CData Software - Knowledge Base
Recent Articles
-
Import Real-Time Postmark Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Postmark data in ColdFusion.
-
Analyze Salesforce CRM Analytics Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Salesforce CRM Analytics data in Microsoft R Open.
-
Use Biml to Build SSIS Tasks to Replicate HelloSign Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate HelloSign data to SQL Server.
-
Connect to CockroachDB Data in RazorSQL
Connect to CockroachDB from wizards and query CockroachDB data from the GUI in the RazorSQL database management tool.
-
Viewing Shopify Data in RAD Studio Data Explorer
How to view Shopify data in RAD Studio Data Explorer using the CData ODBC Driver for Shopify.
-
Integrate Live Dynamics 365 Business Central 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 Dynamics 365 Business Central data from within the IDE.
-
Access Perplexity Data from MySQL in Amazon QuickSight
Connect to Perplexity and build visualizations of Perplexity data using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous CouchDB Replication to MongoDB
Use CData Sync for automated, continuous, customizable CouchDB replication to MongoDB.
-
Connect to Freshservice Data from PowerBuilder via JDBC
This article demonstrates how to access Freshservice data from PowerBuilder using the Freshservice JDBC Driver.
-
Excel Spreadsheet Automation on Procore Data with the QUERY Formula
Pull data from Procore, automate spreadsheets, and more with the QUERY formula.
-
Rapidly Develop Invoiced-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Invoiced.
-
Create Reports from XML Data in Looker Studio
Use CData Connect AI to gain access to live XML data and create custom reports in Looker Studio.
-
DataBind Controls to Bitbucket Data in C++Builder
DataBind to Bitbucket data in C++Builder with standard components and controls.
-
Connect to Datadog Data in Jaspersoft Studio
Execute SQL to remote Datadog data in Jaspersoft Studio.
-
Connect to Figshare Data in HULFT Integrate
Connect to Figshare as a JDBC data source in HULFT Integrate
-
How to create an RPA flow for HCL Domino Data in UiPath Studio
Use the HCL Domino ODBC Driver to create workflows that access real-time HCL Domino data without any coding.
-
Automate SendPulse Data Replication to SAP HANA
Use CData Sync to customize and automate SendPulse data replication to SAP HANA.
-
Choosing the Best Method to Connect Microsoft Planner to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Microsoft Planner data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous Guru Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Guru replication to Azure SQL Database.
-
A PostgreSQL Interface for Testmonitor Data using the CData ODBC Driver
Use the SQL Gateway and Testmonitor ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Templated Replication to SQL Server
Use CData Sync for automated, continuous, customizable Templated replication to SQL Server.
-
Use Claude to Talk to Your Tally 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 Tally data for you.
-
Integrate Flowlu Data in the Pentaho Report Designer
Publish reports based on Flowlu data in the Pentaho BI tool.
-
Visualize Foursquare 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 Foursquare data into TIBCO Spotfire.
-
Connect to Highrise Data in CloverDX (formerly CloverETL)
Transfer Highrise data using the visual workflow in the CloverDX data integration tool.
-
Use Manus AI to Talk to Your Perplexity 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 Perplexity data.
-
Connect to Azure Data Catalog Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Azure Data Catalog Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Query Mailgun Data in MySQL Workbench
Execute MySQL queries against live Mailgun data from MySQL Workbench.
-
Connect to Airtable Data from HeidiSQL
Use CData Connect AI to connect to and query live Airtable data from HeidiSQL.
-
How to Create Power BI Visual Reports with Real-Time SAP BusinessObjects BI Data
Use CData Power BI Connectors to visualize SAP BusinessObjects BI data in Power BI.
-
Import SAS Data Sets Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to SAS Data Sets Data and provide access to live SAS Data Sets data for custom reports in the Power BI Service.
-
Connect to Mouseflow in SpagoBI
Create reports featuring live Mouseflow data in SpagoBI Studio. Host Mouseflow reports on SpagoBI Server.
-
Integrate Placid Data in Pentaho Data Integration
Build ETL pipelines based on Placid data in the Pentaho Data Integration tool.
-
Connect to IBM Cloud Object Storage Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live IBM Cloud Object Storage data.
-
Connect to LaunchDarkly Data in DBeaver
Use the CData ODBC Driver to connect to LaunchDarkly data in DBeaver.
-
Connect to Live Mailgun Data in MicroStrategy through CData Connect AI
Create a live connection to Mailgun Data in CData Connect AI and connect to your Mailgun data from MicroStrategy.
-
Working with Raisers Edge NXT Data in LINQPad
Execute LINQ queries to Raisers Edge NXT data in LINQPad.
-
How to connect PolyBase to Microsoft Entra ID
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Microsoft Entra ID data.
-
Connect to MongoDB Data in RazorSQL
Connect to MongoDB from wizards and query MongoDB data from the GUI in the RazorSQL database management tool.
-
Integrate Trae with Live Grafana Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Grafana data from within the AI-powered IDE.
-
Use Databricks Agent Bricks to Talk to Your Zoho Creator Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Zoho Creator data for you.
-
Working with Dynamics 365 Data in LINQPad
Execute LINQ queries to Dynamics 365 data in LINQPad.
-
Use JayDeBeApi to access Sage 200 Data in Python
Use standard Python scripting and the development environment of your choice to access live Sage 200 data.
-
Publish CapsuleCRM-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live CapsuleCRM data.
-
Using the CData Software ODBC Driver for LinkedIn Ads in PyCharm
Connect to LinkedIn Ads as an ODBC data source in PyCharm using the CData Software ODBC Driver for LinkedIn Ads.
-
Establish a Live Connection with Google Drive Data using Tableau Bridge
The CData ODBC Driver for Google Drive enables you to integrate live Google Drive data into Tableau Cloud dashboards using the Tableau Bridge.
-
Build AI Agents with Zuora Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Zuora data through CData Connect AI.
-
Automated Continuous ChargeOver Replication to Oracle
Use CData Sync for automated, continuous, customizable ChargeOver replication to Oracle.
-
Add SurveyMonkey Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SurveyMonkey with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build Sage Cloud Accounting Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Sage Cloud Accounting data and build visualizations in Tableau Cloud.
-
DataBind Controls to EmailOctopus Data in C++Builder
DataBind to EmailOctopus data in C++Builder with standard components and controls.
-
Visualize Live HubDB Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live HubDB data into custom reports in Power BI.
-
Automated Continuous SingleStore Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable SingleStore replication to Google Cloud SQL.
-
Using the CData Software ODBC Driver for Coda in PyCharm
Connect to Coda as an ODBC data source in PyCharm using the CData Software ODBC Driver for Coda.
-
Replicate Todoist Data to Multiple Databases
Replicate Todoist data to disparate databases with a point-and-click configuration.
-
Access Live JDBC-ODBC Bridge Data in AWS Lambda (with IntelliJ IDEA)
Connect to live JDBC-ODBC Bridge data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use Dash to Build to Web Apps on Bitbucket Data
Create Python applications that use pandas and Dash to build Bitbucket-connected web apps.
-
Build SendPulse-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for SendPulse Data and create custom apps in Mendix.
-
Visualize Live AdRoll Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live AdRoll data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating OpenCode with Coda 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 Google Sheets Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Google Sheets data within automated workflows.
-
Build a PostgreSQL Interface for Oracle HCM Cloud Data using the CData JDBC Driver
Use the Remoting features of the Oracle HCM Cloud JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connecting Pipedream with Splunk Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Splunk data in real time.
-
Publish Jodoo-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Jodoo data.
-
How to work with Mocean Data in Apache Spark using SQL
Access and process Mocean Data in Apache Spark using the CData Software JDBC Driver.
-
Build Freshteam Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Freshteam data and build visualizations in Tableau.
-
How to import Authorize.Net Data into Apache Solr
Use the CData Software JDBC Driver for Authorize.Net in Data Import Handler and create an automated import of Authorize.Net data to Apache Solr Enterprise Search platform.
-
Viewing Calendly Data in RAD Studio Data Explorer
How to view Calendly data in RAD Studio Data Explorer using the CData ODBC Driver for Calendly.
-
Integrate Trae with Live Outreach.io Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Outreach.io data from within the AI-powered IDE.
-
Visualize HDFS Data in Sisense
Create an ElastiCube in Sisense app with access to HDFS data.
-
Use ChatGPT to Talk to Your AfterShip 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 AfterShip data for you.
-
Migrating data from Scrapfly to Databricks using CData SSIS Components.
Easily push Scrapfly data to Databricks using the CData SSIS Tasks for Scrapfly and Databricks.
-
Access Live Zoho Books Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Zoho Books data from your Excel spreadsheets.
-
How to connect Amazon QuickSight to Facebook Ads Data
Create a connection to Facebook Ads data in CData Connect AI and insert Facebook Ads data into Amazon QuickSight SPICE to build interactive dashboards.
-
Access Live Browserless Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Browserless data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Publish ZohoExpense-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ZohoExpense data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for BenchmarkEmail
Provide connectivity to BenchmarkEmail data through an SAP BusinessObjects universe.
-
Integrate Live Mistral AI Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Mistral AI data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Query Live Reckon Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Reckon data through a conversational interface.
-
How to publish and share SAP Business One Data dashboards with Tableau Server
The CData ODBC driver for SAP Business One enables you integrate SAP Business One data into Tableau dashboards.
-
Integrate Trae with Live SAP Fieldglass Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live SAP Fieldglass data from within the AI-powered IDE.
-
Automated Continuous Google Sheets Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Google Sheets replication to Google BigQuery.
-
Automated Continuous TaxJar Replication to Snowflake
Use CData Sync for automated, continuous, customizable TaxJar replication to Snowflake.
-
Automated Continuous Azure Blob Storage Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to Azure SQL Database.
-
Analyze BigCommerce Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of BigCommerce data and visualize live BigCommerce data in Infragistics Reveal.
-
Getting Started with the CData Power BI Connector for Sugar CRM
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Sugar CRM.
-
Use Agno to Talk to Your Trello Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Trello data for you.
-
Object-Relational Mapping (ORM) with Zoho Creator Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Zoho Creator data into a Java-based ORM framework, Hibernate.
-
Connect to and Query IBM Cloud Object Storage Data in QlikView over ODBC
Create data visualizations with IBM Cloud Object Storage data in QlikView.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for BenchmarkEmail
Provide connectivity to BenchmarkEmail data through an SAP BusinessObjects universe.
-
Import Adobe Target Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Adobe Target Data and provide access to live Adobe Target data for custom reports in the Power BI Service.
-
Automated Continuous Oracle HCM Cloud Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to Amazon Redshift.
-
Use Grok to Talk to Your Vault CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Vault CRM data for you.
-
Integrate Trae with Live eBay Analytics Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live eBay Analytics data from within the AI-powered IDE.
-
Connect to Salesforce Pardot Data from a Connection Pool in Jetty
The Salesforce Pardot JDBC Driver supports connection pooling: This article shows how to connect faster to Salesforce Pardot data from Web apps in Jetty.
-
Sage 200 Reporting in OBIEE with the Sage 200 JDBC Driver
Deploy the Sage 200 JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Query PabblySubscriptions Data in MySQL Workbench
Execute MySQL queries against live PabblySubscriptions data from MySQL Workbench.
-
Build Dashboards with Miro Data in DBxtra
Create dynamic dashboards and perform analytics based on Miro data in DBxtra.
-
Work with SAP HANA Data in FoxPro
Load SAP HANA data into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to integrate Metabase with PostgreSQL Data
Use CData Connect AI to connect to live PostgreSQL data and create an interactive dashboard in Metabase from PostgreSQL data.