CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Productboard Replication to Vertica
Use CData Sync for automated, continuous, customizable Productboard replication to Vertica.
-
How to Work with Oracle Eloqua Data in ETL Validator JDBC
Connect to Oracle Eloqua from ETL Validator jobs using the CData Software JDBC Driver.
-
Use Claude to Talk to Your Cvent 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 Cvent data for you.
-
Access Live CloudConvert Data in AWS Lambda
Connect to live CloudConvert data in AWS Lambda using the CData JDBC Driver.
-
Visualize AfterShip Data in Sisense
Create an ElastiCube in Sisense app with access to AfterShip data.
-
Connect to Shortcut Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Shortcut data using standard SQL.
-
Create Reports from Aweber Data in Looker Studio
Use CData Connect AI to gain access to live Aweber data and create custom reports in Looker Studio.
-
Integrate OpenCode with Live FreshBooks Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live FreshBooks data from within your AI coding agent.
-
Configure the CData JDBC Driver for DB2 in a Connection Pool in Tomcat
Connect to DB2 data from a connection pool in Tomcat.
-
Establish a Live Connection with ConvertKit Data using Tableau Bridge
The CData ODBC Driver for ConvertKit enables you to integrate live ConvertKit data into Tableau Cloud dashboards using the Tableau Bridge.
-
Excel Spreadsheet Automation on Cvent Data with the QUERY Formula
Pull data from Cvent, automate spreadsheets, and more with the QUERY formula.
-
A PostgreSQL Interface for Aha! Data (MySQL Remoting via JDBC)
Use the Remoting features of the Aha! JDBC Driver to create a PostgreSQL entry-point for data access.
-
Viewing SAP Hybris C4C Data in RAD Studio Data Explorer
How to view SAP Hybris C4C data in RAD Studio Data Explorer using the CData ODBC Driver for SAP Hybris C4C.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Hugging Face
Provide connectivity to Hugging Face data through an SAP BusinessObjects universe.
-
Access Live ZohoPeople Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live ZohoPeople data from your Excel spreadsheets.
-
How to integrate Factorial with Apache Airflow
Access and process Factorial data in Apache Airflow using the CData JDBC Driver.
-
Automate SendInBlue Data Replication to Couchbase
Use CData Sync to Customize and automate SendInBlue data replication to Couchbase.
-
How to connect to Freshdesk Data in DBVisualizer
Integrate Freshdesk data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Factorial Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Factorial data using standard SQL.
-
ETL Retently in Oracle Data Integrator
This article shows how to transfer Retently data into a data warehouse using Oracle Data Integrator.
-
Import and Visualize Jodoo Data in Power View
Create data visualizations based on Jodoo data in Excel.
-
How to Build an ETL App for Microsoft Planner Data in Python with CData Connect AI
Build ETL pipelines that read and write live Microsoft Planner data in Python with petl and the CData Connect AI Python SDK.
-
Connect to Oracle Data in NetBeans
Connect to Oracle data in NetBeans with the data source configuration wizard.
-
Integrate with Live ServiceNow Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to ServiceNow from the MuleSoft Anypoint Platform to integrate live ServiceNow data into custom reports and dashboards.
-
Automated Continuous Todoist Replication to Snowflake
Use CData Sync for automated, continuous, customizable Todoist replication to Snowflake.
-
How to connect Amazon QuickSight to Microsoft Ads Data
Create a connection to Microsoft Ads data in CData Connect AI and insert Microsoft Ads data into Amazon QuickSight SPICE to build interactive dashboards.
-
Automated Continuous Everhour Replication to SQL Server
Use CData Sync for automated, continuous, customizable Everhour replication to SQL Server.
-
Connect and Query Live Adobe Target Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Adobe Target data into Databricks and enable direct, live querying and analysis without replication.
-
Integrate Google's Antigravity Agent with Live AgileCRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live AgileCRM data using the Model Context Protocol.
-
Use JayDeBeApi to access Optimizely Data in Python
Use standard Python scripting and the development environment of your choice to access live Optimizely data.
-
How to Visualize SendPulse Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live SendPulse data in Python.
-
Create Power BI Reports on Real-Time Azure Data Catalog Data
Use the CData ODBC Driver for Azure Data Catalog to visualize Azure Data Catalog data in Power BI Desktop.
-
Query Live NetSuite SuiteAnalytics 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 NetSuite SuiteAnalytics data through a conversational interface.
-
Automated Continuous xBase Replication to SingleStore
Use CData Sync for automated, continuous, customizable xBase replication to SingleStore.
-
Integrate Live SAS xpt Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live SAS xpt data from within the IDE.
-
Connect to ShipStation Data in NetBeans
Connect to ShipStation data in NetBeans with the data source configuration wizard.
-
How to create an RPA flow for Flowlu Data in UiPath Studio
Use the Flowlu ODBC Driver to create workflows that access real-time Flowlu data without any coding.
-
Import Real-Time Salesforce Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Salesforce data in ColdFusion.
-
Connect to SQL Analysis Services Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SQL Analysis Services as an External Source in Dremio.
-
Publish HubDB-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live HubDB data.
-
Build MVC Applications with Connectivity to Vimeo Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Vimeo from an ASP.NET MVC application.
-
Deploy the ADO.NET Provider for Freshsales on an SSRS Report Server
Connect to Freshsales 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.
-
How to work with Egnyte Data in Apache Spark using SQL
Access and process Egnyte Data in Apache Spark using the CData Software JDBC Driver.
-
Testmonitor Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Testmonitor data through CData Connect AI using different applications and tools.
-
Bidirectional Access to Microsoft Dataverse Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Microsoft Dataverse data in Filemaker Pro for Mac or Windows.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Google Ad Manager
Provide connectivity to Google Ad Manager data through an SAP BusinessObjects universe.
-
Visualize Live Apollo Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Apollo data into custom reports in Power BI.
-
Use JayDeBeApi to access Datadog Data in Python
Use standard Python scripting and the development environment of your choice to access live Datadog data.
-
Establish a Live Connection with Databricks Data using Tableau Bridge
The CData ODBC Driver for Databricks enables you to integrate live Databricks data into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Query Live Customer.io Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Customer.io data data in natural language using Python.
-
Create Data Visualizations in Cognos BI with Smartsheet Data
Access Smartsheet data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Import Klaviyo Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Klaviyo Data and provide access to live Klaviyo data for custom reports in the Power BI Service.
-
Create Reports with LDAP Objects in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date LDAP objects.
-
Connect to Salesforce CRM Analytics Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Salesforce CRM Analytics to connect to Salesforce CRM Analytics data and execute queries in PowerBuilder.
-
Extract, Transform, and Load Asana Data in Informatica PowerCenter
Create a simple Workflow for Asana data in Informatica PowerCenter.
-
Integrate with live Adobe Target Data in Jitterbit
Use CData Connect AI to connect to and integrate live Adobe Target data in Jitterbit.
-
Integrate Mixpanel with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Mixpanel with External Services.
-
How to connect to GitLab Data from Spring Boot
Connect to GitLab in a Spring Boot Application using the CData API Driver for JDBC
-
Import Real-Time SAP HANA XS Advanced Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SAP HANA XS Advanced data in ColdFusion.
-
Integrate Clio Data in Pentaho Data Integration
Build ETL pipelines based on Clio data in the Pentaho Data Integration tool.
-
Connect to Real-Time QuickBooks Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for QuickBooks and Dataflow to import and use QuickBooks data in Power Apps.
-
Manage SAS Data Sets Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SAS Data Sets.
-
Box Reporting in OBIEE with the Box JDBC Driver
Deploy the Box JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connecting GenSpark with Oracle Service Cloud Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Oracle Service Cloud data without any replication or custom integration required.
-
Visualize Live Klipfolio Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Klipfolio data into custom reports in Power BI.
-
Integrating Antigravity CLI with Harvest data via CData CLI
Connect Harvest data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Stream Cohere Data into Apache Kafka Topics
Access and stream Cohere data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to load Google Translate data into Elasticsearch via Logstash
Introducing a simple method to load Google Translate data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrating Kiro with EmailOctopus 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.
-
Automated Continuous Vertica Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Vertica replication to IBM DB2.
-
Visualize SendGrid 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 SendGrid data into TIBCO Spotfire.
-
Connect to Zoho Books Data from PowerBuilder via JDBC
This article demonstrates how to access Zoho Books data from PowerBuilder using the Zoho Books JDBC Driver.
-
How to Query TaxJar Data in MySQL Workbench
Execute MySQL queries against live TaxJar data from MySQL Workbench.
-
Model Klaviyo Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Klaviyo, enabling the direct import of real-time Klaviyo data.
-
Object-Relational Mapping (ORM) with Missive 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 Missive data into a Java-based ORM framework, Hibernate.
-
Connect to Sugar CRM Data in RapidMiner
Integrate Sugar CRM data with standard components and data source configuration wizards in RapidMiner Studio.
-
Using the CData Software ODBC Driver for Zoho Creator in PyCharm
Connect to Zoho Creator as an ODBC data source in PyCharm using the CData Software ODBC Driver for Zoho Creator.
-
How to Query Codat Data in MySQL Workbench
Execute MySQL queries against live Codat data from MySQL Workbench.
-
Automate Paylocity Data Replication to Azure Synapse
Use CData Sync to customize and automate Paylocity data replication to Azure Synapse.
-
Query, Visualize, and Share live PingOne Data in Redash
Use CData Connect AI to connect to live PingOne data in Redash for querying, visualizing, and sharing.
-
Integrate Cursor with Live ZohoPeople Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live ZohoPeople data from within the editor.
-
Link Recurly with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Recurly data in Filemaker Pro for Mac or Windows.
-
Build Microsoft OneDrive-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Microsoft OneDrive data and build Microsoft OneDrive-connected web apps with Axios.
-
Getting Started with the CData Tableau Connector for Facebook Ads
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Facebook Ads.
-
Easily Integrate Cassandra Data in Lazarus Pascal IDE
Learn how to easily integrate live Cassandra data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automate Rootly Data Replication to Couchbase
Use CData Sync to Customize and automate Rootly data replication to Couchbase.
-
Access Live Salesforce Marketing Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Salesforce Marketing data into the statistical analysis tools available in SAS JMP. This article shows how to use Salesforce Marketing data in the Graph Builder and Query Builder.
-
Automated Continuous ADP Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable ADP replication to PostgreSQL.
-
Automated Continuous Microsoft Planner Replication to Databricks
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to Databricks.
-
Import Jumpseller Data Using Azure Data Factory
Use CData Connect AI to connect to Jumpseller Data from Azure Data Factory and import live Jumpseller data.
-
Zoho CRM Reporting in OBIEE with the Zoho CRM JDBC Driver
Deploy the Zoho CRM JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Seamlessly Bring Azure Data Catalog Data into Retool Using CData Connect AI
Integrate Azure Data Catalog data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Moving Data from Calendly to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Calendly data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Analyze Dropbox Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Dropbox from Power Pivot. You will use the Table Import Wizard to load Dropbox data. You can visually build the import query or use any SQL supported by the driver.
-
Using the CData Software ODBC Driver for SAP Netweaver Gateway in PyCharm
Connect to SAP Netweaver Gateway as an ODBC data source in PyCharm using the CData Software ODBC Driver for SAP Netweaver Gateway.
-
Build Semantic Layer Views for Zoho Creator Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Zoho Creator data.
-
How to Work with Landbot Data in AWS Glue Jobs Using JDBC
Connect to Landbot from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Connect to Live SharePoint Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live SharePoint data securely in real time.
-
Automate Sage 200 Data Replication to Couchbase
Use CData Sync to Customize and automate Sage 200 data replication to Couchbase.
-
Integrate with SAP Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SAP data to a JSON file on disk.