CData Software - Knowledge Base
Recent Articles
-
Bidirectional Access to Samanage Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Samanage in Filemaker Pro for Mac or Windows.
-
Connect to FTP Data from a Connection Pool in Jetty
The FTP JDBC Driver supports connection pooling: This article shows how to connect faster to FTP Servers from Web apps in Jetty.
-
A PostgreSQL Interface for Oracle SCM Data (MySQL Remoting via JDBC)
Use the Remoting features of the Oracle SCM JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live SAS Data Sets within intelligent workflows.
-
How to Work with Instagram Data in ETL Validator JDBC
Connect to Instagram from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrating Dataiku with MailChimp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live MailChimp.
-
How to Connect to Live MariaDB Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live MariaDB without replication.
-
Access Rootly Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Rootly.
-
Automate Bannerbear Data Replication to Azure Synapse
Use CData Sync to customize and automate Bannerbear replication to Azure Synapse.
-
Build AI/ML Models with Live Discord Data using Dataiku
Connect Discord Data with Dataiku using the CData API Driver for JDBC.
-
Query ServiceNow Data as a MySQL Database in Node.js
Execute MySQL queries against ServiceNow from Node.js.
-
Design BIRT Reports on Okta Data
Provide current Okta to your embedded analytics.
-
Build a PostgreSQL Interface for Strava Data using the CData JDBC Driver
Use the Remoting features of the Strava JDBC Driver to create a PostgreSQL entry-point for data access.
-
Query Live MYOB AccountRight Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live MYOB AccountRight directly from the development environment.
-
How to Connect to Live Gong 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 Gong for you.
-
How to use SQLAlchemy ORM to access Bitly Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Bitly.
-
How to Access Live Avro Data in Visual Studio Code via Cline
Run CData MCP Server for Avro on Windows Subsytem for Linux (WSL) and connect to live Apache Avro from the Cline extension in Visual Studio Code.
-
How to Connect to & Open Wave Financial Data in Microsoft Excel
This article uses the CData ODBC driver for Wave Financial to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Add Productboard Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Productboard with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build Cassandra Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Apache Cassandra and build visualizations in Tableau.
-
Build a Simple VCL Application for ZohoExpense Data
How to build a simple VCL Application to view ZohoExpense in RAD Studio using the CData ODBC Driver for ZohoExpense.
-
How to Easily Query OnePageCrm Data in OpenOffice Base
Connect to OnePageCrm data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Replicate WordPress Data to Multiple Databases via the CData Sync CLI
Replicate WordPress to disparate databases with a single configuration.
-
Integrate Live Gong Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Gong to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Use the CData Software JDBC Driver for Testmonitor in MicroStrategy Desktop
Connect to Testmonitor in MicroStrategy Desktop using the CData Software JDBC Driver for Testmonitor.
-
Connect to ElevenLabs in SpagoBI
Create reports featuring live ElevenLabs in SpagoBI Studio. Host ElevenLabs reports on SpagoBI Server.
-
Automate Jodoo Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Jodoo from PowerShell? This article demonstrates how to utilize the Jodoo Cmdlets for tasks like connecting to Jodoo, automating operations, downloading data, and more.
-
Create Data Visualizations in Cognos BI with Amazon Athena Data
Access Amazon Athena as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build Dashboards with Trello Data in DBxtra
Create dynamic dashboards and perform analytics based on Trello in DBxtra.
-
Publish Crystal Reports on SAP Business One Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SAP Business One.
-
Extract, Transform, and Load Asana Data in Informatica PowerCenter
Create a simple Workflow for Asana in Informatica PowerCenter.
-
Visualize Amazon Marketplace Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Amazon Marketplace.
-
Integrate ChargeOver Data in the Pentaho Report Designer
Publish reports based on ChargeOver in the Pentaho BI tool.
-
How to connect to GitLab Data from Spring Boot
Connect to GitLab in a Spring Boot Application using the CData API Driver for JDBC
-
Zoho Books Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Zoho Books through CData Connect AI using different applications and tools.
-
How to import EmailOctopus Data into Apache Solr
Use the CData Software JDBC Driver for EmailOctopus in Data Import Handler and create an automated import of EmailOctopus to Apache Solr Enterprise Search platform.
-
How to integrate Metabase with BambooHR Data
Use CData Connect AI to connect to live BambooHR and create an interactive dashboard in Metabase from BambooHR.
-
Manage SAP Business Warehouse Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SAP Business Warehouse.
-
Connect to Real-Time QuickBooks Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for QuickBooks and Dataflow to import and use QuickBooks Desktop in Power Apps.
-
Box Reporting in OBIEE with the Box JDBC Driver
Deploy the Box JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build Spark-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Spark Data and create custom apps in Mendix.
-
Connecting GenSpark with Oracle Service Cloud Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Oracle Service Cloud without any replication or custom integration required.
-
How to Connect the Power BI Service to Epicor Kinetic: Complete Guide
Connect to the CData Software Power BI Connector for Epicor Kinetic from PowerBI.com to provide real-time Epicor Kinetic across the organization.
-
Connect to Outreach.io Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Outreach.io to connect to Outreach.io and execute queries in PowerBuilder.
-
Create Azure DevOps Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Azure DevOps from PowerBI.com to create Power BI Dataflows with real-time data.
-
Getting Started with the CData ODBC Driver for Aircall
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Aircall.
-
Integrating Kiro CLI with EmailOctopus 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.
-
Integrating Claude Code CLI with Customer.io 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.
-
Integrate Live ServiceDesk Plus Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live ServiceDesk Plus to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
How to Connect to Live Cassandra Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Apache Cassandra for you.
-
Use the CData Software JDBC Driver for REST in MicroStrategy
Connect to REST in MicroStrategy Developer using the CData Software JDBC Driver for REST.
-
How to create Pipeline CRM federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Pipeline CRM in MySQL .
-
How to Query TaxJar Data in MySQL Workbench
Execute MySQL queries against live TaxJar from MySQL Workbench.
-
Integrating Codex CLI with Facebook 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.
-
Analyze Zoho Books Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Zoho Books and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build AI/ML Models with Live Timely Data using Dataiku
Connect Timely Data with Dataiku using the CData API Driver for JDBC.
-
Connect to HDFS Data from a Connection Pool in JBoss
Integrate Apache HDFS into Java servlets: Use the Management Console in JBoss to install the HDFS JDBC Driver.
-
Automated Continuous Ontraport Replication to Vertica
Use CData Sync for automated, continuous, customizable Ontraport replication to Vertica.
-
Access Live Salesforce Marketing Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Salesforce Marketing Cloud into the statistical analysis tools available in SAS JMP. This article shows how to use Salesforce Marketing Cloud in the Graph Builder and Query Builder.
-
Connect and Visualize Live Google Campaign Manager 360 Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Google Campaign Manager 360 into the Databricks platform and create visualization dashboards with real-time Google Campaign Manager 360.
-
Create Informatica Mappings From/To an ODBC Data Source for SendInBlue
Create an ODBC connection to SendInBlue in Informatica and browse and transfer SendInBlue.
-
Automated Continuous Facebook Ads Replication to MongoDB
Use CData Sync for automated, continuous, customizable Facebook Ads replication to MongoDB.
-
Integrating LlamaIndex with SAP SuccessFactors Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on SAP SuccessFactors in real time.
-
Integrate Hubstaff with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Hubstaff with External Services.
-
Create ADP Dataflows on PowerBI.com
Connect to the CData Power BI Connector for ADP from PowerBI.com to create Power BI Dataflows with real-time data.
-
Getting Started with the CData Python Connector for Redis
Learn to install and license the CData Python Connector
-
Omnisend Reporting in OBIEE with the Omnisend JDBC Driver
Deploy the Omnisend JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to connect to Perplexity Data from Spring Boot
Connect to Perplexity in a Spring Boot Application using the CData API Driver for JDBC
-
Using the CData Software ODBC Driver for SAP Netweaver Gateway in PyCharm
Connect to SAP Netweaver Gateway as an ODBC data source in PyCharm using the CData Software ODBC Driver for SAP Netweaver Gateway.
-
Build Semantic Layer Views for Zoho Creator Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Zoho Creator.
-
How to Work with Landbot Data in AWS Glue Jobs Using JDBC
Connect to Landbot from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Manage Redshift Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Redshift.
-
Use Azure AI Foundry to Talk to Your Zoho Books 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 Zoho Books for you.
-
Integrate Live Salesforce Pardot Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Salesforce Pardot and integrate live Salesforce Pardot into apps built in Microsoft Power Apps.
-
How to Access Live Scrapfly Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Scrapfly enables you to integrate Scrapfly into workflows built using Microsoft Power Automate Desktop.
-
DataBind Instagram Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Instagram with the DevExpress Windows Forms and Web controls to provide Instagram to a chart.
-
Automate SAP Business One Data Replication to Azure Data Lake
Use CData Sync to customize and automate SAP Business One replication to Azure Data Lake.
-
Integrate Live SAP BusinessObjects BI Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Connect to RabbitMQ Data in Ruby
Connect to RabbitMQ in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Query Oracle Eloqua Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Oracle Eloqua entities in PHP by modeling them as objects.
-
Integrating LangGraph with Google Search Results via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Google Search within automated workflows.
-
Publish Flowlu-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Flowlu.
-
Automated Continuous Optimizely Replication to Snowflake
Use CData Sync for automated, continuous, customizable Optimizely replication to Snowflake.
-
Getting Started with the CData ADO.NET Provider for Dropbox
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Dropbox.
-
Build Data Flows from Missive to SQL Server using SSIS
Easily back up Missive to SQL Server using the SSIS components for Missive.
-
How to create AgileCRM federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for AgileCRM in MySQL .
-
Access Live eBay Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live eBay from your Excel spreadsheets.
-
How to Build an ETL App for FormSite Data in Python with CData
Create ETL applications and real-time data pipelines for FormSite in Python with petl.
-
Use JayDeBeApi to access Salesforce Marketing Data in Python
Use standard Python scripting and the development environment of your choice to access live Salesforce Marketing Cloud.
-
Visualize Deel Data in Tableau
The CData ODBC driver for Deel enables you integrate Deel into Tableau dashboards.
-
Automate YouTube Analytics Data Replication to SAP HANA
Use CData Sync to customize and automate YouTube Analytics replication to SAP HANA.
-
Add Raisers Edge NXT Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Raisers Edge NXT with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build Data Flows from HDFS to SQL Server using SSIS
Easily back up Apache HDFS to SQL Server using the SSIS components for HDFS.
-
Integrating Antigravity CLI with Oracle HCM Cloud via CData CLI
Connect Oracle HCM Cloud to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
DataBind Quickbase Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Quickbase with the DevExpress Windows Forms and Web controls to provide Quickbase to a chart.
-
Automated Continuous SendInBlue Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable SendInBlue replication to Google Cloud SQL.
-
Create Datasets from Toggl in Domo Workbench and Build Visualizations of Toggl Data in Domo
Use the CData Software ODBC Driver for Toggl to create datasets from Toggl in Domo Workbench and then build visualizations in the Domo service.
-
Query ZendeskSell Data through ODBC in Node.js
Use node-odbc to execute SQL queries against ZendeskSell from Node.js.
-
Connect to Pingdom Data from a Connection Pool in JBoss
Integrate Pingdom into Java servlets: Use the Management Console in JBoss to install the Pingdom JDBC Driver.
-
Connect and Visualize Live Amazon Marketplace Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Amazon Marketplace into the Databricks platform and create visualization dashboards with real-time Amazon Marketplace.