CData Software - Knowledge Base
Recent Articles
-
Integrate MailerLite Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live MailerLite from Informatica Cloud.
-
Prepare, Blend, and Analyze Oracle Service Cloud Data in Alteryx Designer (Connect AI)
Build workflows to access live Oracle Service Cloud for self-service data analytics.
-
Consume Authorize.Net OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Authorize.Net feeds that reflect any changes in SAP Lumira.
-
How to Create Power BI Visual Reports with Real-Time Microsoft Exchange Data
Use CData Power BI Connectors to visualize Microsoft Exchange in Power BI.
-
Access WooCommerce Data from MySQL in Amazon QuickSight
Connect to WooCommerce and build visualizations of WooCommerce using a MySQL Connection in Amazon QuickSight.
-
Connect to HubSpot Data from HeidiSQL
Use CData Connect AI to connect to and query live HubSpot from HeidiSQL.
-
Create Power BI Reports on Real-Time MessageBird Data
Use the CData ODBC Driver for MessageBird to visualize MessageBird in Power BI Desktop.
-
Integrate Oracle HCM Cloud Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Oracle HCM Cloud from Informatica Cloud.
-
Build AI/ML Models with Live Zoho Books Data using Dataiku
Connect Zoho Books Data with Dataiku using the CData JDBC Driver for Zoho Books.
-
Integrate Testmonitor Data in the Pentaho Report Designer
Publish reports based on Testmonitor in the Pentaho BI tool.
-
Integrating Codex CLI with Dynamics 365 Business Central 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.
-
Automated Continuous Kintone Replication to SQL Server
Use CData Sync for automated, continuous, customizable Kintone replication to SQL Server.
-
Integrate Real-Time Access to Office 365 in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Microsoft Office 365 in real time.
-
Operational Reporting on Discourse Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Discourse.
-
How to Seamlessly Import MailChimp Data into IBM SPSS Modeler
Integrate MailChimp data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automate Harvest Data Replication to SAP HANA
Use CData Sync to customize and automate Harvest replication to SAP HANA.
-
Build Oracle Financials Cloud Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Oracle Financials Cloud and build visualizations in Tableau Cloud.
-
How to create Microsoft Entra ID federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Microsoft Entra ID in MySQL .
-
Automated Continuous Act CRM Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Act CRM replication to OneLake in Microsoft Fabric.
-
Connect to SAP SuccessFactors in SpagoBI
Create reports featuring live SAP SuccessFactors in SpagoBI Studio. Host SAP SuccessFactors reports on SpagoBI Server.
-
Create DocuSign-Connected Applications in Appsmith
Connect to DocuSign Data via CData Connect AI in Appsmith and create custom business applications with real-time access to DocuSign.
-
Getting Started with the CData ODBC Driver for ZohoSubscriptions
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ZohoSubscriptions.
-
Integrating Dataiku with Office 365 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Microsoft Office 365.
-
DataBind MessageBird Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide MessageBird to a chart.
-
Use the CData ODBC Driver for AdRoll in Microsoft Power Query
You can use the CData AdRoll ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import AdRoll into Microsoft Power Query.
-
Build Data Flows from SQL Server to Salesforce Marketing through SSIS
Easily push SQL Server data to Salesforce Marketing using the CData SSIS Tasks for Salesforce Marketing.
-
Use the CData ODBC Driver for Calendly from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Calendly to connect to Calendly from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Calendly in Excel.
-
Build an OLAP Cube in SSAS from Supabase Data
Establish a connection to Supabase data from SQL Server Analysis Services, and use the Supabase Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use Claude to Talk to Your Splunk 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 Splunk for you.
-
Analyze CockroachDB Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of CockroachDB and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Create Oracle Eloqua-Connected Applications in Appsmith
Connect to Oracle Eloqua Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Oracle Eloqua.
-
Visualize IBM Cloud Object Storage Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to IBM Cloud Object Storage.
-
Using the CData Software ODBC Driver for Dynamics 365 in PyCharm
Connect to Dynamics 365 as an ODBC data source in PyCharm using the CData Software ODBC Driver for Dynamics 365.
-
Building Dynamic Web Pages with Salesforce CRM Analytics Data Using AngularJS
Create single-page applications with live connectivity to Salesforce CRM Analytics using the CData API Server.
-
Connect Jira Assets to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Jira Assets using the CData Python MCP Server.
-
Load Procore Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Procore to a database.
-
Automated Continuous Email Replication to Oracle
Use CData Sync for automated, continuous, customizable Email replication to Oracle.
-
Build Data Flows from SQL Server to OData through SSIS
Easily push SQL Server data to OData using the CData SSIS Tasks for OData.
-
Connect to Pinecone from Asprova with CData Software ODBC Driver for Pinecone
This article shows how to connect faster to Pinecone data from Asprova.
-
How to Connect to Live Cosmos DB Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Azure Cosmos DB without replication.
-
Integrate Live Oracle Sales Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Analyze Shippo Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Shippo from Power Pivot. You will use the Table Import Wizard to load Shippo. You can visually build the import query or use any SQL supported by the driver.
-
Import Real-Time Customer.io Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Customer.io in ColdFusion.
-
Connect and Query Live NetSuite Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live NetSuite CRM & ERP into Databricks
-
Visualize CockroachDB Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to CockroachDB.
-
Build a PostgreSQL Interface for Databricks Data using the CData JDBC Driver
Use the Remoting features of the Databricks JDBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData Connect AI Python SDK for CockroachDB
Install the CData Connect AI Python SDK to read and write live CockroachDB with standard DB-API 2.0 Python code.
-
Replicate SendGrid Data in Heroku for Use in Salesforce Connect
Replicate SendGrid to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Connect to Live Azure Synapse Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Azure Synapse without replication.
-
Use the CData Software JDBC Driver for SAP SuccessFactors LMS in MicroStrategy Desktop
Connect to SAP SuccessFactors LMS in MicroStrategy Desktop using the CData Software JDBC Driver for SAP SuccessFactors LMS.
-
How to integrate Impala with Apache Airflow
Access and process Apache Impala in Apache Airflow using the CData JDBC Driver.
-
Publish Crystal Reports on Ontraport Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Ontraport.
-
Connect to HDFS from a Connection Pool in WebLogic
Use the CData JDBC Driver for HDFS to connect to Apache HDFS from Web applications running on WebLogic.
-
Deploy the ADO.NET Provider for Sage 300 on an SSRS Report Server
Connect to Sage 300 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.
-
How to Query Live MailChimp Data in Claude Desktop
Connect to and query live MailChimp Data in Claude Desktop using CData MCP Server.
-
Connecting Agentforce with SAP BusinessObjects BI 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 SAP BusinessObjects BI for you.
-
Integrating OpenCode Terminal with Aircall 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.
-
Perform Batch Operations with SharePoint Excel Services Data in Apache NiFi
Connect to SharePoint Excel Services and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Bidirectional Access to SQL Server Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Microsoft SQL Server in Filemaker Pro for Mac or Windows.
-
Build Semantic Layer Views for SAP Hybris C4C Data in APOS Live Data Gateway
Use the CData Connector for SAP Hybris C4C in APOS Live Data Gateway to build Semantic Layer Views for SAP Hybris C4C.
-
Use the CData ODBC Driver for SuiteCRM in Microsoft Power Query
You can use the CData SuiteCRM ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SuiteCRM into Microsoft Power Query.
-
Connect to and Query Wrike Data in QlikView over ODBC
Create data visualizations with Wrike in QlikView.
-
Access Live Yelp Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Yelp into the statistical analysis tools available in SAS JMP. This article shows how to use Yelp in the Graph Builder and Query Builder.
-
How to Visualize CloudConvert Data in Python with pandas
Use pandas and other modules to analyze and visualize live CloudConvert in Python.
-
LINQ to Microsoft Teams 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 Microsoft Teams Data Provider.
-
Connect to Sybase Data in Ruby
Connect to Sybase in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build a Singer.io Tap for Cohere With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Cohere data using
-
Replicate Chargebee Data from PowerShell
Write a quick PowerShell script to query Chargebee. Use connectivity to the live data to replicate Chargebee to SQL Server.
-
Work with Retently Data in FoxPro
Load Retently into a FoxPro database. This article includes full code and a walk-through of the process.
-
Rapidly Develop Bugsnag-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Bugsnag.
-
Integrating Bullhorn CRM Data in Talend Cloud Data Management Platform
Connect Bullhorn CRM Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Bullhorn CRM.
-
Connect to Phoenix Data in CloverDX (formerly CloverETL)
Transfer Apache Phoenix using the visual workflow in the CloverDX data integration tool.
-
Load Avalara AvaTax Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Avalara AvaTax to a database.
-
DataBind Charts to Zoho Books Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Zoho Books 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.
-
How to Work with SAP ByDesign Data in AWS Glue Jobs Using JDBC
Connect to SAP ByDesign from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Gong Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Gong and work with Gong in your FileMaker application.
-
A PostgreSQL Interface for Planio Data (MySQL Remoting via JDBC)
Use the Remoting features of the Planio JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Live Spark Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Apache Spark SQL without replication.
-
Excel Spreadsheet Automation on Klipfolio Data with the QUERY Formula
Pull data from Klipfolio, automate spreadsheets, and more with the QUERY formula.
-
Creating Adobe Analytics-Connected Applications in Unqork
You can use CData Connect AI to feed Adobe Analytics to Unqork and build custom business apps.
-
Connect to Float Data in DBArtisan
Use wizards in DBArtisan to configure Float as a data source.
-
Integrate Neo4J with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Neo4J with External Services.
-
Create Power BI Reports on Real-Time Zoho CRM Data
Use the CData ODBC Driver for Zoho CRM to visualize Zoho CRM in Power BI Desktop.
-
Getting Started with the CData Excel Add-In for CSV
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for CSV.
-
Automated Marketo Data Replication to Teradata
Use CData Sync to Customize and automate Marketo replication to Teradata.
-
Connect to Sage Intacct Data in DBeaver
Use the CData ODBC Driver to connect to Sage Intacct in DBeaver.
-
Bridge SFTP Connectivity with Apache NiFi
Access and process SFTP in Apache NiFi using the CData JDBC Driver.
-
Integrate SendInBlue with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SendInBlue with External Services.
-
Excel Spreadsheet Automation on eBay Data with the QUERY Formula
Pull data from eBay, automate spreadsheets, and more with the QUERY formula.
-
How to Connect to Live Oracle Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Oracle Database securely in real time.
-
Build Charts with Hugging Face Data in Clear Analytics
Create dynamic charts and perform analytics based on Hugging Face in Clear Analytics.
-
Automated Continuous Chargebee Replication to SingleStore
Use CData Sync for automated, continuous, customizable Chargebee replication to SingleStore.
-
How to integrate Metabase with Twitter Ads Data
Use CData Connect AI to connect to live Twitter Ads and create an interactive dashboard in Metabase from Twitter Ads.
-
Moving Data from ShipEngine to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live ShipEngine data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Establish a Live Connection with Tally Data using Tableau Bridge
The CData ODBC Driver for Tally enables you to integrate live Tally ERP into Tableau Cloud dashboards using the Tableau Bridge.
-
Import Real-Time SAP Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SAP ERP/NetWeaver in ColdFusion.
-
Extract, Transform, and Load Presto Data in Informatica PowerCenter
Create a simple Workflow for Presto in Informatica PowerCenter.
-
Create Informatica Mappings From/To a JDBC Data Source for Mixpanel
Create Mixpanel data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Visualize Live SAP Hybris C4C Data in the Power BI Service
Use CData Connect AI to connect to live SAP Hybris C4C and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate with QuickBooks Time Data in SnapLogic
Use CData Connect AI to connect to and integrate with live QuickBooks Time in SnapLogic.