CData Software - Knowledge Base
Recent Articles
-
Extract, Transform, and Load Oracle Data in Informatica PowerCenter
Create a simple Workflow for Oracle data in Informatica PowerCenter.
-
Import Smartsheet Data Using Azure Data Factory
Use CData Connect AI to connect to Smartsheet Data from Azure Data Factory and import live Smartsheet data.
-
Query RSS Feeds in DataGrip
Create a Data Source for RSS in DataGrip and use SQL to query live RSS feeds.
-
Use Dash to Build Web Apps on OneNote Data via CData Connect AI
Build interactive Dash web apps on live OneNote data using pandas and the CData Connect AI Python SDK.
-
Connect to Reckon Accounts Hosted Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Reckon Accounts Hosted.
-
Integrating Claude Code with GetResponse Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on GetResponse data within assisted coding and automated development workflows.
-
Integrate Dify with Live Cvent Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Cvent data.
-
Migrating data from Oracle Eloqua to Databricks using CData SSIS Components.
Easily push Oracle Eloqua data to Databricks using the CData SSIS Tasks for Oracle Eloqua and Databricks.
-
Connect to Real-Time Avalara AvaTax Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Avalara AvaTax and Dataflow to import and use Avalara AvaTax data in Power Apps.
-
Bind Live Cvent Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Cvent data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Connect to SharePoint Excel Services Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SharePoint Excel Services to connect to SharePoint Excel Services data and execute queries in PowerBuilder.
-
Connect to Splunk Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Splunk Data and connect to Splunk data in Akorbi Digital RunMyProcess.
-
Integrate Cursor with Live ZohoSubscriptions Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live ZohoSubscriptions data from within the editor.
-
Interact with Live Google Cloud Storage Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Google Cloud Storage data.
-
Connect to Bright Data Data from a Connection Pool in JBoss
Integrate Bright Data data into Java servlets: Use the Management Console in JBoss to install the Bright Data JDBC Driver.
-
Getting Started with the CData ODBC Driver for Exa
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Exa.
-
Integrating Claude Code CLI with Airtable 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 Excel Add-In for Smartsheet
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Smartsheet.
-
Connect to Excel Data in JRuby
Create a simple JRuby app with access to live Excel data.
-
How to integrate Metabase with Optimizely Data
Use CData Connect AI to connect to live Optimizely data and create an interactive dashboard in Metabase from Optimizely data.
-
How to connect to CSV Data with Squirrel SQL client
Connect to CSV data and execute queries in the Squirrel SQL Client.
-
Create Power BI Reports on Real-Time Lakebase Data
Use the CData ODBC Driver for Lakebase to visualize Lakebase data in Power BI Desktop.
-
Prepare, Blend, and Analyze MySQL Data in Alteryx Designer (ODBC)
Build workflows to access live MySQL data for self-service data analytics.
-
Create Exact Online-Connected Business Apps in AppSheet
Connect to Exact Online Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Exact Online data.
-
Connect to Cosmos DB Data in DBeaver
Use the CData ODBC Driver to connect to Cosmos DB data in DBeaver.
-
Build BenchmarkEmail Visualizations in Tableau Desktop
Use CData Connect AI to connect to live BenchmarkEmail data and build visualizations in Tableau.
-
Create Salesforce Marketing-Connected Nintex Workflows
Use CData Connect AI to connect to Salesforce Marketing Data from Nintex Workflow Cloud and build custom workflows using live Salesforce Marketing data.
-
How to create an RPA flow for Sendwithus Data in UiPath Studio
Use the Sendwithus ODBC Driver to create workflows that access real-time Sendwithus data without any coding.
-
Work with Live ZohoMarketingHub Data in Power Query
Use CData Connect AI to connect to ZohoMarketingHub data and work with live ZohoMarketingHub data in Microsoft Power Query.
-
How to Connect to Live Acumatica 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 Acumatica data for you.
-
How to Connect to OData Services in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to OData services. Leverage the pyodbc module for ODBC in Python.
-
Use JayDeBeApi to access Quaderno Data in Python
Use standard Python scripting and the development environment of your choice to access live Quaderno data.
-
Operational Reporting on ZohoPeople Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote ZohoPeople data.
-
How to publish and share Contentful Data dashboards with Tableau Server
The CData ODBC driver for Contentful enables you integrate Contentful data into Tableau dashboards.
-
Automated Continuous Pipeline CRM Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Pipeline CRM replication to Azure SQL Database.
-
Connect to Zoho Projects Data in DBArtisan
Use wizards in DBArtisan to configure Zoho Projects data as a data source.
-
Visualize Live Cassandra Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Cassandra data.
-
Integrate LibreChat with Live Notion Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Notion data from within the chat interface.
-
Viewing PhantomBuster Data in RAD Studio Data Explorer
How to view PhantomBuster data in RAD Studio Data Explorer using the CData ODBC Driver for PhantomBuster.
-
Connect to Authorize.Net Data in DBeaver
Use the CData ODBC Driver to connect to Authorize.Net data in DBeaver.
-
Figshare Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Figshare facts in real time.
-
Access Live SAP Business Warehouse Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SAP Business Warehouse data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Continuous Keap Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Keap data replication to OneLake in Microsoft Fabric.
-
Access Live Anaplan 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 Anaplan data through MCP integration.
-
A PostgreSQL Interface for Aha! Data using the CData ODBC Driver
Use the SQL Gateway and Aha! ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Access eBay Data Using Entity Framework
This article shows how to access eBay data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to PagerDuty Data in Aqua Data Studio
Access PagerDuty data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous AgileCRM Replication to Databricks
Use CData Sync for automated, continuous, customizable AgileCRM replication to Databricks.
-
Integrate Spark Data in the Pentaho Report Designer
Publish reports based on Spark data in the Pentaho BI tool.
-
Access Live Printful Data in AWS Lambda
Connect to live Printful data in AWS Lambda using the CData JDBC Driver.
-
Automated Continuous Aweber Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Aweber replication to delimited files (CSV/TSV).
-
Query Live ZohoExpense 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 ZohoExpense data through a conversational interface.
-
Perform Batch Operations with ActiveCampaign Data in Apache NiFi
Connect to ActiveCampaign data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Access Live Coda Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Coda data into the statistical analysis tools available in SAS JMP. This article shows how to use Coda data in the Graph Builder and Query Builder.
-
Add Lakebase Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Lakebase with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Brex Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Brex data.
-
Getting Started with the CData Tableau Connector for Aircall
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Connect to QuickBooks Time Data in RapidMiner
Integrate QuickBooks Time data with standard components and data source configuration wizards in RapidMiner Studio.
-
Automate Tavily Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Tavily data from PowerShell? This article demonstrates how to utilize the Tavily Cmdlets for tasks like connecting to Tavily data, automating operations, downloading data, and more.
-
Use Azure AI Foundry to Talk to Your SAP HANA 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 SAP HANA data for you.
-
Use JayDeBeApi to access Zoom Data in Python
Use standard Python scripting and the development environment of your choice to access live Zoom data.
-
Edit and Search External Marketo Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Marketo data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Marketo Data objects that you can access from apps and the dashboard.
-
Connect to and Visualize Live MarkLogic Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live MarkLogic data.
-
Build Visualizations of Twitter Ads Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Twitter Ads data in Birst.
-
Connect to PabblySubscriptions Data in CloverDX (formerly CloverETL)
Transfer PabblySubscriptions data using the visual workflow in the CloverDX data integration tool.
-
Query SendGrid Data as a MySQL Database in Node.js
Execute MySQL queries against SendGrid data from Node.js.
-
ETL Oracle HCM Cloud in Oracle Data Integrator
This article shows how to transfer Oracle HCM Cloud data into a data warehouse using Oracle Data Integrator.
-
How to Build an ETL App for Amplitude Data in Python with CData
Create ETL applications and real-time data pipelines for Amplitude data in Python with petl.
-
Integrating Gumloop with Amazon S3 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Amazon S3 data within automated workflows.
-
Automate Paymo Data Replication to Couchbase
Use CData Sync to Customize and automate Paymo data replication to Couchbase.
-
Configure the CData JDBC Driver for Azure Analysis Services in a Connection Pool in Tomcat
Connect to Azure Analysis Services data from a connection pool in Tomcat.
-
Work with PayPal Data in FoxPro
Load PayPal data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate Google's Antigravity Agent with Live Gong Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Gong data using the Model Context Protocol.
-
Create Google Ad Manager-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Google Ad Manager Data from Klipfolio and build custom visualizations using live Google Ad Manager data.
-
Create Apps from EnterpriseDB Data in Qlik Sense Cloud
Use CData Connect AI to connect to EnterpriseDB Data and build apps from live EnterpriseDB data in Qlik Sense Cloud.
-
Getting Started with the CData Connect AI Python SDK for QuickBooks Online
Install the CData Connect AI Python SDK to read and write live QuickBooks Online data with standard DB-API 2.0 Python code.
-
Integrate LibreChat with Live Cvent Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Cvent data from within the chat interface.
-
Integrating LlamaIndex with MailChimp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on MailChimp data in real time.
-
Access Live SAP Business One Data in Coginiti Pro
Connect to and query live SAP Business One data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrate with Insightly Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Insightly data to a JSON file on disk.
-
DataBind Discord Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Discord data to a chart.
-
Manage Twitter Ads Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Twitter Ads.
-
Integrate with Wave Financial Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Wave Financial data in SnapLogic.
-
Analyze Grafana Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Grafana data with the CData JDBC Driver for Grafana.
-
How to publish and share Google Directory Data dashboards with Tableau Server
The CData ODBC driver for Google Directory enables you integrate Google Directory data into Tableau dashboards.
-
Getting Started with the CData Tableau Connector for NetSuite
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for NetSuite.
-
Integrating Cursor with JobNimbus 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.
-
Query, Visualize, and Share live ActiveCampaign Data in Redash
Use CData Connect AI to connect to live ActiveCampaign data in Redash for querying, visualizing, and sharing.
-
How to Query Live Pinecone Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Pinecone data data in natural language using Python.
-
Edit and Search External Google Directory Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Google Directory data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Google Directory Data objects that you can access from apps and the dashboard.
-
Process & Analyze Spark Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Spark Data.
-
DataBind Google Ad Manager Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Google Ad Manager with the DevExpress Windows Forms and Web controls to provide Google Ad Manager data to a chart.
-
Build ServiceNow Visualizations in Tableau Cloud
Use CData Connect AI to connect to live ServiceNow data and build visualizations in Tableau Cloud.
-
Integrate with Active Directory Data in JReport Designer
Create charts and reports based on Active Directory data in JReport Designer.
-
Create Dashboards and Visualize Live Printify Data in Geckoboard
Use CData Connect AI to connect to live Printify data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Build Optimizely-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Optimizely data.
-
Design BIRT Reports on Customer.io Data
Provide current Customer.io data to your embedded analytics.
-
Connect to Rebilly Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Rebilly and work with Rebilly data in your FileMaker application.
-
Analyze Qualaroo Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Qualaroo data with the CData JDBC Driver for Qualaroo.
-
Use the CData Software JDBC Driver for MarkLogic in MicroStrategy Web
Connect to MarkLogic data in MicroStrategy Web using the CData Software JDBC Driver for MarkLogic.