CData Software - Knowledge Base
Recent Articles
-
Prepare, Blend, and Analyze Oracle Service Cloud Data in Alteryx Designer (Connect AI)
Build workflows to access live Oracle Service Cloud data for self-service data analytics.
-
Build a Singer.io Tap for Sage Cloud Accounting With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Sage Cloud Accounting data using the CData Python Connector.
-
Use the CData Software ODBC Driver for eBay Analytics in MicroStrategy Web
Connect to eBay Analytics data in MicroStrategy Web using the CData Software ODBC Driver for eBay Analytics.
-
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 data from Informatica Cloud.
-
Build a PostgreSQL Interface for ServiceNow Data using the CData JDBC Driver
Use the Remoting features of the ServiceNow JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Humanity Replication to SQL Server
Use CData Sync for automated, continuous, customizable Humanity replication to SQL Server.
-
Build Charts with ZarMoney Data in Clear Analytics
Create dynamic charts and perform analytics based on ZarMoney data in Clear Analytics.
-
Enable the Power BI XMLA JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Power BI XMLA data.
-
Use the CData Software JDBC Driver for Active Directory in MicroStrategy Web
Connect to Active Directory data in MicroStrategy Web using the CData Software JDBC Driver for Active Directory.
-
Natively Connect to Excel Data in PHP
The CData ODBC driver for Excel enables you to create PHP applications with connectivity to Excel data. Leverage the native support for ODBC in PHP.
-
Query Live GraphQL Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live GraphQL data through a conversational interface.
-
Integrating Codex with Pipeline CRM 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.
-
Query CampaignMonitor Data as a MySQL Database in Node.js
Execute MySQL queries against CampaignMonitor data from Node.js.
-
Access Live Act-On Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Act-On data through MCP integration.
-
Automated Continuous Act CRM Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Act CRM data replication to OneLake in Microsoft Fabric.
-
Create a Data Access Object for BigCommerce Data using JDBI
A brief overview of creating a SQL Object API for BigCommerce data in JDBI.
-
Connect Miro to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Miro with IBM WebSphere for seamless data integration and connectivity.
-
Use Grok to Talk to Your ZohoDesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your ZohoDesk data for you.
-
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 Office 365 data.
-
How to Create Power BI Visual Reports with Real-Time Mistral AI Data
Use CData Power BI Connectors to visualize Mistral AI data in Power BI.
-
Integrate Printful with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Printful with External Services.
-
How to work with ZendeskSell Data in Apache Spark using SQL
Access and process ZendeskSell Data in Apache Spark using the CData Software JDBC Driver.
-
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.
-
How to Connect to Box Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Box data. Leverage the pyodbc module for ODBC in Python.
-
Connect to MarkLogic Data in RapidMiner
Integrate MarkLogic data with standard components and data source configuration wizards in RapidMiner Studio.
-
Getting Started with the CData SSIS Components for Mistral AI
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Mistral AI.
-
Connect to OData from a Connection Pool in WebLogic
Use the CData JDBC Driver for OData to connect to OData services from Web applications running on WebLogic.
-
Build Apps with Live Couchbase Data Using the Low-Code Development Platform of Mendix
Connect Couchbase data with Mendix to build apps using the CData JDBC Driver for Couchbase.
-
Access Live Clio Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Clio data into the statistical analysis tools available in SAS JMP. This article shows how to use Clio data in the Graph Builder and Query Builder.
-
Use Grok to Talk to Your Apollo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Apollo data for you.
-
How to Connect to Live Egnyte 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 Egnyte data for you.
-
Create Datasets from FormSite in Domo Workbench and Build Visualizations of FormSite Data in Domo
Use the CData Software ODBC Driver for FormSite to create datasets from FormSite data in Domo Workbench and then build visualizations in the Domo service.
-
Visualize ZeroBounce Data in TIBCO Spotfire through ADO.NET
Integrate ZeroBounce data into dashboards in TIBCO Spotfire.
-
Automated Zendesk Data Replication to Teradata
Use CData Sync to Customize and automate Zendesk data replication to Teradata.
-
Process & Analyze Postmark Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Postmark Data.
-
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 Procore Data in Jaspersoft Studio
Execute SQL to remote Procore data in Jaspersoft Studio.
-
Automated Continuous JSON Replication to Databricks
Use CData Sync for automated, continuous, customizable JSON replication to Databricks.
-
Use Claude to Talk to Your Vertica 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 Vertica data for you.
-
Integrate Real-Time Access to Google Analytics in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Google Analytics data in real time.
-
Connect and Query Live NetSuite Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live NetSuite data into Databricks and enable direct, live querying and analysis without replication.
-
Visualize Live Sage 200 Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Sage 200 data.
-
Connect to Microsoft Exchange Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Microsoft Exchange and the Script function in FileMaker Pro to connect to Microsoft Exchange and work with Microsoft Exchange data in your FileMaker application.
-
Automated Continuous PagerDuty Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable PagerDuty replication to Google Cloud SQL.
-
LINQ to Mailjet 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 Mailjet Data Provider.
-
Import Real-Time MailChimp Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use MailChimp data in ColdFusion.
-
Integrate Dify with Live DB2 Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live DB2 data.
-
Automated Continuous SAP Concur Replication to Snowflake
Use CData Sync for automated, continuous, customizable SAP Concur replication to Snowflake.
-
Access ZohoExpense Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access ZohoExpense data from your Oracle system.
-
Connect to HDFS from a Connection Pool in WebLogic
Use the CData JDBC Driver for HDFS to connect to HDFS data from Web applications running on WebLogic.
-
Moving Data from PayPal to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live PayPal data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Seamlessly Bring Sage 200 Data into Retool Using CData Connect AI
Integrate Sage 200 data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to Connect to Mouseflow Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Mouseflow data. Leverage the pyodbc module for ODBC in Python.
-
Excel Spreadsheet Automation on Parallel Data with the QUERY Formula
Pull data from Parallel, automate spreadsheets, and more with the QUERY formula.
-
ETL Gong in Oracle Data Integrator
This article shows how to transfer Gong data into a data warehouse using Oracle Data Integrator.
-
Connect to Real-Time ElevenLabs Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use ElevenLabs data in Power Apps.
-
Bidirectional Access to SQL Server Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SQL Server data in Filemaker Pro for Mac or Windows.
-
Connect to Cohere Data in RapidMiner
Integrate Cohere data with standard components and data source configuration wizards in RapidMiner Studio.
-
Visualize Wave Financial Data in Sisense
Create an ElastiCube in Sisense app with access to Wave Financial data.
-
Build Dashboards with Procore Data in DBxtra
Create dynamic dashboards and perform analytics based on Procore data in DBxtra.
-
Automate Azure Data Catalog Data Replication to Azure Synapse
Use CData Sync to customize and automate Azure Data Catalog data replication to Azure Synapse.
-
Import Real-Time Tally Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Tally data in ColdFusion.
-
How to connect to Sybase IQ Data from IntelliJ
Integrate connectivity to Sybase IQ data with wizards in IntelliJ.
-
Automated Continuous Float Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Float replication to Apache Cassandra.
-
Build Epicor Kinetic-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Epicor Kinetic data.
-
Integrate Trae with Live SAP Netweaver Gateway Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live SAP Netweaver Gateway data from within the AI-powered IDE.
-
Connect to Azure Table Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Azure Table data in Airbyte.
-
Moving Data from HubDB to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live HubDB data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Use the CData ODBC Driver for Front in Microsoft Power Query
You can use the CData Front ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Front data into Microsoft Power Query.
-
Integrating OpenCode with GitLab 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.
-
Build Agents in Relevance AI with Access to Live Sybase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Sybase data within intelligent agent workflows.
-
Import and Visualize ClickUp Data in Power View
Create data visualizations based on ClickUp data in Excel.
-
How to load Opsgenie data into Elasticsearch via Logstash
Introducing a simple method to load Opsgenie data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Getting Started with the CData Tableau Connector for Databricks
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Databricks.
-
Build Voice Agents in ElevenLabs with access to Live Sybase IQ Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Sybase IQ data.
-
Connect to SAP SuccessFactors LMS Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for SAP SuccessFactors LMS and the Script function in FileMaker Pro to connect to SAP SuccessFactors LMS and work with SAP SuccessFactors LMS data in your FileMaker application.
-
How to create an RPA flow for Xero Data in UiPath Studio
Use the Xero ODBC Driver to create workflows that access real-time Xero data without any coding.
-
Build Semantic Layer Views for Google Spanner Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Google Spanner data.
-
DataBind Charts to Zoho Books Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Zoho Books data 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.
-
Process & Analyze Close Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Close Data.
-
Integrate ZohoPeople with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate ZohoPeople with External Services.
-
Integrate Freshdesk with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Freshdesk with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Freshdesk data.
-
Connect to Gorgias Data from a Connection Pool in Jetty
The Gorgias JDBC Driver supports connection pooling: This article shows how to connect faster to Gorgias data from Web apps in Jetty.
-
How to load Avalara AvaTax data into Elasticsearch via Logstash
Introducing a simple method to load Avalara AvaTax data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Salesforce Marketing Data from PowerBuilder via JDBC
This article demonstrates how to access Salesforce Marketing data from PowerBuilder using the Salesforce Marketing JDBC Driver.
-
How to Visualize BambooHR Data in Python with pandas
Use pandas and other modules to analyze and visualize live BambooHR data in Python.
-
Getting Started with the CData JDBC Driver for Autopilot
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Autopilot.
-
Getting Started with the CData JDBC Driver for SAP Business One
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SAP Business One.
-
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.
-
How to Access RabbitMQ Data Using Entity Framework
This article shows how to access RabbitMQ data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrate with Retently Data in JReport Designer
Create charts and reports based on Retently data in JReport Designer.
-
Connect to Mouseflow Data in DBArtisan
Use wizards in DBArtisan to configure Mouseflow data as a data source.
-
Natively Connect to Codat Data in PHP
The CData ODBC driver for Codat enables you to create PHP applications with connectivity to Codat data. Leverage the native support for ODBC in PHP.
-
Import Real-Time Facebook Ads Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Facebook Ads data in ColdFusion.
-
Azure Data Catalog Reporting in OBIEE with the Azure Data Catalog JDBC Driver
Deploy the Azure Data Catalog JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to integrate Metabase with Twitter Ads Data
Use CData Connect AI to connect to live Twitter Ads data and create an interactive dashboard in Metabase from Twitter Ads data.
-
Query Live Zoho CRM Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Zoho CRM data directly from the development environment.
-
Use Azure AI Foundry to Talk to Your Mode 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 Mode data for you.
-
Intercom Reporting in OBIEE with the Intercom JDBC Driver
Deploy the Intercom JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Access Live CockroachDB Data in Power Automate Desktop via ODBC
The CData ODBC Driver for CockroachDB enables you to integrate CockroachDB data into workflows built using Microsoft Power Automate Desktop.