CData Software - Knowledge Base
Recent Articles
-
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 SAP HANA Data in JRuby
Create a simple JRuby app with access to live SAP HANA.
-
Configure the CData JDBC Driver for Gong in a Connection Pool in Tomcat
Connect to Gong from a connection pool in Tomcat.
-
Import Real-Time Eventbrite Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Eventbrite in ColdFusion.
-
Connect to Act CRM Data from Crystal Reports
Use CData Connect AI to connect to and report on live Act CRM 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 and execute queries in PowerBuilder.
-
Working with Oracle SCM Data in LINQPad
Execute LINQ queries to Oracle SCM in LINQPad.
-
Visualize Brex Data in Sisense
Create an ElastiCube in Sisense app with access to Brex.
-
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.
-
How to Visualize Mixpanel Data in Python with pandas
Use pandas and other modules to analyze and visualize live Mixpanel in Python.
-
How to Query FHIR Data in MySQL Workbench
Execute MySQL queries against live FHIR from MySQL Workbench.
-
Automate Google Contacts Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Google Contacts and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Build Apps with Live Hive Data Using the Low-Code Development Platform of Mendix
Connect Apache Hive 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 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 from Google Apps Script.
-
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, 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 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 using CData drivers.
-
Integrating OpenCode Terminal 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 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 in Birst.
-
Build a Simple VCL Application for Jira Data
How to build a simple VCL Application to view Atlassian Jira in RAD Studio using the CData ODBC Driver for Jira.
-
Create Informatica Mappings From/To a JDBC Data Source for Delighted
Create Delighted data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Bidirectional Access to Smartsheet Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Smartsheet in Filemaker Pro for Mac or Windows.
-
Automate JSON Services Replication to Azure Synapse
Use CData Sync to customize and automate JSON 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.
-
Access Live Google Ads Data in Excel 365 Online (Excel for the web)
Connect to Google Ads 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.
-
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 via CData CLI
Connect Landbot 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 ERP and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create Reports with CouchDB Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Apache CouchDB.
-
How to publish and share Paddle Data dashboards with Tableau Server
The CData ODBC driver for Paddle enables you integrate Paddle into Tableau dashboards.
-
Connect to Azure Data Lake Storage Data in DBArtisan
Use wizards in DBArtisan to configure Azure Data Lake Storage as a data source.
-
Connect to and Query Short.io Data in QlikView over ODBC
Create data visualizations with Short.io in QlikView.
-
Build Google Analytics-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Google Analytics to explore live Google Analytics Data in Cursor to assist with building Google Analytics-powered applications.
-
Use JayDeBeApi to access OData Services in Python
Use standard Python scripting and the development environment of your choice to access live OData.
-
Connect and Query Live Act CRM Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Act CRM into Databricks
-
Use the CData Software ODBC Driver for Coinbase in MicroStrategy Web
Connect to Coinbase 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 Microsoft OneNote in your FileMaker application.
-
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 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.
-
Access Live Adobe Commerce Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Adobe Commerce data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
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 for you.
-
PostgreSQL Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to PostgreSQL through CData Connect AI using different applications and tools.
-
Integrating OpenCode Terminal 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.
-
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.
-
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 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 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 replication to OneLake in Microsoft Fabric.
-
Migrating data from Okta to Databricks using CData SSIS Components.
Easily push Okta to Databricks using the CData SSIS Tasks for Okta and Databricks.
-
How to use SQLAlchemy ORM to access Mocean Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Mocean.
-
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 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 through CData Connect AI.
-
How to Connect DBeaver to Zoho CRM via a JDBC Driver
Manage Zoho CRM 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.
-
Integrate with FreeAgent Data in JReport Designer
Create charts and reports based on FreeAgent 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.
-
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 into the building and management of effective data pipelines.
-
How to Design Reckon Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Reckon from mobile and tablet Power Apps.
-
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.
-
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 from within your IDE.
-
Connect to MySQL Data in ACL Analytics
Connect to MySQL via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to MySQL.
-
Replicate QuickBooks Data in Heroku for Use in Salesforce Connect
Replicate QuickBooks Desktop 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 in Power Apps.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Atlassian Jira to Power BI dashboards. Simply drag and drop Atlassian Jira into data visuals on the Power BI canvas.
-
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 & Force.com to Blue Prism using the CData ODBC Driver for Salesforce to create automated workflows for repetitive business tasks.
-
Visualize Live Bannerbear Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Bannerbear.
-
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 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.
-
How to Import Data from Sage Intacct into Google Sheets
Import Sage Intacct into a Google spreadsheet that is automatically refreshed.
-
Edit and Search Dynamics 365 External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Microsoft Dynamics 365 to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Dynamics 365 objects that you can access from apps and the dashboard.
-
Import Real-Time Neo4J Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Neo4J in ColdFusion.
-
How to Query Live Certinia Data in Claude Desktop
Connect to and query live Certinia Data in Claude Desktop using CData MCP Server.
-
Replicate Google Cloud Storage Data in Heroku for Use in Salesforce Connect
Replicate Google Cloud Storage to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Connect to Live ShipStation Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your ShipStation for you.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Avalara AvaTax
Provide connectivity to Avalara AvaTax through an SAP BusinessObjects universe.
-
Build PostgreSQL-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live PostgreSQL and build PostgreSQL-connected web apps with Axios.
-
Connect to Dropbox Data in Google Apps Script via Connect AI
Use CData Connect AI to access Dropbox in Google Apps Script.
-
Publish Crystal Reports on Couchbase Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Couchbase.
-
Build AI/ML Models with Live Excel Online Data using Dataiku
Connect Excel Online Data with Dataiku using the CData JDBC Driver for Excel Online.
-
Build Optimizely-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Optimizely.
-
How to Connect to Live Salesforce Marketing Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Salesforce Marketing Cloud through natural language.
-
Automated Continuous Microsoft Dataverse Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Microsoft Dataverse replication to delimited files (CSV/TSV).
-
How to load Datadog data into Elasticsearch via Logstash
Introducing a simple method to load Datadog data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Query FreshBooks Data through ODBC in Node.js
Use node-odbc to execute SQL queries against FreshBooks from Node.js.
-
How to Connect to Reckon Accounts Hosted Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Reckon Accounts Hosted. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous QuickBooks Time Replication to Amazon S3
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to Amazon S3.