CData Software - Knowledge Base
Recent Articles
-
Build Adobe Experience Manager Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Adobe Experience Manager data and build visualizations in Tableau Cloud.
-
Integrate Mocean with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Mocean with External Services.
-
Connect to and Visualize Live MariaDB Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live MariaDB data.
-
Replicate Accelo Data to Multiple Databases via the CData Sync CLI
Replicate Accelo data to disparate databases with a single configuration.
-
Build Data Flows from Gumroad to SQL Server using SSIS
Easily back up Gumroad data to SQL Server using the SSIS components for Gumroad.
-
Design BIRT Reports on Billsby Data
Provide current Billsby data to your embedded analytics.
-
Integrating Gumloop with DocuSign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on DocuSign data within automated workflows.
-
Analyze Blackbaud FE NXT Data in Looker
Use CData Connect AI to connect to Blackbaud FE NXT Data from Looker and build custom apps using live Blackbaud FE NXT data.
-
How to import NetSuite Data into Apache Solr
Use the CData Software JDBC Driver for NetSuite in Data Import Handler and create an automated import of NetSuite data to Apache Solr Enterprise Search platform.
-
Automate Azure Data Catalog Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Azure Data Catalog data from PowerShell? This article demonstrates how to utilize the Azure Data Catalog Cmdlets for tasks like connecting to Azure Data Catalog data, automating operations, downloading data, and more.
-
Create Datasets from ADP in Domo Workbench and Build Visualizations of ADP Data in Domo
Use the CData Software ODBC Driver for ADP to create datasets from ADP data in Domo Workbench and then build visualizations in the Domo service.
-
Access Live Perplexity Data in Coginiti Pro
Connect to and query live Perplexity data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect Everhour to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Everhour data using the CData Python MCP Server.
-
How to Access Live Miro Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Miro enables you to integrate Miro data into workflows built using Microsoft Power Automate Desktop.
-
Analyze SAP Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SAP data with the CData JDBC Driver for SAP.
-
Connect to Zoho Recruit Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Zoho Recruit data using standard SQL.
-
Integrating Claude Code with Hive Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Hive data within assisted coding and automated development workflows.
-
Work with ActiveCampaign Data in FoxPro
Load ActiveCampaign data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build eBay-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live eBay data.
-
Replicate Acumatica Data from PowerShell
Write a quick PowerShell script to query Acumatica data. Use connectivity to the live data to replicate Acumatica data to SQL Server.
-
Migrating data from Zoho Creator to Databricks using CData SSIS Components.
Easily push Zoho Creator data to Databricks using the CData SSIS Tasks for Zoho Creator and Databricks.
-
Automate SAP Netweaver Gateway Data Replication to Azure Synapse
Use CData Sync to customize and automate SAP Netweaver Gateway data replication to Azure Synapse.
-
Build Confluence-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Confluence Data from Zoho Analytics and import live Confluence data.
-
How to Connect to Live Spark 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 Spark data for you.
-
Analyze Autopilot Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Autopilot from Power Pivot. You will use the Table Import Wizard to load Autopilot data. You can visually build the import query or use any SQL supported by the driver.
-
Connect to SAP Business One Data in Claris FileMaker Pro
Use the CData ODBC Driver for SAP Business One in FileMaker Pro to connect to SAP Business One and work with SAP Business One data in your FileMaker applications.
-
Connect to Xero Data in NetBeans
Connect to Xero data in NetBeans with the data source configuration wizard.
-
Build Dashboards with Contentful Data in DBxtra
Create dynamic dashboards and perform analytics based on Contentful data in DBxtra.
-
Create Datasets from Drip in Domo Workbench and Build Visualizations of Drip Data in Domo
Use the CData Software ODBC Driver for Drip to create datasets from Drip data in Domo Workbench and then build visualizations in the Domo service.
-
Access Live Highrise Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Highrise data from your Excel spreadsheets.
-
Automated Continuous Sage Intacct Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Sage Intacct replication to Amazon S3.
-
Build Procore-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Procore Data and create custom apps in Bubble.
-
Migrating data from Google Contacts to Google BigQuery using CData SSIS Components.
Easily push Google Contacts data to Google BigQuery using the CData SSIS Tasks for Google Contacts and Google BigQuery.
-
Visualize ConstantContact Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load ConstantContact data into TIBCO Spotfire.
-
How to connect to Samanage Data from Spring Boot
Connect to Samanage in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to Mixpanel Data in Aqua Data Studio
Access Mixpanel data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Helpscout Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Helpscout and the SQL Gateway to access Helpscout data from Google Apps Script.
-
Connect to HubDB Data in HULFT Integrate
Connect to HubDB as a JDBC data source in HULFT Integrate
-
How to Visualize Strava Data in Python with pandas
Use pandas and other modules to analyze and visualize live Strava data in Python.
-
Connect to ZeroBounce Data in DBArtisan
Use wizards in DBArtisan to configure ZeroBounce data as a data source.
-
How to Connect to & Open Planio Data in Microsoft Excel
This article uses the CData ODBC driver for Planio to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Getting Started with the CData Connect AI Python SDK for Cloudant
Install the CData Connect AI Python SDK to read and write live Cloudant data with standard DB-API 2.0 Python code.
-
Connect to MessageBird Data from PowerBuilder via ADO.NET
This article demonstrates how to access MessageBird data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Automated Continuous Scrapfly Replication to Vertica
Use CData Sync for automated, continuous, customizable Scrapfly replication to Vertica.
-
Visualize Xero Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Xero data into TIBCO Spotfire.
-
Automated Continuous Microsoft Exchange Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to Google Cloud SQL.
-
Integrate Dify with Live EnterpriseDB Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live EnterpriseDB data.
-
Connect to ADP Data in RazorSQL
Connect to ADP from wizards and query ADP data from the GUI in the RazorSQL database management tool.
-
Connect WordPress to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live WordPress data using the CData Python MCP Server.
-
Connect to and Visualize Live Oracle Financials Cloud Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Oracle Financials Cloud data.
-
Establish a Live Connection with Gmail Data using Tableau Bridge
The CData ODBC Driver for Gmail enables you to integrate live Gmail data into Tableau Cloud dashboards using the Tableau Bridge.
-
Import and Visualize Pinecone Data in Power View
Create data visualizations based on Pinecone data in Excel.
-
Integrating Gumloop with Zuora Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Zuora data within automated workflows.
-
Create Act-On-Connected Business Apps in AppSheet
Connect to Act-On Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Act-On data.
-
Moving Data from Microsoft Entra ID to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Microsoft Entra ID data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Easily Integrate Tally Data in Lazarus Pascal IDE
Learn how to easily integrate live Tally data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create LDAP-Connected Applications in Appsmith
Connect to LDAP Objects via CData Connect AI in Appsmith and create custom business applications with real-time access to LDAP objects.
-
How to import Excel Data into Apache Solr
Use the CData Software JDBC Driver for Excel in Data Import Handler and create an automated import of Excel data to Apache Solr Enterprise Search platform.
-
Getting Started with the CData Power BI Connector for Oracle Financials Cloud
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Oracle Financials Cloud.
-
Create Oracle Service Cloud-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Oracle Service Cloud Data from OutSystems and build custom enterprise apps using live Oracle Service Cloud data.
-
Build Visualizations of iContact Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of iContact data in Birst.
-
Create Blackbaud FE NXT-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Blackbaud FE NXT Data from OutSystems and build custom enterprise apps using live Blackbaud FE NXT data.
-
How to Connect to Live Bright Data Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Bright Data data for you.
-
Replicate Google Cloud Storage Data to Multiple Databases
Replicate Google Cloud Storage data to disparate databases with a point-and-click configuration.
-
Replicate ShipStation Data from PowerShell
Write a quick PowerShell script to query ShipStation data. Use connectivity to the live data to replicate ShipStation data to SQL Server.
-
Access Live Autopilot Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Autopilot data into the statistical analysis tools available in SAS JMP. This article shows how to use Autopilot data in the Graph Builder and Query Builder.
-
Create a Data Access Object for PolarTeamPro Data using JDBI
A brief overview of creating a SQL Object API for PolarTeamPro data in JDBI.
-
Integrate OpenCode with Live Spark Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Spark data from within your AI coding agent.
-
Getting Started with the CData Excel Add-In for ZohoPeople
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for ZohoPeople.
-
Enable the Hacker News JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Hacker News data.
-
Connect to Pipedrive Data in DBArtisan
Use wizards in DBArtisan to configure Pipedrive data as a data source.
-
ZarMoney Reporting in OBIEE with the ZarMoney JDBC Driver
Deploy the ZarMoney JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrating Gumloop with ClickUp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on ClickUp data within automated workflows.
-
Connect to Google Contacts Data from AWS Glue
Use CData Connect AI to gain access to live Google Contacts data from your AWS Glue jobs.
-
Getting Started with the CData Excel Add-In for PDFMonkey
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for PDFMonkey.
-
Use JayDeBeApi to access Testmonitor Data in Python
Use standard Python scripting and the development environment of your choice to access live Testmonitor data.
-
Integrating OpenCode with SAP Netweaver Gateway 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.
-
Stream Landbot Data into Apache Kafka Topics
Access and stream Landbot data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to SAP HANA Data from a Connection Pool in JBoss
Integrate SAP HANA data into Java servlets: Use the Management Console in JBoss to install the SAP HANA JDBC Driver.
-
Automated Continuous XML Replication to SingleStore
Use CData Sync for automated, continuous, customizable XML replication to SingleStore.
-
Salesforce Pardot Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Salesforce Pardot data through CData Connect AI using different applications and tools.
-
Integrate Cline with Live SQL Server Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live SQL Server data from within your IDE.
-
Migrating data from Office 365 to Databricks using CData SSIS Components.
Easily push Office 365 data to Databricks using the CData SSIS Tasks for Office 365 and Databricks.
-
Getting Started with the CData Python Connector for Sybase
Learn to install and license the CData Python Connector and configure a connection to live Sybase data.
-
Automated Continuous Impala Replication to Databricks
Use CData Sync for automated, continuous, customizable Impala replication to Databricks.
-
How to work with Amazon Marketplace Data in Apache Spark using SQL
Access and process Amazon Marketplace Data in Apache Spark using the CData Software JDBC Driver.
-
Use Dash to Build to Web Apps on Printify Data
Create Python applications that use pandas and Dash to build Printify-connected web apps.
-
Connect to Presto Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Presto.
-
Visualize Live TaxJar Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live TaxJar data into custom reports in Power BI.
-
Create Datasets from DocuSign in Domo Workbench and Build Visualizations of DocuSign Data in Domo
Use the CData Software ODBC Driver for DocuSign to create datasets from DocuSign data in Domo Workbench and then build visualizations in the Domo service.
-
Access Live Zoho Projects Data in TIBCO Data Virtualization
Use the Zoho Projects Tibco DV Adapter to create a Zoho Projects data data source in TIBCO Data Virtualization Studio and gain access to live Zoho Projects data from your TDV Server.
-
Query, Visualize, and Share live SAP HANA XS Advanced Data in Redash
Use CData Connect AI to connect to live SAP HANA XS Advanced data in Redash for querying, visualizing, and sharing.
-
Back Up Google Spanner data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Google Spanner. In this article, we will employ an SSIS workflow to populate a database with Google Spanner data data.
-
Creating MarkLogic-Connected Applications in Unqork
You can use CData Connect AI to feed MarkLogic data to Unqork and build custom business apps.
-
Create MySQL-Connected Dashboards in Grafana
Connect to MySQL Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to MySQL data.
-
Query Adobe Target Data in DataGrip
Create a Data Source for Adobe Target in DataGrip and use SQL to query live Adobe Target data.
-
Natively Connect to Telegram Data in PHP
The CData ODBC driver for Telegram enables you to create PHP applications with connectivity to Telegram data. Leverage the native support for ODBC in PHP.
-
Build AI/ML Models with Live Amazon DynamoDB Data using Dataiku
Connect Amazon DynamoDB Data with Dataiku using the CData JDBC Driver for Amazon DynamoDB.
-
Create Power BI Reports on Real-Time Twitter Ads Data
Use the CData ODBC Driver for Twitter Ads to visualize Twitter Ads data in Power BI Desktop.
-
Access iContact Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live iContact data from HeidiSQL.