CData Software - Knowledge Base
Recent Articles
-
Connect EmailOctopus to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live EmailOctopus using the CData Python MCP Server.
-
Connect to Bannerbear Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Automate SAP Fieldglass Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live SAP Fieldglass and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
DataBind Controls to Elorus Data in Delphi
DataBind to Elorus in Delphi with standard data access components and controls.
-
Connect to Dynamics CRM from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Microsoft Dynamics CRM, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Build Semantic Layer Views for Salesforce CRM Analytics Data in APOS Live Data Gateway
Use the CData Connector for Salesforce CRM Analytics in APOS Live Data Gateway to build Semantic Layer Views for Salesforce CRM Analytics.
-
How to Connect to & Open Jumpseller Data in Microsoft Excel
This article uses the CData ODBC driver for Jumpseller to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Viewing HDFS Data in RAD Studio Data Explorer
How to view Apache HDFS in RAD Studio Data Explorer using the CData ODBC Driver for HDFS.
-
Use the CData Software JDBC Driver for Harvest in MicroStrategy Web
Connect to Harvest in MicroStrategy Web using the CData Software JDBC Driver for Harvest.
-
Connect to ActiveCampaign Data in RazorSQL
Connect to ActiveCampaign from wizards and query ActiveCampaign from the GUI in the RazorSQL database management tool.
-
Integrating Codex CLI with LionDesk 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.
-
Analyze Exact Online Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Exact Online and visualize Exact Online in SAP Analytics Cloud.
-
Import Real-Time LinkedIn Ads Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use LinkedIn Ads in ColdFusion.
-
Access Stack Exchange Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Stack Exchange from HeidiSQL.
-
Connect to Raisers Edge NXT Data in DBArtisan
Use wizards in DBArtisan to configure Raisers Edge NXT as a data source.
-
Query iContact Data as a MySQL Database in Node.js
Execute MySQL queries against iContact from Node.js.
-
How to Query Live SAP Fieldglass Data in Claude Desktop
Connect to and query live SAP Fieldglass Data in Claude Desktop using CData MCP Server.
-
Automated Continuous Google Ad Manager Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Google Ad Manager replication to Amazon Redshift.
-
Prepare, Blend, and Analyze IBM Cloud Object Storage Data in Alteryx Designer (ODBC)
Build workflows to access live IBM Cloud Object Storage for self-service data analytics.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Google Calendar to Power BI dashboards. Simply drag and drop Google Calendar into data visuals on the Power BI canvas.
-
Access Live Copper Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Copper into the statistical analysis tools available in SAS JMP. This article shows how to use Copper in the Graph Builder and Query Builder.
-
Integrate SingleStore Data in the Pentaho Report Designer
Publish reports based on SingleStore in the Pentaho BI tool.
-
Visualize HubDB Data in TIBCO Spotfire through ADO.NET
Integrate HubDB into dashboards in TIBCO Spotfire.
-
How to connect to Moosend Data from IntelliJ
Integrate connectivity to Moosend with wizards in IntelliJ.
-
Connect to SageHR Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SageHR as an External Source in Dremio.
-
DataBind Charts to REST Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to REST 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.
-
Create a Data Access Object for Contentful Data using JDBI
A brief overview of creating a SQL Object API for Contentful in JDBI.
-
Build Dashboards with Cohere Data in Dundas BI
Create dynamic dashboards and perform analytics based on Cohere in Dundas BI.
-
Build AI/ML Models with Live ZohoInvoice Data using Dataiku
Connect ZohoInvoice Data with Dataiku using the CData API Driver for JDBC.
-
Create Act CRM-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Act CRM Data from Klipfolio and build custom visualizations using live Act CRM.
-
Automated Continuous Avaza Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Avaza replication to PostgreSQL.
-
Connect to Autopilot Data in RazorSQL
Connect to Autopilot from wizards and query Autopilot from the GUI in the RazorSQL database management tool.
-
Access Live xBase Data in AWS Lambda
Connect to live xBase in AWS Lambda using the CData JDBC Driver.
-
Build Presto-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Presto to explore live Presto Data in Cursor to assist with building Presto-powered applications.
-
Create Greenplum Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Greenplum from PowerBI.com to create Power BI Dataflows with real-time data.
-
Getting Started with the CData Power BI Connector for Redshift
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Redshift.
-
Back Up SingleStore to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SingleStore. In this article, we will employ an SSIS workflow to populate a database with SingleStore data.
-
Integrate Live LinkedIn Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live LinkedIn to Blue Prism using the CData ODBC Driver for LinkedIn to create automated workflows for repetitive business tasks.
-
How to Query Live Azure DevOps Data in Perplexity MacOS Desktop
Connect to and query live Azure DevOps Data in Perplexity Desktop using CData MCP Server.
-
Build HCL Domino-Connected Apps in Choreo
Use CData Connect AI to connect to HCL Domino Data from Choreo and build custom apps using live HCL Domino.
-
Create Sage Cloud Accounting-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Sage Cloud Accounting Data from Klipfolio and build custom visualizations using live Sage Business Cloud Accounting.
-
Analyze Webflow Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Webflow from Power Pivot. You will use the Table Import Wizard to load Webflow. You can visually build the import query or use any SQL supported by the driver.
-
How to Access Live Shopify Data in Visual Studio Code via Cline
Run CData MCP Server for Shopify on Windows Subsytem for Linux (WSL) and connect to live Shopify from the Cline extension in Visual Studio Code.
-
Integrating TigerGraph Data in Talend Cloud Data Management Platform
Connect TigerGraph Data with Talend Cloud Data Management Platform using the CData JDBC Driver for TigerGraph.
-
Connect to Live Facebook Ads Data in MicroStrategy through CData Connect AI
Create a live connection to Facebook Ads Data in CData Connect AI and connect to your Facebook Ads from MicroStrategy.
-
Automated Continuous MarkLogic Replication to IBM DB2
Use CData Sync for automated, continuous, customizable MarkLogic replication to IBM DB2.
-
Replicate Multiple ZohoExpense Accounts
Replicate multiple ZohoExpense accounts to one or many databases.
-
Visualize Foursquare Data in TIBCO Spotfire through ADO.NET
Integrate Foursquare into dashboards in TIBCO Spotfire.
-
Create Reports from Freshdesk Data in Looker Studio
Use CData Connect AI to gain access to live Freshdesk and create custom reports in Looker Studio.
-
How to load Gmail data into Elasticsearch via Logstash
Introducing a simple method to load Gmail data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to use SQLAlchemy ORM to access ActiveCampaign Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of ActiveCampaign.
-
Access EnterpriseDB Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live EnterpriseDB from HeidiSQL.
-
Visualize Exa 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 Exa into TIBCO Spotfire.
-
How to Access Live Dropbox Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Dropbox enables you to integrate Dropbox into workflows built using Microsoft Power Automate Desktop.
-
Connect Monday.com Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Monday.com using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Validate BambooHR Data with QuerySurge
Access and validate BambooHR in QuerySurge using the CData JDBC Driver.
-
Access WooCommerce Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live WooCommerce from HeidiSQL.
-
Prepare, Blend, and Analyze Auth0 Data in Alteryx Designer (ODBC)
Build workflows to access live Auth0 for self-service data analytics.
-
Create Data Visualizations in Cognos BI with Suadeo Data
Access Suadeo as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to PagerDuty Data in CloverDX (formerly CloverETL)
Transfer PagerDuty using the visual workflow in the CloverDX data integration tool.
-
Connect to REST from a Connection Pool in WebLogic
Use the CData JDBC Driver for REST to connect to REST from Web applications running on WebLogic.
-
Integrating Codex CLI with OpenWeatherMap 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 API Server in Microsoft Power BI
You can use the CData API Server to feed SAP HANA XS Advanced to Power BI dashboards. Simply drag and drop SAP HANA XS Advanced into data visuals on the Power BI canvas.
-
Query Auth0 Data as a MySQL Database in Node.js
Execute MySQL queries against Auth0 from Node.js.
-
Query SendInBlue Data in ColdFusion
Write standard ColdFusion data access code to connect to SendInBlue.
-
Access Live Google Ad Manager Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Ad Manager from your Google Sheets.
-
Connect to PostgreSQL Data from a Connection Pool in JBoss
Integrate PostgreSQL into Java servlets: Use the Management Console in JBoss to install the PostgreSQL JDBC Driver.
-
Integrating Kiro CLI with Amazon Marketplace 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.
-
Using the CData Software ODBC Driver for Databricks in PyCharm
Connect to Databricks as an ODBC data source in PyCharm using the CData Software ODBC Driver for Databricks.
-
How to Access Wrike Data Using Entity Framework
This article shows how to access Wrike using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Microsoft Exchange Data in RapidMiner
Integrate Microsoft Exchange with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Create Power BI Visual Reports with Real-Time Okta Data
Use CData Power BI Connectors to visualize Okta in Power BI.
-
Create Informatica Mappings From/To an ODBC Data Source for ChargeOver
Create an ODBC connection to ChargeOver in Informatica and browse and transfer ChargeOver.
-
Getting Started with the CData Python Connector for Smartsheet
Learn to install and license the CData Python Connector
-
LINQ to BenchmarkEmail Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the BenchmarkEmail Data Provider.
-
Automated Continuous Google Tasks Replication to Oracle
Use CData Sync for automated, continuous, customizable Google Tasks replication to Oracle.
-
How to Connect to & Open Postmark Data in Microsoft Excel
This article uses the CData ODBC driver for Postmark to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Establish a Live Connection with Tickspot Data using Tableau Bridge
The CData ODBC Driver for Tickspot enables you to integrate live Tickspot into Tableau Cloud dashboards using the Tableau Bridge.
-
Connecting GenSpark with WooCommerce Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to WooCommerce without any replication or custom integration required.
-
ADP Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to ADP through CData Connect AI using different applications and tools.
-
Connecting to ODBC Data Sources in Google Apps Script
This article shows how to use the SQL Gateway to access ODBC data sources from Google Apps Script.
-
How to connect SharePoint with Cosmos DB Data through external lists
Provide Azure Cosmos DB to SharePoint users as an external list.
-
Build a Singer.io Tap for Templated With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Templated data using
-
Access Live Instagram Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Instagram into the statistical analysis tools available in SAS JMP. This article shows how to use Instagram in the Graph Builder and Query Builder.
-
Connect to Azure Synapse Data in Google Apps Script via Connect AI
Use CData Connect AI to access Azure Synapse in Google Apps Script.
-
How to connect Amazon QuickSight to YouTube Analytics Data
Create a connection to YouTube Analytics in CData Connect AI and insert YouTube Analytics into Amazon QuickSight SPICE to build interactive dashboards.
-
Create Datasets from Salesforce CRM Analytics in Domo Workbench and Build Visualizations of Salesforce CRM Analytics Data in Domo
Use the CData Software ODBC Driver for Salesforce CRM Analytics to create datasets from Salesforce CRM Analytics in Domo Workbench and then build visualizations in the Domo service.
-
Getting Started with the CData Power BI Connector for Rebilly
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Create Power BI Reports on Real-Time BigQuery Data
Use the CData ODBC Driver for BigQuery to visualize Google BigQuery in Power BI Desktop.
-
Build Semantic Layer Views for Discourse Data in APOS Live Data Gateway
Use the CData Connector for Discourse in APOS Live Data Gateway to build Semantic Layer Views for Discourse.
-
How to work with Aircall Data in Apache Spark using SQL
Access and process Aircall Data in Apache Spark using the CData Software JDBC Driver.
-
Manage Email Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Email.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for HDFS
Provide connectivity to Apache HDFS through an SAP BusinessObjects universe.
-
How to Work with Oracle Service Cloud Data in AWS Glue Jobs Using JDBC
Connect to Oracle Service Cloud from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Access Live Redis Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Redis into the statistical analysis tools available in SAS JMP. This article shows how to use Redis in the Graph Builder and Query Builder.
-
Connect to CampaignMonitor Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Access Live Webex Data in AWS Lambda
Connect to live Webex in AWS Lambda using the CData JDBC Driver.
-
Build Dashboards with Cosmos DB Data in Dundas BI
Create dynamic dashboards and perform analytics based on Azure Cosmos DB in Dundas BI.
-
Design BIRT Reports on Beeminder Data
Provide current Beeminder to your embedded analytics.
-
Build API-Connected Apps in Choreo
Use CData Connect AI to connect to API Data from Choreo and build custom apps using live API.