CData Software - Knowledge Base
Recent Articles
-
Access Live Zoho Creator Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Zoho Creator data from your Excel spreadsheets.
-
Build Apps with Live Reckon Accounts Hosted Data Using the Low-Code Development Platform of Mendix
Connect Reckon Accounts Hosted data with Mendix to build apps using the CData JDBC Driver for Reckon Accounts Hosted.
-
How to use SQLAlchemy ORM to access Todoist Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Todoist data.
-
Replicate MailerLite Data in Heroku for Use in Salesforce Connect
Replicate MailerLite data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Create Power BI Visual Reports with Real-Time Basecamp Data
Use CData Power BI Connectors to visualize Basecamp data in Power BI.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Planio
Provide connectivity to Planio data through an SAP BusinessObjects universe.
-
Import and Visualize Twilio Data in Power View
Create data visualizations based on Twilio data in Excel.
-
Build a Simple VCL Application for Odoo Data
How to build a simple VCL Application to view Odoo data in RAD Studio using the CData ODBC Driver for Odoo.
-
How to Work with Zoho Books Data in ETL Validator JDBC
Connect to Zoho Books from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Connect to Live Stripe Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Stripe data for you.
-
Samanage Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Samanage facts in real time.
-
Prepare, Blend, and Analyze ElevenLabs Data in Alteryx Designer (ODBC)
Build workflows to access live ElevenLabs data for self-service data analytics.
-
Connect to Printful Data in DBeaver
Use the CData ODBC Driver to connect to Printful data in DBeaver.
-
Integrate Cline with Live Sybase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Sybase data from within your IDE.
-
Access Live Avro Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Avro data from your Google Sheets.
-
Visualize DB2 Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to DB2 data.
-
Build an OLAP Cube in SSAS from SAS xpt Data
Establish a connection to SAS xpt data data from SQL Server Analysis Services, and use the SAS xpt Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Teamgate Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Teamgate replication to Amazon Redshift.
-
Automated Continuous MailerLite Replication to Databricks
Use CData Sync for automated, continuous, customizable MailerLite replication to Databricks.
-
Connect to Gmail Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Gmail data.
-
Work with Phoenix Data in FoxPro
Load Phoenix data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Using the CData Software ODBC Driver for PolarTeamPro in PyCharm
Connect to PolarTeamPro as an ODBC data source in PyCharm using the CData Software ODBC Driver for PolarTeamPro.
-
How to Access Zoho Books Data Using Entity Framework
This article shows how to access Zoho Books data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Dashboards with Jira Data in Dundas BI
Create dynamic dashboards and perform analytics based on Jira data in Dundas BI.
-
How to integrate Coda with Apache Airflow
Access and process Coda data in Apache Airflow using the CData JDBC Driver.
-
Use Dash to Build Web Apps on GetResponse Data via CData Connect AI
Build interactive Dash web apps on live GetResponse data using pandas and the CData Connect AI Python SDK.
-
Getting Started with the CData JDBC Driver for Mocean
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Mocean.
-
Consume MYOB AccountRight OData Feeds in PowerBuilder
This article demonstrates how to consume MYOB AccountRight data as OData feeds from PowerBuilder using the API Server.
-
Create Data Visualizations in Cognos BI with Beeminder Data
Access Beeminder data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to load Presto data into Elasticsearch via Logstash
Introducing a simple method to load Presto data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate OpenCode with Live Stripe Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Stripe data from within your AI coding agent.
-
Build Dashboards with ADP Data in Dundas BI
Create dynamic dashboards and perform analytics based on ADP data in Dundas BI.
-
Moving Data from OnePageCrm to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live OnePageCrm data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Access NetSuite 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 NetSuite data.
-
Integrate Goose with Live Zoho Creator Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Zoho Creator data from within the local AI agent.
-
How to Query Cloudant Data in MySQL Workbench
Execute MySQL queries against live Cloudant data from MySQL Workbench.
-
Integrate with Keap Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Keap data to a JSON file on disk.
-
Visualize Outlook Data in Tableau
The CData ODBC driver for Outlook enables you integrate Outlook data into Tableau dashboards.
-
Build Dashboards with Excel Data in DBxtra
Create dynamic dashboards and perform analytics based on Excel data in DBxtra.
-
DataBind Controls to RSS Feeds in Delphi
DataBind to RSS feeds in Delphi with standard data access components and controls.
-
Automate Vault CRM Data Replication to Couchbase
Use CData Sync to Customize and automate Vault CRM data replication to Couchbase.
-
Automate Webflow Data Replication to Azure Data Lake
Use CData Sync to customize and automate Webflow data replication to Azure Data Lake.
-
How to Work with Instagram Data in ETL Validator JDBC
Connect to Instagram from ETL Validator jobs using the CData Software JDBC Driver.
-
Visualize Microsoft Planner Data in Sisense
Create an ElastiCube in Sisense app with access to Microsoft Planner data.
-
Connect to Shortcut Data in DBArtisan
Use wizards in DBArtisan to configure Shortcut data as a data source.
-
How to import PhantomBuster Data into Apache Solr
Use the CData Software JDBC Driver for PhantomBuster in Data Import Handler and create an automated import of PhantomBuster data to Apache Solr Enterprise Search platform.
-
Natively Connect to Hubstaff Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Hubstaff data. Leverage the native support for ODBC in PHP.
-
Connect to MySQL Data in NetBeans
Connect to MySQL data in NetBeans with the data source configuration wizard.
-
Automated Continuous Gumroad Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Gumroad replication to Google BigQuery.
-
Integrating Antigravity CLI with Facebook data via CData CLI
Connect Facebook data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Anaplan Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Anaplan data in Airbyte.
-
Automated Continuous Accelo Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Accelo replication to Google Cloud SQL.
-
Analyze Sage Cloud Accounting Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Sage Cloud Accounting from Power Pivot. You will use the Table Import Wizard to load Sage Cloud Accounting data. You can visually build the import query or use any SQL supported by the driver.
-
Design BIRT Reports on Okta Data
Provide current Okta data to your embedded analytics.
-
Integrate with Email Data in JReport Designer
Create charts and reports based on Email data in JReport Designer.
-
Connect to Pingdom Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Pingdom and work with Pingdom data in your FileMaker applications.
-
Natively Connect to Reckon Accounts Hosted Data in PHP
The CData ODBC driver for Reckon Accounts Hosted enables you to create PHP applications with connectivity to Reckon Accounts Hosted data. Leverage the native support for ODBC in PHP.
-
Natively Connect to Harvest Data in PHP
The CData ODBC driver for Harvest enables you to create PHP applications with connectivity to Harvest data. Leverage the native support for ODBC in PHP.
-
Create BigCommerce-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to BigCommerce Data from Klipfolio and build custom visualizations using live BigCommerce data.
-
Analyze Live Coda Data in SAS Viya
Use CData Connect AI to connect to Coda data from SAS Viya and deploy self-service analytics using live Coda data.
-
Build Automated Sage Cloud Accounting-Connected Workflows in Zapier
Use CData Connect AI to connect to live Sage Cloud Accounting data and build automated workflows in Zapier.
-
How to Connect to Live Adobe Experience Manager Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Adobe Experience Manager data securely in real time.
-
Build Data Flows from Strava to SQL Server using SSIS
Easily back up Strava data to SQL Server using the SSIS components for Strava.
-
How to use SQLAlchemy ORM to access Bitly Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Bitly data.
-
Connect to ZohoSubscriptions Data in Aqua Data Studio
Access ZohoSubscriptions data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create Dynamic BambooHR Grids Using the Infragistics XamDataGrid
Learn how you can connect BambooHR to Infragistics XamDataGrid to build dynamic grids.
-
Bind Live Presto Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Presto data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Integrate Greenplum with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Greenplum with External Services.
-
Integrate Live PingOne Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to PingOne data and integrate live PingOne data into apps built in Microsoft Power Apps.
-
Connect to Elasticsearch Data from HeidiSQL
Use CData Connect AI to connect to and query live Elasticsearch data from HeidiSQL.
-
Replicate WordPress Data to Multiple Databases via the CData Sync CLI
Replicate WordPress data to disparate databases with a single configuration.
-
Getting Started with the CData Tableau Connector for LDAP
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for LDAP.
-
How to work with Bugsnag Data in Apache Spark using SQL
Access and process Bugsnag Data in Apache Spark using the CData Software JDBC Driver.
-
Build Data Flows from YouTube Analytics to SQL Server using SSIS
Easily back up YouTube Analytics data to SQL Server using the SSIS components for YouTube Analytics.
-
Connecting Mastra with DB2 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 DB2 data, no replication required.
-
Analyze TaxJar Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of TaxJar data and visualize TaxJar data in SAP Analytics Cloud.
-
Connect to Tavily Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Tavily data using standard SQL.
-
How to Connect to Live Amazon DynamoDB Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Amazon DynamoDB data securely in real time.
-
Use the CData Software JDBC Driver for Avaza in MicroStrategy Desktop
Connect to Avaza data in MicroStrategy Desktop using the CData Software JDBC Driver for Avaza.
-
How to Work with HubSpot Data in AWS Glue Jobs Using JDBC
Connect to HubSpot from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Viewing SAP SuccessFactors Data in RAD Studio Data Explorer
How to view SAP SuccessFactors data in RAD Studio Data Explorer using the CData ODBC Driver for SAP SuccessFactors.
-
Integrating Dataiku with Reckon Accounts Hosted Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Reckon Accounts Hosted data.
-
How to connect to Datadog Data from Spring Boot
Connect to Datadog in a Spring Boot Application using the CData API Driver for JDBC
-
Getting Started with the CData ODBC Driver for Aircall
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Aircall.
-
Integrating Claude Code CLI with Customer.io 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.
-
A PostgreSQL Interface for ScrapingBee Data using the CData ODBC Driver
Use the SQL Gateway and ScrapingBee ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect WooCommerce to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live WooCommerce data using the CData Python MCP Server.
-
Automated Continuous ActiveCampaign Replication to Databricks
Use CData Sync for automated, continuous, customizable ActiveCampaign replication to Databricks.
-
Automated Continuous Spark Replication to Vertica
Use CData Sync for automated, continuous, customizable Spark replication to Vertica.
-
How to create Pipeline CRM federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Pipeline CRM data in MySQL .
-
Use CData Connect AI to Access PayPal Data in Microsoft Power Pivot
Use CData Connect AI to connect to live PayPal data in the Power Pivot business intelligence tool.
-
Connect to Adobe Target Data from a Connection Pool in Jetty
The Adobe Target JDBC Driver supports connection pooling: This article shows how to connect faster to Adobe Target data from Web apps in Jetty.
-
Visualize Lakebase Data in TIBCO Spotfire through OData
Integrate Lakebase data into dashboards in TIBCO Spotfire.
-
Visualize CSV Data in Tableau
The CData ODBC driver for CSV enables you integrate CSV data into Tableau dashboards.
-
Access Live SAP Ariba Procurement Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SAP Ariba Procurement data into the statistical analysis tools available in SAS JMP. This article shows how to use SAP Ariba Procurement data in the Graph Builder and Query Builder.
-
Integrating Claude Code with Google Drive Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Google Drive data within assisted coding and automated development workflows.
-
Access Live Campaigner Data in Coginiti Pro
Connect to and query live Campaigner data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous MailerLite Replication to MySQL
Use CData Sync for automated, continuous, customizable MailerLite replication to MySQL.
-
Bridge Zoho Recruit Connectivity with Apache NiFi
Access and process Zoho Recruit data in Apache NiFi using the CData JDBC Driver.
-
Integrating SAP HANA Data in Talend Cloud Data Management Platform
Connect SAP HANA Data with Talend Cloud Data Management Platform using the CData JDBC Driver for SAP HANA.