CData Software - Knowledge Base
Recent Articles
-
Moving Data from Adobe Analytics to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Adobe Analytics data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrating Codex CLI with LaunchDarkly 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 Azure AI Foundry to Talk to Your Confluence 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 Atlassian Confluence for you.
-
How to connect to Teradata Data in DBVisualizer
Integrate Teradata with visual data analysis tools and data connection wizards in DBVisualizer
-
Build a Singer.io Tap for Dynamics 365 Business Central With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Dynamics 365 Business Central data using
-
DataBind Controls to Couchbase Data in C++Builder
DataBind to Couchbase in C++Builder with standard components and controls.
-
Build Data Flows from SQL Server to Freshdesk through SSIS
Easily push SQL Server data to Freshdesk using the CData SSIS Tasks for Freshdesk.
-
Integrate Cursor with Live SAS xpt Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live SAS XPORT from within the editor.
-
Integrating Codex CLI with PolarTeamPro 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 OneNote Data from MySQL in Amazon QuickSight
Connect to OneNote and build visualizations of Microsoft OneNote using a MySQL Connection in Amazon QuickSight.
-
How to Connect to & Open Zoho CRM Data in Microsoft Excel
This article uses the CData ODBC driver for Zoho CRM to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Dropbox Reporting in OBIEE with the Dropbox JDBC Driver
Deploy the Dropbox JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Connect to Cosmos DB Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Azure Cosmos DB. Leverage the pyodbc module for ODBC in Python.
-
Connect to Egnyte Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Egnyte in the Denodo Virtual DataPort Administrator.
-
Getting Started with the CData Tableau Connector for ZeroBounce
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
How to Connect to & Open Hive Data in Microsoft Excel
This article uses the CData ODBC driver for Hive to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed XML Files to Power BI dashboards. Simply drag and drop XML Files into data visuals on the Power BI canvas.
-
Access Live HubDB Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate HubDB into the statistical analysis tools available in SAS JMP. This article shows how to use HubDB in the Graph Builder and Query Builder.
-
Access Rootly Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Rootly from HeidiSQL.
-
ETL CockroachDB in Oracle Data Integrator
This article shows how to transfer CockroachDB into a data warehouse using Oracle Data Integrator.
-
Automated Continuous Tally Replication to Vertica
Use CData Sync for automated, continuous, customizable Tally replication to Vertica.
-
ETL Customer.io in Oracle Data Integrator
This article shows how to transfer Customer.io into a data warehouse using Oracle Data Integrator.
-
Deploy the ADO.NET Provider for SparkPost on an SSRS Report Server
Connect to SparkPost 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.
-
Design BIRT Reports on Qualaroo Data
Provide current Qualaroo to your embedded analytics.
-
Query Oracle Sales Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Oracle Sales from Node.js.
-
Getting Started with the CData Excel Add-In for JSON
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for JSON.
-
Analyze QuickBooks Time Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of QuickBooks Time and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Publish Zoho Creator-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Zoho Creator.
-
How to Query Live Google Campaign Manager 360 Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Google Campaign Manager 360 data in natural language using Python.
-
Connect to Miro Data in NetBeans
Connect to Miro in NetBeans with the data source configuration wizard.
-
Query Gong Data in DataGrip
Create a Data Source for Gong in DataGrip and use SQL to query live Gong.
-
Connect to Spark Data in JRuby
Create a simple JRuby app with access to live Apache Spark SQL.
-
Process & Analyze Egnyte Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Egnyte Data.
-
Consume Zoho Projects OData Feeds in PowerBuilder
This article demonstrates how to consume Zoho Projects as OData feeds from PowerBuilder using the API Server.
-
Visualize Delighted 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 Delighted into TIBCO Spotfire.
-
Viewing Jira Data in RAD Studio Data Explorer
How to view Atlassian Jira in RAD Studio Data Explorer using the CData ODBC Driver for Jira.
-
Use the CData ODBC Driver for Xero in Microsoft Power Query
You can use the CData Xero ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Xero Accounting into Microsoft Power Query.
-
Connect to Bullhorn CRM Data in RapidMiner
Integrate Bullhorn CRM with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrating GitHub Copilot CLI with Telegram 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.
-
Write a Simple Go Application to work with PDFMonkey Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to PDFMonkey.
-
Connect to Google Search Results from a Connection Pool in JBoss
Integrate Google Search into Java servlets: Use the Management Console in JBoss to install the Google Search JDBC Driver.
-
Connect to Klipfolio Data in DBArtisan
Use wizards in DBArtisan to configure Klipfolio as a data source.
-
How to Access Live Dynamics NAV Data in Visual Studio Code via Cline
Run CData MCP Server for Dynamics NAV on Windows Subsytem for Linux (WSL) and connect to live Microsoft Dynamics NAV from the Cline extension in Visual Studio Code.
-
Build an OLAP Cube in SSAS from VWO Data
Establish a connection to VWO data from SQL Server Analysis Services, and use the VWO Data Provider to build OLAP cubes for use in analytics and reporting.
-
Migrating data from Snapchat Ads to Databricks using CData SSIS Components.
Easily push Snapchat Ads to Databricks using the CData SSIS Tasks for Snapchat Ads and Databricks.
-
Add Copper Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Copper with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Epicor Kinetic Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Epicor Kinetic as an External Source in Dremio.
-
Integrate Open WebUI with Live Tally Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Tally ERP from within the chat interface.
-
Build Semantic Layer Views for Cloudant Data in APOS Live Data Gateway
Use the CData Connector for Cloudant in APOS Live Data Gateway to build Semantic Layer Views for IBM Cloudant.
-
How to Connect to Live Active Directory Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Active Directory securely in real time.
-
How to connect to Aircall Data from IntelliJ
Integrate connectivity to Aircall with wizards in IntelliJ.
-
Use the CData Software JDBC Driver for Hive in MicroStrategy Desktop
Connect to Apache Hive in MicroStrategy Desktop using the CData Software JDBC Driver for Hive.
-
A PostgreSQL Interface for EnterpriseDB Data (MySQL Remoting via JDBC)
Use the Remoting features of the EnterpriseDB JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use Databricks Agent Bricks to Talk to Your IBM Informix Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your IBM Informix for you.
-
Connect to SpaceX Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SpaceX in the Denodo Virtual DataPort Administrator.
-
Bind Live HCL Domino Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live HCL Domino data
-
How to load CouchDB data into Elasticsearch via Logstash
Introducing a simple method to load CouchDB data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use the CData Software JDBC Driver for Quickbase in MicroStrategy Desktop
Connect to Quickbase in MicroStrategy Desktop using the CData Software JDBC Driver for Quickbase.
-
Model Act-On Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Act-On, enabling the direct import of real-time Act-On.
-
Visualize Cassandra Data in TIBCO Spotfire through OData
Integrate Apache Cassandra into dashboards in TIBCO Spotfire.
-
Create Freshservice-Connected Nintex Workflows
Use CData Connect AI to connect to Freshservice Data from Nintex Workflow Cloud and build custom workflows using live Freshservice.
-
Automated Continuous JotForm Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable JotForm replication to OneLake in Microsoft Fabric.
-
Create BambooHR-Connected Applications in Appsmith
Connect to BambooHR Data via CData Connect AI in Appsmith and create custom business applications with real-time access to BambooHR.
-
Connect to Superchat Data in NetBeans
Connect to Superchat in NetBeans with the data source configuration wizard.
-
Connect to Live CSV Data in MicroStrategy through CData Connect AI
Create a live connection to CSV Data in CData Connect AI and connect to your CSV/TSV Files from MicroStrategy.
-
Migrating data from Hugging Face to Google BigQuery using CData SSIS Components.
Easily push Hugging Face to Google BigQuery using the CData SSIS Tasks for Hugging Face and Google BigQuery.
-
Use the CData ODBC Driver for Sage 300 from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Sage 300 to connect to Sage 300 from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Sage 300 in Excel.
-
Publish Quickbase-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Quickbase.
-
Integrate Zoho Inventory with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Zoho Inventory with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Zoho Inventory.
-
How to Connect to & Open Foursquare Data in Microsoft Excel
This article uses the CData ODBC driver for Foursquare to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous DB2 for i Replication to MongoDB
Use CData Sync for automated, continuous, customizable DB2 for i replication to MongoDB.
-
Access LinkedIn Ads Data from MySQL in Amazon QuickSight
Connect to LinkedIn Ads and build visualizations of LinkedIn Ads using a MySQL Connection in Amazon QuickSight.
-
Replicate WordPress Data to Multiple Databases
Replicate WordPress to disparate databases with a point-and-click configuration.
-
Import Adobe Commerce Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Adobe Commerce. In this article, you will use the OData format to import Adobe Commerce into Microsoft Power Query.
-
Connect to and Visualize Live Shopify Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Shopify.
-
Integrate Avaza Data in the Pentaho Report Designer
Publish reports based on Avaza in the Pentaho BI tool.
-
Extend Google Sheets with Oracle Data
Make calls to Oracle from Google Apps Script via the API Server.
-
Integrating LangGraph with IBM Cloud Object Storage Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on IBM Cloud Object Storage within automated workflows.
-
DataBind Controls to Certinia Data in C++Builder
DataBind to Certinia in C++Builder with standard components and controls.
-
Connect and Visualize Live CSV Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live CSV/TSV Files into the Databricks platform and create visualization dashboards with real-time CSV/TSV Files.
-
Integrating Cursor CLI with Okta 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.
-
Getting Started with the CData Tableau Connector for Square
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Square.
-
Connect to Elorus Data in DBeaver
Use the CData ODBC Driver to connect to Elorus in DBeaver.
-
How to import Simplesat Data into Apache Solr
Use the CData Software JDBC Driver for Simplesat in Data Import Handler and create an automated import of Simplesat to Apache Solr Enterprise Search platform.
-
Visualize Zoho CRM Data in Tableau
The CData ODBC driver for Zoho CRM enables you integrate Zoho CRM into Tableau dashboards.
-
DataBind Controls to Printful Data in Delphi
DataBind to Printful in Delphi with standard data access components and controls.
-
Integrate Open WebUI with Live Facebook Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Facebook Ads from within the chat interface.
-
Access Live Act-On Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Act-On from your Excel spreadsheets.
-
Query CockroachDB Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume CockroachDB entities in PHP by modeling them as objects.
-
Access Live Snowflake Data in Excel 365 Online (Excel for the web)
Connect to Snowflake from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect and Visualize Live Impala Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Apache Impala into the Databricks platform and create visualization dashboards with real-time Apache Impala.
-
DataBind Charts to Snapchat Ads Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Snapchat Ads 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.
-
Automated Continuous Amazon S3 Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Amazon S3 replication to Amazon S3.
-
Connect to Shortcut Data in HULFT Integrate
Connect to Shortcut as a JDBC data source in HULFT Integrate
-
How to Access Strava Data Using Entity Framework
This article shows how to access Strava using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Amazon Marketplace Reporting in OBIEE with the Amazon Marketplace JDBC Driver
Deploy the Amazon Marketplace JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Analyze Paylocity Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Paylocity and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
ETL REST in Oracle Data Integrator
This article shows how to transfer REST into a data warehouse using Oracle Data Integrator.
-
Create Reports from Act-On Data in Looker Studio
Use CData Connect AI to gain access to live Act-On and create custom reports in Looker Studio.
-
Integrating LangChain with Azure Data Lake Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Azure Data Lake Storage within automated workflows.