CData Software - Knowledge Base
Recent Articles
-
Moving Data from Miro to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Miro data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Access Amplitude Data from MySQL in Amazon QuickSight
Connect to Amplitude and build visualizations of Amplitude data using a MySQL Connection in Amazon QuickSight.
-
Connect to Gong Data from HeidiSQL
Use CData Connect AI to connect to and query live Gong data from HeidiSQL.
-
Connect to Oracle Eloqua Data in RazorSQL
Connect to Oracle Eloqua from wizards and query Oracle Eloqua data from the GUI in the RazorSQL database management tool.
-
Use Dash to Build to Web Apps on Suadeo Data
Create Python applications that use pandas and Dash to build Suadeo-connected web apps.
-
Publish Clockify-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Clockify data.
-
Build a PostgreSQL Interface for Eventbrite Data using the CData JDBC Driver
Use the Remoting features of the Eventbrite JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Email Data in Ruby
Connect to Email data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Migrating data from YouTube Analytics to Databricks using CData SSIS Components.
Easily push YouTube Analytics data to Databricks using the CData SSIS Tasks for YouTube Analytics and Databricks.
-
Integrate with Landbot Data in JReport Designer
Create charts and reports based on Landbot data in JReport Designer.
-
Integrating Codex with Amazon DynamoDB 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 ODBC Driver for Dynamics NAV
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Dynamics NAV.
-
How to Query Acumatica Data in MySQL Workbench
Execute MySQL queries against live Acumatica data from MySQL Workbench.
-
Integrate Cline with Live HDFS Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live HDFS data from within your IDE.
-
Use Grok to Talk to Your Zoho Inventory 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 Inventory data for you.
-
Prepare, Blend, and Analyze xBase Data in Alteryx Designer (ODBC)
Build workflows to access live xBase data for self-service data analytics.
-
Explore Geographical Relationships in ChartMogul Data with Power Map
Create data visualizations with ChartMogul data in Power Map.
-
Use the CData Software ODBC Driver for FormSite in MicroStrategy Desktop
Connect to FormSite data in MicroStrategy Desktop using the CData Software ODBC Driver for FormSite.
-
Automated Continuous Rootly Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Rootly replication to Azure SQL Database.
-
Analyze Bitly Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Bitly from Power Pivot. You will use the Table Import Wizard to load Bitly data. You can visually build the import query or use any SQL supported by the driver.
-
Integrating GitHub Copilot with Samanage 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 Amazon Athena-Connected Business Apps in AppSheet
Connect to Amazon Athena Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Amazon Athena data.
-
Build MarkLogic-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to MarkLogic Data from Zoho Analytics and import live MarkLogic data.
-
Connect to Power BI XMLA Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Power BI XMLA and the SQL Gateway to access Power BI XMLA data from Google Apps Script.
-
Integrate Shippo Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Shippo data and integrate live Shippo data into your Power Automate tasks.
-
Connect to SendGrid Data from AWS Glue
Use CData Connect AI to gain access to live SendGrid data from your AWS Glue jobs.
-
Integrating Codex with AfterShip 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 load Humanity data into Elasticsearch via Logstash
Introducing a simple method to load Humanity data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Wave Financial Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Wave Financial data using standard SQL.
-
Integrate with Live Jumpseller Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Jumpseller from the MuleSoft Anypoint Platform to integrate live Jumpseller data into custom reports and dashboards.
-
Bridge Amazon DynamoDB Connectivity with Apache NiFi
Access and process Amazon DynamoDB data in Apache NiFi using the CData JDBC Driver.
-
Integrating Phoenix Data in Talend Cloud Data Management Platform
Connect Phoenix Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Phoenix.
-
Automated Continuous Adobe Target Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Adobe Target replication to Apache Cassandra.
-
Automate Billsby Data Replication to Azure Data Lake
Use CData Sync to customize and automate Billsby data replication to Azure Data Lake.
-
Connect to Freshservice from Asprova with CData Software ODBC Driver for Freshservice
This article shows how to connect faster to Freshservice data from Asprova.
-
Automated Continuous SageHR Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SageHR replication to Apache Cassandra.
-
Automate iContact Data Replication to Couchbase
Use CData Sync to Customize and automate iContact data replication to Couchbase.
-
Integrating Claude Code with SurveyMonkey Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on SurveyMonkey data within assisted coding and automated development workflows.
-
Automated Continuous Pinecone Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Pinecone replication to Google BigQuery.
-
Establish a Live Connection with Webex Data using Tableau Bridge
The CData ODBC Driver for Webex enables you to integrate live Webex data into Tableau Cloud dashboards using the Tableau Bridge.
-
Stream ZohoInvoice Data into Apache Kafka Topics
Access and stream ZohoInvoice data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Publish Crystal Reports on LaunchDarkly Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date LaunchDarkly data.
-
Automated Continuous Google Spanner Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Google Spanner data replication to OneLake in Microsoft Fabric.
-
Connecting Moonlit Workflow with AgileCRM Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your AgileCRM data in real time.
-
Build Act CRM Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Act CRM data and build visualizations in Tableau.
-
Use JayDeBeApi to access Productboard Data in Python
Use standard Python scripting and the development environment of your choice to access live Productboard data.
-
Integrating Claude Code with SAP ByDesign Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on SAP ByDesign data within assisted coding and automated development workflows.
-
Connect to Live Wave Financial Data in MicroStrategy through CData Connect AI
Create a live connection to Wave Financial Data in CData Connect AI and connect to your Wave Financial data from MicroStrategy.
-
Integrate LibreChat with Live Oracle Service Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Oracle Service Cloud data from within the chat interface.
-
How to Build an ETL App for Couchbase Data in Python with CData Connect AI
Build ETL pipelines that read and write live Couchbase data in Python with petl and the CData Connect AI Python SDK.
-
How to Connect to & Open NASA Data in Microsoft Excel
This article uses the CData ODBC driver for NASA to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Power BI XMLA Data in RapidMiner
Integrate Power BI XMLA data with standard components and data source configuration wizards in RapidMiner Studio.
-
Import Real-Time IBM Cloud Object Storage Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use IBM Cloud Object Storage data in ColdFusion.
-
How to connect to Productboard Data in DBVisualizer
Integrate Productboard data with visual data analysis tools and data connection wizards in DBVisualizer
-
Stream DocuSign Data into Apache Kafka Topics
Access and stream DocuSign data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Coda
Provide connectivity to Coda data through an SAP BusinessObjects universe.
-
Analyze Asana Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Asana data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrate Adobe Target Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Adobe Target data and integrate live Adobe Target data into your Power Automate tasks.
-
Connecting Agentforce with SAP Fieldglass Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your SAP Fieldglass data for you.
-
Excel Spreadsheet Automation on Spark Data with the QUERY Formula
Pull data from Spark, automate spreadsheets, and more with the QUERY formula.
-
Connect to YouTube Analytics from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from YouTube Analytics data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Klaviyo
Provide connectivity to Klaviyo data through an SAP BusinessObjects universe.
-
How to connect to Shopify Data in DBVisualizer
Integrate Shopify data with visual data analysis tools and data connection wizards in DBVisualizer
-
Replicate ZarMoney Data in Heroku for Use in Salesforce Connect
Replicate ZarMoney data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create Data Visualizations in Cognos BI with Google Directory Data
Access Google Directory data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build Visualizations of Timely Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Timely data in Birst.
-
DataBind eBay Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for eBay with the DevExpress Windows Forms and Web controls to provide eBay data to a chart.
-
Automate Tanda Data Replication to SAP HANA
Use CData Sync to customize and automate Tanda data replication to SAP HANA.
-
Connect to Blackbaud FE NXT Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Blackbaud FE NXT and the Script function in FileMaker Pro to connect to Blackbaud FE NXT and work with Blackbaud FE NXT data in your FileMaker application.
-
Create Shortcut-Connected Dashboards in Grafana
Connect to Shortcut Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Shortcut data.
-
Getting Started with the CData Python Connector for Presto
Learn to install and license the CData Python Connector and configure a connection to live Presto data.
-
Integrate Cline with Live Act-On Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Act-On data from within your IDE.
-
Connect to Highrise Data from PowerBuilder via ADO.NET
This article demonstrates how to access Highrise data from Appeon PowerBuilder using the CData ADO.NET Provider for Highrise.
-
Analyze Campaigner Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Campaigner from Power Pivot. You will use the Table Import Wizard to load Campaigner data. You can visually build the import query or use any SQL supported by the driver.
-
How to Create Power BI Visual Reports with Real-Time Ontraport Data
Use CData Power BI Connectors to visualize Ontraport data in Power BI.
-
Search External ShipStation Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of ShipStation data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create ShipStation Data objects that you can access from apps and the dashboard.
-
Visualize Gong Data in TIBCO Spotfire through ADO.NET
Integrate Gong data into dashboards in TIBCO Spotfire.
-
Automate QuickBooks Data Replication to Azure Synapse
Use CData Sync to customize and automate QuickBooks data replication to Azure Synapse.
-
Access Live Active Directory 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 Active Directory data through MCP integration.
-
Connect to Amazon DynamoDB Data in JRuby
Create a simple JRuby app with access to live Amazon DynamoDB data.
-
Use the CData Software JDBC Driver for Reckon Accounts Hosted in MicroStrategy
Connect to Reckon Accounts Hosted data in MicroStrategy Developer using the CData Software JDBC Driver for Reckon Accounts Hosted.
-
Automated Continuous Perigon Replication to MySQL
Use CData Sync for automated, continuous, customizable Perigon replication to MySQL.
-
Use the CData Software ODBC Driver for MYOB AccountRight in MicroStrategy Desktop
Connect to MYOB AccountRight data in MicroStrategy Desktop using the CData Software ODBC Driver for MYOB AccountRight.
-
Connect to Opsgenie Data in HULFT Integrate
Connect to Opsgenie as a JDBC data source in HULFT Integrate
-
Explore Geographical Relationships in Okta Data with Power Map
Create data visualizations with Okta data in Power Map.
-
DataBind Controls to Toggl Data in C++Builder
DataBind to Toggl data in C++Builder with standard components and controls.
-
Add WooCommerce Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for WooCommerce with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Zoho CRM Data in DBeaver
Use the CData ODBC Driver to connect to Zoho CRM data in DBeaver.
-
Connect to SageHR Data from a Connection Pool in JBoss
Integrate SageHR data into Java servlets: Use the Management Console in JBoss to install the SageHR JDBC Driver.
-
Connect to and Query Epicor Kinetic Data in QlikView over ODBC
Create data visualizations with Epicor Kinetic data in QlikView.
-
Access Live Authorize.Net Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Authorize.Net data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate Cline with Live Mode Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Mode data from within your IDE.
-
Automate Oracle Eloqua Data Replication to Couchbase
Use CData Sync to Customize and automate Oracle Eloqua data replication to Couchbase.
-
Integrate Theia IDE with Live Klipfolio Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Klipfolio data from within the development environment.
-
Add Splunk Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Splunk with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to connect to Aha! Data from Spring Boot
Connect to Aha! in a Spring Boot Application using the CData API Driver for JDBC
-
Getting Started with the CData Connect AI Python SDK for Apify
Install the CData Connect AI Python SDK to read live Apify data with standard DB-API 2.0 Python code.
-
Build an OLAP Cube in SSAS from IBM Cloud Object Storage Data
Establish a connection to IBM Cloud Object Storage data data from SQL Server Analysis Services, and use the IBM Cloud Object Storage Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to connect Amazon QuickSight to SparkPost Data
Create a connection to SparkPost data in CData Connect AI and insert SparkPost data into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrate Live CouchDB Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to CouchDB from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live CouchDB data.