CData Software - Knowledge Base
Recent Articles
-
Integrating IBM Cloud Object Storage Data in Talend Cloud Data Management Platform
Connect IBM Cloud Object Storage Data with Talend Cloud Data Management Platform using the CData JDBC Driver for IBM Cloud Object Storage.
-
Getting Started with the CData Power BI Connector for Shippo
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to create an RPA flow for Nuclia Data in UiPath Studio
Use the Nuclia ODBC Driver to create workflows that access real-time Nuclia data without any coding.
-
DataBind Controls to Splunk Data in C++Builder
DataBind to Splunk data in C++Builder with standard components and controls.
-
Replicate Pipedrive Data from PowerShell
Write a quick PowerShell script to query Pipedrive data. Use connectivity to the live data to replicate Pipedrive data to SQL Server.
-
How to Work with Webex Data in AWS Glue Jobs Using JDBC
Connect to Webex from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build Dashboards with Testmonitor Data in DBxtra
Create dynamic dashboards and perform analytics based on Testmonitor data in DBxtra.
-
Connect DB2 to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect DB2 with IBM WebSphere for seamless data integration and connectivity.
-
Automated Continuous Zuora Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Zuora data replication to OneLake in Microsoft Fabric.
-
Use the CData Software JDBC Driver for eBay in MicroStrategy Desktop
Connect to eBay data in MicroStrategy Desktop using the CData Software JDBC Driver for eBay.
-
How to Connect Microsoft Ads Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Microsoft Ads data in real time using natural language.
-
Work with Live Dynamics 365 Data in Power Query
Use CData Connect AI to connect to Dynamics 365 data and work with live Dynamics 365 data in Microsoft Power Query.
-
Integrating Kiro with Todoist 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.
-
Load OneNote Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load OneNote data to a database.
-
Build Semantic Layer Views for Lakebase Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Lakebase data.
-
How to Build an ETL App for eBay Analytics Data in Python with CData
Create ETL applications and real-time data pipelines for eBay Analytics data in Python with petl.
-
How to Query FormSite Data in MySQL Workbench
Execute MySQL queries against live FormSite data from MySQL Workbench.
-
Excel Spreadsheet Automation on ZeroBounce Data with the QUERY Formula
Pull data from ZeroBounce, automate spreadsheets, and more with the QUERY formula.
-
Integrate Live Shopify Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Shopify data from within the IDE.
-
Visualize Live Microsoft Ads Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Microsoft Ads data into custom reports in Power BI.
-
Integrating Gumloop with SFTP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on SFTP data within automated workflows.
-
Connect to Retently in SpagoBI
Create reports featuring live Retently data in SpagoBI Studio. Host Retently reports on SpagoBI Server.
-
How to publish and share Nethunt Data dashboards with Tableau Server
The CData ODBC driver for Nethunt enables you integrate Nethunt data into Tableau dashboards.
-
Connect to Adobe Commerce Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Adobe Commerce and the SQL Gateway to access Adobe Commerce data from Google Apps Script.
-
Automated Continuous Apify Replication to Vertica
Use CData Sync for automated, continuous, customizable Apify replication to Vertica.
-
Automated Continuous Amazon Athena Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Amazon Athena replication to Apache Cassandra.
-
Automated Continuous Tally Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Tally replication to IBM DB2.
-
Query PostgreSQL Data as a MySQL Database in Node.js
Execute MySQL queries against PostgreSQL data from Node.js.
-
Use the CData Software ODBC Driver for Cvent in MicroStrategy Web
Connect to Cvent data in MicroStrategy Web using the CData Software ODBC Driver for Cvent.
-
How to Work with Invoiced Data in AWS Glue Jobs Using JDBC
Connect to Invoiced from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
DataBind Controls to Adobe Commerce Data in C++Builder
DataBind to Adobe Commerce data in C++Builder with standard components and controls.
-
Connect to Webflow Data in DBeaver
Use the CData ODBC Driver to connect to Webflow data in DBeaver.
-
How to Connect the Power BI Service to Attio: Complete Guide
Connect to the CData Software Power BI Connector for Attio from PowerBI.com to provide real-time Attio data across the organization.
-
Import and Visualize Jumpseller Data in Power View
Create data visualizations based on Jumpseller data in Excel.
-
Connect to Aweber Data in DBArtisan
Use wizards in DBArtisan to configure Aweber data as a data source.
-
Visualize Live Shippo Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Shippo data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Stream Browserless Data into Apache Kafka Topics
Access and stream Browserless data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to import SharePoint Excel Services Data into Apache Solr
Use the CData Software JDBC Driver for SharePoint Excel Services in Data Import Handler and create an automated import of SharePoint Excel Services data to Apache Solr Enterprise Search platform.
-
Query TaxJar Data in ColdFusion
Write standard ColdFusion data access code to connect to TaxJar data.
-
Access Live Attio 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 Attio data through MCP integration.
-
Use ChatGPT to Talk to Your Microsoft Teams Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Microsoft Teams data for you.
-
DataBind Controls to Outreach.io Data in C++Builder
DataBind to Outreach.io data in C++Builder with standard components and controls.
-
SAP BusinessObjects BI Reporting in OBIEE with the SAP BusinessObjects BI JDBC Driver
Deploy the SAP BusinessObjects BI JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build an OLAP Cube in SSAS from Sybase Data
Establish a connection to Sybase data data from SQL Server Analysis Services, and use the Sybase Data Provider to build OLAP cubes for use in analytics and reporting.
-
Access Live Pipeliner CRM Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Pipeliner CRM data into the statistical analysis tools available in SAS JMP. This article shows how to use Pipeliner CRM data in the Graph Builder and Query Builder.
-
Analyze Marketo Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Marketo data in Microsoft R Open.
-
View Reports on Real-Time Reply.io Data in Power BI Report Server
Use the CData ODBC Driver for Reply.io to visualize Reply.io data in Power BI Desktop and then publish them to Power BI Report Server.
-
Visualize Microsoft OneDrive Data in TIBCO Spotfire through OData
Integrate Microsoft OneDrive data into dashboards in TIBCO Spotfire.
-
Build an OLAP Cube in SSAS from ClickUp Data
Establish a connection to ClickUp data data from SQL Server Analysis Services, and use the ClickUp Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Live OneNote Data in MicroStrategy through CData Connect AI
Create a live connection to OneNote Data in CData Connect AI and connect to your OneNote data from MicroStrategy.
-
Access Live HubSpot Data in Coginiti Pro
Connect to and query live HubSpot data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to ActiveCampaign Data in DBeaver
Use the CData ODBC Driver to connect to ActiveCampaign data in DBeaver.
-
Connect to Greenplum Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Greenplum Data and connect to Greenplum data in Akorbi Digital RunMyProcess.
-
Integrating Claude Code with SAP Ariba Source Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on SAP Ariba Source data within assisted coding and automated development workflows.
-
Connect to Oracle Service Cloud in SpagoBI
Create reports featuring live Oracle Service Cloud data in SpagoBI Studio. Host Oracle Service Cloud reports on SpagoBI Server.
-
Connect to Gong Data in NetBeans
Connect to Gong data in NetBeans with the data source configuration wizard.
-
Connect to Real-Time Email Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Email and Dataflow to import and use Email data in Power Apps.
-
Use the CData Software ODBC Driver for Phoenix in MicroStrategy Desktop
Connect to Phoenix data in MicroStrategy Desktop using the CData Software ODBC Driver for Phoenix.
-
Integrate with Live HubSpot Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to HubSpot from the MuleSoft Anypoint Platform to integrate live HubSpot data into custom reports and dashboards.
-
Visualize Live Google Calendar Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Google Calendar data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous Workday Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Workday replication to AlloyDB.
-
Automated Continuous Campaigner Replication to MongoDB
Use CData Sync for automated, continuous, customizable Campaigner replication to MongoDB.
-
Connect to Vercel Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Vercel data.
-
Use the CData Software JDBC Driver for Customer.io in MicroStrategy Web
Connect to Customer.io data in MicroStrategy Web using the CData Software JDBC Driver for Customer.io.
-
Manage Float Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Float.
-
How to connect to Perplexity Data with Squirrel SQL client
Connect to Perplexity data and execute queries in the Squirrel SQL Client.
-
How to import Avro Data into Apache Solr
Use the CData Software JDBC Driver for Avro in Data Import Handler and create an automated import of Avro data to Apache Solr Enterprise Search platform.
-
Build Sugar CRM-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Sugar CRM data without replication.
-
Use Databricks Agent Bricks to Talk to Your Avro Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Avro data for you.
-
Establish a Live Connection with Adobe Commerce Data using Tableau Bridge
The CData ODBC Driver for Adobe Commerce enables you to integrate live Adobe Commerce data into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Work with Cloudant Data in ETL Validator JDBC
Connect to Cloudant from ETL Validator jobs using the CData Software JDBC Driver.
-
Access Live ScrapingBee Data in Coginiti Pro
Connect to and query live ScrapingBee data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Getting Started with the CData Tableau Connector for Zoho Books
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Zoho Books.
-
Connect to Box Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Box as an External Source in Dremio.
-
Connect to HubSpot Data in JRuby
Create a simple JRuby app with access to live HubSpot data.
-
Create Apps from Zoom Data in Qlik Sense Cloud
Use CData Connect AI to connect to Zoom Data and build apps from live Zoom data in Qlik Sense Cloud.
-
Getting Started with the CData JDBC Driver for Smartsheet
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Smartsheet.
-
Build Dashboards with ZohoInvoice Data in Dundas BI
Create dynamic dashboards and perform analytics based on ZohoInvoice data in Dundas BI.
-
Connect to and Query Quaderno Data in QlikView over ODBC
Create data visualizations with Quaderno data in QlikView.
-
DataBind Controls to CloudConvert Data in Delphi
DataBind to CloudConvert data in Delphi with standard data access components and controls.
-
Migrating data from ZohoDesk to Databricks using CData SSIS Components.
Easily push ZohoDesk data to Databricks using the CData SSIS Tasks for ZohoDesk and Databricks.
-
Connect to SendInBlue 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 SendInBlue and work with SendInBlue data in your FileMaker application.
-
Query Teamgate Data in ColdFusion
Write standard ColdFusion data access code to connect to Teamgate data.
-
How to integrate Salesforce with Apache Airflow
Access and process Salesforce data in Apache Airflow using the CData JDBC Driver.
-
Integrating Gumloop with Amazon Marketplace Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Amazon Marketplace data within automated workflows.
-
Create Reports from Google Directory Data in Looker Studio
Use CData Connect AI to gain access to live Google Directory data and create custom reports in Looker Studio.
-
Campaigner Reporting in OBIEE with the Campaigner JDBC Driver
Deploy the Campaigner JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Work with Live Salesforce Data in Power Query
Use CData Connect AI to connect to Salesforce data and work with live Salesforce data in Microsoft Power Query.
-
How to Build an ETL App for SAP Fieldglass Data in Python with CData
Create ETL applications and real-time data pipelines for SAP Fieldglass data in Python with petl.
-
Build Instagram-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Instagram Data and create custom apps in Bubble.
-
Use Dash to Build Web Apps on Microsoft Teams Data via CData Connect AI
Build interactive Dash web apps on live Microsoft Teams data using pandas and the CData Connect AI Python SDK.
-
Operational Reporting on Qualaroo Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Qualaroo data.
-
Automate Insightly Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Insightly data from PowerShell? This article demonstrates how to utilize the Insightly Cmdlets for tasks like connecting to Insightly data, automating operations, downloading data, and more.
-
Use Claude to Talk to Your Grafana 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 Grafana data for you.
-
Natively Connect to Bitbucket Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Bitbucket data. Leverage the native support for ODBC in PHP.
-
Query Live Lakebase 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 Lakebase data directly from the development environment.
-
How to Connect Flowise AI Agents to Live Workday Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Workday data without replication.
-
Integrate Vimeo with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Vimeo with External Services.
-
Getting Started with the CData ODBC Driver for TaxJar
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for TaxJar.
-
DataBind Charts to WooCommerce Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to WooCommerce 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.