CData Software - Knowledge Base
Recent Articles
-
Configure the CData JDBC Driver for Paylocity in a Connection Pool in Tomcat
Connect to Paylocity from a connection pool in Tomcat.
-
Use the CData ODBC Driver for Okta in Microsoft Power Query
You can use the CData Okta ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Okta into Microsoft Power Query.
-
Connect to Sage 50 UK in Aqua Data Studio
Access Sage 50 UK from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Getting Started with the CData Excel Add-In for Confluence
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Confluence.
-
Connecting GenSpark with OData Services via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to enterprise data across 300+ systems without any replication or custom integration required.
-
Automated Continuous Salesloft Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Salesloft replication to Apache Kafka.
-
Connect to and Query Acumatica in QlikView over ODBC
Create data visualizations with Acumatica ERP in QlikView.
-
Connect to HubDB in DBArtisan
Use wizards in DBArtisan to configure HubDB as a data source.
-
Back Up NetSuite CRM & ERP to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for NetSuite. In this article, we will employ an SSIS workflow to populate a database with NetSuite CRM & ERP data.
-
Connect to Cvent in DBeaver
Use the CData ODBC Driver to connect to Cvent in DBeaver.
-
Integrate Live OneNote into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to OneNote from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Microsoft OneNote.
-
Build Dashboards with Todoist in Dundas BI
Create dynamic dashboards and perform analytics based on Todoist in Dundas BI.
-
How to Query Workday in MySQL Workbench
Execute MySQL queries against live Workday from MySQL Workbench.
-
Visualize Live Microsoft Planner in the Power BI Service
Use CData Connect AI to connect to live Microsoft Planner and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to update Elasticsearch from Excel
This article explains how to transfer data from Excel to Elasticsearch using the Excel Add-In for Elasticsearch.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Oracle Eloqua
Provide connectivity to Oracle Eloqua through an SAP BusinessObjects universe.
-
Integrate Real-Time Access to Facebook Ads in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Facebook Ads in real time.
-
Query SAP Fieldglass through ODBC in Node.js
Use node-odbc to execute SQL queries against SAP Fieldglass from Node.js.
-
Create SAP Business One Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SAP Business One data access from reports, embedded analytics, and more.
-
Connect to Klipfolio from a Connection Pool in JBoss
Integrate Klipfolio into Java servlets: Use the Management Console in JBoss to install the Klipfolio JDBC Driver.
-
Configure the CData JDBC Driver for Sage 300 in a Connection Pool in Tomcat
Connect to Sage 300 from a connection pool in Tomcat.
-
Create Databricks Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to connect to Google Ads from Spring Boot
Connect to Google Ads in a Spring Boot Application using CData JDBC Google Ads Driver
-
How to Query Live Amazon DynamoDB in Claude Desktop
Connect to and query live Amazon DynamoDB in Claude Desktop using the CData MCP Server.
-
Facebook Ads Reporting in OBIEE with the Facebook Ads JDBC Driver
Deploy the Facebook Ads JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Azure Data Catalog Replication to Oracle
Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to Oracle.
-
ETL YouTube Analytics in Oracle Data Integrator
This article shows how to transfer YouTube Analytics into a data warehouse using Oracle Data Integrator.
-
Use the CData Software ODBC Driver for Redis in MicroStrategy
Connect to Redis in MicroStrategy Developer using the CData Software ODBC Driver for Redis.
-
Natively Connect to Oracle Eloqua Reporting in PHP
The CData ODBC driver for Oracle Eloqua Reporting enables you to create PHP applications with connectivity to Oracle Eloqua Reporting. Leverage the native support for ODBC in PHP.
-
Replicate Dynamics 365 in Heroku for Use in Salesforce Connect
Replicate Microsoft Dynamics 365 to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to MYOB AccountRight from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time MYOB AccountRight using standard SQL.
-
DataBind Charts to ServiceNow
Use the standard ADO.NET procedures for databinding to provide bidirectional access to ServiceNow 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.
-
Provide OData Services of Shippo from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Shippo by developing a WCF Service Application.
-
Design BIRT Reports on Lakebase
Provide current Lakebase to your embedded analytics.
-
Replicate Multiple SAP Ariba Source Accounts
Replicate multiple SAP Ariba Source accounts to one or many databases.
-
Integrate Live Google Directory into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Google Directory and integrate live Google Directory into apps built in Microsoft Power Apps.
-
Automated Continuous PostgreSQL Replication to IBM DB2
Use CData Sync for automated, continuous, customizable PostgreSQL replication to IBM DB2.
-
Build Pipelines with Live Reckon in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Reckon from Google Cloud Data Fusion, enabling the integration of live Reckon into the building and management of effective data pipelines.
-
Query, Visualize, and Share live Impala in Redash
Use CData Connect AI to connect to live Apache Impala in Redash for querying, visualizing, and sharing.
-
Build Data Flows from SuiteCRM to SQL Server using SSIS
Easily back up SuiteCRM to SQL Server using the SSIS components for SuiteCRM.
-
Access Live TigerGraph in AWS Lambda
Connect to live TigerGraph in AWS Lambda using the CData JDBC Driver.
-
Automate Bullhorn CRM Replication to SAP HANA
Use CData Sync to customize and automate Bullhorn CRM replication to SAP HANA.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Couchbase using the Model Context Protocol.
-
How to connect to Procore from Spring Boot
Connect to Procore in a Spring Boot Application using CData JDBC Procore Driver
-
Automated Continuous JotForm Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable JotForm replication to Microsoft Access.
-
Connect to QuickBooks Time in Google Apps Script via SQL Gateway
Use the ODBC Driver for QuickBooks Time and the SQL Gateway to access QuickBooks Time from Google Apps Script.
-
Connect to Databricks Using the Script Function in Claris FileMaker Pro
-