CData Software - Knowledge Base
Recent Articles
-
How to Connect the Power BI Service to Tanda: Complete Guide
Connect to the CData Software Power BI Connector for Tanda from PowerBI.com to provide real-time Tanda data across the organization.
-
Process & Analyze Zuora Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Zuora Data.
-
Use Dash to Build to Web Apps on Aha! Data
Create Python applications that use pandas and Dash to build Aha!-connected web apps.
-
Query Hacker News Data as a MySQL Database in Node.js
Execute MySQL queries against Hacker News data from Node.js.
-
Integrating Claude Code with ShipStation Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on ShipStation data within assisted coding and automated development workflows.
-
Use the CData Software ODBC Driver for Templated in MicroStrategy Web
Connect to Templated data in MicroStrategy Web using the CData Software ODBC Driver for Templated.
-
Build a PostgreSQL Interface for Workable Data using the CData JDBC Driver
Use the Remoting features of the Workable JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Stripe Data from AWS Glue
Use CData Connect AI to gain access to live Stripe data from your AWS Glue jobs.
-
Use Azure AI Foundry to Talk to Your Azure Data Catalog 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 Azure Data Catalog data for you.
-
Build an OLAP Cube in SSAS from Snapchat Ads Data
Establish a connection to Snapchat Ads data data from SQL Server Analysis Services, and use the Snapchat Ads Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Connect to Live Wave Financial Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Wave Financial data securely in real time.
-
How to connect to SAP Ariba Source Data from IntelliJ
Integrate connectivity to SAP Ariba Source data with wizards in IntelliJ.
-
Connect to Adobe Experience Manager Data in Claris FileMaker Pro
Use the CData ODBC Driver for Adobe Experience Manager in FileMaker Pro to connect to Adobe Experience Manager and work with Adobe Experience Manager data in your FileMaker applications.
-
Connect and Visualize Live Google Spanner Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Google Spanner data into the Databricks platform and create visualization dashboards with real-time Google Spanner data.
-
Access GraphQL Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live GraphQL data from HeidiSQL.
-
Connect to Yelp in SpagoBI
Create reports featuring live Yelp data in SpagoBI Studio. Host Yelp reports on SpagoBI Server.
-
Add IBM Informix Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for IBM Informix with the Informatica Enterprise Data Catalog to classify and organize data.
-
Migrating data from Lakebase to Snowflake using CData SSIS Components.
Easily push Lakebase data to Snowflake using the CData SSIS Tasks for Lakebase and Snowflake.
-
Connecting GenSpark with Google Directory Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Google Directory data without any replication or custom integration required.
-
Publish Zoho CRM-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Zoho CRM data.
-
Connect to OneNote Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for OneNote data.
-
Analyze Anaplan Data in Looker
Use CData Connect AI to connect to Anaplan Data from Looker and build custom apps using live Anaplan data.
-
Build Voice Agents in ElevenLabs with access to Live GitLab Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live GitLab data.
-
Deploy the ADO.NET Provider for SAS Data Sets on an SSRS Report Server
Connect to SAS Data Sets data 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.
-
Connect to SAP Ariba Procurement from a Connection Pool in WebLogic
Use the CData JDBC Driver for SAP Ariba Procurement to connect to SAP Ariba Procurement data from Web applications running on WebLogic.
-
Connect to and Query Oracle Service Cloud Data in QlikView over ODBC
Create data visualizations with Oracle Service Cloud data in QlikView.
-
Integrate ZohoExpense with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate ZohoExpense with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to ZohoExpense data.
-
Automated Continuous Vercel Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Vercel replication to AlloyDB.
-
Create Dynamic ZarMoney Grids Using the Infragistics XamDataGrid
Learn how you can connect ZarMoney to Infragistics XamDataGrid to build dynamic grids.
-
Getting Started with the CData Excel Add-In for ServiceDesk Plus
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for ServiceDesk Plus.
-
Automated Continuous Everhour Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Everhour replication to Azure SQL Database.
-
Create Data Visualizations in Cognos BI with JSON Services
Access JSON services as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Use the CData Software ODBC Driver for Blackbaud FE NXT in MicroStrategy Web
Connect to Blackbaud FE NXT data in MicroStrategy Web using the CData Software ODBC Driver for Blackbaud FE NXT.
-
Automate Active Directory Data Replication to Azure Data Lake
Use CData Sync to customize and automate Active Directory data replication to Azure Data Lake.
-
How to Easily Query Recurly Data in OpenOffice Base
Connect to Recurly data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect and Visualize Live SharePoint Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live SharePoint data into the Databricks platform and create visualization dashboards with real-time SharePoint data.
-
Connect to Splunk Data in DBeaver
Use the CData ODBC Driver to connect to Splunk data in DBeaver.
-
Build an OLAP Cube in SSAS from Salesforce Pardot Data
Establish a connection to Salesforce Pardot data data from SQL Server Analysis Services, and use the Salesforce Pardot Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Connect to Live Hive 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 Hive data for you.
-
Use Azure AI Foundry to Talk to Your Supabase 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 Supabase data for you.
-
Seamlessly Bring Bitbucket Data into Retool Using CData Connect AI
Integrate Bitbucket data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Publish QuickBooks Time-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live QuickBooks Time data.
-
Build AI Agents with FreshBooks Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live FreshBooks data through CData Connect AI.
-
Connect to SAS Data Sets Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for SAS Data Sets and the Script function in FileMaker Pro to connect to SAS Data Sets and work with SAS Data Sets data in your FileMaker application.
-
Extract, Transform, and Load SAP HANA Data in Informatica PowerCenter
Create a simple Workflow for SAP HANA data in Informatica PowerCenter.
-
Integrating Antigravity CLI with Opsgenie data via CData CLI
Connect Opsgenie data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
A PostgreSQL Interface for MailerLite Data using the CData ODBC Driver
Use the SQL Gateway and MailerLite ODBC Driver to create a PostgreSQL entry-point for data access.
-
Replicate Freshsales Data from PowerShell
Write a quick PowerShell script to query Freshsales data. Use connectivity to the live data to replicate Freshsales data to SQL Server.
-
Extract, Transform, and Load LDAP Objects in Informatica PowerCenter
Create a simple Workflow for LDAP objects in Informatica PowerCenter.
-
Build MVC Applications with Connectivity to Gorgias Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Gorgias from an ASP.NET MVC application.
-
Build AI/ML Models with Live Presto Data using Dataiku
Connect Presto Data with Dataiku using the CData JDBC Driver for Presto.
-
Getting Started with the CData Tableau Connector for SAP BusinessObjects BI
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SAP BusinessObjects BI.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ConvertAPI
Provide connectivity to ConvertAPI data through an SAP BusinessObjects universe.
-
Enable the PostgreSQL JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with PostgreSQL data.
-
How to connect to Sentry Data in DBVisualizer
Integrate Sentry data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Connect to Live GitLab Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live GitLab data without replication.
-
How to Connect to Live Google Contacts Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Google Contacts data without replication.
-
How to Access Grafana Data Using Entity Framework
This article shows how to access Grafana data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to create XML federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for XML data in MySQL .
-
Automated Continuous Nethunt Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Nethunt replication to Azure SQL Database.
-
How to Work with Vercel Data in AWS Glue Jobs Using JDBC
Connect to Vercel from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous Productboard Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Productboard replication to delimited files (CSV/TSV).
-
Getting Started with the CData Tableau Connector for Teradata
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Teradata.
-
Import and Visualize VWO Data in Power View
Create data visualizations based on VWO data in Excel.
-
Integrate Live Splunk Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Splunk data and integrate live Splunk data into apps built in Microsoft Power Apps.
-
Use JayDeBeApi to access SAP Netweaver Gateway Data in Python
Use standard Python scripting and the development environment of your choice to access live SAP Netweaver Gateway data.
-
Integrating OpenCode with SAP SuccessFactors 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 Work with JSON Services in AWS Glue Jobs Using JDBC
Connect to JSON from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create Power BI Reports on Real-Time Mixpanel Data
Use the CData ODBC Driver for Mixpanel to visualize Mixpanel data in Power BI Desktop.
-
Integrate Devin with Live Exa Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Exa data.
-
DataBind Bitbucket Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Bitbucket with the DevExpress Windows Forms and Web controls to provide Bitbucket data to a chart.
-
Automated Continuous Postmark Replication to Vertica
Use CData Sync for automated, continuous, customizable Postmark replication to Vertica.
-
How to Connect to & Open Kintone Data in Microsoft Excel
This article uses the CData ODBC driver for Kintone to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrating Dataiku with ZohoInvoice Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live ZohoInvoice data.
-
Build Data Flows from XML to SQL Server using SSIS
Easily back up XML data to SQL Server using the SSIS components for XML.
-
Access Apify Data from MySQL in PHP
Connect to Apify through the standard MySQL libraries in PHP.
-
Connect to and Query Cloudflare Data in QlikView over ODBC
Create data visualizations with Cloudflare data in QlikView.
-
SQL Analysis Services Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SQL Analysis Services facts in real time.
-
Interact with Live Aweber Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Aweber data.
-
Use JayDeBeApi to access PolarTeamPro Data in Python
Use standard Python scripting and the development environment of your choice to access live PolarTeamPro data.
-
Visualize Attio Data in Sisense
Create an ElastiCube in Sisense app with access to Attio data.
-
How to Query Live Adobe Commerce Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Adobe Commerce data data in natural language using Python.
-
How to Create Power BI Visual Reports with Real-Time MailerSend Data
Use CData Power BI Connectors to visualize MailerSend data in Power BI.
-
Replicate Multiple Shortcut Accounts
Replicate multiple Shortcut accounts to one or many databases.
-
Analyze FTP Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of FTP data and visualize live FTP data in Infragistics Reveal.
-
Connect to Oracle Service Cloud Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Oracle Service Cloud data in Airbyte.
-
Integrating Claude Code with Oracle HCM Cloud Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Oracle HCM Cloud data within assisted coding and automated development workflows.
-
Connect to Blackbaud FE NXT Data in RapidMiner
Integrate Blackbaud FE NXT data with standard components and data source configuration wizards in RapidMiner Studio.
-
Create Yelp-Connected Applications in Appsmith
Connect to Yelp Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Yelp data.
-
How to load Onfleet data into Elasticsearch via Logstash
Introducing a simple method to load Onfleet data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Using the CData Software ODBC Driver for CouchDB in PyCharm
Connect to CouchDB as an ODBC data source in PyCharm using the CData Software ODBC Driver for CouchDB.
-
Getting Started with the CData ODBC Driver for Parquet
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Parquet.
-
Build Office 365-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Office 365 data.
-
Integrate with ZohoSubscriptions Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ZohoSubscriptions data to a JSON file on disk.
-
Publish Aircall-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Aircall data.
-
Connect to Excel Online Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Excel Online.
-
Build Semantic Layer Views for SAP Business One Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for SAP Business One data.
-
How to create an RPA flow for ConvertKit Data in UiPath Studio
Use the ConvertKit ODBC Driver to create workflows that access real-time ConvertKit data without any coding.
-
How to Easily Query Zoho Inventory Data in OpenOffice Base
Connect to Zoho Inventory data in OpenOffice Base using the CData ODBC Driver for Zoho Inventory and generate reports with live data insights.
-
Access Live Sybase 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 Sybase data through MCP integration.