CData Software - Knowledge Base
Recent Articles
-
Replicate Mouseflow Data to Multiple Databases
Replicate Mouseflow to disparate databases with a point-and-click configuration.
-
How to work with PhantomBuster Data in Apache Spark using SQL
Access and process PhantomBuster Data in Apache Spark using the CData Software JDBC Driver.
-
Automated Continuous Pipedrive Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Pipedrive replication to Apache Kafka.
-
Connecting Moonlit Workflow with Office 365 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 Microsoft Office 365 in real time.
-
Build Pipelines with Live LinkedIn Ads Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to LinkedIn Ads from Google Cloud Data Fusion, enabling the integration of live LinkedIn Ads into the building and management of effective data pipelines.
-
ETL SendPulse in Oracle Data Integrator
This article shows how to transfer SendPulse into a data warehouse using Oracle Data Integrator.
-
How to connect PolyBase to SparkPost
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SparkPost.
-
How to Connect to SQL Analysis Services Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SQL Analysis Services. Leverage the pyodbc module for ODBC in Python.
-
ETL Brex in Oracle Data Integrator
This article shows how to transfer Brex into a data warehouse using Oracle Data Integrator.
-
LINQ to SFTP 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 SFTP Data Provider.
-
Replicate Qualaroo Data from PowerShell
Write a quick PowerShell script to query Qualaroo. Use connectivity to the live data to replicate Qualaroo to SQL Server.
-
Import and Visualize Zoho CRM Data in Power View
Create data visualizations based on Zoho CRM in Excel.
-
Deploy the ADO.NET Provider for HCL Domino on an SSRS Report Server
Connect to HCL Domino 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.
-
A PostgreSQL Interface for Salesloft Data using the CData ODBC Driver
Use the SQL Gateway and Salesloft ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate CockroachDB with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate CockroachDB with External Services.
-
Connect to Asana Data from PowerBuilder via JDBC
This article demonstrates how to access Asana from PowerBuilder using the Asana JDBC Driver.
-
DataBind Suadeo Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Suadeo with the DevExpress Windows Forms and Web controls to provide Suadeo to a chart.
-
Use Grok to Talk to Your Act CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Act CRM for you.
-
How to Create Power BI Visual Reports with Real-Time Microsoft Dataverse Data
Use CData Power BI Connectors to visualize Microsoft Dataverse (CDS) in Power BI.
-
Analyze Presto Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Presto in Microsoft R Open.
-
A PostgreSQL Interface for Gorgias Data (MySQL Remoting via JDBC)
Use the Remoting features of the Gorgias JDBC Driver to create a PostgreSQL entry-point for data access.
-
Query Dropbox Data as a MySQL Database in Node.js
Execute MySQL queries against Dropbox from Node.js.
-
Integrate Cline with Live Neo4J Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Neo4J from within your IDE.
-
Publish Auth0-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Auth0.
-
Connect to Foursquare Data in DBeaver
Use the CData ODBC Driver to connect to Foursquare in DBeaver.
-
How to Connect to Live SAP Ariba Procurement 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 SAP Ariba Procurement for you.
-
Access FreeAgent Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live FreeAgent from HeidiSQL.
-
How to Connect to & Open ZohoPeople Data in Microsoft Excel
This article uses the CData ODBC driver for ZohoPeople to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create Informatica Mappings From/To an ODBC Data Source for Jodoo
Create an ODBC connection to Jodoo in Informatica and browse and transfer Jodoo.
-
Connect to Todoist from a Connection Pool in WebLogic
Use the CData JDBC Driver for Todoist to connect to Todoist from Web applications running on WebLogic.
-
Use the CData API Server to Access Google Drive Data in Microsoft PowerPivot
Use the CData API Server to connect to live Google Drive in the Power Pivot business intelligence tool.
-
Visualize SuiteCRM Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SuiteCRM.
-
Integrating LangChain with AlloyDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Google AlloyDB within automated workflows.
-
Visualize ZendeskSell Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to ZendeskSell.
-
How to Connect to & Open Placid Data in Microsoft Excel
This article uses the CData ODBC driver for Placid to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate Live Adobe Analytics Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Adobe Analytics and integrate live Adobe Analytics into apps built in Microsoft Power Apps.
-
Access HubSpot 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 HubSpot.
-
How to Connect Oracle Eloqua 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 Oracle Eloqua data in real time using natural language.
-
Connect to Sybase Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Sybase as an External Source in Dremio.
-
Integrate with Microsoft OneDrive Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Microsoft OneDrive to a JSON file on disk.
-
Clio Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Clio facts in real time.
-
Create Power BI Reports on Real-Time Oracle Eloqua Data
Use the CData ODBC Driver for Oracle Eloqua to visualize Oracle Eloqua in Power BI Desktop.
-
Access Wrike 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 Wrike.
-
Automated Continuous Smartsheet Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Smartsheet replication to Amazon Redshift.
-
Build Semantic Layer Views for FHIR Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for FHIR.
-
Integrating GitHub Copilot CLI with Microsoft Dynamics NAV 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.
-
Access MariaDB Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access MariaDB from your Oracle system.
-
Create Datasets from Gumroad in Domo Workbench and Build Visualizations of Gumroad Data in Domo
Use the CData Software ODBC Driver for Gumroad to create datasets from Gumroad in Domo Workbench and then build visualizations in the Domo service.
-
Replicate YouTube Analytics Data in Heroku for Use in Salesforce Connect
Replicate YouTube Analytics to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
ETL Zoho Inventory in Oracle Data Integrator
This article shows how to transfer Zoho Inventory into a data warehouse using Oracle Data Integrator.
-
Connect to SharePoint Data in ACL Analytics
Connect to Microsoft SharePoint via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Microsoft SharePoint.
-
How to connect and process ChargeOver from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live ChargeOver.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Adobe Target
Provide connectivity to Adobe Target through an SAP BusinessObjects universe.
-
Automated Continuous Aweber Replication to SQLite
Use CData Sync for automated, continuous, customizable Aweber replication to SQLite.
-
Connect Bitbucket to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Bitbucket using the CData Python MCP Server.
-
Build Oracle Eloqua-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Oracle Eloqua and build web apps with connectivity to live Oracle Eloqua.
-
Create Reports from Sage 200 Data in Looker Studio
Use CData Connect AI to gain access to live Sage 200 and create custom reports in Looker Studio.
-
Process & Analyze MYOB AccountRight Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live MYOB AccountRight Data.
-
Configure the CData JDBC Driver for ChargeOver in a Connection Pool in Tomcat
Connect to ChargeOver from a connection pool in Tomcat.
-
Build Presto-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Presto Data from Zoho Analytics and import live Presto.
-
Object-Relational Mapping (ORM) with Jira 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 Atlassian Jira into a Java-based ORM framework, Hibernate.
-
Connect to Jodoo Data in Jaspersoft Studio
Execute SQL to remote Jodoo in Jaspersoft Studio.
-
Using the CData Software ODBC Driver for SQL Analysis Services in PyCharm
Connect to SQL Analysis Services as an ODBC data source in PyCharm using the CData Software ODBC Driver for SQL Analysis Services.
-
DataBind Charts to Box Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Box 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.
-
Use ChatGPT to Talk to Your Kintone Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Kintone for you.
-
Use Biml to Build SSIS Tasks to Replicate Dynamics NAV Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Microsoft Dynamics NAV to SQL Server.
-
Connect to Zoho CRM Data in JRuby
Create a simple JRuby app with access to live Zoho CRM.
-
Use Microsoft Copilot Studio to talk to your Salesforce 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 Salesforce & Force.com for you.
-
Automated Continuous Google Sheets Replication to SQLite
Use CData Sync for automated, continuous, customizable Google Sheets replication to SQLite.
-
Connect to Quaderno Data in DBeaver
Use the CData ODBC Driver to connect to Quaderno in DBeaver.
-
Integrating Cursor CLI with Pipeline CRM 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 the CData Software ODBC Driver for Pinterest in SAS for Real-Time Reporting and Analytics
Connect to real-time Pinterest in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Pinterest.
-
Integrate Live Outreach.io Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Outreach.io and integrate live Outreach.io into apps built in Microsoft Power Apps.
-
Feed Exact Online Data into FineReport
How to set Exact Online as a JDBC data source in FineReport.
-
How to Build an ETL App for Google Contacts Data in Python with CData
Create ETL applications and real-time data pipelines for Google Contacts in Python with petl.
-
Getting Started with the CData ADO.NET Provider for Clio
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Publish Reports with IBM Informix Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date IBM Informix.
-
DataBind Controls to Billsby Data in Delphi
DataBind to Billsby in Delphi with standard data access components and controls.
-
How to Connect to & Open Freshsales Data in Microsoft Excel
This article uses the CData ODBC driver for Freshsales to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Build an ETL App for Omnisend Data in Python with CData
Create ETL applications and real-time data pipelines for Omnisend in Python with petl.
-
Access Elorus Data from MySQL in Amazon QuickSight
Connect to Elorus and build visualizations of Elorus using a MySQL Connection in Amazon QuickSight.
-
Integrating Claude Code CLI with MailerSend 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.
-
Bind Live SAP BusinessObjects BI Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SAP BusinessObjects BI data
-
Working with Suadeo Data in LINQPad
Execute LINQ queries to Suadeo in LINQPad.
-
Automated Continuous Shippo Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Shippo replication to Apache Cassandra.
-
Edit and Search External API Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of API to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create API Data objects that you can access from apps and the dashboard.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for DB2
Provide connectivity to IBM DB2 through an SAP BusinessObjects universe.
-
Connect to Real-Time PolarTeamPro Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use PolarTeamPro in Power Apps.
-
Query ElevenLabs Data in ColdFusion
Write standard ColdFusion data access code to connect to ElevenLabs.
-
Integrate Live Bullhorn CRM Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Bullhorn CRM from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Bullhorn CRM.
-
Use the CData Software JDBC Driver for Shortcut in MicroStrategy
Connect to Shortcut in MicroStrategy Developer using the CData Software JDBC Driver for Shortcut.
-
Integrating Kiro CLI with Auth0 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 Codex CLI with CloudConvert 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 ZohoExpense Data in DBArtisan
Use wizards in DBArtisan to configure ZohoExpense as a data source.
-
How to Access Live MailerLite Data in Power Automate Desktop via ODBC
The CData ODBC Driver for MailerLite enables you to integrate MailerLite into workflows built using Microsoft Power Automate Desktop.
-
Build a Simple VCL Application for Amazon Marketplace Data
How to build a simple VCL Application to view Amazon Marketplace in RAD Studio using the CData ODBC Driver for Amazon Marketplace.
-
Integrate Theia IDE with Live Greenplum Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Visualize Salesforce Pardot Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Salesforce Pardot.
-
Getting Started with the CData Excel Add-In for Zoho Books
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Zoho Books.
-
Build Blackbaud FE NXT-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Blackbaud FE NXT to explore live Blackbaud FE NXT Data in GitHub Copilot to assist with building Blackbaud FE NXT-powered applications.