CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Zoho Creator Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Zoho Creator replication to IBM DB2.
-
Getting Started with the CData ADO.NET Provider for JSON
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for JSON.
-
Use the CData Software JDBC Driver for Spark in MicroStrategy Web
Connect to Spark data in MicroStrategy Web using the CData Software JDBC Driver for Spark.
-
How to Work with Zendesk Data in ETL Validator JDBC
Connect to Zendesk from ETL Validator jobs using the CData Software JDBC Driver.
-
Use the CData Software JDBC Driver for Aircall in MicroStrategy Desktop
Connect to Aircall data in MicroStrategy Desktop using the CData Software JDBC Driver for Aircall.
-
Integrate Live Hugging Face Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Hugging Face data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Prepare, Blend, and Analyze Greenplum Data in Alteryx Designer (Connect AI)
Build workflows to access live Greenplum data for self-service data analytics.
-
Getting Started with the CData JDBC Driver for Missive
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Missive.
-
Use the CData ODBC Driver for Microsoft OneDrive in Microsoft Power Query
You can use the CData Microsoft OneDrive ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Microsoft OneDrive data into Microsoft Power Query.
-
Automated Continuous Parallel Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Parallel replication to Amazon Redshift.
-
Connect CockroachDB to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live CockroachDB data using the CData Python MCP Server.
-
Create a Data Access Object for CapsuleCRM Data using JDBI
A brief overview of creating a SQL Object API for CapsuleCRM data in JDBI.
-
Getting Started with the CData Power BI Connector for CircleCI
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Getting Started with the CData ODBC Driver for Pingdom
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Pingdom.
-
Analyze Splunk Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Splunk from Power Pivot. You will use the Table Import Wizard to load Splunk data. You can visually build the import query or use any SQL supported by the driver.
-
How to connect to PagerDuty Data from Spring Boot
Connect to PagerDuty in a Spring Boot Application using the CData API Driver for JDBC
-
Query Elasticsearch Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Elasticsearch entities in PHP by modeling them as objects.
-
Automated Continuous SAP HANA Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SAP HANA replication to PostgreSQL.
-
Integrate OpenCode with Live GitLab Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live GitLab data from within your AI coding agent.
-
Build Agents in Relevance AI with Access to Live Adobe Experience Manager Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Adobe Experience Manager data within intelligent agent workflows.
-
Connect to Quickbase Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Quickbase data in Airbyte.
-
Analyze HDFS Data in Looker
Use CData Connect AI to connect to HDFS Data from Looker and build custom apps using live HDFS data.
-
Getting Started with the CData Power BI Connector for ZarMoney
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to Connect to Live AgileCRM Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your AgileCRM data for you.
-
Access Live Amazon Athena Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Amazon Athena data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Create MongoDB-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to MongoDB Data from OutSystems and build custom enterprise apps using live MongoDB data.
-
Build Charts with WooCommerce Data in Clear Analytics
Create dynamic charts and perform analytics based on WooCommerce data in Clear Analytics.
-
Automated Continuous SharePoint Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SharePoint data replication to OneLake in Microsoft Fabric.
-
Connect to Flowlu from Asprova with CData Software ODBC Driver for Flowlu
This article shows how to connect faster to Flowlu data from Asprova.
-
Create Data Visualizations Based On Shippo Data in Mode
Use CData Connect AI to connect to Shippo Data from Mode and build visualizations using live Shippo data.
-
How to Work with SharePoint Data in AWS Glue Jobs Using JDBC
Connect to SharePoint from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Publish Reports with Apollo Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Apollo data.
-
Use the CData Software ODBC Driver for Workday in MicroStrategy
Connect to Workday data in MicroStrategy Developer using the CData Software ODBC Driver for Workday.
-
Connecting Mastra with Twilio 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 Twilio data, no replication required.
-
Integrate Live Microsoft Exchange Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Microsoft Exchange data to Blue Prism using the CData ODBC Driver for Microsoft Exchange to create automated workflows for repetitive business tasks.
-
Query Unbounce Data in DataGrip
Create a Data Source for Unbounce in DataGrip and use SQL to query live Unbounce data.
-
Use the CData Software JDBC Driver for Zoom in MicroStrategy
Connect to Zoom data in MicroStrategy Developer using the CData Software JDBC Driver for Zoom.
-
Connect and Query Live Jira Assets Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Jira Assets data into Databricks and enable direct, live querying and analysis without replication.
-
Connecting Pipedream with AlloyDB 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 AlloyDB data in real time.
-
Use the CData Software ODBC Driver for MariaDB in MicroStrategy Web
Connect to MariaDB data in MicroStrategy Web using the CData Software ODBC Driver for MariaDB.
-
Build a PostgreSQL Interface for FreshBooks Data using the CData JDBC Driver
Use the Remoting features of the FreshBooks JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live PostgreSQL Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live PostgreSQL data from your Excel spreadsheets.
-
How to Connect to & Open Sage Cloud Accounting Data in Microsoft Excel
This article uses the CData ODBC driver for Sage Cloud Accounting to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrating LlamaIndex with Discord Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Discord data in real time.
-
Build Microsoft Ads-Connected Apps in Choreo
Use CData Connect AI to connect to Microsoft Ads Data from Choreo and build custom apps using live Microsoft Ads data.
-
How to work with SAS xpt Data in Apache Spark using SQL
Access and process SAS xpt Data in Apache Spark using the CData Software JDBC Driver.
-
Getting Started with the CData Tableau Connector for Elorus
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Getting Started with the CData Power BI Connector for Marketo
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Marketo.
-
Automated Continuous PostgreSQL Replication to Snowflake
Use CData Sync for automated, continuous, customizable PostgreSQL replication to Snowflake.
-
Build Microsoft Teams-Connected Apps in Choreo
Use CData Connect AI to connect to Microsoft Teams Data from Choreo and build custom apps using live Microsoft Teams data.
-
Getting Started with the CData JDBC Driver for ConvertAPI
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for ConvertAPI.
-
How to Create Power BI Visual Reports with Real-Time SAP HANA Data
Use CData Power BI Connectors to visualize SAP HANA data in Power BI.
-
How to Access Microsoft Ads Data Using Entity Framework
This article shows how to access Microsoft Ads data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Analyze Pipeliner CRM Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Pipeliner CRM from Power Pivot. You will use the Table Import Wizard to load Pipeliner CRM data. You can visually build the import query or use any SQL supported by the driver.
-
Analyze SAP Hybris C4C Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of SAP Hybris C4C data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to RSS Feeds in RapidMiner
Integrate RSS feeds with standard components and data source configuration wizards in RapidMiner Studio.
-
Build Automated SharePoint-Connected Workflows in Zapier
Use CData Connect AI to connect to live SharePoint data and build automated workflows in Zapier.
-
Visualize Live Microsoft Entra ID Data in the Power BI Service
Use CData Connect AI to connect to live Microsoft Entra ID data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Accelo 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 Accelo and work with Accelo data in your FileMaker application.
-
Natively Connect to FHIR Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to FHIR data. Leverage the native support for ODBC in PHP.
-
Integrate with ZarMoney Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ZarMoney data to a JSON file on disk.
-
Visualize Live Salesforce Marketing Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Salesforce Marketing data into custom reports in Power BI.
-
Build an OLAP Cube in SSAS from Simplesat Data
Establish a connection to Simplesat data data from SQL Server Analysis Services, and use the Simplesat Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to connect to MailerLite Data with Squirrel SQL client
Connect to MailerLite data and execute queries in the Squirrel SQL Client.
-
Integrating Kiro with ServiceNow 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.
-
Use Microsoft Copilot Studio to talk to your Monday.com Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Monday.com data for you.
-
Add Notion Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Notion with the Informatica Enterprise Data Catalog to classify and organize data.
-
Query MongoDB Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume MongoDB entities in PHP by modeling them as objects.
-
Automate Stack Exchange Data Replication to Azure Synapse
Use CData Sync to customize and automate Stack Exchange data replication to Azure Synapse.
-
Query ZohoDesk Data in ColdFusion
Write standard ColdFusion data access code to connect to ZohoDesk data.
-
Access Live Google Drive Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Google Drive data through MCP integration.
-
Access Live Google Ads Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Google Ads data through MCP integration.
-
Analyze Zoho Creator Data in Looker
Use CData Connect AI to connect to Zoho Creator Data from Looker and build custom apps using live Zoho Creator data.
-
Automate Klaviyo Data Replication to SAP HANA
Use CData Sync to customize and automate Klaviyo data replication to SAP HANA.
-
Analyze Sage 300 Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Sage 300 data and visualize live Sage 300 data in Infragistics Reveal.
-
Easily Integrate Monday.com Data in Lazarus Pascal IDE
Learn how to easily integrate live Monday.com data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Testmonitor Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Testmonitor as an External Source in Dremio.
-
A PostgreSQL Interface for Apify Data (MySQL Remoting via JDBC)
Use the Remoting features of the Apify JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Query Printify Data in MySQL Workbench
Execute MySQL queries against live Printify data from MySQL Workbench.
-
Use the CData Software ODBC Driver for Google Campaign Manager 360 in SAS for Real-Time Reporting and Analytics
Connect to real-time Google Campaign Manager 360 data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Google Campaign Manager 360.
-
Replicate Multiple Timely Accounts
Replicate multiple Timely accounts to one or many databases.
-
Create Bannerbear-Connected Nintex Workflows
Use CData Connect AI to connect to Bannerbear Data from Nintex Workflow Cloud and build custom workflows using live Bannerbear data.
-
Connect to Printify Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Printify data.
-
Use the CData Software ODBC Driver for Parquet in MicroStrategy Desktop
Connect to Parquet data in MicroStrategy Desktop using the CData Software ODBC Driver for Parquet.
-
Build Dashboards with CircleCI Data in DBxtra
Create dynamic dashboards and perform analytics based on CircleCI data in DBxtra.
-
Excel Spreadsheet Automation on Close Data with the QUERY Formula
Pull data from Close, automate spreadsheets, and more with the QUERY formula.
-
How to connect SharePoint with MySQL Data through external lists
Provide MySQL data to SharePoint users as an external list.
-
Build Freshteam-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Freshteam data.
-
Create Oracle Sales Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Oracle Sales from PowerBI.com to create Power BI Dataflows with real-time data.
-
Access Live EnterpriseDB Data in Excel 365 Online (Excel for the web)
Connect to EnterpriseDB data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Automated Continuous Confluence Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Confluence replication to AlloyDB.
-
Connect to Phoenix Data in RazorSQL
Connect to Phoenix from wizards and query Phoenix data from the GUI in the RazorSQL database management tool.
-
How to load Paylocity data into Elasticsearch via Logstash
Introducing a simple method to load Paylocity data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Analyze Microsoft Ads Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Microsoft Ads data with the CData JDBC Driver for Microsoft Ads.
-
How to import Testmonitor Data into Apache Solr
Use the CData Software JDBC Driver for Testmonitor in Data Import Handler and create an automated import of Testmonitor data to Apache Solr Enterprise Search platform.
-
Getting Started with the CData Python Connector for HelloSign
Learn to install and license the CData Python Connector and configure a connection to live HelloSign data.
-
Automated Continuous Wistia Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Wistia replication to Google BigQuery.
-
How to connect and process Oracle Eloqua data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Oracle Eloqua data.
-
Replicate Multiple MariaDB Accounts via the CData Sync CLI
Replicate multiple MariaDB accounts to one or many databases.
-
Connect to Parallel Data in CloverDX (formerly CloverETL)
Transfer Parallel data using the visual workflow in the CloverDX data integration tool.