CData Software - Knowledge Base
Recent Articles
-
Create a Data Access Object for Microsoft Dataverse Data using JDBI
A brief overview of creating a SQL Object API for Microsoft Dataverse data in JDBI.
-
Automated Continuous Dynamics CRM Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to PostgreSQL.
-
Access Jira Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Jira data from HeidiSQL.
-
Automated Continuous SAP HANA XS Advanced Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to Google Cloud SQL.
-
Analyze XML Data in Looker
Use CData Connect AI to connect to XML Data from Looker and build custom apps using live XML data.
-
Access SAP Ariba Source Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SAP Ariba Source data from HeidiSQL.
-
Visualize Live Adobe Experience Manager Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Adobe Experience Manager data.
-
How to Connect to & Open ShipStation Data in Microsoft Excel
This article uses the CData ODBC driver for ShipStation to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to SageHR from Asprova with CData Software ODBC Driver for SageHR
This article shows how to connect faster to SageHR data from Asprova.
-
Integrate OpenCode with Live SFTP Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live SFTP data from within your AI coding agent.
-
Use Manus AI to Talk to Your ServiceDesk Plus Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on ServiceDesk Plus data.
-
Publish Snowflake-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Snowflake data.
-
How to Visualize Oracle Service Cloud Data in Python with pandas
Use pandas and other modules to analyze and visualize live Oracle Service Cloud data in Python.
-
Integrating Codex with ChargeOver 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 Oracle Financials Cloud Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Oracle Financials Cloud data using standard SQL.
-
Build an OLAP Cube in SSAS from Vercel Data
Establish a connection to Vercel data data from SQL Server Analysis Services, and use the Vercel Data Provider to build OLAP cubes for use in analytics and reporting.
-
Publish Klaviyo-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Klaviyo data.
-
Analyze Live Shippo Data in SAS Viya
Use CData Connect AI to connect to Shippo data from SAS Viya and deploy self-service analytics using live Shippo data.
-
Connect to Twitter Ads Data in RapidMiner
Integrate Twitter Ads data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Jumpseller 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 Jumpseller and work with Jumpseller data in your FileMaker application.
-
Publish Simplesat-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Simplesat data.
-
Getting Started with the CData Python Connector for Onfleet
Learn to install and license the CData Python Connector and configure a connection to live Onfleet data.
-
Integrate Live Wave Financial Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Wave Financial data from within the IDE.
-
Getting Started with the CData Excel Add-In for Cvent
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Cvent.
-
How to Connect to & Open VWO Data in Microsoft Excel
This article uses the CData ODBC driver for VWO to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Bitly Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Bitly Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Connect to Live Azure Data Lake Storage Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Azure Data Lake Storage data securely in real time.
-
Connect to iContact Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live iContact data from Filemaker Pro on Mac.
-
Use the CData Software ODBC Driver for Cosmos DB in SAS for Real-Time Reporting and Analytics
Connect to real-time Cosmos DB data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Cosmos DB.
-
Integrate Mouseflow Data in Pentaho Data Integration
Build ETL pipelines based on Mouseflow data in the Pentaho Data Integration tool.
-
Write a Simple Go Application to work with RabbitMQ Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to RabbitMQ data.
-
Use Grok to Talk to Your Zoho Creator 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 Zoho Creator data for you.
-
Connect to Shopify Data from PowerBuilder via ADO.NET
This article demonstrates how to access Shopify data from Appeon PowerBuilder using the CData ADO.NET Provider for Shopify.
-
Visualize Printful Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Printful data into TIBCO Spotfire.
-
Automated Continuous Google Spanner Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Google Spanner replication to Amazon S3.
-
Connect to Pinterest Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Pinterest data.
-
Import and Visualize Exa Data in Power View
Create data visualizations based on Exa data in Excel.
-
Connect to Elasticsearch Data in Google Apps Script via Connect AI
Use CData Connect AI to access Elasticsearch data in Google Apps Script.
-
Build Semantic Layer Views for ConstantContact Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for ConstantContact data.
-
Migrating data from SAP Business One to Databricks using CData SSIS Components.
Easily push SAP Business One data to Databricks using the CData SSIS Tasks for SAP Business One and Databricks.
-
How to Connect the Power BI Service to TaxJar: Complete Guide
Connect to the CData Software Power BI Connector for TaxJar from PowerBI.com to provide real-time TaxJar data across the organization.
-
How to Connect to Live Amazon Athena 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 Amazon Athena data for you.
-
Analyze MariaDB Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze MariaDB data with the CData JDBC Driver for MariaDB.
-
Use Biml to Build SSIS Tasks to Replicate ShipEngine Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ShipEngine data to SQL Server.
-
Access BigCommerce Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live BigCommerce data from HeidiSQL.
-
Access Live MailChimp Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live MailChimp data from your Google Sheets.
-
Publish Crystal Reports on Pinterest Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Pinterest data.
-
Connect to SAP Hybris C4C Data in ACL Analytics
Connect to SAP Hybris C4C data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to SAP Hybris C4C data.
-
Use Dash to Build Web Apps on Slack Data via CData Connect AI
Build interactive Dash web apps on live Slack data using pandas and the CData Connect AI Python SDK.
-
How to connect to Vimeo Data from Spring Boot
Connect to Vimeo in a Spring Boot Application using the CData API Driver for JDBC
-
Use the CData Software JDBC Driver for Cloudflare in MicroStrategy Web
Connect to Cloudflare data in MicroStrategy Web using the CData Software JDBC Driver for Cloudflare.
-
Integrate Live Access Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Access data to Blue Prism using the CData ODBC Driver for Access to create automated workflows for repetitive business tasks.
-
Design BIRT Reports on Egnyte Data
Provide current Egnyte data to your embedded analytics.
-
Trigger Exact Online IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Exact Online with standard wizards in Logic Apps.
-
Integrating Codex with Trello 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.
-
Access PayPal Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access PayPal data from your Oracle system.
-
Connect to Float Data in Aqua Data Studio
Access Float data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect Sage 200 to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Sage 200 data using the CData Python MCP Server.
-
SharePoint Excel Services Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SharePoint Excel Services facts in real time.
-
Create Apps from Sage 200 Data in Qlik Sense Cloud
Use CData Connect AI to connect to Sage 200 Data and build apps from live Sage 200 data in Qlik Sense Cloud.
-
Seamlessly Bring Mode Data into Retool Using CData Connect AI
Integrate Mode data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Replicate Multiple Xero Accounts via the CData Sync CLI
Replicate multiple Xero accounts to one or many databases.
-
DataBind Charts to Front Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Front 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.
-
Feed PDFMonkey Data into FineReport
How to set PDFMonkey data as a JDBC data source in FineReport.
-
Excel Spreadsheet Automation on Factorial Data with the QUERY Formula
Pull data from Factorial, automate spreadsheets, and more with the QUERY formula.
-
Analyze Quaderno Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Quaderno data in Microsoft R Open.
-
Integrating OpenCode with Wistia 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 the CData Software JDBC Driver for Highrise in MicroStrategy Web
Connect to Highrise data in MicroStrategy Web using the CData Software JDBC Driver for Highrise.
-
How to Connect to Live Exa 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 Exa data for you.
-
Automated Deel Data Replication to Teradata
Use CData Sync to Customize and automate Deel data replication to Teradata.
-
Visualize Live Spark Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Spark data into custom reports in Power BI.
-
How to Connect to Live Google Calendar 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 Google Calendar data for you.
-
How to Connect to Live Reckon Accounts Hosted 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 Reckon Accounts Hosted data for you.
-
Use Manus AI to Talk to Your Pipedrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Pipedrive data.
-
Access Live Rootly Data in AWS Lambda
Connect to live Rootly data in AWS Lambda using the CData JDBC Driver.
-
Query Google Campaign Manager 360 Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Google Campaign Manager 360 entities in PHP by modeling them as objects.
-
How to Access Google Contacts Data Using Entity Framework
This article shows how to access Google Contacts data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous Notion Replication to Snowflake
Use CData Sync for automated, continuous, customizable Notion replication to Snowflake.
-
Create Cloudflare-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Cloudflare Data from OutSystems and build custom enterprise apps using live Cloudflare data.
-
DataBind Controls to Redshift Data in C++Builder
DataBind to Redshift data in C++Builder with standard components and controls.
-
Integrating OpenCode with Microsoft Teams 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.
-
Integrate with Hugging Face Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Hugging Face data to a JSON file on disk.
-
Using the CData Software ODBC Driver for ZohoPeople in PyCharm
Connect to ZohoPeople as an ODBC data source in PyCharm using the CData Software ODBC Driver for ZohoPeople.
-
Use ChatGPT to Talk to Your Bitly Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Bitly data for you.
-
Use the CData ODBC Driver for SAS xpt in Microsoft Power Query
You can use the CData SAS xpt ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SAS xpt data into Microsoft Power Query.
-
Access Live Facebook Ads Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Facebook Ads data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate with LDAP Objects in SnapLogic
Use CData Connect AI to connect to and integrate with live LDAP objects in SnapLogic.
-
Analyze Odoo Data in Cognos Analytics
Use CData Connect AI to connect to Odoo Data from Cognos Analytics and analyze live Odoo data.
-
Back Up Amazon Marketplace data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Amazon Marketplace. In this article, we will employ an SSIS workflow to populate a database with Amazon Marketplace data data.
-
Work with Wrike Data in FoxPro
Load Wrike data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build a Singer.io Tap for TaxJar With the CData Python Connector
Learn how to easily build a Singer.io Tap for live TaxJar data using the CData Python Connector.
-
Model, Search, and Visualize Live OneNote Data in ThoughtSpot
Use CData Connect AI to connect to live OneNote data for modeling, searching, and visualizing.
-
Integrate with Oracle SCM Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Oracle SCM data to a JSON file on disk.
-
Automated Continuous Planio Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Planio data replication to OneLake in Microsoft Fabric.
-
Connect to Humanity Data in DBeaver
Use the CData ODBC Driver to connect to Humanity data in DBeaver.
-
Connect to Dynamics 365 Business Central Data in Aqua Data Studio
Access Dynamics 365 Business Central data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Query Live Salesforce Data 360 Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Salesforce Data 360 data data in natural language using Python.
-
Process & Analyze SAP ByDesign Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SAP ByDesign Data.
-
Build an OLAP Cube in SSAS from Authorize.Net Data
Establish a connection to Authorize.Net data data from SQL Server Analysis Services, and use the Authorize.Net Data Provider to build OLAP cubes for use in analytics and reporting.
-
Analyze Tally Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Tally data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.