CData Software - Knowledge Base
Recent Articles
-
Connect to and Query Couchbase Data in QlikView over ODBC
Create data visualizations with Couchbase data in QlikView.
-
Access Live LeadDesk Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate LeadDesk data into the statistical analysis tools available in SAS JMP. This article shows how to use LeadDesk data in the Graph Builder and Query Builder.
-
Use Microsoft Copilot Studio to talk to your Google Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Google Analytics data for you.
-
Use JayDeBeApi to access Aha! Data in Python
Use standard Python scripting and the development environment of your choice to access live Aha! data.
-
Connect to Coinbase Data from PowerBuilder via JDBC
This article demonstrates how to access Coinbase data from PowerBuilder using the Coinbase JDBC Driver.
-
How to connect to Amazon Athena Data in DBVisualizer
Integrate Amazon Athena data with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Pipelines with Live SAP Business One Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to SAP Business One from Google Cloud Data Fusion, enabling the integration of live SAP Business One data into the building and management of effective data pipelines.
-
How to Query Accelo Data in MySQL Workbench
Execute MySQL queries against live Accelo data from MySQL Workbench.
-
Integrate Goose with Live IBM Cloud Object Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live IBM Cloud Object Storage data from within the local AI agent.
-
Excel Spreadsheet Automation on Moosend Data with the QUERY Formula
Pull data from Moosend, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous Apollo Replication to SQL Server
Use CData Sync for automated, continuous, customizable Apollo replication to SQL Server.
-
Use CData Connect AI to Access Bannerbear Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Bannerbear data in the Power Pivot business intelligence tool.
-
Getting Started with the CData Python Connector for Attio
Learn to install and license the CData Python Connector and configure a connection to live Attio data.
-
Query SQL Server Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SQL Server data from Node.js.
-
Connect to Avro Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Avro and the Script function in FileMaker Pro to connect to Avro and work with Avro data in your FileMaker application.
-
Connect to SAP ByDesign Data in Aqua Data Studio
Access SAP ByDesign data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Connect the Power BI Service to WooCommerce: Complete Guide
Connect to the CData Software Power BI Connector for WooCommerce from PowerBI.com to provide real-time WooCommerce data across the organization.
-
Use the CData SSIS Components to Insert New or Update Existing Instagram Records from SQL Server
Easily push SQL Server data to Instagram using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Instagram or update existing records with data from a SQL Server database.
-
Integrating OpenCode with Sage Intacct 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 Connect to Live Paylocity 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 Paylocity data for you.
-
Visualize Live SAP Ariba Procurement Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SAP Ariba Procurement data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Replicate Multiple MailerSend Accounts
Replicate multiple MailerSend accounts to one or many databases.
-
Use Claude to Talk to Your Reckon Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Reckon data for you.
-
Integrate Gorgias Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Gorgias data from Informatica Cloud.
-
Operational Reporting on Google Spanner Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Google Spanner data.
-
Connect to Freshservice Data in DBeaver
Use the CData ODBC Driver to connect to Freshservice data in DBeaver.
-
Use CData Connect AI to Access Blackbaud FE NXT Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Blackbaud FE NXT data in the Power Pivot business intelligence tool.
-
Easily Integrate SparkPost Data in Lazarus Pascal IDE
Learn how to easily integrate live SparkPost data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous JSON Replication to SQL Server
Use CData Sync for automated, continuous, customizable JSON replication to SQL Server.
-
Connect to and Query ShipStation Data in QlikView over ODBC
Create data visualizations with ShipStation data in QlikView.
-
Provide OData Services of Teamgate Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Teamgate data by developing a WCF Service Application.
-
How to connect to Onfleet Data in DBVisualizer
Integrate Onfleet data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Airtable Data in HULFT Integrate
Connect to Airtable as a JDBC data source in HULFT Integrate
-
Access LinkedIn Ads Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access LinkedIn Ads data from your Oracle system.
-
Stream Sage 200 Data into Apache Kafka Topics
Access and stream Sage 200 data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Freshservice Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Freshservice data from Filemaker Pro on Mac.
-
Connect and Query Live Cosmos DB Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Cosmos DB data into Databricks and enable direct, live querying and analysis without replication.
-
Connect Paymo to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Paymo data using the CData Python MCP Server.
-
Integrate Helpscout Data in Pentaho Data Integration
Build ETL pipelines based on Helpscout data in the Pentaho Data Integration tool.
-
Connect to Gorgias Data in Aqua Data Studio
Access Gorgias data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Feed Trello Data into FineReport
How to set Trello data as a JDBC data source in FineReport.
-
Build Data Flows from SQL Server to WooCommerce through SSIS
Easily push SQL Server data to WooCommerce using the CData SSIS Tasks for WooCommerce.
-
How to connect PolyBase to IBM Informix
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live IBM Informix data.
-
LINQ to VWO Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the VWO Data Provider.
-
Getting Started with the CData ADO.NET Provider for Kintone
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Kintone.
-
How to Connect to & Open Stack Exchange Data in Microsoft Excel
This article uses the CData ODBC driver for Stack Exchange to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Query FTP Data as a MySQL Database in Node.js
Execute MySQL queries against FTP data from Node.js.
-
Feed Asana Data into FineReport
How to set Asana data as a JDBC data source in FineReport.
-
Automated Continuous Adobe Analytics Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Adobe Analytics replication to AlloyDB.
-
Working with Azure Analysis Services Data in LINQPad
Execute LINQ queries to Azure Analysis Services data in LINQPad.
-
Connect to Real-Time Azure Table Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Azure Table and Dataflow to import and use Azure Table data in Power Apps.
-
Connect to Exa Data from a Connection Pool in Jetty
The Exa JDBC Driver supports connection pooling: This article shows how to connect faster to Exa data from Web apps in Jetty.
-
Automated Continuous Reckon Accounts Hosted Replication to Snowflake
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to Snowflake.
-
Replicate SAP HANA XS Advanced Data from PowerShell
Write a quick PowerShell script to query SAP HANA XS Advanced data. Use connectivity to the live data to replicate SAP HANA XS Advanced data to SQL Server.
-
Back Up Procore data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Procore data data.
-
Access YouTube Analytics Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live YouTube Analytics data from HeidiSQL.
-
How to Access Instantly Data Using Entity Framework
This article shows how to access Instantly data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Moving Data from Mixpanel to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Mixpanel data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Excel Spreadsheet Automation on ZohoPeople Data with the QUERY Formula
Pull data from ZohoPeople, automate spreadsheets, and more with the QUERY formula.
-
Visualize Authorize.Net Data in Sisense
Create an ElastiCube in Sisense app with access to Authorize.Net data.
-
How to publish and share Box Data dashboards with Tableau Server
The CData ODBC driver for Box enables you integrate Box data into Tableau dashboards.
-
Manage Azure Synapse Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Azure Synapse.
-
Access Live EnterpriseDB Data in AWS Lambda (with IntelliJ IDEA)
Connect to live EnterpriseDB data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrating Dataiku with XML Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live XML data.
-
Analyze REST Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze REST data with the CData JDBC Driver for REST.
-
Build Voice Agents in ElevenLabs with access to Live VWO Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live VWO data.
-
Integrate with live Campaigner Data in Jitterbit
Use CData Connect AI to connect to and integrate live Campaigner data in Jitterbit.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Shortcut
Provide connectivity to Shortcut data through an SAP BusinessObjects universe.
-
Visualize Live Zoho Inventory Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Zoho Inventory data.
-
Configure the CData JDBC Driver for JobNimbus in a Connection Pool in Tomcat
Connect to JobNimbus data from a connection pool in Tomcat.
-
How to create Visio diagrams from Google Contacts Data
Automatically update Google Contacts data with the changes you make to Visio master shapes.
-
Use the CData Software JDBC Driver for ZohoPeople in MicroStrategy Desktop
Connect to ZohoPeople data in MicroStrategy Desktop using the CData Software JDBC Driver for ZohoPeople.
-
Integrating Dataiku with xBase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live xBase data.
-
How to Access Live Demio Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Demio enables you to integrate Demio data into workflows built using Microsoft Power Automate Desktop.
-
Link LeadDesk with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate LeadDesk data in Filemaker Pro for Mac or Windows.
-
Use the CData Software ODBC Driver for SQL Analysis Services in MicroStrategy Desktop
Connect to SQL Analysis Services data in MicroStrategy Desktop using the CData Software ODBC Driver for SQL Analysis Services.
-
Access Coda Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Coda data from your Oracle system.
-
A PostgreSQL Interface for Xero Data (MySQL Remoting via JDBC)
Use the Remoting features of the Xero JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect and Visualize Live PolarTeamPro Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live PolarTeamPro data into the Databricks platform and create visualization dashboards with real-time PolarTeamPro data.
-
Publish Amazon DynamoDB-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Amazon DynamoDB data.
-
Create Data Visualizations Based On Gmail Data in Mode
Use CData Connect AI to connect to Gmail Data from Mode and build visualizations using live Gmail data.
-
Create Apps from Splunk Data in Qlik Sense Cloud
Use CData Connect AI to connect to Splunk Data and build apps from live Splunk data in Qlik Sense Cloud.
-
Integrating Paymo Data in Talend Cloud Data Management Platform
Connect Paymo Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to connect to BigQuery Data from Spring Boot
Connect to BigQuery in a Spring Boot Application using the CData JDBC Driver for BigQuery
-
Automated Continuous SAP Netweaver Gateway Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SAP Netweaver Gateway replication to Apache Kafka.
-
How to Connect to Live Adobe Target Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Adobe Target data for you.
-
Access Live Planio Data in AWS Lambda
Connect to live Planio data in AWS Lambda using the CData JDBC Driver.
-
Connect to and Query Tally Data in QlikView over ODBC
Create data visualizations with Tally data in QlikView.
-
Load Google Spanner Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google Spanner data to a database.
-
Connect to Google Directory Data in Google Apps Script via Connect AI
Use CData Connect AI to access Google Directory data in Google Apps Script.
-
Access Live Certinia Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Certinia data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Visualize Live Perplexity Data in the Power BI Service
Use CData Connect AI to connect to live Perplexity data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build a Simple VCL Application for Quaderno Data
How to build a simple VCL Application to view Quaderno data in RAD Studio using the CData ODBC Driver for Quaderno.
-
How to Create Power BI Visual Reports with Real-Time Amazon Athena Data
Use CData Power BI Connectors to visualize Amazon Athena data in Power BI.
-
Analyze Asana Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Asana from Power Pivot. You will use the Table Import Wizard to load Asana data. You can visually build the import query or use any SQL supported by the driver.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Facebook Ads
Provide connectivity to Facebook Ads data through an SAP BusinessObjects universe.
-
How to connect to Parquet Data in DBVisualizer
Integrate Parquet data with visual data analysis tools and data connection wizards in DBVisualizer
-
Replicate Multiple Notion Accounts
Replicate multiple Notion accounts to one or many databases.
-
Query BigCommerce Data as a MySQL Database in Node.js
Execute MySQL queries against BigCommerce data from Node.js.
-
Easily Integrate Retently Data in Lazarus Pascal IDE
Learn how to easily integrate live Retently data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.