Show articles by: Integration Technology | Driver Technology | Recent Articles

CData Software - Knowledge Base

Recent Articles

Build a Simple VCL Application for Reckon

How to build a simple VCL Application to view Reckon in RAD Studio using the CData ODBC Driver for Reckon.
Automated MarkLogic Replication to Teradata

Use CData Sync to Customize and automate MarkLogic replication to Teradata.
How to connect to Paylocity with Squirrel SQL client

Connect to Paylocity and execute queries in the Squirrel SQL Client.
Connect to Oracle HCM Cloud from a Connection Pool in JBoss

Integrate Oracle HCM Cloud into Java servlets: Use the Management Console in JBoss to install the Oracle HCM Cloud JDBC Driver.
Object-Relational Mapping (ORM) with EventBrite 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 Eventbrite into a Java-based ORM framework, Hibernate.
Integrate with Live Databricks in MuleSoft (via CData Connect Cloud)

Use CData Connect Cloud to connect to Databricks from the MuleSoft Anypoint Platform to integrate live Databricks into custom reports and dashboards.
Import Real-Time Zoho Creator via ODBC in ColdFusion to Build Applications

Use CData ODBC drivers to import and use Zoho Creator in ColdFusion.
How to Query Live DocuSign in Claude Desktop

Connect to and query live DocuSign in Claude Desktop using the CData MCP Server.
Automated Continuous MYOB AccountRight Replication to IBM DB2

Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to IBM DB2.
Connect to MongoDB in RapidMiner

Integrate MongoDB with standard components and data source configuration wizards in RapidMiner Studio.
How to work with Jira Assets in Apache Spark using SQL

Access and process Jira Assets in Apache Spark using the CData Software JDBC Driver.
How to connect to CockroachDB from Spring Boot

Connect to CockroachDB in a Spring Boot Application using CData JDBC CockroachDB Driver
Migrating data from Databricks to Google BigQuery using CData SSIS Components.

Easily push Databricks to Google BigQuery using the CData SSIS Tasks for Databricks and Google BigQuery.
Use the CData Software ODBC Driver for Facebook Ads in SAS for Real-Time Reporting and Analytics

Connect to real-time Facebook Ads in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Facebook Ads.
Build Dashboards with Sage Intacct in DBxtra

Create dynamic dashboards and perform analytics based on Sage Intacct in DBxtra.
Automated Continuous GraphQL Replication to Apache Kafka

Use CData Sync for automated, continuous, customizable GraphQL replication to Apache Kafka.
Connect to Unbounce in RapidMiner

Integrate Unbounce with standard components and data source configuration wizards in RapidMiner Studio.
Publish SAP Hybris C4C-Connected Dashboards in Tableau Server

Use CData Tableau Connectors and Tableau Server to visualize live SAP Hybris C4C.
Connect to BigCommerce in Google Apps Script via Connect Cloud

Use CData Connect Cloud to access BigCommerce in Google Apps Script.
Connect to HBase from Asprova with CData Software ODBC Driver for HBase

This article shows how to connect faster to HBase data from Asprova.
DataBind ActiveCampaign to the DevExpress Data Grid

Use the CData Software ADO.NET Provider for ActiveCampaign with the DevExpress Windows Forms and Web controls to provide ActiveCampaign to a chart.
How to connect to SAP Ariba Procurement from Spring Boot

Connect to SAP Ariba Procurement in a Spring Boot Application using CData JDBC SAP Ariba Procurement Driver
Publish Microsoft OneDrive-Connected Dashboards in Tableau Server via JDBC

Use CData JDBC drivers and Tableau Server to visualize live Microsoft OneDrive.
How to connect and process Salesforce Pardot from Azure Databricks

Use CData, Azure, and Databricks to perform data engineering and data science on live Salesforce Pardot.
Connect QuickBooks Online to AI Assistants With the CData Python MCP Server

Learn how to give AI assistants like Claude direct access to live QuickBooks Online using the CData Python MCP Server.
Connect to Highrise from Blazor Apps

Build ASP.NET Core Blazor C# apps that integrate with real-time Highrise CRM using standard SQL.
Analyze MongoDB in Cognos Analytics

Use CData Connect Cloud to connect to MongoDB from Cognos Analytics and analyze live MongoDB.
How to load Redshift data into Elasticsearch via Logstash

Introducing a simple method to load Redshift data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
Visualize Live BigQuery in the Power BI Service

Use CData Connect Cloud to connect to live Google BigQuery and create custom reports in the Power BI Service through the On-Premises Gateway.
Create Dynamic Bing Ads Grids Using the Infragistics XamDataGrid

Learn how you can connect Bing Ads to Infragistics XamDataGrid to build dynamic grids.
A PostgreSQL Interface for Google Ads (MySQL Remoting via JDBC)

Use the Remoting features of the Google Ads JDBC Driver to create a PostgreSQL entry-point for data access.
Automated Continuous Drip Replication to IBM DB2

Use CData Sync for automated, continuous, customizable Drip replication to IBM DB2.
How to Connect the Power BI Service to Adobe Analytics: Complete Guide

Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
Automated Continuous AlloyDB Replication to Google Cloud SQL

Use CData Sync for automated, continuous, customizable AlloyDB replication to Google Cloud SQL.
Automated Continuous Google Calendar Replication to SingleStore

Use CData Sync for automated, continuous, customizable Google Calendar replication to SingleStore.
Create Informatica Mappings From/To an ODBC Data Source for Power BI XMLA

Create an ODBC connection to Power BI XMLA in Informatica and browse and transfer Power BI XMLA.
Create Data Visualizations Based On MongoDB in Mode

Use CData Connect Cloud to connect to MongoDB from Mode and build visualizations using live
Access Live SAP Business One in SAS JMP via ODBC

You can use the CData ODBC Driver to integrate SAP Business One into the statistical analysis tools available in SAS JMP. This article shows how to use SAP Business One in the Graph Builder and Query Builder.
Automate HDFS Replication to Azure Synapse

Use CData Sync to customize and automate Apache HDFS replication to Azure Synapse.
DataBind Controls to IBM Cloud Object Storage in C++Builder

DataBind to IBM Cloud Object Storage in C++Builder with standard components and controls.
Operational Reporting on Instagram from Spotfire Server

Create and share Spotfire data visualizations with real-time connectivity to remote Instagram.
Access Facebook from MySQL in HeidiSQL

Use CData ODBC Driver and SQL Gateway to connect and query live Facebook from HeidiSQL.
Automated Continuous JotForm Replication to Databricks

Use CData Sync for automated, continuous, customizable JotForm replication to Databricks.
Visualize Live Databricks of Power BI Report Builder in Power BI Service

Use CData Power BI Connectors to connect to live Databricks using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
Natively Connect to SAP Ariba Procurement in PHP via ODBC (Linux)

Create PHP applications on Linux/UNIX machines with connectivity to SAP Ariba Procurement. Leverage the native support for ODBC in PHP.
Back Up IBM Informix to SQL Server through SSIS

Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for IBM Informix. In this article, we will employ an SSIS workflow to populate a database with IBM Informix data.
How to Query QuickBooks Online in MySQL Workbench

Execute MySQL queries against live QuickBooks Online from MySQL Workbench.
How to Query Active Directory in MySQL Workbench

Execute MySQL queries against live Active Directory from MySQL Workbench.
Automated Continuous Zoom Replication to Apache Kafka

Use CData Sync for automated, continuous, customizable Zoom replication to Apache Kafka.
How to connect to SAP Business One from Spring Boot

Connect to SAP Business One in a Spring Boot Application using CData JDBC SAP Business One Driver
How to connect to SAP Hybris C4C in DBVisualizer

Integrate SAP Hybris C4C with visual data analysis tools and data connection wizards in DBVisualizer
How to Connect to & Open Office 365 in Microsoft Excel

This article uses the CData ODBC driver for Office 365 to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
ETL ServiceNow in Oracle Data Integrator

This article shows how to transfer ServiceNow into a data warehouse using Oracle Data Integrator.
Create Power BI Reports on Real-Time Google Drive

Use the CData ODBC Driver for Google Drive to visualize Google Drive in Power BI Desktop.
Access Dynamics NAV as a Remote Oracle Database

Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Microsoft Dynamics NAV from your Oracle system.
Connect to ConstantContact from PowerBuilder via JDBC

This article demonstrates how to access ConstantContact from PowerBuilder using the ConstantContact JDBC Driver.
Publish Coinbase-Connected Dashboards in Tableau Server via JDBC

Use CData JDBC drivers and Tableau Server to visualize live Coinbase.
Connect to Quickbase in DBeaver

Use the CData ODBC Driver to connect to Quickbase in DBeaver.
Automated Continuous TaxJar Replication to Snowflake

Use CData Sync for automated, continuous, customizable TaxJar replication to Snowflake.
Build Trello-Connected Apps in Choreo

Use CData Connect Cloud to connect to Trello from Choreo and build custom apps using live Trello.
Visualize Live Adobe Commerce of Power BI Report Builder in Power BI Service

Use CData Power BI Connectors to connect to live Adobe Commerce using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
Import Aha into Microsoft Power Query

The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Aha!. In this article, you will use the OData format to import Aha! into Microsoft Power Query.
Automated Continuous Access Replication to SingleStore

Use CData Sync for automated, continuous, customizable Access replication to SingleStore.
How to Import Data from Raisers Edge NXT into Google Sheets

Import Raisers Edge NXT into a Google spreadsheet that is automatically refreshed.
Connect and Query Live Gmail Data in Databricks with CData Connect Cloud

Use CData Connect Cloud to integrate live Gmail into Databricks
How to publish and share GraphQL dashboards with Tableau Server

The CData ODBC driver for GraphQL enables you integrate GraphQL into Tableau dashboards.
Import QuickBooks Online Using Azure Data Factory

Use CData Connect Cloud to connect to QuickBooks Online from Azure Data Factory and import live QuickBooks Online.
Connect to CSV in RapidMiner

Integrate CSV/TSV Files with standard components and data source configuration wizards in RapidMiner Studio.
Import Real-Time Smartsheet via ODBC in ColdFusion to Build Applications

Use CData ODBC drivers to import and use Smartsheet in ColdFusion.
Write a Simple Go Application to work with JSON Services on Linux

Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to JSON.
Use the CData ODBC Driver for Adobe Commerce from SharePoint Excel Services

This article demonstrates how to use the CData ODBC Driver for Adobe Commerce to connect to Adobe Commerce from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Adobe Commerce in Excel.
Create Data Visualizations Based On Microsoft Planner in Mode

Use CData Connect Cloud to connect to Microsoft Planner from Mode and build visualizations using live
How to create Visio diagrams from OData Services

Automatically update OData with the changes you make to Visio master shapes.
Access Live Jira Assets in Coginiti Pro

Connect to and query live Jira Assets from the GUI in the Coginiti Pro: SQL Analytics Tool.
Build a Singer.io Tap for eBay Analytics With the CData Python Connector

Learn how to easily build a Singer.io Tap for live eBay Analytics data using
Automated Continuous SAP Ariba Source Replication to IBM DB2

Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to IBM DB2.
DataBind Controls to Oracle Financials Cloud in Delphi

DataBind to Oracle Financials Cloud in Delphi with standard data access components and controls.
Access Live Sansan in Excel (Desktop) through Connect Spreadsheets

Use Connect Spreadsheets by CData to gain access to live Sansan from your Excel spreadsheets.
Automated Google Sheets Replication to Teradata

Use CData Sync to Customize and automate Google Sheets replication to Teradata.
ETL Google Calendar in Oracle Data Integrator

This article shows how to transfer Google Calendar into a data warehouse using Oracle Data Integrator.
Connect to Splunk in SpagoBI

Create reports featuring live Splunk in SpagoBI Studio. Host Splunk reports on SpagoBI Server.
Create Data Visualizations in Cognos BI with Microsoft Dataverse

Access Microsoft Dataverse (CDS) as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
Connect to Google Search Results as an External Source in Dremio

Use the CData JDBC Driver to connect to Google Search as an External Source in Dremio.
Consume Jira Service Management OData Feeds in SAP Lumira

Use the API Server to create data visualizations on Jira Service Management feeds that reflect any changes in SAP Lumira.
A PostgreSQL Interface for Smartsheet (MySQL Remoting via JDBC)

Use the Remoting features of the Smartsheet JDBC Driver to create a PostgreSQL entry-point for data access.
Replicate Multiple SurveyMonkey Accounts via the CData Sync CLI

Replicate multiple SurveyMonkey accounts to one or many databases.
Automated Continuous CData Connect Cloud Replication to Azure SQL Database

Use CData Sync for automated, continuous, customizable CData Connect Cloud replication to Azure SQL Database.
Connect to Amazon S3 from a Connection Pool in WebLogic

Use the CData JDBC Driver for Amazon S3 to connect to Amazon S3 from Web applications running on WebLogic.
How to connect SharePoint with SAP HANA XS Advanced through external lists

Provide SAP HANA XS Advanced to SharePoint users as an external list.
Query xBase as a MySQL Database in Node.js

Execute MySQL queries against xBase from Node.js.
Connect to Amazon DynamoDB through External Services in Salesforce

Use CData Connect Cloud to securely connect Salesforce External Services with Amazon DynamoDB using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
Design BIRT Reports on Unbounce

Provide current Unbounce to your embedded analytics.
Natively Connect to Salesforce Marketing in PHP

The CData ODBC driver for Salesforce Marketing enables you to create PHP applications with connectivity to Salesforce Marketing Cloud. Leverage the native support for ODBC in PHP.
Query Epicor Kinetic through ODBC in Node.js

Use node-odbc to execute SQL queries against Epicor Kinetic from Node.js.
Connect to Microsoft Dataverse from AWS Glue

Use CData Connect Cloud to gain access to live Microsoft Dataverse (CDS) from your AWS Glue jobs.
How to Query Live Certinia Data in Natural Language in Python using LlamaIndex

Use LlamaIndex to query live Certinia data in natural language using Python.
Access Live EventBrite in AWS Lambda (with IntelliJ IDEA)

Connect to live Eventbrite in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
Build Trello-Connected Apps in Bubble

Use CData Connect Cloud to create an OData feed for Trello and create custom apps in Bubble.
Access Live Dropbox in AWS Lambda (with IntelliJ IDEA)

Connect to live Dropbox in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
How to import Reckon Accounts Hosted into Apache Solr

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