CData Software - Knowledge Base
Recent Articles
-
Use the CData Software ODBC Driver for SharePoint in MicroStrategy Web
Connect to SharePoint data in MicroStrategy Web using the CData Software ODBC Driver for SharePoint.
-
Integrating Codex with Shopify 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 Grok to Talk to Your Azure Data Catalog Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Azure Data Catalog data for you.
-
Automated Continuous Flowlu Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Flowlu replication to Apache Kafka.
-
How to Work with Aweber Data in ETL Validator JDBC
Connect to Aweber from ETL Validator jobs using the CData Software JDBC Driver.
-
Build Apps with Live RabbitMQ Data Using the Low-Code Development Platform of Mendix
Connect RabbitMQ data with Mendix to build apps using the CData API Driver for JDBC.
-
Getting Started with the CData Connect AI Python SDK for FTP
Install the CData Connect AI Python SDK to read and write live FTP data with standard DB-API 2.0 Python code.
-
Bridge Datadog Connectivity with Apache NiFi
Access and process Datadog data in Apache NiFi using the CData JDBC Driver.
-
Integrate Coda Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Coda data and integrate live Coda data into your Power Automate tasks.
-
How to Easily Query ElevenLabs Data in OpenOffice Base
Connect to ElevenLabs data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to Live VWO Data in PostGresSQL Interface through CData Connect AI
Create a live connection to VWO in CData Connect AI and connect to your VWO data from PostgreSQL.
-
Connect to SAP HANA Data in JRuby
Create a simple JRuby app with access to live SAP HANA data.
-
Configure the CData JDBC Driver for Gong in a Connection Pool in Tomcat
Connect to Gong data from a connection pool in Tomcat.
-
Query Live Bitly 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 Bitly data through a conversational interface.
-
Import Real-Time Eventbrite Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Eventbrite data in ColdFusion.
-
Connect to Act CRM Data from Crystal Reports
Use CData Connect AI to connect to and report on live Act CRM data from Crystal Reports.
-
Connect to Landbot Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Landbot to connect to Landbot data and execute queries in PowerBuilder.
-
Working with Oracle SCM Data in LINQPad
Execute LINQ queries to Oracle SCM data in LINQPad.
-
Visualize Brex Data in Sisense
Create an ElastiCube in Sisense app with access to Brex data.
-
How to Easily Query Pinecone Data in OpenOffice Base
Connect to Pinecone data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Create Data Visualizations Based On Anaplan Data in Mode
Use CData Connect AI to connect to Anaplan Data from Mode and build visualizations using live Anaplan data.
-
How to Visualize Mixpanel Data in Python with pandas
Use pandas and other modules to analyze and visualize live Mixpanel data in Python.
-
How to Query FHIR Data in MySQL Workbench
Execute MySQL queries against live FHIR data from MySQL Workbench.
-
Build Apps with Live Hive Data Using the Low-Code Development Platform of Mendix
Connect Hive data with Mendix to build apps using the CData JDBC Driver for Hive.
-
DataBind Charts to ElevenLabs Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to ElevenLabs data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Connect to Okta Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Okta and the SQL Gateway to access Okta data from Google Apps Script.
-
Integrate OpenCode with Live SAP SuccessFactors LMS Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live SAP SuccessFactors LMS data from within your AI coding agent.
-
Integrating Boomi Agentstudio with Oracle Service Cloud Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Oracle Service Cloud data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to Avaza from a Connection Pool in WebLogic
Use the CData JDBC Driver for Avaza to connect to Avaza data from Web applications running on WebLogic.
-
Create SSAS Tabular Models from Adobe Target Data
How to build a SQL Server Analysis Service Tabular Model from Adobe Target data using CData drivers.
-
Work with Live Bitly Data in Power Query
Use CData Connect AI to connect to Bitly data and work with live Bitly data in Microsoft Power Query.
-
Integrating OpenCode with iContact 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.
-
How to Query ZohoPeople Data in MySQL Workbench
Execute MySQL queries against live ZohoPeople data from MySQL Workbench.
-
Build Visualizations of Splunk Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Splunk data in Birst.
-
Build a Simple VCL Application for Jira Data
How to build a simple VCL Application to view Jira data in RAD Studio using the CData ODBC Driver for Jira.
-
Bidirectional Access to Smartsheet Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Smartsheet data in Filemaker Pro for Mac or Windows.
-
Automate JSON Services Replication to Azure Synapse
Use CData Sync to customize and automate JSON services replication to Azure Synapse.
-
Integrating xBase Data in Talend Cloud Data Management Platform
Connect xBase Data with Talend Cloud Data Management Platform using the CData JDBC Driver for xBase.
-
Connect to and Visualize Live Printful Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Printful data.
-
Access Live Google Ads Data in Excel 365 Online (Excel for the web)
Connect to Google Ads data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Build Outreach.io-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Outreach.io data.
-
How to update Salesforce Pardot from Excel
This article explains how to transfer data from Excel to Salesforce Pardot using the Excel Add-In for Salesforce Pardot.
-
Integrating Antigravity CLI with Landbot data via CData CLI
Connect Landbot data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrating JotForm Data in Talend Cloud Data Management Platform
Connect JotForm Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Visualize Live Acumatica Data in the Power BI Service
Use CData Connect AI to connect to live Acumatica data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to ZohoMarketingHub Data from AWS Glue
Use CData Connect AI to gain access to live ZohoMarketingHub data from your AWS Glue jobs.
-
Create Reports with CouchDB Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date CouchDB data.
-
How to publish and share Paddle Data dashboards with Tableau Server
The CData ODBC driver for Paddle enables you integrate Paddle data into Tableau dashboards.
-
Connect to Azure Data Lake Storage Data in DBArtisan
Use wizards in DBArtisan to configure Azure Data Lake Storage data as a data source.
-
Connect to and Query Short.io Data in QlikView over ODBC
Create data visualizations with Short.io data in QlikView.
-
Use JayDeBeApi to access OData Services in Python
Use standard Python scripting and the development environment of your choice to access live OData services.
-
Connect and Query Live Act CRM Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Act CRM data into Databricks and enable direct, live querying and analysis without replication.
-
Use the CData Software ODBC Driver for Coinbase in MicroStrategy Web
Connect to Coinbase data in MicroStrategy Web using the CData Software ODBC Driver for Coinbase.
-
How to connect to Supabase Data from Spring Boot
Connect to Supabase in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to OneNote Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for OneNote and the Script function in FileMaker Pro to connect to OneNote and work with OneNote data in your FileMaker application.
-
Model Moosend Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Moosend, enabling the direct import of real-time Moosend data.
-
Excel Spreadsheet Automation on JSON Services with the QUERY Formula
Pull data from JSON, automate spreadsheets, and more with the QUERY formula.
-
How to Access Live SAP Ariba Source Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SAP Ariba Source enables you to integrate SAP Ariba Source data into workflows built using Microsoft Power Automate Desktop.
-
Connect to SAP BusinessObjects BI Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SAP BusinessObjects BI data.
-
A Comparison of JDBC & ODBC Drivers for BigQuery
A performance comparison of the CData JDBC Driver for Google BigQuery 2016 and ODBC Driver for Google BigQuery 2016 and the Google JDBC Driver for Google BigQuery 1.0 and ODBC Driver for Google BigQuery 2.0
-
Connect to Certinia Data in HULFT Integrate
Connect to Certinia as a JDBC data source in HULFT Integrate
-
Use Agno to Talk to Your SAS Data Sets 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 SAS Data Sets data for you.
-
PostgreSQL Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to PostgreSQL data through CData Connect AI using different applications and tools.
-
Integrating OpenCode with Auth0 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 SparkPost-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live SparkPost data and build SparkPost-connected web apps with Axios.
-
Use Manus AI to Talk to Your Power BI XMLA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Power BI XMLA data.
-
Integrate Trae with Live SageHR Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live SageHR data from within the AI-powered IDE.
-
How to create an RPA flow for Front Data in UiPath Studio
Use the Front ODBC Driver to create workflows that access real-time Front data without any coding.
-
Create Adobe Target Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Adobe Target data access from reports, embedded analytics, and more.
-
Create Apps from Box Data in Qlik Sense Cloud
Use CData Connect AI to connect to Box Data and build apps from live Box data in Qlik Sense Cloud.
-
How to Work with XML Data in AWS Glue Jobs Using JDBC
Connect to XML from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous LDAP Objects Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable LDAP objects replication to OneLake in Microsoft Fabric.
-
Migrating data from Okta to Databricks using CData SSIS Components.
Easily push Okta data to Databricks using the CData SSIS Tasks for Okta and Databricks.
-
Use Microsoft Copilot Studio to talk to your Tavily 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 Tavily data for you.
-
How to use SQLAlchemy ORM to access Mocean Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Mocean data.
-
How to Work with Salesforce Pardot Data in ETL Validator JDBC
Connect to Salesforce Pardot from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Pipeline CRM Data in Aqua Data Studio
Access Pipeline CRM data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Easily Query Azure Analysis Services Data in OpenOffice Base
Connect to Azure Analysis Services data in OpenOffice Base using the CData ODBC Driver for Azure Analysis Services and generate reports with live data insights.
-
Build AI Agents with Exact Online 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 Exact Online data through CData Connect AI.
-
How to Connect DBeaver to Zoho CRM via a JDBC Driver
Manage Zoho CRM data with visual tools in DBeaver like the query browser.
-
Publish Crystal Reports on Scrapfly Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Scrapfly data.
-
Creating Bitly-Connected Applications in Unqork
You can use CData Connect AI to feed Bitly data to Unqork and build custom business apps.
-
Integrate with FreeAgent Data in JReport Designer
Create charts and reports based on FreeAgent data in JReport Designer.
-
Create Reports with Sendwithus Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Sendwithus data.
-
Build Pipelines with Live SAP Netweaver Gateway Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to SAP Netweaver Gateway from Google Cloud Data Fusion, enabling the integration of live SAP Netweaver Gateway data into the building and management of effective data pipelines.
-
Integrate LinkedIn with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate LinkedIn with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to LinkedIn data.
-
Integrate Cline with Live Asana Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Asana data from within your IDE.
-
Connect to MySQL Data in ACL Analytics
Connect to MySQL data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to MySQL data.
-
Replicate QuickBooks Data in Heroku for Use in Salesforce Connect
Replicate QuickBooks data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Process & Analyze Opsgenie Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Opsgenie Data.
-
Connect to Real-Time RabbitMQ Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use RabbitMQ data in Power Apps.
-
Use Dash to Build to Web Apps on QuickBooks Online Data
Create Python applications that use pandas and Dash to build QuickBooks Online-connected web apps.
-
Integrate Live Salesforce Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Salesforce data to Blue Prism using the CData ODBC Driver for Salesforce to create automated workflows for repetitive business tasks.
-
Use Microsoft Copilot Studio to talk to your xBase 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 xBase data for you.
-
Visualize Live Bannerbear Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Bannerbear data.
-
Visualize Customer.io 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 Customer.io data into TIBCO Spotfire.
-
How to Work with Close Data in ETL Validator JDBC
Connect to Close from ETL Validator jobs using the CData Software JDBC Driver.
-
Import Real-Time Neo4J Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Neo4J data in ColdFusion.
-
Replicate Google Cloud Storage Data in Heroku for Use in Salesforce Connect
Replicate Google Cloud Storage data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Live PolarTeamPro Data in MicroStrategy through CData Connect AI
Create a live connection to PolarTeamPro Data in CData Connect AI and connect to your PolarTeamPro data from MicroStrategy.