Connecting Invantive Cloud to Looker Studio

Questions
,
1

While Invantive Cloud has been successfully connected to Exact Online, I am still trying to understand how to connect Invantive database to Looker Studio directly.

I was told that we could connect it to Google Cloud but I am curious if we could bypass this.

I am not sure how familiar you are with Looker Studio but usually Looker Studio offers connections to these types of databases:

  • MSSQL,
  • MySQL and
  • PostgresSQL.

For starters, which type of database is Invantive?

Secondly, is there an IP or a host name to the database?

To connect Looker Studio to a database, I usually require these information: Host or IP, Database, Username and Password. Now I see that all IP addresses are whitelisted in Invantive. I guess I could replace this with the Looker Studio common IP address, right?

Finally, if this does not work out, I was told there is a possibility to connect Invantive to Google Cloud SQL Server: Connect to SQL Server on Google Cloud.

Nevertheless, this article seems to miss how to connect Invantive Cloud to Google Cloud SQL Server.

Could you please help out asap?

2

Invantive Cloud is an UniversalSQL-database. This is a virtual database, which real-time interprets SQL statements and translates them in operations on the APIs of the supported platforms. The SQL syntax is documented on Invantive UniversalSQL Grammar 23.0. The Exact Online datamodel is described in SQL-stuurprogramma voor Exact Online API - Exact Online API Data Model.

An Invantive Cloud-database is typically accessed using the OData4 bridge named Bridge Online (see What are the critical points for implementing Power BI? as a good starting page on the most common questions and solutions).

For use with Google Looker Studio it is recommended to copy the data to a SQL Server, PostgreSQL or MySQL database using statements as illustrated in Elementary Data Replication Module between Exact Online and Azure SQL Server.

Alternative approaches are also possible, for instance using an ETL tool accessing the OData4 bridge.

3

This question was automatically closed after at least 1 week of inactivity after a possible solution was provided. The last answer given has been marked as a solution.

Please ask a new question via a separate topic if the problem occurs again. Please include a link to this topic in the new question by pasting its URL into the text.

4

Dit topic is 3 dagen na het laatste antwoord automatisch gesloten. Nieuwe antwoorden zijn niet meer toegestaan.