CData Software - Knowledge Base
Recent Articles
-
Build Voice Agents in ElevenLabs with access to Live Sage Intacct Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Sage Intacct.
-
Automated Continuous SAP ByDesign Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SAP ByDesign replication to Apache Cassandra.
-
Getting Started with the CData SSIS Components for Workday
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Workday.
-
Integrate Live CSV Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Import Real-Time Sage 300 Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Sage 300 in ColdFusion.
-
Bidirectional Access to Azure Data Lake Storage Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Azure Data Lake Storage in Filemaker Pro for Mac or Windows.
-
Integrate with Tanda Data in JReport Designer
Create charts and reports based on Tanda in JReport Designer.
-
Integrate Live Teamwork Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Teamwork to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to Sendwithus from a Connection Pool in WebLogic
Use the CData JDBC Driver for Sendwithus to connect to Sendwithus from Web applications running on WebLogic.
-
ETL LightSpeedRetail in Oracle Data Integrator
This article shows how to transfer LightSpeedRetail into a data warehouse using Oracle Data Integrator.
-
Analyze SurveyMonkey Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of SurveyMonkey and visualize live SurveyMonkey in Infragistics Reveal.
-
Automated Continuous MySQL Replication to IBM DB2
Use CData Sync for automated, continuous, customizable MySQL replication to IBM DB2.
-
Extract, Transform, and Load Google Tasks Data in Informatica PowerCenter
Create a simple Workflow for Google Tasks in Informatica PowerCenter.
-
Excel Spreadsheet Automation on Zoho Projects Data with the QUERY Formula
Pull data from Zoho Projects, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous MYOB AccountRight Replication to Vertica
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to Vertica.
-
Build Visualizations of ConvertKit Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ConvertKit in Birst.
-
How to publish and share PingOne Data dashboards with Tableau Server
The CData ODBC driver for PingOne enables you integrate PingOne into Tableau dashboards.
-
Automated Continuous JotForm Replication to IBM DB2
Use CData Sync for automated, continuous, customizable JotForm replication to IBM DB2.
-
Automated Continuous Notion Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Notion replication to Amazon S3.
-
Build Charts with OData Services in Clear Analytics
Create dynamic charts and perform analytics based on OData in Clear Analytics.
-
How to Query Live Certinia Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Certinia data in natural language using Python.
-
Integrate Workable with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Workable with External Services.
-
Connect to Printful Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Printful and the SQL Gateway to access Printful from Google Apps Script.
-
Visualize Oracle Eloqua 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 Oracle Eloqua into TIBCO Spotfire.
-
Connect to Shopify Data in CloverDX (formerly CloverETL)
Transfer Shopify using the visual workflow in the CloverDX data integration tool.
-
Add Oracle Service Cloud Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Oracle Service Cloud with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Connect SAP Netweaver Gateway 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 SAP Netweaver Gateway data in real time using natural language.
-
Integrating LangGraph with Azure Synapse Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Azure Synapse within automated workflows.
-
Create Apps from Klaviyo Data in Qlik Sense Cloud
Use CData Connect AI to connect to Klaviyo Data and build apps from live Klaviyo in Qlik Sense Cloud.
-
Build PostgreSQL-Connected Apps in Choreo
Use CData Connect AI to connect to PostgreSQL Data from Choreo and build custom apps using live PostgreSQL.
-
Perform Batch Operations with Kafka Data in Apache NiFi
Connect to Apache Kafka and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Connect to Act-On Data in Claris FileMaker Pro
Use the CData ODBC Driver for Act-On in FileMaker Pro to connect to Act-On and work with Act-On in your FileMaker applications.
-
Connect to Real-Time Vimeo Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Vimeo in Power Apps.
-
Create Zuora-Connected Business Apps in AppSheet
Connect to Zuora Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Zuora.
-
Rapidly Develop Google Directory-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 Google Directory.
-
Work with Bullhorn CRM Data in FoxPro
Load Bullhorn CRM into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use the CData Software ODBC Driver for WooCommerce in SAS for Real-Time Reporting and Analytics
Connect to real-time WooCommerce in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for WooCommerce.
-
Dotmailer Reporting in OBIEE with the Dotmailer JDBC Driver
Deploy the Dotmailer JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrate Procore Data into Power Automate Desktop using CData Connect
CData Connect for Procore Data enables you to integrate Procore into workflows built using Microsoft Power Automate Desktop.
-
Integrating Microsoft OneDrive Data in Talend Cloud Data Management Platform
Connect Microsoft OneDrive Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Microsoft OneDrive.
-
How to Work with Monday.com Data in ETL Validator JDBC
Connect to Monday.com from ETL Validator jobs using the CData Software JDBC Driver.
-
Create Reports with Bitly Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Bitly.
-
Connect to Workday from a Connection Pool in WebLogic
Use the CData JDBC Driver for Workday to connect to Workday from Web applications running on WebLogic.
-
Google Ad Manager Reporting in OBIEE with the Google Ad Manager JDBC Driver
Deploy the Google Ad Manager JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Extract, Transform, and Load SAS Data Sets Data in Informatica PowerCenter
Create a simple Workflow for SAS Data Sets in Informatica PowerCenter.
-
Create Reports with SendPulse Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SendPulse.
-
DataBind Controls to Anaplan Data in Delphi
DataBind to Anaplan in Delphi with standard data access components and controls.
-
How to connect PolyBase to TigerGraph
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live TigerGraph.
-
Automated Continuous Aha! Replication to SQL Server
Use CData Sync for automated, continuous, customizable Aha! replication to SQL Server.
-
Integrate with SAS Data Sets Data in SnapLogic
Use CData Connect AI to connect to and integrate with live SAS Data Sets in SnapLogic.
-
Connect to Live Greenhouse Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Greenhouse in CData Connect AI and connect to your Greenhouse from PostgreSQL.
-
How to Access Live Greenhouse Data in Visual Studio Code via Cline
Run CData MCP Server for Greenhouse on Windows Subsytem for Linux (WSL) and connect to live Greenhouse from the Cline extension in Visual Studio Code.
-
Work with ZohoSubscriptions Data in FoxPro
Load ZohoSubscriptions into a FoxPro database. This article includes full code and a walk-through of the process.
-
SAP ByDesign Reporting in OBIEE with the SAP ByDesign JDBC Driver
Deploy the SAP ByDesign JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Webflow Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to Sage 300 Data in RapidMiner
Integrate Sage 300 with standard components and data source configuration wizards in RapidMiner Studio.
-
Publish Reports with SAP Concur Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP Concur.
-
Connecting Moonlit Workflow with Bullhorn CRM 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 Bullhorn CRM in real time.
-
How to Build an ETL App for Templated Data in Python with CData
Create ETL applications and real-time data pipelines for Templated in Python with petl.
-
Connect to Lakebase Data in DBArtisan
Use wizards in DBArtisan to configure Lakebase as a data source.
-
Access Live ZohoMarketingHub Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate ZohoMarketingHub into the statistical analysis tools available in SAS JMP. This article shows how to use ZohoMarketingHub in the Graph Builder and Query Builder.
-
Use Claude to Talk to Your Airtable 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 Airtable for you.
-
How to use SQLAlchemy ORM to access Qualaroo Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Qualaroo.
-
Access Parquet Data from MySQL in Amazon QuickSight
Connect to Parquet and build visualizations of Apache Parquet using a MySQL Connection in Amazon QuickSight.
-
Integrate Goose with Live SAP HANA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live SAP HANA from within the local AI agent.
-
Extract, Transform, and Load SAP Concur Data in Informatica PowerCenter
Create a simple Workflow for SAP Concur in Informatica PowerCenter.
-
Connect to SpaceX Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Integrate Planio Data in Pentaho Data Integration
Build ETL pipelines based on Planio in the Pentaho Data Integration tool.
-
Publish XML-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live XML Files.
-
DataBind Guru Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Guru to a chart.
-
Visualize LinkedIn Ads Data in TIBCO Spotfire through ADO.NET
Integrate LinkedIn Ads into dashboards in TIBCO Spotfire.
-
How to Easily Query Clio Data in OpenOffice Base
Connect to Clio data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Getting Started with the CData ADO.NET Provider for Google Directory
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Google Directory.
-
Create a Data Access Object for RSS Feeds using JDBI
A brief overview of creating a SQL Object API for RSS Feeds in JDBI.
-
Build AI/ML Models with Live Figshare Data using Dataiku
Connect Figshare Data with Dataiku using the CData API Driver for JDBC.
-
How to connect and process Apache Spark SQL from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Apache Spark SQL.
-
How to load Salesloft data into Elasticsearch via Logstash
Introducing a simple method to load Salesloft data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Analyze NetSuite SuiteAnalytics Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of NetSuite SuiteAnalytics and visualize NetSuite SuiteAnalytics in SAP Analytics Cloud.
-
Build a Singer.io Tap for Todoist With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Todoist data using
-
Access Live Clockify Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Clockify in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Access Twitter Ads Data Using Entity Framework
This article shows how to access Twitter Ads using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Create Dynamic Oracle Financials Cloud Grids Using the Infragistics XamDataGrid
Learn how you can connect Oracle Financials Cloud to Infragistics XamDataGrid to build dynamic grids.
-
Use Claude to Talk to Your HCL Domino 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 HCL Domino for you.
-
Access Live Accelo Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Accelo in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Validate Microsoft Planner Data with QuerySurge
Access and validate Microsoft Planner in QuerySurge using the CData JDBC Driver.
-
Connect to Foursquare from a Connection Pool in WebLogic
Use the CData JDBC Driver for Foursquare to connect to Foursquare from Web applications running on WebLogic.
-
Connect to Stripe Data in DBeaver
Use the CData ODBC Driver to connect to Stripe in DBeaver.
-
Integrate Real-Time Access to Bullhorn CRM in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Bullhorn CRM in real time.
-
Getting Started with the CData ADO.NET Provider for HCL Domino
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for HCL Domino.
-
Getting Started with the CData Tableau Connector for TigerGraph
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for TigerGraph.
-
Load SQL Server Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft SQL Server to a database.
-
Build Airtable-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Airtable Data from Zoho Analytics and import live Airtable.
-
Build MVC Applications with Connectivity to FHIR Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access FHIR from an ASP.NET MVC application.
-
Automated Continuous ShipEngine Replication to AlloyDB
Use CData Sync for automated, continuous, customizable ShipEngine replication to AlloyDB.
-
Build Dashboards with Bright Data Data in Dundas BI
Create dynamic dashboards and perform analytics based on Bright Data in Dundas BI.
-
Automated Continuous Oracle HCM Cloud Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to OneLake in Microsoft Fabric.
-
Integrating Claude Code CLI 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.
-
Access SAP Concur Data from MySQL in PHP
Connect to SAP Concur through the standard MySQL libraries in PHP.
-
Build Wistia-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Wistia and build web apps with connectivity to live Wistia.
-
Rapidly Develop Reckon-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 Reckon.