CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Exa Replication to Oracle
Use CData Sync for automated, continuous, customizable Exa replication to Oracle.
-
Create Informatica Mappings From/To an ODBC Data Source for SAP SuccessFactors LMS
Create an ODBC connection to SAP SuccessFactors LMS in Informatica and browse and transfer SAP SuccessFactors LMS.
-
Visualize Azure DevOps Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Azure DevOps into TIBCO Spotfire.
-
Connect to Pipeliner CRM Data from a Connection Pool in JBoss
Integrate Pipeliner CRM into Java servlets: Use the Management Console in JBoss to install the Pipeliner CRM JDBC Driver.
-
Create Office 365-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Office 365 Data from Klipfolio and build custom visualizations using live Microsoft Office 365.
-
Use JayDeBeApi to access Mixpanel Data in Python
Use standard Python scripting and the development environment of your choice to access live Mixpanel.
-
Use the CData Software ODBC Driver for Instantly in SAS for Real-Time Reporting and Analytics
Connect to real-time Instantly in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Instantly.
-
Create Dynamic Greenhouse Grids Using the Infragistics XamDataGrid
Learn how you can connect Greenhouse to Infragistics XamDataGrid to build dynamic grids.
-
Integrate Cursor with Live QuickBooks Time Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live QuickBooks Time from within the editor.
-
Analyze Discourse Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Discourse and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
How to Query FreshBooks Data in MySQL Workbench
Execute MySQL queries against live FreshBooks from MySQL Workbench.
-
Enable the SAP Ariba Source JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SAP Ariba Source.
-
Replicate Multiple Mode Accounts via the CData Sync CLI
Replicate multiple Mode accounts to one or many databases.
-
Create Dynamic MailChimp Grids Using the Infragistics XamDataGrid
Learn how you can connect MailChimp to Infragistics XamDataGrid to build dynamic grids.
-
Configure the CData JDBC Driver for OneNote in a Connection Pool in Tomcat
Connect to Microsoft OneNote from a connection pool in Tomcat.
-
Integrating Boomi Agentstudio with ShipStation Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to ShipStation, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed EmailOctopus to Power BI dashboards. Simply drag and drop EmailOctopus into data visuals on the Power BI canvas.
-
How to Work with Wrike Data in ETL Validator JDBC
Connect to Wrike from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrating Cursor CLI with Bitly Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Migrating data from Asana to Databricks using CData SSIS Components.
Easily push Asana to Databricks using the CData SSIS Tasks for Asana and Databricks.
-
Avro Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Apache Avro through CData Connect AI using different applications and tools.
-
Integrate Live MailerLite Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live MailerLite to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrating OpenCode Terminal with Parquet Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Migrating data from Oracle Financials Cloud to Google BigQuery using CData SSIS Components.
Easily push Oracle Financials Cloud to Google BigQuery using the CData SSIS Tasks for Oracle Financials Cloud and Google BigQuery.
-
Connect to Highrise Data in Jaspersoft Studio
Execute SQL to remote Highrise CRM in Jaspersoft Studio.
-
Integrate eBay Analytics Data in the Pentaho Report Designer
Publish reports based on eBay Analytics in the Pentaho BI tool.
-
Automated Continuous Printify Replication to Snowflake
Use CData Sync for automated, continuous, customizable Printify replication to Snowflake.
-
Validate Sybase Data with QuerySurge
Access and validate Sybase in QuerySurge using the CData JDBC Driver.
-
Connect to Klipfolio Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Build Automated Workflows with Live Jira Assets Data in Workato
Use CData Connect AI to connect to live Jira Assets and build automated workflows in Workato.
-
DataBind Charts to Dynamics 365 Business Central Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Dynamics 365 Business Central 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.
-
Create Apps from Jira Data in Qlik Sense Cloud
Use CData Connect AI to connect to Jira Data and build apps from live Atlassian Jira in Qlik Sense Cloud.
-
How to integrate Metabase with Microsoft Exchange Data
Use CData Connect AI to connect to live Microsoft Exchange and create an interactive dashboard in Metabase from Microsoft Exchange.
-
Publish Crystal Reports on Demio Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Demio.
-
Create Data Visualizations Based On ServiceNow Data in Mode
Use CData Connect AI to connect to ServiceNow Data from Mode and build visualizations using live
-
Connect to Azure Data Catalog Data from PowerBuilder via JDBC
This article demonstrates how to access Azure Data Catalog from PowerBuilder using the Azure Data Catalog JDBC Driver.
-
Analyze Webex Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Webex with the CData JDBC Driver for Webex.
-
How to Access Live Cosmos DB Data in Visual Studio Code via Cline
Run CData MCP Server for Cosmos DB on Windows Subsytem for Linux (WSL) and connect to live Azure Cosmos DB from the Cline extension in Visual Studio Code.
-
How to Connect to GitLab Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to GitLab. Leverage the pyodbc module for ODBC in Python.
-
Connect to Azure Table Data in HULFT Integrate
Connect to Azure Table as a JDBC data source in HULFT Integrate
-
How to connect to Bitbucket Data in DBVisualizer
Integrate Bitbucket with visual data analysis tools and data connection wizards in DBVisualizer
-
Getting Started with the CData ODBC Driver for Notion
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Notion.
-
Connect SendInBlue to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SendInBlue with IBM WebSphere for seamless data integration and connectivity.
-
Natively Connect to Placid Data in PHP
The CData ODBC driver for Placid enables you to create PHP applications with connectivity to Placid. Leverage the native support for ODBC in PHP.
-
Build FreeAgent-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live FreeAgent.
-
Visualize Live Quickbase Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Quickbase into custom reports in Power BI.
-
Replicate Salesforce Pardot Data in Heroku for Use in Salesforce Connect
Replicate Salesforce Pardot to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Paymo Data in NetBeans
Connect to Paymo in NetBeans with the data source configuration wizard.
-
How to Build an ETL App for Adobe Commerce Data in Python with CData
Create ETL applications and real-time data pipelines for Adobe Commerce in Python with petl.
-
Extract, Transform, and Load LinkedIn Data in Informatica PowerCenter
Create a simple Workflow for LinkedIn in Informatica PowerCenter.
-
How to integrate Azure DevOps with Apache Airflow
Access and process Azure DevOps in Apache Airflow using the CData JDBC Driver.
-
Query, Visualize, and Share live FHIR Data in Redash
Use CData Connect AI to connect to live FHIR in Redash for querying, visualizing, and sharing.
-
How to Connect to & Open Parallel Data in Microsoft Excel
This article uses the CData ODBC driver for Parallel to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Charts with Pipeline CRM Data in Clear Analytics
Create dynamic charts and perform analytics based on Pipeline CRM in Clear Analytics.
-
A PostgreSQL Interface for ElevenLabs Data using the CData ODBC Driver
Use the SQL Gateway and ElevenLabs ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to create Strava federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Strava in MySQL .
-
How to integrate Drift with Apache Airflow
Access and process Drift in Apache Airflow using the CData JDBC Driver.
-
Integrating Kiro CLI with Drip Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Integrating Antigravity CLI with Amazon Redshift via CData CLI
Connect Amazon Redshift to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Write a Simple Go Application to work with AfterShip Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to AfterShip.
-
Design BIRT Reports on FTP Data
Provide current FTP Servers to your embedded analytics.
-
Bridge QuickBooks Online Connectivity with Apache NiFi
Access and process QuickBooks Online in Apache NiFi using the CData JDBC Driver.
-
Create Microsoft OneDrive Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Microsoft OneDrive from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated LDAP Objects Replication to Teradata
Use CData Sync to Customize and automate LDAP replication to Teradata.
-
Access Smartsheet Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Smartsheet from HeidiSQL.
-
Stripe Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Stripe facts in real time.
-
Import Real-Time SQL Analysis Services Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SQL Analysis Services in ColdFusion.
-
Build Azure Synapse-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Azure Synapse to explore live Azure Synapse Data in Cursor to assist with building Azure Synapse-powered applications.
-
Add Harvest Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Harvest with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to connect and process Instantly from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Instantly.
-
How to connect and process Pipeline CRM from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Pipeline CRM.
-
Feed Testmonitor Data into FineReport
How to set Testmonitor as a JDBC data source in FineReport.
-
Create a Data Access Object for Google Cloud Storage Data using JDBI
A brief overview of creating a SQL Object API for Google Cloud Storage in JDBI.
-
Visualize Zoho Creator Data in TIBCO Spotfire through ADO.NET
Integrate Zoho Creator into dashboards in TIBCO Spotfire.
-
Connect to SageHR Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SageHR.
-
DataBind Charts to MessageBird Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to MessageBird 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.
-
Connect to Aha! Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Aha! as an External Source in Dremio.
-
Analyze Spark Data 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.
-
Extract, Transform, and Load Elorus Data in Informatica PowerCenter
Create a simple Workflow for Elorus in Informatica PowerCenter.
-
Use the CData API Server to Access Acumatica Data in Microsoft PowerPivot
Use the CData API Server to connect to live Acumatica ERP in the Power Pivot business intelligence tool.
-
How to connect to Paddle Data in DBVisualizer
Integrate Paddle with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Jira-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Jira Data and create custom apps in Mendix.
-
Create Klaviyo Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Klaviyo from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous Sage 200 Replication to SQLite
Use CData Sync for automated, continuous, customizable Sage 200 replication to SQLite.
-
Use the CData Software JDBC Driver for Google Tasks in MicroStrategy Web
Connect to Google Tasks in MicroStrategy Web using the CData Software JDBC Driver for Google Tasks.
-
Automate MarkLogic Data Replication to Couchbase
Use CData Sync to Customize and automate MarkLogic replication to Couchbase.
-
Integrate Live Google Analytics Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Create Stripe-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Stripe Data from OutSystems and build custom enterprise apps using live Stripe.
-
DataBind Charts to Printful Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Printful 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.
-
Integrating HBase Data in Talend Cloud Data Management Platform
Connect HBase Data with Talend Cloud Data Management Platform using the CData JDBC Driver for HBase.
-
Bind Live Tally Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Tally data
-
Use the CData Software JDBC Driver for HBase in MicroStrategy
Connect to Apache HBase in MicroStrategy Developer using the CData Software JDBC Driver for HBase.
-
Access Live Adobe Commerce Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Adobe Commerce from your Excel spreadsheets.
-
Import Real-Time Workday Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Workday in ColdFusion.
-
How to Access Live SendPulse Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SendPulse enables you to integrate SendPulse into workflows built using Microsoft Power Automate Desktop.
-
Use Dash to Build to Web Apps on Basecamp Data
Create Python applications that use pandas and Dash to build Basecamp-connected web apps.
-
Automated Continuous Spark Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Spark replication to delimited files (CSV/TSV).
-
Automated Continuous Impala Replication to SQLite
Use CData Sync for automated, continuous, customizable Impala replication to SQLite.
-
Access Live ADP Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live ADP through MCP integration.
-
Build Voice Agents in ElevenLabs with access to Live Epicor Kinetic Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Epicor Kinetic.