CData Software - Knowledge Base
Recent Articles
-
Connect to Oracle Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Oracle to connect to Oracle Database and execute queries in PowerBuilder.
-
Connect and Query Live ADP Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live ADP into Databricks
-
Connect to Miro Data in Aqua Data Studio
Access Miro from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Outreach.io-Connected Apps in Choreo
Use CData Connect AI to connect to Outreach.io Data from Choreo and build custom apps using live Outreach.io.
-
Automated Continuous Slack Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Slack replication to Amazon S3.
-
Visualize FreeAgent Data in Tableau
The CData ODBC driver for FreeAgent enables you integrate FreeAgent into Tableau dashboards.
-
Moving Data from Gumroad to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Gumroad data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrating OpenCode Terminal with Box 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.
-
How to Easily Query Jodoo Data in OpenOffice Base
Connect to Jodoo data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Build Zoho Inventory-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Zoho Inventory.
-
Build AI/ML Models with Live ConvertAPI Data using Dataiku
Connect ConvertAPI Data with Dataiku using the CData API Driver for JDBC.
-
Deploy the ADO.NET Provider for iContact on an SSRS Report Server
Connect to iContact 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 SuccessFactors Data from a Connection Pool in JBoss
Integrate SAP SuccessFactors into Java servlets: Use the Management Console in JBoss to install the SAP SuccessFactors JDBC Driver.
-
Connect to and Query Splunk Data in QlikView over ODBC
Create data visualizations with Splunk in QlikView.
-
Import Real-Time CockroachDB Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use CockroachDB in ColdFusion.
-
Back Up Placid to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Placid data.
-
Automate Zoho Inventory Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Zoho Inventory from PowerShell? This article demonstrates how to utilize the Zoho Inventory Cmdlets for tasks like connecting to Zoho Inventory, automating operations, downloading data, and more.
-
Automated Continuous Dynamics 365 Business Central Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to IBM DB2.
-
Build Instagram-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Instagram and build Instagram-connected web apps with Axios.
-
Automate HelloSign Data Replication to SAP HANA
Use CData Sync to customize and automate HelloSign replication to SAP HANA.
-
Integrating Claude Code CLI with Adobe Analytics 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.
-
Stream Google Forms Data into Apache Kafka Topics
Access and stream Google Forms in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Write a Simple Go Application to work with EmailOctopus Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to EmailOctopus.
-
How to Import Data from Dynamics CRM into Google Sheets
Import Microsoft Dynamics CRM into a Google spreadsheet that is automatically refreshed.
-
Automate Factorial Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Factorial from PowerShell? This article demonstrates how to utilize the Factorial Cmdlets for tasks like connecting to Factorial, automating operations, downloading data, and more.
-
Migrating data from Recurly to Databricks using CData SSIS Components.
Easily push Recurly to Databricks using the CData SSIS Tasks for Recurly and Databricks.
-
Create Dropbox-Connected Nintex Workflows
Use CData Connect AI to connect to Dropbox Data from Nintex Workflow Cloud and build custom workflows using live Dropbox.
-
Use Dash to Build to Web Apps on JobNimbus Data
Create Python applications that use pandas and Dash to build JobNimbus-connected web apps.
-
Create Splunk-Connected Applications in Appsmith
Connect to Splunk Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Splunk.
-
How to Work with Microsoft Dataverse Data in ETL Validator JDBC
Connect to Microsoft Dataverse from ETL Validator jobs using the CData Software JDBC Driver.
-
How to integrate Metabase with Act-On Data
Use CData Connect AI to connect to live Act-On and create an interactive dashboard in Metabase from Act-On.
-
How to create Helpscout federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Helpscout in MySQL .
-
Integrate Oracle SCM Data into Power Automate Desktop using CData Connect
CData Connect for Oracle SCM Data enables you to integrate Oracle SCM into workflows built using Microsoft Power Automate Desktop.
-
How to Connect Office 365 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 Office 365 data in real time using natural language.
-
Connect to SAP SuccessFactors Data in HULFT Integrate
Connect to SAP SuccessFactors as a JDBC data source in HULFT Integrate
-
Use JayDeBeApi to access Demio Data in Python
Use standard Python scripting and the development environment of your choice to access live Demio.
-
How to work with SAP HANA XS Advanced Data in Apache Spark using SQL
Access and process SAP HANA XS Advanced Data in Apache Spark using the CData Software JDBC Driver.
-
Use the CData Software JDBC Driver for Salesforce Pardot in MicroStrategy
Connect to Salesforce Pardot in MicroStrategy Developer using the CData Software JDBC Driver for Salesforce Pardot.
-
Integrate Procore Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Procore and integrate live Procore into your Power Automate tasks.
-
Access Pinterest Data from MySQL in Amazon QuickSight
Connect to Pinterest and build visualizations of Pinterest using a MySQL Connection in Amazon QuickSight.
-
How to Connect DBeaver to Dynamics NAV via a JDBC Driver
Manage Microsoft Dynamics NAV with visual tools in DBeaver like the query browser.
-
Working with Freshsales Data in LINQPad
Execute LINQ queries to Freshsales in LINQPad.
-
How to Build an ETL App for Sendwithus Data in Python with CData
Create ETL applications and real-time data pipelines for Sendwithus in Python with petl.
-
Automated Continuous Microsoft Teams Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Microsoft Teams replication to Google Cloud SQL.
-
Integrating Kiro CLI with SuiteCRM 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 PayPal Data Replication to Couchbase
Use CData Sync to Customize and automate PayPal replication to Couchbase.
-
Integrate with SurveyMonkey Data in JReport Designer
Create charts and reports based on SurveyMonkey in JReport Designer.
-
Query OneNote Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Microsoft OneNote from Node.js.
-
Build Visualizations of Google Sheets Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Google Sheets in Birst.
-
Access Live Amazon DynamoDB 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 DynamoDB through MCP integration.
-
How to Build an ETL App for MySQL Data in Python with CData
Create ETL applications and real-time data pipelines for MySQL in Python with petl.
-
Work with Anaplan Data in FoxPro
Load Anaplan into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use the CData Software JDBC Driver for Power BI XMLA in MicroStrategy Desktop
Connect to Power BI XMLA in MicroStrategy Desktop using the CData Software JDBC Driver for Power BI XMLA.
-
Build Azure Analysis Services-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Azure Analysis Services to explore live Azure Analysis Services Data in Claude Code to assist with building Azure Analysis Services-powered applications.
-
Build Gmail-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Gmail to explore live Gmail Data in GitHub Copilot to assist with building Gmail-powered applications.
-
Access Onfleet Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Onfleet from HeidiSQL.
-
Automate xBase Data Replication to Couchbase
Use CData Sync to Customize and automate xBase replication to Couchbase.
-
Analyze Oracle HCM Cloud Data in Looker
Use CData Connect AI to connect to Oracle HCM Cloud Data from Looker and build custom apps using live Oracle HCM Cloud.
-
Connect to Xero Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Xero Data and connect to Xero Accounting in Akorbi Digital RunMyProcess.
-
Connect to SparkPost Data in Jaspersoft Studio
Execute SQL to remote SparkPost in Jaspersoft Studio.
-
Using the CData Software ODBC Driver for AdRoll in PyCharm
Connect to AdRoll as an ODBC data source in PyCharm using the CData Software ODBC Driver for AdRoll.
-
Visualize Harvest Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Harvest.
-
Automated Continuous Klipfolio Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Klipfolio replication to Apache Cassandra.
-
Integrate with ServiceDesk Plus Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ServiceDesk Plus to a JSON file on disk.
-
Integrate PolarTeamPro Data in Pentaho Data Integration
Build ETL pipelines based on PolarTeamPro in the Pentaho Data Integration tool.
-
LINQ to Reply.io 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 Reply.io Data Provider.
-
Use Manus AI to Talk to Your Vertica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Vertica.
-
Access Live MessageBird Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate MessageBird into the statistical analysis tools available in SAS JMP. This article shows how to use MessageBird in the Graph Builder and Query Builder.
-
Access Oracle SCM Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Oracle SCM from HeidiSQL.
-
Replicate Multiple Zoho Inventory Accounts via the CData Sync CLI
Replicate multiple Zoho Inventory accounts to one or many databases.
-
Feed JDBC-ODBC Bridge Data into FineReport
How to set JDBC-ODBC Bridge as a JDBC data source in FineReport.
-
How to Query Live Pipeline CRM Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Pipeline CRM data in natural language using Python.
-
How to Query Live SFTP Data in Perplexity MacOS Desktop
Connect to and query live SFTP Data in Perplexity Desktop using CData MCP Server.
-
How to Use a Microsoft Access Database to Update Paylocity Data in Real Time
Update Paylocity data by creating a linked table in Microsoft Access with the CData Paylocity ODBC Driver.
-
Explore Geographical Relationships in SAP BusinessObjects BI Data with Power Map
Create data visualizations with SAP BusinessObjects BI in Power Map.
-
Bidirectional Access to Amplitude Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Amplitude in Filemaker Pro for Mac or Windows.
-
Build MVC Applications with Connectivity to BigQuery Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access BigQuery from an ASP.NET MVC application.
-
Analyze Microsoft Dataverse Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Microsoft Dataverse (CDS) and visualize live Microsoft Dataverse (CDS) in Infragistics Reveal.
-
Design BIRT Reports on Salesforce Data
Provide current Salesforce & Force.com to your embedded analytics.
-
Build Apps with Live Zuora Data Using the Low-Code Development Platform of Mendix
Connect Zuora with Mendix to build apps using the CData JDBC Driver for Zuora.
-
Automated Continuous Codat Replication to SQLite
Use CData Sync for automated, continuous, customizable Codat replication to SQLite.
-
How to connect to Avro Data from Spring Boot
Connect to Avro in a Spring Boot Application using the CData JDBC Driver for Avro
-
How to Access FTP Data Using Entity Framework
This article shows how to access FTP Servers using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Moving Data from Keap to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Keap data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Access Live Accelo Data in AWS Lambda
Connect to live Accelo in AWS Lambda using the CData JDBC Driver.
-
Visualize GitHub Data in Tableau
The CData ODBC driver for GitHub enables you integrate GitHub into Tableau dashboards.
-
How to Work with Zoho Creator Data in AWS Glue Jobs Using JDBC
Connect to Zoho Creator from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Migrating data from Mode to Snowflake using CData SSIS Components.
Easily push Mode to Snowflake using the CData SSIS Tasks for Mode and Snowflake.
-
Write a Simple Go Application to work with GraphQL Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to GraphQL.
-
Create Reports from HBase Data in Looker Studio
Use CData Connect AI to gain access to live Apache HBase and create custom reports in Looker Studio.
-
Integrate Live Raisers Edge NXT Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Raisers Edge NXT to Blue Prism using the CData ODBC Driver for Raisers Edge NXT to create automated workflows for repetitive business tasks.
-
Operational Reporting on Google Analytics Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Google Analytics.
-
Publish Reports with Wistia Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Wistia.
-
Integrating Monday.com Data in Talend Cloud Data Management Platform
Connect Monday.com Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Monday.com.
-
Working with Databricks Data in LINQPad
Execute LINQ queries to Databricks in LINQPad.
-
Connect to SAP Ariba Source Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SAP Ariba Source in the Denodo Virtual DataPort Administrator.
-
Use the CData Software ODBC Driver for Factorial in MicroStrategy
Connect to Factorial in MicroStrategy Developer using the CData Software ODBC Driver for Factorial.
-
Rapidly Develop Lakebase-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Lakebase.
-
Connect to Live HBase Data in MicroStrategy through CData Connect AI
Create a live connection to HBase Data in CData Connect AI and connect to your Apache HBase from MicroStrategy.
-
Automated Continuous Autopilot Replication to MongoDB
Use CData Sync for automated, continuous, customizable Autopilot replication to MongoDB.