CData Software - Knowledge Base
Recent Articles
-
Integrating Kiro with XML 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.
-
Create a Data Access Object for PagerDuty Data using JDBI
A brief overview of creating a SQL Object API for PagerDuty data in JDBI.
-
Build Data Flows from SFTP to SQL Server using SSIS
Easily back up SFTP data to SQL Server using the SSIS components for SFTP.
-
ETL Oracle Financials Cloud in Oracle Data Integrator
This article shows how to transfer Oracle Financials Cloud data into a data warehouse using Oracle Data Integrator.
-
Integrate SparkPost Data in the Pentaho Report Designer
Publish reports based on SparkPost data in the Pentaho BI tool.
-
Migrating data from SAP Concur to Snowflake using CData SSIS Components.
Easily push SAP Concur data to Snowflake using the CData SSIS Tasks for SAP Concur and Snowflake.
-
Connect to ClickUp Data in DBeaver
Use the CData ODBC Driver to connect to ClickUp data in DBeaver.
-
Load Microsoft OneDrive Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft OneDrive data to a database.
-
Connect to and Visualize Live Discourse Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Discourse data.
-
Visualize Workday Data in Tableau
The CData ODBC driver for Workday enables you integrate Workday data into Tableau dashboards.
-
Validate CSV Data with QuerySurge
Access and validate CSV data in QuerySurge using the CData JDBC Driver.
-
Integrating Templated Data in Talend Cloud Data Management Platform
Connect Templated Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Access Live Instantly Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Instantly data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Rapidly Develop Cohere-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 Cohere.
-
Consume Quickbase OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Quickbase feeds that reflect any changes in SAP Lumira.
-
A PostgreSQL Interface for Foursquare Data using the CData ODBC Driver
Use the SQL Gateway and Foursquare ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use Grok to Talk to Your Samanage 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 Samanage data for you.
-
How to connect to Azure Synapse Data with Squirrel SQL client
Connect to Azure Synapse data and execute queries in the Squirrel SQL Client.
-
Natively Connect to MailChimp Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to MailChimp data. Leverage the native support for ODBC in PHP.
-
Connect to Dynamics NAV from a Connection Pool in WebLogic
Use the CData JDBC Driver for Dynamics NAV to connect to Dynamics NAV data from Web applications running on WebLogic.
-
Use the CData Software ODBC Driver for SAS xpt in MicroStrategy Desktop
Connect to SAS xpt data in MicroStrategy Desktop using the CData Software ODBC Driver for SAS xpt.
-
How to Access Live Elasticsearch Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Elasticsearch enables you to integrate Elasticsearch data into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous iContact Replication to MySQL
Use CData Sync for automated, continuous, customizable iContact replication to MySQL.
-
How to Connect to Live OData Services 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 OData services for you.
-
Access Live SAP Netweaver Gateway Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP Netweaver Gateway data from your Google Sheets.
-
Integrate Odoo Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Odoo data from Informatica Cloud.
-
Integrate SageHR Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to SageHR data and integrate live SageHR data into your Power Automate tasks.
-
Work with Live Figshare Data in Power Query
Use CData Connect AI to connect to Figshare data and work with live Figshare data in Microsoft Power Query.
-
Analyze SingleStore Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SingleStore data with the CData JDBC Driver for SingleStore.
-
Integrate Trae with Live Hive Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Hive data from within the AI-powered IDE.
-
Connect to and Visualize Live Zoho Inventory Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Zoho Inventory data.
-
Create Datasets from Mode in Domo Workbench and Build Visualizations of Mode Data in Domo
Use the CData Software ODBC Driver for Mode to create datasets from Mode data in Domo Workbench and then build visualizations in the Domo service.
-
Publish Reports with Power BI XMLA Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Power BI XMLA data.
-
Query Facebook Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Facebook data from Node.js.
-
Import Gmail Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Gmail Data and provide access to live Gmail data for custom reports in the Power BI Service.
-
Connect and Query Live Procore Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Procore data into Databricks and enable direct, live querying and analysis without replication.
-
Use Dash to Build to Web Apps on ShipStation Data
Create Python applications that use pandas and Dash to build ShipStation-connected web apps.
-
Use Grok to Talk to Your Tavily 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 Tavily data for you.
-
Getting Started with the CData ADO.NET Provider for Oracle Service Cloud
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Oracle Service Cloud.
-
Connect to and Query Amazon Athena Data in QlikView over ODBC
Create data visualizations with Amazon Athena data in QlikView.
-
Build Apps with Live Dynamics NAV data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Dynamics NAV data into the Adalo platform and build custom mobile and web applications with real-time Dynamics NAV data.
-
How to Connect to Live MailerLite Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your MailerLite data for you.
-
Connect to Live Salesforce Marketing Data in MicroStrategy through CData Connect AI
Create a live connection to Salesforce Marketing Data in CData Connect AI and connect to your Salesforce Marketing data from MicroStrategy.
-
Use the CData ODBC Driver for Deel from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Deel to connect to Deel data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Deel data in Excel.
-
Build MVC Applications with Connectivity to SQL Analysis Services Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SQL Analysis Services from an ASP.NET MVC application.
-
View Reports on Real-Time CockroachDB Data in Power BI Report Server
Use the CData ODBC Driver for CockroachDB to visualize CockroachDB data in Power BI Desktop and then publish them to Power BI Report Server.
-
A PostgreSQL Interface for Stripe Data (MySQL Remoting via JDBC)
Use the Remoting features of the Stripe JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create SSAS Tabular Models from Twitter Ads Data
How to build a SQL Server Analysis Service Tabular Model from Twitter Ads data using CData drivers.
-
Replicate Multiple Google Sheets Accounts via the CData Sync CLI
Replicate multiple Google Sheets accounts to one or many databases.
-
Create Power BI Reports on Real-Time Azure DevOps Data
Use the CData ODBC Driver for Azure DevOps to visualize Azure DevOps data in Power BI Desktop.
-
Automated Continuous Typeform Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Typeform replication to Apache Kafka.
-
Design BIRT Reports on Avro Data
Provide current Avro data to your embedded analytics.
-
Automated Continuous Zoho Inventory Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Zoho Inventory replication to delimited files (CSV/TSV).
-
How to Query Live IBM Informix Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live IBM Informix data data in natural language using Python.
-
Build Demio-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Demio data and build web apps with connectivity to live Demio data.
-
Connect to Microsoft Exchange Data in HULFT Integrate
Connect to Microsoft Exchange as a JDBC data source in HULFT Integrate
-
Visualize Live Parquet Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Parquet data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Moving Data from Aweber to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Aweber data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to connect Amazon QuickSight to Zoho Books Data
Create a connection to Zoho Books data in CData Connect AI and insert Zoho Books data into Amazon QuickSight SPICE to build interactive dashboards.
-
Automated Continuous Zuora Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Zuora replication to PostgreSQL.
-
Use CData Connect AI to Access Oracle Eloqua Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Oracle Eloqua data in the Power Pivot business intelligence tool.
-
Build GitHub-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live GitHub data.
-
Build SAP Fieldglass-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live SAP Fieldglass data without replication.
-
How to connect SharePoint with PayPal Data through external lists
Provide PayPal data to SharePoint users as an external list.
-
Query Templated Data in ColdFusion
Write standard ColdFusion data access code to connect to Templated data.
-
Create Airtable-Connected Nintex Workflows
Use CData Connect AI to connect to Airtable Data from Nintex Workflow Cloud and build custom workflows using live Airtable data.
-
Integrating Oracle Sales Data in Talend Cloud Data Management Platform
Connect Oracle Sales Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Oracle Sales.
-
Connect to and Query Google Sheets Data in QlikView over ODBC
Create data visualizations with Google Sheets data in QlikView.
-
How to integrate Instantly with Apache Airflow
Access and process Instantly data in Apache Airflow using the CData JDBC Driver.
-
Create Bitly-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Bitly Data from Klipfolio and build custom visualizations using live Bitly data.
-
Connect to Sage Cloud Accounting Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Sage Cloud Accounting data in the Denodo Virtual DataPort Administrator.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Kafka
Provide connectivity to Kafka data through an SAP BusinessObjects universe.
-
Analyze Live Testmonitor Data in SAS Viya
Use CData Connect AI to connect to Testmonitor data from SAS Viya and deploy self-service analytics using live Testmonitor data.
-
Automated Continuous Paymo Replication to MySQL
Use CData Sync for automated, continuous, customizable Paymo replication to MySQL.
-
A PostgreSQL Interface for Vault CRM Data using the CData ODBC Driver
Use the SQL Gateway and Vault CRM ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to & Open Dynamics 365 Business Central Data in Microsoft Excel
This article uses the CData ODBC driver for Dynamics 365 Business Central to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Use Dash to Build Web Apps on Lakebase Data via CData Connect AI
Build interactive Dash web apps on live Lakebase data using pandas and the CData Connect AI Python SDK.
-
Integrating Boomi Agentstudio with Freshteam Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Freshteam data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to create Visio diagrams from Salesforce Marketing Data
Automatically update Salesforce Marketing data with the changes you make to Visio master shapes.
-
Extract, Transform, and Load SAP Netweaver Gateway Data in Informatica PowerCenter
Create a simple Workflow for SAP Netweaver Gateway data in Informatica PowerCenter.
-
Integrate LibreChat with Live BigQuery Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live BigQuery data from within the chat interface.
-
Access Oracle HCM Cloud Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Oracle HCM Cloud data from your Oracle system.
-
Connect to Avalara AvaTax Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Avalara AvaTax as an External Source in Dremio.
-
Connect to Greenhouse Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Greenhouse data in the Denodo Virtual DataPort Administrator.
-
Create a Data Access Object for FormSite Data using JDBI
A brief overview of creating a SQL Object API for FormSite data in JDBI.
-
Integrating Codex with Bugsnag 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.
-
Connect to ZohoSubscriptions Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ZohoSubscriptions to connect to ZohoSubscriptions data and execute queries in PowerBuilder.
-
Getting Started with the CData ODBC Driver for HBase
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for HBase.
-
Analyze Pushbullet Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Pushbullet data in Microsoft R Open.
-
Use the CData Software JDBC Driver for Mode in MicroStrategy Desktop
Connect to Mode data in MicroStrategy Desktop using the CData Software JDBC Driver for Mode.
-
Integrating Claude Code CLI with PagerDuty 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 Cohere Data in AWS Glue Jobs Using JDBC
Connect to Cohere from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for JotForm
Provide connectivity to JotForm data through an SAP BusinessObjects universe.
-
Import ClickUp Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to ClickUp Data and provide access to live ClickUp data for custom reports in the Power BI Service.
-
Viewing Printful Data in RAD Studio Data Explorer
How to view Printful data in RAD Studio Data Explorer using the CData ODBC Driver for Printful.
-
Work with LeadDesk Data in FoxPro
Load LeadDesk data into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Connect Elasticsearch Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Elasticsearch data in real time using natural language.
-
Publish ZohoExpense-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ZohoExpense data.
-
Creating SAP Hybris C4C-Connected Applications in Unqork
You can use CData Connect AI to feed SAP Hybris C4C data to Unqork and build custom business apps.
-
Integrate Microsoft Dataverse with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Microsoft Dataverse with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Microsoft Dataverse data.