CData Software - Knowledge Base
Recent Articles
-
Use ChatGPT to Talk to Your Facebook Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Facebook Ads for you.
-
How to Connect to Live Cvent 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 Cvent for you.
-
Query Salesforce Pardot Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Salesforce Pardot from Node.js.
-
Use the CData Software JDBC Driver for Attio in MicroStrategy Desktop
Connect to Attio in MicroStrategy Desktop using the CData Software JDBC Driver for Attio.
-
Natively Connect to Calendly Data in PHP
The CData ODBC driver for Calendly enables you to create PHP applications with connectivity to Calendly. Leverage the native support for ODBC in PHP.
-
Start Visualizing Facebook Ads Performance Using CData
Learn how to visualize Facebook Ads data using CData drivers and connectors and build interactive dashboards in Power BI, Tableau, Excel, and more.
-
Use Azure AI Foundry to Talk to Your SAP BusinessObjects BI 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 SAP BusinessObjects BI for you.
-
DataBind Controls to Nethunt Data in C++Builder
DataBind to Nethunt in C++Builder with standard components and controls.
-
Integrating LangGraph with eBay Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on eBay within automated workflows.
-
Getting Started with the CData Excel Add-In for Raisers Edge NXT
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Raisers Edge NXT.
-
Create Dashboards and Visualize Live Reckon Accounts Hosted Data in Geckoboard
Use CData Connect AI to connect to live Reckon Accounts Hosted and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to Query Live RSS Feeds in Perplexity MacOS Desktop
Connect to and query live RSS Feeds in Perplexity Desktop using CData MCP Server.
-
Automated Continuous Box Replication to SQLite
Use CData Sync for automated, continuous, customizable Box replication to SQLite.
-
Connect to REST from Asprova with CData Software ODBC Driver for REST
This article shows how to connect faster to REST data from Asprova.
-
Deploy the ADO.NET Provider for Bannerbear on an SSRS Report Server
Connect to Bannerbear 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 Freshteam Data from a Connection Pool in Jetty
The Freshteam JDBC Driver supports connection pooling: This article shows how to connect faster to Freshteam from Web apps in Jetty.
-
How to integrate LinkedIn Ads with Apache Airflow
Access and process LinkedIn Ads in Apache Airflow using the CData JDBC Driver.
-
Consume REST OData Feeds in SAP Lumira
Use the API Server to create data visualizations on REST feeds that reflect any changes in SAP Lumira.
-
Create Apps from Cosmos DB Data in Qlik Sense Cloud
Use CData Connect AI to connect to Cosmos DB Data and build apps from live Azure Cosmos DB in Qlik Sense Cloud.
-
Work with Pinterest Data in FoxPro
Load Pinterest into a FoxPro database. This article includes full code and a walk-through of the process.
-
Extend Google Sheets with ADP Data
Make calls to ADP from Google Apps Script via the API Server.
-
Getting Started with the CData SSIS Components for Exact Online
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Exact Online.
-
Viewing Marketo Data in RAD Studio Data Explorer
How to view Marketo in RAD Studio Data Explorer using the CData ODBC Driver for Marketo.
-
Integrate Apify with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Apify with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Apify.
-
Connect to Live API Data in PostGresSQL Interface through CData Connect AI
Create a live connection to API in CData Connect AI and connect to your API from PostgreSQL.
-
Create Power BI Reports on Real-Time Cosmos DB Data
Use the CData ODBC Driver for Cosmos DB to visualize Azure Cosmos DB in Power BI Desktop.
-
Build Charts with Paylocity Data in Clear Analytics
Create dynamic charts and perform analytics based on Paylocity in Clear Analytics.
-
Import Real-Time Tanda Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Tanda in ColdFusion.
-
Choosing the Best Method to Connect Epicor Kinetic to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Epicor Kinetic from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
DataBind Controls to Google Translate Data in C++Builder
DataBind to Google Translate in C++Builder with standard components and controls.
-
Automated Continuous Azure Synapse Replication to MySQL
Use CData Sync for automated, continuous, customizable Azure Synapse replication to MySQL.
-
Using the CData Software ODBC Driver for Pipeline CRM in PyCharm
Connect to Pipeline CRM as an ODBC data source in PyCharm using the CData Software ODBC Driver for Pipeline CRM.
-
A PostgreSQL Interface for SAP HANA Data (MySQL Remoting via JDBC)
Use the Remoting features of the SAP HANA JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect and Query Live Stripe Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Stripe into Databricks
-
Query Cassandra Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Apache Cassandra and perform CRUD operations on Cassandra from Node.js.
-
How to Connect DBeaver to Paddle via a JDBC Driver
Manage Paddle with visual tools in DBeaver like the query browser.
-
Use JayDeBeApi to access Drip Data in Python
Use standard Python scripting and the development environment of your choice to access live Drip.
-
Visualize SAP HANA Data in Tableau
The CData ODBC driver for SAP HANA enables you integrate SAP HANA into Tableau dashboards.
-
Access Live Power BI XMLA Data in Coginiti Pro
Connect to and query live Power BI XMLA from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use Biml to Build SSIS Tasks to Replicate Pipedrive Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Pipedrive to SQL Server.
-
Connect to Sugar CRM Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Sugar CRM and the Script function in FileMaker Pro to connect to Sugar CRM and work with Sugar CRM in your FileMaker application.
-
Use Microsoft Copilot Studio to talk to your Splunk 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 Splunk for you.
-
Connect and Query Live Oracle Eloqua Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Oracle Eloqua into Databricks
-
Enable the Salesforce Data 360 JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Salesforce Data 360.
-
Connect to IBM Cloud Object Storage Data in CloverDX (formerly CloverETL)
Transfer IBM Cloud Object Storage using the visual workflow in the CloverDX data integration tool.
-
How to Build an ETL App for Chargebee Data in Python with CData
Create ETL applications and real-time data pipelines for Chargebee in Python with petl.
-
How to Create Power BI Visual Reports with Real-Time Parquet Data
Use CData Power BI Connectors to visualize Apache Parquet in Power BI.
-
Work with TaxJar Data in FoxPro
Load TaxJar into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Apps with Live Oracle Sales in Adalo using CData Connect AI
Use CData Connect AI to integrate live Oracle Sales into the Adalo platform and build custom mobile and web applications with real-time Oracle Sales.
-
Connect to Deel Data from a Connection Pool in JBoss
Integrate Deel into Java servlets: Use the Management Console in JBoss to install the Deel JDBC Driver.
-
Bridge Facebook Connectivity with Apache NiFi
Access and process Facebook in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous Quaderno Replication to SQLite
Use CData Sync for automated, continuous, customizable Quaderno replication to SQLite.
-
Use the CData Software JDBC Driver for Short.io in MicroStrategy Desktop
Connect to Short.io in MicroStrategy Desktop using the CData Software JDBC Driver for Short.io.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for JobNimbus
Provide connectivity to JobNimbus through an SAP BusinessObjects universe.
-
Integrating Dataiku with FreshBooks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live FreshBooks.
-
Connect and Query Live Neo4J Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Neo4J into Databricks
-
Integrating Claude Code CLI with eBay 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 Azure Data Catalog Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Azure Data Catalog from your Oracle system.
-
Object-Relational Mapping (ORM) with FreshBooks Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to FreshBooks into a Java-based ORM framework, Hibernate.
-
Migrating data from Hacker News to Databricks using CData SSIS Components.
Easily push Hacker News to Databricks using the CData SSIS Tasks for Hacker News and Databricks.
-
How to Connect to & Open ZendeskSell Data in Microsoft Excel
This article uses the CData ODBC driver for ZendeskSell to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect Vault CRM Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Veeva Vault & Vault CRM using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Publish Dynamics 365 Business Central-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Dynamics 365 Business Central.
-
Build Voice Agents in ElevenLabs with access to Live Asana Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Asana.
-
Publish Crystal Reports on JotForm Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date JotForm.
-
Integrate Sybase with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Sybase with External Services.
-
Work with Google Ad Manager Data in FoxPro
Load Google Ad Manager into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Connect to & Open Monday.com Data in Microsoft Excel
This article uses the CData ODBC driver for Monday.com to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Freshsales Data in Aqua Data Studio
Access Freshsales from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
LINQ to Act CRM 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 Act CRM Data Provider.
-
DataBind Charts to XML Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to XML Files from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Replicate Spark Data in Heroku for Use in Salesforce Connect
Replicate Apache Spark SQL to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to connect PolyBase to Bitbucket
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Bitbucket.
-
Connect to Presto Data from AWS Glue
Use CData Connect AI to gain access to live Presto from your AWS Glue jobs.
-
How to Query Tally Data in MySQL Workbench
Execute MySQL queries against live Tally ERP from MySQL Workbench.
-
Integrating Antigravity CLI with SAP Ariba Procurement via CData CLI
Connect SAP Ariba Procurement to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate with Live API Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to API from the MuleSoft Anypoint Platform to integrate live API into custom reports and dashboards.
-
How to Connect to & Open Zoho Recruit Data in Microsoft Excel
This article uses the CData ODBC driver for Zoho Recruit to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Use Biml to Build SSIS Tasks to Replicate Google Spanner Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Google Spanner to SQL Server.
-
Natively Connect to OpenWeatherMap Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to OpenWeatherMap. Leverage the native support for ODBC in PHP.
-
Build a PostgreSQL Interface for PabblySubscriptions Data using the CData JDBC Driver
Use the Remoting features of the PabblySubscriptions JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use Manus AI to Talk to Your Trello 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 Trello.
-
Migrating data from Notion to Databricks using CData SSIS Components.
Easily push Notion to Databricks using the CData SSIS Tasks for Notion and Databricks.
-
Connect to and Visualize Live Reckon Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Reckon.
-
Getting Started with the CData JDBC Driver for Ontraport
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Ontraport.
-
Build Data Flows from Billsby to SQL Server using SSIS
Easily back up Billsby to SQL Server using the SSIS components for Billsby.
-
Publish Mailgun-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Mailgun.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ZohoPeople
Provide connectivity to ZohoPeople through an SAP BusinessObjects universe.
-
Integrating LangChain with ServiceNow Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on ServiceNow within automated workflows.
-
How to Connect to Dynamics 365 Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Microsoft Dynamics 365. Leverage the pyodbc module for ODBC in Python.
-
Add SAP Ariba Source Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SAP Ariba Source with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use the CData ODBC Driver for HubSpot in Microsoft Power Query
You can use the CData HubSpot ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import HubSpot into Microsoft Power Query.
-
Integrating LangGraph with Salesforce CRM Analytics Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Salesforce CRM Analytics within automated workflows.
-
Automate ConvertKit Integration Tasks from PowerShell
Are you in search of a quick and easy way to access ConvertKit from PowerShell? This article demonstrates how to utilize the ConvertKit Cmdlets for tasks like connecting to ConvertKit, automating operations, downloading data, and more.
-
Connect to REST Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for REST and the SQL Gateway to access REST from Google Apps Script.
-
Integrating LangChain with Authorize.Net Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Authorize.Net within automated workflows.
-
Build Visualizations of Salesforce Data 360 Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Salesforce Data 360 in Birst.
-
Getting Started with the CData ODBC Driver for JSON
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for JSON.
-
Build Apps with Live Sybase IQ Data Using the Low-Code Development Platform of Mendix
Connect Sybase IQ with Mendix to build apps using the CData JDBC Driver for Sybase IQ.
-
Build Voice Agents in ElevenLabs with access to Live Google Ads Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Google Ads.