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

CData Software - Knowledge Base

Recent Articles

Connect to Paylocity from PowerBuilder via JDBC

This article demonstrates how to access Paylocity from PowerBuilder using the Paylocity JDBC Driver.
Connect to ActiveCampaign in DigitalSuite Studio through RunMyProcess DSEC

Use Arkobi Digital
Replicate Clio in Heroku for Use in Salesforce Connect

Replicate Clio to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
Extract, Transform, and Load Freshdesk in Informatica PowerCenter

Create a simple Workflow for Freshdesk in Informatica PowerCenter.
Automated Continuous Sage Intacct Replication to MySQL

Use CData Sync for automated, continuous, customizable Sage Intacct replication to MySQL.
Use Dash to Build to Web Apps on JotForm

Create Python applications that use pandas and Dash to build JotForm-connected web apps.
Build a Singer.io Tap for XML With the CData Python Connector

Learn how to easily build a Singer.io Tap for live XML data using
Use the CData ODBC Driver for Drift from SharePoint Excel Services

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

Connect to Sybase as an ODBC data source in PyCharm using the CData Software ODBC Driver for Sybase.
Use Claude to Talk to Your YouTube Analytics via CData Connect Cloud

Leverage CData Connect Cloud Remote MCP to enable Claude to securely answer questions and take actions on your YouTube Analytics for you.
Access Amazon Athena from MySQL in PHP

Connect to Amazon Athena through the standard MySQL libraries in PHP.
Access Act CRM as a Remote Oracle Database

Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Act CRM from your Oracle system.
Connect to Splunk in Google Apps Script via Connect Cloud

Use CData Connect Cloud to access Splunk in Google Apps Script.
Automated Continuous Aha Replication to Google Cloud SQL

Use CData Sync for automated, continuous, customizable Aha replication to Google Cloud SQL.
Connect to Active Directory in Aqua Data Studio

Access Active Directory from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
Consume SFTP OData Feeds in PowerBuilder

This article demonstrates how to consume SFTP as OData feeds from PowerBuilder using the API Server.
DataBind Controls to MongoDB in Delphi

DataBind to MongoDB in Delphi with standard data access components and controls.
Access PingOne from MySQL in Amazon QuickSight

Connect to PingOne and build visualizations of PingOne using a MySQL Connection in Amazon QuickSight.
Connect SAP to AI Assistants With the CData Python MCP Server

Learn how to give AI assistants like Claude direct access to live SAP ERP/NetWeaver using the CData Python MCP Server.
How to import Shopify into Apache Solr

Use the CData Software JDBC Driver for Shopify in Data Import Handler and create an automated import of Shopify to Apache Solr Enterprise Search platform.
Replicate Sugar CRM to Multiple Databases

Replicate Sugar CRM to disparate databases with a point-and-click configuration.
Bridge Databricks Connectivity with Apache NiFi

Access and process Databricks in Apache NiFi using the CData JDBC Driver.
Build Visualizations of PostgreSQL in Birst

Use CData drivers and the Birst Cloud Agent to build real-time visualizations of PostgreSQL in Birst.
How to work with Basecamp in Apache Spark using SQL

Access and process Basecamp in Apache Spark using the CData Software JDBC Driver.
Access GitHub from MySQL in HeidiSQL

Use CData ODBC Driver and SQL Gateway to connect and query live GitHub from HeidiSQL.
Connect to Live PCA Sales in PostGresSQL Interface through CData Connect Cloud

Create a live connection to PCA Sales in CData Connect Cloud and connect to your PCA Sales from PostgreSQL.
Perform Batch Operations with HBase in Apache NiFi

Connect to Apache HBase and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
Automated Continuous SAS xpt Replication to AlloyDB

Use CData Sync for automated, continuous, customizable SAS xpt replication to AlloyDB.
Establish a Live Connection with Redis using Tableau Bridge

The CData ODBC Driver for Redis enables you to integrate live Redis into Tableau Cloud dashboards using the Tableau Bridge.
Establish a Live Connection with Paylocity using Tableau Bridge

The CData ODBC Driver for Paylocity enables you to integrate live Paylocity into Tableau Cloud dashboards using the Tableau Bridge.
Access Cvent from MySQL in PHP

Connect to Cvent through the standard MySQL libraries in PHP.
Connect to Oracle in DigitalSuite Studio through RunMyProcess DSEC

Use Arkobi Digital
Query Unbounce in DataGrip

Create a Data Source for Unbounce in DataGrip and use SQL to query live Unbounce.
Access Dropbox from MySQL in HeidiSQL

Use CData ODBC Driver and SQL Gateway to connect and query live Dropbox from HeidiSQL.
Access Live MarkLogic in AWS Lambda (with IntelliJ IDEA)

Connect to live MarkLogic in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
How to update Square from Excel

This article explains how to transfer data from Excel to Square using the Excel Add-In for Square.
How to Work with Parquet in ETL Validator JDBC

Connect to Parquet from ETL Validator jobs using the CData Software JDBC Driver.
Create Informatica Mappings From/To an ODBC Data Source for JSON

Create an ODBC connection to JSON in Informatica and browse and transfer JSON.
Build Visualizations of Cassandra in Birst

Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Apache Cassandra in Birst.
Query Twitter in ColdFusion

Write standard ColdFusion data access code to connect to Twitter.
How to integrate Microsoft Teams with Apache Airflow

Access and process Microsoft Teams in Apache Airflow using the CData JDBC Driver.
Connect to SAP ByDesign in Google Apps Script via SQL Gateway

Use the ODBC Driver for SAP ByDesign and the SQL Gateway to access SAP Business ByDesign from Google Apps Script.
Using the CData Software ODBC Driver for Paylocity in PyCharm

Connect to Paylocity as an ODBC data source in PyCharm using the CData Software ODBC Driver for Paylocity.
DataBind Charts to Google Directory

Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google Directory 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.
Analyze Spark with Power Pivot

This article walks you through the process of using the CData ODBC Driver for Spark from Power Pivot. You will use the Table Import Wizard to load Apache Spark SQL. You can visually build the import query or use any SQL supported by the driver.
Automated Continuous SAP Replication to Microsoft Access

Use CData Sync for automated, continuous, customizable SAP replication to Microsoft Access.
Query Sage 200 from Node.js

Use the OData endpoint of the CData API Server to connect to your Sage 200 and perform CRUD operations on Sage 200 from Node.js.
Connect to Azure Data Lake Storage in RapidMiner

Integrate Azure Data Lake Storage with standard components and data source configuration wizards in RapidMiner Studio.
LINQ to Typeform

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 Typeform Data Provider.
Use CData Connect Cloud to Access MYOB AccountRight in Microsoft Power Pivot

Use CData Connect Cloud to connect to live MYOB AccountRight in the Power Pivot business intelligence tool.
Back Up Apache Cassandra to SQL Server through SSIS

Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Cassandra. In this article, we will employ an SSIS workflow to populate a database with Apache Cassandra data.
Build MVC Applications with Connectivity to Zoom

This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Zoom from an ASP.NET MVC application.
Access Live Dynamics CRM in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

Connect to Microsoft Dynamics CRM from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
Connect to Azure Data Catalog in DigitalSuite Studio through RunMyProcess DSEC

Use Arkobi Digital
Publish Reports with Facebook in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Facebook.
Visualize Gmail in TIBCO Spotfire through ODBC

The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Gmail into TIBCO Spotfire.
Migrating data from Google Cloud Storage to Snowflake using CData SSIS Components.

Easily push Google Cloud Storage to Snowflake using the CData SSIS Tasks for Google Cloud Storage and Snowflake.
Build Data Flows from SQL Server to Snowflake through SSIS

Easily push SQL Server data to Snowflake using the CData SSIS Tasks for Snowflake.
Visualize Live EventBrite in Tableau

Use CData Tableau Connectors and Tableau Desktop to visualize live Eventbrite.
Automated Continuous Oracle Sales Replication to Local Delimited Files

Use CData Sync for automated, continuous, customizable Oracle Sales replication to delimited files (CSV/TSV).
Access Azure Analysis Services from MySQL in Amazon QuickSight

Connect to Azure Analysis Services and build visualizations of Azure Analysis Services using a MySQL Connection in Amazon QuickSight.
Use the CData Software JDBC Driver for FTP in MicroStrategy Web

Connect to FTP Servers in MicroStrategy Web using the CData Software JDBC Driver for FTP.
Build Apps with Live HubDB Using the Low-Code Development Platform of Mendix