CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Office 365 Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Office 365 replication to Amazon S3.
-
How to Query CSV Data in MySQL Workbench
Execute MySQL queries against live CSV data from MySQL Workbench.
-
Import SparkPost Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to SparkPost Data and provide access to live SparkPost data for custom reports in the Power BI Service.
-
Visualize Strava Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Strava data into TIBCO Spotfire.
-
Getting Started with the CData JDBC Driver for HBase
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for HBase.
-
Build a Simple VCL Application for CockroachDB Data
How to build a simple VCL Application to view CockroachDB data in RAD Studio using the CData ODBC Driver for CockroachDB.
-
Use the CData Software ODBC Driver for Amazon S3 in MicroStrategy Desktop
Connect to Amazon S3 data in MicroStrategy Desktop using the CData Software ODBC Driver for Amazon S3.
-
Use the CData Software ODBC Driver for Twilio in MicroStrategy Desktop
Connect to Twilio data in MicroStrategy Desktop using the CData Software ODBC Driver for Twilio.
-
Use Claude to Talk to Your Impala Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Impala data for you.
-
Connect to ZohoDesk Data from a Connection Pool in Jetty
The ZohoDesk JDBC Driver supports connection pooling: This article shows how to connect faster to ZohoDesk data from Web apps in Jetty.
-
Migrating data from ConvertAPI to Google BigQuery using CData SSIS Components.
Easily push ConvertAPI data to Google BigQuery using the CData SSIS Tasks for ConvertAPI and Google BigQuery.
-
Connect to SuiteCRM Data from a Connection Pool in Jetty
The SuiteCRM JDBC Driver supports connection pooling: This article shows how to connect faster to SuiteCRM data from Web apps in Jetty.
-
Connect LeadDesk to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live LeadDesk data using the CData Python MCP Server.
-
Integrate with Google Cloud Storage Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Google Cloud Storage data to a JSON file on disk.
-
How to connect to SurveyMonkey Data from IntelliJ
Integrate connectivity to SurveyMonkey data with wizards in IntelliJ.
-
Connect to Shippo Data in DBArtisan
Use wizards in DBArtisan to configure Shippo data as a data source.
-
Build a PostgreSQL Interface for Simplesat Data using the CData JDBC Driver
Use the Remoting features of the Simplesat JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Sendwithus Data from PowerBuilder via ADO.NET
This article demonstrates how to access Sendwithus data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect Strava Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Strava data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Query Hugging Face Data in DataGrip
Create a Data Source for Hugging Face in DataGrip and use SQL to query live Hugging Face data.
-
Bidirectional Access to Salesforce Pardot Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Salesforce Pardot data in Filemaker Pro for Mac or Windows.
-
Build Visualizations of Cohere Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Cohere data in Birst.
-
Publish Crystal Reports on Pipedrive Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Pipedrive data.
-
How to Work with Smartsheet Data in ETL Validator JDBC
Connect to Smartsheet from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate Theia IDE with Live GetResponse 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 GetResponse data from within the development environment.
-
Connect to Placid Data in Ruby
Connect to Placid data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use Azure AI Foundry to Talk to Your Google Forms Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Google Forms data for you.
-
How to Connect to Live Active Directory 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 Active Directory data for you.
-
Automated Continuous OnePageCrm Replication to Databricks
Use CData Sync for automated, continuous, customizable OnePageCrm replication to Databricks.
-
Create Dashboards and Visualize Live Azure Analysis Services Data in Geckoboard
Use CData Connect AI to connect to live Azure Analysis Services data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to Visualize Salesforce Data in Python with pandas
Use pandas and other modules to analyze and visualize live Salesforce data in Python.
-
DataBind Asana Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Asana with the DevExpress Windows Forms and Web controls to provide Asana data to a chart.
-
Automated Continuous VWO Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable VWO replication to Apache Cassandra.
-
How to connect to Webflow Data from IntelliJ
Integrate connectivity to Webflow data with wizards in IntelliJ.
-
Easily Integrate Toggl Data in Lazarus Pascal IDE
Learn how to easily integrate live Toggl data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Excel Spreadsheet Automation on Apify Data with the QUERY Formula
Pull data from Apify, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous SendPulse Replication to MongoDB
Use CData Sync for automated, continuous, customizable SendPulse replication to MongoDB.
-
Enable the PagerDuty JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with PagerDuty data.
-
Access Live FHIR Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live FHIR data from your Excel spreadsheets.
-
How to connect to Avalara AvaTax Data in DBVisualizer
Integrate Avalara AvaTax data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to connect to ActiveCampaign Data with Squirrel SQL client
Connect to ActiveCampaign data and execute queries in the Squirrel SQL Client.
-
Connect to Todoist Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Todoist to connect to Todoist data and execute queries in PowerBuilder.
-
Use the CData Software ODBC Driver for Accelo in MicroStrategy Web
Connect to Accelo data in MicroStrategy Web using the CData Software ODBC Driver for Accelo.
-
Integrate Freshservice Data in the Pentaho Report Designer
Publish reports based on Freshservice data in the Pentaho BI tool.
-
Provide OData Services of QuickBooks Time Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for QuickBooks Time data by developing a WCF Service Application.
-
How to publish and share ConvertAPI Data dashboards with Tableau Server
The CData ODBC driver for ConvertAPI enables you integrate ConvertAPI data into Tableau dashboards.
-
Connect to Sage Intacct Data from a Connection Pool in JBoss
Integrate Sage Intacct data into Java servlets: Use the Management Console in JBoss to install the Sage Intacct JDBC Driver.
-
Connect and Visualize Live Gong Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Gong data into the Databricks platform and create visualization dashboards with real-time Gong data.
-
Build Data Flows from SQL Server to Snowflake through SSIS
Easily push SQL Server data to Snowflake using the CData SSIS Tasks for Snowflake.
-
Getting Started with the CData Excel Add-In for Attio
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Attio.
-
Getting Started with the CData Connect AI Python SDK for CSV
Install the CData Connect AI Python SDK to read live CSV data with standard DB-API 2.0 Python code.
-
Automated Continuous Oracle Eloqua Reporting Replication to SingleStore
Use CData Sync for automated, continuous, customizable Oracle Eloqua Reporting replication to SingleStore.
-
Integrate with Exact Online Data in JReport Designer
Create charts and reports based on Exact Online data in JReport Designer.
-
Rapidly Develop BigCommerce-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 BigCommerce.
-
Use the CData ODBC Driver for SAP BusinessObjects BI from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SAP BusinessObjects BI to connect to SAP BusinessObjects BI data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SAP BusinessObjects BI data in Excel.
-
Automated Continuous Twilio Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Twilio replication to PostgreSQL.
-
Publish Paymo-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Paymo data.
-
How to Connect to Live GitHub Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live GitHub data securely in real time.
-
Automated Continuous SAP Hybris C4C Replication to MongoDB
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to MongoDB.
-
Creating Amazon Athena-Connected Applications in Unqork
You can use CData Connect AI to feed Amazon Athena data to Unqork and build custom business apps.
-
Integrating Claude Code CLI with Copper 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 Simplesat Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Simplesat data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create a Data Access Object for Reckon Accounts Hosted Data using JDBI
A brief overview of creating a SQL Object API for Reckon Accounts Hosted data in JDBI.
-
Getting Started with the CData SSIS Components for Zoho Inventory
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Zoho Inventory.
-
Access Live SAP BusinessObjects BI 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 SAP BusinessObjects BI data through MCP integration.
-
How to publish and share Microsoft Entra ID Data dashboards with Tableau Server
The CData ODBC driver for Microsoft Entra ID enables you integrate Microsoft Entra ID data into Tableau dashboards.
-
Automated Continuous OnePageCrm Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable OnePageCrm replication to Azure SQL Database.
-
Build MVC Applications with Connectivity to Intercom Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Intercom from an ASP.NET MVC application.
-
Migrating data from Onfleet to Snowflake using CData SSIS Components.
Easily push Onfleet data to Snowflake using the CData SSIS Tasks for Onfleet and Snowflake.
-
Use the CData Software ODBC Driver for Oracle SCM in SAS for Real-Time Reporting and Analytics
Connect to real-time Oracle SCM data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Oracle SCM.
-
Use the CData Software ODBC Driver for Mocean in MicroStrategy
Connect to Mocean data in MicroStrategy Developer using the CData Software ODBC Driver for Mocean.
-
Provide OData Services of Azure Analysis Services Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Azure Analysis Services data by developing a WCF Service Application.
-
Build Apps with Live Oracle Financials Cloud data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Oracle Financials Cloud data into the Adalo platform and build custom mobile and web applications with real-time Oracle Financials Cloud data.
-
Connect BenchmarkEmail to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live BenchmarkEmail data using the CData Python MCP Server.
-
Integrate Live PostgreSQL Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to PostgreSQL data and integrate live PostgreSQL data into apps built in Microsoft Power Apps.
-
Build Agents in Relevance AI with Access to Live Basecamp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Basecamp data within intelligent agent workflows.
-
Use the CData ODBC Driver for Kintone from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Kintone to connect to Kintone data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Kintone data in Excel.
-
Integrate LibreChat with Live Zoho Inventory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Zoho Inventory data from within the chat interface.
-
DataBind DB2 Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for DB2 with the DevExpress Windows Forms and Web controls to provide DB2 data to a chart.
-
How to connect to Google Campaign Manager 360 Data from Spring Boot
Connect to Google Campaign Manager 360 in a Spring Boot Application using the CData JDBC Driver for Google Campaign Manager 360
-
Create a Data Access Object for ZendeskSell Data using JDBI
A brief overview of creating a SQL Object API for ZendeskSell data in JDBI.
-
Build Charts with Front Data in Clear Analytics
Create dynamic charts and perform analytics based on Front data in Clear Analytics.
-
DataBind Controls to Float Data in Delphi
DataBind to Float data in Delphi with standard data access components and controls.
-
Connect to RSS Feeds from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time RSS feeds using standard SQL.
-
Write a Simple Go Application to work with ZohoMarketingHub Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ZohoMarketingHub data.
-
Automated Continuous Google Directory Replication to SQL Server
Use CData Sync for automated, continuous, customizable Google Directory replication to SQL Server.
-
Replicate Browserless Data to Multiple Databases
Replicate Browserless data to disparate databases with a point-and-click configuration.
-
Connect to Airtable Data in Aqua Data Studio
Access Airtable data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Apify Data in JRuby
Create a simple JRuby app with access to live Apify data.
-
Connect to Vault CRM Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Vault CRM.
-
Connecting Pipedream with Okta 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 Okta data in real time.
-
Consume Act-On OData Feeds in PowerBuilder
This article demonstrates how to consume Act-On data as OData feeds from PowerBuilder using the API Server.
-
Build an OLAP Cube in SSAS from Google Translate Data
Establish a connection to Google Translate data data from SQL Server Analysis Services, and use the Google Translate Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use Dash to Build to Web Apps on HCL Domino Data
Create Python applications that use pandas and Dash to build HCL Domino-connected web apps.
-
How to integrate Printify with Apache Airflow
Access and process Printify data in Apache Airflow using the CData JDBC Driver.
-
Configure the CData JDBC Driver for Clari in a Connection Pool in Tomcat
Connect to Clari data from a connection pool in Tomcat.
-
Integrate with Live Acumatica Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Acumatica from the MuleSoft Anypoint Platform to integrate live Acumatica data into custom reports and dashboards.
-
Add Bright Data Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Bright Data with the Informatica Enterprise Data Catalog to classify and organize data.
-
Import Google Analytics Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Google Analytics Data and provide access to live Google Analytics data for custom reports in the Power BI Service.
-
How to import Greenhouse Data into Apache Solr
Use the CData Software JDBC Driver for Greenhouse in Data Import Handler and create an automated import of Greenhouse data to Apache Solr Enterprise Search platform.