CData Software - Knowledge Base
Recent Articles
-
Integrate SAP Ariba Procurement with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SAP Ariba Procurement with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SAP Ariba Procurement data.
-
Integrate Instantly with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Instantly with External Services.
-
How to connect to SAP Business One Data in DBVisualizer
Integrate SAP Business One data with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Semantic Layer Views for Figshare Data in APOS Live Data Gateway
Use the CData Connector for Figshare in APOS Live Data Gateway to build Semantic Layer Views for Figshare data.
-
Automate Onfleet Data Replication to Azure Data Lake
Use CData Sync to customize and automate Onfleet data replication to Azure Data Lake.
-
Integrating Claude Code CLI with Basecamp 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.
-
Integrate Live SAP Hybris C4C Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SAP Hybris C4C data to Blue Prism using the CData ODBC Driver for SAP Hybris C4C to create automated workflows for repetitive business tasks.
-
Prepare, Blend, and Analyze MySQL Data in Alteryx Designer (ODBC)
Build workflows to access live MySQL data for self-service data analytics.
-
Create SSAS Tabular Models from Google Search Results
How to build a SQL Server Analysis Service Tabular Model from Google Search results using CData drivers.
-
Connect to Amazon DynamoDB Data from a Connection Pool in Jetty
The Amazon DynamoDB JDBC Driver supports connection pooling: This article shows how to connect faster to Amazon DynamoDB data from Web apps in Jetty.
-
Automated Continuous Paddle Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Paddle replication to delimited files (CSV/TSV).
-
Integrating GitHub Copilot with Google Drive 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.
-
Connect to Cosmos DB Data in DBeaver
Use the CData ODBC Driver to connect to Cosmos DB data in DBeaver.
-
Connect Contentful to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Contentful data using the CData Python MCP Server.
-
Excel Spreadsheet Automation on Exact Online Data with the QUERY Formula
Pull data from Exact Online, automate spreadsheets, and more with the QUERY formula.
-
How to Connect to Live Redshift Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Redshift data through natural language.
-
Create Dynamic Act-On Grids Using the Infragistics XamDataGrid
Learn how you can connect Act-On to Infragistics XamDataGrid to build dynamic grids.
-
How to Connect DBeaver to Dotmailer via a JDBC Driver
Manage Dotmailer data with visual tools in DBeaver like the query browser.
-
How to Seamlessly Import OneNote Data into IBM SPSS Modeler
Integrate OneNote data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Query ClickUp Data in MySQL Workbench
Execute MySQL queries against live ClickUp data from MySQL Workbench.
-
Analyze Impala Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Impala data and visualize Impala data in SAP Analytics Cloud.
-
Integrate Open WebUI with Live Sybase IQ Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Sybase IQ data from within the chat interface.
-
Access Live Epicor Kinetic Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Epicor Kinetic data from your Excel spreadsheets.
-
Import Real-Time Reckon Accounts Hosted Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Reckon Accounts Hosted data in ColdFusion.
-
Manage SharePoint Excel Services Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SharePoint Excel Services.
-
Migrating data from ZeroBounce to Snowflake using CData SSIS Components.
Easily push ZeroBounce data to Snowflake using the CData SSIS Tasks for ZeroBounce and Snowflake.
-
Getting Started with the CData JDBC Driver for Kafka
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Kafka.
-
Using the CData Data Providers with the DevExpress Data Grid
The CData ADO.NET providers are standards-based libraries that can be used with various third-party components and tools. This article shows how to use the CData ADO.NET Provider for Salesforce with the DevExpress Chart Control.
-
Build Automated Attio-Connected Workflows in Zapier
Use CData Connect AI to connect to live Attio data and build automated workflows in Zapier.
-
Connect to Amazon DynamoDB Data in DBeaver
Use the CData ODBC Driver to connect to Amazon DynamoDB data in DBeaver.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for MarkLogic
Provide connectivity to MarkLogic data through an SAP BusinessObjects universe.
-
Use the CData Software ODBC Driver for Paylocity in SAS for Real-Time Reporting and Analytics
Connect to real-time Paylocity data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Paylocity.
-
Write a Simple Go Application to work with ZohoSubscriptions Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ZohoSubscriptions data.
-
Access Live SAP Business Warehouse Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SAP Business Warehouse data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build an OLAP Cube in SSAS from Paddle Data
Establish a connection to Paddle data data from SQL Server Analysis Services, and use the Paddle Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Connect to Live SQL Analysis Services Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your SQL Analysis Services data for you.
-
Use Agno to Talk to Your Zoho Inventory 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 Zoho Inventory data for you.
-
Visualize Live Instantly Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Instantly data.
-
Connect to Oracle Eloqua Reporting Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Oracle Eloqua Reporting.
-
Automated Continuous Keap Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Keap data replication to OneLake in Microsoft Fabric.
-
Replicate Box Data from PowerShell
Write a quick PowerShell script to query Box data. Use connectivity to the live data to replicate Box data to SQL Server.
-
Automated Continuous Kafka Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Kafka replication to IBM DB2.
-
Automated Continuous Exact Online Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Exact Online replication to Apache Cassandra.
-
Use the CData SSIS Components to Insert New or Update Existing PostgreSQL Records from SQL Server
Easily push SQL Server data to PostgreSQL using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into PostgreSQL or update existing records with data from a SQL Server database.
-
Connect to Bright Data Data from PowerBuilder via ADO.NET
This article demonstrates how to access Bright Data data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to Connect to Live Apollo Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Apollo data for you.
-
Use Claude to Talk to Your CockroachDB 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 CockroachDB data for you.
-
Automated Continuous Aweber Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Aweber replication to delimited files (CSV/TSV).
-
Consume Amazon DynamoDB OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Amazon DynamoDB feeds that reflect any changes in SAP Lumira.
-
Host the API Server on Amazon EC2
Host the Windows and Java editions of an API Server on Amazon EC2.
-
Build Visualizations of Missive Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Missive data in Birst.
-
Access Live Bitbucket Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Bitbucket data into the statistical analysis tools available in SAS JMP. This article shows how to use Bitbucket data in the Graph Builder and Query Builder.
-
Automated Continuous Accelo Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Accelo replication to AlloyDB.
-
How to create an RPA flow for ScrapingBee Data in UiPath Studio
Use the ScrapingBee ODBC Driver to create workflows that access real-time ScrapingBee data without any coding.
-
Add Lakebase Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Lakebase with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automate Okta Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Okta data from PowerShell? This article demonstrates how to utilize the Okta Cmdlets for tasks like connecting to Okta data, automating operations, downloading data, and more.
-
Validate Google Ad Manager Data with QuerySurge
Access and validate Google Ad Manager data in QuerySurge using the CData JDBC Driver.
-
Automated Continuous Yelp Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Yelp replication to Google Cloud SQL.
-
Migrating data from SAP Ariba Source to Google BigQuery using CData SSIS Components.
Easily push SAP Ariba Source data to Google BigQuery using the CData SSIS Tasks for SAP Ariba Source and Google BigQuery.
-
How to Create Power BI Visual Reports with Real-Time Sugar CRM Data
Use CData Power BI Connectors to visualize Sugar CRM data in Power BI.
-
Create Jira-Connected Business Apps in AppSheet
Connect to Jira Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Jira data.
-
Prepare, Blend, and Analyze LightSpeedRetail Data in Alteryx Designer (ODBC)
Build workflows to access live LightSpeedRetail data for self-service data analytics.
-
Build Semantic Layer Views for Jira Assets Data in APOS Live Data Gateway
Use the CData Connector for Jira Assets in APOS Live Data Gateway to build Semantic Layer Views for Jira Assets data.
-
Create GraphQL-Connected Applications in Appsmith
Connect to GraphQL Data via CData Connect AI in Appsmith and create custom business applications with real-time access to GraphQL data.
-
Access Live Salesforce Marketing Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Salesforce Marketing data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Analyze Bitbucket Data in Cognos Analytics
Use CData Connect AI to connect to Bitbucket Data from Cognos Analytics and analyze live Bitbucket data.
-
Create Salesforce Pardot-Connected Dashboards in Grafana
Connect to Salesforce Pardot Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Salesforce Pardot data.
-
Automated Continuous Shopify Replication to SingleStore
Use CData Sync for automated, continuous, customizable Shopify replication to SingleStore.
-
Connect to PabblySubscriptions Data in CloverDX (formerly CloverETL)
Transfer PabblySubscriptions data using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous ZohoSubscriptions Replication to MySQL
Use CData Sync for automated, continuous, customizable ZohoSubscriptions replication to MySQL.
-
How to Query Freshsales Data in MySQL Workbench
Execute MySQL queries against live Freshsales data from MySQL Workbench.
-
Seamlessly Bring Greenplum Data into Retool Using CData Connect AI
Integrate Greenplum data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
View Reports on Real-Time Google Forms Data in Power BI Report Server
Use the CData ODBC Driver for Google Forms to visualize Google Forms data in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to MongoDB Data in Google Apps Script via Connect AI
Use CData Connect AI to access MongoDB data in Google Apps Script.
-
Getting Started with the CData ODBC Driver for Twilio
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Twilio.
-
Automated Continuous Google Tasks Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Google Tasks replication to Google Cloud SQL.
-
Automated Continuous Azure Blob Storage Replication to MySQL
Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to MySQL.
-
How to Connect the Power BI Service to Sage Cloud Accounting: Complete Guide
Connect to the CData Software Power BI Connector for Sage Cloud Accounting from PowerBI.com to provide real-time Sage Cloud Accounting data across the organization.
-
DataBind Controls to Google Cloud Storage Data in C++Builder
DataBind to Google Cloud Storage data in C++Builder with standard components and controls.
-
Connect to and Query PabblySubscriptions Data in QlikView over ODBC
Create data visualizations with PabblySubscriptions data in QlikView.
-
Work with PayPal Data in FoxPro
Load PayPal data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to ZohoDesk Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with ZohoDesk Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to create Adobe Analytics federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Adobe Analytics data in MySQL .
-
Migrating data from Sugar CRM to Snowflake using CData SSIS Components.
Easily push Sugar CRM data to Snowflake using the CData SSIS Tasks for Sugar CRM and Snowflake.
-
Publish Attio-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Attio data.
-
Connect to iContact Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live iContact data.
-
Integrating LangChain with Jira Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Jira data within automated workflows.
-
Import and Visualize TaxJar Data in Power View
Create data visualizations based on TaxJar data in Excel.
-
How to work with Timely Data in Apache Spark using SQL
Access and process Timely Data in Apache Spark using the CData Software JDBC Driver.
-
Easily Integrate CampaignMonitor Data in Lazarus Pascal IDE
Learn how to easily integrate live CampaignMonitor data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Sage 300 Data from a Connection Pool in JBoss
Integrate Sage 300 data into Java servlets: Use the Management Console in JBoss to install the Sage 300 JDBC Driver.
-
Query Live JSON Services in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live JSON services directly from the development environment.
-
View Reports on Real-Time Facebook Ads Data in Power BI Report Server
Use the CData ODBC Driver for Facebook Ads to visualize Facebook Ads data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to connect PolyBase to Sage 200
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Sage 200 data.
-
How to connect PolyBase to AlloyDB
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live AlloyDB data.
-
Analyze Grafana Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Grafana data with the CData JDBC Driver for Grafana.
-
How to connect SharePoint with Amazon DynamoDB Data through external lists
Provide Amazon DynamoDB data to SharePoint users as an external list.
-
Add Planio Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Planio with the Informatica Enterprise Data Catalog to classify and organize data.
-
Migrating data from Omnisend to Google BigQuery using CData SSIS Components.
Easily push Omnisend data to Google BigQuery using the CData SSIS Tasks for Omnisend and Google BigQuery.
-
Build Semantic Layer Views for Gong Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Gong data.