The UniversalSQL driver of Invantive Cloud now makes it possible to real-time access Exact Online from JDBC such as using SquirrelSQL.
Perform the following steps to access Exact Online from JDBC:
Prepare
Execute steps 1..24 on Connect Power BI to Exact Online
Connect
Start SquirrelSQL and create an alias as shown below:
The magic is in:
- URL:
jdbc:sqlserver://invantive-exact-online.database.invantive.comwhere you place the SQL Server host name after// - User Name: specify the Invantive Cloud user name
- Password: specify the Invantive Cloud password
Press the “Connect” button.
Run query
Execute some Exact Online queries such as:
Documentation
The full data model of Exact Online is given on:
A graphical entity relationship diagram is available at: