CData Software - Knowledge Base
Recent Articles
-
View Reports on Real-Time Freshdesk Data in Power BI Report Server
Use the CData ODBC Driver for Freshdesk to visualize Freshdesk data in Power BI Desktop and then publish them to Power BI Report Server.
-
Automate Google Ad Manager Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Google Ad Manager data from PowerShell? This article demonstrates how to utilize the Google Ad Manager Cmdlets for tasks like connecting to Google Ad Manager data, automating operations, downloading data, and more.
-
Create Informatica Mappings From/To an ODBC Data Source for Unbounce
Create an ODBC connection to Unbounce in Informatica and browse and transfer Unbounce data.
-
How to connect to MarkLogic Data from IntelliJ
Integrate connectivity to MarkLogic data with wizards in IntelliJ.
-
Access Live Box Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Box data from your Excel spreadsheets.
-
Connect to Aweber Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Aweber data using standard SQL.
-
Connect to Jira Data in Google Apps Script via Connect AI
Use CData Connect AI to access Jira data in Google Apps Script.
-
Access Live Tavily Data in AWS Lambda
Connect to live Tavily data in AWS Lambda using the CData JDBC Driver.
-
Build Automated IBM Informix-Connected Workflows in Zapier
Use CData Connect AI to connect to live IBM Informix data and build automated workflows in Zapier.
-
Integrate BigQuery Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to BigQuery data and integrate live BigQuery data into your Power Automate tasks.
-
Integrate LibreChat with Live Raisers Edge NXT Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Raisers Edge NXT data from within the chat interface.
-
How to Connect to Live Authorize.Net Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Authorize.Net data for you.
-
Integrate Live Google Cloud Storage Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Google Cloud Storage data and integrate live Google Cloud Storage data into apps built in Microsoft Power Apps.
-
Integrate Theia IDE with Live Reckon Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Reckon data from within the development environment.
-
Build NetSuite SuiteAnalytics-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to NetSuite SuiteAnalytics Data from Zoho Analytics and import live NetSuite SuiteAnalytics data.
-
How to Seamlessly Import Blackbaud FE NXT Data into IBM SPSS Modeler
Integrate Blackbaud FE NXT data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Publish ActiveCampaign-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ActiveCampaign data.
-
Import TaxJar Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to TaxJar Data and provide access to live TaxJar data for custom reports in the Power BI Service.
-
Natively Connect to Shippo Data in PHP
The CData ODBC driver for Shippo enables you to create PHP applications with connectivity to Shippo data. Leverage the native support for ODBC in PHP.
-
Visualize Rootly Data in Tableau
The CData ODBC driver for Rootly enables you integrate Rootly data into Tableau dashboards.
-
How to Visualize Power BI XMLA Data in Python with pandas
Use pandas and other modules to analyze and visualize live Power BI XMLA data in Python.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for ChargeOver
Provide connectivity to ChargeOver data through an SAP BusinessObjects universe.
-
Analyze Live SAS xpt Data in SAS Viya
Use CData Connect AI to connect to SAS xpt data from SAS Viya and deploy self-service analytics using live SAS xpt data.
-
Access Live BenchmarkEmail 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 BenchmarkEmail data through MCP integration.
-
How to Visualize BigCommerce Data in Python with pandas
Use pandas and other modules to analyze and visualize live BigCommerce data in Python.
-
Create DocuSign-Connected Dashboards in Grafana
Connect to DocuSign Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to DocuSign data.
-
Integrating LangGraph with Microsoft Entra ID Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Microsoft Entra ID data within automated workflows.
-
Connect to Jodoo Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Jodoo and work with Jodoo data in your FileMaker applications.
-
Bidirectional Access to Salesforce Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Salesforce data in Filemaker Pro for Mac or Windows.
-
Getting Started with the CData ODBC Driver for LeadDesk
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for LeadDesk.
-
Access Live Microsoft Dataverse Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Microsoft Dataverse data from your Excel spreadsheets.
-
Connect to Landbot Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Landbot as an External Source in Dremio.
-
Load Opsgenie Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Opsgenie data to a database.
-
Automated Continuous Teamgate Replication to MySQL
Use CData Sync for automated, continuous, customizable Teamgate replication to MySQL.
-
Deploy the ADO.NET Provider for Strava on an SSRS Report Server
Connect to Strava data 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.
-
Automate Zoho CRM Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Zoho CRM data from PowerShell? This article demonstrates how to utilize the Zoho CRM Cmdlets for tasks like connecting to Zoho CRM data, automating operations, downloading data, and more.
-
How to create an RPA flow for SpaceX Data in UiPath Studio
Use the SpaceX ODBC Driver to create workflows that access real-time SpaceX data without any coding.
-
Prepare, Blend, and Analyze ShipStation Data in Alteryx Designer (ODBC)
Build workflows to access live ShipStation data for self-service data analytics.
-
Feed Zoho Inventory Data into FineReport
How to set Zoho Inventory data as a JDBC data source in FineReport.
-
Query, Visualize, and Share live CockroachDB Data in Redash
Use CData Connect AI to connect to live CockroachDB data in Redash for querying, visualizing, and sharing.
-
Connect to Rootly Data in Ruby
Connect to Rootly data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Create JSON-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to JSON Services from Klipfolio and build custom visualizations using live JSON services.
-
Connect to Optimizely Data in Aqua Data Studio
Access Optimizely data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Replicate Multiple ServiceNow Accounts
Replicate multiple ServiceNow accounts to one or many databases.
-
Query Oracle Service Cloud Data in ColdFusion
Write standard ColdFusion data access code to connect to Oracle Service Cloud data.
-
Automated Continuous SAP Concur Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SAP Concur replication to PostgreSQL.
-
Access Yelp Data from MySQL in Amazon QuickSight
Connect to Yelp and build visualizations of Yelp data using a MySQL Connection in Amazon QuickSight.
-
Query Microsoft Exchange Data as a MySQL Database in Node.js
Execute MySQL queries against Microsoft Exchange data from Node.js.
-
How to publish and share HubSpot Data dashboards with Tableau Server
The CData ODBC driver for HubSpot enables you integrate HubSpot data into Tableau dashboards.
-
How to Connect to Live Azure Data Catalog Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Azure Data Catalog data for you.
-
Integrating Cursor with Odoo 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.
-
Use the CData Software ODBC Driver for ZendeskSell in MicroStrategy Desktop
Connect to ZendeskSell data in MicroStrategy Desktop using the CData Software ODBC Driver for ZendeskSell.
-
Build Charts with Adobe Experience Manager Data in Clear Analytics
Create dynamic charts and perform analytics based on Adobe Experience Manager data in Clear Analytics.
-
Enable the Planio JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Planio data.
-
Connect to Nethunt from a Connection Pool in WebLogic
Use the CData JDBC Driver for Nethunt to connect to Nethunt data from Web applications running on WebLogic.
-
Connect to Optimizely Data in ACL Analytics
Connect to Optimizely data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Optimizely data.
-
Connect to Marketo Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Marketo data.
-
Integrating Dataiku with HCL Domino Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live HCL Domino data.
-
How to Query Stripe Data in MySQL Workbench
Execute MySQL queries against live Stripe data from MySQL Workbench.
-
Publish FormSite-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live FormSite data.
-
Connect to Okta Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Okta as an External Source in Dremio.
-
Integrate Real-Time Access to Dynamics 365 in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Dynamics 365 data in real time.
-
How to work with Stripe Data in Apache Spark using SQL
Access and process Stripe Data in Apache Spark using the CData Software JDBC Driver.
-
Integrate Sage 200 Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Sage 200 data and integrate live Sage 200 data into your Power Automate tasks.
-
Connect to Live Sybase Data in MicroStrategy through CData Connect AI
Create a live connection to Sybase Data in CData Connect AI and connect to your Sybase data from MicroStrategy.
-
Connecting Mastra with Google Sheets 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 Google Sheets data, no replication required.
-
Moving Data from Redshift to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Redshift data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automated Continuous FHIR Replication to MongoDB
Use CData Sync for automated, continuous, customizable FHIR replication to MongoDB.
-
How to connect to FormSite Data with Squirrel SQL client
Connect to FormSite data and execute queries in the Squirrel SQL Client.
-
Analyze HubDB Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze HubDB data with the CData JDBC Driver for HubDB.
-
Integrating LangGraph with OneNote Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on OneNote data within automated workflows.
-
Integrate OpenCode with Live Zoom Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Zoom data from within your AI coding agent.
-
Integrating LlamaIndex with SAP SuccessFactors LMS 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 SuccessFactors LMS data in real time.
-
Replicate BigCommerce Data to Multiple Databases
Replicate BigCommerce data to disparate databases with a point-and-click configuration.
-
Getting Started with the CData ODBC Driver for Figshare
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Figshare.
-
Automate Sendwithus Data Replication to SAP HANA
Use CData Sync to customize and automate Sendwithus data replication to SAP HANA.
-
Connect to Omnisend Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Omnisend as an External Source in Dremio.
-
Getting Started with the CData Excel Add-In for Zoom
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Zoom.
-
Query xBase Data as a MySQL Database in Node.js
Execute MySQL queries against xBase data from Node.js.
-
Integrate Google's Antigravity Agent with Live Reckon Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Reckon data using the Model Context Protocol.
-
Create Zendesk Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Zendesk from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Query Opsgenie Data in MySQL Workbench
Execute MySQL queries against live Opsgenie data from MySQL Workbench.
-
Using the CData Software ODBC Driver for FreeAgent in PyCharm
Connect to FreeAgent as an ODBC data source in PyCharm using the CData Software ODBC Driver for FreeAgent.
-
How to Query Coinbase Data in MySQL Workbench
Execute MySQL queries against live Coinbase data from MySQL Workbench.
-
Connect to Google Campaign Manager 360 in SpagoBI
Create reports featuring live Google Campaign Manager 360 data in SpagoBI Studio. Host Google Campaign Manager 360 reports on SpagoBI Server.
-
Query ClickUp Data as a MySQL Database in Node.js
Execute MySQL queries against ClickUp data from Node.js.
-
Connect to Real-Time Instantly Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Instantly data in Power Apps.
-
Visualize Elasticsearch 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 Elasticsearch data into TIBCO Spotfire.
-
Natively Connect to Spotify Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Spotify data. Leverage the native support for ODBC in PHP.
-
How to Work with Deel Data in AWS Glue Jobs Using JDBC
Connect to Deel from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Google Search
Provide connectivity to Google Search results through an SAP BusinessObjects universe.
-
Use the CData Software ODBC Driver for CircleCI in MicroStrategy Desktop
Connect to CircleCI data in MicroStrategy Desktop using the CData Software ODBC Driver for CircleCI.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Dropbox
Provide connectivity to Dropbox data through an SAP BusinessObjects universe.
-
Connect to Postmark Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Postmark data.
-
Automated Continuous Qualaroo Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Qualaroo replication to Google Cloud SQL.
-
Connect to Google Ads Data in RazorSQL
Connect to Google Ads from wizards and query Google Ads data from the GUI in the RazorSQL database management tool.
-
Wave Financial Reporting in OBIEE with the Wave Financial JDBC Driver
Deploy the Wave Financial JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Visualize Live Attio Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Attio data into custom reports in Power BI.
-
Automate Certinia Data Replication to Azure Data Lake
Use CData Sync to customize and automate Certinia data replication to Azure Data Lake.
-
Analyze Xero Data in Looker
Use CData Connect AI to connect to Xero Data from Looker and build custom apps using live Xero data.