CData Software - Knowledge Base
Recent Articles
-
Write a Simple Go Application to work with Twitter Ads Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Twitter Ads data.
-
Integrating Claude Code CLI with SparkPost 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 Live Microsoft Teams Data in SAS Viya
Use CData Connect AI to connect to Microsoft Teams data from SAS Viya and deploy self-service analytics using live Microsoft Teams data.
-
Feed SFTP Data into FineReport
How to set SFTP data as a JDBC data source in FineReport.
-
Integrate OpenCode with Live SAP Hybris C4C Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live SAP Hybris C4C data from within your AI coding agent.
-
Analyze SparkPost Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SparkPost from Power Pivot. You will use the Table Import Wizard to load SparkPost data. You can visually build the import query or use any SQL supported by the driver.
-
A PostgreSQL Interface for Spark Data (MySQL Remoting via JDBC)
Use the Remoting features of the Spark JDBC Driver to create a PostgreSQL entry-point for data access.
-
LINQ to Phoenix 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 Phoenix Data Provider.
-
Integrate ZohoMarketingHub Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ZohoMarketingHub data from Informatica Cloud.
-
Build AI/ML Models with Live Freshsales Data using Dataiku
Connect Freshsales Data with Dataiku using the CData API Driver for JDBC.
-
Create Datasets from Telegram in Domo Workbench and Build Visualizations of Telegram Data in Domo
Use the CData Software ODBC Driver for Telegram to create datasets from Telegram data in Domo Workbench and then build visualizations in the Domo service.
-
Getting Started with the CData Python Connector for Customer.io
Learn to install and license the CData Python Connector and configure a connection to live Customer.io data.
-
A PostgreSQL Interface for Jumpseller Data (MySQL Remoting via JDBC)
Use the Remoting features of the Jumpseller JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to ScrapingBee Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to ScrapingBee.
-
Publish GitLab-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live GitLab data.
-
Getting Started with the CData Tableau Connector for Wave Financial
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Wave Financial.
-
Create Datasets from REST in Domo Workbench and Build Visualizations of REST Data in Domo
Use the CData Software ODBC Driver for REST to create datasets from REST data in Domo Workbench and then build visualizations in the Domo service.
-
Access Live eBay Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live eBay data from your Excel spreadsheets.
-
How to publish and share Google Forms Data dashboards with Tableau Server
The CData ODBC driver for Google Forms enables you integrate Google Forms data into Tableau dashboards.
-
Object-Relational Mapping (ORM) with Humanity 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 Humanity data into a Java-based ORM framework, Hibernate.
-
Replicate Oracle Data to Multiple Databases
Replicate Oracle data to disparate databases with a point-and-click configuration.
-
Configure the CData JDBC Driver for Greenhouse in a Connection Pool in Tomcat
Connect to Greenhouse data from a connection pool in Tomcat.
-
Connect to Salesforce CRM Analytics Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Salesforce CRM Analytics as an External Source in Dremio.
-
PayPal Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to PayPal data through CData Connect AI using different applications and tools.
-
How to connect to Twilio Data in DBVisualizer
Integrate Twilio data with visual data analysis tools and data connection wizards in DBVisualizer
-
Access Avalara AvaTax Data from MySQL in PHP
Connect to Avalara AvaTax through the standard MySQL libraries in PHP.
-
How to Connect to Live Mailjet 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 Mailjet data through natural language.
-
Automated Continuous Coda Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Coda replication to AlloyDB.
-
Integrate Cursor with Live Google Search Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Google Search results from within the editor.
-
Integrate Cursor with Live Salesforce Marketing Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Salesforce Marketing data from within the editor.
-
Perform Batch Operations with BigQuery Data in Apache NiFi
Connect to BigQuery data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Add SingleStore Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SingleStore with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Supabase Data in Ruby
Connect to Supabase data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Guru Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Guru.
-
Connect to Copper Data in Jaspersoft Studio
Execute SQL to remote Copper data in Jaspersoft Studio.
-
Visualize Campaigner Data in TIBCO Spotfire through ADO.NET
Integrate Campaigner data into dashboards in TIBCO Spotfire.
-
Build AI Agents with Shopify 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 Shopify data through CData Connect AI.
-
Build Pipelines with Live ZohoExpense Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to ZohoExpense from Google Cloud Data Fusion, enabling the integration of live ZohoExpense data into the building and management of effective data pipelines.
-
Automated Continuous Productboard Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Productboard replication to Azure SQL Database.
-
Create Freshteam-Connected Business Apps in AppSheet
Connect to Freshteam Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Freshteam data.
-
Write a Simple Go Application to work with Webflow Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Webflow data.
-
Use the CData ODBC Driver for Anaplan in Microsoft Power Query
You can use the CData Anaplan ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Anaplan data into Microsoft Power Query.
-
Connect to MYOB AccountRight Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with MYOB AccountRight Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Automate ElevenLabs Data Replication to Azure Synapse
Use CData Sync to customize and automate ElevenLabs data replication to Azure Synapse.
-
Build an OLAP Cube in SSAS from SparkPost Data
Establish a connection to SparkPost data data from SQL Server Analysis Services, and use the SparkPost Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Pingdom Replication to SingleStore
Use CData Sync for automated, continuous, customizable Pingdom replication to SingleStore.
-
Viewing Jodoo Data in RAD Studio Data Explorer
How to view Jodoo data in RAD Studio Data Explorer using the CData ODBC Driver for Jodoo.
-
How to Query Live Anaplan Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Anaplan data data in natural language using Python.
-
Integrating Cursor with eBay 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 Power BI Connector for Amplitude
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Access Live FreshBooks Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate FreshBooks data into the statistical analysis tools available in SAS JMP. This article shows how to use FreshBooks data in the Graph Builder and Query Builder.
-
How to connect to Qualaroo Data with Squirrel SQL client
Connect to Qualaroo data and execute queries in the Squirrel SQL Client.
-
Replicate Multiple Placid Accounts
Replicate multiple Placid accounts to one or many databases.
-
Integrate Epicor Kinetic Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Epicor Kinetic data and integrate live Epicor Kinetic data into your Power Automate tasks.
-
Connecting GenSpark with Samanage Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Samanage data without any replication or custom integration required.
-
How to Connect to HubSpot Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to HubSpot data. Leverage the pyodbc module for ODBC in Python.
-
How to Connect to Live LDAP Objects from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your LDAP objects for you.
-
Validate Humanity Data with QuerySurge
Access and validate Humanity data in QuerySurge using the CData JDBC Driver.
-
Automated Continuous Excel Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Excel replication to Amazon S3.
-
Build MVC Applications with Connectivity to Moosend Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Moosend from an ASP.NET MVC application.
-
Object-Relational Mapping (ORM) with Basecamp 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 Basecamp data into a Java-based ORM framework, Hibernate.
-
Rapidly Develop Missive-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 Missive.
-
DataBind Controls to OnePageCrm Data in Delphi
DataBind to OnePageCrm data in Delphi with standard data access components and controls.
-
Create Power BI Reports on Real-Time Zuora Data
Use the CData ODBC Driver for Zuora to visualize Zuora data in Power BI Desktop.
-
Building Dynamic Web Pages with YouTube Analytics Data Using AngularJS
Create single-page applications with live connectivity to YouTube Analytics using the CData API Server.
-
How to work with Procore Data in Apache Spark using SQL
Access and process Procore Data in Apache Spark using the CData Software JDBC Driver.
-
Replicate Pinterest Data from PowerShell
Write a quick PowerShell script to query Pinterest data. Use connectivity to the live data to replicate Pinterest data to SQL Server.
-
Access Live ZohoExpense Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live ZohoExpense data through MCP integration.
-
Replicate WooCommerce Data from PowerShell
Write a quick PowerShell script to query WooCommerce data. Use connectivity to the live data to replicate WooCommerce data to SQL Server.
-
How to Visualize Azure Data Catalog Data in Python with pandas
Use pandas and other modules to analyze and visualize live Azure Data Catalog data in Python.
-
Create SSAS Tabular Models from Ontraport Data
How to build a SQL Server Analysis Service Tabular Model from Ontraport data using CData drivers.
-
How to create Visio diagrams from Amazon DynamoDB Data
Automatically update Amazon DynamoDB data with the changes you make to Visio master shapes.
-
How to work with GraphQL Data in Apache Spark using SQL
Access and process GraphQL Data in Apache Spark using the CData Software JDBC Driver.
-
How to Build an ETL App for Cassandra Data in Python with CData
Create ETL applications and real-time data pipelines for Cassandra data in Python with petl.
-
Build a Simple VCL Application for Discord Data
How to build a simple VCL Application to view Discord data in RAD Studio using the CData ODBC Driver for Discord.
-
Connect to Gmail Data in RazorSQL
Connect to Gmail from wizards and query Gmail data from the GUI in the RazorSQL database management tool.
-
Integrate Google's Vertex AI Agent with Live DocuSign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live DocuSign data within intelligent workflows.
-
Deploy the ADO.NET Provider for Printful on an SSRS Report Server
Connect to Printful data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Object-Relational Mapping (ORM) with ZohoSubscriptions 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 ZohoSubscriptions data into a Java-based ORM framework, Hibernate.
-
Integrating Tanda Data in Talend Cloud Data Management Platform
Connect Tanda Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Integrate Cline with Live Tavily Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Tavily data from within your IDE.
-
Use CData Connect AI to Access SAP Netweaver Gateway Data in Microsoft Power Pivot
Use CData Connect AI to connect to live SAP Netweaver Gateway data in the Power Pivot business intelligence tool.
-
Automate Omnisend Data Replication to Couchbase
Use CData Sync to Customize and automate Omnisend data replication to Couchbase.
-
How to connect Amazon QuickSight to WordPress Data
Create a connection to WordPress data in CData Connect AI and insert WordPress data into Amazon QuickSight SPICE to build interactive dashboards.
-
Connecting GenSpark with MySQL Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to MySQL data without any replication or custom integration required.
-
Replicate Multiple SendPulse Accounts via the CData Sync CLI
Replicate multiple SendPulse accounts to one or many databases.
-
Enable the Tavily JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Tavily data.
-
How to Work with iContact Data in ETL Validator JDBC
Connect to iContact from ETL Validator jobs using the CData Software JDBC Driver.
-
Access Live Sage Intacct Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Sage Intacct data from your Excel spreadsheets.
-
A PostgreSQL Interface for Salesforce Marketing Data using the CData ODBC Driver
Use the SQL Gateway and Salesforce Marketing ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to work with Everhour Data in Apache Spark using SQL
Access and process Everhour Data in Apache Spark using the CData Software JDBC Driver.
-
Replicate Redshift Data from PowerShell
Write a quick PowerShell script to query Redshift data. Use connectivity to the live data to replicate Redshift data to SQL Server.
-
Build Semantic Layer Views for Monday.com Data in APOS Live Data Gateway
Use the CData Connector for Monday.com in APOS Live Data Gateway to build Semantic Layer Views for Monday.com data.
-
Integrate Live Microsoft Dataverse Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Microsoft Dataverse data and integrate live Microsoft Dataverse data into apps built in Microsoft Power Apps.
-
Visualize Live Shippo Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Shippo data.
-
Object-Relational Mapping (ORM) with Campaigner 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 Campaigner data into a Java-based ORM framework, Hibernate.
-
Reckon Accounts Hosted Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Reckon Accounts Hosted facts in real time.
-
Write a Simple Go Application to work with Salesforce Pardot Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Salesforce Pardot data.
-
Establish a Live Connection with Planio Data using Tableau Bridge
The CData ODBC Driver for Planio enables you to integrate live Planio data into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Kintone-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Kintone Data and create custom apps in Mendix.