CData Software - Knowledge Base
Recent Articles
-
Query NASA Data as a MySQL Database in Node.js
Execute MySQL queries against NASA from Node.js.
-
Integrate with Gong Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Gong to a JSON file on disk.
-
Connecting Pipedream with QuickBooks Time Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on QuickBooks Time data in real time.
-
Integrating LangGraph with Trello Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Trello within automated workflows.
-
Creating Phoenix-Connected Applications in Unqork
You can use CData Connect AI to feed Apache Phoenix to Unqork and build custom business apps.
-
Add PayPal Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for PayPal with the Informatica Enterprise Data Catalog to classify and organize data.
-
Working with Hive Data in LINQPad
Execute LINQ queries to Apache Hive in LINQPad.
-
Choosing the Best Method to Connect Keap to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Keap from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Replicate Avaza Data in Heroku for Use in Salesforce Connect
Replicate Avaza to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build Apps with Live Smartsheet in Adalo using CData Connect AI
Use CData Connect AI to integrate live Smartsheet into the Adalo platform and build custom mobile and web applications with real-time Smartsheet.
-
Create SSAS Tabular Models from Superchat Data
How to build a SQL Server Analysis Service Tabular Model from Superchat using CData drivers.
-
Connect SAP Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SAP ERP/NetWeaver using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Query FHIR Data in ColdFusion
Write standard ColdFusion data access code to connect to FHIR.
-
How to Create Power BI Visual Reports with Real-Time Airtable Data
Use CData Power BI Connectors to visualize Airtable in Power BI.
-
Deploy the ADO.NET Provider for LightSpeedRetail on an SSRS Report Server
Connect to LightSpeedRetail 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.
-
Visualize Twilio Data in Tableau
The CData ODBC driver for Twilio enables you integrate Twilio into Tableau dashboards.
-
Create Reports with SAP Business Warehouse Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP Business Warehouse.
-
Visualize XML Data in Sisense
Create an ElastiCube in Sisense app with access to XML Files.
-
Automated Continuous GitHub Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable GitHub replication to Azure SQL Database.
-
How to integrate Shopify with Apache Airflow
Access and process Shopify in Apache Airflow using the CData JDBC Driver.
-
How to Connect to Live Oracle Financials Cloud 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 Oracle Financials Cloud for you.
-
Build Excel Online-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Microsoft Excel Online.
-
Integrating Codex CLI with Facebook Ads 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 JayDeBeApi to access Jira Data in Python
Use standard Python scripting and the development environment of your choice to access live Atlassian Jira.
-
Automate Epicor Kinetic Data Replication to SAP HANA
Use CData Sync to customize and automate Epicor Kinetic replication to SAP HANA.
-
How to Easily Query SAS xpt Data in OpenOffice Base
Connect to SAS xpt data in OpenOffice Base using the CData ODBC Driver for SAS xpt and generate reports with live data insights.
-
Connecting Agentforce with Sybase 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 Sybase for you.
-
How to Design Facebook Ads Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Facebook Ads from mobile and tablet Power Apps.
-
Create Informatica Mappings From/To an ODBC Data Source for Mocean
Create an ODBC connection to Mocean in Informatica and browse and transfer Mocean.
-
How to connect to Hive Data with Squirrel SQL client
Connect to Apache Hive and execute queries in the Squirrel SQL Client.
-
Natively Connect to HubDB Data in PHP
The CData ODBC driver for HubDB enables you to create PHP applications with connectivity to HubDB. Leverage the native support for ODBC in PHP.
-
Visualize Live Suadeo Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Suadeo using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to WordPress Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live WordPress.
-
How to Seamlessly Import Retently Data into IBM SPSS Modeler
Integrate Retently data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Agents in Relevance AI with Access to Live Google Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Google Ads within intelligent agent workflows.
-
Automate Paymo Data Replication to Azure Data Lake
Use CData Sync to customize and automate Paymo replication to Azure Data Lake.
-
How to Work with Salesforce Marketing Data in ETL Validator JDBC
Connect to Salesforce Marketing from ETL Validator jobs using the CData Software JDBC Driver.
-
Work with Quickbase Data in FoxPro
Load Quickbase into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use Dash to Build to Web Apps on Exact Online Data
Create Python applications that use pandas and Dash to build Exact Online-connected web apps.
-
Build Pipelines with Live CSV Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to CSV from Google Cloud Data Fusion, enabling the integration of live CSV/TSV Files into the building and management of effective data pipelines.
-
Seamlessly Bring Microsoft Exchange Data into Retool Using CData Connect AI
Integrate Microsoft Exchange data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Migrating data from Adobe Analytics to Snowflake using CData SSIS Components.
Easily push Adobe Analytics to Snowflake using the CData SSIS Tasks for Adobe Analytics and Snowflake.
-
Automated Continuous Reckon Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Reckon replication to Apache Cassandra.
-
Integrate Gong Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Gong from Informatica Cloud.
-
How to Create Power BI Visual Reports with Real-Time Deel Data
Use CData Power BI Connectors to visualize Deel in Power BI.
-
ETL Insightly in Oracle Data Integrator
This article shows how to transfer Insightly into a data warehouse using Oracle Data Integrator.
-
Build Authorize.Net-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Authorize.Net to explore live Authorize.Net Data in GitHub Copilot to assist with building Authorize.Net-powered applications.
-
DataBind Controls to Bitbucket Data in Delphi
DataBind to Bitbucket in Delphi with standard data access components and controls.
-
Use the CData Software ODBC Driver for Impala in MicroStrategy
Connect to Apache Impala in MicroStrategy Developer using the CData Software ODBC Driver for Impala.
-
How to Connect to Live Google Calendar Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Google Calendar for you.
-
Build AI/ML Models with Live SharePoint Excel Services Data using Dataiku
Connect SharePoint Excel Services Data with Dataiku using the CData JDBC Driver for SharePoint Excel Services.
-
Connect to ZohoMarketingHub Data in HULFT Integrate
Connect to ZohoMarketingHub as a JDBC data source in HULFT Integrate
-
How to Query Live SendGrid Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SendGrid data in natural language using Python.
-
DataBind Charts to Aha! Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Aha! 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.
-
Integrate Live Oracle Financials Cloud Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Build Dashboards with Bitbucket Data in Dundas BI
Create dynamic dashboards and perform analytics based on Bitbucket in Dundas BI.
-
Visualize Avalara AvaTax Data in TIBCO Spotfire through OData
Integrate Avalara AvaTax into dashboards in TIBCO Spotfire.
-
Automated Accelo Data Replication to Teradata
Use CData Sync to Customize and automate Accelo replication to Teradata.
-
Replicate Multiple Opsgenie Accounts
Replicate multiple Opsgenie accounts to one or many databases.
-
Access Adobe Analytics Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Adobe Analytics from your Oracle system.
-
Access CouchDB Data from MySQL in PHP
Connect to CouchDB through the standard MySQL libraries in PHP.
-
Use the CData Software ODBC Driver for Pushbullet in SAS for Real-Time Reporting and Analytics
Connect to real-time Pushbullet in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Pushbullet.
-
Natively Connect to Zoho CRM Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Zoho CRM. Leverage the native support for ODBC in PHP.
-
Connect to QuickBooks Data from a Connection Pool in JBoss
Integrate QuickBooks Desktop into Java servlets: Use the Management Console in JBoss to install the QuickBooks JDBC Driver.
-
Use the CData Software ODBC Driver for OnePageCrm in MicroStrategy Desktop
Connect to OnePageCrm in MicroStrategy Desktop using the CData Software ODBC Driver for OnePageCrm.
-
Write a Simple Go Application to work with Sendwithus Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Sendwithus.
-
Connect to SQL Server Data in Aqua Data Studio
Access Microsoft SQL Server from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Query IBM Cloud Object Storage Data in ColdFusion
Write standard ColdFusion data access code to connect to IBM Cloud Object Storage.
-
Connect to Real-Time GraphQL Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for GraphQL and Dataflow to import and use GraphQL in Power Apps.
-
Use Claude to Talk to Your ServiceNow 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 ServiceNow for you.
-
Publish Reports with Hive Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Apache Hive.
-
How to Create Power BI Visual Reports with Real-Time Simplesat Data
Use CData Power BI Connectors to visualize Simplesat in Power BI.
-
Integrate Live Adobe Commerce Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Adobe Commerce and integrate live Adobe Commerce into apps built in Microsoft Power Apps.
-
Visualize Discord Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Discord.
-
Automate Invoiced Data Replication to Couchbase
Use CData Sync to Customize and automate Invoiced replication to Couchbase.
-
Build Automated Workflows with Live HubSpot Data in Workato
Use CData Connect AI to connect to live HubSpot and build automated workflows in Workato.
-
How to Build an ETL App for SAP BusinessObjects BI Data in Python with CData Connect AI
Build ETL pipelines that read and write live SAP BusinessObjects BI in Python with petl and the CData Connect AI Python SDK.
-
Visualize RabbitMQ Data in Sisense
Create an ElastiCube in Sisense app with access to RabbitMQ.
-
Build Sage Cloud Accounting-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Sage Cloud Accounting Data and create custom apps in Bubble.
-
Use the CData Software JDBC Driver for Hive in MicroStrategy Web
Connect to Apache Hive in MicroStrategy Web using the CData Software JDBC Driver for Hive.
-
Automated Continuous SingleStore Replication to Snowflake
Use CData Sync for automated, continuous, customizable SingleStore replication to Snowflake.
-
Connect to Google Sheets from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Google Sheets, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Use the CData Software JDBC Driver for Greenhouse in MicroStrategy Desktop
Connect to Greenhouse in MicroStrategy Desktop using the CData Software JDBC Driver for Greenhouse.
-
Connect to Short.io Data in CloverDX (formerly CloverETL)
Transfer Short.io using the visual workflow in the CloverDX data integration tool.
-
Use the CData Software JDBC Driver for Access in MicroStrategy Web
Connect to Microsoft Access in MicroStrategy Web using the CData Software JDBC Driver for Access.
-
Natively Connect to Avro Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Apache Avro. Leverage the native support for ODBC in PHP.
-
Analyze SAP Netweaver Gateway Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SAP Netweaver Gateway in Microsoft R Open.
-
DataBind Controls to Clockify Data in C++Builder
DataBind to Clockify in C++Builder with standard components and controls.
-
Access Live Avro Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Apache Avro from your Excel spreadsheets.
-
CockroachDB Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to CockroachDB through CData Connect AI using different applications and tools.
-
Feed MariaDB Data into FineReport
How to set MariaDB as a JDBC data source in FineReport.
-
How to Access Live Facebook Ads Data in Visual Studio Code via Cline
Run CData MCP Server for Facebook Ads on Windows Subsytem for Linux (WSL) and connect to live Facebook Ads from the Cline extension in Visual Studio Code.
-
Build SAP Ariba Procurement-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for SAP Ariba Procurement Data and create custom apps in Mendix.
-
Stream LDAP Objects into Apache Kafka Topics
Access and stream LDAP in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to SAP HANA Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for SAP HANA and the Script function in FileMaker Pro to connect to SAP HANA and work with SAP HANA in your FileMaker application.
-
View Reports on Real-Time Presto Data in Power BI Report Server
Use the CData ODBC Driver for Presto to visualize Presto in Power BI Desktop and then publish them to Power BI Report Server.
-
Access Templated Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Templated from your Oracle system.
-
How to Build an ETL App for SingleStore Data in Python with CData
Create ETL applications and real-time data pipelines for SingleStore in Python with petl.
-
Building Dynamic Web Pages with Bullhorn CRM Data Using AngularJS
Create single-page applications with live connectivity to Bullhorn CRM using the CData API Server.
-
Build Coinbase-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Coinbase.