CData Software - Knowledge Base
Recent Articles
-
Build a PostgreSQL Interface for Dynamics 365 Business Central Data using the CData JDBC Driver
Use the Remoting features of the Dynamics 365 Business Central JDBC Driver to create a PostgreSQL entry-point for data access.
-
DataBind Act CRM Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Act CRM with the DevExpress Windows Forms and Web controls to provide Act CRM to a chart.
-
Replicate Shippo Data to Multiple Databases
Replicate Shippo to disparate databases with a point-and-click configuration.
-
Work with Live Phoenix Data in Power Query
Use CData Connect AI to connect to Apache Phoenix and work with live Apache Phoenix in Microsoft Power Query.
-
Create Informatica Mappings From/To an ODBC Data Source for BambooHR
Create an ODBC connection to BambooHR in Informatica and browse and transfer BambooHR.
-
A PostgreSQL Interface for Wave Financial Data (MySQL Remoting via JDBC)
Use the Remoting features of the Wave Financial JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Access Gumroad Data Using Entity Framework
This article shows how to access Gumroad using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrating Avalara AvaTax Data in Talend Cloud Data Management Platform
Connect Avalara AvaTax Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Avalara AvaTax.
-
Connect to Bugsnag Data in RazorSQL
Connect to Bugsnag from wizards and query Bugsnag from the GUI in the RazorSQL database management tool.
-
How to integrate Procore with Apache Airflow
Access and process Procore in Apache Airflow using the CData JDBC Driver.
-
Build a Simple VCL Application for BambooHR Data
How to build a simple VCL Application to view BambooHR in RAD Studio using the CData ODBC Driver for BambooHR.
-
Build Automated SAP SuccessFactors-Connected Workflows in Zapier
Use CData Connect AI to connect to live SAP SuccessFactors and build automated workflows in Zapier.
-
Analyze SAP HANA Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SAP HANA and visualize live SAP HANA in Infragistics Reveal.
-
Integrate Sage Cloud Accounting Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Sage Business Cloud Accounting and integrate live Sage Business Cloud Accounting into your Power Automate tasks.
-
Use Azure AI Foundry to Talk to Your HCL Domino Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your HCL Domino for you.
-
Create Power BI Reports on Real-Time Zoho Books Data
Use the CData ODBC Driver for Zoho Books to visualize Zoho Books in Power BI Desktop.
-
Integrate with SAP Ariba Source Data in JReport Designer
Create charts and reports based on SAP Ariba Source in JReport Designer.
-
Write a Simple Go Application to work with Active Directory Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Active Directory.
-
How to connect to Postmark Data with Squirrel SQL client
Connect to Postmark and execute queries in the Squirrel SQL Client.
-
Use the CData ODBC Driver for ZendeskSell in Microsoft Power Query
You can use the CData ZendeskSell ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ZendeskSell into Microsoft Power Query.
-
Integrate Paddle Data in the Pentaho Report Designer
Publish reports based on Paddle in the Pentaho BI tool.
-
Build Automated Workflows with Live DB2 Data in Workato
Use CData Connect AI to connect to live IBM DB2 and build automated workflows in Workato.
-
Create Informatica Mappings From/To a JDBC Data Source for Google Forms
Create Google Forms data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Natively Connect to Kintone Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Kintone. Leverage the native support for ODBC in PHP.
-
Access Auth0 Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Auth0 from HeidiSQL.
-
Build Cloudant-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live IBM Cloudant and build Cloudant-connected web apps with Axios.
-
Access Live Kintone Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Kintone through MCP integration.
-
How to Connect to Live Microsoft Dataverse 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 Microsoft Dataverse (CDS) for you.
-
Integrate Monday.com Data into Power Automate Desktop using CData Connect
CData Connect for Monday.com Data enables you to integrate Monday.com into workflows built using Microsoft Power Automate Desktop.
-
How to Query Anaplan Data in MySQL Workbench
Execute MySQL queries against live Anaplan from MySQL Workbench.
-
Connect to Vimeo Data in Ruby
Connect to Vimeo in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Getting Started with the CData JDBC Driver for Cosmos DB
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Cosmos DB.
-
Use Databricks Agent Bricks to Talk to Your Smartsheet Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Smartsheet for you.
-
Integrating Antigravity CLI with Epicor Kinetic via CData CLI
Connect Epicor Kinetic to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Use the CData SSIS Components to Insert New or Update Existing Oracle Service Cloud Records from SQL Server
Easily push SQL Server data to Oracle Service Cloud using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Oracle Service Cloud or update existing records with data from a SQL Server database.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SQL Server
Provide connectivity to Microsoft SQL Server through an SAP BusinessObjects universe.
-
How to connect to Parallel Data with Squirrel SQL client
Connect to Parallel and execute queries in the Squirrel SQL Client.
-
Access Live Freshdesk Data in AWS Lambda
Connect to live Freshdesk in AWS Lambda using the CData JDBC Driver.
-
Integrate Workable Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Workable from Informatica Cloud.
-
Build HCL Domino-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live HCL Domino.
-
How to connect and process TaxJar from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live TaxJar.
-
Bridge OnePageCrm Connectivity with Apache NiFi
Access and process OnePageCrm in Apache NiFi using the CData JDBC Driver.
-
Query Telegram Data as a MySQL Database in Node.js
Execute MySQL queries against Telegram from Node.js.
-
Create Hive-Connected Business Apps in AppSheet
Connect to Hive Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Apache Hive.
-
Build a Singer.io Tap for Aircall With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Aircall data using
-
Visualize ZendeskSell Data in TIBCO Spotfire through ADO.NET
Integrate ZendeskSell into dashboards in TIBCO Spotfire.
-
Import Real-Time MySQL Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use MySQL in ColdFusion.
-
Build Semantic Layer Views for Foursquare Data in APOS Live Data Gateway
Use the CData Connector for Foursquare in APOS Live Data Gateway to build Semantic Layer Views for Foursquare.
-
Build Dashboards with Wrike Data in DBxtra
Create dynamic dashboards and perform analytics based on Wrike in DBxtra.
-
Build Data Flows from eBay Analytics to SQL Server using SSIS
Easily back up eBay Analytics to SQL Server using the SSIS components for eBay Analytics.
-
Automated Continuous Email Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Email replication to OneLake in Microsoft Fabric.
-
Migrating data from Phoenix to Databricks using CData SSIS Components.
Easily push Apache Phoenix to Databricks using the CData SSIS Tasks for Phoenix and Databricks.
-
Connecting Agentforce with NetSuite Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your NetSuite CRM & ERP for you.
-
Integrate with Microsoft Teams Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Microsoft Teams in SnapLogic.
-
Build Microsoft Teams-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Microsoft Teams.
-
Build Data Flows from SQL Server to SAP Netweaver Gateway through SSIS
Easily push SQL Server data to SAP Netweaver Gateway using the CData SSIS Tasks for SAP Netweaver Gateway.
-
Replicate JotForm Data in Heroku for Use in Salesforce Connect
Replicate JotForm to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to integrate SAP SuccessFactors with Apache Airflow
Access and process SAP SuccessFactors in Apache Airflow using the CData JDBC Driver.
-
How to Access Live Pipedrive Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Pipedrive enables you to integrate Pipedrive into workflows built using Microsoft Power Automate Desktop.
-
Integrate with ZohoMarketingHub Data in JReport Designer
Create charts and reports based on ZohoMarketingHub in JReport Designer.
-
Integrate PagerDuty Data in Pentaho Data Integration
Build ETL pipelines based on PagerDuty in the Pentaho Data Integration tool.
-
Query Asana Data as a MySQL Database in Node.js
Execute MySQL queries against Asana from Node.js.
-
Use the CData Software JDBC Driver for SAP Ariba Procurement in MicroStrategy Web
Connect to SAP Ariba Procurement in MicroStrategy Web using the CData Software JDBC Driver for SAP Ariba Procurement.
-
Extract, Transform, and Load Sage Cloud Accounting Data in Informatica PowerCenter
Create a simple Workflow for Sage Business Cloud Accounting in Informatica PowerCenter.
-
Integrating GitHub Copilot CLI with Drip 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 Live xBase Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live xBase data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Use the CData Software ODBC Driver for QuickBooks Time in MicroStrategy
Connect to QuickBooks Time in MicroStrategy Developer using the CData Software ODBC Driver for QuickBooks Time.
-
How to connect to Beeminder Data in DBVisualizer
Integrate Beeminder with visual data analysis tools and data connection wizards in DBVisualizer
-
Establish a Live Connection with SAP HANA XS Advanced Data using Tableau Bridge
The CData ODBC Driver for SAP HANA XS Advanced enables you to integrate live SAP HANA XS Advanced into Tableau Cloud dashboards using the Tableau Bridge.
-
Analyze Facebook Ads Data in Looker
Use CData Connect AI to connect to Facebook Ads Data from Looker and build custom apps using live Facebook Ads.
-
Use the CData ODBC Driver for CloudConvert in Microsoft Power Query
You can use the CData CloudConvert ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import CloudConvert into Microsoft Power Query.
-
Use CData Connect AI to Access SAP SuccessFactors LMS Data in Microsoft Power Pivot
Use CData Connect AI to connect to live SAP SuccessFactors LMS in the Power Pivot business intelligence tool.
-
How to Work with Dotmailer Data in ETL Validator JDBC
Connect to Dotmailer from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Build an ETL App for Redshift Data in Python with CData Connect AI
Build ETL pipelines that read and write live Amazon Redshift in Python with petl and the CData Connect AI Python SDK.
-
Connect to SAP SuccessFactors LMS Data in Google Apps Script via Connect AI
Use CData Connect AI to access SAP SuccessFactors LMS in Google Apps Script.
-
How to use SQLAlchemy ORM to access PivotalTracker Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of PivotalTracker.
-
Build Semantic Layer Views for Salesforce CRM Analytics Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Salesforce CRM Analytics.
-
How to connect to JDBC-ODBC Bridge Data with Squirrel SQL client
Connect to JDBC-ODBC Bridge and execute queries in the Squirrel SQL Client.
-
Automated Continuous SparkPost Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SparkPost replication to Apache Kafka.
-
Deploy the ADO.NET Provider for SAP Ariba Source on an SSRS Report Server
Connect to SAP Ariba Source 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.
-
Easily Integrate Vault CRM Data in Lazarus Pascal IDE
Learn how to easily integrate live Veeva Vault & Vault CRM in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create Informatica Mappings From/To an ODBC Data Source for xBase
Create an ODBC connection to xBase in Informatica and browse and transfer xBase.
-
Access Harvest Data from MySQL in PHP
Connect to Harvest through the standard MySQL libraries in PHP.
-
Integrate Couchbase Data into Power Automate Desktop using CData Connect
CData Connect for Couchbase Data enables you to integrate Couchbase into workflows built using Microsoft Power Automate Desktop.
-
Connect to Mode Data in Ruby
Connect to Mode in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Work with PabblySubscriptions Data in AWS Glue Jobs Using JDBC
Connect to PabblySubscriptions from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Visualize Parallel Data in Python with pandas
Use pandas and other modules to analyze and visualize live Parallel in Python.
-
Automate VWO Data Replication to SAP HANA
Use CData Sync to customize and automate VWO replication to SAP HANA.
-
Connect to Oracle Eloqua Reporting Data from a Connection Pool in Jetty
The Oracle Eloqua Reporting JDBC Driver supports connection pooling: This article shows how to connect faster to Oracle Eloqua Reporting from Web apps in Jetty.
-
How to create Retently federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Retently in MySQL .
-
How to Connect Airtable 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 Airtable data in real time using natural language.
-
How to integrate Pingdom with Apache Airflow
Access and process Pingdom in Apache Airflow using the CData JDBC Driver.
-
LINQ to Trello 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 Trello Data Provider.
-
Integrating Boomi Agentstudio with Zendesk Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Zendesk, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to Connect to Tanda Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Tanda. Leverage the pyodbc module for ODBC in Python.
-
How to Connect to Live Redis Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Redis through natural language.
-
Access Live SingleStore Data in Excel 365 Online (Excel for the web)
Connect to SingleStore from Excel 365 Online (Excel for the web) with CData Connect AI.
-
A PostgreSQL Interface for Marketo Data using the CData ODBC Driver
Use the SQL Gateway and Marketo ODBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Live Google Drive Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Google Drive into custom reports in Power BI.
-
Build AI/ML Models with Live LionDesk Data using Dataiku
Connect LionDesk Data with Dataiku using the CData API Driver for JDBC.