CData Software - Knowledge Base
Recent Articles
-
Connecting Mastra with Amazon Marketplace 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 Amazon Marketplace, no replication required.
-
Connecting Moonlit Workflow with Google Analytics 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 Google Analytics in real time.
-
Use Dash to Build to Web Apps on LinkedIn Ads Data
Create Python applications that use pandas and Dash to build LinkedIn Ads-connected web apps.
-
Consume Splunk OData Feeds in PowerBuilder
This article demonstrates how to consume Splunk as OData feeds from PowerBuilder using the API Server.
-
Build AI/ML Models with Live MariaDB Data using Dataiku
Connect MariaDB Data with Dataiku using the CData JDBC Driver for MariaDB.
-
Integrate Live Autopilot Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Autopilot to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
How to Connect to eBay Analytics Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to eBay Analytics. Leverage the pyodbc module for ODBC in Python.
-
Access Live Aweber Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Aweber into the statistical analysis tools available in SAS JMP. This article shows how to use Aweber in the Graph Builder and Query Builder.
-
Connect to eBay Data in Google Apps Script via Connect AI
Use CData Connect AI to access eBay in Google Apps Script.
-
Explore Geographical Relationships in Zoho Inventory Data with Power Map
Create data visualizations with Zoho Inventory in Power Map.
-
How to Visualize Aweber Data in Python with pandas
Use pandas and other modules to analyze and visualize live Aweber in Python.
-
How to Visualize Jira Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Atlassian Jira in Python.
-
Connect to QuickBooks Online Data as an External Source in Dremio
Use the CData JDBC Driver to connect to QuickBooks Online as an External Source in Dremio.
-
Connect Databricks Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Databricks using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to ScrapingBee Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ScrapingBee in the Denodo Virtual DataPort Administrator.
-
How to Visualize Amazon DynamoDB Data in Python with pandas
Use pandas and other modules to analyze and visualize live Amazon DynamoDB in Python.
-
Use the CData Software ODBC Driver for Coda in MicroStrategy Desktop
Connect to Coda in MicroStrategy Desktop using the CData Software ODBC Driver for Coda.
-
Analyze SendGrid Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of SendGrid and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Automated Continuous Procore Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Procore replication to OneLake in Microsoft Fabric.
-
DataBind Charts to Recurly Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Recurly 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.
-
Build Voice Agents in ElevenLabs with access to Live Excel Online Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Microsoft Excel Online.
-
Build Google Ad Manager-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Google Ad Manager.
-
Create Aha! Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Aha! from PowerBI.com to create Power BI Dataflows with real-time data.
-
A PostgreSQL Interface for Microsoft Dataverse Data (MySQL Remoting via JDBC)
Use the Remoting features of the Microsoft Dataverse JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Odoo Data in Claris FileMaker Pro
Use the CData ODBC Driver for Odoo in FileMaker Pro to connect to Odoo and work with Odoo ERP in your FileMaker applications.
-
Publish Crystal Reports on ZohoDesk Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ZohoDesk.
-
Automated Continuous ZohoSubscriptions Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable ZohoSubscriptions replication to Google BigQuery.
-
How to connect PolyBase to Float
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Float.
-
Connect to Campaigner Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to SharePoint Excel Services Data from PowerBuilder via ADO.NET
This article demonstrates how to access SharePoint Excel Services from Appeon PowerBuilder using the CData ADO.NET Provider for SharePoint Excel Services.
-
Automate Confluence Data Replication to Azure Synapse
Use CData Sync to customize and automate Atlassian Confluence replication to Azure Synapse.
-
Excel Spreadsheet Automation on Greenplum Data with the QUERY Formula
Pull data from Greenplum, automate spreadsheets, and more with the QUERY formula.
-
Replicate Multiple CSV Accounts via the CData Sync CLI
Replicate multiple CSV accounts to one or many databases.
-
Connect QuickBooks Time Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your QuickBooks Time using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Easily Integrate REST Data in Lazarus Pascal IDE
Learn how to easily integrate live REST in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to and Query Humanity Data in QlikView over ODBC
Create data visualizations with Humanity in QlikView.
-
Add Google Sheets Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Google Sheets with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use Dash to Build to Web Apps on SharePoint Data
Create Python applications that use pandas and Dash to build SharePoint-connected web apps.
-
Automated Continuous Rebilly Replication to Databricks
Use CData Sync for automated, continuous, customizable Rebilly replication to Databricks.
-
Establish a Live Connection with ShipEngine Data using Tableau Bridge
The CData ODBC Driver for ShipEngine enables you to integrate live ShipEngine into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to SQL Analysis Services Data in JRuby
Create a simple JRuby app with access to live SQL Analysis Services.
-
Create Informatica Mappings From/To a JDBC Data Source for CloudConvert
Create CloudConvert data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Prepare, Blend, and Analyze OnePageCrm Data in Alteryx Designer (ODBC)
Build workflows to access live OnePageCrm for self-service data analytics.
-
Access Pipeliner CRM Data from MySQL in PHP
Connect to Pipeliner CRM through the standard MySQL libraries in PHP.
-
Use the CData Software ODBC Driver for Salesforce Pardot in SAS for Real-Time Reporting and Analytics
Connect to real-time Salesforce Pardot in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Salesforce Pardot.
-
Connect to Close Data in NetBeans
Connect to Close in NetBeans with the data source configuration wizard.
-
Replicate YouTube Analytics Data to Multiple Databases
Replicate YouTube Analytics to disparate databases with a point-and-click configuration.
-
How to Connect to Snowflake Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Snowflake. Leverage the pyodbc module for ODBC in Python.
-
Use the CData ODBC Driver for GetResponse from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for GetResponse to connect to GetResponse from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring GetResponse in Excel.
-
Visualize Live Certinia Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Certinia using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize Act CRM Data in Tableau
The CData ODBC driver for Act CRM enables you integrate Act CRM into Tableau dashboards.
-
Build Dashboards with Rebilly Data in Dundas BI
Create dynamic dashboards and perform analytics based on Rebilly in Dundas BI.
-
Prepare, Blend, and Analyze QuickBooks Online Data in Alteryx Designer (Connect AI)
Build workflows to access live QuickBooks Online for self-service data analytics.
-
Integrating Gumloop with SAP Fieldglass Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on SAP Fieldglass within automated workflows.
-
Load Azure Data Catalog Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Azure Data Catalog to a database.
-
Use the CData Software ODBC Driver for ConvertAPI in MicroStrategy Desktop
Connect to ConvertAPI in MicroStrategy Desktop using the CData Software ODBC Driver for ConvertAPI.
-
Integrate Live ZohoInvoice Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live ZohoInvoice to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Build Apps with Live GitLab in Adalo using CData Connect AI
Use CData Connect AI to integrate live GitLab into the Adalo platform and build custom mobile and web applications with real-time GitLab.
-
Integrating Cursor CLI with JotForm 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.
-
Prepare, Blend, and Analyze Templated Data in Alteryx Designer (ODBC)
Build workflows to access live Templated for self-service data analytics.
-
Bridge PayPal Connectivity with Apache NiFi
Access and process PayPal in Apache NiFi using the CData JDBC Driver.
-
Establish a Live Connection with Microsoft OneDrive Data using Tableau Bridge
The CData ODBC Driver for Microsoft OneDrive enables you to integrate live Microsoft OneDrive into Tableau Cloud dashboards using the Tableau Bridge.
-
PostgreSQL Reporting in OBIEE with the PostgreSQL JDBC Driver
Deploy the PostgreSQL JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
DataBind Controls to Microsoft Dataverse Data in Delphi
DataBind to Microsoft Dataverse (CDS) in Delphi with standard data access components and controls.
-
Connect to Google Drive Data in Jaspersoft Studio
Execute SQL to remote Google Drive in Jaspersoft Studio.
-
Visualize Smartsheet Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Smartsheet.
-
Add Xero Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Xero with the Informatica Enterprise Data Catalog to classify and organize data.
-
Feed Mouseflow Data into FineReport
How to set Mouseflow as a JDBC data source in FineReport.
-
Connect to Toggl Data from a Connection Pool in Jetty
The Toggl JDBC Driver supports connection pooling: This article shows how to connect faster to Toggl from Web apps in Jetty.
-
Connect to JobNimbus Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connecting Mastra with YouTube Analytics 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 YouTube Analytics, no replication required.
-
View Reports on Real-Time Cassandra Data in Power BI Report Server
Use the CData ODBC Driver for Cassandra to visualize Apache Cassandra in Power BI Desktop and then publish them to Power BI Report Server.
-
Automated Continuous VWO Replication to SQLite
Use CData Sync for automated, continuous, customizable VWO replication to SQLite.
-
Integrate Billsby with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Billsby with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Billsby.
-
Analyze Planio Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Planio in Microsoft R Open.
-
Build a Singer.io Tap for Chargebee With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Chargebee data using
-
Use the CData Software JDBC Driver for Pipedrive in MicroStrategy Web
Connect to Pipedrive in MicroStrategy Web using the CData Software JDBC Driver for Pipedrive.
-
Analyze Clari Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Clari in Microsoft R Open.
-
How to load Quaderno data into Elasticsearch via Logstash
Introducing a simple method to load Quaderno data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create Datasets from SQL Server in Domo Workbench and Build Visualizations of SQL Server Data in Domo
Use the CData Software ODBC Driver for SQL Server to create datasets from Microsoft SQL Server in Domo Workbench and then build visualizations in the Domo service.
-
Explore Geographical Relationships in LinkedIn Ads Data with Power Map
Create data visualizations with LinkedIn Ads in Power Map.
-
Use the CData Software JDBC Driver for AgileCRM in MicroStrategy Desktop
Connect to AgileCRM in MicroStrategy Desktop using the CData Software JDBC Driver for AgileCRM.
-
Use the CData Software JDBC Driver for WordPress in MicroStrategy Desktop
Connect to WordPress in MicroStrategy Desktop using the CData Software JDBC Driver for WordPress.
-
Connect to SparkPost Data in CloverDX (formerly CloverETL)
Transfer SparkPost using the visual workflow in the CloverDX data integration tool.
-
Query SQL Analysis Services Data in DataGrip
Create a Data Source for SQL Analysis Services in DataGrip and use SQL to query live SQL Analysis Services.
-
How to Create Power BI Visual Reports with Real-Time HDFS Data
Use CData Power BI Connectors to visualize Apache HDFS in Power BI.
-
Access Sybase 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 Sybase.
-
Replicate Drip Data to Multiple Databases
Replicate Drip to disparate databases with a point-and-click configuration.
-
Analyze Salesforce CRM Analytics Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Salesforce CRM Analytics from Power Pivot. You will use the Table Import Wizard to load Salesforce CRM Analytics. You can visually build the import query or use any SQL supported by the driver.
-
Visualize Salesforce CRM Analytics Data in TIBCO Spotfire through OData
Integrate Salesforce CRM Analytics into dashboards in TIBCO Spotfire.
-
Automate TaxJar Data Replication to Azure Data Lake
Use CData Sync to customize and automate TaxJar replication to Azure Data Lake.
-
Connect to and Visualize Live Perplexity Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Perplexity.
-
Access Live Flowlu Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Flowlu into the statistical analysis tools available in SAS JMP. This article shows how to use Flowlu in the Graph Builder and Query Builder.
-
Integrating Antigravity CLI with SAP HANA XS Advanced via CData CLI
Connect SAP HANA XS Advanced to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build Pipeline CRM-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Pipeline CRM.
-
Connect to and Query MongoDB Data in QlikView over ODBC
Create data visualizations with MongoDB in QlikView.
-
Visualize Billsby Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Billsby.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Square actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Query LDAP Objects through ODBC in Node.js
Use node-odbc to execute SQL queries against LDAP from Node.js.
-
Build Oracle-Connected Apps in Choreo
Use CData Connect AI to connect to Oracle Data from Choreo and build custom apps using live Oracle Database.