CData Software - Knowledge Base
Recent Articles
-
Integrate with Toggl Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Toggl data to a JSON file on disk.
-
Using the CData Software ODBC Driver for AlloyDB in PyCharm
Connect to AlloyDB as an ODBC data source in PyCharm using the CData Software ODBC Driver for AlloyDB.
-
How to Connect to Live GetResponse 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 GetResponse data without replication.
-
Build ConstantContact-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live ConstantContact 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.
-
Using the CData Software ODBC Driver for Sybase in PyCharm
Connect to Sybase as an ODBC data source in PyCharm using the CData Software ODBC Driver for Sybase.
-
How to import Superchat Data into Apache Solr
Use the CData Software JDBC Driver for Superchat in Data Import Handler and create an automated import of Superchat data to Apache Solr Enterprise Search platform.
-
Visualize Live Customer.io Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Customer.io data.
-
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.
-
Access Live Box Data in AWS Lambda
Connect to live Box data in AWS Lambda using the CData JDBC Driver.
-
Work with Wistia Data in FoxPro
Load Wistia data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to LDAP Objects in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for LDAP Objects and connect to LDAP objects in Akorbi Digital RunMyProcess.
-
Getting Started with the CData Excel Add-In for CouchDB
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for CouchDB.
-
DataBind Controls to Power BI XMLA Data in C++Builder
DataBind to Power BI XMLA data in C++Builder with standard components and controls.
-
How to Access Live Zoom Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Zoom enables you to integrate Zoom data into workflows built using Microsoft Power Automate Desktop.
-
Manage ActiveCampaign Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for ActiveCampaign.
-
Access Live Azure Data Catalog Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Azure Data Catalog data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Getting Started with the CData Power BI Connector for Oracle Sales
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Oracle Sales.
-
Access Live Amazon Athena 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 Amazon Athena data through MCP integration.
-
Validate Sage Intacct Data with QuerySurge
Access and validate Sage Intacct data in QuerySurge using the CData JDBC Driver.
-
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.
-
Integrate Live Bright Data Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Bright Data from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Bright Data data.
-
Integrating Codex with Active Directory 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 Google Spanner Data in Ruby
Connect to Google Spanner data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
SageHR Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to SageHR data through CData Connect AI using different applications and tools.
-
DataBind Controls to Cloudflare Data in Delphi
DataBind to Cloudflare data in Delphi with standard data access components and controls.
-
Creating Azure DevOps-Connected Applications in Unqork
You can use CData Connect AI to feed Azure DevOps data to Unqork and build custom business apps.
-
Integrating Kiro with WooCommerce 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.
-
Automate Guru Data Replication to Azure Synapse
Use CData Sync to customize and automate Guru data replication to Azure Synapse.
-
LINQ to Dynamics NAV 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 Dynamics NAV Data Provider.
-
Interact with Live Zoho Creator Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Zoho Creator data.
-
Build Dashboards with Calendly Data in Dundas BI
Create dynamic dashboards and perform analytics based on Calendly data in Dundas BI.
-
Integrating Cursor with WooCommerce 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.
-
Model, Search, and Visualize Live SAP HANA Data in ThoughtSpot
Use CData Connect AI to connect to live SAP HANA data for modeling, searching, and visualizing.
-
Integrate Monday.com with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Monday.com with External Services.
-
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.
-
Connect to Kintone Data in CloverDX (formerly CloverETL)
Transfer Kintone data using the visual workflow in the CloverDX data integration tool.
-
Replicate Coinbase Data to Multiple Databases
Replicate Coinbase data to disparate databases with a point-and-click configuration.
-
A PostgreSQL Interface for Jira Assets Data using the CData ODBC Driver
Use the SQL Gateway and Jira Assets ODBC Driver to create a PostgreSQL entry-point for data access.
-
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.
-
Build SAP Hybris C4C-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live SAP Hybris C4C data.
-
Establish a Live Connection with Adobe Experience Manager Data using Tableau Bridge
The CData ODBC Driver for Adobe Experience Manager enables you to integrate live Adobe Experience Manager data into Tableau Cloud dashboards using the Tableau Bridge.
-
Analyze SAP SuccessFactors LMS Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SAP SuccessFactors LMS from Power Pivot. You will use the Table Import Wizard to load SAP SuccessFactors LMS data. You can visually build the import query or use any SQL supported by the driver.
-
Automated Continuous Demio Replication to Snowflake
Use CData Sync for automated, continuous, customizable Demio replication to Snowflake.
-
How to Visualize Freshdesk 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 Freshdesk data in Python.
-
Integrating Antigravity CLI with Timely data via CData CLI
Connect Timely data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automated Continuous ClickTime Replication to SingleStore
Use CData Sync for automated, continuous, customizable ClickTime replication to SingleStore.
-
Connecting Moonlit Workflow with Asana 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 Asana data in real time.
-
Integrating GetResponse Data in Talend Cloud Data Management Platform
Connect GetResponse Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Create SingleStore-Connected Business Apps in AppSheet
Connect to SingleStore Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to SingleStore data.
-
Connect to Instantly Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Instantly data in the Denodo Virtual DataPort Administrator.
-
How to load Optimizely data into Elasticsearch via Logstash
Introducing a simple method to load Optimizely data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Adobe Commerce Data from Crystal Reports
Use CData Connect AI to connect to and report on live Adobe Commerce data from Crystal Reports.
-
Excel Spreadsheet Automation on Airtable Data with the QUERY Formula
Pull data from Airtable, automate spreadsheets, and more with the QUERY formula.
-
Create Dynamic SAP Fieldglass Grids Using the Infragistics XamDataGrid
Learn how you can connect SAP Fieldglass to Infragistics XamDataGrid to build dynamic grids.
-
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.
-
Connect to Zoho Projects Data in Ruby
Connect to Zoho Projects data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Getting Started with the CData SSIS Components for Dynamics CRM
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Dynamics CRM.
-
Integrate Unbounce Data in the Pentaho Report Designer
Publish reports based on Unbounce data in the Pentaho BI tool.
-
Connect to and Visualize Live Quaderno Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Quaderno data.
-
Extract, Transform, and Load Square Data in Informatica PowerCenter
Create a simple Workflow for Square data in Informatica PowerCenter.
-
Use the CData Software JDBC Driver for TaxJar in MicroStrategy Desktop
Connect to TaxJar data in MicroStrategy Desktop using the CData Software JDBC Driver for TaxJar.
-
Build Zuora-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 Zuora data without replication.
-
Replicate Nuclia Data to Multiple Databases via the CData Sync CLI
Replicate Nuclia data to disparate databases with a single configuration.
-
Integrate SAP HANA XS Advanced Data in the Pentaho Report Designer
Publish reports based on SAP HANA XS Advanced data in the Pentaho BI tool.
-
Integrate with Toggl Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Toggl data in SnapLogic.
-
Create Datasets from PhantomBuster in Domo Workbench and Build Visualizations of PhantomBuster Data in Domo
Use the CData Software ODBC Driver for PhantomBuster to create datasets from PhantomBuster data in Domo Workbench and then build visualizations in the Domo service.
-
Integrate Redis Data into Power Automate Desktop using CData Connect
CData Connect for Redis Data enables you to integrate Redis data into workflows built using Microsoft Power Automate Desktop.
-
Back Up LinkedIn data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for LinkedIn. In this article, we will employ an SSIS workflow to populate a database with LinkedIn data data.
-
Model Wistia Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Wistia, enabling the direct import of real-time Wistia data.
-
Automated Continuous DB2 for i Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable DB2 for i replication to PostgreSQL.
-
Build Timely-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Timely data and build web apps with connectivity to live Timely data.
-
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.
-
Search External SageHR Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SageHR data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SageHR Data objects that you can access from apps and the dashboard.
-
Create Reports with ConstantContact Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ConstantContact data.
-
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.
-
Create Databricks-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Databricks Data from Klipfolio and build custom visualizations using live Databricks data.
-
Connect to Bitly Data in DBeaver
Use the CData ODBC Driver to connect to Bitly data in DBeaver.
-
Migrating data from Yelp to Snowflake using CData SSIS Components.
Easily push Yelp data to Snowflake using the CData SSIS Tasks for Yelp and Snowflake.
-
Model, Search, and Visualize Live GitHub Data in ThoughtSpot
Use CData Connect AI to connect to live GitHub data for modeling, searching, and visualizing.
-
Query Slack Data in DataGrip
Create a Data Source for Slack in DataGrip and use SQL to query live Slack data.
-
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 Adobe Commerce Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Adobe Commerce data.
-
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.
-
Deploy the ADO.NET Provider for Oracle Eloqua Reporting on an SSRS Report Server
Connect to Oracle Eloqua Reporting 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 Avalara AvaTax Data from a Connection Pool in Jetty
The Avalara AvaTax JDBC Driver supports connection pooling: This article shows how to connect faster to Avalara AvaTax data from Web apps in Jetty.
-
Query Live Discord 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 Discord data through a conversational interface.
-
Automated Continuous Clockify Replication to MySQL
Use CData Sync for automated, continuous, customizable Clockify replication to MySQL.
-
Use JayDeBeApi to access SAP Ariba Procurement Data in Python
Use standard Python scripting and the development environment of your choice to access live SAP Ariba Procurement data.
-
How to Work with TaxJar Data in ETL Validator JDBC
Connect to TaxJar from ETL Validator jobs using the CData Software JDBC Driver.
-
Build Visualizations of Exact Online Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Exact Online data in Birst.
-
How to Work with SingleStore Data in ETL Validator JDBC
Connect to SingleStore from ETL Validator jobs using the CData Software JDBC Driver.
-
How to create an RPA flow for Pipeline CRM Data in UiPath Studio
Use the Pipeline CRM ODBC Driver to create workflows that access real-time Pipeline CRM data without any coding.
-
Query RSS Feeds as a MySQL Database in Node.js
Execute MySQL queries against RSS feeds from Node.js.
-
Building Dynamic Web Pages with PayPal Data Using AngularJS
Create single-page applications with live connectivity to PayPal using the CData API Server.
-
How to Seamlessly Import Zoho Recruit Data into IBM SPSS Modeler
Integrate Zoho Recruit data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to PostgreSQL Data in HULFT Integrate
Connect to PostgreSQL as a JDBC data source in HULFT Integrate
-
Automated Continuous Postmark Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Postmark replication to AlloyDB.
-
Use the CData Software ODBC Driver for AlloyDB in SAS for Real-Time Reporting and Analytics
Connect to real-time AlloyDB data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for AlloyDB.