Enable everyone in your organization to access their data in the cloud — no code required.
Learn More →CData Software - Knowledge Base
Recent Exact Online Articles
Use the MySQL Remoting feature of the JDBC driver to integrate Exact Online in Filemaker Pro for Mac or Windows.
Connect to Exact Online as a Linked Server
Use the SQL Gateway and the ODBC Driver to set up a linked server for Exact Online.
PowerShell Scripting to Replicate Exact Online to MySQL
Write a simple PowerShell script to replicate Exact Online to a MySQL database.
View Reports on Real-Time Exact Online in Power BI Report Server
Use the CData ODBC Driver for Exact Online to visualize Exact Online in Power BI Desktop and then publish them to Power BI Report Server.
Access Exact Online from MySQL in Amazon QuickSight
Connect to Exact Online and build visualizations of Exact Online using a MySQL Connection in Amazon QuickSight.
Automated Continuous Exact Online Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Exact Online replication to IBM DB2.
Using Microsoft Query in Excel to Connect to Exact Online
This article uses the CData ODBC driver for Exact Online to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
Use the CData Software JDBC Driver for Exact Online in MicroStrategy
Connect to Exact Online in MicroStrategy Developer using the CData Software JDBC Driver for Exact Online.
Publish Reports with Exact Online in Crystal Reports
Use the Report Wizard to design a report based on up-to-date Exact Online.
Query Exact Online as a MySQL Database in Node.js
Execute MySQL queries against Exact Online from Node.js.
Import and Visualize Exact Online in Power View
Create data visualizations based on Exact Online in Excel.
Automated Continuous Exact Online Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Exact Online replication to delimited files (CSV/TSV).