CData Software - Knowledge Base
Recent Articles
-
Build a PostgreSQL Interface for Contentful Data using the CData JDBC Driver
Use the Remoting features of the Contentful JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Exa Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Exa data.
-
Moving Data from Dotmailer to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Dotmailer data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate Live Sendwithus Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Sendwithus from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Sendwithus data.
-
How to Seamlessly Import Odoo Data into IBM SPSS Modeler
Integrate Odoo data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ClickTime
Provide connectivity to ClickTime data through an SAP BusinessObjects universe.
-
Connect to Oracle Service Cloud Data in CloverDX (formerly CloverETL)
Transfer Oracle Service Cloud data using the visual workflow in the CloverDX data integration tool.
-
Connecting Agentforce with Workday Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Workday data for you.
-
Write a Simple Go Application to work with Brex Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Brex data.
-
Access Email Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Email data from HeidiSQL.
-
Process & Analyze SAS Data Sets Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SAS Data Sets Data.
-
A PostgreSQL Interface for Amazon Athena Data (MySQL Remoting via JDBC)
Use the Remoting features of the Amazon Athena JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software JDBC Driver for Gumroad in MicroStrategy
Connect to Gumroad data in MicroStrategy Developer using the CData Software JDBC Driver for Gumroad.
-
Automate CockroachDB Data Replication to SAP HANA
Use CData Sync to customize and automate CockroachDB data replication to SAP HANA.
-
Connect Sage 300 to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Sage 300 data using the CData Python MCP Server.
-
Provide OData Services of Azure Synapse Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Azure Synapse data by developing a WCF Service Application.
-
Connect to Tavily Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Tavily.
-
ETL Everhour in Oracle Data Integrator
This article shows how to transfer Everhour data into a data warehouse using Oracle Data Integrator.
-
Migrating data from Klaviyo to Snowflake using CData SSIS Components.
Easily push Klaviyo data to Snowflake using the CData SSIS Tasks for Klaviyo and Snowflake.
-
Getting Started with the CData Excel Add-In for Oracle Eloqua Reporting
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Oracle Eloqua Reporting.
-
Use CData Connect AI to Access CapsuleCRM Data in Microsoft Power Pivot
Use CData Connect AI to connect to live CapsuleCRM data in the Power Pivot business intelligence tool.
-
Automate HCL Domino Data Replication to Couchbase
Use CData Sync to Customize and automate HCL Domino data replication to Couchbase.
-
Natively Connect to LaunchDarkly Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to LaunchDarkly data. Leverage the native support for ODBC in PHP.
-
Integrating Figshare Data in Talend Cloud Data Management Platform
Connect Figshare Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Work with Jumpseller Data in FoxPro
Load Jumpseller data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create Informatica Mappings From/To an ODBC Data Source for SparkPost
Create an ODBC connection to SparkPost in Informatica and browse and transfer SparkPost data.
-
DataBind Charts to MariaDB Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to MariaDB data 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.
-
Build Gong-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Gong data.
-
Back Up Adobe Experience Manager data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Adobe Experience Manager. In this article, we will employ an SSIS workflow to populate a database with Adobe Experience Manager data data.
-
Create Data Visualizations in Cognos BI with Pinterest Data
Access Pinterest data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build Pipedrive-Connected Apps in Choreo
Use CData Connect AI to connect to Pipedrive Data from Choreo and build custom apps using live Pipedrive data.
-
Getting Started with the CData Power BI Connector for Anaplan
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Anaplan.
-
Access Bitly Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Bitly data from your Oracle system.
-
Viewing Highrise Data in RAD Studio Data Explorer
How to view Highrise data in RAD Studio Data Explorer using the CData ODBC Driver for Highrise.
-
Integrating Claude Code CLI with GitHub 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.
-
Getting Started with the CData ADO.NET Provider for WordPress
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for WordPress.
-
Connect to IBM Cloud Object Storage Data in NetBeans
Connect to IBM Cloud Object Storage data in NetBeans with the data source configuration wizard.
-
Use Manus AI to Talk to Your MYOB AccountRight Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on MYOB AccountRight data.
-
How to connect Amazon QuickSight to LinkedIn Ads Data
Create a connection to LinkedIn Ads data in CData Connect AI and insert LinkedIn Ads data into Amazon QuickSight SPICE to build interactive dashboards.
-
Replicate Google Tasks Data to Multiple Databases via the CData Sync CLI
Replicate Google Tasks data to disparate databases with a single configuration.
-
Build Agents in Relevance AI with Access to Live Oracle Sales Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Oracle Sales data within intelligent agent workflows.
-
Automate CloudConvert Integration Tasks from PowerShell
Are you in search of a quick and easy way to access CloudConvert data from PowerShell? This article demonstrates how to utilize the CloudConvert Cmdlets for tasks like connecting to CloudConvert data, automating operations, downloading data, and more.
-
Integrate Live Amazon S3 Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Amazon S3 data to Blue Prism using the CData ODBC Driver for Amazon S3 to create automated workflows for repetitive business tasks.
-
How to Connect to Live Aweber 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 Aweber data through natural language.
-
Automate FreeAgent Data Replication to SAP HANA
Use CData Sync to customize and automate FreeAgent data replication to SAP HANA.
-
How to connect to Neo4J Data from Spring Boot
Connect to Neo4J in a Spring Boot Application using the CData JDBC Driver for Neo4J
-
Build Semantic Layer Views for Grafana Data in APOS Live Data Gateway
Use the CData Connector for Grafana in APOS Live Data Gateway to build Semantic Layer Views for Grafana data.
-
Build Visualizations of PolarTeamPro Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of PolarTeamPro data in Birst.
-
Integrate Theia IDE with Live Oracle HCM Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Oracle HCM Cloud data from within the development environment.
-
Process & Analyze Dynamics NAV Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Dynamics NAV Data.
-
Access Live Databricks Data in Excel 365 Online (Excel for the web)
Connect to Databricks data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Use the CData ODBC Driver for GetResponse in Microsoft Power Query
You can use the CData GetResponse ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import GetResponse data into Microsoft Power Query.
-
Access Live Invoiced Data in Coginiti Pro
Connect to and query live Invoiced data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrating Kiro with JDBC-ODBC Bridge 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.
-
Import and Visualize Hacker News Data in Power View
Create data visualizations based on Hacker News data in Excel.
-
Integrating LlamaIndex with SuiteCRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on SuiteCRM data in real time.
-
Connect to Hubstaff Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Hubstaff data in the Denodo Virtual DataPort Administrator.
-
Access Live Yelp Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Yelp data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create Reports with Highrise Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Highrise data.
-
Design BIRT Reports on BigCommerce Data
Provide current BigCommerce data to your embedded analytics.
-
Automated Continuous XML Replication to SQL Server
Use CData Sync for automated, continuous, customizable XML replication to SQL Server.
-
Automated Continuous Asana Replication to Vertica
Use CData Sync for automated, continuous, customizable Asana replication to Vertica.
-
Create Bitly Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Bitly from PowerBI.com to create Power BI Dataflows with real-time data.
-
Extract, Transform, and Load Nuclia Data in Informatica PowerCenter
Create a simple Workflow for Nuclia data in Informatica PowerCenter.
-
Build Semantic Layer Views for CockroachDB Data in APOS Live Data Gateway
Use the CData Connector for CockroachDB in APOS Live Data Gateway to build Semantic Layer Views for CockroachDB data.
-
Create Exa-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Exa Data from OutSystems and build custom enterprise apps using live Exa data.
-
Getting Started with the CData JDBC Driver for SharePoint Excel Services
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SharePoint Excel Services.
-
Access Odoo 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 Odoo data.
-
Use the CData Software ODBC Driver for ShipEngine in MicroStrategy Web
Connect to ShipEngine data in MicroStrategy Web using the CData Software ODBC Driver for ShipEngine.
-
Natively Connect to MailerLite Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to MailerLite data. Leverage the native support for ODBC in PHP.
-
Publish Reports with Campaigner Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Campaigner data.
-
Create Data Visualizations Based On Bitbucket Data in Mode
Use CData Connect AI to connect to Bitbucket Data from Mode and build visualizations using live Bitbucket data.
-
Integrate with Odoo Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Odoo data to a JSON file on disk.
-
Replicate Billsby Data in Heroku for Use in Salesforce Connect
Replicate Billsby data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Publish Reports with Adobe Target Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Adobe Target data.
-
Analyze CapsuleCRM Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze CapsuleCRM data in Microsoft R Open.
-
Create Apps from Hive Data in Qlik Sense Cloud
Use CData Connect AI to connect to Hive Data and build apps from live Hive data in Qlik Sense Cloud.
-
Automated Continuous Drip Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Drip replication to Apache Kafka.
-
Access Live Yelp Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Yelp data from your Google Sheets.
-
Extract, Transform, and Load Amazon Marketplace Data in Informatica PowerCenter
Create a simple Workflow for Amazon Marketplace data in Informatica PowerCenter.
-
Build Automated Act CRM-Connected Workflows in Zapier
Use CData Connect AI to connect to live Act CRM data and build automated workflows in Zapier.
-
Connecting Mastra with QuickBooks Online Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time QuickBooks Online data, no replication required.
-
Visualize Live Wrike Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Wrike data.
-
A PostgreSQL Interface for Paddle Data (MySQL Remoting via JDBC)
Use the Remoting features of the Paddle JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous CampaignMonitor Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable CampaignMonitor replication to Azure SQL Database.
-
Connect to Microsoft OneDrive 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 Microsoft OneDrive data.
-
Rapidly Develop HubDB-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by HubDB.
-
Process & Analyze Shopify Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Shopify Data.
-
Connect to SAP Netweaver Gateway Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SAP Netweaver Gateway to connect to SAP Netweaver Gateway data and execute queries in PowerBuilder.
-
How to connect to LinkedIn Ads Data from Spring Boot
Connect to LinkedIn Ads in a Spring Boot Application using the CData JDBC Driver for LinkedIn Ads
-
Interact with Live eBay Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live eBay data.
-
Integrate Toggl Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Toggl data and integrate live Toggl data into your Power Automate tasks.
-
Integrate Live RSS Feeds into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to RSS from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live RSS feeds.
-
Replicate Multiple Tally Accounts via the CData Sync CLI
Replicate multiple Tally accounts to one or many databases.
-
Integrating Dataiku with SurveyMonkey Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SurveyMonkey data.
-
How to Connect to & Open Missive Data in Microsoft Excel
This article uses the CData ODBC driver for Missive to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Kintone Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Kintone as an External Source in Dremio.
-
Feed SQL Analysis Services Data into FineReport
How to set SQL Analysis Services data as a JDBC data source in FineReport.
-
Getting Started with the CData ADO.NET Provider for Deel
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Create Power BI Reports on Real-Time Act-On Data
Use the CData ODBC Driver for Act-On to visualize Act-On data in Power BI Desktop.