CData Software - Knowledge Base
Recent Articles
-
Connecting GenSpark with SAP ByDesign Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SAP ByDesign data without any replication or custom integration required.
-
Connect to SAS Data Sets Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for SAS Data Sets data in Airbyte.
-
Build Amazon Marketplace-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Amazon Marketplace data.
-
Create Informatica Mappings From/To a JDBC Data Source for eBay
Create eBay data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Create Reports with ADP Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ADP data.
-
Integrate Open WebUI with Live JSON Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live JSON services from within the chat interface.
-
How to Work with MariaDB Data in ETL Validator JDBC
Connect to MariaDB from ETL Validator jobs using the CData Software JDBC Driver.
-
Migrating data from Miro to Snowflake using CData SSIS Components.
Easily push Miro data to Snowflake using the CData SSIS Tasks for Miro and Snowflake.
-
How to connect to Aha! Data from IntelliJ
Integrate connectivity to Aha! data with wizards in IntelliJ.
-
ETL MailerLite in Oracle Data Integrator
This article shows how to transfer MailerLite data into a data warehouse using Oracle Data Integrator.
-
Use Dash to Build to Web Apps on Adobe Target Data
Create Python applications that use pandas and Dash to build Adobe Target-connected web apps.
-
Use Dash to Build to Web Apps on Zoho Creator Data
Create Python applications that use pandas and Dash to build Zoho Creator-connected web apps.
-
Create Informatica Mappings From/To a JDBC Data Source for Cassandra
Create Cassandra data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build AI Agents with Cloudflare Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Cloudflare data through CData Connect AI.
-
Migrating data from Jodoo to Snowflake using CData SSIS Components.
Easily push Jodoo data to Snowflake using the CData SSIS Tasks for Jodoo and Snowflake.
-
Visualize Live Rootly Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Rootly data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Postmark Data in DBeaver
Use the CData ODBC Driver to connect to Postmark data in DBeaver.
-
Build Voice Agents in ElevenLabs with access to Live Coda Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Coda data.
-
Access Live Dotmailer Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Dotmailer data into the statistical analysis tools available in SAS JMP. This article shows how to use Dotmailer data in the Graph Builder and Query Builder.
-
Automated Continuous MariaDB Replication to Oracle
Use CData Sync for automated, continuous, customizable MariaDB replication to Oracle.
-
Automated Continuous Clio Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Clio replication to Google Cloud SQL.
-
Integrate Spark Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Spark data and integrate live Spark data into your Power Automate tasks.
-
How to Build an ETL App for ChartMogul Data in Python with CData
Create ETL applications and real-time data pipelines for ChartMogul data in Python with petl.
-
Query Printify Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Printify data from Node.js.
-
Consume MailChimp OData Feeds in PowerBuilder
This article demonstrates how to consume MailChimp data as OData feeds from PowerBuilder using the API Server.
-
Integrate Adobe Analytics Data in the Pentaho Report Designer
Publish reports based on Adobe Analytics data in the Pentaho BI tool.
-
Create Cosmos DB-Connected Applications in Appsmith
Connect to Cosmos DB Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Cosmos DB data.
-
Import Real-Time Hive Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Hive data in ColdFusion.
-
How to Visualize Amplitude Data in Python with pandas
Use pandas and other modules to analyze and visualize live Amplitude data in Python.
-
Connect to Airtable Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Airtable data.
-
Integrate Trae with Live Act-On Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Act-On data from within the AI-powered IDE.
-
Integrating OpenCode with MailChimp 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 Pinterest Replication to SQLite
Use CData Sync for automated, continuous, customizable Pinterest replication to SQLite.
-
Replicate Pipeline CRM Data from PowerShell
Write a quick PowerShell script to query Pipeline CRM data. Use connectivity to the live data to replicate Pipeline CRM data to SQL Server.
-
Build MVC Applications with Connectivity to SendPulse Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SendPulse from an ASP.NET MVC application.
-
How to Visualize Google Cloud Storage 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 Google Cloud Storage data in Python.
-
Access Facebook Ads Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Facebook Ads data from HeidiSQL.
-
Connect to Wave Financial from a Connection Pool in WebLogic
Use the CData JDBC Driver for Wave Financial to connect to Wave Financial data from Web applications running on WebLogic.
-
Connect to SurveyMonkey Data from a Connection Pool in JBoss
Integrate SurveyMonkey data into Java servlets: Use the Management Console in JBoss to install the SurveyMonkey JDBC Driver.
-
Query Live Trello 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 Trello data through a conversational interface.
-
Feed Jira Data into FineReport
How to set Jira data as a JDBC data source in FineReport.
-
Use the CData Software JDBC Driver for Square in MicroStrategy Web
Connect to Square data in MicroStrategy Web using the CData Software JDBC Driver for Square.
-
Use Dash to Build Web Apps on ClickUp Data via CData Connect AI
Build interactive Dash web apps on live ClickUp data using pandas and the CData Connect AI Python SDK.
-
Automated HBase Data Replication to Teradata
Use CData Sync to Customize and automate HBase data replication to Teradata.
-
Use JayDeBeApi to access Zuora Data in Python
Use standard Python scripting and the development environment of your choice to access live Zuora data.
-
How to Query Live Cloudflare Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Cloudflare data data in natural language using Python.
-
Query Live Gmail 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 Gmail data directly from the development environment.
-
Link PolarTeamPro with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate PolarTeamPro data in Filemaker Pro for Mac or Windows.
-
Building Dynamic Web Pages with Smartsheet Data Using AngularJS
Create single-page applications with live connectivity to Smartsheet using the CData API Server.
-
Use the CData ODBC Driver for ClickTime in Microsoft Power Query
You can use the CData ClickTime ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ClickTime data into Microsoft Power Query.
-
Connect Sendwithus to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Sendwithus with IBM WebSphere for seamless data integration and connectivity.
-
Migrating data from ElevenLabs to Snowflake using CData SSIS Components.
Easily push ElevenLabs data to Snowflake using the CData SSIS Tasks for ElevenLabs and Snowflake.
-
Automated Continuous Gorgias Replication to Oracle
Use CData Sync for automated, continuous, customizable Gorgias replication to Oracle.
-
Write a Simple Go Application to work with Google Cloud Storage Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Google Cloud Storage data.
-
Connect Teradata to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Teradata with IBM WebSphere for seamless data integration and connectivity.
-
Build Pipelines with Live BigCommerce Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to BigCommerce from Google Cloud Data Fusion, enabling the integration of live BigCommerce data into the building and management of effective data pipelines.
-
SFTP Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SFTP facts in real time.
-
Search External Supabase Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Supabase data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Supabase Data objects that you can access from apps and the dashboard.
-
Integrating Kiro with Salesforce Data 360 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 ShipEngine Replication to Oracle
Use CData Sync for automated, continuous, customizable ShipEngine replication to Oracle.
-
Automated Continuous Humanity Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Humanity replication to Azure SQL Database.
-
Create Informatica Mappings From/To an ODBC Data Source for eBay Analytics
Create an ODBC connection to eBay Analytics in Informatica and browse and transfer eBay Analytics data.
-
Connect to AfterShip Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for AfterShip data in Airbyte.
-
Connect to SAP SuccessFactors LMS Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SAP SuccessFactors LMS to connect to SAP SuccessFactors LMS data and execute queries in PowerBuilder.
-
Integrate Workday Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Workday data and integrate live Workday data into your Power Automate tasks.
-
Connect to Airtable Data from Crystal Reports
Use CData Connect AI to connect to and report on live Airtable data from Crystal Reports.
-
How to work with Slack Data in Apache Spark using SQL
Access and process Slack Data in Apache Spark using the CData Software JDBC Driver.
-
How to connect PolyBase to XML
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live XML data.
-
Connect to Oracle Data from HeidiSQL
Use CData Connect AI to connect to and query live Oracle data from HeidiSQL.
-
Automate Zoho CRM Data Replication to Azure Data Lake
Use CData Sync to customize and automate Zoho CRM data replication to Azure Data Lake.
-
Integrate Live ClickUp Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to ClickUp data and integrate live ClickUp data into apps built in Microsoft Power Apps.
-
Connect to Unbounce Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Unbounce data.
-
How to Connect to Live Google Drive 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 Google Drive data without replication.
-
Connect to FreeAgent Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time FreeAgent data using standard SQL.
-
Integrate Oracle SCM Data in Pentaho Data Integration
Build ETL pipelines based on Oracle SCM data in the Pentaho Data Integration tool.
-
Access Live TaxJar 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 TaxJar data through MCP integration.
-
How to Seamlessly Import Amplitude Data into IBM SPSS Modeler
Integrate Amplitude data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Create Data Visualizations Based On Testmonitor Data in Mode
Use CData Connect AI to connect to Testmonitor Data from Mode and build visualizations using live Testmonitor data.
-
Use JayDeBeApi to access JDBC-ODBC Bridge Data in Python
Use standard Python scripting and the development environment of your choice to access live JDBC-ODBC Bridge data.
-
Build a Simple VCL Application for Redis Data
How to build a simple VCL Application to view Redis data in RAD Studio using the CData ODBC Driver for Redis.
-
Visualize Parquet Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Parquet data.
-
How to import Clari Data into Apache Solr
Use the CData Software JDBC Driver for Clari in Data Import Handler and create an automated import of Clari data to Apache Solr Enterprise Search platform.
-
Automated Continuous Dynamics NAV Replication to Oracle
Use CData Sync for automated, continuous, customizable Dynamics NAV replication to Oracle.
-
Integrating Claude Code with HBase Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on HBase data within assisted coding and automated development workflows.
-
How to Build an ETL App for Google Search Results in Python with CData
Create ETL applications and real-time data pipelines for Google Search results in Python with petl.
-
Connect and Query Live Amazon Marketplace Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Amazon Marketplace data into Databricks and enable direct, live querying and analysis without replication.
-
Connect and Query Live Dropbox Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Dropbox data into Databricks and enable direct, live querying and analysis without replication.
-
Build AI Agents with Sendwithus Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Sendwithus data through CData Connect AI.
-
Build Azure Synapse Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Azure Synapse data and build visualizations in Tableau Cloud.
-
Build Exa Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Exa data and build visualizations in Tableau Cloud.
-
Automated Continuous Codat Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Codat replication to Amazon Redshift.
-
Deploy the ADO.NET Provider for PolarTeamPro on an SSRS Report Server
Connect to PolarTeamPro 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.
-
Connect to SAP Fieldglass Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live SAP Fieldglass data.
-
How to Connect to Live Bullhorn CRM Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Bullhorn CRM data for you.
-
Choosing the Best Method to Connect PabblySubscriptions to SQL Server: 5 Options Explained
Discover multiple ways to connect and use PabblySubscriptions data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Visualize Accelo Data in Tableau
The CData ODBC driver for Accelo enables you integrate Accelo data into Tableau dashboards.
-
Use Biml to Build SSIS Tasks to Replicate Insightly Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Insightly data to SQL Server.
-
Moving Data from Rebilly to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Rebilly data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Provide OData Services of Klaviyo Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Klaviyo data by developing a WCF Service Application.
-
Access Live Optimizely Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Optimizely data from your Excel spreadsheets.