CData Software - Knowledge Base
Recent Articles
-
Connect to ChartMogul Data from PowerBuilder via JDBC
This article demonstrates how to access ChartMogul data from PowerBuilder using the ChartMogul JDBC Driver.
-
Connect to SAP Ariba Procurement Data in CloverDX (formerly CloverETL)
Transfer SAP Ariba Procurement data 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 data 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 data 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 data, 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 data 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 data, 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 Hive data and execute queries in PowerBuilder.
-
Connect to NASA Data in NetBeans
Connect to NASA data 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 data in Birst.
-
Automated Continuous PDFMonkey Replication to SQLite
Use CData Sync for automated, continuous, customizable PDFMonkey replication to SQLite.
-
Publish Google Sheets-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Google Sheets data.
-
Automated Continuous Zoho Inventory Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Zoho Inventory replication to Google BigQuery.
-
Analyze Mailgun Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Mailgun data 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 data 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 data in Informatica PowerCenter.
-
Access Pinecone Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Pinecone data 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 data 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 data 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 CouchDB data to a chart.
-
Build an OLAP Cube in SSAS from Sentry Data
Establish a connection to Sentry data 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 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 data.
-
Integrate Live Chargebee Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Chargebee data 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 data 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 data. Leverage the native support for ODBC in PHP.
-
Automated Typeform Data Replication to Teradata
Use CData Sync to Customize and automate Typeform data 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 data 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 Office 365 data.
-
How to integrate Hive with Apache Airflow
Access and process Hive data 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 data through an SAP BusinessObjects universe.
-
DataBind Controls to Shippo Data in Delphi
DataBind to Shippo data 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 data in Python with petl.
-
Easily Integrate Close Data in Lazarus Pascal IDE
Learn how to easily integrate live Close data 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 data from PowerShell? This article demonstrates how to utilize the SAP SuccessFactors LMS Cmdlets for tasks like connecting to SAP SuccessFactors LMS data, automating operations, downloading data, and more.
-
ETL Microsoft Exchange in Oracle Data Integrator
This article shows how to transfer Microsoft Exchange data 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 data in Airbyte.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Oracle Sales
Provide connectivity to Oracle Sales data through an SAP BusinessObjects universe.
-
Connect to Cloudflare Data in DBArtisan
Use wizards in DBArtisan to configure Cloudflare data 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 data within automated workflows.
-
Perform Batch Operations with Dropbox Data in Apache NiFi
Connect to Dropbox data 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 data 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 data.
-
How to Query Adobe Commerce Data in MySQL Workbench
Execute MySQL queries against live Adobe Commerce data 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 with Mode 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 Agno to Talk to Your SendPulse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your SendPulse data for you.
-
DataBind Controls to Apify Data in C++Builder
DataBind to Apify data in C++Builder with standard components and controls.
-
Build GitHub Visualizations in Tableau Desktop
Use CData Connect AI to connect to live GitHub data 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 data 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 data 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 data 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 data 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 data 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 data.
-
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 data 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 data 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 data 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 data 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 data in Python.
-
How to Query Live EmailOctopus Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live EmailOctopus data data in natural language using Python.
-
Build Data Flows from Helpscout to SQL Server using SSIS
Easily back up Helpscout data to SQL Server using the SSIS components for Helpscout.
-
Working with Procore Data in LINQPad
Execute LINQ queries to Procore data 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 data.
-
Analyze IBM Informix Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze IBM Informix data 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 data in Birst.
-
Working with Amazon DynamoDB Data in LINQPad
Execute LINQ queries to Amazon DynamoDB data 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 data in Power Apps.
-
Integrate LibreChat with Live Printify Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Printify data from within the chat interface.
-
Creating Redshift-Connected Applications in Unqork
You can use CData Connect AI to feed Redshift data to Unqork and build custom business apps.
-
Integrate Open WebUI with Live Reckon Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Reckon data from within the chat interface.
-
Getting Started with the CData Excel Add-In for QuickBooks Online
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for QuickBooks Online.
-
Access ZohoExpense Data from MySQL in Amazon QuickSight
Connect to ZohoExpense and build visualizations of ZohoExpense data using a MySQL Connection in Amazon QuickSight.
-
Replicate Multiple Perplexity Accounts
Replicate multiple Perplexity accounts to one or many databases.
-
Connect and Query Live SAP Hybris C4C Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live SAP Hybris C4C data into Databricks and enable direct, live querying and analysis without replication.
-
Integrate OpenCode with Live Sendwithus Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Sendwithus data from within your AI coding agent.
-
Import Act-On Data Using Azure Data Factory
Use CData Connect AI to connect to Act-On Data from Azure Data Factory and import live Act-On data.
-
How to Connect to Live Apify 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 Apify data for you.
-
Replicate Multiple ZohoMarketingHub Accounts
Replicate multiple ZohoMarketingHub accounts to one or many databases.