CData Software - Knowledge Base
Recent Articles
-
Integrate with SAS xpt Data in SnapLogic
Use CData Connect AI to connect to and integrate with live SAS xpt data in SnapLogic.
-
Use Agno to Talk to Your HBase 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 HBase data for you.
-
Integrating Codex with Shortcut 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 Microsoft Ads Data to Multiple Databases via the CData Sync CLI
Replicate Microsoft Ads data to disparate databases with a single configuration.
-
DataBind Charts to Short.io Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Short.io 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.
-
Access Live Adobe Commerce Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Adobe Commerce data from your Google Sheets.
-
Access Live MariaDB Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live MariaDB data from your Google Sheets.
-
How to Work with PhantomBuster Data in ETL Validator JDBC
Connect to PhantomBuster from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate Dify with Live Facebook Ads Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Facebook Ads data.
-
Connect to Avalara AvaTax Data in HULFT Integrate
Connect to Avalara AvaTax as a JDBC data source in HULFT Integrate
-
Visualize Qualaroo Data in Tableau
The CData ODBC driver for Qualaroo enables you integrate Qualaroo data into Tableau dashboards.
-
Build Dashboards with Phoenix Data in Dundas BI
Create dynamic dashboards and perform analytics based on Phoenix data in Dundas BI.
-
Integrate Airtable with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Airtable with External Services.
-
Automated Continuous Adobe Commerce Replication to SQLite
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to SQLite.
-
Prepare, Blend, and Analyze Notion Data in Alteryx Designer (Connect AI)
Build workflows to access live Notion data for self-service data analytics.
-
Enable the AdRoll JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with AdRoll data.
-
Build Pipelines with Live Slack Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Slack from Google Cloud Data Fusion, enabling the integration of live Slack data into the building and management of effective data pipelines.
-
Connect to Hugging Face Data in CloverDX (formerly CloverETL)
Transfer Hugging Face data using the visual workflow in the CloverDX data integration tool.
-
Connect Epicor Kinetic Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Epicor Kinetic data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Dynamics 365 Business Central Data in Jaspersoft Studio
Execute SQL to remote Dynamics 365 Business Central data in Jaspersoft Studio.
-
Extract, Transform, and Load ScrapingBee Data in Informatica PowerCenter
Create a simple Workflow for ScrapingBee data in Informatica PowerCenter.
-
Integrate Devin with Live Exact Online Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Exact Online data.
-
LINQ to Avalara AvaTax Data
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 Avalara AvaTax Data Provider.
-
Build Visualizations of Apollo Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Apollo data in Birst.
-
Integrate HubDB Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live HubDB data from Informatica Cloud.
-
Excel Spreadsheet Automation on DB2 Data with the QUERY Formula
Pull data from DB2, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous Front Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Front replication to Azure SQL Database.
-
Create Apps from ADP Data in Qlik Sense Cloud
Use CData Connect AI to connect to ADP Data and build apps from live ADP data in Qlik Sense Cloud.
-
Use the CData Software ODBC Driver for BenchmarkEmail in SAS for Real-Time Reporting and Analytics
Connect to real-time BenchmarkEmail data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for BenchmarkEmail.
-
Prepare, Blend, and Analyze Greenplum Data in Alteryx Designer (ODBC)
Build workflows to access live Greenplum data for self-service data analytics.
-
How to Access Google Calendar Data Using Entity Framework
This article shows how to access Google Calendar data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access Live VWO Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to VWO data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Configure the CData JDBC Driver for Apify in a Connection Pool in Tomcat
Connect to Apify data from a connection pool in Tomcat.
-
Connecting Mastra with MailChimp 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 MailChimp data, no replication required.
-
Build WooCommerce Visualizations in Tableau Cloud
Use CData Connect AI to connect to live WooCommerce data and build visualizations in Tableau Cloud.
-
Access Supabase Data from MySQL in PHP
Connect to Supabase through the standard MySQL libraries in PHP.
-
How to work with Front Data in Apache Spark using SQL
Access and process Front Data in Apache Spark using the CData Software JDBC Driver.
-
Use Biml to Build SSIS Tasks to Replicate Webflow Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Webflow data to SQL Server.
-
How to Connect to Live Perplexity Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Perplexity data for you.
-
Building Dynamic Web Pages with Hive Data Using AngularJS
Create single-page applications with live connectivity to Hive using the CData API Server.
-
Access Oracle Service Cloud Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Oracle Service Cloud data from your Oracle system.
-
Create Data Visualizations in Cognos BI with Act CRM Data
Access Act CRM data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Analyze ActiveCampaign Data in Cognos Analytics
Use CData Connect AI to connect to ActiveCampaign Data from Cognos Analytics and analyze live ActiveCampaign data.
-
Connect to and Query Scrapfly Data in QlikView over ODBC
Create data visualizations with Scrapfly data in QlikView.
-
Automated Continuous Factorial Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Factorial replication to PostgreSQL.
-
Build a Simple VCL Application for SAP SuccessFactors LMS Data
How to build a simple VCL Application to view SAP SuccessFactors LMS data in RAD Studio using the CData ODBC Driver for SAP SuccessFactors LMS.
-
Build Voice Agents in ElevenLabs with access to Live Jira Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Jira data.
-
Query Aweber Data as a SQL Server Database in Node.js
Execute SQL Server queries against Aweber data from Node.js.
-
Connect to LeadDesk Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to LeadDesk.
-
Build Data Flows from Salesloft to SQL Server using SSIS
Easily back up Salesloft data to SQL Server using the SSIS components for Salesloft.
-
Getting Started with the CData Tableau Connector for Twitter Ads
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Twitter Ads.
-
Integrating Codex with Dotmailer 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.
-
Natively Connect to HCL Domino Data in PHP
The CData ODBC driver for HCL Domino enables you to create PHP applications with connectivity to HCL Domino data. Leverage the native support for ODBC in PHP.
-
Integrate Theia IDE with Live SAP HANA 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 SAP HANA data from within the development environment.
-
DataBind Charts to ADP Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to ADP 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.
-
Provide OData Services of Google Drive Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Google Drive data by developing a WCF Service Application.
-
Connect to Notion Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Notion Data and connect to Notion data in Akorbi Digital RunMyProcess.
-
Connect to Google Tasks from a Connection Pool in WebLogic
Use the CData JDBC Driver for Google Tasks to connect to Google Tasks data from Web applications running on WebLogic.
-
Connecting GenSpark with Figshare Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Figshare data without any replication or custom integration required.
-
Use the CData Software JDBC Driver for Azure Analysis Services in MicroStrategy Web
Connect to Azure Analysis Services data in MicroStrategy Web using the CData Software JDBC Driver for Azure Analysis Services.
-
Build Automated MariaDB-Connected Workflows in Zapier
Use CData Connect AI to connect to live MariaDB data and build automated workflows in Zapier.
-
Integrating Claude Code CLI with Dynamics CRM 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.
-
Query Live Anaplan Data 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 Anaplan data directly from the development environment.
-
Build Charts with Customer.io Data in Clear Analytics
Create dynamic charts and perform analytics based on Customer.io data in Clear Analytics.
-
Visualize Pinecone Data in Sisense
Create an ElastiCube in Sisense app with access to Pinecone data.
-
Connect to BigCommerce Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for BigCommerce data in the Denodo Virtual DataPort Administrator.
-
Automate DB2 Data Replication to Azure Data Lake
Use CData Sync to customize and automate DB2 data replication to Azure Data Lake.
-
Validate Avaza Data with QuerySurge
Access and validate Avaza data in QuerySurge using the CData JDBC Driver.
-
Getting Started with the CData SSIS Components for Zoho Recruit
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Zoho Recruit.
-
Analyze Elasticsearch Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Elasticsearch data with the CData JDBC Driver for Elasticsearch.
-
Automated Continuous LinkedIn Replication to SingleStore
Use CData Sync for automated, continuous, customizable LinkedIn replication to SingleStore.
-
Getting Started with the CData SSIS Components for Anaplan
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Anaplan.
-
Connect to Live TaxJar Data in MicroStrategy through CData Connect AI
Create a live connection to TaxJar Data in CData Connect AI and connect to your TaxJar data from MicroStrategy.
-
Choosing the Best Method to Connect Sage 300 to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Sage 300 data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Provide OData Services of Facebook Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Facebook data by developing a WCF Service Application.
-
Consume xBase OData Feeds in SAP Lumira
Use the API Server to create data visualizations on xBase feeds that reflect any changes in SAP Lumira.
-
Connect to Harvest Data in JRuby
Create a simple JRuby app with access to live Harvest data.
-
Query PolarTeamPro Data through ODBC in Node.js
Use node-odbc to execute SQL queries against PolarTeamPro data from Node.js.
-
Integrating Boomi Agentstudio with Reckon Accounts Hosted Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Reckon Accounts Hosted data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to Phoenix from Asprova with CData Software ODBC Driver for Phoenix
This article shows how to connect faster to Phoenix data from Asprova.
-
How to Connect to Live Blackbaud FE NXT Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Blackbaud FE NXT data for you.
-
Manage ElevenLabs Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for ElevenLabs.
-
Integrate Real-Time Access to PingOne in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to PingOne data in real time.
-
Stream Exa Data into Apache Kafka Topics
Access and stream Exa data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrating Claude Code CLI with Pingdom 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.
-
Automate Mode Data Replication to Couchbase
Use CData Sync to Customize and automate Mode data replication to Couchbase.
-
How to Seamlessly Import Float Data into IBM SPSS Modeler
Integrate Float data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automate Presto Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Presto data from PowerShell? This article demonstrates how to utilize the Presto Cmdlets for tasks like connecting to Presto data, automating operations, downloading data, and more.
-
Create Datasets from Microsoft Dataverse in Domo Workbench and Build Visualizations of Microsoft Dataverse Data in Domo
Use the CData Software ODBC Driver for Microsoft Dataverse to create datasets from Microsoft Dataverse data in Domo Workbench and then build visualizations in the Domo service.
-
Analyze Live Apollo Data in SAS Viya
Use CData Connect AI to connect to Apollo data from SAS Viya and deploy self-service analytics using live Apollo data.
-
Integrating Dataiku with Kintone Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Kintone data.
-
Object-Relational Mapping (ORM) with Planio Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Planio data into a Java-based ORM framework, Hibernate.
-
Visualize CouchDB Data in TIBCO Spotfire through OData
Integrate CouchDB data into dashboards in TIBCO Spotfire.
-
Visualize Live Raisers Edge NXT Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Raisers Edge NXT data into custom reports in Power BI.
-
Excel Spreadsheet Automation on Oracle Financials Cloud Data with the QUERY Formula
Pull data from Oracle Financials Cloud, automate spreadsheets, and more with the QUERY formula.
-
Connect to Okta from Asprova with CData Software ODBC Driver for Okta
This article shows how to connect faster to Okta data from Asprova.
-
Visualize Live Oracle SCM Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Oracle SCM data.
-
Publish Crystal Reports on Exa Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Exa data.
-
Establish a Live Connection with PingOne Data using Tableau Bridge
The CData ODBC Driver for PingOne enables you to integrate live PingOne data into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous PayPal Replication to Oracle
Use CData Sync for automated, continuous, customizable PayPal replication to Oracle.