CData Software - Knowledge Base
Recent Articles
-
Use JayDeBeApi to access Discord Data in Python
Use standard Python scripting and the development environment of your choice to access live Discord data.
-
Natively Connect to Dropbox Data in PHP
The CData ODBC driver for Dropbox enables you to create PHP applications with connectivity to Dropbox data. Leverage the native support for ODBC in PHP.
-
Connect to Outreach.io Data from a Connection Pool in JBoss
Integrate Outreach.io data into Java servlets: Use the Management Console in JBoss to install the Outreach.io JDBC Driver.
-
Build an OLAP Cube in SSAS from Act CRM Data
Establish a connection to Act CRM data data from SQL Server Analysis Services, and use the Act CRM Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use Microsoft Copilot Studio to talk to your Coda 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 Coda data for you.
-
Easily Integrate Adobe Experience Manager Data in Lazarus Pascal IDE
Learn how to easily integrate live Adobe Experience Manager data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to xBase Data in Ruby
Connect to xBase data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Connect Neo4J Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Neo4J data in real time using natural language.
-
Design BIRT Reports on NetSuite Data
Provide current NetSuite data to your embedded analytics.
-
Use the CData Software ODBC Driver for SAP SuccessFactors LMS in MicroStrategy Desktop
Connect to SAP SuccessFactors LMS data in MicroStrategy Desktop using the CData Software ODBC Driver for SAP SuccessFactors LMS.
-
Connect to Salesloft Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Salesloft as an External Source in Dremio.
-
Visualize Customer.io Data in Sisense
Create an ElastiCube in Sisense app with access to Customer.io data.
-
Getting Started with the CData Excel Add-In for Jira
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Jira.
-
How to Access Live Dynamics CRM Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Dynamics CRM enables you to integrate Dynamics CRM data into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous GitLab Replication to SingleStore
Use CData Sync for automated, continuous, customizable GitLab replication to SingleStore.
-
How to Connect to Live Sendwithus 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 Sendwithus data for you.
-
Automate Guru Data Replication to Azure Synapse
Use CData Sync to customize and automate Guru data replication to Azure Synapse.
-
Integrating Codex with CSV 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 Connect DBeaver to XML via a JDBC Driver
Manage XML data with visual tools in DBeaver like the query browser.
-
Automated Continuous ServiceDesk Plus Replication to Amazon S3
Use CData Sync for automated, continuous, customizable ServiceDesk Plus replication to Amazon S3.
-
Connect to Sage Cloud Accounting from a Connection Pool in WebLogic
Use the CData JDBC Driver for Sage Cloud Accounting to connect to Sage Cloud Accounting data from Web applications running on WebLogic.
-
Use JayDeBeApi to access LinkedIn Data in Python
Use standard Python scripting and the development environment of your choice to access live LinkedIn data.
-
Connect to Vault CRM Data from PowerBuilder via JDBC
This article demonstrates how to access Vault CRM data from PowerBuilder using the Vault CRM JDBC Driver.
-
Create Power BI Reports on Real-Time Perigon Data
Use the CData ODBC Driver for Perigon to visualize Perigon data in Power BI Desktop.
-
Build a PostgreSQL Interface for Demio Data using the CData JDBC Driver
Use the Remoting features of the Demio JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Helpscout-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Helpscout data and build web apps with connectivity to live Helpscout data.
-
Neo4J Reporting in OBIEE with the Neo4J JDBC Driver
Deploy the Neo4J JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build Slack-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Slack data without replication.
-
AfterShip Reporting in OBIEE with the AfterShip JDBC Driver
Deploy the AfterShip JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Replicate Multiple Oracle Accounts via the CData Sync CLI
Replicate multiple Oracle accounts to one or many databases.
-
Connect to Presto Data in ACL Analytics
Connect to Presto data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Presto data.
-
DataBind Controls to Factorial Data in C++Builder
DataBind to Factorial data in C++Builder with standard components and controls.
-
Integrate Live Oracle SCM Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Oracle SCM data to Blue Prism using the CData ODBC Driver for Oracle SCM to create automated workflows for repetitive business tasks.
-
Connecting Mastra with SAP Business Warehouse Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time SAP Business Warehouse data, no replication required.
-
Query Teradata Data as a SQL Server Database in Node.js
Execute SQL Server queries against Teradata data from Node.js.
-
Connect to Printful Data from a Connection Pool in Jetty
The Printful JDBC Driver supports connection pooling: This article shows how to connect faster to Printful data from Web apps in Jetty.
-
A PostgreSQL Interface for Freshservice Data (MySQL Remoting via JDBC)
Use the Remoting features of the Freshservice JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Apps with Live xBase data in Adalo using CData Connect AI
Use CData Connect AI to integrate live xBase data into the Adalo platform and build custom mobile and web applications with real-time xBase data.
-
How to Connect to Live Lakebase Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Lakebase data for you.
-
Integrate Devin with Live SAP SuccessFactors LMS 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 SAP SuccessFactors LMS data.
-
Connect to Marketo Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Marketo data from Filemaker Pro on Mac.
-
How to Create Power BI Visual Reports with Real-Time Email Data
Use CData Power BI Connectors to visualize Email data in Power BI.
-
How to Connect Flowise AI Agents to Live Slack Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Slack data without replication.
-
Publish Reports with Jira Assets Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Jira Assets data.
-
Automated Continuous Cloudant Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Cloudant replication to AlloyDB.
-
Build Automated Figshare-Connected Workflows in Zapier
Use CData Connect AI to connect to live Figshare data and build automated workflows in Zapier.
-
Create Datasets from Chargebee in Domo Workbench and Build Visualizations of Chargebee Data in Domo
Use the CData Software ODBC Driver for Chargebee to create datasets from Chargebee data in Domo Workbench and then build visualizations in the Domo service.
-
Integrate Google Search Results in the Pentaho Report Designer
Publish reports based on Google Search results in the Pentaho BI tool.
-
Use the CData Software JDBC Driver for Workday in MicroStrategy Desktop
Connect to Workday data in MicroStrategy Desktop using the CData Software JDBC Driver for Workday.
-
Migrating data from Paddle to Google BigQuery using CData SSIS Components.
Easily push Paddle data to Google BigQuery using the CData SSIS Tasks for Paddle and Google BigQuery.
-
Connect to and Query SharePoint Data in QlikView over ODBC
Create data visualizations with SharePoint data in QlikView.
-
Build Snowflake Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Snowflake data and build visualizations in Tableau.
-
Automated Continuous MongoDB Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable MongoDB replication to Azure SQL Database.
-
Replicate Cosmos DB Data in Heroku for Use in Salesforce Connect
Replicate Cosmos DB data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create Data Visualizations Based On Exact Online Data in Mode
Use CData Connect AI to connect to Exact Online Data from Mode and build visualizations using live Exact Online data.
-
Build MariaDB-Connected Apps in Choreo
Use CData Connect AI to connect to MariaDB Data from Choreo and build custom apps using live MariaDB data.
-
How to load GetResponse data into Elasticsearch via Logstash
Introducing a simple method to load GetResponse data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrating Codex with Google Tasks 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.
-
ETL Tally in Oracle Data Integrator
This article shows how to transfer Tally data into a data warehouse using Oracle Data Integrator.
-
Automated Continuous Customer.io Replication to SQL Server
Use CData Sync for automated, continuous, customizable Customer.io replication to SQL Server.
-
Object-Relational Mapping (ORM) with Vercel Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Vercel data into a Java-based ORM framework, Hibernate.
-
Automated Continuous PDFMonkey Replication to AlloyDB
Use CData Sync for automated, continuous, customizable PDFMonkey replication to AlloyDB.
-
Replicate Nuclia Data to Multiple Databases via the CData Sync CLI
Replicate Nuclia data to disparate databases with a single configuration.
-
Integrate Live QuickBooks Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to QuickBooks data and integrate live QuickBooks data into apps built in Microsoft Power Apps.
-
Access Live ZohoInvoice Data in AWS Lambda
Connect to live ZohoInvoice data in AWS Lambda using the CData JDBC Driver.
-
Connecting GenSpark with Reckon Accounts Hosted Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Reckon Accounts Hosted data without any replication or custom integration required.
-
How to connect Amazon QuickSight to IBM Cloud Object Storage Data
Create a connection to IBM Cloud Object Storage data in CData Connect AI and insert IBM Cloud Object Storage data into Amazon QuickSight SPICE to build interactive dashboards.
-
Build AI/ML Models with Live Simplesat Data using Dataiku
Connect Simplesat Data with Dataiku using the CData API Driver for JDBC.
-
How to load Azure Data Lake Storage data into Elasticsearch via Logstash
Introducing a simple method to load Azure Data Lake Storage data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
ETL ConvertAPI in Oracle Data Integrator
This article shows how to transfer ConvertAPI data into a data warehouse using Oracle Data Integrator.
-
Configure the CData JDBC Driver for Salesforce Pardot in a Connection Pool in Tomcat
Connect to Salesforce Pardot data from a connection pool in Tomcat.
-
How to Connect DBeaver to Microsoft Exchange via a JDBC Driver
Manage Microsoft Exchange data with visual tools in DBeaver like the query browser.
-
Integrate LibreChat with Live Phoenix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Phoenix data from within the chat interface.
-
How to Visualize Notion 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 Notion data in Python.
-
Integrating OpenCode with Missive 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.
-
LINQ to Mouseflow Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Mouseflow Data Provider.
-
Getting Started with the CData ADO.NET Provider for HelloSign
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
How to Build an ETL App for CockroachDB Data in Python with CData Connect AI
Build ETL pipelines that read and write live CockroachDB data in Python with petl and the CData Connect AI Python SDK.
-
Connect Kafka to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Kafka with IBM WebSphere for seamless data integration and connectivity.
-
Integrate Real-Time Access to SQL Analysis Services in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SQL Analysis Services data in real time.
-
Connect to BenchmarkEmail Data from Crystal Reports
Use CData Connect AI to connect to and report on live BenchmarkEmail data from Crystal Reports.
-
Connect to Scrapfly Data in CloverDX (formerly CloverETL)
Transfer Scrapfly data using the visual workflow in the CloverDX data integration tool.
-
Import Dynamics 365 Business Central Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Dynamics 365 Business Central Data and provide access to live Dynamics 365 Business Central data for custom reports in the Power BI Service.
-
Create Zoho Projects-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Zoho Projects Data from OutSystems and build custom enterprise apps using live Zoho Projects data.
-
Automated Continuous Power BI XMLA Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Power BI XMLA replication to Google Cloud SQL.
-
How to Connect to & Open Pushbullet Data in Microsoft Excel
This article uses the CData ODBC driver for Pushbullet to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build an OLAP Cube in SSAS from Insightly Data
Establish a connection to Insightly data data from SQL Server Analysis Services, and use the Insightly Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Workable Replication to SQL Server
Use CData Sync for automated, continuous, customizable Workable replication to SQL Server.
-
Build Charts with Jumpseller Data in Clear Analytics
Create dynamic charts and perform analytics based on Jumpseller data in Clear Analytics.
-
Trigger Highrise IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Highrise with standard wizards in Logic Apps.
-
ETL BigCommerce in Oracle Data Integrator
This article shows how to transfer BigCommerce data into a data warehouse using Oracle Data Integrator.
-
Create LaunchDarkly Dataflows on PowerBI.com
Connect to the CData Power BI Connector for LaunchDarkly from PowerBI.com to create Power BI Dataflows with real-time data.
-
Trigger Basecamp IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Basecamp with standard wizards in Logic Apps.
-
How to Work with SingleStore Data in ETL Validator JDBC
Connect to SingleStore from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Unbounce Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Unbounce replication to Azure SQL Database.
-
Integrate LibreChat with Live Lakebase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Lakebase data from within the chat interface.
-
Automate Missive Data Replication to Azure Data Lake
Use CData Sync to customize and automate Missive data replication to Azure Data Lake.
-
Integrate Live Monday.com Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Monday.com data from within the IDE.
-
Query CapsuleCRM Data in ColdFusion
Write standard ColdFusion data access code to connect to CapsuleCRM data.
-
Connect to Rebilly Data from PowerBuilder via ADO.NET
This article demonstrates how to access Rebilly data from Appeon PowerBuilder using the CData API Driver for ADO.NET.