CData Software - Knowledge Base
Recent Articles
-
Create Informatica Mappings From/To a JDBC Data Source for Zuora
Create Zuora data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automate Dynamics CRM Data Replication to Azure Data Lake
Use CData Sync to customize and automate Dynamics CRM data replication to Azure Data Lake.
-
Build Pipelines with Live Greenplum Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Greenplum from Google Cloud Data Fusion, enabling the integration of live Greenplum data into the building and management of effective data pipelines.
-
Use the CData Software ODBC Driver for Pinterest in MicroStrategy Desktop
Connect to Pinterest data in MicroStrategy Desktop using the CData Software ODBC Driver for Pinterest.
-
How to Connect to Live Greenplum 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 Greenplum data for you.
-
Deploy the ADO.NET Provider for Todoist on an SSRS Report Server
Connect to Todoist 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.
-
Access SharePoint Excel Services Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SharePoint Excel Services data from your Oracle system.
-
Connect to Klipfolio Data in Aqua Data Studio
Access Klipfolio data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Visualize Google Sheets 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 Google Sheets data in Python.
-
How to import Klipfolio Data into Apache Solr
Use the CData Software JDBC Driver for Klipfolio in Data Import Handler and create an automated import of Klipfolio data to Apache Solr Enterprise Search platform.
-
How to create an RPA flow for Paymo Data in UiPath Studio
Use the Paymo ODBC Driver to create workflows that access real-time Paymo data without any coding.
-
Prepare, Blend, and Analyze Perplexity Data in Alteryx Designer (ODBC)
Build workflows to access live Perplexity data for self-service data analytics.
-
Integrate Trae with Live Hive Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Hive data from within the AI-powered IDE.
-
View Reports on Real-Time Phoenix Data in Power BI Report Server
Use the CData ODBC Driver for Phoenix to visualize Phoenix data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to connect to Egnyte Data from IntelliJ
Integrate connectivity to Egnyte data with wizards in IntelliJ.
-
Connect to TaxJar Data in Aqua Data Studio
Access TaxJar data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Feed Demio Data into FineReport
How to set Demio data as a JDBC data source in FineReport.
-
Import Real-Time Amplitude Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Amplitude data in ColdFusion.
-
How to Work with BambooHR Data in ETL Validator JDBC
Connect to BambooHR from ETL Validator jobs using the CData Software JDBC Driver.
-
Replicate Multiple Sendwithus Accounts
Replicate multiple Sendwithus accounts to one or many databases.
-
Use Dash to Build to Web Apps on ShipStation Data
Create Python applications that use pandas and Dash to build ShipStation-connected web apps.
-
How to integrate Facebook Ads with Apache Airflow
Access and process Facebook Ads data in Apache Airflow using the CData JDBC Driver.
-
Access Live Facebook Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Facebook data into the statistical analysis tools available in SAS JMP. This article shows how to use Facebook data in the Graph Builder and Query Builder.
-
How to Access Live HBase Data in Power Automate Desktop via ODBC
The CData ODBC Driver for HBase enables you to integrate HBase data into workflows built using Microsoft Power Automate Desktop.
-
Connect to PolarTeamPro Data from a Connection Pool in Jetty
The PolarTeamPro JDBC Driver supports connection pooling: This article shows how to connect faster to PolarTeamPro data from Web apps in Jetty.
-
Viewing Kintone Data in RAD Studio Data Explorer
How to view Kintone data in RAD Studio Data Explorer using the CData ODBC Driver for Kintone.
-
Natively Connect to Access Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Access data. Leverage the native support for ODBC in PHP.
-
Connect to Mailjet Data in JRuby
Create a simple JRuby app with access to live Mailjet data.
-
Access Live VWO Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live VWO data from your Excel spreadsheets.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for QuickBooks
Provide connectivity to QuickBooks data through an SAP BusinessObjects universe.
-
Publish Reports with Todoist Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Todoist data.
-
Integrating Cursor with Bitbucket 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.
-
Use Microsoft Copilot Studio to talk to your SAS Data Sets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your SAS Data Sets data for you.
-
Integrate Devin with Live Vault CRM 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 Vault CRM data.
-
Connect to Grafana Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Grafana data from Filemaker Pro on Mac.
-
Automated Continuous Hacker News Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Hacker News replication to Amazon S3.
-
Automate Zoho Recruit Data Replication to Azure Synapse
Use CData Sync to customize and automate Zoho Recruit data replication to Azure Synapse.
-
Connect to Xero Data in Google Apps Script via Connect AI
Use CData Connect AI to access Xero data in Google Apps Script.
-
Establish a Live Connection with Miro Data using Tableau Bridge
The CData ODBC Driver for Miro enables you to integrate live Miro data into Tableau Cloud dashboards using the Tableau Bridge.
-
Natively Connect to CampaignMonitor Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to CampaignMonitor data. Leverage the native support for ODBC in PHP.
-
Build a Simple VCL Application for Smartsheet Data
How to build a simple VCL Application to view Smartsheet data in RAD Studio using the CData ODBC Driver for Smartsheet.
-
Use the CData Software ODBC Driver for Google Ads in MicroStrategy Desktop
Connect to Google Ads data in MicroStrategy Desktop using the CData Software ODBC Driver for Google Ads.
-
Query Live Google Ads 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 Google Ads data through a conversational interface.
-
Connect to and Visualize Live Clari Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Clari data.
-
Use CData Connect AI to Access Oracle Eloqua Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Oracle Eloqua data in the Power Pivot business intelligence tool.
-
Build Voice Agents in ElevenLabs with access to Live Timely Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Timely data.
-
Getting Started with the CData JDBC Driver for Instantly
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Instantly.
-
Connect to and Query Smartsheet Data in QlikView over ODBC
Create data visualizations with Smartsheet data in QlikView.
-
View Reports on Real-Time Klipfolio Data in Power BI Report Server
Use the CData ODBC Driver for Klipfolio to visualize Klipfolio data in Power BI Desktop and then publish them to Power BI Report Server.
-
Using the CData Software ODBC Driver for LinkedIn in PyCharm
Connect to LinkedIn as an ODBC data source in PyCharm using the CData Software ODBC Driver for LinkedIn.
-
Create Apps from Outreach.io Data in Qlik Sense Cloud
Use CData Connect AI to connect to Outreach.io Data and build apps from live Outreach.io data in Qlik Sense Cloud.
-
Getting Started with the CData Python Connector for PagerDuty
Learn to install and license the CData Python Connector and configure a connection to live PagerDuty data.
-
Bind Live Dropbox Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Dropbox data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Connect to Timely Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Timely as an External Source in Dremio.
-
Automated Square Data Replication to Teradata
Use CData Sync to Customize and automate Square data replication to Teradata.
-
Viewing HubSpot Data in RAD Studio Data Explorer
How to view HubSpot data in RAD Studio Data Explorer using the CData ODBC Driver for HubSpot.
-
Analyze ZohoExpense Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze ZohoExpense data with the CData JDBC Driver for ZohoExpense.
-
Connect to Greenhouse Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Greenhouse data in the Denodo Virtual DataPort Administrator.
-
Connect to Teradata Data from PowerBuilder via ADO.NET
This article demonstrates how to access Teradata data from Appeon PowerBuilder using the CData ADO.NET Provider for Teradata.
-
Connect to Harvest Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Harvest.
-
Automated Continuous Toggl Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Toggl replication to Apache Kafka.
-
Replicate Cohere Data to Multiple Databases
Replicate Cohere data to disparate databases with a point-and-click configuration.
-
Automated Continuous Datadog Replication to MongoDB
Use CData Sync for automated, continuous, customizable Datadog replication to MongoDB.
-
Outreach.io Reporting in OBIEE with the Outreach.io JDBC Driver
Deploy the Outreach.io JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Visualize LightSpeedRetail Data in Sisense
Create an ElastiCube in Sisense app with access to LightSpeedRetail data.
-
How to Query Invoiced Data in MySQL Workbench
Execute MySQL queries against live Invoiced data from MySQL Workbench.
-
Getting Started with the CData JDBC Driver for Adobe Analytics
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Adobe Analytics.
-
Working with Egnyte Data in LINQPad
Execute LINQ queries to Egnyte data in LINQPad.
-
Create Wave Financial-Connected Applications in Appsmith
Connect to Wave Financial Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Wave Financial data.
-
Use the CData Software JDBC Driver for SAP SuccessFactors LMS in MicroStrategy
Connect to SAP SuccessFactors LMS data in MicroStrategy Developer using the CData Software JDBC Driver for SAP SuccessFactors LMS.
-
Publish Wrike-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Wrike data.
-
How to Connect to Salesforce Pardot Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Salesforce Pardot data. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous Active Directory Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Active Directory replication to Google Cloud SQL.
-
Getting Started with the CData ADO.NET Provider for Cassandra
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Cassandra.
-
Integrate Opsgenie with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Opsgenie with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Opsgenie data.
-
Use Agno to Talk to Your Airtable 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 Airtable data for you.
-
How to connect to Workday Data from IntelliJ
Integrate connectivity to Workday data with wizards in IntelliJ.
-
Integrate Trae with Live Highrise Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Highrise data from within the AI-powered IDE.
-
Automated Continuous Google Forms Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Google Forms replication to IBM DB2.
-
Build a PostgreSQL Interface for Aircall Data using the CData JDBC Driver
Use the Remoting features of the Aircall JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Cline with Live ADP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live ADP data from within your IDE.
-
Creating SAP Hybris C4C-Connected Applications in Unqork
You can use CData Connect AI to feed SAP Hybris C4C data to Unqork and build custom business apps.
-
Integrate Microsoft Dataverse with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Microsoft Dataverse with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Microsoft Dataverse data.
-
Connect Humanity Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Humanity data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to connect and process Tavily data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Tavily data.
-
Use Databricks Agent Bricks to Talk to Your Adobe Experience Manager Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Adobe Experience Manager data for you.
-
Use the CData Software JDBC Driver for JDBC-ODBC Bridge in MicroStrategy Web
Connect to JDBC-ODBC Bridge data in MicroStrategy Web using the CData Software JDBC Driver for JDBC-ODBC Bridge.
-
Connect to Salesforce Marketing Data from a Connection Pool in JBoss
Integrate Salesforce Marketing data into Java servlets: Use the Management Console in JBoss to install the Salesforce Marketing JDBC Driver.
-
Automated Continuous Mouseflow Replication to Snowflake
Use CData Sync for automated, continuous, customizable Mouseflow replication to Snowflake.
-
Connecting Moonlit Workflow with DB2 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 DB2 data in real time.
-
Build a Singer.io Tap for JobNimbus With the CData Python Connector
Learn how to easily build a Singer.io Tap for live JobNimbus data using the CData Python Connector.
-
Integrate Real-Time Access to Gmail in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Gmail data in real time.
-
Rapidly Develop JSON-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by JSON.
-
Integrating Codex with Landbot 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 Microsoft OneDrive-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Microsoft OneDrive Data and create custom apps in Bubble.
-
Analyze Salesforce CRM Analytics Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Salesforce CRM Analytics data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to Rebilly Data in Jaspersoft Studio
Execute SQL to remote Rebilly data in Jaspersoft Studio.
-
Create Jira-Connected Dashboards in Grafana
Connect to Jira Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Jira data.
-
Automated Continuous GraphQL Replication to SQL Server
Use CData Sync for automated, continuous, customizable GraphQL replication to SQL Server.
-
How to Connect to Teradata Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Teradata data. Leverage the pyodbc module for ODBC in Python.