CData Software - Knowledge Base
Recent Articles
-
Connect to Pinecone Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Pinecone to connect to Pinecone data and execute queries in PowerBuilder.
-
How to work with Google Drive Data in Apache Spark using SQL
Access and process Google Drive Data in Apache Spark using the CData Software JDBC Driver.
-
How to use SQLAlchemy ORM to access Tickspot Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Tickspot data.
-
Connect to Avro Data from Crystal Reports
Use CData Connect AI to connect to and report on live Avro data from Crystal Reports.
-
Access Live Salesforce Data in AWS Lambda
Connect to live Salesforce data in AWS Lambda using the CData JDBC Driver.
-
Migrating data from ActiveCampaign to Snowflake using CData SSIS Components.
Easily push ActiveCampaign data to Snowflake using the CData SSIS Tasks for ActiveCampaign and Snowflake.
-
How to Connect Flowise AI Agents to Live Adobe Experience Manager 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 Adobe Experience Manager data without replication.
-
Connect Act-On Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Act-On data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create Yelp-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Yelp Data from Klipfolio and build custom visualizations using live Yelp data.
-
Deploy the ADO.NET Provider for Certinia on an SSRS Report Server
Connect to Certinia 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.
-
Analyze BenchmarkEmail Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of BenchmarkEmail data and visualize live BenchmarkEmail data in Infragistics Reveal.
-
Getting Started with the CData Connect AI Python SDK for Oracle Service Cloud
Install the CData Connect AI Python SDK to read and write live Oracle Service Cloud data with standard DB-API 2.0 Python code.
-
Connect to Todoist Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Todoist data.
-
Deploy the ADO.NET Provider for Aha! on an SSRS Report Server
Connect to Aha! 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.
-
Integrate Amazon DynamoDB Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Amazon DynamoDB data from Informatica Cloud.
-
How to Query Live MessageBird Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live MessageBird data data in natural language using Python.
-
How to publish and share SAP Netweaver Gateway Data dashboards with Tableau Server
The CData ODBC driver for SAP Netweaver Gateway enables you integrate SAP Netweaver Gateway data into Tableau dashboards.
-
Extract, Transform, and Load PhantomBuster Data in Informatica PowerCenter
Create a simple Workflow for PhantomBuster data in Informatica PowerCenter.
-
Connect to Productboard Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Productboard as an External Source in Dremio.
-
Integrating LlamaIndex with Adobe Commerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Adobe Commerce data in real time.
-
How to Connect Egnyte 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 Egnyte data in real time using natural language.
-
Build Charts with Gong Data in Clear Analytics
Create dynamic charts and perform analytics based on Gong data in Clear Analytics.
-
Use the CData Software ODBC Driver for Zendesk in MicroStrategy Desktop
Connect to Zendesk data in MicroStrategy Desktop using the CData Software ODBC Driver for Zendesk.
-
Write a Simple Go Application to work with Dropbox Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Dropbox data.
-
How to Access Live RabbitMQ Data in Power Automate Desktop via ODBC
The CData ODBC Driver for RabbitMQ enables you to integrate RabbitMQ data into workflows built using Microsoft Power Automate Desktop.
-
Access SendInBlue Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SendInBlue data from HeidiSQL.
-
Connect to SAP SuccessFactors Data from a Connection Pool in Jetty
The SAP SuccessFactors JDBC Driver supports connection pooling: This article shows how to connect faster to SAP SuccessFactors data from Web apps in Jetty.
-
How to integrate Azure Synapse with Apache Airflow
Access and process Azure Synapse data in Apache Airflow using the CData JDBC Driver.
-
Integrating Cursor with Chargebee 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.
-
Back Up Pipedrive data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Pipedrive. In this article, we will employ an SSIS workflow to populate a database with Pipedrive data data.
-
How to connect to Adobe Target Data with Squirrel SQL client
Connect to Adobe Target data and execute queries in the Squirrel SQL Client.
-
Use the CData ODBC Driver for ChargeOver in Microsoft Power Query
You can use the CData ChargeOver ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ChargeOver data into Microsoft Power Query.
-
Import and Visualize Mailjet Data in Power View
Create data visualizations based on Mailjet data in Excel.
-
Replicate Multiple SQL Server Accounts
Replicate multiple SQL Server accounts to one or many databases.
-
Use Dash to Build to Web Apps on Sugar CRM Data
Create Python applications that use pandas and Dash to build Sugar CRM-connected web apps.
-
Use the CData Software JDBC Driver for Avro in MicroStrategy Desktop
Connect to Avro data in MicroStrategy Desktop using the CData Software JDBC Driver for Avro.
-
Integrate Oracle Sales Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Oracle Sales data and integrate live Oracle Sales data into your Power Automate tasks.
-
Connect to Demio Data in Ruby
Connect to Demio data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate with Phoenix Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Phoenix data to a JSON file on disk.
-
Migrating data from Anaplan to Snowflake using CData SSIS Components.
Easily push Anaplan data to Snowflake using the CData SSIS Tasks for Anaplan and Snowflake.
-
How to connect Amazon QuickSight to ZohoExpense Data
Create a connection to ZohoExpense data in CData Connect AI and insert ZohoExpense data into Amazon QuickSight SPICE to build interactive dashboards.
-
Visualize Live Google Directory Data in the Power BI Service
Use CData Connect AI to connect to live Google Directory data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Replicate Multiple Quaderno Accounts
Replicate multiple Quaderno accounts to one or many databases.
-
Integrating Boomi Agentstudio with SAS xpt Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to SAS xpt data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Integrate Coda Data into Power Automate Desktop using CData Connect
CData Connect for Coda Data enables you to integrate Coda data into workflows built using Microsoft Power Automate Desktop.
-
Shippo Reporting in OBIEE with the Shippo JDBC Driver
Deploy the Shippo JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Guru Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Guru data.
-
Provide OData Services of Avalara AvaTax Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Avalara AvaTax data by developing a WCF Service Application.
-
Integrating Dataiku with Omnisend Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Omnisend data.
-
Connect to Supabase Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Supabase data in the Denodo Virtual DataPort Administrator.
-
Query SFTP Data as a MySQL Database in Node.js
Execute MySQL queries against SFTP data from Node.js.
-
Migrating data from Onfleet to Databricks using CData SSIS Components.
Easily push Onfleet data to Databricks using the CData SSIS Tasks for Onfleet and Databricks.
-
Use the CData ODBC Driver for Lakebase in Microsoft Power Query
You can use the CData Lakebase ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Lakebase data into Microsoft Power Query.
-
Build a Simple VCL Application for PolarTeamPro Data
How to build a simple VCL Application to view PolarTeamPro data in RAD Studio using the CData ODBC Driver for PolarTeamPro.
-
Publish Crystal Reports on ActiveCampaign Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ActiveCampaign data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for AgileCRM
Provide connectivity to AgileCRM data through an SAP BusinessObjects universe.
-
Query Live Oracle HCM Cloud 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 Oracle HCM Cloud data through a conversational interface.
-
Build Dashboards with ConstantContact Data in Dundas BI
Create dynamic dashboards and perform analytics based on ConstantContact data in Dundas BI.
-
Automated Continuous ZendeskSell Replication to Databricks
Use CData Sync for automated, continuous, customizable ZendeskSell replication to Databricks.
-
Integrate Devin with Live Egnyte 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 Egnyte data.
-
How to connect PolyBase to Perigon
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Perigon data.
-
Create Dynamic Marketo Grids Using the Infragistics XamDataGrid
Learn how you can connect Marketo to Infragistics XamDataGrid to build dynamic grids.
-
How to Connect to & Open Azure Data Lake Storage Data in Microsoft Excel
This article uses the CData ODBC driver for Azure Data Lake Storage to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrating LangChain with Zendesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Zendesk data within automated workflows.
-
Automated Continuous Amazon DynamoDB Replication to MySQL
Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to MySQL.
-
Integrating Boomi Agentstudio with CapsuleCRM Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to CapsuleCRM data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Access Live Procore Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Procore data through MCP integration.
-
Automated Continuous Zendesk Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Zendesk replication to Amazon S3.
-
Design BIRT Reports on ScrapingBee Data
Provide current ScrapingBee data to your embedded analytics.
-
Build a PostgreSQL Interface for Facebook Data using the CData JDBC Driver
Use the Remoting features of the Facebook JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated ShipStation Data Replication to Teradata
Use CData Sync to Customize and automate ShipStation data replication to Teradata.
-
Connect to eBay from Asprova with CData Software ODBC Driver for eBay
This article shows how to connect faster to eBay data from Asprova.
-
Migrating data from Adobe Target to Snowflake using CData SSIS Components.
Easily push Adobe Target data to Snowflake using the CData SSIS Tasks for Adobe Target and Snowflake.
-
Connect to Azure Analysis Services Data in RapidMiner
Integrate Azure Analysis Services data with standard components and data source configuration wizards in RapidMiner Studio.
-
Create Informatica Mappings From/To a JDBC Data Source for JSON
Create JSON data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to connect to Planio Data with Squirrel SQL client
Connect to Planio data and execute queries in the Squirrel SQL Client.
-
Load ZohoInvoice Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ZohoInvoice data to a database.
-
How to Connect DBeaver to ServiceDesk Plus via a JDBC Driver
Manage ServiceDesk Plus data with visual tools in DBeaver like the query browser.
-
How to update Salesloft from Excel
This article explains how to transfer data from Excel to Salesloft using the Excel Add-In for Salesloft.
-
Use the CData Software ODBC Driver for BenchmarkEmail in MicroStrategy Desktop
Connect to BenchmarkEmail data in MicroStrategy Desktop using the CData Software ODBC Driver for BenchmarkEmail.
-
Use the CData ODBC Driver for Apollo in Microsoft Power Query
You can use the CData Apollo ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Apollo data into Microsoft Power Query.
-
Automated Continuous Jodoo Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Jodoo replication to AlloyDB.
-
Integrate Zuora Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Zuora data and integrate live Zuora data into your Power Automate tasks.
-
Getting Started with the CData SSIS Components for PayPal
Complete guide to installing, licensing, and connecting with the CData SSIS Components for PayPal.
-
How to create an RPA flow for Oracle SCM Data in UiPath Studio
Use the Oracle SCM ODBC Driver to create workflows that access real-time Oracle SCM data without any coding.
-
Create Tally-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Tally Data from OutSystems and build custom enterprise apps using live Tally data.
-
Connect to and Visualize Live Paylocity Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Paylocity data.
-
Build Wistia-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Wistia Data and create custom apps in Bubble.
-
Analyze SAP BusinessObjects BI Data in Cognos Analytics
Use CData Connect AI to connect to SAP BusinessObjects BI Data from Cognos Analytics and analyze live SAP BusinessObjects BI data.
-
Automated Continuous Greenplum Replication to Databricks
Use CData Sync for automated, continuous, customizable Greenplum replication to Databricks.
-
Integrate Open WebUI with Live Bitbucket Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Bitbucket data from within the chat interface.
-
How to Connect PolarTeamPro 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 PolarTeamPro data in real time using natural language.
-
Excel Spreadsheet Automation on SAP Hybris C4C Data with the QUERY Formula
Pull data from SAP Hybris C4C, automate spreadsheets, and more with the QUERY formula.
-
Analyze LinkedIn Ads Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of LinkedIn Ads data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Automated Continuous Templated Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Templated replication to IBM DB2.
-
A Comparison of JDBC Drivers for MySQL
A performance comparison of the CData JDBC Driver for MySQL, the MySQL Connector/J, and the MariaDB Connector/J
-
Automated Continuous Microsoft Ads Replication to SQLite
Use CData Sync for automated, continuous, customizable Microsoft Ads replication to SQLite.
-
Connect to ElevenLabs Data in Ruby
Connect to ElevenLabs data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use Claude to Talk to Your SingleStore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your SingleStore data for you.
-
Integrate Google's Antigravity Agent with Live Anaplan Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Anaplan data using the Model Context Protocol.