CData Software - Knowledge Base
Recent Articles
-
Integrating Claude Code CLI with Cohere 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 and Query Live BigQuery Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live BigQuery data into Databricks and enable direct, live querying and analysis without replication.
-
Access Live Yelp Data in Excel 365 Online (Excel for the web)
Connect to Yelp data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Integrate Cursor with Live Shortcut Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Shortcut data from within the editor.
-
Connect to SAP Netweaver Gateway Data in Ruby
Connect to SAP Netweaver Gateway data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate Google Spanner Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Google Spanner data from Informatica Cloud.
-
Analyze HubSpot Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of HubSpot data and visualize live HubSpot data in Infragistics Reveal.
-
Use the CData SSIS Components to Insert New or Update Existing Act-On Records from SQL Server
Easily push SQL Server data to Act-On using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Act-On or update existing records with data from a SQL Server database.
-
Query ZohoSubscriptions Data in ColdFusion
Write standard ColdFusion data access code to connect to ZohoSubscriptions data.
-
Create Informatica Mappings From/To a JDBC Data Source for Printify
Create Printify data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Provide OData Services of HDFS Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for HDFS data by developing a WCF Service Application.
-
Edit and Search External Dynamics 365 Business Central Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Dynamics 365 Business Central data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Dynamics 365 Business Central Data objects that you can access from apps and the dashboard.
-
Connect to IBM Informix Data in JRuby
Create a simple JRuby app with access to live IBM Informix data.
-
Build a Singer.io Tap for DocuSign With the CData Python Connector
Learn how to easily build a Singer.io Tap for live DocuSign data using the CData Python Connector.
-
Natively Connect to Presto Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Presto data. Leverage the native support for ODBC in PHP.
-
Natively Connect to Microsoft Entra ID Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Microsoft Entra ID data. Leverage the native support for ODBC in PHP.
-
Connect to Office 365 Data in Jaspersoft Studio
Execute SQL to remote Office 365 data in Jaspersoft Studio.
-
Automated Continuous HubDB Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable HubDB replication to Google Cloud SQL.
-
Analyze Live Google Ads Data in SAS Viya
Use CData Connect AI to connect to Google Ads data from SAS Viya and deploy self-service analytics using live Google Ads data.
-
Back Up MailerLite 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 MailerLite data data.
-
How to connect to Elorus Data from IntelliJ
Integrate connectivity to Elorus data with wizards in IntelliJ.
-
Visualize Live JSON Services in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live JSON services.
-
Connect to Oracle Financials Cloud Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Oracle Financials Cloud data.
-
Integrating Boomi Agentstudio with PingOne Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to PingOne data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Visualize Live BigCommerce Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live BigCommerce data.
-
Create Coinbase Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Coinbase data access from reports, embedded analytics, and more.
-
DataBind Controls to TaxJar Data in C++Builder
DataBind to TaxJar data in C++Builder with standard components and controls.
-
How to Connect the Power BI Service to Mixpanel: Complete Guide
Connect to the CData Software Power BI Connector for Mixpanel from PowerBI.com to provide real-time Mixpanel data across the organization.
-
Visualize Live SuiteCRM Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SuiteCRM data.
-
Connect to Certinia Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Certinia and the SQL Gateway to access Certinia data from Google Apps Script.
-
How to Connect to Live API 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 API data for you.
-
Replicate Multiple LinkedIn Ads Accounts
Replicate multiple LinkedIn Ads accounts to one or many databases.
-
How to work with SAP Netweaver Gateway Data in Apache Spark using SQL
Access and process SAP Netweaver Gateway Data in Apache Spark using the CData Software JDBC Driver.
-
Integrate Harvest Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Harvest data from Informatica Cloud.
-
How to Query Live Productboard Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Productboard data data in natural language using Python.
-
How to connect PolyBase to ZohoSubscriptions
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live ZohoSubscriptions data.
-
Getting Started with the CData Connect AI Python SDK for Hive
Install the CData Connect AI Python SDK to read and write live Hive data with standard DB-API 2.0 Python code.
-
Automated Continuous Miro Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Miro replication to AlloyDB.
-
Integrate Theia IDE with Live Egnyte 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 Egnyte data from within the development environment.
-
DataBind Parallel Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Parallel data to a chart.
-
Create Salesforce Data 360 Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Salesforce Data 360 from PowerBI.com to create Power BI Dataflows with real-time data.
-
Link Asana with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Asana data in Filemaker Pro for Mac or Windows.
-
How to integrate SendGrid with Apache Airflow
Access and process SendGrid data in Apache Airflow using the CData JDBC Driver.
-
Create SageHR-Connected Nintex Workflows
Use CData Connect AI to connect to SageHR Data from Nintex Workflow Cloud and build custom workflows using live SageHR data.
-
Replicate ShipStation Data to Multiple Databases
Replicate ShipStation data to disparate databases with a point-and-click configuration.
-
Build Automated Workflows with Live Greenplum Data in Workato
Use CData Connect AI to connect to live Greenplum data and build automated workflows in Workato.
-
Explore Geographical Relationships in Azure Synapse Data with Power Map
Create data visualizations with Azure Synapse data in Power Map.
-
Automated Continuous iContact Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable iContact replication to PostgreSQL.
-
Automated Continuous Facebook Ads Replication to Vertica
Use CData Sync for automated, continuous, customizable Facebook Ads replication to Vertica.
-
Analyze LinkedIn Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze LinkedIn data in Microsoft R Open.
-
Easily Integrate Excel Data in Lazarus Pascal IDE
Learn how to easily integrate live Excel data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to BigQuery Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for BigQuery data.
-
How to integrate FHIR with Apache Airflow
Access and process FHIR data in Apache Airflow using the CData JDBC Driver.
-
Link SendPulse with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SendPulse data in Filemaker Pro for Mac or Windows.
-
Use the CData Software JDBC Driver for Cassandra in MicroStrategy
Connect to Cassandra data in MicroStrategy Developer using the CData Software JDBC Driver for Cassandra.
-
Integrating Spotify Data in Talend Cloud Data Management Platform
Connect Spotify Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to Build an ETL App for Gumroad Data in Python with CData
Create ETL applications and real-time data pipelines for Gumroad data in Python with petl.
-
How to Use a Microsoft Access Database to Update CouchDB Data in Real Time
Update CouchDB data by creating a linked table in Microsoft Access with the CData CouchDB ODBC Driver.
-
Integrating Cursor with Zoho Creator 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 Everhour from a Connection Pool in WebLogic
Use the CData JDBC Driver for Everhour to connect to Everhour data from Web applications running on WebLogic.
-
DataBind Controls to Workable Data in C++Builder
DataBind to Workable data in C++Builder with standard components and controls.
-
Connect to FormSite Data from a Connection Pool in JBoss
Integrate FormSite data into Java servlets: Use the Management Console in JBoss to install the FormSite JDBC Driver.
-
Publish Crystal Reports on MariaDB Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date MariaDB data.
-
Analyze ShipStation Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of ShipStation data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build a Singer.io Tap for SAP With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SAP data using the CData Python Connector.
-
Getting Started with the CData Connect AI Python SDK for ZohoMarketingHub
Install the CData Connect AI Python SDK to read live ZohoMarketingHub data with standard DB-API 2.0 Python code.
-
How to Use a Microsoft Access Database to Update SAP Hybris C4C Data in Real Time
Update SAP Hybris C4C data by creating a linked table in Microsoft Access with the CData SAP Hybris C4C ODBC Driver.
-
How to Connect to Live SAP SuccessFactors LMS 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 SAP SuccessFactors LMS data for you.
-
How to Query ClickTime Data in MySQL Workbench
Execute MySQL queries against live ClickTime data from MySQL Workbench.
-
Automated Apify Data Replication to Teradata
Use CData Sync to Customize and automate Apify data replication to Teradata.
-
Replicate Salesforce Marketing Data to Multiple Databases
Replicate Salesforce Marketing data to disparate databases with a point-and-click configuration.
-
Build AI Agents with LinkedIn Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live LinkedIn data through CData Connect AI.
-
Access Missive Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Missive data from your Oracle system.
-
Create a Data Access Object for QuickBooks Time Data using JDBI
A brief overview of creating a SQL Object API for QuickBooks Time data in JDBI.
-
Connect to Microsoft Entra ID Data in ACL Analytics
Connect to Microsoft Entra ID data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Microsoft Entra ID data.
-
Use CData Connect AI to Access Salesforce Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Salesforce data in the Power Pivot business intelligence tool.
-
Write a Simple Go Application to work with Onfleet Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Onfleet data.
-
Automated Continuous Toggl Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Toggl replication to AlloyDB.
-
Build ShipEngine-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live ShipEngine data and build ShipEngine-connected web apps with Axios.
-
Link Google Ads with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Google Ads data in Filemaker Pro for Mac or Windows.
-
Query Avro Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Avro data from Node.js.
-
Automated Continuous Printify Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Printify replication to Apache Cassandra.
-
Integrating Antigravity CLI with Freshservice data via CData CLI
Connect Freshservice data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Use CData Connect AI to Access Adobe Analytics Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Adobe Analytics data in the Power Pivot business intelligence tool.
-
Connect to Accelo Data in Jaspersoft Studio
Execute SQL to remote Accelo data in Jaspersoft Studio.
-
Connect to and Visualize Live SAP HANA Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SAP HANA data.
-
How to Seamlessly Import Apollo Data into IBM SPSS Modeler
Integrate Apollo data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrating Cursor with Box 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 IBM Cloud Object Storage Data Replication to Couchbase
Use CData Sync to Customize and automate IBM Cloud Object Storage data replication to Couchbase.
-
Using the CData Software ODBC Driver for Perigon in PyCharm
Connect to Perigon as an ODBC data source in PyCharm using the CData Software ODBC Driver for Perigon.
-
Getting Started with the CData ODBC Driver for RSS
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for RSS.
-
How to Connect to RSS Feeds in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to RSS feeds. Leverage the pyodbc module for ODBC in Python.
-
Build Data Flows from SQL Server to MarkLogic through SSIS
Easily push SQL Server data to MarkLogic using the CData SSIS Tasks for MarkLogic.
-
DataBind Avaza Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Avaza data to a chart.
-
Replicate Multiple Google Contacts Accounts via the CData Sync CLI
Replicate multiple Google Contacts accounts to one or many databases.
-
Import Real-Time Amazon Marketplace Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Amazon Marketplace data in ColdFusion.
-
Build an OLAP Cube in SSAS from SingleStore Data
Establish a connection to SingleStore data data from SQL Server Analysis Services, and use the SingleStore Data Provider to build OLAP cubes for use in analytics and reporting.
-
Migrating data from Google Search to Snowflake using CData SSIS Components.
Easily push Google Search results to Snowflake using the CData SSIS Tasks for Google Search and Snowflake.
-
Connect to Sage Intacct Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Sage Intacct data in the Denodo Virtual DataPort Administrator.
-
Query Live DocuSign Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live DocuSign data through a conversational interface.