CData Software - Knowledge Base
Recent Articles
-
Enable the PingOne JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with PingOne data.
-
Connect to Instantly Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Instantly data.
-
Import and Visualize SAP Ariba Procurement Data in Power View
Create data visualizations based on SAP Ariba Procurement data in Excel.
-
How to integrate Close with Apache Airflow
Access and process Close data in Apache Airflow using the CData JDBC Driver.
-
Automated Continuous Outlook Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Outlook replication to Apache Kafka.
-
View Reports on Real-Time SAS xpt Data in Power BI Report Server
Use the CData ODBC Driver for SAS xpt to visualize SAS xpt data in Power BI Desktop and then publish them to Power BI Report Server.
-
Write a Simple Go Application to work with Aha! Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Aha! data.
-
Replicate MailChimp Data from PowerShell
Write a quick PowerShell script to query MailChimp data. Use connectivity to the live data to replicate MailChimp data to SQL Server.
-
How to Build an ETL App for GetResponse Data in Python with CData
Create ETL applications and real-time data pipelines for GetResponse data in Python with petl.
-
Prepare, Blend, and Analyze Cosmos DB Data in Alteryx Designer (Connect AI)
Build workflows to access live Cosmos DB data for self-service data analytics.
-
Build Salesforce-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Salesforce data and build Salesforce-connected web apps with Axios.
-
How to connect to ZeroBounce Data with Squirrel SQL client
Connect to ZeroBounce data and execute queries in the Squirrel SQL Client.
-
Use the CData Software JDBC Driver for MailChimp in MicroStrategy Web
Connect to MailChimp data in MicroStrategy Web using the CData Software JDBC Driver for MailChimp.
-
Connect to SAP BusinessObjects BI from Asprova with CData Software ODBC Driver for SAP BusinessObjects BI
This article shows how to connect faster to SAP BusinessObjects BI data from Asprova.
-
LINQ to Browserless 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 Browserless Data Provider.
-
Automated Continuous Landbot Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Landbot replication to Azure SQL Database.
-
Connect to HubDB Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for HubDB data in Airbyte.
-
Integrating GitHub Copilot with Square 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.
-
Use Microsoft Copilot Studio to talk to your Pinterest 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 Pinterest data for you.
-
Analyze Helpscout Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Helpscout from Power Pivot. You will use the Table Import Wizard to load Helpscout data. You can visually build the import query or use any SQL supported by the driver.
-
How to Query MailerSend Data in MySQL Workbench
Execute MySQL queries against live MailerSend data from MySQL Workbench.
-
Access Live SAS Data Sets Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAS Data Sets data from your Google Sheets.
-
Integrate with live Tally Data in Jitterbit
Use CData Connect AI to connect to and integrate live Tally data in Jitterbit.
-
Build Agents in Relevance AI with Access to Live Marketo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Marketo data within intelligent agent workflows.
-
Create SFTP-Connected Applications in Appsmith
Connect to SFTP Data via CData Connect AI in Appsmith and create custom business applications with real-time access to SFTP data.
-
Automated Continuous Act CRM Replication to SingleStore
Use CData Sync for automated, continuous, customizable Act CRM replication to SingleStore.
-
Access Live Freshdesk Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Freshdesk data from your Excel spreadsheets.
-
Publish Amazon DynamoDB-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Amazon DynamoDB data.
-
Connect to Microsoft Planner Data in RazorSQL
Connect to Microsoft Planner from wizards and query Microsoft Planner data from the GUI in the RazorSQL database management tool.
-
Feed ChartMogul Data into FineReport
How to set ChartMogul data as a JDBC data source in FineReport.
-
Getting Started with the CData Python Connector for Printful
Learn to install and license the CData Python Connector and configure a connection to live Printful data.
-
Connect to TigerGraph Data in Jaspersoft Studio
Execute SQL to remote TigerGraph data in Jaspersoft Studio.
-
Connect to Amazon Marketplace Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Amazon Marketplace data in the Denodo Virtual DataPort Administrator.
-
Build Charts with Elorus Data in Clear Analytics
Create dynamic charts and perform analytics based on Elorus data in Clear Analytics.
-
Integrating OpenCode with SurveyMonkey 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.
-
Connect to WordPress from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from WordPress data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to Seamlessly Import Discord Data into IBM SPSS Modeler
Integrate Discord data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Replicate Azure Data Lake Storage Data to Multiple Databases
Replicate Azure Data Lake Storage data to disparate databases with a point-and-click configuration.
-
Automated Continuous XML Replication to IBM DB2
Use CData Sync for automated, continuous, customizable XML replication to IBM DB2.
-
Build Apps with Live Amazon DynamoDB data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Amazon DynamoDB data into the Adalo platform and build custom mobile and web applications with real-time Amazon DynamoDB data.
-
How to import Samanage Data into Apache Solr
Use the CData Software JDBC Driver for Samanage in Data Import Handler and create an automated import of Samanage data to Apache Solr Enterprise Search platform.
-
Object-Relational Mapping (ORM) with CampaignMonitor 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 CampaignMonitor data into a Java-based ORM framework, Hibernate.
-
Create Campaigner-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Campaigner Data from OutSystems and build custom enterprise apps using live Campaigner data.
-
Migrating data from Cosmos DB to Google BigQuery using CData SSIS Components.
Easily push Cosmos DB data to Google BigQuery using the CData SSIS Tasks for Cosmos DB and Google BigQuery.
-
Automated Continuous Adobe Target Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Adobe Target replication to delimited files (CSV/TSV).
-
How to Query Customer.io Data in MySQL Workbench
Execute MySQL queries against live Customer.io data from MySQL Workbench.
-
Access Postmark 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 Postmark data.
-
Building Dynamic Web Pages with MongoDB Data Using AngularJS
Create single-page applications with live connectivity to MongoDB using the CData API Server.
-
Integrate with Live SAP HANA XS Advanced Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to SAP HANA XS Advanced from the MuleSoft Anypoint Platform to integrate live SAP HANA XS Advanced data into custom reports and dashboards.
-
Work with Live Sybase IQ Data in Power Query
Use CData Connect AI to connect to Sybase IQ data and work with live Sybase IQ data in Microsoft Power Query.
-
How to Build an ETL App for LeadDesk Data in Python with CData
Create ETL applications and real-time data pipelines for LeadDesk data in Python with petl.
-
Access Live Google Analytics 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 Google Analytics data through MCP integration.
-
Connect to and Query LightSpeedRetail Data in QlikView over ODBC
Create data visualizations with LightSpeedRetail data in QlikView.
-
Automated Continuous CampaignMonitor Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable CampaignMonitor replication to delimited files (CSV/TSV).
-
Automated Continuous SAP Business One Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SAP Business One replication to Apache Kafka.
-
Seamlessly Bring Oracle HCM Cloud Data into Retool Using CData Connect AI
Integrate Oracle HCM Cloud data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Extract, Transform, and Load Datadog Data in Informatica PowerCenter
Create a simple Workflow for Datadog data in Informatica PowerCenter.
-
Easily Integrate Mouseflow Data in Lazarus Pascal IDE
Learn how to easily integrate live Mouseflow data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build ActiveCampaign-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 ActiveCampaign data without replication.
-
Create Datasets from ZohoDesk in Domo Workbench and Build Visualizations of ZohoDesk Data in Domo
Use the CData Software ODBC Driver for ZohoDesk to create datasets from ZohoDesk data in Domo Workbench and then build visualizations in the Domo service.
-
How to load AlloyDB data into Elasticsearch via Logstash
Introducing a simple method to load AlloyDB data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrating Cursor with CircleCI 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 with Redis Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Redis data within assisted coding and automated development workflows.
-
Create Data Visualizations Based On Lakebase Data in Mode
Use CData Connect AI to connect to Lakebase Data from Mode and build visualizations using live Lakebase data.
-
Integrate with live Facebook Ads Data in Jitterbit
Use CData Connect AI to connect to and integrate live Facebook Ads data in Jitterbit.
-
Integrate with Kintone Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Kintone data in SnapLogic.
-
Create Dynamic Blackbaud FE NXT Grids Using the Infragistics XamDataGrid
Learn how you can connect Blackbaud FE NXT to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Cassandra Data in CloverDX (formerly CloverETL)
Transfer Cassandra data using the visual workflow in the CloverDX data integration tool.
-
DataBind Charts to Gumroad Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Gumroad data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Integrate Trae with Live DocuSign Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live DocuSign data from within the AI-powered IDE.
-
Import Google Contacts Data Using Azure Data Factory
Use CData Connect AI to connect to Google Contacts Data from Azure Data Factory and import live Google Contacts data.
-
Getting Started with the CData JDBC Driver for Gorgias
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Gorgias.
-
Build Data Flows from GetResponse to SQL Server using SSIS
Easily back up GetResponse data to SQL Server using the SSIS components for GetResponse.
-
Visualize REST Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load REST data into TIBCO Spotfire.
-
Choosing the Best Method to Connect Salesloft to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Salesloft data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Sage 200 Data from a Connection Pool in JBoss
Integrate Sage 200 data into Java servlets: Use the Management Console in JBoss to install the Sage 200 JDBC Driver.
-
Build Google Calendar-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Google Calendar data.
-
Connect to JSON Services from a Connection Pool in JBoss
Integrate JSON services into Java servlets: Use the Management Console in JBoss to install the JSON JDBC Driver.
-
Build Automated Workflows with Live SAP Business One Data in Workato
Use CData Connect AI to connect to live SAP Business One data and build automated workflows in Workato.
-
Connect to Invoiced Data from a Connection Pool in Jetty
The Invoiced JDBC Driver supports connection pooling: This article shows how to connect faster to Invoiced data from Web apps in Jetty.
-
How to use SQLAlchemy ORM to access Jira Assets Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Jira Assets data.
-
Integrate Theia IDE with Live BambooHR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live BambooHR data from within the development environment.
-
DataBind Charts to Rebilly Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Rebilly data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Connect to SAP Business One Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live SAP Business One data.
-
Object-Relational Mapping (ORM) with Jumpseller 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 Jumpseller data into a Java-based ORM framework, Hibernate.
-
Using the CData Software ODBC Driver for Twitter Ads in PyCharm
Connect to Twitter Ads as an ODBC data source in PyCharm using the CData Software ODBC Driver for Twitter Ads.
-
Automated Continuous Acumatica Replication to Databricks
Use CData Sync for automated, continuous, customizable Acumatica replication to Databricks.
-
DataBind Controls to Zoho Inventory Data in Delphi
DataBind to Zoho Inventory data in Delphi with standard data access components and controls.
-
Integrate NetSuite Data into Power Automate Desktop using CData Connect
CData Connect for NetSuite Data enables you to integrate NetSuite data into workflows built using Microsoft Power Automate Desktop.
-
Getting Started with the CData ADO.NET Provider for Amazon S3
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Amazon S3.
-
Visualize SageHR Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load SageHR data into TIBCO Spotfire.
-
Integrate Live Dropbox Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Dropbox data and integrate live Dropbox data into apps built in Microsoft Power Apps.
-
Create Dynamics CRM Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Dynamics CRM from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Square Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Square data in the Denodo Virtual DataPort Administrator.
-
Query Spark Data in ColdFusion
Write standard ColdFusion data access code to connect to Spark data.
-
Query Databricks Data as a MySQL Database in Node.js
Execute MySQL queries against Databricks data from Node.js.
-
Use Claude to Talk to Your CSV 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 CSV data for you.
-
Connect to Humanity Data in DBArtisan
Use wizards in DBArtisan to configure Humanity data as a data source.
-
Easily Integrate Front Data in Lazarus Pascal IDE
Learn how to easily integrate live Front data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Google Translate Data in DBArtisan
Use wizards in DBArtisan to configure Google Translate data as a data source.