CData Software - Knowledge Base
Recent Articles
-
Connect to Live Certinia Data in MicroStrategy through CData Connect AI
Create a live connection to Certinia Data in CData Connect AI and connect to your Certinia from MicroStrategy.
-
Connect to Nethunt Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Nethunt.
-
How to publish and share Sage Cloud Accounting Data dashboards with Tableau Server
The CData ODBC driver for Sage Cloud Accounting enables you integrate Sage Business Cloud Accounting into Tableau dashboards.
-
Automate Quaderno Data Replication to Azure Synapse
Use CData Sync to customize and automate Quaderno replication to Azure Synapse.
-
Add SAP Concur Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SAP Concur with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use Microsoft Copilot Studio to talk to your WordPress 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 WordPress for you.
-
Automate Datadog Data Replication to SAP HANA
Use CData Sync to customize and automate Datadog replication to SAP HANA.
-
Publish Crystal Reports on Nethunt Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Nethunt.
-
Replicate Multiple Certinia Accounts via the CData Sync CLI
Replicate multiple Certinia accounts to one or many databases.
-
Work with ConvertKit Data in FoxPro
Load ConvertKit into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to ChartMogul Data from PowerBuilder via JDBC
This article demonstrates how to access ChartMogul from PowerBuilder using the ChartMogul JDBC Driver.
-
Connect to SAP Ariba Procurement Data in CloverDX (formerly CloverETL)
Transfer SAP Ariba Procurement using the visual workflow in the CloverDX data integration tool.
-
Create Front Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Front from PowerBI.com to create Power BI Dataflows with real-time data.
-
A PostgreSQL Interface for Workday Data (MySQL Remoting via JDBC)
Use the Remoting features of the Workday JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Paddle
Provide connectivity to Paddle through an SAP BusinessObjects universe.
-
LINQ to FreshBooks 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 FreshBooks Data Provider.
-
How to integrate Teamgate with Apache Airflow
Access and process Teamgate in Apache Airflow using the CData JDBC Driver.
-
How to Connect eBay 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 eBay data in real time using natural language.
-
Create Informatica Mappings From/To a JDBC Data Source for MySQL
Create MySQL data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to HCL Domino from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from HCL Domino, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Integrate with SAP SuccessFactors Data in SnapLogic
Use CData Connect AI to connect to and integrate with live SAP SuccessFactors in SnapLogic.
-
Connecting Mastra with SAP SuccessFactors LMS Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time SAP SuccessFactors LMS, no replication required.
-
Connect to Hive Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Hive to connect to Apache Hive and execute queries in PowerBuilder.
-
Connect to NASA Data in NetBeans
Connect to NASA in NetBeans with the data source configuration wizard.
-
Build Visualizations of Sentry Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Sentry in Birst.
-
Publish Google Sheets-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Google Sheets.
-
Automated Continuous Zoho Inventory Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Zoho Inventory replication to Google BigQuery.
-
How to Query Live SingleStore Data in Claude Desktop
Connect to and query live SingleStore Data in Claude Desktop using CData MCP Server.
-
Analyze Mailgun Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Mailgun with the CData JDBC Driver for Mailgun.
-
Integrate with Harvest Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Harvest to a JSON file on disk.
-
Automated Continuous IBM Cloud Object Storage Replication to SQLite
Use CData Sync for automated, continuous, customizable IBM Cloud Object Storage replication to SQLite.
-
Extract, Transform, and Load SAP Business One Data in Informatica PowerCenter
Create a simple Workflow for SAP Business One in Informatica PowerCenter.
-
Access Pinecone Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Pinecone from your Oracle system.
-
Build Authorize.Net-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Authorize.Net Data and create custom apps in Bubble.
-
Connect to and Query NASA Data in QlikView over ODBC
Create data visualizations with NASA in QlikView.
-
Create Datasets from Amazon Marketplace in Domo Workbench and Build Visualizations of Amazon Marketplace Data in Domo
Use the CData Software ODBC Driver for Amazon Marketplace to create datasets from Amazon Marketplace in Domo Workbench and then build visualizations in the Domo service.
-
Getting Started with the CData Tableau Connector for Guru
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
DataBind CouchDB Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for CouchDB with the DevExpress Windows Forms and Web controls to provide Apache CouchDB to a chart.
-
Build an OLAP Cube in SSAS from Sentry Data
Establish a connection to Sentry data from SQL Server Analysis Services, and use the Sentry Data Provider to build OLAP cubes for use in analytics and reporting.
-
Getting Started with the CData Tableau Connector for BenchmarkEmail
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Integrating Kiro CLI with ActiveCampaign 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 Cloudflare Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Cloudflare.
-
Integrate Live Chargebee Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Chargebee to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Design BIRT Reports on Pipedrive Data
Provide current Pipedrive to your embedded analytics.
-
Natively Connect to Teradata Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Teradata. Leverage the native support for ODBC in PHP.
-
Automated Typeform Data Replication to Teradata
Use CData Sync to Customize and automate Typeform replication to Teradata.
-
Replicate Multiple Microsoft Dataverse Accounts via the CData Sync CLI
Replicate multiple Microsoft Dataverse accounts to one or many databases.
-
Connect to Mailjet Data from PowerBuilder via ADO.NET
This article demonstrates how to access Mailjet from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Build Office 365-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Microsoft Office 365.
-
How to integrate Hive with Apache Airflow
Access and process Apache Hive in Apache Airflow using the CData JDBC Driver.
-
Replicate Multiple Google Sheets Accounts
Replicate multiple Google Sheets accounts to one or many databases.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Drip
Provide connectivity to Drip through an SAP BusinessObjects universe.
-
DataBind Controls to Shippo Data in Delphi
DataBind to Shippo in Delphi with standard data access components and controls.
-
Create Dynamic Mailjet Grids Using the Infragistics XamDataGrid
Learn how you can connect Mailjet to Infragistics XamDataGrid to build dynamic grids.
-
How to Build an ETL App for Freshdesk Data in Python with CData
Create ETL applications and real-time data pipelines for Freshdesk in Python with petl.
-
Easily Integrate Close Data in Lazarus Pascal IDE
Learn how to easily integrate live Close in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automate SAP SuccessFactors LMS Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SAP SuccessFactors LMS from PowerShell? This article demonstrates how to utilize the SAP SuccessFactors LMS Cmdlets for tasks like connecting to SAP SuccessFactors LMS, automating operations, downloading data, and more.
-
ETL Microsoft Exchange in Oracle Data Integrator
This article shows how to transfer Microsoft Exchange into a data warehouse using Oracle Data Integrator.
-
Getting Started with the CData ODBC Driver for CockroachDB
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for CockroachDB.
-
Connect to API Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for API in Airbyte.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Oracle Sales
Provide connectivity to Oracle Sales through an SAP BusinessObjects universe.
-
Connect to Cloudflare Data in DBArtisan
Use wizards in DBArtisan to configure Cloudflare as a data source.
-
Integrating LangChain with Xero Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Xero Accounting within automated workflows.
-
Perform Batch Operations with Dropbox Data in Apache NiFi
Connect to Dropbox and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Google Contacts Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Google Contacts facts in real time.
-
Use the CData Software JDBC Driver for Pushbullet in MicroStrategy Desktop
Connect to Pushbullet in MicroStrategy Desktop using the CData Software JDBC Driver for Pushbullet.
-
Automated Continuous DB2 for i Replication to AlloyDB
Use CData Sync for automated, continuous, customizable DB2 for i replication to AlloyDB.
-
Enable the Adobe Commerce JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Adobe Commerce.
-
How to Query Adobe Commerce Data in MySQL Workbench
Execute MySQL queries against live Adobe Commerce from MySQL Workbench.
-
Use Dash to Build to Web Apps on SAP SuccessFactors LMS Data
Create Python applications that use pandas and Dash to build SAP SuccessFactors LMS-connected web apps.
-
Integrating GitHub Copilot CLI with Mode 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.
-
DataBind Controls to Apify Data in C++Builder
DataBind to Apify in C++Builder with standard components and controls.
-
Build GitHub Visualizations in Tableau Desktop
Use CData Connect AI to connect to live GitHub and build visualizations in Tableau.
-
Automated Continuous NetSuite SuiteAnalytics Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to Amazon Redshift.
-
Import Real-Time YouTube Analytics Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use YouTube Analytics in ColdFusion.
-
Integrating Claude Code CLI with Sage 300 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.
-
Build Dashboards with CapsuleCRM Data in DBxtra
Create dynamic dashboards and perform analytics based on CapsuleCRM in DBxtra.
-
How to Connect to Live SAP Ariba Source 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 Source for you.
-
A PostgreSQL Interface for Amplitude Data using the CData ODBC Driver
Use the SQL Gateway and Amplitude ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect FTP to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live FTP Servers using the CData Python MCP Server.
-
How to Build an ETL App for Splunk Data in Python with CData Connect AI
Build ETL pipelines that read and write live Splunk in Python with petl and the CData Connect AI Python SDK.
-
Access Oracle 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 Oracle Database.
-
How to Build an ETL App for Salesforce CRM Analytics Data in Python with CData Connect AI
Build ETL pipelines that read and write live Salesforce CRM Analytics in Python with petl and the CData Connect AI Python SDK.
-
Access Live API Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live API from your Excel spreadsheets.
-
A PostgreSQL Interface for Acumatica Data using the CData ODBC Driver
Use the SQL Gateway and Acumatica ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Dotmailer Data in RazorSQL
Connect to Dotmailer from wizards and query Dotmailer from the GUI in the RazorSQL database management tool.
-
How to Connect Flowise AI Agents to Live Adobe Analytics Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Adobe Analytics without replication.
-
Getting Started with the CData SSIS Components for Spotify
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Spotify.
-
How to Visualize Google Campaign Manager 360 Data in Python with pandas
Use pandas and other modules to analyze and visualize live Google Campaign Manager 360 in Python.
-
How to Query Live EmailOctopus Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live EmailOctopus data in natural language using Python.
-
Build Data Flows from Helpscout to SQL Server using SSIS
Easily back up Helpscout to SQL Server using the SSIS components for Helpscout.
-
Working with Procore Data in LINQPad
Execute LINQ queries to Procore in LINQPad.
-
Building Dynamic Web Pages with Oracle HCM Cloud Data Using AngularJS
Create single-page applications with live connectivity to Oracle HCM Cloud using the CData API Server.
-
Build PayPal-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live PayPal.
-
Analyze IBM Informix Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze IBM Informix with the CData JDBC Driver for IBM Informix.
-
Build Visualizations of Neo4J Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Neo4J in Birst.
-
Working with Amazon DynamoDB Data in LINQPad
Execute LINQ queries to Amazon DynamoDB in LINQPad.
-
Connect to Real-Time Clari Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Clari in Power Apps.
-
Creating Redshift-Connected Applications in Unqork
You can use CData Connect AI to feed Amazon Redshift to Unqork and build custom business apps.
-
Automate Oracle Sales Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Oracle Sales and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.