CData Software - Knowledge Base
Recent Articles
-
Automated Continuous iContact Replication to IBM DB2
Use CData Sync for automated, continuous, customizable iContact replication to IBM DB2.
-
Integrate Webflow with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Webflow with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Webflow data.
-
Automated Continuous ZendeskSell Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable ZendeskSell replication to Apache Cassandra.
-
Connect to DB2 Data as an External Source in Dremio
Use the CData JDBC Driver to connect to DB2 as an External Source in Dremio.
-
Connect to Elorus from Asprova with CData Software ODBC Driver for Elorus
This article shows how to connect faster to Elorus data from Asprova.
-
Access Live Deel Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Deel data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Visualize Clio Data in Tableau
The CData ODBC driver for Clio enables you integrate Clio data into Tableau dashboards.
-
Explore Geographical Relationships in Exact Online Data with Power Map
Create data visualizations with Exact Online data in Power Map.
-
Access Live MarkLogic Data in TIBCO Data Virtualization
Use the MarkLogic Tibco DV Adapter to create a MarkLogic data data source in TIBCO Data Virtualization Studio and gain access to live MarkLogic data from your TDV Server.
-
Access PingOne Data 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 PingOne data.
-
Model, Search, and Visualize Live Freshdesk Data in ThoughtSpot
Use CData Connect AI to connect to live Freshdesk data for modeling, searching, and visualizing.
-
Build Apps with Live Presto data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Presto data into the Adalo platform and build custom mobile and web applications with real-time Presto data.
-
Use JayDeBeApi to access Dynamics NAV Data in Python
Use standard Python scripting and the development environment of your choice to access live Dynamics NAV data.
-
Use Biml to Build SSIS Tasks to Replicate Aha! Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Aha! data to SQL Server.
-
Create Zoho Projects-Connected Dashboards in Grafana
Connect to Zoho Projects Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Zoho Projects data.
-
Integrate Open WebUI with Live CockroachDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live CockroachDB data from within the chat interface.
-
Connect Elorus to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Elorus data using the CData Python MCP Server.
-
Replicate Multiple Cassandra Accounts via the CData Sync CLI
Replicate multiple Cassandra accounts to one or many databases.
-
Integrating Claude Code CLI with Amazon DynamoDB 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.
-
Replicate Multiple Zoom Accounts
Replicate multiple Zoom accounts to one or many databases.
-
How to Query Keap Data in MySQL Workbench
Execute MySQL queries against live Keap data from MySQL Workbench.
-
Integrate LibreChat with Live Google Search Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Google Search results from within the chat interface.
-
Use Claude to Talk to Your Jira Assets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Jira Assets data for you.
-
How to create DB2 federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for DB2 data in MySQL .
-
How to connect Amazon QuickSight to Workday Data
Create a connection to Workday data in CData Connect AI and insert Workday data into Amazon QuickSight SPICE to build interactive dashboards.
-
Build an OLAP Cube in SSAS from Harvest Data
Establish a connection to Harvest data data from SQL Server Analysis Services, and use the Harvest Data Provider to build OLAP cubes for use in analytics and reporting.
-
Getting Started with the CData ADO.NET Provider for Google Translate
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to CouchDB from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from CouchDB data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Operational Reporting on Figshare Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Figshare data.
-
Connect to Intercom Data in Jaspersoft Studio
Execute SQL to remote Intercom data in Jaspersoft Studio.
-
Integrate Sendwithus with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Sendwithus with External Services.
-
Connect ActiveCampaign to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ActiveCampaign with IBM WebSphere for seamless data integration and connectivity.
-
Migrating data from MariaDB to Google BigQuery using CData SSIS Components.
Easily push MariaDB data to Google BigQuery using the CData SSIS Tasks for MariaDB and Google BigQuery.
-
How to integrate MariaDB with Apache Airflow
Access and process MariaDB data in Apache Airflow using the CData JDBC Driver.
-
Automated Continuous SAP SuccessFactors Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SAP SuccessFactors replication to Apache Kafka.
-
Build Semantic Layer Views for AdRoll Data in APOS Live Data Gateway
Use the CData Connector for AdRoll in APOS Live Data Gateway to build Semantic Layer Views for AdRoll data.
-
How to connect to QuickBooks Online Data with Squirrel SQL client
Connect to QuickBooks Online data and execute queries in the Squirrel SQL Client.
-
A PostgreSQL Interface for Short.io Data (MySQL Remoting via JDBC)
Use the Remoting features of the Short.io JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Active Directory Data in RapidMiner
Integrate Active Directory data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Query RabbitMQ Data in MySQL Workbench
Execute MySQL queries against live RabbitMQ data from MySQL Workbench.
-
Getting Started with the CData ODBC Driver for JotForm
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for JotForm.
-
Build Agents in Relevance AI with Access to Live NetSuite Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on NetSuite data within intelligent agent workflows.
-
Write a Simple Go Application to work with Box Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Box data.
-
Visualize Live Keap Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Keap data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to integrate Metabase with Adobe Target Data
Use CData Connect AI to connect to live Adobe Target data and create an interactive dashboard in Metabase from Adobe Target data.
-
Connect to Close Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Close to connect to Close data and execute queries in PowerBuilder.
-
How to create Microsoft Ads federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Microsoft Ads data in MySQL .
-
Getting Started with the CData Python Connector for Google Cloud Storage
Learn to install and license the CData Python Connector and configure a connection to live Google Cloud Storage data.
-
Build AI/ML Models with Live Avaza Data using Dataiku
Connect Avaza Data with Dataiku using the CData API Driver for JDBC.
-
Automated Continuous SAP Ariba Procurement Replication to Snowflake
Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to Snowflake.
-
Automated Continuous GraphQL Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable GraphQL replication to Google BigQuery.
-
Build Automated Workflows with Live Teradata Data in Workato
Use CData Connect AI to connect to live Teradata data and build automated workflows in Workato.
-
Visualize Clockify Data in TIBCO Spotfire through ADO.NET
Integrate Clockify data into dashboards in TIBCO Spotfire.
-
Integrate Pipeliner CRM Data in Pentaho Data Integration
Build ETL pipelines based on Pipeliner CRM data in the Pentaho Data Integration tool.
-
How to use SQLAlchemy ORM to access Tally Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Tally data.
-
Integrating LlamaIndex with BigCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on BigCommerce data in real time.
-
Access Printful Data from MySQL in PHP
Connect to Printful through the standard MySQL libraries in PHP.
-
Build LDAP-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to LDAP Objects from Zoho Analytics and import live LDAP objects.
-
Build Agents in Relevance AI with Access to Live Oracle Eloqua Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Oracle Eloqua data within intelligent agent workflows.
-
Integrating Cursor with ZohoSubscriptions 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.
-
Automated Continuous SuiteCRM Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SuiteCRM replication to Google BigQuery.
-
Integrating GitHub Copilot with Zoho Inventory 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.
-
Bind Live OData Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live OData data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Import and Visualize Blackbaud FE NXT Data in Power View
Create data visualizations based on Blackbaud FE NXT data in Excel.
-
Use Agno to Talk to Your Salesforce Pardot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Salesforce Pardot data for you.
-
Getting Started with the CData JDBC Driver for Marketo
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Marketo.
-
Build Dashboards with Mixpanel Data in DBxtra
Create dynamic dashboards and perform analytics based on Mixpanel data in DBxtra.
-
Excel Spreadsheet Automation on SAP SuccessFactors LMS Data with the QUERY Formula
Pull data from SAP SuccessFactors LMS, automate spreadsheets, and more with the QUERY formula.
-
Connect Highrise to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Highrise with IBM WebSphere for seamless data integration and connectivity.
-
Visualize Live SendGrid Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SendGrid data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Replicate EmailOctopus Data in Heroku for Use in Salesforce Connect
Replicate EmailOctopus data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Migrating data from HelloSign to Snowflake using CData SSIS Components.
Easily push HelloSign data to Snowflake using the CData SSIS Tasks for HelloSign and Snowflake.
-
Integrating NASA Data in Talend Cloud Data Management Platform
Connect NASA Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Create Reports with Contentful Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Contentful data.
-
Connect Certinia to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Certinia data using the CData Python MCP Server.
-
Migrating data from Wave Financial to Databricks using CData SSIS Components.
Easily push Wave Financial data to Databricks using the CData SSIS Tasks for Wave Financial and Databricks.
-
Analyze Outreach.io Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Outreach.io data with the CData JDBC Driver for Outreach.io.
-
Build Charts with Excel Data in Clear Analytics
Create dynamic charts and perform analytics based on Excel data in Clear Analytics.
-
Automated Discourse Data Replication to Teradata
Use CData Sync to Customize and automate Discourse data replication to Teradata.
-
Automated Continuous Amazon Athena Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Amazon Athena replication to AlloyDB.
-
Automated Continuous Sugar CRM Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Sugar CRM replication to Amazon Redshift.
-
Integrate Authorize.Net Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Authorize.Net data and integrate live Authorize.Net data into your Power Automate tasks.
-
How to Work with Odoo Data in AWS Glue Jobs Using JDBC
Connect to Odoo from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Back Up Campaigner data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Campaigner data data.
-
Replicate Discord Data in Heroku for Use in Salesforce Connect
Replicate Discord data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Explore Geographical Relationships in Yelp Data with Power Map
Create data visualizations with Yelp data in Power Map.
-
Connect to Wrike from a Connection Pool in WebLogic
Use the CData JDBC Driver for Wrike to connect to Wrike data from Web applications running on WebLogic.
-
Integrate Live Bitly Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Bitly data from within the IDE.
-
Use Grok to Talk to Your SAP HANA XS Advanced Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your SAP HANA XS Advanced data for you.
-
Automated Continuous Instagram Replication to Snowflake
Use CData Sync for automated, continuous, customizable Instagram replication to Snowflake.
-
Create Informatica Mappings From/To a JDBC Data Source for Sage 300
Create Sage 300 data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Choosing the Best Method to Connect ConstantContact to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ConstantContact data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Getting Started with the CData Tableau Connector for Excel Online
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Excel Online.
-
Connect and Query Live ZohoExpense Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live ZohoExpense data into Databricks and enable direct, live querying and analysis without replication.
-
Create Informatica Mappings From/To an ODBC Data Source for Reckon Accounts Hosted
Create an ODBC connection to Reckon Accounts Hosted in Informatica and browse and transfer Reckon Accounts Hosted data.
-
Write a Simple Go Application to work with Google Tasks Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Google Tasks data.
-
Query Suadeo Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Suadeo data from Node.js.
-
Search External Authorize.Net Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Authorize.Net data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Authorize.Net Data objects that you can access from apps and the dashboard.
-
A PostgreSQL Interface for Oracle Data using the CData ODBC Driver
Use the SQL Gateway and Oracle ODBC Driver to create a PostgreSQL entry-point for data access.
-
Moving Data from SAP SuccessFactors to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SAP SuccessFactors data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.