CData Software - Knowledge Base



Recent Exact Online Articles

Bidirectional Access to Exact Online from FileMaker Pro

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).

Use pandas to Visualize Exact Online in Python

The CData Software Python Connector for Exact Online enables you use pandas and other modules to analyze and visualize live Exact Online in Python.

Feed Exact Online into FineReport

How to set Exact Online as a JDBC data source in FineReport.

Use the CData Software ODBC Driver for Exact Online in SAS for Real-Time Reporting and Analytics

Connect to real-time Exact Online in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Exact Online.