CData Software - Knowledge Base
Recent Articles
-
How to Work with Zoho Books Data in ETL Validator JDBC
Connect to Zoho Books from ETL Validator jobs using the CData Software JDBC Driver.
-
Build Dashboards with Couchbase Data in Dundas BI
Create dynamic dashboards and perform analytics based on Couchbase data in Dundas BI.
-
Integrate Cline with Live Sybase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Sybase data from within your IDE.
-
Access Live Avro Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Avro data from your Google Sheets.
-
Use Biml to Build SSIS Tasks to Replicate SendPulse Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SendPulse data to SQL Server.
-
Create Power BI Reports on Real-Time SharePoint Data
Use the CData ODBC Driver for SharePoint to visualize SharePoint data in Power BI Desktop.
-
Connect to Zuora Data from AWS Glue
Use CData Connect AI to gain access to live Zuora data from your AWS Glue jobs.
-
How to Work with Oracle Eloqua Data in ETL Validator JDBC
Connect to Oracle Eloqua from ETL Validator jobs using the CData Software JDBC Driver.
-
Access Live CloudConvert Data in AWS Lambda
Connect to live CloudConvert data in AWS Lambda using the CData JDBC Driver.
-
Natively Connect to MarkLogic Data in PHP
The CData ODBC driver for MarkLogic enables you to create PHP applications with connectivity to MarkLogic data. Leverage the native support for ODBC in PHP.
-
Connect to Gmail Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Gmail data.
-
A PostgreSQL Interface for Aha! Data (MySQL Remoting via JDBC)
Use the Remoting features of the Aha! JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Dashboards with Jira Data in Dundas BI
Create dynamic dashboards and perform analytics based on Jira data in Dundas BI.
-
Connect to Opsgenie Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Opsgenie and work with Opsgenie data in your FileMaker application.
-
Query Live Google Spanner 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 Google Spanner data directly from the development environment.
-
Connect to SAP Concur Data in RapidMiner
Integrate SAP Concur data with standard components and data source configuration wizards in RapidMiner Studio.
-
Deploy the ADO.NET Provider for Rootly on an SSRS Report Server
Connect to Rootly 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.
-
Use JayDeBeApi to access Telegram Data in Python
Use standard Python scripting and the development environment of your choice to access live Telegram data.
-
Consume MYOB AccountRight OData Feeds in PowerBuilder
This article demonstrates how to consume MYOB AccountRight data as OData feeds from PowerBuilder using the API Server.
-
How to load Presto data into Elasticsearch via Logstash
Introducing a simple method to load Presto data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Zoho Creator in SpagoBI
Create reports featuring live Zoho Creator data in SpagoBI Studio. Host Zoho Creator reports on SpagoBI Server.
-
Link Samanage with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Samanage data 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 data 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's Vertex AI Agent with Live SAS Data Sets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live SAS Data Sets data 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 data.
-
How to Connect to Live MariaDB Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live MariaDB data 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 data.
-
Automate Bannerbear Data Replication to Azure Synapse
Use CData Sync to customize and automate Bannerbear data 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 data from Node.js.
-
Design BIRT Reports on Okta Data
Provide current Okta data 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 data directly from the development environment.
-
Create PolarTeamPro-Connected Nintex Workflows
Use CData Connect AI to connect to PolarTeamPro Data from Nintex Workflow Cloud and build custom workflows using live PolarTeamPro data.
-
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 data 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 data.
-
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 Cassandra data and build visualizations in Tableau.
-
Build a Simple VCL Application for ZohoExpense Data
How to build a simple VCL Application to view ZohoExpense data 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 data to disparate databases with a single configuration.
-
Integrate Live Gong Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Gong data 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 data in MicroStrategy Desktop using the CData Software JDBC Driver for Testmonitor.
-
Connect to ElevenLabs in SpagoBI
Create reports featuring live ElevenLabs data 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 data from PowerShell? This article demonstrates how to utilize the Jodoo Cmdlets for tasks like connecting to Jodoo data, automating operations, downloading data, and more.
-
Create Data Visualizations in Cognos BI with Amazon Athena Data
Access Amazon Athena data 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 data 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 data.
-
Extract, Transform, and Load Asana Data in Informatica PowerCenter
Create a simple Workflow for Asana data in Informatica PowerCenter.
-
Visualize Amazon Marketplace Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Amazon Marketplace data.
-
Integrate ChargeOver Data in the Pentaho Report Designer
Publish reports based on ChargeOver data 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 data 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 data to Apache Solr Enterprise Search platform.
-
How to integrate Metabase with BambooHR Data
Use CData Connect AI to connect to live BambooHR data and create an interactive dashboard in Metabase from BambooHR data.
-
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 data 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 data 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 data 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 data 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 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 data 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 Cassandra data for you.
-
Use the CData Software JDBC Driver for REST in MicroStrategy
Connect to REST data 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 data in MySQL .
-
How to Query TaxJar Data in MySQL Workbench
Execute MySQL queries against live TaxJar data from MySQL Workbench.
-
Create Data Visualizations Based On ZohoExpense Data in Mode
Use CData Connect AI to connect to ZohoExpense Data from Mode and build visualizations using live ZohoExpense data.
-
Integrating Codex with Facebook 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.
-
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 data 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 HDFS data into Java servlets: Use the Management Console in JBoss to install the HDFS JDBC Driver.
-
Integrate Cursor with Live ZohoPeople Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live ZohoPeople data from within the editor.
-
Integrate OpenCode with Live Google Forms Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Google Forms data from within your AI coding agent.
-
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 data into the statistical analysis tools available in SAS JMP. This article shows how to use Salesforce Marketing data 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 data into the Databricks platform and create visualization dashboards with real-time Google Campaign Manager 360 data.
-
Create Informatica Mappings From/To an ODBC Data Source for SendInBlue
Create an ODBC connection to SendInBlue in Informatica and browse and transfer SendInBlue data.
-
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 data in real time.
-
Integrate Hubstaff with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Hubstaff with External Services.
-
Seamlessly Bring Azure Data Catalog Data into Retool Using CData Connect AI
Integrate Azure Data Catalog data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
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 and configure a connection to live Redis data.
-
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 data.
-
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 data for you.
-
Automated Continuous Templated Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Templated data replication to OneLake in Microsoft Fabric.
-
Integrate Live Salesforce Pardot Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Salesforce Pardot data and integrate live Salesforce Pardot data into apps built in Microsoft Power Apps.