CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData SSIS Components for Zoho CRM
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Zoho CRM.
-
Getting Started with the CData Python Connector for Oracle
Learn to install and license the CData Python Connector and configure a connection to live Oracle data.
-
Connect to Hubstaff Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Hubstaff data.
-
Process & Analyze SageHR Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SageHR Data.
-
Model Salesforce Marketing Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Salesforce Marketing, enabling the direct import of real-time Salesforce Marketing data.
-
Import Power BI XMLA Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Power BI XMLA Data and provide access to live Power BI XMLA data for custom reports in the Power BI Service.
-
Connect to Adobe Commerce Data from HeidiSQL
Use CData Connect AI to connect to and query live Adobe Commerce data from HeidiSQL.
-
Work with YouTube Analytics Data in FoxPro
Load YouTube Analytics data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Access Exact Online 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 Exact Online data.
-
Integrate OpenCode with Live Mailgun Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Mailgun data from within your AI coding agent.
-
Build Dashboards with Eventbrite Data in Dundas BI
Create dynamic dashboards and perform analytics based on Eventbrite data in Dundas BI.
-
Build a PostgreSQL Interface for ZohoExpense Data using the CData JDBC Driver
Use the Remoting features of the ZohoExpense JDBC Driver to create a PostgreSQL entry-point for data access.
-
Configure the CData JDBC Driver for Vimeo in a Connection Pool in Tomcat
Connect to Vimeo data from a connection pool in Tomcat.
-
Access Live ZohoInvoice Data in Excel 365 Online (Excel for the web)
Connect to ZohoInvoice data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Build Visualizations of Zoho Recruit Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Zoho Recruit data in Birst.
-
Automated Continuous ZohoDesk Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ZohoDesk data replication to OneLake in Microsoft Fabric.
-
Visualize FormSite Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to FormSite data.
-
How to connect to Toggl Data with Squirrel SQL client
Connect to Toggl data and execute queries in the Squirrel SQL Client.
-
Automated Continuous EmailOctopus Replication to Snowflake
Use CData Sync for automated, continuous, customizable EmailOctopus replication to Snowflake.
-
Connect Codat to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Codat with IBM WebSphere for seamless data integration and connectivity.
-
How to Connect to Live Dynamics NAV Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Dynamics NAV data for you.
-
Automated Continuous SAP SuccessFactors Replication to SQLite
Use CData Sync for automated, continuous, customizable SAP SuccessFactors replication to SQLite.
-
How to connect to Oracle SCM Data with Squirrel SQL client
Connect to Oracle SCM data and execute queries in the Squirrel SQL Client.
-
A PostgreSQL Interface for Landbot Data using the CData ODBC Driver
Use the SQL Gateway and Landbot ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Dynamics CRM Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Dynamics CRM data.
-
Connect to Real-Time HDFS Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for HDFS and Dataflow to import and use HDFS data in Power Apps.
-
Create Smartsheet Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Smartsheet data access from reports, embedded analytics, and more.
-
Integrate Salesloft Data into Power Automate Desktop using CData Connect
CData Connect for Salesloft Data enables you to integrate Salesloft data into workflows built using Microsoft Power Automate Desktop.
-
How to Query Campaigner Data in MySQL Workbench
Execute MySQL queries against live Campaigner data from MySQL Workbench.
-
Connect to SAP Concur Data in Ruby
Connect to SAP Concur data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Replicate SQL Server Data to Multiple Databases via the CData Sync CLI
Replicate SQL Server data to disparate databases with a single configuration.
-
Integrate Live Reckon Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Reckon data to Blue Prism using the CData ODBC Driver for Reckon to create automated workflows for repetitive business tasks.
-
How to connect to Quaderno Data in DBVisualizer
Integrate Quaderno data with visual data analysis tools and data connection wizards in DBVisualizer
-
Feed ActiveCampaign Data into FineReport
How to set ActiveCampaign data as a JDBC data source in FineReport.
-
Natively Connect to Demio Data in PHP
The CData ODBC driver for Demio enables you to create PHP applications with connectivity to Demio data. Leverage the native support for ODBC in PHP.
-
How to Connect to Live BambooHR Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your BambooHR data for you.
-
Connect to ZarMoney Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to ZarMoney.
-
Replicate Multiple ZendeskSell Accounts via the CData Sync CLI
Replicate multiple ZendeskSell accounts to one or many databases.
-
How to Query Live LinkedIn Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live LinkedIn data data in natural language using Python.
-
Connect to Scrapfly Data in Ruby
Connect to Scrapfly data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Connect DBeaver to Salesforce Pardot via a JDBC Driver
Manage Salesforce Pardot data with visual tools in DBeaver like the query browser.
-
Automated Continuous Vimeo Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Vimeo replication to Amazon S3.
-
Connect to Real-Time Microsoft Exchange Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Microsoft Exchange and Dataflow to import and use Microsoft Exchange data in Power Apps.
-
DataBind Controls to SendGrid Data in C++Builder
DataBind to SendGrid data in C++Builder with standard components and controls.
-
How to Build an ETL App for Cloudant Data in Python with CData
Create ETL applications and real-time data pipelines for Cloudant data in Python with petl.
-
Integrating Boomi Agentstudio with Sage Cloud Accounting Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Sage Cloud Accounting data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to import SAP Data into Apache Solr
Use the CData Software JDBC Driver for SAP in Data Import Handler and create an automated import of SAP data to Apache Solr Enterprise Search platform.
-
Build MVC Applications with Connectivity to Excel Online Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Excel Online from an ASP.NET MVC application.
-
How to Connect to Live DB2 Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your DB2 data for you.
-
Connect to ShipEngine Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time ShipEngine data using standard SQL.
-
Getting Started with OAuth in CData Connectivity Solutions
Configuring OAuth with CData Connectivity Solutions for Desktop, Web Application and Headless Machines
-
Getting Started with the CData Excel Add-In for Redshift
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Redshift.
-
Access Live Reckon Accounts Hosted Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Reckon Accounts Hosted data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate CouchDB with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate CouchDB with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to CouchDB data.
-
Working with Close Data in LINQPad
Execute LINQ queries to Close data in LINQPad.
-
Migrating data from Microsoft Dataverse to Databricks using CData SSIS Components.
Easily push Microsoft Dataverse data to Databricks using the CData SSIS Tasks for Microsoft Dataverse and Databricks.
-
How to connect to Salesforce Pardot Data from IntelliJ
Integrate connectivity to Salesforce Pardot data with wizards in IntelliJ.
-
Integrating Cursor with LaunchDarkly 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.
-
Consume Azure Data Lake Storage OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Azure Data Lake Storage feeds that reflect any changes in SAP Lumira.
-
Explore Geographical Relationships in Sendwithus Data with Power Map
Create data visualizations with Sendwithus data in Power Map.
-
Edit and Search External Smartsheet Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Smartsheet data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Smartsheet Data objects that you can access from apps and the dashboard.
-
Migrating data from CapsuleCRM to Snowflake using CData SSIS Components.
Easily push CapsuleCRM data to Snowflake using the CData SSIS Tasks for CapsuleCRM and Snowflake.
-
Integrate Live Klaviyo Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Klaviyo from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Klaviyo data.
-
Build Data Flows from Tavily to SQL Server using SSIS
Easily back up Tavily data to SQL Server using the SSIS components for Tavily.
-
Use Biml to Build SSIS Tasks to Replicate Oracle SCM Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Oracle SCM data to SQL Server.
-
Use the CData Software JDBC Driver for PabblySubscriptions in MicroStrategy
Connect to PabblySubscriptions data in MicroStrategy Developer using the CData Software JDBC Driver for PabblySubscriptions.
-
Configure the CData JDBC Driver for Cosmos DB in a Connection Pool in Tomcat
Connect to Cosmos DB data from a connection pool in Tomcat.
-
Query Live Google Analytics 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 Google Analytics data directly from the development environment.
-
Publish Reports with Parallel Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Parallel data.
-
Visualize Live Exa Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Exa data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Getting Started with the CData SSIS Components for Teamwork
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Teamwork.
-
Build Wave Financial-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Wave Financial Data from Zoho Analytics and import live Wave Financial data.
-
Integrating SAS xpt Data in Talend Cloud Data Management Platform
Connect SAS xpt Data with Talend Cloud Data Management Platform using the CData JDBC Driver for SAS xpt.
-
Connect to Printify Data from a Connection Pool in Jetty
The Printify JDBC Driver supports connection pooling: This article shows how to connect faster to Printify data from Web apps in Jetty.
-
Build Visualizations of Monday.com Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Monday.com data in Birst.
-
Import Real-Time Microsoft Dataverse Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Microsoft Dataverse data in ColdFusion.
-
Integrate Facebook Ads Data in Pentaho Data Integration
Build ETL pipelines based on Facebook Ads data in the Pentaho Data Integration tool.
-
How to Connect to Live Oracle Sales Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Oracle Sales data for you.
-
Integrating Claude Code with SAS Data Sets Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on SAS Data Sets data within assisted coding and automated development workflows.
-
Establish a Live Connection with Shippo Data using Tableau Bridge
The CData ODBC Driver for Shippo enables you to integrate live Shippo data into Tableau Cloud dashboards using the Tableau Bridge.
-
Visualize Blackbaud FE NXT Data in TIBCO Spotfire through OData
Integrate Blackbaud FE NXT data into dashboards in TIBCO Spotfire.
-
Integrating Codex with Office 365 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.
-
Create Lakebase Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Lakebase data access from reports, embedded analytics, and more.
-
Build Apps with Live CapsuleCRM Data Using the Low-Code Development Platform of Mendix
Connect CapsuleCRM data with Mendix to build apps using the CData API Driver for JDBC.
-
Automated Continuous Stripe Replication to Oracle
Use CData Sync for automated, continuous, customizable Stripe replication to Oracle.
-
Use the CData Software ODBC Driver for Google Cloud Storage in MicroStrategy
Connect to Google Cloud Storage data in MicroStrategy Developer using the CData Software ODBC Driver for Google Cloud Storage.
-
Perform Batch Operations with Dynamics NAV Data in Apache NiFi
Connect to Dynamics NAV data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
How to connect SharePoint with SAP Fieldglass Data through external lists
Provide SAP Fieldglass data to SharePoint users as an external list.
-
Access Live Toggl 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 Toggl data through MCP integration.
-
A PostgreSQL Interface for Facebook Data (MySQL Remoting via JDBC)
Use the Remoting features of the Facebook JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Work with Amplitude Data in AWS Glue Jobs Using JDBC
Connect to Amplitude from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Google Campaign Manager 360 Data from AWS Glue
Use CData Connect AI to gain access to live Google Campaign Manager 360 data from your AWS Glue jobs.
-
Access Live Guru Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Guru data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrate Devin with Live Azure DevOps 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 Azure DevOps data.
-
Integrate with ScrapingBee Data in JReport Designer
Create charts and reports based on ScrapingBee data in JReport Designer.
-
Query, Visualize, and Share live Epicor Kinetic Data in Redash
Use CData Connect AI to connect to live Epicor Kinetic data in Redash for querying, visualizing, and sharing.
-
Visualize Cloudflare Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Cloudflare data.
-
How to connect and process Dynamics 365 Business Central data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Dynamics 365 Business Central data.
-
Import VWO Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to VWO Data and provide access to live VWO data for custom reports in the Power BI Service.
-
Connecting Agentforce with Campaigner Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Campaigner data for you.