CData Software - Knowledge Base
Recent Articles
-
Visualize LeadDesk 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 LeadDesk into TIBCO Spotfire.
-
Automated Continuous MailerLite Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable MailerLite replication to delimited files (CSV/TSV).
-
Create Data Visualizations Based On Act CRM Data in Mode
Use CData Connect AI to connect to Act CRM Data from Mode and build visualizations using live
-
Automate Datadog Data Replication to Couchbase
Use CData Sync to Customize and automate Datadog replication to Couchbase.
-
Replicate PivotalTracker Data to Multiple Databases via the CData Sync CLI
Replicate PivotalTracker to disparate databases with a single configuration.
-
Build Voice Agents in ElevenLabs with access to Live LinkedIn Ads Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live LinkedIn Ads.
-
Access Live GitLab Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live GitLab from your Excel spreadsheets.
-
Automated Continuous DocuSign Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable DocuSign replication to Google Cloud SQL.
-
Create Apps from Avalara AvaTax Data in Qlik Sense Cloud
Use CData Connect AI to connect to Avalara AvaTax Data and build apps from live Avalara AvaTax in Qlik Sense Cloud.
-
Integrate Real-Time Access to Reckon in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Reckon in real time.
-
Automated Continuous Reckon Replication to Vertica
Use CData Sync for automated, continuous, customizable Reckon replication to Vertica.
-
How to Build an ETL App for JSON Services in Python with CData
Create ETL applications and real-time data pipelines for JSON in Python with petl.
-
Automated Confluence Data Replication to Teradata
Use CData Sync to Customize and automate Atlassian Confluence replication to Teradata.
-
How to publish and share Opsgenie Data dashboards with Tableau Server
The CData ODBC driver for Opsgenie enables you integrate Opsgenie into Tableau dashboards.
-
How to connect to Close Data in DBVisualizer
Integrate Close with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate Planio Data in the Pentaho Report Designer
Publish reports based on Planio in the Pentaho BI tool.
-
Integrate Open WebUI with Live Azure Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Azure Analysis Services from within the chat interface.
-
Integrating Codex CLI with ZeroBounce 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.
-
How to Connect to Nethunt Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Nethunt. Leverage the pyodbc module for ODBC in Python.
-
Add JDBC-ODBC Bridge Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for JDBC-ODBC Bridge with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous SAP Ariba Source Replication to SQL Server
Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to SQL Server.
-
Connect to Google Ads Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Google Ads as an External Source in Dremio.
-
Integrate Goose with Live Sage Intacct Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Sage Intacct from within the local AI agent.
-
Integrating LangChain with Okta Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Okta within automated workflows.
-
Stream Pipedrive Data into Apache Kafka Topics
Access and stream Pipedrive in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build Automated Office 365-Connected Workflows in Zapier
Use CData Connect AI to connect to live Microsoft Office 365 and build automated workflows in Zapier.
-
Build Automated Databricks-Connected Workflows in Zapier
Use CData Connect AI to connect to live Databricks and build automated workflows in Zapier.
-
Query Anaplan Data in DataGrip
Create a Data Source for Anaplan in DataGrip and use SQL to query live Anaplan.
-
Getting Started with the CData Power BI Connector for SendInBlue
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connect and Query Live Google Ads Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Google Ads into Databricks
-
Create Power BI Reports on Real-Time Webflow Data
Use the CData ODBC Driver for Webflow to visualize Webflow in Power BI Desktop.
-
Build Apps with Live Act-On in Adalo using CData Connect AI
Use CData Connect AI to integrate live Act-On into the Adalo platform and build custom mobile and web applications with real-time Act-On.
-
Build Google Search-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Google Search to explore live Google Search Results in Gemini Code Assist to assist with building Google Search-powered applications.
-
Integrating Codex CLI with Exact Online 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.
-
Integrate Live Reckon Accounts Hosted Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Reckon Accounts Hosted from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Reckon Accounts Hosted.
-
Use CData Connect AI to Access Okta Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Okta in the Power Pivot business intelligence tool.
-
Visualize Shopify Data in TIBCO Spotfire through OData
Integrate Shopify into dashboards in TIBCO Spotfire.
-
Use the CData Software ODBC Driver for SAP HANA in MicroStrategy Desktop
Connect to SAP HANA in MicroStrategy Desktop using the CData Software ODBC Driver for SAP HANA.
-
Bridge Exa Connectivity with Apache NiFi
Access and process Exa in Apache NiFi using the CData JDBC Driver.
-
Publish Todoist-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Todoist.
-
How to Connect to Webex Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Webex. Leverage the pyodbc module for ODBC in Python.
-
Process & Analyze Miro Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Miro Data.
-
Build Databricks-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Databricks.
-
Connect to Salesforce CRM Analytics Data from a Connection Pool in Jetty
The Salesforce CRM Analytics JDBC Driver supports connection pooling: This article shows how to connect faster to Salesforce CRM Analytics from Web apps in Jetty.
-
Connect to Real-Time Bitbucket Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Bitbucket and Dataflow to import and use Bitbucket in Power Apps.
-
Extend Google Sheets with Google Ad Manager Data
Make calls to Google Ad Manager from Google Apps Script via the API Server.
-
Connect Oracle Financials Cloud to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Oracle Financials Cloud with IBM WebSphere for seamless data integration and connectivity.
-
Configure the CData JDBC Driver for Dropbox in a Connection Pool in Tomcat
Connect to Dropbox from a connection pool in Tomcat.
-
Automated Continuous Dynamics 365 Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Dynamics 365 replication to delimited files (CSV/TSV).
-
Natively Connect to PivotalTracker Data in PHP
The CData ODBC driver for PivotalTracker enables you to create PHP applications with connectivity to PivotalTracker. Leverage the native support for ODBC in PHP.
-
Access Amazon Athena Data from MySQL in PHP
Connect to Amazon Athena through the standard MySQL libraries in PHP.
-
Access Live Browserless Data in AWS Lambda
Connect to live Browserless in AWS Lambda using the CData JDBC Driver.
-
Publish Oracle Service Cloud-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Oracle Service Cloud.
-
Connect to Accelo Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Accelo using standard SQL.
-
Build AI/ML Models with Live Twilio Data using Dataiku
Connect Twilio Data with Dataiku using the CData JDBC Driver for Twilio.
-
Build Charts with Quickbase Data in Clear Analytics
Create dynamic charts and perform analytics based on Quickbase in Clear Analytics.
-
Use the CData Software JDBC Driver for Google Tasks in MicroStrategy
Connect to Google Tasks in MicroStrategy Developer using the CData Software JDBC Driver for Google Tasks.
-
Connect to Oracle Eloqua Reporting Data in HULFT Integrate
Connect to Oracle Eloqua Reporting as a JDBC data source in HULFT Integrate
-
How to Connect to Live Freshservice Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Freshservice for you.
-
Connect to SAP SuccessFactors Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SAP SuccessFactors to connect to SAP SuccessFactors and execute queries in PowerBuilder.
-
Use Azure AI Foundry to Talk to Your Stripe 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 Stripe for you.
-
View Reports on Real-Time Amazon DynamoDB Data in Power BI Report Server
Use the CData ODBC Driver for Amazon DynamoDB to visualize Amazon DynamoDB in Power BI Desktop and then publish them to Power BI Report Server.
-
Build Visualizations of Smartsheet Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Smartsheet in Birst.
-
Build an OLAP Cube in SSAS from Google Sheets Data
Establish a connection to Google Sheets data from SQL Server Analysis Services, and use the Google Sheets Data Provider to build OLAP cubes for use in analytics and reporting.
-
Natively Connect to Zoho Creator Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Zoho Creator. Leverage the native support for ODBC in PHP.
-
Automated Continuous Elasticsearch Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Elasticsearch replication to OneLake in Microsoft Fabric.
-
Back Up Smartsheet to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Smartsheet. In this article, we will employ an SSIS workflow to populate a database with Smartsheet data.
-
Load Okta Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Okta to a database.
-
Operational Reporting on SuiteCRM Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SuiteCRM.
-
Connect to Sage Intacct Data from PowerBuilder via JDBC
This article demonstrates how to access Sage Intacct from PowerBuilder using the Sage Intacct JDBC Driver.
-
Connect to Sage 200 Data in Claris FileMaker Pro
Use the CData ODBC Driver for Sage 200 in FileMaker Pro to connect to Sage 200 and work with Sage 200 in your FileMaker applications.
-
Configure the CData JDBC Driver for CockroachDB in a Connection Pool in Tomcat
Connect to CockroachDB from a connection pool in Tomcat.
-
Create SSAS Tabular Models from Epicor Kinetic Data
How to build a SQL Server Analysis Service Tabular Model from Epicor Kinetic using CData drivers.
-
Manage Pipeline CRM Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Pipeline CRM.
-
Connect to Redis Data in CloverDX (formerly CloverETL)
Transfer Redis using the visual workflow in the CloverDX data integration tool.
-
Getting Started with the CData Connect AI Python SDK for Oracle Eloqua
Install the CData Connect AI Python SDK to read and write live Oracle Eloqua with standard DB-API 2.0 Python code.
-
Bridge Pushbullet Connectivity with Apache NiFi
Access and process Pushbullet in Apache NiFi using the CData JDBC Driver.
-
Connect to Gmail Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Gmail in the Denodo Virtual DataPort Administrator.
-
Use the CData API Server to Access Slack Data in Microsoft PowerPivot
Use the CData API Server to connect to live Slack in the Power Pivot business intelligence tool.
-
Replicate Tally Data in Heroku for Use in Salesforce Connect
Replicate Tally ERP to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use the CData Software JDBC Driver for Wrike in MicroStrategy Web
Connect to Wrike in MicroStrategy Web using the CData Software JDBC Driver for Wrike.
-
Build Semantic Layer Views for Google Directory Data in APOS Live Data Gateway
Use the CData Connector for Google Directory in APOS Live Data Gateway to build Semantic Layer Views for Google Directory.
-
DataBind Controls to WordPress Data in Delphi
DataBind to WordPress in Delphi with standard data access components and controls.
-
Bridge HCL Domino Connectivity with Apache NiFi
Access and process HCL Domino in Apache NiFi using the CData JDBC Driver.
-
How to Visualize Oracle Financials Cloud 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 Oracle Financials Cloud in Python.
-
How to integrate Oracle Eloqua with Apache Airflow
Access and process Oracle Eloqua in Apache Airflow using the CData JDBC Driver.
-
Connecting Agentforce with Monday.com Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Monday.com for you.
-
Back Up Bannerbear to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Bannerbear data.
-
Automated Continuous Todoist Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Todoist replication to Apache Cassandra.
-
How to import SAP Concur Data into Apache Solr
Use the CData Software JDBC Driver for SAP Concur in Data Import Handler and create an automated import of SAP Concur to Apache Solr Enterprise Search platform.
-
Connect to Delighted Data in HULFT Integrate
Connect to Delighted as a JDBC data source in HULFT Integrate
-
Create Data Visualizations in Cognos BI with Sybase Data
Access Sybase as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create Data Visualizations Based On Freshservice Data in Mode
Use CData Connect AI to connect to Freshservice Data from Mode and build visualizations using live
-
Create Dynamic XML Grids Using the Infragistics XamDataGrid
Learn how you can connect XML to Infragistics XamDataGrid to build dynamic grids.
-
Viewing FreeAgent Data in RAD Studio Data Explorer
How to view FreeAgent in RAD Studio Data Explorer using the CData ODBC Driver for FreeAgent.
-
Connecting Moonlit Workflow with Adobe Analytics Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Adobe Analytics in real time.
-
Connect to Stripe Data from a Connection Pool in JBoss
Integrate Stripe into Java servlets: Use the Management Console in JBoss to install the Stripe JDBC Driver.
-
Integrating GitHub Copilot CLI with Nethunt 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.
-
How to publish and share GetResponse Data dashboards with Tableau Server
The CData ODBC driver for GetResponse enables you integrate GetResponse into Tableau dashboards.
-
How to use SQLAlchemy ORM to access Oracle HCM Cloud Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Oracle HCM Cloud.