CData Software - Knowledge Base
Recent Articles
-
Visualize Adobe Analytics Data in Tableau
The CData ODBC driver for Adobe Analytics enables you integrate Adobe Analytics data into Tableau dashboards.
-
Build AI Agents with Google Ad Manager 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 Google Ad Manager data through CData Connect AI.
-
Query Okta Data in ColdFusion
Write standard ColdFusion data access code to connect to Okta data.
-
Connect to LightSpeedRetail Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to LightSpeedRetail and work with LightSpeedRetail data in your FileMaker applications.
-
Automated Continuous Keap Replication to SingleStore
Use CData Sync for automated, continuous, customizable Keap replication to SingleStore.
-
Visualize Live Cassandra Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Cassandra data into custom reports in Power BI.
-
Integrating Boomi Agentstudio with Basecamp Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Basecamp data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Viewing CapsuleCRM Data in RAD Studio Data Explorer
How to view CapsuleCRM data in RAD Studio Data Explorer using the CData ODBC Driver for CapsuleCRM.
-
How to Build an ETL App for ADP Data in Python with CData
Create ETL applications and real-time data pipelines for ADP data in Python with petl.
-
Create Egnyte Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Egnyte data access from reports, embedded analytics, and more.
-
Build WooCommerce-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to WooCommerce Data from Zoho Analytics and import live WooCommerce data.
-
Viewing CloudConvert Data in RAD Studio Data Explorer
How to view CloudConvert data in RAD Studio Data Explorer using the CData ODBC Driver for CloudConvert.
-
Use the CData Software ODBC Driver for Gmail in MicroStrategy Web
Connect to Gmail data in MicroStrategy Web using the CData Software ODBC Driver for Gmail.
-
Analyze Amazon Marketplace Data in Cognos Analytics
Use CData Connect AI to connect to Amazon Marketplace Data from Cognos Analytics and analyze live Amazon Marketplace data.
-
Analyze PingOne Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of PingOne data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Replicate Multiple Parallel Accounts via the CData Sync CLI
Replicate multiple Parallel accounts to one or many databases.
-
Create Intercom Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Intercom from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build AI/ML Models with Live Google Sheets Data using Dataiku
Connect Google Sheets Data with Dataiku using the CData JDBC Driver for Google Sheets.
-
How to Query Smartsheet Data in MySQL Workbench
Execute MySQL queries against live Smartsheet data from MySQL Workbench.
-
Connect to Samanage Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Samanage to connect to Samanage data and execute queries in PowerBuilder.
-
Integrate Devin with Live MongoDB Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live MongoDB data.
-
Provide OData Services of Sage 200 Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Sage 200 data by developing a WCF Service Application.
-
Automated Continuous Cvent Replication to SingleStore
Use CData Sync for automated, continuous, customizable Cvent replication to SingleStore.
-
Analyze Adobe Analytics Data in Cognos Analytics
Use CData Connect AI to connect to Adobe Analytics Data from Cognos Analytics and analyze live Adobe Analytics data.
-
Bidirectional Access to Slack Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Slack data in Filemaker Pro for Mac or Windows.
-
Build Apps with Live Bugsnag Data Using the Low-Code Development Platform of Mendix
Connect Bugsnag data with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to Paymo Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Paymo data.
-
Connect Qualaroo to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Qualaroo data using the CData Python MCP Server.
-
Connect to Live Procore Data in MicroStrategy through CData Connect AI
Create a live connection to Procore Data in CData Connect AI and connect to your Procore data from MicroStrategy.
-
Automate Google Forms Data Replication to SAP HANA
Use CData Sync to customize and automate Google Forms data replication to SAP HANA.
-
How to Connect to Live API 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 API data for you.
-
Design BIRT Reports on Mixpanel Data
Provide current Mixpanel data to your embedded analytics.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Cassandra
Provide connectivity to Cassandra data through an SAP BusinessObjects universe.
-
Analyze Azure Synapse Data in Cognos Analytics
Use CData Connect AI to connect to Azure Synapse Data from Cognos Analytics and analyze live Azure Synapse data.
-
Import Azure Table Data Using Azure Data Factory
Use CData Connect AI to connect to Azure Table Data from Azure Data Factory and import live Azure Table data.
-
Build Semantic Layer Views for Pipedrive Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Pipedrive data.
-
Publish Datadog-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Datadog data.
-
Automated Continuous xBase Replication to MongoDB
Use CData Sync for automated, continuous, customizable xBase replication to MongoDB.
-
Replicate Multiple HubSpot Accounts
Replicate multiple HubSpot accounts to one or many databases.
-
Printify Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Printify facts in real time.
-
Connect to Epicor Kinetic Data from a Connection Pool in Jetty
The Epicor Kinetic JDBC Driver supports connection pooling: This article shows how to connect faster to Epicor Kinetic data from Web apps in Jetty.
-
Connect to Kafka Data in JRuby
Create a simple JRuby app with access to live Kafka data.
-
Working with HubDB Data in LINQPad
Execute LINQ queries to HubDB data in LINQPad.
-
How to connect to SAP Ariba Source Data from Spring Boot
Connect to SAP Ariba Source in a Spring Boot Application using the CData JDBC Driver for SAP Ariba Source
-
Build Dashboards with Nethunt Data in DBxtra
Create dynamic dashboards and perform analytics based on Nethunt data in DBxtra.
-
Using the CData Software ODBC Driver for Deel in PyCharm
Connect to Deel as an ODBC data source in PyCharm using the CData Software ODBC Driver for Deel.
-
Integrate with SendGrid Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SendGrid data to a JSON file on disk.
-
Replicate Multiple Harvest Accounts
Replicate multiple Harvest accounts to one or many databases.
-
How to create an RPA flow for Monday.com Data in UiPath Studio
Use the Monday.com ODBC Driver to create workflows that access real-time Monday.com data without any coding.
-
Replicate Egnyte Data to Multiple Databases
Replicate Egnyte data to disparate databases with a point-and-click configuration.
-
Build Dashboards with Tanda Data in Dundas BI
Create dynamic dashboards and perform analytics based on Tanda data in Dundas BI.
-
How to Seamlessly Import ChartMogul Data into IBM SPSS Modeler
Integrate ChartMogul data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Load Bullhorn CRM Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Bullhorn CRM data to a database.
-
Migrating data from Brex to Databricks using CData SSIS Components.
Easily push Brex data to Databricks using the CData SSIS Tasks for Brex and Databricks.
-
Access QuickBooks Time Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access QuickBooks Time data from your Oracle system.
-
How to use SQLAlchemy ORM to access MYOB AccountRight Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of MYOB AccountRight data.
-
How to Connect to Live Anaplan Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Anaplan data for you.
-
Extract, Transform, and Load Adobe Analytics Data in Informatica PowerCenter
Create a simple Workflow for Adobe Analytics data in Informatica PowerCenter.
-
Integrating GitHub Copilot with OpenWeatherMap 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.
-
Build FormSite-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to FormSite data and build web apps with connectivity to live FormSite data.
-
Create a Data Access Object for Amazon Marketplace Data using JDBI
A brief overview of creating a SQL Object API for Amazon Marketplace data in JDBI.
-
Access Live ShipEngine Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate ShipEngine data into the statistical analysis tools available in SAS JMP. This article shows how to use ShipEngine data in the Graph Builder and Query Builder.
-
How to Connect Bitbucket 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 Bitbucket data in real time using natural language.
-
Manage Aweber Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Aweber.
-
How to Work with MarkLogic Data in AWS Glue Jobs Using JDBC
Connect to MarkLogic from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use the CData Software ODBC Driver for Lakebase in MicroStrategy Web
Connect to Lakebase data in MicroStrategy Web using the CData Software ODBC Driver for Lakebase.
-
Connect to SAP Fieldglass Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for SAP Fieldglass and the Script function in FileMaker Pro to connect to SAP Fieldglass and work with SAP Fieldglass data in your FileMaker application.
-
Use the CData Software ODBC Driver for Printify in SAS for Real-Time Reporting and Analytics
Connect to real-time Printify data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Printify.
-
Add Clockify Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Clockify with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automate Greenhouse Data Replication to Couchbase
Use CData Sync to Customize and automate Greenhouse data replication to Couchbase.
-
Analyze SAP SuccessFactors LMS Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of SAP SuccessFactors LMS data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Create Aircall Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Aircall data access from reports, embedded analytics, and more.
-
Automated Continuous Testmonitor Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Testmonitor replication to Azure SQL Database.
-
How to Seamlessly Import Sendwithus Data into IBM SPSS Modeler
Integrate Sendwithus data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Access FreshBooks Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access FreshBooks data from your Oracle system.
-
Model Amazon Athena Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Amazon Athena, enabling the direct import of real-time Amazon Athena data.
-
Establish a Live Connection with Bitbucket Data using Tableau Bridge
The CData ODBC Driver for Bitbucket enables you to integrate live Bitbucket data into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous Reply.io Replication to Oracle
Use CData Sync for automated, continuous, customizable Reply.io replication to Oracle.
-
Create Google Ad Manager-Connected Nintex Workflows
Use CData Connect AI to connect to Google Ad Manager Data from Nintex Workflow Cloud and build custom workflows using live Google Ad Manager data.
-
Query, Visualize, and Share live YouTube Analytics Data in Redash
Use CData Connect AI to connect to live YouTube Analytics data in Redash for querying, visualizing, and sharing.
-
How to Create Power BI Visual Reports with Real-Time LaunchDarkly Data
Use CData Power BI Connectors to visualize LaunchDarkly data in Power BI.
-
Connect to Ontraport Data in Aqua Data Studio
Access Ontraport data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to SuiteCRM Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SuiteCRM as an External Source in Dremio.
-
Integrate Recurly Data in Pentaho Data Integration
Build ETL pipelines based on Recurly data in the Pentaho Data Integration tool.
-
Replicate ZohoDesk Data from PowerShell
Write a quick PowerShell script to query ZohoDesk data. Use connectivity to the live data to replicate ZohoDesk data to SQL Server.
-
Connecting GenSpark with Dynamics 365 Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Dynamics 365 data without any replication or custom integration required.
-
Access Live Oracle Service Cloud 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 Oracle Service Cloud data through MCP integration.
-
Integrate Goose with Live Dynamics CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Dynamics CRM data from within the local AI agent.
-
Integrate Trae with Live iContact Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live iContact data from within the AI-powered IDE.
-
Visualize Excel Online Data in Sisense
Create an ElastiCube in Sisense app with access to Excel Online data.
-
Use Azure AI Foundry to Talk to Your GetResponse 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 GetResponse data for you.
-
Visualize Live SendGrid Data in the Power BI Service
Use CData Connect AI to connect to live SendGrid data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Analyze SAP Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SAP from Power Pivot. You will use the Table Import Wizard to load SAP data. You can visually build the import query or use any SQL supported by the driver.
-
Provide OData Services of SingleStore Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SingleStore data by developing a WCF Service Application.
-
Query, Visualize, and Share live Blackbaud FE NXT Data in Redash
Use CData Connect AI to connect to live Blackbaud FE NXT data in Redash for querying, visualizing, and sharing.
-
Access Live Google Cloud Storage Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Google Cloud Storage data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Access Live AfterShip Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live AfterShip data from your Google Sheets.
-
Feed Tavily Data into FineReport
How to set Tavily data as a JDBC data source in FineReport.
-
Access Live Ontraport Data in AWS Lambda
Connect to live Ontraport data in AWS Lambda using the CData JDBC Driver.
-
Build a Simple VCL Application for HDFS Data
How to build a simple VCL Application to view HDFS data in RAD Studio using the CData ODBC Driver for HDFS.