CData Software - Knowledge Base
Recent Articles
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Oracle Eloqua Reporting
Provide connectivity to Oracle Eloqua Reporting data through an SAP BusinessObjects universe.
-
Build Impala-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Impala data and build web apps with connectivity to live Impala data.
-
Analyze Float Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Float data with the CData JDBC Driver for Float.
-
Automated Continuous Pipeliner CRM Replication to SQLite
Use CData Sync for automated, continuous, customizable Pipeliner CRM replication to SQLite.
-
Access Live Klaviyo Data in Excel 365 Online (Excel for the web)
Connect to Klaviyo data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Automated Continuous Asana Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Asana replication to IBM DB2.
-
Integrating LlamaIndex with Dropbox Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Dropbox data in real time.
-
How to Easily Query Adobe Commerce Data in OpenOffice Base
Connect to Adobe Commerce data in OpenOffice Base using the CData ODBC Driver for Adobe Commerce and generate reports with live data insights.
-
Automated Continuous Coda Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Coda replication to Amazon Redshift.
-
Integrate Dify with Live ServiceNow 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 ServiceNow data.
-
Integrate Open WebUI with Live Instagram Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Instagram data from within the chat interface.
-
Integrating Claude Code CLI with Typeform 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.
-
Analyze Snapchat Ads Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Snapchat Ads data and visualize Snapchat Ads data in SAP Analytics Cloud.
-
Create Reckon-Connected Applications in Appsmith
Connect to Reckon Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Reckon data.
-
Connect to BigCommerce Data in Ruby
Connect to BigCommerce data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to SendPulse Data in RazorSQL
Connect to SendPulse from wizards and query SendPulse data from the GUI in the RazorSQL database management tool.
-
Explore Geographical Relationships in ServiceNow Data with Power Map
Create data visualizations with ServiceNow data in Power Map.
-
Connect to Mailgun Data in ACL Analytics
Connect to Mailgun data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Mailgun data.
-
Getting Started with the CData ADO.NET Provider for Pingdom
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Migrating data from Cvent to Google BigQuery using CData SSIS Components.
Easily push Cvent data to Google BigQuery using the CData SSIS Tasks for Cvent and Google BigQuery.
-
Bridge Box Connectivity with Apache NiFi
Access and process Box data in Apache NiFi using the CData JDBC Driver.
-
Integrate OpenCode with Live ADP Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live ADP data from within your AI coding agent.
-
Integrate Live Zoho Books Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Zoho Books data to Blue Prism using the CData ODBC Driver for Zoho Books to create automated workflows for repetitive business tasks.
-
Import IBM Cloud Object Storage Data Using Azure Data Factory
Use CData Connect AI to connect to IBM Cloud Object Storage Data from Azure Data Factory and import live IBM Cloud Object Storage data.
-
Replicate Multiple Dotmailer Accounts
Replicate multiple Dotmailer accounts to one or many databases.
-
Connect to and Query Amazon DynamoDB Data in QlikView over ODBC
Create data visualizations with Amazon DynamoDB data in QlikView.
-
How to connect and process Codat data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Codat data.
-
How to connect PolyBase to PhantomBuster
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live PhantomBuster data.
-
Connect to Greenhouse Data from Crystal Reports
Use CData Connect AI to connect to and report on live Greenhouse data from Crystal Reports.
-
Connect to OData Services in CloverDX (formerly CloverETL)
Transfer OData services using the visual workflow in the CloverDX data integration tool.
-
How to import Microsoft OneDrive Data into Apache Solr
Use the CData Software JDBC Driver for Microsoft OneDrive in Data Import Handler and create an automated import of Microsoft OneDrive data to Apache Solr Enterprise Search platform.
-
Connect and Query Live Shippo Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Shippo data into Databricks and enable direct, live querying and analysis without replication.
-
Use Agno to Talk to Your Salesforce Data 360 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 Data 360 data for you.
-
Access Live Phoenix Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Phoenix data from your Excel spreadsheets.
-
Connect BigQuery to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live BigQuery data using the CData Python MCP Server.
-
How to Use a Microsoft Access Database to Update Act-On Data in Real Time
Update Act-On data by creating a linked table in Microsoft Access with the CData Act-On ODBC Driver.
-
Replicate Multiple Telegram Accounts
Replicate multiple Telegram accounts to one or many databases.
-
Model, Search, and Visualize Live Kintone Data in ThoughtSpot
Use CData Connect AI to connect to live Kintone data for modeling, searching, and visualizing.
-
Work with Demio Data in FoxPro
Load Demio data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Parallel Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Parallel and the SQL Gateway to access Parallel data from Google Apps Script.
-
How to update Pipedrive from Excel
This article explains how to transfer data from Excel to Pipedrive using the Excel Add-In for Pipedrive.
-
Use Biml to Build SSIS Tasks to Replicate Marketo Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Marketo data to SQL Server.
-
Connecting Pipedream with IBM Informix Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on IBM Informix data in real time.
-
Use the CData Software ODBC Driver for ShipEngine in MicroStrategy Desktop
Connect to ShipEngine data in MicroStrategy Desktop using the CData Software ODBC Driver for ShipEngine.
-
Connect to IBM Informix Data from a Connection Pool in JBoss
Integrate IBM Informix data into Java servlets: Use the Management Console in JBoss to install the IBM Informix JDBC Driver.
-
Automated Snapchat Ads Data Replication to Teradata
Use CData Sync to Customize and automate Snapchat Ads data replication to Teradata.
-
Create Informatica Mappings From/To a JDBC Data Source for Neo4J
Create Neo4J data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Access Bright Data Data from MySQL in PHP
Connect to Bright Data through the standard MySQL libraries in PHP.
-
Import Real-Time Beeminder Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Beeminder data in ColdFusion.
-
Visualize Smartsheet Data in TIBCO Spotfire through ADO.NET
Integrate Smartsheet data into dashboards in TIBCO Spotfire.
-
Connect to Perplexity Data in JRuby
Create a simple JRuby app with access to live Perplexity data.
-
Rapidly Develop BigQuery-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 BigQuery.
-
Publish ChargeOver-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ChargeOver data.
-
Consume Google Sheets OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Google Sheets feeds that reflect any changes in SAP Lumira.
-
How to connect to SAP Ariba Procurement Data from Spring Boot
Connect to SAP Ariba Procurement in a Spring Boot Application using the CData JDBC Driver for SAP Ariba Procurement
-
Access Live SAP SuccessFactors LMS Data in AWS Lambda
Connect to live SAP SuccessFactors LMS data in AWS Lambda using the CData JDBC Driver.
-
Query Ontraport Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Ontraport data from Node.js.
-
How to connect to Instagram Data in DBVisualizer
Integrate Instagram data with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrating Dataiku with Azure Synapse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Azure Synapse data.
-
Working with Oracle Service Cloud Data in LINQPad
Execute LINQ queries to Oracle Service Cloud data in LINQPad.
-
Build an OLAP Cube in SSAS from Amplitude Data
Establish a connection to Amplitude data data from SQL Server Analysis Services, and use the Amplitude Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connecting Mastra with NetSuite 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 NetSuite data, no replication required.
-
Object-Relational Mapping (ORM) with YouTube Analytics 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 YouTube Analytics data into a Java-based ORM framework, Hibernate.
-
Integrate Cursor with Live TaxJar Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live TaxJar data from within the editor.
-
Integrate Theia IDE with Live SurveyMonkey 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 SurveyMonkey data from within the development environment.
-
How to publish and share Browserless Data dashboards with Tableau Server
The CData ODBC driver for Browserless enables you integrate Browserless data into Tableau dashboards.
-
Integrate with live HDFS Data in Jitterbit
Use CData Connect AI to connect to and integrate live HDFS data in Jitterbit.
-
Integrating Antigravity CLI with SparkPost data via CData CLI
Connect SparkPost data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to connect to Asana Data in DBVisualizer
Integrate Asana data with visual data analysis tools and data connection wizards in DBVisualizer
-
Replicate Multiple Printful Accounts
Replicate multiple Printful accounts to one or many databases.
-
How to connect to SingleStore Data from Spring Boot
Connect to SingleStore in a Spring Boot Application using the CData JDBC Driver for SingleStore
-
How to Create Power BI Visual Reports with Real-Time Hacker News Data
Use CData Power BI Connectors to visualize Hacker News data in Power BI.
-
How to create Visio diagrams from SAP Hybris C4C Data
Automatically update SAP Hybris C4C data with the changes you make to Visio master shapes.
-
Automated Continuous MarkLogic Replication to Databricks
Use CData Sync for automated, continuous, customizable MarkLogic replication to Databricks.
-
Work with CSV Data in FoxPro
Load CSV data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automate Oracle Eloqua Reporting Data Replication to Azure Data Lake
Use CData Sync to customize and automate Oracle Eloqua Reporting data replication to Azure Data Lake.
-
Automated Continuous Qualaroo Replication to Snowflake
Use CData Sync for automated, continuous, customizable Qualaroo replication to Snowflake.
-
Integrate Eventbrite Data in Pentaho Data Integration
Build ETL pipelines based on Eventbrite data in the Pentaho Data Integration tool.
-
Creating PostgreSQL-Connected Applications in Unqork
You can use CData Connect AI to feed PostgreSQL data to Unqork and build custom business apps.
-
Automated VWO Data Replication to Teradata
Use CData Sync to Customize and automate VWO data replication to Teradata.
-
How to connect Amazon QuickSight to Google Calendar Data
Create a connection to Google Calendar data in CData Connect AI and insert Google Calendar data into Amazon QuickSight SPICE to build interactive dashboards.
-
How to Connect to Live Shopify Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Shopify data securely in real time.
-
Replicate Workday Data from PowerShell
Write a quick PowerShell script to query Workday data. Use connectivity to the live data to replicate Workday data to SQL Server.
-
Connect to SingleStore Data in Jaspersoft Studio
Execute SQL to remote SingleStore data in Jaspersoft Studio.
-
Create Reports with Greenhouse Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Greenhouse data.
-
Explore Geographical Relationships in ChargeOver Data with Power Map
Create data visualizations with ChargeOver data in Power Map.
-
Integrate Zoho Projects Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Zoho Projects data from Informatica Cloud.
-
Use Biml to Build SSIS Tasks to Replicate Oracle Eloqua Reporting Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Oracle Eloqua Reporting data to SQL Server.
-
Use the CData Software ODBC Driver for Hacker News in MicroStrategy
Connect to Hacker News data in MicroStrategy Developer using the CData Software ODBC Driver for Hacker News.
-
Integrate with Dynamics NAV Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Dynamics NAV data to a JSON file on disk.
-
Automated Continuous Clockify Replication to Vertica
Use CData Sync for automated, continuous, customizable Clockify replication to Vertica.
-
Analyze Freshservice Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Freshservice data in Microsoft R Open.
-
Automate OnePageCrm Data Replication to Couchbase
Use CData Sync to Customize and automate OnePageCrm data replication to Couchbase.
-
Natively Connect to Active Directory Data in PHP
The CData ODBC driver for Active Directory enables you to create PHP applications with connectivity to Active Directory data. Leverage the native support for ODBC in PHP.
-
Access Live QuickBooks Online 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 QuickBooks Online data through MCP integration.
-
Automated Continuous API Replication to MySQL
Use CData Sync for automated, continuous, customizable API replication to MySQL.
-
Connect to Copper Data in Ruby
Connect to Copper data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Kintone Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Kintone replication to Apache Cassandra.
-
Import Real-Time Superchat Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Superchat data in ColdFusion.
-
Connect to Procore Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Procore Data and connect to Procore data in Akorbi Digital RunMyProcess.