CData Software - Knowledge Base
Recent Articles
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Amazon DynamoDB
Provide connectivity to Amazon DynamoDB data through an SAP BusinessObjects universe.
-
How to connect to Pushbullet Data from Spring Boot
Connect to Pushbullet in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to Microsoft Entra ID from Asprova with CData Software ODBC Driver for Microsoft Entra ID
This article shows how to connect faster to Microsoft Entra ID data from Asprova.
-
Working with Airtable Data in LINQPad
Execute LINQ queries to Airtable data in LINQPad.
-
How to import Xero Data into Apache Solr
Use the CData Software JDBC Driver for Xero in Data Import Handler and create an automated import of Xero data to Apache Solr Enterprise Search platform.
-
Model, Search, and Visualize Live Kafka Data in ThoughtSpot
Use CData Connect AI to connect to live Kafka data for modeling, searching, and visualizing.
-
Choosing the Best Method to Connect Demio to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Demio data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Create Apps from ActiveCampaign Data in Qlik Sense Cloud
Use CData Connect AI to connect to ActiveCampaign Data and build apps from live ActiveCampaign data in Qlik Sense Cloud.
-
Create Dashboards and Visualize Live Toggl Data in Geckoboard
Use CData Connect AI to connect to live Toggl data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Automated Continuous Chargebee Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Chargebee replication to Apache Kafka.
-
Connect to SAP ByDesign Data in NetBeans
Connect to SAP ByDesign data in NetBeans with the data source configuration wizard.
-
Easily Integrate Microsoft Planner Data in Lazarus Pascal IDE
Learn how to easily integrate live Microsoft Planner data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate Mode Data in Pentaho Data Integration
Build ETL pipelines based on Mode data in the Pentaho Data Integration tool.
-
Getting Started with the CData Power BI Connector for Google Sheets
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Google Sheets.
-
How to load Insightly data into Elasticsearch via Logstash
Introducing a simple method to load Insightly data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automated Continuous RabbitMQ Replication to SQL Server
Use CData Sync for automated, continuous, customizable RabbitMQ replication to SQL Server.
-
Query Live Zuora Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Zuora data directly from the development environment.
-
Import and Visualize Amazon DynamoDB Data in Power View
Create data visualizations based on Amazon DynamoDB data in Excel.
-
Connect to Notion Data in ACL Analytics
Connect to Notion data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Notion data.
-
Build LinkedIn-Connected Apps in Choreo
Use CData Connect AI to connect to LinkedIn Data from Choreo and build custom apps using live LinkedIn data.
-
Use the CData Software ODBC Driver for Oracle Eloqua Reporting in SAS for Real-Time Reporting and Analytics
Connect to real-time Oracle Eloqua Reporting data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Oracle Eloqua Reporting.
-
Connect to SAP Fieldglass Data in Aqua Data Studio
Access SAP Fieldglass data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Rapidly Develop BambooHR-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 BambooHR.
-
Integrate Goose with Live Outreach.io Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Outreach.io data from within the local AI agent.
-
Create Dashboards and Visualize Live Square Data in Geckoboard
Use CData Connect AI to connect to live Square data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect to WooCommerce Data in Aqua Data Studio
Access WooCommerce data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build an OLAP Cube in SSAS from Oracle Sales Data
Establish a connection to Oracle Sales data data from SQL Server Analysis Services, and use the Oracle Sales Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build Visualizations of Copper Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Copper data in Birst.
-
How to Connect DBeaver to IBM Informix via a JDBC Driver
Manage IBM Informix data with visual tools in DBeaver like the query browser.
-
View Reports on Real-Time SageHR Data in Power BI Report Server
Use the CData ODBC Driver for SageHR to visualize SageHR data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating Active Directory Data in Talend Cloud Data Management Platform
Connect Active Directory Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Active Directory.
-
Use Agno to Talk to Your Wave Financial Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Wave Financial data for you.
-
DataBind Microsoft Entra ID Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Microsoft Entra ID with the DevExpress Windows Forms and Web controls to provide Microsoft Entra ID data to a chart.
-
How to load Landbot data into Elasticsearch via Logstash
Introducing a simple method to load Landbot data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Access ConvertAPI Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live ConvertAPI data from HeidiSQL.
-
Build Lakebase-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Lakebase Data and create custom apps in Mendix.
-
Create Power BI Reports on Real-Time AfterShip Data
Use the CData ODBC Driver for AfterShip to visualize AfterShip data in Power BI Desktop.
-
Integrating GitHub Copilot with CockroachDB 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.
-
Outreach.io Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Outreach.io data through CData Connect AI using different applications and tools.
-
ShipEngine Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to ShipEngine data through CData Connect AI using different applications and tools.
-
Build EnterpriseDB-Connected Apps in Choreo
Use CData Connect AI to connect to EnterpriseDB Data from Choreo and build custom apps using live EnterpriseDB data.
-
How to load Lakebase data into Elasticsearch via Logstash
Introducing a simple method to load Lakebase data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Access Live Helpscout Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Helpscout data into the statistical analysis tools available in SAS JMP. This article shows how to use Helpscout data in the Graph Builder and Query Builder.
-
Publish Reports with SAP Ariba Procurement Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP Ariba Procurement data.
-
DataBind Charts to Demio Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Demio 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.
-
Access Live Shortcut Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Shortcut data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Import and Visualize WooCommerce Data in Power View
Create data visualizations based on WooCommerce data in Excel.
-
Use Databricks Agent Bricks to Talk to Your Quickbase Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Quickbase data for you.
-
Replicate Presto Data from PowerShell
Write a quick PowerShell script to query Presto data. Use connectivity to the live data to replicate Presto data to SQL Server.
-
Automated Continuous Amazon Athena Replication to Vertica
Use CData Sync for automated, continuous, customizable Amazon Athena replication to Vertica.
-
Connect to Wistia Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Wistia data.
-
Migrating data from Bright Data to Google BigQuery using CData SSIS Components.
Easily push Bright Data data to Google BigQuery using the CData SSIS Tasks for Bright Data and Google BigQuery.
-
How to Connect to Live DocuSign Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live DocuSign data securely in real time.
-
Work with Live Google Forms Data in Power Query
Use CData Connect AI to connect to Google Forms data and work with live Google Forms data in Microsoft Power Query.
-
Design BIRT Reports on Opsgenie Data
Provide current Opsgenie data to your embedded analytics.
-
Create Datasets from Google Translate in Domo Workbench and Build Visualizations of Google Translate Data in Domo
Use the CData Software ODBC Driver for Google Translate to create datasets from Google Translate data in Domo Workbench and then build visualizations in the Domo service.
-
Excel Spreadsheet Automation on Adobe Commerce Data with the QUERY Formula
Pull data from Adobe Commerce, automate spreadsheets, and more with the QUERY formula.
-
How to Connect to & Open Sage 200 Data in Microsoft Excel
This article uses the CData ODBC driver for Sage 200 to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Avalara AvaTax Data from AWS Glue
Use CData Connect AI to gain access to live Avalara AvaTax data from your AWS Glue jobs.
-
A PostgreSQL Interface for Unbounce Data using the CData ODBC Driver
Use the SQL Gateway and Unbounce ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Hive Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Hive Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Build an ETL App for Dropbox Data in Python with CData Connect AI
Build ETL pipelines that read and write live Dropbox data in Python with petl and the CData Connect AI Python SDK.
-
How to Work with Notion Data in AWS Glue Jobs Using JDBC
Connect to Notion from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Visualize Paylocity Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Paylocity data.
-
Integrating Cursor with Cohere 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.
-
Explore Geographical Relationships in GraphQL Data with Power Map
Create data visualizations with GraphQL data in Power Map.
-
Automated Continuous Pinterest Replication to SQL Server
Use CData Sync for automated, continuous, customizable Pinterest replication to SQL Server.
-
Access Live Microsoft Exchange Data in Excel 365 Online (Excel for the web)
Connect to Microsoft Exchange data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Integrate OpenCode with Live FHIR Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live FHIR data from within your AI coding agent.
-
Integrate with Microsoft Entra ID Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Microsoft Entra ID data to a JSON file on disk.
-
Back Up Mailgun 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 Mailgun data data.
-
Connect to Vercel Data from a Connection Pool in JBoss
Integrate Vercel data into Java servlets: Use the Management Console in JBoss to install the Vercel JDBC Driver.
-
Access Live FreshBooks Data in Coginiti Pro
Connect to and query live FreshBooks data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous ConstantContact Replication to MongoDB
Use CData Sync for automated, continuous, customizable ConstantContact replication to MongoDB.
-
Create ADP Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ADP data access from reports, embedded analytics, and more.
-
Integrating LangGraph with MYOB AccountRight Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on MYOB AccountRight data within automated workflows.
-
Access Live Avalara AvaTax Data in TIBCO Data Virtualization
Use the Avalara AvaTax Tibco DV Adapter to create a Avalara AvaTax data data source in TIBCO Data Virtualization Studio and gain access to live Avalara AvaTax data from your TDV Server.
-
How to Access Live Snapchat Ads Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Snapchat Ads enables you to integrate Snapchat Ads data into workflows built using Microsoft Power Automate Desktop.
-
Visualize RabbitMQ Data in Tableau
The CData ODBC driver for RabbitMQ enables you integrate RabbitMQ data into Tableau dashboards.
-
Provide OData Services of Zuora Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Zuora data by developing a WCF Service Application.
-
How to Use a Microsoft Access Database to Update Microsoft Exchange Data in Real Time
Update Microsoft Exchange data by creating a linked table in Microsoft Access with the CData Microsoft Exchange ODBC Driver.
-
Provide OData Services of Airtable Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Airtable data by developing a WCF Service Application.
-
Visualize Google Sheets Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Google Sheets data.
-
How to connect SharePoint with SAP Ariba Source Data through external lists
Provide SAP Ariba Source data to SharePoint users as an external list.
-
Build Data Flows from ConvertKit to SQL Server using SSIS
Easily back up ConvertKit data to SQL Server using the SSIS components for ConvertKit.
-
Working with Mocean Data in LINQPad
Execute LINQ queries to Mocean data in LINQPad.
-
Getting Started with the CData Connect AI Python SDK for QuickBooks Time
Install the CData Connect AI Python SDK to read live QuickBooks Time data with standard DB-API 2.0 Python code.
-
Connect Cloudflare to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Cloudflare with IBM WebSphere for seamless data integration and connectivity.
-
Automate Microsoft Entra ID Data Replication to SAP HANA
Use CData Sync to customize and automate Microsoft Entra ID data replication to SAP HANA.
-
How to Connect to Live Stripe Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Stripe data without replication.
-
How to import Billsby Data into Apache Solr
Use the CData Software JDBC Driver for Billsby in Data Import Handler and create an automated import of Billsby data to Apache Solr Enterprise Search platform.
-
Connect to Flowlu Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Flowlu data.
-
Working with Webflow Data in LINQPad
Execute LINQ queries to Webflow data in LINQPad.
-
Automated Continuous Google Calendar Replication to Databricks
Use CData Sync for automated, continuous, customizable Google Calendar replication to Databricks.
-
Use Dash to Build to Web Apps on Elorus Data
Create Python applications that use pandas and Dash to build Elorus-connected web apps.
-
Connect to ChartMogul Data in Aqua Data Studio
Access ChartMogul data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrate Vercel Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Vercel data from Informatica Cloud.
-
Load VWO Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load VWO data to a database.
-
Access Live Klipfolio 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 Klipfolio data through MCP integration.
-
Integrating Claude Code with Cosmos DB Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Cosmos DB data within assisted coding and automated development workflows.