CData Software - Knowledge Base
Recent Articles
-
Integrate Live Impala Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Apache Impala to Blue Prism using the CData ODBC Driver for Impala to create automated workflows for repetitive business tasks.
-
Build Agents in Relevance AI with Access to Live CockroachDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on CockroachDB within intelligent agent workflows.
-
How to Connect to Vimeo Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Vimeo. Leverage the pyodbc module for ODBC in Python.
-
Connect to Intercom Data in RazorSQL
Connect to Intercom from wizards and query Intercom from the GUI in the RazorSQL database management tool.
-
How to Visualize Vault CRM 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 Veeva Vault & Vault CRM in Python.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live CSV/TSV Files within intelligent workflows.
-
Use Agno to Talk to Your NetSuite 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 NetSuite CRM & ERP for you.
-
Create Salesforce Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Salesforce data access from reports, embedded analytics, and more.
-
Access Live AdRoll Data in AWS Lambda
Connect to live AdRoll in AWS Lambda using the CData JDBC Driver.
-
Create Datasets from Reckon Accounts Hosted in Domo Workbench and Build Visualizations of Reckon Accounts Hosted Data in Domo
Use the CData Software ODBC Driver for Reckon Accounts Hosted to create datasets from Reckon Accounts Hosted in Domo Workbench and then build visualizations in the Domo service.
-
How to Connect to Live Outreach.io 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 Outreach.io for you.
-
Build SAP Concur-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for SAP Concur to explore live SAP Concur Data in Gemini Code Assist to assist with building SAP Concur-powered applications.
-
Import Real-Time Microsoft Entra ID Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Microsoft Entra ID in ColdFusion.
-
Import and Visualize Gmail Data in Power View
Create data visualizations based on Gmail in Excel.
-
Create Zoho Inventory-Connected Business Apps in AppSheet
Connect to Zoho Inventory Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Zoho Inventory.
-
Automated Continuous Redis Replication to SQLite
Use CData Sync for automated, continuous, customizable Redis replication to SQLite.
-
How to connect to Notion Data in DBVisualizer
Integrate Notion with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Amazon Athena Data Replication to Teradata
Use CData Sync to Customize and automate Amazon Athena replication to Teradata.
-
Build AI/ML Models with Live EmailOctopus Data using Dataiku
Connect EmailOctopus Data with Dataiku using the CData API Driver for JDBC.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Kafka actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Create Amplitude Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Amplitude data access from reports, embedded analytics, and more.
-
Connect to Postmark Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Postmark as an External Source in Dremio.
-
Integrating Cursor CLI with Zoho CRM 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.
-
Getting Started with the CData JDBC Driver for Azure DevOps
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Azure DevOps.
-
Create Dynamic Adobe Analytics Grids Using the Infragistics XamDataGrid
Learn how you can connect Adobe Analytics to Infragistics XamDataGrid to build dynamic grids.
-
Visualize Live Billsby Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Billsby.
-
Build Microsoft Entra ID-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Microsoft Entra ID Data and create custom apps in Mendix.
-
Visualize ServiceDesk Plus 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 ServiceDesk Plus into TIBCO Spotfire.
-
Getting Started with the CData JDBC Driver for Yelp
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Yelp.
-
How to Connect to Wave Financial Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Wave Financial. Leverage the pyodbc module for ODBC in Python.
-
Integrating Codex CLI with ServiceNow 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.
-
Configure the CData JDBC Driver for Sage 300 in a Connection Pool in Tomcat
Connect to Sage 300 from a connection pool in Tomcat.
-
Automated Continuous Flowlu Replication to SQL Server
Use CData Sync for automated, continuous, customizable Flowlu replication to SQL Server.
-
Sage 300 Reporting in OBIEE with the Sage 300 JDBC Driver
Deploy the Sage 300 JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrating GitHub Copilot CLI with PingOne 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 AI/ML Models with Live Dynamics 365 Business Central Data using Dataiku
Connect Dynamics 365 Business Central Data with Dataiku using the CData JDBC Driver for Dynamics 365 Business Central.
-
Connect to Gorgias Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Gorgias and the SQL Gateway to access Gorgias from Google Apps Script.
-
Moving Data from GraphQL to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live GraphQL data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Analyze ConstantContact Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ConstantContact from Power Pivot. You will use the Table Import Wizard to load ConstantContact. You can visually build the import query or use any SQL supported by the driver.
-
Stream SharePoint Excel Services Data into Apache Kafka Topics
Access and stream SharePoint Excel Services in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Query Hubstaff Data in MySQL Workbench
Execute MySQL queries against live Hubstaff from MySQL Workbench.
-
Query OpenWeatherMap Data as a MySQL Database in Node.js
Execute MySQL queries against OpenWeatherMap from Node.js.
-
Integrating Claude Code CLI with TaxJar 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.
-
Automate MongoDB Data Replication to SAP HANA
Use CData Sync to customize and automate MongoDB replication to SAP HANA.
-
Build CockroachDB-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to CockroachDB Data from Zoho Analytics and import live CockroachDB.
-
Integrating OpenCode Terminal with Sybase IQ 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.
-
Integrating QuickBooks Data in Talend Cloud Data Management Platform
Connect QuickBooks Data with Talend Cloud Data Management Platform using the CData JDBC Driver for QuickBooks.
-
How to Query PDFMonkey Data in MySQL Workbench
Execute MySQL queries against live PDFMonkey from MySQL Workbench.
-
Creating Zoho CRM-Connected Applications in Unqork
You can use CData Connect AI to feed Zoho CRM to Unqork and build custom business apps.
-
DataBind Controls to GraphQL Data in Delphi
DataBind to GraphQL in Delphi with standard data access components and controls.
-
Create Power BI Reports on Real-Time SAP Hybris C4C Data
Use the CData ODBC Driver for SAP Hybris C4C to visualize SAP Hybris C4C in Power BI Desktop.
-
Integrate with Amazon Athena Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Amazon Athena in SnapLogic.
-
Publish Templated-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Templated.
-
Analyze Airtable Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Airtable and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Automate Odoo Data Replication to Azure Synapse
Use CData Sync to customize and automate Odoo ERP replication to Azure Synapse.
-
How to Seamlessly Import TigerGraph Data into IBM SPSS Modeler
Integrate TigerGraph data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Trigger Avalara AvaTax IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Avalara AvaTax with standard wizards in Logic Apps.
-
Replicate ChargeOver Data to Multiple Databases
Replicate ChargeOver to disparate databases with a point-and-click configuration.
-
Bridge Humanity Connectivity with Apache NiFi
Access and process Humanity in Apache NiFi using the CData JDBC Driver.
-
How to Access PingOne Data Using Entity Framework
This article shows how to access PingOne using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Natively Connect to ZendeskSell Data in PHP
The CData ODBC driver for ZendeskSell enables you to create PHP applications with connectivity to ZendeskSell. Leverage the native support for ODBC in PHP.
-
How to work with Salesforce Marketing Data in Apache Spark using SQL
Access and process Salesforce Marketing Data in Apache Spark using the CData Software JDBC Driver.
-
Getting Started with the CData Tableau Connector for Codat
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Automate Zendesk Data Replication to Couchbase
Use CData Sync to Customize and automate Zendesk replication to Couchbase.
-
Analyze Snapchat Ads Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Snapchat Ads and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Getting Started with the CData ODBC Driver for ADP
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ADP.
-
Load SAP Netweaver Gateway Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SAP Netweaver Gateway to a database.
-
Bind Live Box Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Box data
-
Automated Continuous Omnisend Replication to Snowflake
Use CData Sync for automated, continuous, customizable Omnisend replication to Snowflake.
-
Automated Continuous GetResponse Replication to Amazon S3
Use CData Sync for automated, continuous, customizable GetResponse replication to Amazon S3.
-
Analyze Dynamics CRM Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Microsoft Dynamics CRM with the CData JDBC Driver for Dynamics CRM.
-
Consume Salesloft OData Feeds in PowerBuilder
This article demonstrates how to consume Salesloft as OData feeds from PowerBuilder using the API Server.
-
Integrate Slack Data into Power Automate Desktop using CData Connect
CData Connect for Slack Data enables you to integrate Slack into workflows built using Microsoft Power Automate Desktop.
-
Connect to MongoDB Data from PowerBuilder via JDBC
This article demonstrates how to access MongoDB from PowerBuilder using the MongoDB JDBC Driver.
-
How to Query Microsoft OneDrive Data in MySQL Workbench
Execute MySQL queries against live Microsoft OneDrive from MySQL Workbench.
-
Feed Onfleet Data into FineReport
How to set Onfleet as a JDBC data source in FineReport.
-
Automated Continuous Google Ads Replication to Snowflake
Use CData Sync for automated, continuous, customizable Google Ads replication to Snowflake.
-
Automate SAP Ariba Procurement Data Replication to Couchbase
Use CData Sync to Customize and automate SAP Ariba Procurement replication to Couchbase.
-
Integrate Redshift with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Redshift with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Amazon Redshift.
-
Access Live Salesforce Pardot 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 Salesforce Pardot through MCP integration.
-
Use CData Connect AI to Access Vault CRM Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Veeva Vault & Vault CRM in the Power Pivot business intelligence tool.
-
Replicate Multiple Tickspot Accounts
Replicate multiple Tickspot accounts to one or many databases.
-
Connect to and Visualize Live Calendly Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Calendly.
-
How to Build an ETL App for ActiveCampaign Data in Python with CData
Create ETL applications and real-time data pipelines for ActiveCampaign in Python with petl.
-
Perform Batch Operations with SingleStore Data in Apache NiFi
Connect to SingleStore and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Replicate Timely Data to Multiple Databases
Replicate Timely to disparate databases with a point-and-click configuration.
-
Work with Live Dynamics 365 Business Central Data in Power Query
Use CData Connect AI to connect to Dynamics 365 Business Central and work with live Dynamics 365 Business Central in Microsoft Power Query.
-
Query Google Ad Manager Data in DataGrip
Create a Data Source for Google Ad Manager in DataGrip and use SQL to query live Google Ad Manager.
-
How to Connect to Live Exact Online Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Exact Online without replication.
-
Connect to Presto Data from PowerBuilder via ADO.NET
This article demonstrates how to access Presto from Appeon PowerBuilder using the CData ADO.NET Provider for Presto.
-
Natively Connect to Google Search Results in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Google Search. Leverage the native support for ODBC in PHP.
-
Analyze DocuSign Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of DocuSign and visualize live DocuSign in Infragistics Reveal.
-
Establish a Live Connection with Browserless Data using Tableau Bridge
The CData ODBC Driver for Browserless enables you to integrate live Browserless into Tableau Cloud dashboards using the Tableau Bridge.
-
Create Informatica Mappings From/To an ODBC Data Source for GetResponse
Create an ODBC connection to GetResponse in Informatica and browse and transfer GetResponse.
-
Short.io Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Short.io facts in real time.
-
Integrate Presto with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Presto with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Presto.
-
Connect to Spark Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Apache Spark SQL.
-
Connect to Chargebee Data in Ruby
Connect to Chargebee in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Write a Simple Go Application to work with Highrise Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Highrise CRM.
-
Connect to Shopify Data in Ruby
Connect to Shopify in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.