CData Software - Knowledge Base
Recent Articles
-
Automated Continuous RSS Replication to Vertica
Use CData Sync for automated, continuous, customizable RSS replication to Vertica.
-
How to connect to Webex Data in DBVisualizer
Integrate Webex with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Datasets from Teamwork in Domo Workbench and Build Visualizations of Teamwork Data in Domo
Use the CData Software ODBC Driver for Teamwork to create datasets from Teamwork in Domo Workbench and then build visualizations in the Domo service.
-
How to Visualize Adobe Commerce Data in Python with pandas
Use pandas and other modules to analyze and visualize live Adobe Commerce in Python.
-
Connect to Parallel Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Parallel to connect to Parallel and execute queries in PowerBuilder.
-
How to Connect Zendesk Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Zendesk data in real time using natural language.
-
Access Live Presto Data in Excel 365 Online (Excel for the web)
Connect to Presto from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Access Live Reckon Accounts Hosted Data in Excel 365 Online (Excel for the web)
Connect to Reckon Accounts Hosted from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Integrate Goose with Live FreshBooks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live FreshBooks from within the local AI agent.
-
Automated Continuous Wave Financial Replication to Databricks
Use CData Sync for automated, continuous, customizable Wave Financial replication to Databricks.
-
DataBind Charts to ZohoDesk Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to ZohoDesk from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Use Biml to Build SSIS Tasks to Replicate Pinecone Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Pinecone to SQL Server.
-
Manage MailChimp Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for MailChimp.
-
Analyze Smartsheet Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Smartsheet and visualize live Smartsheet in Infragistics Reveal.
-
Connect to and Visualize Live Bitly Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Bitly.
-
Design BIRT Reports on FreeAgent Data
Provide current FreeAgent to your embedded analytics.
-
Replicate CData Connect AI Data to Multiple Databases
Replicate CData Connect AI to disparate databases with a point-and-click configuration.
-
Connect to Authorize.Net Data from a Connection Pool in Jetty
The Authorize.Net JDBC Driver supports connection pooling: This article shows how to connect faster to Authorize.Net from Web apps in Jetty.
-
How to publish and share Optimizely Data dashboards with Tableau Server
The CData ODBC driver for Optimizely enables you integrate Optimizely into Tableau dashboards.
-
Connect to Live Sybase IQ Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Sybase IQ in CData Connect AI and connect to your Sybase IQ from PostgreSQL.
-
Connect to Live SingleStore Data in MicroStrategy through CData Connect AI
Create a live connection to SingleStore Data in CData Connect AI and connect to your SingleStore from MicroStrategy.
-
How to connect to Oracle HCM Cloud Data from Spring Boot
Connect to Oracle HCM Cloud in a Spring Boot Application using the CData JDBC Driver for Oracle HCM Cloud
-
Automated Continuous Avaza Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Avaza replication to Apache Kafka.
-
Connect to and Query HCL Domino Data in QlikView over ODBC
Create data visualizations with HCL Domino in QlikView.
-
Create Acumatica-Connected Business Apps in AppSheet
Connect to Acumatica Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Acumatica ERP.
-
Automated Continuous Pingdom Replication to Snowflake
Use CData Sync for automated, continuous, customizable Pingdom replication to Snowflake.
-
Automated Continuous Cosmos DB Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Cosmos DB replication to PostgreSQL.
-
Connect to ADP Data from HeidiSQL
Use CData Connect AI to connect to and query live ADP from HeidiSQL.
-
Connect SAP HANA XS Advanced Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SAP HANA XS Advanced using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Query, Visualize, and Share live Gmail Data in Redash
Use CData Connect AI to connect to live Gmail in Redash for querying, visualizing, and sharing.
-
Build Redis-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Redis to explore live Redis Data in Gemini Code Assist to assist with building Redis-powered applications.
-
How to Access Live Adobe Analytics Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Adobe Analytics enables you to integrate Adobe Analytics into workflows built using Microsoft Power Automate Desktop.
-
How to create an RPA flow for SAP SuccessFactors LMS Data in UiPath Studio
Use the SAP SuccessFactors LMS ODBC Driver to create workflows that access real-time SAP SuccessFactors LMS without any coding.
-
How to Build an ETL App for SAP Ariba Procurement Data in Python with CData
Create ETL applications and real-time data pipelines for SAP Ariba Procurement in Python with petl.
-
How to Query Live ADP Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ADP data in natural language using Python.
-
How to Easily Query Amplitude Data in OpenOffice Base
Connect to Amplitude data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Automate Google Tasks Data Replication to Couchbase
Use CData Sync to Customize and automate Google Tasks replication to Couchbase.
-
Load Pingdom Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Pingdom to a database.
-
Getting Started with the CData Excel Add-In for SAP Ariba Procurement
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SAP Ariba Procurement.
-
Create Datasets from HDFS in Domo Workbench and Build Visualizations of HDFS Data in Domo
Use the CData Software ODBC Driver for HDFS to create datasets from Apache HDFS in Domo Workbench and then build visualizations in the Domo service.
-
Bridge Microsoft OneDrive Connectivity with Apache NiFi
Access and process Microsoft OneDrive in Apache NiFi using the CData JDBC Driver.
-
Edit and Search Zoho Creator External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Zoho Creator to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Zoho Creator objects that you can access from apps and the dashboard.
-
Connect to Hacker News Data from a Connection Pool in JBoss
Integrate Hacker News into Java servlets: Use the Management Console in JBoss to install the Hacker News JDBC Driver.
-
Create Power BI Reports on Real-Time Avro Data
Use the CData ODBC Driver for Avro to visualize Apache Avro in Power BI Desktop.
-
A Comparison of Drivers for Azure Cosmos DB
An article comparing the read performance and resources usage of the CData Software ODBC Driver for CosmosDB with the native ODBC Driver.
-
Integrate with Microsoft Exchange Data in JReport Designer
Create charts and reports based on Microsoft Exchange in JReport Designer.
-
Use Agno to Talk to Your Salesforce CRM Analytics 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 CRM Analytics for you.
-
Access Live Cvent Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Cvent into the statistical analysis tools available in SAS JMP. This article shows how to use Cvent in the Graph Builder and Query Builder.
-
Connect to Simplesat Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Simplesat.
-
How to connect to Onfleet Data from Spring Boot
Connect to Onfleet in a Spring Boot Application using the CData API Driver for JDBC
-
Create Datasets from JobNimbus in Domo Workbench and Build Visualizations of JobNimbus Data in Domo
Use the CData Software ODBC Driver for JobNimbus to create datasets from JobNimbus in Domo Workbench and then build visualizations in the Domo service.
-
How to Seamlessly Import Moosend Data into IBM SPSS Modeler
Integrate Moosend data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Google Cloud Storage-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Google Cloud Storage.
-
Process & Analyze Mouseflow Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Mouseflow Data.
-
Query SQL Server Data as a MySQL Database in Node.js
Execute MySQL queries against Microsoft SQL Server from Node.js.
-
Visualize Adobe Target Data in Tableau
The CData ODBC driver for Adobe Target enables you integrate Adobe Target into Tableau dashboards.
-
How to use SQLAlchemy ORM to access Aha! Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Aha!.
-
Import and Visualize Cassandra Data in Power View
Create data visualizations based on Apache Cassandra in Excel.
-
Analyze SAP Fieldglass Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SAP Fieldglass with the CData JDBC Driver for SAP Fieldglass.
-
Create Datasets from Instantly in Domo Workbench and Build Visualizations of Instantly Data in Domo
Use the CData Software ODBC Driver for Instantly to create datasets from Instantly in Domo Workbench and then build visualizations in the Domo service.
-
Operational Reporting on Google Sheets Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Google Sheets.
-
Integrating Cursor CLI with Confluence 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.
-
Operational Reporting on SAP Ariba Source Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SAP Ariba Source.
-
Connect to Real-Time Scrapfly Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Scrapfly in Power Apps.
-
Connect to Exact Online Data in Aqua Data Studio
Access Exact Online from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
ElevenLabs Reporting in OBIEE with the ElevenLabs JDBC Driver
Deploy the ElevenLabs JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Create a Data Access Object for LinkedIn Ads Data using JDBI
A brief overview of creating a SQL Object API for LinkedIn Ads in JDBI.
-
Use the CData ODBC Driver for FormSite in Microsoft Power Query
You can use the CData FormSite ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import FormSite into Microsoft Power Query.
-
Access Google Calendar Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Google Calendar from your Oracle system.
-
DataBind Controls to Strava Data in Delphi
DataBind to Strava in Delphi with standard data access components and controls.
-
Build Charts with Aweber Data in Clear Analytics
Create dynamic charts and perform analytics based on Aweber in Clear Analytics.
-
Analyze Google Drive Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Google Drive in Microsoft R Open.
-
How to Connect to & Open SendInBlue Data in Microsoft Excel
This article uses the CData ODBC driver for SendInBlue to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate Live Google Ads Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Google Ads and integrate live Google Ads into apps built in Microsoft Power Apps.
-
Moving Data from MongoDB to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live MongoDB data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automated Continuous CData Connect AI Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable CData Connect AI replication to Amazon Redshift.
-
How to Query Live ChargeOver Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ChargeOver data in natural language using Python.
-
Connect to Dynamics 365 from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Microsoft Dynamics 365, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to Query Microsoft Dataverse Data in MySQL Workbench
Execute MySQL queries against live Microsoft Dataverse (CDS) from MySQL Workbench.
-
Access Elasticsearch Data from MySQL in PHP
Connect to Elasticsearch through the standard MySQL libraries in PHP.
-
Configure the CData JDBC Driver for Beeminder in a Connection Pool in Tomcat
Connect to Beeminder from a connection pool in Tomcat.
-
Create Informatica Mappings From/To a JDBC Data Source for AdRoll
Create AdRoll data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Bugsnag Data in RapidMiner
Integrate Bugsnag with standard components and data source configuration wizards in RapidMiner Studio.
-
Access SingleStore Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SingleStore from HeidiSQL.
-
Natively Connect to Outreach.io Data in PHP
The CData ODBC driver for Outreach.io enables you to create PHP applications with connectivity to Outreach.io. Leverage the native support for ODBC in PHP.
-
Build a Simple VCL Application for Workday Data
How to build a simple VCL Application to view Workday in RAD Studio using the CData ODBC Driver for Workday.
-
Getting Started with the CData Python Connector for Bitbucket
Learn to install and license the CData Python Connector
-
Integrating Claude Code with Office 365 Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Microsoft Office 365 within assisted coding and automated development workflows.
-
Automated Continuous SAP SuccessFactors Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable SAP SuccessFactors replication to Azure SQL Database.
-
Connect to Odoo from Asprova with CData Software ODBC Driver for Odoo
This article shows how to connect faster to Odoo data from Asprova.
-
How to connect to OneNote Data with Squirrel SQL client
Connect to Microsoft OneNote and execute queries in the Squirrel SQL Client.
-
Integrate with Google Drive Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Google Drive in SnapLogic.
-
Visualize Dynamics 365 Data in Sisense
Create an ElastiCube in Sisense app with access to Microsoft Dynamics 365.
-
Analyze Act CRM Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Act CRM and visualize live Act CRM in Infragistics Reveal.
-
DataBind Charts to Grafana Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Grafana from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Use Grok to Talk to Your Salesforce Pardot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Salesforce Pardot for you.
-
Integrating Opsgenie Data in Talend Cloud Data Management Platform
Connect Opsgenie Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Model, Search, and Visualize Live Square Data in ThoughtSpot
Use CData Connect AI to connect to live Square for modeling, searching, and visualizing.
-
Create Informatica Mappings From/To an ODBC Data Source for Instantly
Create an ODBC connection to Instantly in Informatica and browse and transfer Instantly.
-
Configure the CData JDBC Driver for BenchmarkEmail in a Connection Pool in Tomcat
Connect to BenchmarkEmail from a connection pool in Tomcat.