CData Software - Knowledge Base
Recent Articles
-
Connect to Bannerbear Data from a Connection Pool in Jetty
The Bannerbear JDBC Driver supports connection pooling: This article shows how to connect faster to Bannerbear from Web apps in Jetty.
-
Extract, Transform, and Load Mailjet Data in Informatica PowerCenter
Create a simple Workflow for Mailjet in Informatica PowerCenter.
-
Migrating data from Freshdesk to Databricks using CData SSIS Components.
Easily push Freshdesk to Databricks using the CData SSIS Tasks for Freshdesk and Databricks.
-
Choosing the Best Method to Connect ZohoMarketingHub to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ZohoMarketingHub from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Use a Microsoft Access Database to Update OneNote Data in Real Time
Update OneNote data by creating a linked table in Microsoft Access with the CData OneNote ODBC Driver.
-
Use Claude to Talk to Your SendGrid 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 SendGrid for you.
-
Connect to Google Ad Manager Data in HULFT Integrate
Connect to Google Ad Manager as a JDBC data source in HULFT Integrate
-
Create a Data Access Object for Basecamp Data using JDBI
A brief overview of creating a SQL Object API for Basecamp in JDBI.
-
Access Bright Data Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Bright Data.
-
Visualize Spark Data in Sisense
Create an ElastiCube in Sisense app with access to Apache Spark SQL.
-
Create JSON-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to JSON Services from OutSystems and build custom enterprise apps using live JSON.
-
Automated Continuous PolarTeamPro Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable PolarTeamPro replication to OneLake in Microsoft Fabric.
-
Query Google Cloud Storage Data as a MySQL Database in Node.js
Execute MySQL queries against Google Cloud Storage from Node.js.
-
Automated Continuous Zoom Replication to MongoDB
Use CData Sync for automated, continuous, customizable Zoom replication to MongoDB.
-
Create Salesforce Pardot Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Salesforce Pardot from PowerBI.com to create Power BI Dataflows with real-time data.
-
Back Up Active Directory to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Active Directory. In this article, we will employ an SSIS workflow to populate a database with Active Directory data.
-
Connect to Gong Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Gong as an External Source in Dremio.
-
How to use SQLAlchemy ORM to access Workday Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Workday.
-
How to Work with Coda Data in ETL Validator JDBC
Connect to Coda from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Work with Oracle HCM Cloud Data in ETL Validator JDBC
Connect to Oracle HCM Cloud from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Bright Data Data in Ruby
Connect to Bright Data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Access Live Shopify Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Shopify enables you to integrate Shopify into workflows built using Microsoft Power Automate Desktop.
-
How to Query Live Authorize.Net Data in Perplexity MacOS Desktop
Connect to and query live Authorize.Net Data in Perplexity Desktop using CData MCP Server.
-
Design BIRT Reports on Gmail Data
Provide current Gmail to your embedded analytics.
-
Integrating Cursor CLI with PhantomBuster 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 Beeminder Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Beeminder from HeidiSQL.
-
Automate Google Ad Manager Data Replication to SAP HANA
Use CData Sync to customize and automate Google Ad Manager replication to SAP HANA.
-
Deploy the ADO.NET Provider for Excel Online on an SSRS Report Server
Connect to Microsoft Excel Online 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.
-
Build DB2 Visualizations in Tableau Desktop
Use CData Connect AI to connect to live IBM DB2 and build visualizations in Tableau.
-
Working with Pinterest Data in LINQPad
Execute LINQ queries to Pinterest in LINQPad.
-
Work with Productboard Data in FoxPro
Load Productboard into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrating Codex CLI with Greenhouse 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 Google Spanner Data in DBArtisan
Use wizards in DBArtisan to configure Google Spanner as a data source.
-
Create Reports with Retently Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Retently.
-
Connect to Oracle SCM Data from PowerBuilder via ADO.NET
This article demonstrates how to access Oracle SCM from Appeon PowerBuilder using the CData ADO.NET Provider for Oracle SCM.
-
How to Query Recurly Data in MySQL Workbench
Execute MySQL queries against live Recurly from MySQL Workbench.
-
Use Claude to Talk to Your Smartsheet 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 Smartsheet for you.
-
Work with Landbot Data in FoxPro
Load Landbot into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connecting Mastra with SAP ByDesign Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time SAP Business ByDesign, no replication required.
-
Connect to Quaderno Data in JRuby
Create a simple JRuby app with access to live Quaderno.
-
Automated Continuous Salesforce Replication to MongoDB
Use CData Sync for automated, continuous, customizable Salesforce replication to MongoDB.
-
How to Query Live Billsby Data in Claude Desktop
Connect to and query live Billsby Data in Claude Desktop using CData MCP Server.
-
Visualize Mailgun Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Mailgun.
-
How to Work with SendInBlue Data in ETL Validator JDBC
Connect to SendInBlue from ETL Validator jobs using the CData Software JDBC Driver.
-
Build ShipStation Visualizations in Tableau Cloud
Use CData Connect AI to connect to live ShipStation and build visualizations in Tableau Cloud.
-
Automated Continuous Phoenix Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Phoenix replication to Apache Cassandra.
-
Integrate with Live SAS Data Sets Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to SAS Data Sets from the MuleSoft Anypoint Platform to integrate live SAS Data Sets into custom reports and dashboards.
-
Connect to Shortcut Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Shortcut in the Denodo Virtual DataPort Administrator.
-
Automated Continuous Dynamics 365 Business Central Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to Google BigQuery.
-
Access Live ServiceNow Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live ServiceNow through MCP integration.
-
Design BIRT Reports on Hugging Face Data
Provide current Hugging Face to your embedded analytics.
-
Connect to Hacker News Data in Aqua Data Studio
Access Hacker News from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Enable the Snapchat Ads JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Snapchat Ads.
-
Build Dotmailer-Powered Applications in Cursor with CData MCP Server
Use the CData API Driver for MCP Server to explore live Dotmailer Data in Cursor to assist with building Dotmailer-powered applications.
-
Connect to Real-Time PingOne Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for PingOne and Dataflow to import and use PingOne in Power Apps.
-
Use Dash to Build to Web Apps on Rootly Data
Create Python applications that use pandas and Dash to build Rootly-connected web apps.
-
Choosing the Best Method to Connect xBase to SQL Server: 5 Options Explained
Discover multiple ways to connect and use xBase from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Create Datasets from Codat in Domo Workbench and Build Visualizations of Codat Data in Domo
Use the CData Software ODBC Driver for Codat to create datasets from Codat in Domo Workbench and then build visualizations in the Domo service.
-
Connecting GenSpark with Greenplum Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Pivotal GreenPlum without any replication or custom integration required.
-
Import Real-Time CouchDB Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Apache CouchDB in ColdFusion.
-
Create Informatica Mappings From/To a JDBC Data Source for Harvest
Create Harvest data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Use the CData ODBC Driver for Miro in Microsoft Power Query
You can use the CData Miro ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Miro into Microsoft Power Query.
-
Connect to Live CockroachDB Data in MicroStrategy through CData Connect AI
Create a live connection to CockroachDB Data in CData Connect AI and connect to your CockroachDB from MicroStrategy.
-
Build SharePoint-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for SharePoint to explore live SharePoint Data in Claude Code to assist with building SharePoint-powered applications.
-
Integrate with Teamwork Data in JReport Designer
Create charts and reports based on Teamwork in JReport Designer.
-
Automated Continuous Bugsnag Replication to MySQL
Use CData Sync for automated, continuous, customizable Bugsnag replication to MySQL.
-
Build Dashboards with HubSpot Data in DBxtra
Create dynamic dashboards and perform analytics based on HubSpot in DBxtra.
-
Automated Continuous Salesloft Replication to Databricks
Use CData Sync for automated, continuous, customizable Salesloft replication to Databricks.
-
Build Charts with Square Data in Clear Analytics
Create dynamic charts and perform analytics based on Square in Clear Analytics.
-
Visualize Live FreshBooks Data in the Power BI Service
Use CData Connect AI to connect to live FreshBooks and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Easily Query Avaza Data in OpenOffice Base
Connect to Avaza data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Mode Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Mode facts in real time.
-
Connect to CSV from a Connection Pool in WebLogic
Use the CData JDBC Driver for CSV to connect to CSV/TSV Files from Web applications running on WebLogic.
-
Building Dynamic Web Pages with Moosend Data Using AngularJS
Create single-page applications with live connectivity to Moosend using the CData API Server.
-
How to Create Power BI Visual Reports with Real-Time MarkLogic Data
Use CData Power BI Connectors to visualize MarkLogic in Power BI.
-
Connect to Dynamics 365 Data in Claris FileMaker Pro
Use the CData ODBC Driver for Dynamics 365 in FileMaker Pro to connect to Dynamics 365 and work with Microsoft Dynamics 365 in your FileMaker applications.
-
Integrating OpenCode Terminal 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.
-
Create SSAS Tabular Models from Nethunt Data
How to build a SQL Server Analysis Service Tabular Model from Nethunt using CData drivers.
-
DataBind Printify Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Printify to a chart.
-
Publish Sage 300-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Sage 300.
-
Access Google Ad Manager Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Google Ad Manager from HeidiSQL.
-
Explore Geographical Relationships in Google Campaign Manager 360 Data with Power Map
Create data visualizations with Google Campaign Manager 360 in Power Map.
-
Create OneNote-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to OneNote Data from Klipfolio and build custom visualizations using live Microsoft OneNote.
-
Build AI/ML Models with Live Retently Data using Dataiku
Connect Retently Data with Dataiku using the CData API Driver for JDBC.
-
Publish Reports with Zuora Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Zuora.
-
Use Dash to Build to Web Apps on Elasticsearch Data
Create Python applications that use pandas and Dash to build Elasticsearch-connected web apps.
-
Connect to DB2 Data in DBeaver
Use the CData ODBC Driver to connect to IBM DB2 in DBeaver.
-
Integrate Instagram Data in the Pentaho Report Designer
Publish reports based on Instagram in the Pentaho BI tool.
-
Analyze Quickbase Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Quickbase and visualize live Quickbase in Infragistics Reveal.
-
Build Semantic Layer Views for WooCommerce Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for WooCommerce.
-
Bannerbear Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Bannerbear facts in real time.
-
Integrate Cline with Live Monday.com Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Monday.com from within your IDE.
-
Using DirectQuery in Power BI with CData Power BI Connectors
CData Power BI Connectors support the DirectQuery connection mode in Power BI, allowing users to query large datasets in real-time without having to import the data locally.
-
How to connect SharePoint with BigCommerce Data through external lists
Provide BigCommerce to SharePoint users as an external list.
-
Automate Rootly Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Rootly and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Publish Reports with Google Search Results in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Search.
-
Connect to Google Drive Data from AWS Glue
Use CData Connect AI to gain access to live Google Drive from your AWS Glue jobs.
-
DataBind ZendeskSell Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide ZendeskSell to a chart.
-
Automated Continuous OData Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable OData replication to Apache Cassandra.
-
Automated Continuous Sybase Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Sybase replication to Google BigQuery.