CData Software - Knowledge Base
Recent Articles
-
Connecting Pipedream with Twilio Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Twilio data in real time.
-
Build AI/ML Models with Live FormSite Data using Dataiku
Connect FormSite Data with Dataiku using the CData API Driver for JDBC.
-
Integrating Claude Code CLI with Hugging Face 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.
-
Automated Continuous IBM Cloud Object Storage Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable IBM Cloud Object Storage replication to Amazon Redshift.
-
How to Seamlessly Import Perplexity Data into IBM SPSS Modeler
Integrate Perplexity data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrating Antigravity CLI with Reply.io via CData CLI
Connect Reply.io to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Load ShipStation Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ShipStation to a database.
-
How to load Factorial data into Elasticsearch via Logstash
Introducing a simple method to load Factorial data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate with Missive Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Missive to a JSON file on disk.
-
Use the CData Software ODBC Driver for FTP in MicroStrategy Desktop
Connect to FTP Servers in MicroStrategy Desktop using the CData Software ODBC Driver for FTP.
-
Connect ZarMoney to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ZarMoney with IBM WebSphere for seamless data integration and connectivity.
-
How to Connect to Live Salesforce 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 Salesforce & Force.com without replication.
-
Replicate eBay Analytics Data in Heroku for Use in Salesforce Connect
Replicate eBay Analytics to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Query Live Paylocity Data in Perplexity MacOS Desktop
Connect to and query live Paylocity Data in Perplexity Desktop using CData MCP Server.
-
Use the CData ODBC Driver for SQL Analysis Services in Microsoft Power Query
You can use the CData SQL Analysis Services ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SQL Analysis Services into Microsoft Power Query.
-
Getting Started with the CData SSIS Components for Printify
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Printify.
-
Integrate Live Cassandra Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Create Informatica Mappings From/To a JDBC Data Source for MessageBird
Create MessageBird data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect Microsoft OneDrive to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Microsoft OneDrive with IBM WebSphere for seamless data integration and connectivity.
-
Connect to Azure Table Data from PowerBuilder via ADO.NET
This article demonstrates how to access Azure Table Storage from Appeon PowerBuilder using the CData ADO.NET Provider for Azure Table.
-
Integrating Claude Code with Salesforce Marketing Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Salesforce Marketing Cloud within assisted coding and automated development workflows.
-
Use the CData Software ODBC Driver for ZohoMarketingHub in SAS for Real-Time Reporting and Analytics
Connect to real-time ZohoMarketingHub in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ZohoMarketingHub.
-
Getting Started with the CData Connect AI Python SDK for Salesforce Marketing
Install the CData Connect AI Python SDK to read and write live Salesforce Marketing Cloud with standard DB-API 2.0 Python code.
-
Automated Continuous Wave Financial Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Wave Financial replication to delimited files (CSV/TSV).
-
How to Build an ETL App for Sugar CRM Data in Python with CData
Create ETL applications and real-time data pipelines for Sugar CRM in Python with petl.
-
Build Excel Online Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Microsoft Excel Online and build visualizations in Tableau Cloud.
-
Manage Facebook Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Facebook.
-
Connect to Moosend from Asprova with CData Software ODBC Driver for Moosend
This article shows how to connect faster to Moosend data from Asprova.
-
Replicate DB2 Data to Multiple Databases
Replicate IBM DB2 to disparate databases with a point-and-click configuration.
-
Access Live SAP Netweaver Gateway Data in TIBCO Data Virtualization
Use the SAP Netweaver Gateway Tibco DV Adapter to create a SAP Netweaver Gateway data source in TIBCO Data Virtualization Studio and gain access to live SAP Netweaver Gateway from your TDV Server.
-
How to connect SharePoint with GraphQL Data through external lists
Provide GraphQL to SharePoint users as an external list.
-
Migrating data from LeadDesk to Snowflake using CData SSIS Components.
Easily push LeadDesk to Snowflake using the CData SSIS Tasks for LeadDesk and Snowflake.
-
Integrate Live Amazon S3 Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
How to Visualize SAP BusinessObjects BI 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 SAP BusinessObjects BI in Python.
-
Replicate Splunk Data from PowerShell
Write a quick PowerShell script to query Splunk. Use connectivity to the live data to replicate Splunk to SQL Server.
-
Analyze Anaplan Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Anaplan and visualize live Anaplan in Infragistics Reveal.
-
Use Dash to Build Web Apps on Google Ads Data via CData Connect AI
Build interactive Dash web apps on live Google Ads using pandas and the CData Connect AI Python SDK.
-
How to Build an ETL App for Recurly Data in Python with CData
Create ETL applications and real-time data pipelines for Recurly in Python with petl.
-
How to update Presto from Excel
This article explains how to transfer data from Excel to Presto using the Excel Add-In for Presto.
-
Connect to Flowlu Data in RapidMiner
Integrate Flowlu with standard components and data source configuration wizards in RapidMiner Studio.
-
Query Live Facebook Ads 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 Facebook Ads directly from the development environment.
-
DataBind Controls to Zoho Books Data in C++Builder
DataBind to Zoho Books in C++Builder with standard components and controls.
-
Extract, Transform, and Load Qualaroo Data in Informatica PowerCenter
Create a simple Workflow for Qualaroo in Informatica PowerCenter.
-
Connect to CloudConvert from a Connection Pool in WebLogic
Use the CData JDBC Driver for CloudConvert to connect to CloudConvert from Web applications running on WebLogic.
-
Build Visualizations of Basecamp Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Basecamp in Birst.
-
Connect to Kafka from a Connection Pool in WebLogic
Use the CData JDBC Driver for Kafka to connect to Apache Kafka from Web applications running on WebLogic.
-
Bidirectional Access to HubDB Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate HubDB in Filemaker Pro for Mac or Windows.
-
Create SSAS Tabular Models from FreshBooks Data
How to build a SQL Server Analysis Service Tabular Model from FreshBooks using CData drivers.
-
Connect to Bitly Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Bitly in the Denodo Virtual DataPort Administrator.
-
Feed CockroachDB Data into FineReport
How to set CockroachDB as a JDBC data source in FineReport.
-
Connect to ConvertAPI Data in DBArtisan
Use wizards in DBArtisan to configure ConvertAPI as a data source.
-
Build Pipelines with Live DB2 Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to DB2 from Google Cloud Data Fusion, enabling the integration of live IBM DB2 into the building and management of effective data pipelines.
-
Connecting Moonlit Workflow with DocuSign Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your DocuSign in real time.
-
Getting Started with the CData ADO.NET Provider for EnterpriseDB
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for EnterpriseDB.
-
Automated Continuous Klaviyo Replication to Oracle
Use CData Sync for automated, continuous, customizable Klaviyo replication to Oracle.
-
Prepare, Blend, and Analyze Guru Data in Alteryx Designer (ODBC)
Build workflows to access live Guru for self-service data analytics.
-
Create Oracle SCM-Connected Business Apps in AppSheet
Connect to Oracle SCM Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Oracle SCM.
-
Build Data Flows from SQL Server to Google Spanner through SSIS
Easily push SQL Server data to Google Spanner using the CData SSIS Tasks for Google Spanner.
-
Build an OLAP Cube in SSAS from Redshift Data
Establish a connection to Amazon Redshift data from SQL Server Analysis Services, and use the Redshift Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connecting Moonlit Workflow with Zoho CRM Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Zoho CRM in real time.
-
Build MariaDB-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for MariaDB to explore live MariaDB Data in GitHub Copilot to assist with building MariaDB-powered applications.
-
Integrate Real-Time Access to eBay in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to eBay in real time.
-
Integrate Live Cassandra Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Apache Cassandra to Blue Prism using the CData ODBC Driver for Cassandra to create automated workflows for repetitive business tasks.
-
Build Power BI XMLA-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Power BI XMLA to explore live Power BI XMLA Data in Cursor to assist with building Power BI XMLA-powered applications.
-
How to create Visio diagrams from Avalara AvaTax Data
Automatically update Avalara AvaTax with the changes you make to Visio master shapes.
-
Work with Google Contacts Data in FoxPro
Load Google Contacts into a FoxPro database. This article includes full code and a walk-through of the process.
-
Using the CData Software ODBC Driver for ZohoDesk in PyCharm
Connect to ZohoDesk as an ODBC data source in PyCharm using the CData Software ODBC Driver for ZohoDesk.
-
Integrate Cursor with Live Asana Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Asana from within the editor.
-
Create a Data Access Object for Foursquare Data using JDBI
A brief overview of creating a SQL Object API for Foursquare in JDBI.
-
Model SQL Analysis Services Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SQL Analysis Services, enabling the direct import of real-time SQL Analysis Services.
-
How to Build an ETL App for HBase Data in Python with CData
Create ETL applications and real-time data pipelines for Apache HBase in Python with petl.
-
Back Up Autopilot to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Autopilot data.
-
Integrating Cursor CLI with SendInBlue 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 to Azure Data Lake Storage Data in DBVisualizer
Integrate Azure Data Lake Storage with visual data analysis tools and data connection wizards in DBVisualizer
-
Analyze Avro Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Avro from Power Pivot. You will use the Table Import Wizard to load Apache Avro. You can visually build the import query or use any SQL supported by the driver.
-
Connecting Mastra with Sage Intacct 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 Sage Intacct, no replication required.
-
Query, Visualize, and Share live Google Campaign Manager 360 Data in Redash
Use CData Connect AI to connect to live Google Campaign Manager 360 in Redash for querying, visualizing, and sharing.
-
Migrating data from Microsoft Dataverse to Snowflake using CData SSIS Components.
Easily push Microsoft Dataverse (CDS) to Snowflake using the CData SSIS Tasks for Microsoft Dataverse and Snowflake.
-
Connect to PolarTeamPro from a Connection Pool in WebLogic
Use the CData JDBC Driver for PolarTeamPro to connect to PolarTeamPro from Web applications running on WebLogic.
-
Use Databricks Agent Bricks to Talk to Your Sugar CRM Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Sugar CRM for you.
-
A PostgreSQL Interface for GetResponse Data (MySQL Remoting via JDBC)
Use the Remoting features of the GetResponse JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Seamlessly Import QuickBooks Data into IBM SPSS Modeler
Integrate QuickBooks data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Design Pipedrive Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Pipedrive from mobile and tablet Power Apps.
-
Automated Continuous Facebook Replication to Oracle
Use CData Sync for automated, continuous, customizable Facebook replication to Oracle.
-
Migrating data from eBay Analytics to Google BigQuery using CData SSIS Components.
Easily push eBay Analytics to Google BigQuery using the CData SSIS Tasks for eBay Analytics and Google BigQuery.
-
Build Visualizations of Amplitude Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Amplitude in Birst.
-
Build SharePoint Excel Services-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SharePoint Excel Services and build web apps with connectivity to live SharePoint Excel Services.
-
Back Up SAP Business Warehouse to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SAP Business Warehouse. In this article, we will employ an SSIS workflow to populate a database with SAP Business Warehouse data.
-
Choosing the Best Method to Connect HubDB to SQL Server: 5 Options Explained
Discover multiple ways to connect and use HubDB from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build Bitbucket-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Bitbucket and build web apps with connectivity to live Bitbucket.
-
How to import Recurly Data into Apache Solr
Use the CData Software JDBC Driver for Recurly in Data Import Handler and create an automated import of Recurly to Apache Solr Enterprise Search platform.
-
Integrate Paylocity with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Paylocity with External Services.
-
Integrate Cursor with Live Databricks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Databricks from within the editor.
-
Integrating OpenCode Terminal with Oracle Eloqua Reporting 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.
-
Operational Reporting on Aha! Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Aha!.
-
Easily Integrate Accelo Data in Lazarus Pascal IDE
Learn how to easily integrate live Accelo in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to connect to Oracle Eloqua Reporting Data from Spring Boot
Connect to Oracle Eloqua Reporting in a Spring Boot Application using the CData JDBC Driver for Oracle Eloqua Reporting
-
Moving Data from Pinecone to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Pinecone data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automate Sage Cloud Accounting Data Replication to Azure Data Lake
Use CData Sync to customize and automate Sage Business Cloud Accounting replication to Azure Data Lake.
-
Automated Continuous Quaderno Replication to SingleStore
Use CData Sync for automated, continuous, customizable Quaderno replication to SingleStore.