CData Software - Knowledge Base



Recent Exact Online Articles

Create Exact Online Dataflows on PowerBI.com

Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.

Access Live Exact Online in AWS Lambda

Connect to live Exact Online in AWS Lambda using the CData JDBC Driver.

Creating Exact Online-Connected Applications in Unqork

You can use CData Connect Cloud to feed Exact Online to Unqork and build custom business apps.

Access Exact Online from MySQL in HeidiSQL

Use CData ODBC Driver and SQL Gateway to connect and query live Exact Online from HeidiSQL.

Use the CData SSIS Components to Insert New or Update Existing Exact Online Records from SQL Server

Easily push SQL Server data to Exact Online using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Exact Online or update existing records with data from a SQL Server database.

Connect to Live Exact Online in MicroStrategy through CData Connect Cloud

Create a live connection to Exact Online in CData Connect Cloud and connect to your Exact Online from MicroStrategy.

How to integrate Metabase with Exact Online

Use CData Connect Cloud to connect to live Exact Online and create an interactive dashboard in Metabase from Exact Online.

Work with Live Exact Online in Power Query

Use CData Connect Cloud to connect to Exact Online and work with live Exact Online in Microsoft Power Query.

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.

Connect to Exact Online through External Services in Salesforce

Use CData Connect Cloud to securely provide OData feeds of Exact Online to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Exact Online objects that you can access from apps and the dashboard.

Connect to Exact Online as a SQL Server Linked Server

Use CData Connect Cloud to create a linked server for live Exact Online.

Connect to Exact Online in JRuby

Create a simple JRuby app with access to live Exact Online.

Exact Online Reporting and Star Schemas in OBIEE

Create a star schema that shows perspectives on Exact Online facts in real time.

Connect to Exact Online from PowerBuilder

This article demonstrates how to use the CData ODBC Driver for Exact Online to connect to Exact Online and execute queries in PowerBuilder.

Integrate with Exact Online using Apache Camel2

Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Exact Online to a JSON file on disk.

Access Exact Online in Mule Applications Using the CData JDBC Driver

Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Exact Online.

How to Use a Microsoft Access Database to Update Exact Online in Real Time

Update Exact Online data by creating a linked table in Microsoft Access with the CData Exact Online ODBC Driver.

Visualize Exact Online in Tableau

The CData ODBC driver for Exact Online enables you integrate Exact Online into Tableau dashboards.

Connect to Exact Online from Filemaker Pro (Mac)

Use CData Connect Cloud to connect to and query live Exact Online from Filemaker Pro on Mac.

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.

Model Exact Online Using Azure Analysis Services

Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Exact Online, enabling the direct import of real-time Exact Online.

DataBind Wijmo Grid to Exact Online

Provide real-time Exact Online to interactive controls.

How to create an RPA flow for Exact Online in UiPath Studio

Use the Exact Online ODBC Driver to create workflows that access real-time Exact Online without any coding.

Integrating Exact Online in Talend Cloud Data Management Platform

Connect Exact Online with Talend Cloud Data Management Platform using the [product_name].

Automated Continuous Exact Online Replication to Amazon S3

Use CData Sync for automated, continuous, customizable Exact Online replication to Amazon S3.

Build Exact Online-Connected Web Apps in Servoy

Use Servoy Developer to easily connect to Exact Online and build web apps with connectivity to live Exact Online.

Back Up Exact Online to SQL Server through SSIS

Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Exact Online. In this article, we will employ an SSIS workflow to populate a database with Exact Online data.

Enable the Exact Online JDBC Driver in KNIME

Use standard data access components in KNIME to create charts and reports with Exact Online.

Natively Connect to Exact Online in PHP

The CData ODBC driver for Exact Online enables you to create PHP applications with connectivity to Exact Online. Leverage the native support for ODBC in PHP.

ETL Exact Online in Oracle Data Integrator

This article shows how to transfer Exact Online into a data warehouse using Oracle Data Integrator.

Use the CData Software JDBC Driver for Exact Online in MicroStrategy Web

Connect to Exact Online in MicroStrategy Web using the CData Software JDBC Driver for Exact Online.

Connect to and Query Exact Online in QlikView over ODBC

Create data visualizations with Exact Online in QlikView.

Use Biml to Build SSIS Tasks to Replicate Exact Online to SQL Server

Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Exact Online to SQL Server.

Working with Exact Online in LINQPad

Execute LINQ queries to Exact Online in LINQPad.

Design BIRT Reports on Exact Online

Provide current Exact Online to your embedded analytics.

Automated Continuous Exact Online Replication to PostgreSQL

Use CData Sync for automated, continuous, customizable Exact Online replication to PostgreSQL.

Build a Simple VCL Application for Exact Online

How to build a simple VCL Application to view Exact Online in RAD Studio using the CData ODBC Driver for Exact Online.

Write a Simple Go Application to work with Exact Online on Linux

Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Exact Online.

Create Data Visualizations Based On Exact Online in Mode

Use CData Connect Cloud to connect to Exact Online from Mode and build visualizations using live

A PostgreSQL Interface for Exact Online

Use the Remoting features of the Exact Online ODBC Driver to create a PostgreSQL entry-point for data access.

Automate Exact Online Integration Tasks from PowerShell

Are you in search of a quick and easy way to access Exact Online from PowerShell? This article demonstrates how to utilize the Exact Online Cmdlets for tasks like connecting to Exact Online, automating operations, downloading data, and more.

Operational Reporting on Exact Online from Spotfire Server

Create and share Spotfire data visualizations with real-time connectivity to remote Exact Online.

How to Access Exact Online Using Entity Framework

This article shows how to access Exact Online using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

Exact Online Cloud Connectivity

Explore a compilation of guides and tutorials demonstrating how to establish connections to Exact Online through CData Connect Cloud using different applications and tools.

Automated Continuous Exact Online Replication to Snowflake

Use CData Sync for automated, continuous, customizable Exact Online replication to Snowflake.

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.

How to connect to Exact Online with Squirrel SQL client

Connect to Exact Online and execute queries in the Squirrel SQL Client.

How to Work with Exact Online in AWS Glue Jobs Using JDBC

Connect to Exact Online from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

Validate Exact Online with QuerySurge

Access and validate Exact Online in QuerySurge using the CData JDBC Driver.

Load Exact Online to a Database Using Embulk

Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Exact Online to a database.

Provide OData Services of Exact Online from a WCF Application

In this article, we will demonstrate the process of generating an OData feed for Exact Online by developing a WCF Service Application.

How to Work with Exact Online in ETL Validator JDBC

Connect to Exact Online from ETL Validator jobs using the CData Software JDBC Driver.

Stream Exact Online into Apache Kafka Topics

Access and stream Exact Online in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

Automated Continuous Exact Online Replication to Vertica

Use CData Sync for automated, continuous, customizable Exact Online replication to Vertica.

Analyze Exact Online in Cognos Analytics

Use CData Connect Cloud to connect to Exact Online from Cognos Analytics and analyze live Exact Online.

Visualize Exact Online in Tableau Desktop (through CData Connect)

Create a virtual SQL Server database for Exact Online in CData Software Connect (or Connect Server) and build visualizations from live Exact Online in Tableau Desktop.

Access Live Exact Online in AWS Lambda (with IntelliJ IDEA)

Connect to live Exact Online in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

Automated Continuous Exact Online Replication to Apache Kafka

Use CData Sync for automated, continuous, customizable Exact Online replication to Apache Kafka.

A PostgreSQL Interface for Exact Online

Use the Remoting features of the Exact Online JDBC Driver to create a PostgreSQL entry-point for data access.

Integrate Exact Online in Your Informatica Cloud Instance

Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Exact Online from Informatica Cloud.

Exact Online Reporting in OBIEE with the Exact Online JDBC Driver

Deploy the Exact Online JDBC driver on OBIEE to provide real-time reporting across the enterprise.

Build Exact Online-Connected Apps in Choreo

Use CData Connect Cloud to connect to Exact Online from Choreo and build custom apps using live Exact Online.

Replicate Multiple Exact Online Accounts

Replicate multiple Exact Online accounts to one or many databases.

Automated Continuous Exact Online Replication to Apache Cassandra

Use CData Sync for automated, continuous, customizable Exact Online replication to Apache Cassandra.

Automated Continuous Exact Online Replication to Azure SQL

Use CData Sync for automated, continuous, customizable Exact Online replication to Azure SQL.

Automated Continuous Exact Online Replication to MySQL

Use CData Sync for automated, continuous, customizable Exact Online replication to MySQL.

How to Connect DBeaver to Exact Online via a JDBC Driver

Manage Exact Online with visual tools in DBeaver like the query browser.

How to connect to Exact Online from MS Excel on Mac OS X

Create a Data Source Name in iODBC with the CData ODBC Driver for Exact Online and work with Exact Online in Microsoft Excel on Mac OS X.

Build Semantic Layer Views for Exact Online in APOS Live Data Gateway

Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Exact Online.

Author and Share Power BI Reports on Real-Time Exact Online

Use the CData ODBC Driver for Exact Online to visualize Exact Online in Power BI Desktop and then upload to the Power BI service.

Use Dash to Build to Web Apps on Exact Online

Create Python applications that use pandas and Dash to build Exact Online-connected web apps.

Connect to Exact Online in NetBeans

Connect to Exact Online in NetBeans with the data source configuration wizard.

Build Pipelines with Live Exact Online in Google Cloud Data Fusion (via CData Connect Cloud)

Use CData Connect Cloud to connect to Exact Online from Google Cloud Data Fusion, enabling the integration of live Exact Online into the building and management of effective data pipelines.

Integrate Exact Online with External Services using SnapLogic

Use CData JDBC drivers in SnapLogic to integrate Exact Online with External Services.

Rapidly Develop Exact Online-Driven Apps with Active Query Builder

Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.

Configure the CData JDBC Driver for Exact Online in a Connection Pool in Tomcat

Connect to Exact Online from a connection pool in Tomcat.

Publish Reports with Exact Online in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Exact Online.

Automated Continuous Exact Online Replication to MongoDB

Use CData Sync for automated, continuous, customizable Exact Online replication to MongoDB.

Edit and Search External Exact Online Objects in Salesforce Connect

Use CData Connect Cloud to securely provide OData feeds of Exact Online to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Exact Online objects that you can access from apps and the dashboard.

How to Connect to & Open Exact Online in Microsoft Excel

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.

Create an SAP BusinessObjects Universe on the CData ODBC Driver for Exact Online

Provide connectivity to Exact Online through an SAP BusinessObjects universe.

How to Create Power BI Visual Reports with Real-Time Exact Online

Use CData Power BI Connectors to visualize Exact Online in Power BI.

Perform Batch Operations with Exact Online in Apache NiFi

Connect to Exact Online and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

How to connect to Exact Online in DBVisualizer

Integrate Exact Online with visual data analysis tools and data connection wizards in DBVisualizer

Build an OLAP Cube in SSAS from Exact Online

Establish a connection to Exact Online data from SQL Server Analysis Services, and use the Exact Online Data Provider to build OLAP cubes for use in analytics and reporting.

Access Live Exact Online in Coginiti Pro

Connect to and query live Exact Online from the GUI in the Coginiti Pro: SQL Analytics Tool.

Replicate Exact Online to Multiple Databases

Replicate Exact Online to disparate databases with a single configuration.

How to create Exact Online federated tables in MySQL

Use the SQL Gateway and the ODBC Driver to set up federated tables for Exact Online in MySQL .

Add Exact Online to Informatica Enterprise Data Catalog

Use the CData Software JDBC Driver for Exact Online with the Informatica Enterprise Data Catalog to classify and organize data.

How to connect PolyBase to Exact Online

Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Exact Online.

Integrate with Exact Online in SnapLogic

Use CData Connect Cloud to connect to and integrate with live Exact Online in SnapLogic.

Create Exact Online-Connected Nintex Workflows

Use CData Connect Cloud to connect to Exact Online from Nintex Workflow Cloud and build custom workflows using live Exact Online.

Connect to Exact Online from a Connection Pool in WebLogic

Use the CData JDBC Driver for Exact Online to connect to Exact Online from Web applications running on WebLogic.

How to Connect the Power BI Service to Exact Online: Complete Guide

Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.

Object-Relational Mapping (ORM) with Exact Online Entities in Java

Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Exact Online into a Java-based ORM framework, Hibernate.

Connect to Exact Online in the Denodo Platform

Use CData driver technologies to create a virtual data source for Exact Online in the Denodo Virtual DataPort Administrator.

Build Visualizations of Exact Online in Birst

Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Exact Online in Birst.

Query Exact Online through ODBC in Node.js

Use node-odbc to execute SQL queries against Exact Online from Node.js.

DataBind Controls to Exact Online in C++Builder

DataBind to Exact Online in C++Builder with standard components and controls.

Extract, Transform, and Load Exact Online in Informatica PowerCenter

Create a simple Workflow for Exact Online in Informatica PowerCenter.

Use the CData Software ODBC Driver for Exact Online in MicroStrategy Web

Connect to Exact Online in MicroStrategy Web using the CData Software ODBC Driver for Exact Online.

Use CData Connect Cloud to Access Exact Online in Microsoft Power Pivot

Use CData Connect Cloud to connect to live Exact Online in the Power Pivot business intelligence tool.

DataBind Charts to Exact Online

Use the standard ADO.NET procedures for databinding to provide bidirectional access to Exact Online from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.

Automated Continuous Exact Online Replication to Databricks

Use CData Sync for automated, continuous, customizable Exact Online replication to Databricks.

How to Import Exact Online into SQL Server using SSIS

Easily back up Exact Online to SQL Server using the SSIS components for Exact Online.

Connect to Exact Online as an External Data Source using PolyBase

Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live Exact Online.

Deploy the ADO.NET Provider for Exact Online on an SSRS Report Server

Connect to Exact Online from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

Connect to Exact Online in RunMyProcess through Connect Cloud

Use CData Connect Cloud to create on OData API for Exact Online and connect to Exact Online in Akorbi Digital RunMyProcess.

Visualize Live Exact Online of Power BI Report Builder in Power BI Service

Use CData Power BI Connectors to connect to live Exact Online using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

Integrate Live Exact Online into Amazon SageMaker Canvas with RDS

Use CData Connect Cloud to connect to Exact Online from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Exact Online.

Visualize Exact Online in TIBCO Spotfire through ODBC

The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Exact Online into TIBCO Spotfire.

Build Semantic Layer Views for Exact Online in APOS Live Data Gateway

Use the CData Connector for Exact Online in APOS Live Data Gateway to build Semantic Layer Views for Exact Online.

Query Exact Online as a MySQL Database in Node.js

Execute MySQL queries against Exact Online from Node.js.

Import Exact Online Using Azure Data Factory

Use CData Connect Cloud to connect to Exact Online from Azure Data Factory and import live Exact Online.

Build Exact Online-Connected Apps in Bubble

Use CData Connect Cloud to create an OData feed for Exact Online and create custom apps in Bubble.

Analyze Exact Online in Looker

Use CData Connect Cloud to connect to Exact Online from Looker and build custom apps using live Exact Online.

Automate Exact Online Replication to Couchbase

Use CData Sync to Customize and automate Exact Online replication to Couchbase.

Connect to Exact Online from a Connection Pool in JBoss

Integrate Exact Online into Java servlets: Use the Management Console in JBoss to install the Exact Online JDBC Driver.

Analyze Exact Online in R

Create data visualizations and use high-performance statistical functions to analyze Exact Online in Microsoft R Open.

Access Exact Online as a Remote Oracle Database

Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Exact Online from your Oracle system.

How to update Exact Online from Excel

This article explains how to transfer data from Excel to Exact Online using the Excel Add-In for Exact Online.

Create Informatica Mappings From/To an ODBC Data Source for Exact Online

Create an ODBC connection to Exact Online in Informatica and browse and transfer Exact Online.

A PostgreSQL Interface for Exact Online

Use the SQL Gateway and Exact Online ODBC Driver to create a PostgreSQL entry-point for data access.

Analyze Exact Online in R

Use standard R functions and the development environment of your choice to analyze Exact Online with the CData JDBC Driver for Exact Online.

Build Exact Online Visualizations in Tableau Cloud

Use CData Connect Cloud to connect to live Exact Online and build visualizations in Tableau Cloud.

Analyze Exact Online in SAP Analytics Cloud

Use CData Connect Cloud to create an OData API on top of Exact Online and visualize Exact Online in SAP Analytics Cloud.

DataBind Controls to Exact Online in Delphi

DataBind to Exact Online in Delphi with standard data access components and controls.

Work with Exact Online in FoxPro

Load Exact Online into a FoxPro database. This article includes full code and a walk-through of the process.

Create a Data Access Object for Exact Online using JDBI

A brief overview of creating a SQL Object API for Exact Online in JDBI.

How to publish and share Exact Online dashboards with Tableau Server

The CData ODBC driver for Exact Online enables you integrate Exact Online into Tableau dashboards.

Connect to Exact Online in Aqua Data Studio

Access Exact Online from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

Import Exact Online into the Power BI Service for Visualizations

Use CData Connect Cloud to connect to Exact Online and provide access to live Exact Online for custom reports in the Power BI Service.

How to work with Exact Online in Apache Spark using SQL

Access and process Exact Online in Apache Spark using the CData Software JDBC Driver.

Create Exact Online-Connected Business Apps in AppSheet

Connect to Exact Online via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to Exact Online.

Integrate Exact Online into Power Automate Desktop using CData Connect

CData Connect for Exact Online enables you to integrate Exact Online into workflows built using Microsoft Power Automate Desktop.

Replicate Exact Online to Multiple Databases

Replicate Exact Online to disparate databases with a point-and-click configuration.

Automate Exact Online Replication to Azure Synapse

Use CData Sync to customize and automate Exact Online replication to Azure Synapse.

How to integrate Exact Online with Apache Airflow

Access and process Exact Online in Apache Airflow using the CData JDBC Driver.

Integrate with Live Exact Online in MuleSoft (via CData Connect Cloud)

Use CData Connect Cloud to connect to Exact Online from the MuleSoft Anypoint Platform to integrate live Exact Online into custom reports and dashboards.

Visualize Exact Online in TIBCO Spotfire through OData

Integrate Exact Online into dashboards in TIBCO Spotfire.

Automated Continuous Exact Online Replication to SQL Server

Use CData Sync for automated, continuous, customizable Exact Online replication to SQL Server.

Replicate Exact Online from PowerShell

Write a quick PowerShell script to query Exact Online. Use connectivity to the live data to replicate Exact Online to SQL Server.

Create Exact Online-Connected Enterprise Applications in OutSystems

Use CData Connect Cloud to connect to Exact Online from OutSystems and build custom enterprise apps using live Exact Online.

How to Access Live Exact Online in Power Automate Desktop via ODBC

The CData ODBC Driver for Exact Online enables you to integrate Exact Online into workflows built using Microsoft Power Automate Desktop.

Create Data Visualizations in Cognos BI with Exact Online

Access Exact Online as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

Automated Continuous Exact Online Replication to IBM DB2

Use CData Sync for automated, continuous, customizable Exact Online replication to IBM DB2.

Access Live Exact Online in Excel (Desktop)

Use CData Connect Cloud to gain access to live Exact Online from your Excel spreadsheets.

Create Exact Online Dashboards in Bold BI

Use CData Software Connect Server to create a virtual SQL Server Database for Exact Online to build custom dashboards in Bold BI.

Create SSAS Tabular Models from Exact Online

How to build a SQL Server Analysis Service Tabular Model from Exact Online using CData drivers.

How to Build Dynamic React Apps with Exact Online

Use the CData Connect and React to Build Dynamic Web Apps with Live Exact Online .

Connect to Exact Online from Asprova with CData Software ODBC Driver for Exact Online

This article shows how to connect faster to Exact Online data from Asprova.

How to use SQLAlchemy ORM to access Exact Online in Python

Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Exact Online.

Connect to Exact Online in CloverDX (formerly CloverETL)

Transfer Exact Online using the visual workflow in the CloverDX data integration tool.

Connect to Exact Online in Google Apps Script

Use CData Connect Cloud to access Exact Online in Google Apps Script.

Query Exact Online in MySQL Workbench

Create a virtual MySQL database for Exact Online in CData Software Connect (or Connect Server) and work with live Exact Online in MySQL Workbench.

Use the CData ODBC Driver for Exact Online in Microsoft Power Query

You can use the CData Exact Online ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Exact Online into Microsoft Power Query.

Connect to and Visualize Live Exact Online in Tableau Prep

Use CData Tableau Connectors and Tableau Prep Builder to visualize live Exact Online.

Using the CData Software ODBC Driver for Exact Online in PyCharm

Connect to Exact Online as an ODBC data source in PyCharm using the CData Software ODBC Driver for Exact Online.

Build Exact Online-Connected Apps in Mendix

Use CData Connect Cloud to create an OData feed for Exact Online and create custom apps in Mendix.

Connect to Exact Online from Crystal Reports

Use CData Connect Cloud to connect to and report on live Exact Online from Crystal Reports.

Prepare, Blend, and Analyze Exact Online in Alteryx Designer

Build workflows to access live Exact Online for self-service data analytics.

Automate Exact Online Replication to SAP HANA

Use CData Sync to customize and automate Exact Online replication to SAP HANA.

How to create Visio diagrams from Exact Online

Automatically update Exact Online with the changes you make to Visio master shapes.

Create Exact Online-Connected Visualizations in Klipfolio

Use CData Connect Cloud to connect to Exact Online from Klipfolio and build custom visualizations using live Exact Online.

Connect to Live Exact Online in PostGresSQL Interface through CData Connect Cloud

Create a live connection to Exact Online in CData Connect Cloud and connect to your Exact Online from PostgreSQL.

Create Datasets from Exact Online in Domo Workbench and Build Visualizations of Exact Online in Domo

Use the CData Software ODBC Driver for Exact Online to create datasets from Exact Online in Domo Workbench and then build visualizations in the Domo service.

PowerShell Scripting to Replicate Exact Online to MySQL

Write a simple PowerShell script to replicate Exact Online to a MySQL database.

Connect to Exact Online in Airbyte ELT Pipelines

Use CData Connect Cloud to build ELT pipelines for Exact Online in Airbyte.

Analyze Exact Online in Infragistics Reveal

Use CData Connect Cloud to create on OData API on top of Exact Online and visualize live Exact Online in Infragistics Reveal.

Visualize Exact Online in Sisense

Create an ElastiCube in Sisense app with access to Exact Online.

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.

How to Visualize Exact Online Data in Python with pandas

Use pandas and other modules to analyze and visualize live Exact Online in Python.

Connect to Exact Online from PowerBuilder

This article demonstrates how to access Exact Online from PowerBuilder using the Exact Online JDBC Driver.

Export Data from SQL Server to Exact Online through SSIS

Easily push SQL Server data to Exact Online using the CData SSIS Tasks for Exact Online.

Visualize Exact Online in TIBCO Spotfire through ADO.NET

Integrate Exact Online into dashboards in TIBCO Spotfire.

Use the CData ODBC Driver for Exact Online in SAS JMP

You can use the CData ODBC Driver to integrate Exact Online into the statistical analysis tools available in SAS JMP. This article shows how to use Exact Online in the Graph Builder and Query Builder.

Prepare, Blend, and Analyze Exact Online in Alteryx Designer

Build workflows to access live Exact Online for self-service data analytics.

Access Live Exact Online in TIBCO Data Virtualization

Use the CData Software TIBCO DV Adapter for Exact Online to create a Exact Online source in TIBCO Data Virtualization Studio and gain access to live Exact Online from your TDV Server.

Automated Continuous Exact Online Replication to SQLite

Use CData Sync for automated, continuous, customizable Exact Online replication to SQLite.

How to Build an ETL App for Exact Online in Python with CData

Create ETL applications and real-time data pipelines for Exact Online in Python with petl.

Visualize Live Exact Online in Tableau

Use CData Tableau Connectors and Tableau Desktop to visualize live Exact Online.

Connect to Exact Online from HeidiSQL

Use CData Connect Cloud to connect to and query live Exact Online from HeidiSQL.

Create Apps from Exact Online in Qlik Sense Cloud

Use CData Connect Cloud to connect to Exact Online and build apps from live Exact Online in Qlik Sense Cloud.

Query Exact Online as a SQL Server Database in Node.js

Execute SQL Server queries against Exact Online from Node.js.

Create Exact Online Reports on JasperReports Server

Deploy the CData JDBC Driver on JasperReports Server to provide real-time Exact Online data access from reports, embedded analytics, and more.

Automated Continuous Exact Online Replication to Microsoft Access

Use CData Sync for automated, continuous, customizable Exact Online replication to Microsoft Access.

Automated Continuous Exact Online Replication to AlloyDB

Use CData Sync for automated, continuous, customizable Exact Online replication to AlloyDB.

Automated Continuous Exact Online Replication to Local Delimited Files

Use CData Sync for automated, continuous, customizable Exact Online replication to delimited files (CSV/TSV).

Automated Continuous Exact Online Replication to Amazon Redshift

Use CData Sync for automated, continuous, customizable Exact Online replication to Amazon Redshift.

Import Real-Time Exact Online in ColdFusion to Build Applications

Use CData JDBC drivers to import and use Exact Online in ColdFusion.

Query Exact Online in ColdFusion

Write standard ColdFusion data access code to connect to Exact Online.

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.

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.

How to connect Amazon QuickSight to Exact Online

Create a connection to Exact Online in CData Connect Cloud and insert Exact Online into Amazon QuickSight SPICE to build interactive dashboards.

Connect to Exact Online in HULFT Integrate

Connect to Exact Online as a JDBC data source in HULFT Integrate

Replicate Multiple Exact Online Accounts

Replicate multiple Exact Online accounts to one or many databases.

Build Dashboards with Exact Online in Dundas BI

Create dynamic dashboards and perform analytics based on Exact Online in Dundas BI.

Viewing Exact Online in RAD Studio Data Explorer

How to view Exact Online in RAD Studio Data Explorer using the CData ODBC Driver for Exact Online.

Automated Continuous Exact Online Replication to SingleStore

Use CData Sync for automated, continuous, customizable Exact Online replication to SingleStore.

Access Exact Online from MySQL in PHP

Connect to Exact Online through the standard MySQL libraries in PHP.

How to connect and process Exact Online from Azure Databricks

Use CData, Azure, and Databricks to perform data engineering and data science on live Exact Online

How to connect to Exact Online from IntelliJ

Integrate connectivity to Exact Online with wizards in IntelliJ.

Connect to Exact Online from AWS Glue

Use CData Connect Cloud to gain access to live Exact Online from your AWS Glue jobs.

Access Live Exact Online in Excel 365 Online (Excel for the web)

Connect to Exact Online from Excel 365 Online (Excel for the web) with CData Connect Cloud.

Visualize Live Exact Online in the Power BI Service

Use CData Connect Cloud to connect to live Exact Online and create custom reports in the Power BI Service through the On-Premises Gateway.

Access Live Exact Online in Google Sheets

Use CData Connect Cloud to gain access to live Exact Online from your Google Sheets.

Connect to Exact Online in RapidMiner

Integrate Exact Online with standard components and data source configuration wizards in RapidMiner Studio.

Establish a Live Connection with Exact Online using Tableau Bridge

The CData ODBC Driver for Exact Online enables you to integrate live Exact Online into Tableau Cloud dashboards using the Tableau Bridge.

Build Exact Online-Connected Visualizations in datapine

Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Exact Online.

Create an SAP BusinessObjects Universe on the CData JDBC Driver for Exact Online

Provide connectivity to Exact Online through an SAP BusinessObjects universe.

Replicate Exact Online for Use in Salesforce Connect

Replicate Exact Online to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

Connect to Exact Online in DBeaver

Use the CData ODBC Driver to connect to Exact Online in DBeaver.

Access Exact Online in PHP through Connect Server

Connect to Exact Online through the standard SQL Server libraries in PHP.

Publish Crystal Reports on Exact Online

Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Exact Online.

Use the CData Software ODBC Driver for Exact Online in MicroStrategy Desktop

Connect to Exact Online in MicroStrategy Desktop using the CData Software ODBC Driver for Exact Online.

Publish Exact Online-Connected Dashboards in Tableau Server

Use CData Tableau Connectors and Tableau Server to visualize live Exact Online.

Process & Analyze Exact Online in Databricks (AWS)

Use CData, AWS, and Databricks to perform data engineering and data science on live Exact Online .

Use the CData ODBC Driver for Exact Online from SharePoint Excel Services

This article demonstrates how to use the CData ODBC Driver for Exact Online to connect to Exact Online from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Exact Online in Excel.

Automated Continuous Exact Online Replication to Google Cloud SQL

Use CData Sync for automated, continuous, customizable Exact Online replication to Google Cloud SQL.

How to Connect to Exact Online in Using Python: 6 Steps

Create Python applications on Linux/UNIX machines with connectivity to Exact Online. Leverage the pyodbc module for ODBC in Python.

Analyze Exact Online with Power Pivot

This article walks you through the process of using the CData ODBC Driver for Exact Online from Power Pivot. You will use the Table Import Wizard to load Exact Online. You can visually build the import query or use any SQL supported by the driver.

Import Exact Online into FileMaker Pro

Create reports that integrate Exact Online in Filemaker Pro.

Connect to Exact Online in Ruby

Connect to Exact Online in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

Query, Visualize, and Share live Exact Online in Redash

Use CData Connect Cloud to connect to live Exact Online in Redash for querying, visualizing, and sharing.

Import and Visualize Exact Online in Power View

Create data visualizations based on Exact Online in Excel.

Use the CData Software JDBC Driver for Exact Online in MicroStrategy Desktop

Connect to Exact Online in MicroStrategy Desktop using the CData Software JDBC Driver for Exact Online.

Integrate Exact Online in the Pentaho Report Designer

Publish reports based on Exact Online in the Pentaho BI tool.

Natively Connect to Exact Online in PHP

Create PHP applications on Linux/UNIX machines with connectivity to Exact Online. Leverage the native support for ODBC in PHP.

Integrate Exact Online into Automated Tasks with Power Automate

Use CData Connect Cloud to connect to Exact Online and integrate live Exact Online into your Power Automate tasks.

Automated Exact Online Replication to Teradata

Use CData Sync to Customize and automate Exact Online replication to Teradata.

How to Query Exact Online in MySQL Workbench

Execute MySQL queries against live Exact Online from MySQL Workbench.

How to import Exact Online into Apache Solr

Use the CData Software JDBC Driver for Exact Online in Data Import Handler and create an automated import of Exact Online to Apache Solr Enterprise Search platform.

Integrate with live Exact Online in Jitterbit

Use CData Connect Cloud to connect to and integrate live Exact Online in Jitterbit.

Create Reports from Exact Online in Looker Studio

Use CData Connect Cloud to gain access to live Exact Online and create custom reports in Looker Studio.

LINQ to Exact Online

LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Exact Online Data Provider.

Connect to Exact Online from a Connection Pool in Jetty

The Exact Online JDBC Driver supports connection pooling: This article shows how to connect faster to Exact Online from Web apps in Jetty.

How to pipe Exact Online to CSV in PowerShell

Use standard PowerShell cmdlets to access Exact Online tables.

How to connect to Exact Online from Spring Boot

Connect to Exact Online in a Spring Boot Application using CData JDBC Exact Online Driver

Connect to Exact Online in as an External Source in Dremio

Use the CData JDBC Driver to connect to Exact Online as an External Source in Dremio.

Using AngularJS to Build Dynamic Web Pages with Exact Online

Use the CData Connect Server to create Exact Online OData feeds and build single-page applications with live Exact Online.

Create Dynamic Exact Online Grids Using the Infragistics XamDataGrid

Learn how you can connect Exact Online to Infragistics XamDataGrid to build dynamic grids.

Import Real-Time Exact Online in ColdFusion to Build Applications

Use CData ODBC drivers to import and use Exact Online in ColdFusion.

Use JayDeBeApi to access Exact Online in Python

Use standard Python scripting and the development environment of your choice to access live Exact Online.

Excel Spreadsheet Automation with the QUERY Formula

Pull data, automate spreadsheets, and more with the QUERY formula.

Bridge Exact Online Connectivity with Apache NiFi

Access and process Exact Online in Apache NiFi using the CData JDBC Driver.

Query Exact Online in DataGrip

Create a Data Source for Exact Online in DataGrip and use SQL to query live Exact Online.

Automate Exact Online Replication to Azure Data Lake

Use CData Sync to customize and automate Exact Online replication to Azure Data Lake.

Build Dashboards with Exact Online in DBxtra

Create dynamic dashboards and perform analytics based on Exact Online in DBxtra.

Automated Continuous Exact Online Replication to Oracle

Use CData Sync for automated, continuous, customizable Exact Online replication to Oracle.

Use the CData Software ODBC Driver for Exact Online in MicroStrategy

Connect to Exact Online in MicroStrategy Developer using the CData Software ODBC Driver for Exact Online.

Connect to Exact Online in Google Apps Script

Use the ODBC Driver for Exact Online and the SQL Gateway to access Exact Online from Google Apps Script.

Manage Exact Online in DBArtisan as a JDBC Source

Use wizards in DBArtisan to create a JDBC data source for Exact Online.

DataBind Exact Online to the DevExpress Data Grid

Use the CData Software ADO.NET Provider for Exact Online with the DevExpress Windows Forms and Web controls to provide Exact Online to a chart.

Build Charts with Exact Online in Clear Analytics

Create dynamic charts and perform analytics based on Exact Online in Clear Analytics.

Feed Exact Online into FineReport

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

Automated Continuous Exact Online Replication to Google BigQuery

Use CData Sync for automated, continuous, customizable Exact Online replication to Google BigQuery.

Visualize Live Exact Online in Power BI (via CData Connect Cloud)

Use the CData Power BI Connector and CData Connect Cloud to integrate live Exact Online into custom reports in Power BI.

Connect to Exact Online from PowerBuilder

This article demonstrates how to access Exact Online from Appeon PowerBuilder using the CData ADO.NET Provider for Exact Online.

Integrate with Exact Online in JReport Designer

Create charts and reports based on Exact Online in JReport Designer.

Publish Exact Online-Connected Dashboards in Tableau Server

Use CData JDBC drivers and Tableau Server to visualize live Exact Online.

Analyze Live Exact Online in SAS Viya

Use CData Connect Cloud to connect to Exact Online from SAS Viya and deploy self-service analytics using live Exact Online.

Build Exact Online-Connected ETL Processes in Google Data Fusion

Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Exact Online.

Integrate Live Exact Online into Custom Business Apps Built in Power Apps

Use CData Connect Cloud to connect to Exact Online and integrate live Exact Online into apps built in Microsoft Power Apps.

Connect to Exact Online in SpagoBI

Create reports featuring live Exact Online in SpagoBI Studio. Host Exact Online reports on SpagoBI Server.

Create Informatica Mappings From/To a JDBC Data Source for Exact Online

Create Exact Online data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

Connect to Exact Online in DBArtisan

Use wizards in DBArtisan to configure Exact Online as a data source.

Build Exact Online-Connected Dashboards Using Zoho Analytics

Use CData Connect Cloud to connect to Exact Online from Zoho Analytics and import live Exact Online.

Create Reports with Exact Online in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Exact Online.

Connect to Exact Online in DigitalSuite Studio through RunMyProcess DSEC

Use Arkobi Digital

Connect to Exact Online in RazorSQL

Connect to Exact Online from wizards and query Exact Online from the GUI in the RazorSQL database management tool.

Visualize Exact Online from Tableau

Use the Tableau Desktop business intelligence tool to connect to Exact Online.

Connect to Exact Online in Jaspersoft Studio

Execute SQL to remote Exact Online in Jaspersoft Studio.

Build MVC Applications with Connectivity to Exact Online

This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Exact Online from an ASP.NET MVC application.

Explore Geographical Relationships in Exact Online with Power Map

Create data visualizations with Exact Online in Power Map.

Create Exact Online Dataflows on PowerBI.com

Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.

Access Live Exact Online in AWS Lambda

Connect to live Exact Online in AWS Lambda using the CData JDBC Driver.

Creating Exact Online-Connected Applications in Unqork

You can use CData Connect Cloud to feed Exact Online to Unqork and build custom business apps.

Access Exact Online from MySQL in HeidiSQL

Use CData ODBC Driver and SQL Gateway to connect and query live Exact Online from HeidiSQL.

Use the CData SSIS Components to Insert New or Update Existing Exact Online Records from SQL Server

Easily push SQL Server data to Exact Online using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Exact Online or update existing records with data from a SQL Server database.

Connect to Live Exact Online in MicroStrategy through CData Connect Cloud

Create a live connection to Exact Online in CData Connect Cloud and connect to your Exact Online from MicroStrategy.

How to integrate Metabase with Exact Online

Use CData Connect Cloud to connect to live Exact Online and create an interactive dashboard in Metabase from Exact Online.

Work with Live Exact Online in Power Query

Use CData Connect Cloud to connect to Exact Online and work with live Exact Online in Microsoft Power Query.

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.

Connect to Exact Online through External Services in Salesforce

Use CData Connect Cloud to securely provide OData feeds of Exact Online to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Exact Online objects that you can access from apps and the dashboard.

Connect to Exact Online as a SQL Server Linked Server

Use CData Connect Cloud to create a linked server for live Exact Online.

Connect to Exact Online in JRuby

Create a simple JRuby app with access to live Exact Online.

Exact Online Reporting and Star Schemas in OBIEE

Create a star schema that shows perspectives on Exact Online facts in real time.

Connect to Exact Online from PowerBuilder

This article demonstrates how to use the CData ODBC Driver for Exact Online to connect to Exact Online and execute queries in PowerBuilder.

Integrate with Exact Online using Apache Camel2

Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Exact Online to a JSON file on disk.

Access Exact Online in Mule Applications Using the CData JDBC Driver

Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Exact Online.

How to Use a Microsoft Access Database to Update Exact Online in Real Time

Update Exact Online data by creating a linked table in Microsoft Access with the CData Exact Online ODBC Driver.

Visualize Exact Online in Tableau

The CData ODBC driver for Exact Online enables you integrate Exact Online into Tableau dashboards.

Connect to Exact Online from Filemaker Pro (Mac)

Use CData Connect Cloud to connect to and query live Exact Online from Filemaker Pro on Mac.

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.

Model Exact Online Using Azure Analysis Services

Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Exact Online, enabling the direct import of real-time Exact Online.

DataBind Wijmo Grid to Exact Online

Provide real-time Exact Online to interactive controls.

How to create an RPA flow for Exact Online in UiPath Studio

Use the Exact Online ODBC Driver to create workflows that access real-time Exact Online without any coding.

Integrating Exact Online in Talend Cloud Data Management Platform

Connect Exact Online with Talend Cloud Data Management Platform using the [product_name].

Automated Continuous Exact Online Replication to Amazon S3

Use CData Sync for automated, continuous, customizable Exact Online replication to Amazon S3.

Build Exact Online-Connected Web Apps in Servoy

Use Servoy Developer to easily connect to Exact Online and build web apps with connectivity to live Exact Online.

Back Up Exact Online to SQL Server through SSIS

Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Exact Online. In this article, we will employ an SSIS workflow to populate a database with Exact Online data.

Enable the Exact Online JDBC Driver in KNIME

Use standard data access components in KNIME to create charts and reports with Exact Online.

Natively Connect to Exact Online in PHP

The CData ODBC driver for Exact Online enables you to create PHP applications with connectivity to Exact Online. Leverage the native support for ODBC in PHP.

ETL Exact Online in Oracle Data Integrator

This article shows how to transfer Exact Online into a data warehouse using Oracle Data Integrator.

Use the CData Software JDBC Driver for Exact Online in MicroStrategy Web

Connect to Exact Online in MicroStrategy Web using the CData Software JDBC Driver for Exact Online.

Connect to and Query Exact Online in QlikView over ODBC

Create data visualizations with Exact Online in QlikView.

Use Biml to Build SSIS Tasks to Replicate Exact Online to SQL Server

Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Exact Online to SQL Server.

Working with Exact Online in LINQPad

Execute LINQ queries to Exact Online in LINQPad.

Design BIRT Reports on Exact Online

Provide current Exact Online to your embedded analytics.

Automated Continuous Exact Online Replication to PostgreSQL

Use CData Sync for automated, continuous, customizable Exact Online replication to PostgreSQL.

Build a Simple VCL Application for Exact Online

How to build a simple VCL Application to view Exact Online in RAD Studio using the CData ODBC Driver for Exact Online.

Write a Simple Go Application to work with Exact Online on Linux

Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Exact Online.

Create Data Visualizations Based On Exact Online in Mode

Use CData Connect Cloud to connect to Exact Online from Mode and build visualizations using live

A PostgreSQL Interface for Exact Online

Use the Remoting features of the Exact Online ODBC Driver to create a PostgreSQL entry-point for data access.

Automate Exact Online Integration Tasks from PowerShell

Are you in search of a quick and easy way to access Exact Online from PowerShell? This article demonstrates how to utilize the Exact Online Cmdlets for tasks like connecting to Exact Online, automating operations, downloading data, and more.

Operational Reporting on Exact Online from Spotfire Server

Create and share Spotfire data visualizations with real-time connectivity to remote Exact Online.

How to Access Exact Online Using Entity Framework

This article shows how to access Exact Online using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

Exact Online Cloud Connectivity

Explore a compilation of guides and tutorials demonstrating how to establish connections to Exact Online through CData Connect Cloud using different applications and tools.

Automated Continuous Exact Online Replication to Snowflake

Use CData Sync for automated, continuous, customizable Exact Online replication to Snowflake.

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.

How to connect to Exact Online with Squirrel SQL client

Connect to Exact Online and execute queries in the Squirrel SQL Client.

How to Work with Exact Online in AWS Glue Jobs Using JDBC

Connect to Exact Online from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

Validate Exact Online with QuerySurge

Access and validate Exact Online in QuerySurge using the CData JDBC Driver.

Load Exact Online to a Database Using Embulk

Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Exact Online to a database.

Provide OData Services of Exact Online from a WCF Application

In this article, we will demonstrate the process of generating an OData feed for Exact Online by developing a WCF Service Application.

How to Work with Exact Online in ETL Validator JDBC

Connect to Exact Online from ETL Validator jobs using the CData Software JDBC Driver.

Stream Exact Online into Apache Kafka Topics

Access and stream Exact Online in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

Automated Continuous Exact Online Replication to Vertica

Use CData Sync for automated, continuous, customizable Exact Online replication to Vertica.

Analyze Exact Online in Cognos Analytics

Use CData Connect Cloud to connect to Exact Online from Cognos Analytics and analyze live Exact Online.

Visualize Exact Online in Tableau Desktop (through CData Connect)

Create a virtual SQL Server database for Exact Online in CData Software Connect (or Connect Server) and build visualizations from live Exact Online in Tableau Desktop.

Access Live Exact Online in AWS Lambda (with IntelliJ IDEA)

Connect to live Exact Online in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

Automated Continuous Exact Online Replication to Apache Kafka

Use CData Sync for automated, continuous, customizable Exact Online replication to Apache Kafka.

A PostgreSQL Interface for Exact Online

Use the Remoting features of the Exact Online JDBC Driver to create a PostgreSQL entry-point for data access.

Integrate Exact Online in Your Informatica Cloud Instance

Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Exact Online from Informatica Cloud.

Exact Online Reporting in OBIEE with the Exact Online JDBC Driver

Deploy the Exact Online JDBC driver on OBIEE to provide real-time reporting across the enterprise.

Build Exact Online-Connected Apps in Choreo

Use CData Connect Cloud to connect to Exact Online from Choreo and build custom apps using live Exact Online.

Replicate Multiple Exact Online Accounts

Replicate multiple Exact Online accounts to one or many databases.

Automated Continuous Exact Online Replication to Apache Cassandra

Use CData Sync for automated, continuous, customizable Exact Online replication to Apache Cassandra.

Automated Continuous Exact Online Replication to Azure SQL

Use CData Sync for automated, continuous, customizable Exact Online replication to Azure SQL.

Automated Continuous Exact Online Replication to MySQL

Use CData Sync for automated, continuous, customizable Exact Online replication to MySQL.

How to Connect DBeaver to Exact Online via a JDBC Driver

Manage Exact Online with visual tools in DBeaver like the query browser.

How to connect to Exact Online from MS Excel on Mac OS X

Create a Data Source Name in iODBC with the CData ODBC Driver for Exact Online and work with Exact Online in Microsoft Excel on Mac OS X.

Build Semantic Layer Views for Exact Online in APOS Live Data Gateway

Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Exact Online.

Author and Share Power BI Reports on Real-Time Exact Online

Use the CData ODBC Driver for Exact Online to visualize Exact Online in Power BI Desktop and then upload to the Power BI service.

Use Dash to Build to Web Apps on Exact Online

Create Python applications that use pandas and Dash to build Exact Online-connected web apps.

Connect to Exact Online in NetBeans

Connect to Exact Online in NetBeans with the data source configuration wizard.

Build Pipelines with Live Exact Online in Google Cloud Data Fusion (via CData Connect Cloud)

Use CData Connect Cloud to connect to Exact Online from Google Cloud Data Fusion, enabling the integration of live Exact Online into the building and management of effective data pipelines.

Integrate Exact Online with External Services using SnapLogic

Use CData JDBC drivers in SnapLogic to integrate Exact Online with External Services.

Rapidly Develop Exact Online-Driven Apps with Active Query Builder

Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.

Configure the CData JDBC Driver for Exact Online in a Connection Pool in Tomcat

Connect to Exact Online from a connection pool in Tomcat.

Publish Reports with Exact Online in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Exact Online.

Automated Continuous Exact Online Replication to MongoDB

Use CData Sync for automated, continuous, customizable Exact Online replication to MongoDB.

Edit and Search External Exact Online Objects in Salesforce Connect

Use CData Connect Cloud to securely provide OData feeds of Exact Online to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Exact Online objects that you can access from apps and the dashboard.

How to Connect to & Open Exact Online in Microsoft Excel

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.

Create an SAP BusinessObjects Universe on the CData ODBC Driver for Exact Online

Provide connectivity to Exact Online through an SAP BusinessObjects universe.

How to Create Power BI Visual Reports with Real-Time Exact Online

Use CData Power BI Connectors to visualize Exact Online in Power BI.

Perform Batch Operations with Exact Online in Apache NiFi

Connect to Exact Online and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

How to connect to Exact Online in DBVisualizer

Integrate Exact Online with visual data analysis tools and data connection wizards in DBVisualizer

Build an OLAP Cube in SSAS from Exact Online

Establish a connection to Exact Online data from SQL Server Analysis Services, and use the Exact Online Data Provider to build OLAP cubes for use in analytics and reporting.

Access Live Exact Online in Coginiti Pro

Connect to and query live Exact Online from the GUI in the Coginiti Pro: SQL Analytics Tool.

Replicate Exact Online to Multiple Databases

Replicate Exact Online to disparate databases with a single configuration.

How to create Exact Online federated tables in MySQL

Use the SQL Gateway and the ODBC Driver to set up federated tables for Exact Online in MySQL .

Add Exact Online to Informatica Enterprise Data Catalog

Use the CData Software JDBC Driver for Exact Online with the Informatica Enterprise Data Catalog to classify and organize data.

How to connect PolyBase to Exact Online

Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Exact Online.

Integrate with Exact Online in SnapLogic

Use CData Connect Cloud to connect to and integrate with live Exact Online in SnapLogic.

Create Exact Online-Connected Nintex Workflows

Use CData Connect Cloud to connect to Exact Online from Nintex Workflow Cloud and build custom workflows using live Exact Online.

Connect to Exact Online from a Connection Pool in WebLogic

Use the CData JDBC Driver for Exact Online to connect to Exact Online from Web applications running on WebLogic.

How to Connect the Power BI Service to Exact Online: Complete Guide

Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.

Object-Relational Mapping (ORM) with Exact Online Entities in Java

Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Exact Online into a Java-based ORM framework, Hibernate.

Connect to Exact Online in the Denodo Platform

Use CData driver technologies to create a virtual data source for Exact Online in the Denodo Virtual DataPort Administrator.

Build Visualizations of Exact Online in Birst

Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Exact Online in Birst.

Query Exact Online through ODBC in Node.js

Use node-odbc to execute SQL queries against Exact Online from Node.js.

DataBind Controls to Exact Online in C++Builder

DataBind to Exact Online in C++Builder with standard components and controls.

Extract, Transform, and Load Exact Online in Informatica PowerCenter

Create a simple Workflow for Exact Online in Informatica PowerCenter.

Use the CData Software ODBC Driver for Exact Online in MicroStrategy Web

Connect to Exact Online in MicroStrategy Web using the CData Software ODBC Driver for Exact Online.

Use CData Connect Cloud to Access Exact Online in Microsoft Power Pivot

Use CData Connect Cloud to connect to live Exact Online in the Power Pivot business intelligence tool.

DataBind Charts to Exact Online

Use the standard ADO.NET procedures for databinding to provide bidirectional access to Exact Online from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.

Automated Continuous Exact Online Replication to Databricks

Use CData Sync for automated, continuous, customizable Exact Online replication to Databricks.

How to Import Exact Online into SQL Server using SSIS

Easily back up Exact Online to SQL Server using the SSIS components for Exact Online.

Connect to Exact Online as an External Data Source using PolyBase

Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live Exact Online.

Deploy the ADO.NET Provider for Exact Online on an SSRS Report Server

Connect to Exact Online from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

Connect to Exact Online in RunMyProcess through Connect Cloud

Use CData Connect Cloud to create on OData API for Exact Online and connect to Exact Online in Akorbi Digital RunMyProcess.

Visualize Live Exact Online of Power BI Report Builder in Power BI Service

Use CData Power BI Connectors to connect to live Exact Online using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

Integrate Live Exact Online into Amazon SageMaker Canvas with RDS

Use CData Connect Cloud to connect to Exact Online from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Exact Online.

Visualize Exact Online in TIBCO Spotfire through ODBC

The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Exact Online into TIBCO Spotfire.

Build Semantic Layer Views for Exact Online in APOS Live Data Gateway

Use the CData Connector for Exact Online in APOS Live Data Gateway to build Semantic Layer Views for Exact Online.

Query Exact Online as a MySQL Database in Node.js

Execute MySQL queries against Exact Online from Node.js.

Import Exact Online Using Azure Data Factory

Use CData Connect Cloud to connect to Exact Online from Azure Data Factory and import live Exact Online.

Build Exact Online-Connected Apps in Bubble

Use CData Connect Cloud to create an OData feed for Exact Online and create custom apps in Bubble.

Analyze Exact Online in Looker

Use CData Connect Cloud to connect to Exact Online from Looker and build custom apps using live Exact Online.

Automate Exact Online Replication to Couchbase

Use CData Sync to Customize and automate Exact Online replication to Couchbase.

Connect to Exact Online from a Connection Pool in JBoss

Integrate Exact Online into Java servlets: Use the Management Console in JBoss to install the Exact Online JDBC Driver.

Analyze Exact Online in R

Create data visualizations and use high-performance statistical functions to analyze Exact Online in Microsoft R Open.

Access Exact Online as a Remote Oracle Database

Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Exact Online from your Oracle system.

How to update Exact Online from Excel

This article explains how to transfer data from Excel to Exact Online using the Excel Add-In for Exact Online.

Create Informatica Mappings From/To an ODBC Data Source for Exact Online

Create an ODBC connection to Exact Online in Informatica and browse and transfer Exact Online.

A PostgreSQL Interface for Exact Online

Use the SQL Gateway and Exact Online ODBC Driver to create a PostgreSQL entry-point for data access.

Analyze Exact Online in R

Use standard R functions and the development environment of your choice to analyze Exact Online with the CData JDBC Driver for Exact Online.

Build Exact Online Visualizations in Tableau Cloud

Use CData Connect Cloud to connect to live Exact Online and build visualizations in Tableau Cloud.

Analyze Exact Online in SAP Analytics Cloud

Use CData Connect Cloud to create an OData API on top of Exact Online and visualize Exact Online in SAP Analytics Cloud.

DataBind Controls to Exact Online in Delphi

DataBind to Exact Online in Delphi with standard data access components and controls.

Work with Exact Online in FoxPro

Load Exact Online into a FoxPro database. This article includes full code and a walk-through of the process.

Create a Data Access Object for Exact Online using JDBI

A brief overview of creating a SQL Object API for Exact Online in JDBI.

How to publish and share Exact Online dashboards with Tableau Server

The CData ODBC driver for Exact Online enables you integrate Exact Online into Tableau dashboards.

Connect to Exact Online in Aqua Data Studio

Access Exact Online from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

Import Exact Online into the Power BI Service for Visualizations

Use CData Connect Cloud to connect to Exact Online and provide access to live Exact Online for custom reports in the Power BI Service.

How to work with Exact Online in Apache Spark using SQL

Access and process Exact Online in Apache Spark using the CData Software JDBC Driver.

Create Exact Online-Connected Business Apps in AppSheet

Connect to Exact Online via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to Exact Online.

Integrate Exact Online into Power Automate Desktop using CData Connect

CData Connect for Exact Online enables you to integrate Exact Online into workflows built using Microsoft Power Automate Desktop.

Replicate Exact Online to Multiple Databases

Replicate Exact Online to disparate databases with a point-and-click configuration.

Automate Exact Online Replication to Azure Synapse

Use CData Sync to customize and automate Exact Online replication to Azure Synapse.

How to integrate Exact Online with Apache Airflow

Access and process Exact Online in Apache Airflow using the CData JDBC Driver.

Integrate with Live Exact Online in MuleSoft (via CData Connect Cloud)

Use CData Connect Cloud to connect to Exact Online from the MuleSoft Anypoint Platform to integrate live Exact Online into custom reports and dashboards.

Visualize Exact Online in TIBCO Spotfire through OData

Integrate Exact Online into dashboards in TIBCO Spotfire.

Automated Continuous Exact Online Replication to SQL Server

Use CData Sync for automated, continuous, customizable Exact Online replication to SQL Server.

Replicate Exact Online from PowerShell

Write a quick PowerShell script to query Exact Online. Use connectivity to the live data to replicate Exact Online to SQL Server.

Create Exact Online-Connected Enterprise Applications in OutSystems

Use CData Connect Cloud to connect to Exact Online from OutSystems and build custom enterprise apps using live Exact Online.

How to Access Live Exact Online in Power Automate Desktop via ODBC

The CData ODBC Driver for Exact Online enables you to integrate Exact Online into workflows built using Microsoft Power Automate Desktop.

Create Data Visualizations in Cognos BI with Exact Online

Access Exact Online as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

Automated Continuous Exact Online Replication to IBM DB2

Use CData Sync for automated, continuous, customizable Exact Online replication to IBM DB2.

Access Live Exact Online in Excel (Desktop)

Use CData Connect Cloud to gain access to live Exact Online from your Excel spreadsheets.

Create Exact Online Dashboards in Bold BI

Use CData Software Connect Server to create a virtual SQL Server Database for Exact Online to build custom dashboards in Bold BI.

Create SSAS Tabular Models from Exact Online

How to build a SQL Server Analysis Service Tabular Model from Exact Online using CData drivers.

How to Build Dynamic React Apps with Exact Online

Use the CData Connect and React to Build Dynamic Web Apps with Live Exact Online .

Connect to Exact Online from Asprova with CData Software ODBC Driver for Exact Online

This article shows how to connect faster to Exact Online data from Asprova.

How to use SQLAlchemy ORM to access Exact Online in Python

Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Exact Online.

Connect to Exact Online in CloverDX (formerly CloverETL)

Transfer Exact Online using the visual workflow in the CloverDX data integration tool.

Connect to Exact Online in Google Apps Script

Use CData Connect Cloud to access Exact Online in Google Apps Script.

Query Exact Online in MySQL Workbench

Create a virtual MySQL database for Exact Online in CData Software Connect (or Connect Server) and work with live Exact Online in MySQL Workbench.

Use the CData ODBC Driver for Exact Online in Microsoft Power Query

You can use the CData Exact Online ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Exact Online into Microsoft Power Query.

Connect to and Visualize Live Exact Online in Tableau Prep

Use CData Tableau Connectors and Tableau Prep Builder to visualize live Exact Online.

Using the CData Software ODBC Driver for Exact Online in PyCharm

Connect to Exact Online as an ODBC data source in PyCharm using the CData Software ODBC Driver for Exact Online.

Build Exact Online-Connected Apps in Mendix

Use CData Connect Cloud to create an OData feed for Exact Online and create custom apps in Mendix.

Connect to Exact Online from Crystal Reports

Use CData Connect Cloud to connect to and report on live Exact Online from Crystal Reports.

Prepare, Blend, and Analyze Exact Online in Alteryx Designer

Build workflows to access live Exact Online for self-service data analytics.

Automate Exact Online Replication to SAP HANA

Use CData Sync to customize and automate Exact Online replication to SAP HANA.

How to create Visio diagrams from Exact Online

Automatically update Exact Online with the changes you make to Visio master shapes.

Create Exact Online-Connected Visualizations in Klipfolio

Use CData Connect Cloud to connect to Exact Online from Klipfolio and build custom visualizations using live Exact Online.

Connect to Live Exact Online in PostGresSQL Interface through CData Connect Cloud

Create a live connection to Exact Online in CData Connect Cloud and connect to your Exact Online from PostgreSQL.

Create Datasets from Exact Online in Domo Workbench and Build Visualizations of Exact Online in Domo

Use the CData Software ODBC Driver for Exact Online to create datasets from Exact Online in Domo Workbench and then build visualizations in the Domo service.

PowerShell Scripting to Replicate Exact Online to MySQL

Write a simple PowerShell script to replicate Exact Online to a MySQL database.

Connect to Exact Online in Airbyte ELT Pipelines

Use CData Connect Cloud to build ELT pipelines for Exact Online in Airbyte.

Analyze Exact Online in Infragistics Reveal

Use CData Connect Cloud to create on OData API on top of Exact Online and visualize live Exact Online in Infragistics Reveal.

Visualize Exact Online in Sisense

Create an ElastiCube in Sisense app with access to Exact Online.

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.

How to Visualize Exact Online Data in Python with pandas

Use pandas and other modules to analyze and visualize live Exact Online in Python.

Connect to Exact Online from PowerBuilder

This article demonstrates how to access Exact Online from PowerBuilder using the Exact Online JDBC Driver.

Export Data from SQL Server to Exact Online through SSIS

Easily push SQL Server data to Exact Online using the CData SSIS Tasks for Exact Online.

Visualize Exact Online in TIBCO Spotfire through ADO.NET

Integrate Exact Online into dashboards in TIBCO Spotfire.

Use the CData ODBC Driver for Exact Online in SAS JMP

You can use the CData ODBC Driver to integrate Exact Online into the statistical analysis tools available in SAS JMP. This article shows how to use Exact Online in the Graph Builder and Query Builder.

Prepare, Blend, and Analyze Exact Online in Alteryx Designer

Build workflows to access live Exact Online for self-service data analytics.

Access Live Exact Online in TIBCO Data Virtualization

Use the CData Software TIBCO DV Adapter for Exact Online to create a Exact Online source in TIBCO Data Virtualization Studio and gain access to live Exact Online from your TDV Server.

Automated Continuous Exact Online Replication to SQLite

Use CData Sync for automated, continuous, customizable Exact Online replication to SQLite.

How to Build an ETL App for Exact Online in Python with CData

Create ETL applications and real-time data pipelines for Exact Online in Python with petl.

Visualize Live Exact Online in Tableau

Use CData Tableau Connectors and Tableau Desktop to visualize live Exact Online.

Connect to Exact Online from HeidiSQL

Use CData Connect Cloud to connect to and query live Exact Online from HeidiSQL.

Create Apps from Exact Online in Qlik Sense Cloud

Use CData Connect Cloud to connect to Exact Online and build apps from live Exact Online in Qlik Sense Cloud.

Query Exact Online as a SQL Server Database in Node.js

Execute SQL Server queries against Exact Online from Node.js.

Create Exact Online Reports on JasperReports Server

Deploy the CData JDBC Driver on JasperReports Server to provide real-time Exact Online data access from reports, embedded analytics, and more.

Automated Continuous Exact Online Replication to Microsoft Access

Use CData Sync for automated, continuous, customizable Exact Online replication to Microsoft Access.

Automated Continuous Exact Online Replication to AlloyDB

Use CData Sync for automated, continuous, customizable Exact Online replication to AlloyDB.

Automated Continuous Exact Online Replication to Local Delimited Files

Use CData Sync for automated, continuous, customizable Exact Online replication to delimited files (CSV/TSV).

Automated Continuous Exact Online Replication to Amazon Redshift

Use CData Sync for automated, continuous, customizable Exact Online replication to Amazon Redshift.

Import Real-Time Exact Online in ColdFusion to Build Applications

Use CData JDBC drivers to import and use Exact Online in ColdFusion.

Query Exact Online in ColdFusion

Write standard ColdFusion data access code to connect to Exact Online.

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.

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.

How to connect Amazon QuickSight to Exact Online

Create a connection to Exact Online in CData Connect Cloud and insert Exact Online into Amazon QuickSight SPICE to build interactive dashboards.

Connect to Exact Online in HULFT Integrate

Connect to Exact Online as a JDBC data source in HULFT Integrate

Replicate Multiple Exact Online Accounts

Replicate multiple Exact Online accounts to one or many databases.

Build Dashboards with Exact Online in Dundas BI

Create dynamic dashboards and perform analytics based on Exact Online in Dundas BI.

Viewing Exact Online in RAD Studio Data Explorer

How to view Exact Online in RAD Studio Data Explorer using the CData ODBC Driver for Exact Online.

Automated Continuous Exact Online Replication to SingleStore

Use CData Sync for automated, continuous, customizable Exact Online replication to SingleStore.

Access Exact Online from MySQL in PHP

Connect to Exact Online through the standard MySQL libraries in PHP.

How to connect and process Exact Online from Azure Databricks

Use CData, Azure, and Databricks to perform data engineering and data science on live Exact Online

How to connect to Exact Online from IntelliJ

Integrate connectivity to Exact Online with wizards in IntelliJ.

Connect to Exact Online from AWS Glue

Use CData Connect Cloud to gain access to live Exact Online from your AWS Glue jobs.

Access Live Exact Online in Excel 365 Online (Excel for the web)

Connect to Exact Online from Excel 365 Online (Excel for the web) with CData Connect Cloud.

Visualize Live Exact Online in the Power BI Service

Use CData Connect Cloud to connect to live Exact Online and create custom reports in the Power BI Service through the On-Premises Gateway.

Access Live Exact Online in Google Sheets

Use CData Connect Cloud to gain access to live Exact Online from your Google Sheets.

Connect to Exact Online in RapidMiner

Integrate Exact Online with standard components and data source configuration wizards in RapidMiner Studio.

Establish a Live Connection with Exact Online using Tableau Bridge

The CData ODBC Driver for Exact Online enables you to integrate live Exact Online into Tableau Cloud dashboards using the Tableau Bridge.

Build Exact Online-Connected Visualizations in datapine

Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Exact Online.

Create an SAP BusinessObjects Universe on the CData JDBC Driver for Exact Online

Provide connectivity to Exact Online through an SAP BusinessObjects universe.

Replicate Exact Online for Use in Salesforce Connect

Replicate Exact Online to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

Connect to Exact Online in DBeaver

Use the CData ODBC Driver to connect to Exact Online in DBeaver.

Access Exact Online in PHP through Connect Server

Connect to Exact Online through the standard SQL Server libraries in PHP.

Publish Crystal Reports on Exact Online

Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Exact Online.

Use the CData Software ODBC Driver for Exact Online in MicroStrategy Desktop

Connect to Exact Online in MicroStrategy Desktop using the CData Software ODBC Driver for Exact Online.

Publish Exact Online-Connected Dashboards in Tableau Server

Use CData Tableau Connectors and Tableau Server to visualize live Exact Online.

Process & Analyze Exact Online in Databricks (AWS)

Use CData, AWS, and Databricks to perform data engineering and data science on live Exact Online .

Use the CData ODBC Driver for Exact Online from SharePoint Excel Services

This article demonstrates how to use the CData ODBC Driver for Exact Online to connect to Exact Online from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Exact Online in Excel.

Automated Continuous Exact Online Replication to Google Cloud SQL

Use CData Sync for automated, continuous, customizable Exact Online replication to Google Cloud SQL.

How to Connect to Exact Online in Using Python: 6 Steps

Create Python applications on Linux/UNIX machines with connectivity to Exact Online. Leverage the pyodbc module for ODBC in Python.

Analyze Exact Online with Power Pivot

This article walks you through the process of using the CData ODBC Driver for Exact Online from Power Pivot. You will use the Table Import Wizard to load Exact Online. You can visually build the import query or use any SQL supported by the driver.

Import Exact Online into FileMaker Pro

Create reports that integrate Exact Online in Filemaker Pro.

Connect to Exact Online in Ruby

Connect to Exact Online in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

Query, Visualize, and Share live Exact Online in Redash

Use CData Connect Cloud to connect to live Exact Online in Redash for querying, visualizing, and sharing.

Import and Visualize Exact Online in Power View

Create data visualizations based on Exact Online in Excel.

Use the CData Software JDBC Driver for Exact Online in MicroStrategy Desktop

Connect to Exact Online in MicroStrategy Desktop using the CData Software JDBC Driver for Exact Online.

Integrate Exact Online in the Pentaho Report Designer

Publish reports based on Exact Online in the Pentaho BI tool.

Natively Connect to Exact Online in PHP

Create PHP applications on Linux/UNIX machines with connectivity to Exact Online. Leverage the native support for ODBC in PHP.

Integrate Exact Online into Automated Tasks with Power Automate

Use CData Connect Cloud to connect to Exact Online and integrate live Exact Online into your Power Automate tasks.

Automated Exact Online Replication to Teradata

Use CData Sync to Customize and automate Exact Online replication to Teradata.

How to Query Exact Online in MySQL Workbench

Execute MySQL queries against live Exact Online from MySQL Workbench.

How to import Exact Online into Apache Solr

Use the CData Software JDBC Driver for Exact Online in Data Import Handler and create an automated import of Exact Online to Apache Solr Enterprise Search platform.

Integrate with live Exact Online in Jitterbit

Use CData Connect Cloud to connect to and integrate live Exact Online in Jitterbit.

Create Reports from Exact Online in Looker Studio

Use CData Connect Cloud to gain access to live Exact Online and create custom reports in Looker Studio.

LINQ to Exact Online

LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Exact Online Data Provider.

Connect to Exact Online from a Connection Pool in Jetty

The Exact Online JDBC Driver supports connection pooling: This article shows how to connect faster to Exact Online from Web apps in Jetty.

How to pipe Exact Online to CSV in PowerShell

Use standard PowerShell cmdlets to access Exact Online tables.

How to connect to Exact Online from Spring Boot

Connect to Exact Online in a Spring Boot Application using CData JDBC Exact Online Driver

Connect to Exact Online in as an External Source in Dremio

Use the CData JDBC Driver to connect to Exact Online as an External Source in Dremio.

Using AngularJS to Build Dynamic Web Pages with Exact Online

Use the CData Connect Server to create Exact Online OData feeds and build single-page applications with live Exact Online.

Create Dynamic Exact Online Grids Using the Infragistics XamDataGrid

Learn how you can connect Exact Online to Infragistics XamDataGrid to build dynamic grids.

Import Real-Time Exact Online in ColdFusion to Build Applications

Use CData ODBC drivers to import and use Exact Online in ColdFusion.

Use JayDeBeApi to access Exact Online in Python

Use standard Python scripting and the development environment of your choice to access live Exact Online.

Excel Spreadsheet Automation with the QUERY Formula

Pull data, automate spreadsheets, and more with the QUERY formula.

Bridge Exact Online Connectivity with Apache NiFi

Access and process Exact Online in Apache NiFi using the CData JDBC Driver.

Query Exact Online in DataGrip

Create a Data Source for Exact Online in DataGrip and use SQL to query live Exact Online.

Automate Exact Online Replication to Azure Data Lake

Use CData Sync to customize and automate Exact Online replication to Azure Data Lake.

Build Dashboards with Exact Online in DBxtra

Create dynamic dashboards and perform analytics based on Exact Online in DBxtra.

Automated Continuous Exact Online Replication to Oracle

Use CData Sync for automated, continuous, customizable Exact Online replication to Oracle.

Use the CData Software ODBC Driver for Exact Online in MicroStrategy

Connect to Exact Online in MicroStrategy Developer using the CData Software ODBC Driver for Exact Online.

Connect to Exact Online in Google Apps Script

Use the ODBC Driver for Exact Online and the SQL Gateway to access Exact Online from Google Apps Script.

Manage Exact Online in DBArtisan as a JDBC Source

Use wizards in DBArtisan to create a JDBC data source for Exact Online.

DataBind Exact Online to the DevExpress Data Grid

Use the CData Software ADO.NET Provider for Exact Online with the DevExpress Windows Forms and Web controls to provide Exact Online to a chart.

Build Charts with Exact Online in Clear Analytics

Create dynamic charts and perform analytics based on Exact Online in Clear Analytics.

Feed Exact Online into FineReport

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

Automated Continuous Exact Online Replication to Google BigQuery

Use CData Sync for automated, continuous, customizable Exact Online replication to Google BigQuery.

Visualize Live Exact Online in Power BI (via CData Connect Cloud)

Use the CData Power BI Connector and CData Connect Cloud to integrate live Exact Online into custom reports in Power BI.

Connect to Exact Online from PowerBuilder

This article demonstrates how to access Exact Online from Appeon PowerBuilder using the CData ADO.NET Provider for Exact Online.

Integrate with Exact Online in JReport Designer

Create charts and reports based on Exact Online in JReport Designer.

Publish Exact Online-Connected Dashboards in Tableau Server

Use CData JDBC drivers and Tableau Server to visualize live Exact Online.

Analyze Live Exact Online in SAS Viya

Use CData Connect Cloud to connect to Exact Online from SAS Viya and deploy self-service analytics using live Exact Online.

Build Exact Online-Connected ETL Processes in Google Data Fusion

Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Exact Online.

Integrate Live Exact Online into Custom Business Apps Built in Power Apps

Use CData Connect Cloud to connect to Exact Online and integrate live Exact Online into apps built in Microsoft Power Apps.

Connect to Exact Online in SpagoBI

Create reports featuring live Exact Online in SpagoBI Studio. Host Exact Online reports on SpagoBI Server.

Create Informatica Mappings From/To a JDBC Data Source for Exact Online

Create Exact Online data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

Connect to Exact Online in DBArtisan

Use wizards in DBArtisan to configure Exact Online as a data source.

Build Exact Online-Connected Dashboards Using Zoho Analytics

Use CData Connect Cloud to connect to Exact Online from Zoho Analytics and import live Exact Online.

Create Reports with Exact Online in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Exact Online.

Connect to Exact Online in DigitalSuite Studio through RunMyProcess DSEC

Use Arkobi Digital

Connect to Exact Online in RazorSQL

Connect to Exact Online from wizards and query Exact Online from the GUI in the RazorSQL database management tool.