CData Software - Knowledge Base
Recent Articles
-
Build ShipStation-Connected Apps in Choreo
Use CData Connect AI to connect to ShipStation Data from Choreo and build custom apps using live ShipStation.
-
Analyze DB2 Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of IBM DB2 and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Create Power BI Reports on Real-Time Recurly Data
Use the CData ODBC Driver for Recurly to visualize Recurly in Power BI Desktop.
-
Integrate with Unbounce Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Unbounce to a JSON file on disk.
-
Getting Started with the CData Power BI Connector for ZendeskSell
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Operational Reporting on Customer.io Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Customer.io.
-
How to Connect to Live Sugar CRM 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 Sugar CRM for you.
-
How to Connect DBeaver to Sage Cloud Accounting via a JDBC Driver
Manage Sage Business Cloud Accounting with visual tools in DBeaver like the query browser.
-
Visualize Vercel Data in TIBCO Spotfire through ADO.NET
Integrate Vercel into dashboards in TIBCO Spotfire.
-
Working with Clockify Data in LINQPad
Execute LINQ queries to Clockify in LINQPad.
-
Analyze CircleCI Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze CircleCI with the CData JDBC Driver for CircleCI.
-
Create Power BI Reports on Real-Time Google Tasks Data
Use the CData ODBC Driver for Google Tasks to visualize Google Tasks in Power BI Desktop.
-
Automated Continuous Excel Replication to MySQL
Use CData Sync for automated, continuous, customizable Excel replication to MySQL.
-
Build Procore Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Procore and build visualizations in Tableau Cloud.
-
Connect to Azure Table Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Azure Table as an External Source in Dremio.
-
Access Pinecone Data from MySQL in Amazon QuickSight
Connect to Pinecone and build visualizations of Pinecone using a MySQL Connection in Amazon QuickSight.
-
Getting Started with the CData Python Connector for Google Ad Manager
Learn to install and license the CData Python Connector
-
Connecting Agentforce with Oracle Financials Cloud 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 Oracle Financials Cloud for you.
-
Automated Continuous ZarMoney Replication to SQLite
Use CData Sync for automated, continuous, customizable ZarMoney replication to SQLite.
-
Integrate Cursor with Live Greenhouse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Greenhouse from within the editor.
-
Connect to Salesforce Marketing Data from HeidiSQL
Use CData Connect AI to connect to and query live Salesforce Marketing Cloud from HeidiSQL.
-
Getting Started with the CData ODBC Driver for DocuSign
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for DocuSign.
-
Automated Continuous Elorus Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Elorus replication to AlloyDB.
-
Create Informatica Mappings From/To a JDBC Data Source for Microsoft OneDrive
Create Microsoft OneDrive data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Add Amazon Athena Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Amazon Athena with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Cline with Live JSON Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live JSON from within your IDE.
-
Connect HCL Domino to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live HCL Domino using the CData Python MCP Server.
-
Lakebase Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Lakebase facts in real time.
-
How to import Coda Data into Apache Solr
Use the CData Software JDBC Driver for Coda in Data Import Handler and create an automated import of Coda to Apache Solr Enterprise Search platform.
-
Add Dynamics NAV Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Dynamics NAV with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use Manus AI to Talk to Your Twilio 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 Twilio.
-
Use Claude to Talk to Your Freshdesk 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 Freshdesk for you.
-
Create Dashboards and Visualize Live Zoho Creator Data in Geckoboard
Use CData Connect AI to connect to live Zoho Creator and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to Easily Query Adobe Analytics Data in OpenOffice Base
Connect to Adobe Analytics data in OpenOffice Base using the CData ODBC Driver for Adobe Analytics and generate reports with live data insights.
-
Edit and Search External Epicor Kinetic Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Epicor Kinetic to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Epicor Kinetic Data objects that you can access from apps and the dashboard.
-
Build Redshift-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Redshift to explore live Redshift Data in Gemini Code Assist to assist with building Redshift-powered applications.
-
Connect to Reply.io from a Connection Pool in WebLogic
Use the CData JDBC Driver for Reply.io to connect to Reply.io from Web applications running on WebLogic.
-
Build an OLAP Cube in SSAS from Printify Data
Establish a connection to Printify data from SQL Server Analysis Services, and use the Printify Data Provider to build OLAP cubes for use in analytics and reporting.
-
Access Dynamics 365 Business Central Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Dynamics 365 Business Central from your Oracle system.
-
Connect to MongoDB Data from a Connection Pool in Jetty
The MongoDB JDBC Driver supports connection pooling: This article shows how to connect faster to MongoDB from Web apps in Jetty.
-
Build a PostgreSQL Interface for Mixpanel Data using the CData JDBC Driver
Use the Remoting features of the Mixpanel JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automate SendGrid Data Replication to SAP HANA
Use CData Sync to customize and automate SendGrid replication to SAP HANA.
-
Import Highrise Data Using Azure Data Factory
Use CData Connect AI to connect to Highrise Data from Azure Data Factory and import live Highrise CRM.
-
Use the CData ODBC Driver for SingleStore in Microsoft Power Query
You can use the CData SingleStore ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SingleStore into Microsoft Power Query.
-
Integrate Live Databricks Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Databricks and integrate live Databricks into apps built in Microsoft Power Apps.
-
Integrating Dataiku with Highrise Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Highrise CRM.
-
Integrate HCL Domino Data in Pentaho Data Integration
Build ETL pipelines based on HCL Domino in the Pentaho Data Integration tool.
-
Build Apps with Live Billsby Data Using the Low-Code Development Platform of Mendix
Connect Billsby with Mendix to build apps using the CData API Driver for JDBC.
-
Building Dynamic Web Pages with SAP SuccessFactors Data Using AngularJS
Create single-page applications with live connectivity to SAP SuccessFactors using the CData API Server.
-
Analyze Salesloft Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Salesloft from Power Pivot. You will use the Table Import Wizard to load Salesloft. You can visually build the import query or use any SQL supported by the driver.
-
Access Bitbucket 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 Bitbucket.
-
Access Live Reply.io Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Reply.io into the statistical analysis tools available in SAS JMP. This article shows how to use Reply.io in the Graph Builder and Query Builder.
-
Build REST-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for REST to explore live REST Data in Gemini Code Assist to assist with building REST-powered applications.
-
Create Cvent-Connected Applications in Appsmith
Connect to Cvent Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Cvent.
-
Write a Simple Go Application to work with Impala Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Apache Impala.
-
DataBind Charts to Yelp Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Yelp 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 Connect to & Open xBase Data in Microsoft Excel
This article uses the CData ODBC driver for xBase to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Visualize Live MYOB AccountRight Data in the Power BI Service
Use CData Connect AI to connect to live MYOB AccountRight and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Query Couchbase Data as a SQL Server Database in Node.js
Execute SQL Server queries against Couchbase from Node.js.
-
Integrate Cursor with Live Quickbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Quickbase from within the editor.
-
Integrating LangGraph with Google Spanner Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Google Spanner within automated workflows.
-
Edit and Search LDAP External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of LDAP to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create LDAP objects that you can access from apps and the dashboard.
-
Automated Continuous MailChimp Replication to AlloyDB
Use CData Sync for automated, continuous, customizable MailChimp replication to AlloyDB.
-
Analyze Basecamp Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Basecamp and visualize live Basecamp in Infragistics Reveal.
-
Build Dashboards with BigQuery Data in Dundas BI
Create dynamic dashboards and perform analytics based on Google BigQuery in Dundas BI.
-
Integrating OpenCode Terminal with Sage Cloud Accounting 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.
-
Automate MarkLogic Integration Tasks from PowerShell
Are you in search of a quick and easy way to access MarkLogic from PowerShell? This article demonstrates how to utilize the MarkLogic Cmdlets for tasks like connecting to MarkLogic, automating operations, downloading data, and more.
-
Visualize Asana Data in TIBCO Spotfire through ADO.NET
Integrate Asana into dashboards in TIBCO Spotfire.
-
Create Omnisend Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Omnisend data access from reports, embedded analytics, and more.
-
Use the CData Software JDBC Driver for QuickBooks Time in MicroStrategy Web
Connect to QuickBooks Time in MicroStrategy Web using the CData Software JDBC Driver for QuickBooks Time.
-
Bridge Cosmos DB Connectivity with Apache NiFi
Access and process Azure Cosmos DB in Apache NiFi using the CData JDBC Driver.
-
Access ZohoMarketingHub Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access ZohoMarketingHub from your Oracle system.
-
Connect to Instagram Data in CloverDX (formerly CloverETL)
Transfer Instagram using the visual workflow in the CloverDX data integration tool.
-
Acumatica Reporting in OBIEE with the Acumatica JDBC Driver
Deploy the Acumatica JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connecting Mastra with Microsoft Planner 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 Microsoft Planner, no replication required.
-
Create Datasets from Apify in Domo Workbench and Build Visualizations of Apify Data in Domo
Use the CData Software ODBC Driver for Apify to create datasets from Apify in Domo Workbench and then build visualizations in the Domo service.
-
Use the CData Software ODBC Driver for Aweber in MicroStrategy
Connect to Aweber in MicroStrategy Developer using the CData Software ODBC Driver for Aweber.
-
Natively Connect to Supabase Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Supabase. Leverage the native support for ODBC in PHP.
-
Analyze Delighted Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Delighted from Power Pivot. You will use the Table Import Wizard to load Delighted. You can visually build the import query or use any SQL supported by the driver.
-
Integrate Shopify Data in Pentaho Data Integration
Build ETL pipelines based on Shopify in the Pentaho Data Integration tool.
-
Back Up FHIR to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for FHIR. In this article, we will employ an SSIS workflow to populate a database with FHIR data.
-
Build Visualizations of Opsgenie Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Opsgenie in Birst.
-
Access Live Mailjet Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Mailjet in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Apps with Live SAP Netweaver Gateway in Adalo using CData Connect AI
Use CData Connect AI to integrate live SAP Netweaver Gateway into the Adalo platform and build custom mobile and web applications with real-time SAP Netweaver Gateway.
-
How to load Parallel data into Elasticsearch via Logstash
Introducing a simple method to load Parallel data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build Pipelines with Live Microsoft Teams Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Microsoft Teams from Google Cloud Data Fusion, enabling the integration of live Microsoft Teams into the building and management of effective data pipelines.
-
How to Connect to ChargeOver Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to ChargeOver. Leverage the pyodbc module for ODBC in Python.
-
Query Sybase Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Sybase from Node.js.
-
Visualize OData Services in Tableau
The CData ODBC driver for OData enables you integrate OData into Tableau dashboards.
-
Analyze Quickbase Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Quickbase and visualize live Quickbase in Infragistics Reveal.
-
Analyze LionDesk Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze LionDesk with the CData JDBC Driver for LionDesk.
-
How to connect Amazon QuickSight to Kintone Data
Create a connection to Kintone in CData Connect AI and insert Kintone into Amazon QuickSight SPICE to build interactive dashboards.
-
Use JayDeBeApi to access Perigon Data in Python
Use standard Python scripting and the development environment of your choice to access live Perigon.
-
Analyze Redis Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Redis from Power Pivot. You will use the Table Import Wizard to load Redis. You can visually build the import query or use any SQL supported by the driver.
-
Use the CData ODBC Driver for Samanage from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Samanage to connect to Samanage from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Samanage in Excel.
-
Connect to ClickTime from Asprova with CData Software ODBC Driver for ClickTime
This article shows how to connect faster to ClickTime data from Asprova.
-
DataBind Controls to Pushbullet Data in Delphi
DataBind to Pushbullet in Delphi with standard data access components and controls.
-
Create Informatica Mappings From/To a JDBC Data Source for Telegram
Create Telegram data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrate Contentful with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Contentful with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Contentful.
-
Prepare, Blend, and Analyze Access Data in Alteryx Designer (ODBC)
Build workflows to access live Microsoft Access for self-service data analytics.