CData Software - Knowledge Base
Recent Articles
-
Access Live CouchDB Data in Excel 365 Online (Excel for the web)
Connect to CouchDB data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Build Dashboards with PabblySubscriptions Data in Dundas BI
Create dynamic dashboards and perform analytics based on PabblySubscriptions data in Dundas BI.
-
Access Live Box Data in Coginiti Pro
Connect to and query live Box data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access QuickBooks Custom Fields in Excel
Update custom fields in QuickBooks using the CData Excel Add-In for QuickBooks.
-
How to Create Power BI Visual Reports with Real-Time Impala Data
Use CData Power BI Connectors to visualize Impala data in Power BI.
-
Use the CData Software JDBC Driver for Zuora in MicroStrategy Web
Connect to Zuora data in MicroStrategy Web using the CData Software JDBC Driver for Zuora.
-
ETL Perigon in Oracle Data Integrator
This article shows how to transfer Perigon data into a data warehouse using Oracle Data Integrator.
-
How to connect to AgileCRM Data from Spring Boot
Connect to AgileCRM in a Spring Boot Application using the CData API Driver for JDBC
-
How to connect to PabblySubscriptions Data from IntelliJ
Integrate connectivity to PabblySubscriptions data with wizards in IntelliJ.
-
Integrating Antigravity CLI with EnterpriseDB data via CData CLI
Connect EnterpriseDB data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Link Ontraport with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Ontraport data in Filemaker Pro for Mac or Windows.
-
Integrate Dify with Live SendPulse 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 SendPulse data.
-
Replicate NetSuite Data from PowerShell
Write a quick PowerShell script to query NetSuite data. Use connectivity to the live data to replicate NetSuite data to SQL Server.
-
Integrating OpenCode with Yelp 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.
-
Connect to OnePageCrm Data from a Connection Pool in Jetty
The OnePageCrm JDBC Driver supports connection pooling: This article shows how to connect faster to OnePageCrm data from Web apps in Jetty.
-
Work with Live Google Ad Manager Data in Power Query
Use CData Connect AI to connect to Google Ad Manager data and work with live Google Ad Manager data in Microsoft Power Query.
-
How to connect PolyBase to xBase
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live xBase data.
-
Connect to Power BI XMLA Data in HULFT Integrate
Connect to Power BI XMLA as a JDBC data source in HULFT Integrate
-
Visualize Live RabbitMQ Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live RabbitMQ data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Analyze Zoom Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Zoom data in Microsoft R Open.
-
Use Microsoft Copilot Studio to talk to your SAP SuccessFactors 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 SAP SuccessFactors data for you.
-
Connect to Contentful Data in DBArtisan
Use wizards in DBArtisan to configure Contentful data as a data source.
-
Build Anaplan Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Anaplan data and build visualizations in Tableau.
-
How to connect and process Everhour data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Everhour data.
-
Access Rebilly 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 Rebilly data.
-
Build Microsoft Teams-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Microsoft Teams data and build web apps with connectivity to live Microsoft Teams data.
-
A PostgreSQL Interface for AdRoll Data (MySQL Remoting via JDBC)
Use the Remoting features of the AdRoll JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Live Azure Data Catalog Data in SAS Viya
Use CData Connect AI to connect to Azure Data Catalog data from SAS Viya and deploy self-service analytics using live Azure Data Catalog data.
-
How to Build an ETL App for AfterShip Data in Python with CData Connect AI
Extract and transform live AfterShip data in Python with petl and the CData Connect AI Python SDK.
-
Connect to Zuora Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Zuora and the Script function in FileMaker Pro to connect to Zuora and work with Zuora data in your FileMaker application.
-
Connect to Demio Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Demio and the SQL Gateway to access Demio data from Google Apps Script.
-
Integrate with Live Google Forms Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Google Forms from the MuleSoft Anypoint Platform to integrate live Google Forms data into custom reports and dashboards.
-
Connect to Excel Online Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Excel Online data.
-
How to work with Wrike Data in Apache Spark using SQL
Access and process Wrike Data in Apache Spark using the CData Software JDBC Driver.
-
Back Up HDFS data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for HDFS. In this article, we will employ an SSIS workflow to populate a database with HDFS data data.
-
Connect to Clio Data in Ruby
Connect to Clio data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Superchat Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Superchat data in the Denodo Virtual DataPort Administrator.
-
Bidirectional Access to Salesforce Marketing Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Salesforce Marketing data in Filemaker Pro for Mac or Windows.
-
Create HDFS-Connected Business Apps in AppSheet
Connect to HDFS Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to HDFS data.
-
Import Real-Time Amazon Athena Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Amazon Athena data in ColdFusion.
-
Load BenchmarkEmail Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load BenchmarkEmail data to a database.
-
Automated Continuous Oracle Service Cloud Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Oracle Service Cloud data replication to OneLake in Microsoft Fabric.
-
Integrate Live FormSite Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live FormSite data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Create Informatica Mappings From/To a JDBC Data Source for SAP HANA
Create SAP HANA data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Create Data Visualizations in Cognos BI with Zoho Creator Data
Access Zoho Creator data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrate with live ServiceDesk Plus Data in Jitterbit
Use CData Connect AI to connect to and integrate live ServiceDesk Plus data in Jitterbit.
-
Build BambooHR-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to BambooHR data and build web apps with connectivity to live BambooHR data.
-
Replicate HelloSign Data in Heroku for Use in Salesforce Connect
Replicate HelloSign data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to QuickBooks Time Data in DBArtisan
Use wizards in DBArtisan to configure QuickBooks Time data as a data source.
-
Connect to Aweber Data in Jaspersoft Studio
Execute SQL to remote Aweber data in Jaspersoft Studio.
-
Integrating Cursor with Zoho Recruit 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.
-
Integrating LangGraph with BigCommerce Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on BigCommerce data within automated workflows.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Templated
Provide connectivity to Templated data through an SAP BusinessObjects universe.
-
Connect to RabbitMQ Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time RabbitMQ data using standard SQL.
-
Use the CData Software JDBC Driver for SAP Ariba Procurement in MicroStrategy Desktop
Connect to SAP Ariba Procurement data in MicroStrategy Desktop using the CData Software JDBC Driver for SAP Ariba Procurement.
-
Use Biml to Build SSIS Tasks to Replicate Toggl Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Toggl data to SQL Server.
-
How to Connect to Live Active Directory Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Active Directory data for you.
-
Integrating LlamaIndex with SAP Netweaver Gateway Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on SAP Netweaver Gateway data in real time.
-
Replicate SendInBlue Data from PowerShell
Write a quick PowerShell script to query SendInBlue data. Use connectivity to the live data to replicate SendInBlue data to SQL Server.
-
Integrating OpenCode with HubSpot 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.
-
Search External Oracle Financials Cloud Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Oracle Financials Cloud data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Oracle Financials Cloud Data objects that you can access from apps and the dashboard.
-
How to connect Amazon QuickSight to Snowflake Data
Create a connection to Snowflake data in CData Connect AI and insert Snowflake data into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect and Visualize Live PayPal Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live PayPal data into the Databricks platform and create visualization dashboards with real-time PayPal data.
-
Getting Started with the CData ODBC Driver for HCL Domino
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for HCL Domino.
-
Create Dynamic Sage Cloud Accounting Grids Using the Infragistics XamDataGrid
Learn how you can connect Sage Cloud Accounting to Infragistics XamDataGrid to build dynamic grids.
-
How to Connect to Live SAP BusinessObjects BI 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 SAP BusinessObjects BI data for you.
-
Create Power BI Reports on Real-Time Office 365 Data
Use the CData ODBC Driver for Office 365 to visualize Office 365 data in Power BI Desktop.
-
Connect to and Visualize Live Greenplum Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Greenplum data.
-
How to Connect the Power BI Service to Cvent: Complete Guide
Connect to the CData Software Power BI Connector for Cvent from PowerBI.com to provide real-time Cvent data across the organization.
-
Build a PostgreSQL Interface for Bitly Data using the CData JDBC Driver
Use the Remoting features of the Bitly JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Sage 300 Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Sage 300 replication to Amazon Redshift.
-
Getting Started with the CData ODBC Driver for Pipedrive
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Pipedrive.
-
Use Claude to Talk to Your Tavily 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 Tavily data for you.
-
Connect to Greenplum Data in CloverDX (formerly CloverETL)
Transfer Greenplum data using the visual workflow in the CloverDX data integration tool.
-
Create Basecamp-Connected Dashboards in Grafana
Connect to Basecamp Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Basecamp data.
-
Automated Continuous Freshservice Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Freshservice replication to AlloyDB.
-
Import and Visualize SAP Netweaver Gateway Data in Power View
Create data visualizations based on SAP Netweaver Gateway data in Excel.
-
Use Microsoft Copilot Studio to talk to your SAP Fieldglass 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 SAP Fieldglass data for you.
-
Working with SAP ByDesign Data in LINQPad
Execute LINQ queries to SAP ByDesign data in LINQPad.
-
Connect to Float Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Float and work with Float data in your FileMaker application.
-
Analyze Sentry Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Sentry from Power Pivot. You will use the Table Import Wizard to load Sentry data. You can visually build the import query or use any SQL supported by the driver.
-
Automate Apify Data Replication to Azure Synapse
Use CData Sync to customize and automate Apify data replication to Azure Synapse.
-
Visualize Live AgileCRM Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live AgileCRM data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Getting Started with the CData Python Connector for Gorgias
Learn to install and license the CData Python Connector and configure a connection to live Gorgias data.
-
Automated Continuous Google Campaign Manager 360 Replication to Oracle
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to Oracle.
-
How to import Qualaroo Data into Apache Solr
Use the CData Software JDBC Driver for Qualaroo in Data Import Handler and create an automated import of Qualaroo data to Apache Solr Enterprise Search platform.
-
Access Live Qualaroo Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Qualaroo data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to integrate Metabase with Okta Data
Use CData Connect AI to connect to live Okta data and create an interactive dashboard in Metabase from Okta data.
-
Use Manus AI to Talk to Your EnterpriseDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on EnterpriseDB data.
-
Connect to and Visualize Live ZeroBounce Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live ZeroBounce data.
-
Automated Continuous Instantly Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Instantly data replication to OneLake in Microsoft Fabric.
-
Work with Oracle SCM Data in FoxPro
Load Oracle SCM data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Model, Search, and Visualize Live Marketo Data in ThoughtSpot
Use CData Connect AI to connect to live Marketo data for modeling, searching, and visualizing.
-
Access Live SendGrid 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 SendGrid data through MCP integration.
-
Build Automated Anaplan-Connected Workflows in Zapier
Use CData Connect AI to connect to live Anaplan data and build automated workflows in Zapier.
-
Use Dash to Build to Web Apps on Chargebee Data
Create Python applications that use pandas and Dash to build Chargebee-connected web apps.
-
Integrating Codex with Bullhorn CRM 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.
-
Integrate with Excel Online Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Excel Online data in SnapLogic.
-
Integrating Claude Code CLI with Timely 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.
-
Process & Analyze MySQL Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live MySQL Data.