CData Software - Knowledge Base
Recent Articles
-
Query EnterpriseDB Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume EnterpriseDB entities in PHP by modeling them as objects.
-
Prepare, Blend, and Analyze Coda Data in Alteryx Designer (ODBC)
Build workflows to access live Coda for self-service data analytics.
-
Build a PostgreSQL Interface for Oracle Financials Cloud Data using the CData JDBC Driver
Use the Remoting features of the Oracle Financials Cloud JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Avro
Provide connectivity to Apache Avro through an SAP BusinessObjects universe.
-
How to Import Data from SuiteCRM into Google Sheets
Import SuiteCRM into a Google spreadsheet that is automatically refreshed.
-
Replicate MYOB AccountRight Data to Multiple Databases
Replicate MYOB AccountRight to disparate databases with a point-and-click configuration.
-
Build Dashboards with SingleStore Data in DBxtra
Create dynamic dashboards and perform analytics based on SingleStore in DBxtra.
-
How to Connect to Live Twilio 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 Twilio through natural language.
-
Create Monday.com Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Monday.com from PowerBI.com to create Power BI Dataflows with real-time data.
-
Rapidly Develop Contentful-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 Contentful.
-
Analyze SAP Business One Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of SAP Business One and visualize live SAP Business One in Infragistics Reveal.
-
How to Work with ChartMogul Data in ETL Validator JDBC
Connect to ChartMogul from ETL Validator jobs using the CData Software JDBC Driver.
-
Automate ZohoExpense Data Replication to Azure Data Lake
Use CData Sync to customize and automate ZohoExpense replication to Azure Data Lake.
-
How to Connect DBeaver to Microsoft Ads via a JDBC Driver
Manage Microsoft Ads with visual tools in DBeaver like the query browser.
-
Replicate Mixpanel Data from PowerShell
Write a quick PowerShell script to query Mixpanel. Use connectivity to the live data to replicate Mixpanel to SQL Server.
-
Create Data Visualizations Based On Act CRM Data in Mode
Use CData Connect AI to connect to Act CRM Data from Mode and build visualizations using live
-
Automate Datadog Data Replication to Couchbase
Use CData Sync to Customize and automate Datadog replication to Couchbase.
-
Build Voice Agents in ElevenLabs with access to Live LinkedIn Ads Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live LinkedIn Ads.
-
Integrate OneNote Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Microsoft OneNote and integrate live Microsoft OneNote into your Power Automate tasks.
-
Access Live GitLab Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live GitLab from your Excel spreadsheets.
-
Integrating Dataiku with Google Campaign Manager 360 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Google Campaign Manager 360.
-
Automate Customer.io Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Customer.io from PowerShell? This article demonstrates how to utilize the Customer.io Cmdlets for tasks like connecting to Customer.io, automating operations, downloading data, and more.
-
How to use SQLAlchemy ORM to access Zoho Inventory Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Zoho Inventory.
-
Integrate Real-Time Access to Reckon in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Reckon in real time.
-
Analyze Gorgias Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Gorgias with the CData JDBC Driver for Gorgias.
-
Analyze Neo4J Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Neo4J and visualize live Neo4J in Infragistics Reveal.
-
Getting Started with the CData ODBC Driver for SAP HANA
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SAP HANA.
-
Integrating Claude Code CLI with Facebook 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.
-
How to publish and share Opsgenie Data dashboards with Tableau Server
The CData ODBC driver for Opsgenie enables you integrate Opsgenie into Tableau dashboards.
-
Connect Mailgun to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Mailgun using the CData Python MCP Server.
-
Build LDAP-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for LDAP to explore live LDAP Objects in Cursor to assist with building LDAP-powered applications.
-
Integrate Cline with Live Authorize.Net Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Authorize.Net from within your IDE.
-
Integrating Antigravity CLI with NASA via CData CLI
Connect NASA to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Stream Confluence Data into Apache Kafka Topics
Access and stream Atlassian Confluence in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate Planio Data in the Pentaho Report Designer
Publish reports based on Planio in the Pentaho BI tool.
-
Automated Continuous Optimizely Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Optimizely replication to delimited files (CSV/TSV).
-
Create Power BI Reports on Real-Time SQL Analysis Services Data
Use the CData ODBC Driver for SQL Analysis Services to visualize SQL Analysis Services in Power BI Desktop.
-
Integrate Open WebUI with Live Azure Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Azure Analysis Services from within the chat interface.
-
Enable the Databricks JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Databricks.
-
DataBind PostgreSQL Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for PostgreSQL with the DevExpress Windows Forms and Web controls to provide PostgreSQL to a chart.
-
Add JDBC-ODBC Bridge Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for JDBC-ODBC Bridge with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous SAP Ariba Source Replication to SQL Server
Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to SQL Server.
-
Build Apps with Live Parallel Data Using the Low-Code Development Platform of Mendix
Connect Parallel with Mendix to build apps using the CData API Driver for JDBC.
-
Build Automated Office 365-Connected Workflows in Zapier
Use CData Connect AI to connect to live Microsoft Office 365 and build automated workflows in Zapier.
-
Build a Singer.io Tap for Telegram With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Telegram data using
-
Consume Microsoft Exchange OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Microsoft Exchange feeds that reflect any changes in SAP Lumira.
-
Build Automated Databricks-Connected Workflows in Zapier
Use CData Connect AI to connect to live Databricks and build automated workflows in Zapier.
-
Getting Started with the CData Power BI Connector for SendInBlue
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Access Zoho Projects Data from MySQL in PHP
Connect to Zoho Projects through the standard MySQL libraries in PHP.
-
Build Google Search-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Google Search to explore live Google Search Results in Gemini Code Assist to assist with building Google Search-powered applications.
-
Integrating Codex CLI with Exact Online 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 the CData Software ODBC Driver for Testmonitor in SAS for Real-Time Reporting and Analytics
Connect to real-time Testmonitor in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Testmonitor.
-
Integrate Live Reckon Accounts Hosted Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Reckon Accounts Hosted from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Reckon Accounts Hosted.
-
Use CData Connect AI to Access Okta Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Okta in the Power Pivot business intelligence tool.
-
Build Billsby-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live Billsby Data in Claude Code to assist with building Billsby-powered applications.
-
Use the CData Software ODBC Driver for SAP HANA in MicroStrategy Desktop
Connect to SAP HANA in MicroStrategy Desktop using the CData Software ODBC Driver for SAP HANA.
-
Bridge Exa Connectivity with Apache NiFi
Access and process Exa in Apache NiFi using the CData JDBC Driver.
-
How to Connect to Webex Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Webex. Leverage the pyodbc module for ODBC in Python.
-
How to Work with Coda Data in AWS Glue Jobs Using JDBC
Connect to Coda from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Process & Analyze Miro Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Miro Data.
-
How to integrate Metabase with Kintone Data
Use CData Connect AI to connect to live Kintone and create an interactive dashboard in Metabase from Kintone.
-
Connect to Real-Time Bitbucket Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Bitbucket and Dataflow to import and use Bitbucket in Power Apps.
-
How to Connect to Live BigQuery 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 Google BigQuery through natural language.
-
How to Connect Flowise AI Agents to Live Oracle Financials Cloud Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Oracle Financials Cloud without replication.
-
Connect Oracle Financials Cloud to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Oracle Financials Cloud with IBM WebSphere for seamless data integration and connectivity.
-
Connect and Query Live Microsoft Ads Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Microsoft Ads into Databricks
-
Access Amazon Athena Data from MySQL in PHP
Connect to Amazon Athena through the standard MySQL libraries in PHP.
-
Build AI/ML Models with Live Twilio Data using Dataiku
Connect Twilio Data with Dataiku using the CData JDBC Driver for Twilio.
-
Build Charts with Quickbase Data in Clear Analytics
Create dynamic charts and perform analytics based on Quickbase in Clear Analytics.
-
Import and Visualize SAP Fieldglass Data in Power View
Create data visualizations based on SAP Fieldglass in Excel.
-
Access Live Productboard Data in TIBCO Data Virtualization
Use the CData API Driver for Tibco DV to create a Productboard data source in TIBCO Data Virtualization Studio and gain access to live Productboard from your TDV Server.
-
Analyze Mailgun Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Mailgun in Microsoft R Open.
-
How to Connect to Live Freshservice Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Freshservice for you.
-
Query Drift Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Drift entities in PHP by modeling them as objects.
-
Getting Started with the CData SSIS Components for Adobe Commerce
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Adobe Commerce.
-
View Reports on Real-Time Amazon DynamoDB Data in Power BI Report Server
Use the CData ODBC Driver for Amazon DynamoDB to visualize Amazon DynamoDB in Power BI Desktop and then publish them to Power BI Report Server.
-
Publish Databricks-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Databricks.
-
Load Okta Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Okta to a database.
-
Access Live Dynamics 365 Business Central Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Dynamics 365 Business Central in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Sage 200 Data in Claris FileMaker Pro
Use the CData ODBC Driver for Sage 200 in FileMaker Pro to connect to Sage 200 and work with Sage 200 in your FileMaker applications.
-
Configure the CData JDBC Driver for CockroachDB in a Connection Pool in Tomcat
Connect to CockroachDB from a connection pool in Tomcat.
-
How to connect PolyBase to Teradata
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Teradata.
-
Connect to Redis Data in CloverDX (formerly CloverETL)
Transfer Redis using the visual workflow in the CloverDX data integration tool.
-
Connect to Salesforce CRM Analytics Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Salesforce CRM Analytics.
-
Bridge Pushbullet Connectivity with Apache NiFi
Access and process Pushbullet in Apache NiFi using the CData JDBC Driver.
-
Replicate Tally Data in Heroku for Use in Salesforce Connect
Replicate Tally ERP to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to publish and share ADP Data dashboards with Tableau Server
The CData ODBC driver for ADP enables you integrate ADP into Tableau dashboards.
-
Build Semantic Layer Views for Google Directory Data in APOS Live Data Gateway
Use the CData Connector for Google Directory in APOS Live Data Gateway to build Semantic Layer Views for Google Directory.
-
Bridge HCL Domino Connectivity with Apache NiFi
Access and process HCL Domino in Apache NiFi using the CData JDBC Driver.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Printify
Provide connectivity to Printify through an SAP BusinessObjects universe.
-
How to import SAP Concur Data into Apache Solr
Use the CData Software JDBC Driver for SAP Concur in Data Import Handler and create an automated import of SAP Concur to Apache Solr Enterprise Search platform.
-
How to Seamlessly Import Outreach.io Data into IBM SPSS Modeler
Integrate Outreach.io data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Delighted Data in HULFT Integrate
Connect to Delighted as a JDBC data source in HULFT Integrate
-
Create Yelp Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Yelp data access from reports, embedded analytics, and more.
-
Create Data Visualizations in Cognos BI with Sybase Data
Access Sybase as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create Dynamic XML Grids Using the Infragistics XamDataGrid
Learn how you can connect XML to Infragistics XamDataGrid to build dynamic grids.
-
Connecting Moonlit Workflow with Adobe Analytics Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Adobe Analytics in real time.
-
Integrate Mailjet with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Mailjet with External Services.
-
Integrating GitHub Copilot CLI with Nethunt 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.
-
Visualize Trello Data in Sisense
Create an ElastiCube in Sisense app with access to Trello.