CData Software - Knowledge Base
Recent Articles
-
Access Live Datadog Data in Coginiti Pro
Connect to and query live Datadog from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Import Reckon Accounts Hosted Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Reckon Accounts Hosted Data and provide access to live Reckon Accounts Hosted for custom reports in the Power BI Service.
-
Connect to Kafka Data in Jaspersoft Studio
Execute SQL to remote Apache Kafka in Jaspersoft Studio.
-
Visualize BigCommerce Data in Sisense
Create an ElastiCube in Sisense app with access to BigCommerce.
-
Automated Continuous Bannerbear Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Bannerbear replication to Amazon S3.
-
Prepare, Blend, and Analyze Azure Data Catalog Data in Alteryx Designer (ODBC)
Build workflows to access live Azure Data Catalog for self-service data analytics.
-
Integrating Cursor CLI with ClickUp 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.
-
A PostgreSQL Interface for OneNote Data (MySQL Remoting via JDBC)
Use the Remoting features of the OneNote JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect to Apify Data from Spring Boot
Connect to Apify in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to OneNote Data from Crystal Reports
Use CData Connect AI to connect to and report on live Microsoft OneNote from Crystal Reports.
-
How to Connect to Live SAP SuccessFactors 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 SAP SuccessFactors for you.
-
Use the CData API Server to Access Square Data in Microsoft PowerPivot
Use the CData API Server to connect to live Square in the Power Pivot business intelligence tool.
-
How to Use a Microsoft Access Database to Update Spark Data in Real Time
Update Spark data by creating a linked table in Microsoft Access with the CData Spark ODBC Driver.
-
Edit and Search ActiveCampaign External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of ActiveCampaign to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create ActiveCampaign objects that you can access from apps and the dashboard.
-
Enable the Monday.com JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Monday.com.
-
Connect to Factorial Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Factorial and the SQL Gateway to access Factorial from Google Apps Script.
-
How to update SuiteCRM from Excel
This article explains how to transfer data from Excel to SuiteCRM using the Excel Add-In for SuiteCRM.
-
Query JSON Services in ColdFusion
Write standard ColdFusion data access code to connect to JSON.
-
Create Reports with Instantly Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Instantly.
-
Build a Singer.io Tap for Oracle With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Oracle data using
-
Integrate Azure Data Lake Storage Data in the Pentaho Report Designer
Publish reports based on Azure Data Lake Storage in the Pentaho BI tool.
-
Integrating Claude Code CLI with Sybase IQ 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.
-
Build SQL Server-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for SQL Server to explore live SQL Server Data in Cursor to assist with building SQL Server-powered applications.
-
Use the CData Software ODBC Driver for Sybase IQ in SAS for Real-Time Reporting and Analytics
Connect to real-time Sybase IQ in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Sybase IQ.
-
How to create Visio diagrams from WooCommerce Data
Automatically update WooCommerce with the changes you make to Visio master shapes.
-
Automated Continuous GitLab Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable GitLab replication to Google BigQuery.
-
Build AI/ML Models with Live Amazon S3 Data using Dataiku
Connect Amazon S3 Data with Dataiku using the CData JDBC Driver for Amazon S3.
-
Integrate Amazon Athena with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Amazon Athena with External Services.
-
Using the CData Software ODBC Driver for Ontraport in PyCharm
Connect to Ontraport as an ODBC data source in PyCharm using the CData Software ODBC Driver for Ontraport.
-
Automate ClickTime Data Replication to Azure Synapse
Use CData Sync to customize and automate ClickTime replication to Azure Synapse.
-
How to Visualize SAP Business Warehouse Data in Python with pandas
Use pandas and other modules to analyze and visualize live SAP Business Warehouse in Python.
-
Access Google Forms Data from MySQL in Amazon QuickSight
Connect to Google Forms and build visualizations of Google Forms using a MySQL Connection in Amazon QuickSight.
-
Connect to Exact Online from a Connection Pool in WebLogic
Use the CData JDBC Driver for Exact Online to connect to Exact Online from Web applications running on WebLogic.
-
Analyze Outlook Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Outlook with the CData JDBC Driver for Outlook.
-
Connect to Sage Intacct from Asprova with CData Software ODBC Driver for Sage Intacct
This article shows how to connect faster to Sage Intacct data from Asprova.
-
Create Amazon DynamoDB Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Amazon DynamoDB data access from reports, embedded analytics, and more.
-
Build an OLAP Cube in SSAS from PagerDuty Data
Establish a connection to PagerDuty data from SQL Server Analysis Services, and use the PagerDuty Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Access Dynamics 365 Business Central Data Using Entity Framework
This article shows how to access Dynamics 365 Business Central using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrate Live CockroachDB Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live CockroachDB to Blue Prism using the CData ODBC Driver for CockroachDB to create automated workflows for repetitive business tasks.
-
Analyze Bitly Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Bitly with the CData JDBC Driver for Bitly.
-
Integrate Live Zuora Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Zuora to Blue Prism using the CData ODBC Driver for Zuora to create automated workflows for repetitive business tasks.
-
Connecting GenSpark with Google Campaign Manager 360 Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Google Campaign Manager 360 without any replication or custom integration required.
-
Connect to ZohoDesk Data in Jaspersoft Studio
Execute SQL to remote ZohoDesk in Jaspersoft Studio.
-
Create Bright Data Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Bright Data data access from reports, embedded analytics, and more.
-
Use the CData Software JDBC Driver for SAP Concur in MicroStrategy Web
Connect to SAP Concur in MicroStrategy Web using the CData Software JDBC Driver for SAP Concur.
-
Connect to Amplitude Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Amplitude to connect to Amplitude and execute queries in PowerBuilder.
-
DataBind Controls to Hacker News Data in Delphi
DataBind to Hacker News in Delphi with standard data access components and controls.
-
Connect to CampaignMonitor Data in Jaspersoft Studio
Execute SQL to remote CampaignMonitor in Jaspersoft Studio.
-
Connect to Oracle Eloqua Reporting Data in Jaspersoft Studio
Execute SQL to remote Oracle Eloqua Reporting in Jaspersoft Studio.
-
Build PhantomBuster-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to PhantomBuster and build web apps with connectivity to live PhantomBuster.
-
Automate Sage 300 Data Replication to Azure Synapse
Use CData Sync to customize and automate Sage 300 replication to Azure Synapse.
-
How to create an RPA flow for Hive Data in UiPath Studio
Use the Hive ODBC Driver to create workflows that access real-time Apache Hive without any coding.
-
Access Live Nuclia Data in AWS Lambda
Connect to live Nuclia in AWS Lambda using the CData JDBC Driver.
-
Create Datasets from Square in Domo Workbench and Build Visualizations of Square Data in Domo
Use the CData Software ODBC Driver for Square to create datasets from Square in Domo Workbench and then build visualizations in the Domo service.
-
Connect to ConvertAPI Data in HULFT Integrate
Connect to ConvertAPI as a JDBC data source in HULFT Integrate
-
Integrate Cline with Live Adobe Commerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Adobe Commerce from within your IDE.
-
Use Agno to Talk to Your Facebook 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 Facebook for you.
-
How to connect to Marketo Data with Squirrel SQL client
Connect to Marketo and execute queries in the Squirrel SQL Client.
-
How to connect PolyBase to ZohoInvoice
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live ZohoInvoice.
-
Visualize SAP Business One Data in TIBCO Spotfire through OData
Integrate SAP Business One into dashboards in TIBCO Spotfire.
-
Getting Started with the CData ODBC Driver for Onfleet
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Onfleet.
-
Access Live Zoho CRM Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Zoho CRM from your Google Sheets.
-
How to Connect the Power BI Service to Adobe Analytics: Complete Guide
Connect to the CData Software Power BI Connector for Adobe Analytics from PowerBI.com to provide real-time Adobe Analytics across the organization.
-
Create Google Drive Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Google Drive data access from reports, embedded analytics, and more.
-
Odoo Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Odoo ERP through CData Connect AI using different applications and tools.
-
Natively Connect to Supabase Data in PHP
The CData ODBC driver for Supabase enables you to create PHP applications with connectivity to Supabase. Leverage the native support for ODBC in PHP.
-
Trigger Cosmos DB IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Cosmos DB with standard wizards in Logic Apps.
-
Visualize Live CircleCI Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live CircleCI.
-
Connect to Shopify from a Connection Pool in WebLogic
Use the CData JDBC Driver for Shopify to connect to Shopify from Web applications running on WebLogic.
-
Seamlessly Bring Instagram Data into Retool Using CData Connect AI
Integrate Instagram data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect to SendGrid Data in Google Apps Script via Connect AI
Use CData Connect AI to access SendGrid in Google Apps Script.
-
Use Grok to Talk to Your MailChimp 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 MailChimp for you.
-
Connect Cassandra Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Apache Cassandra using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Instagram Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Instagram using standard SQL.
-
Import Real-Time QuickBooks Time Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use QuickBooks Time in ColdFusion.
-
Integrate Typeform Data in Pentaho Data Integration
Build ETL pipelines based on Typeform in the Pentaho Data Integration tool.
-
Analyze Snowflake Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Snowflake from Power Pivot. You will use the Table Import Wizard to load Snowflake. You can visually build the import query or use any SQL supported by the driver.
-
Automated Continuous SAP Replication to MySQL
Use CData Sync for automated, continuous, customizable SAP replication to MySQL.
-
Visualize Certinia Data in TIBCO Spotfire through OData
Integrate Certinia into dashboards in TIBCO Spotfire.
-
How to integrate Metabase with HCL Domino Data
Use CData Connect AI to connect to live HCL Domino and create an interactive dashboard in Metabase from HCL Domino.
-
Natively Connect to Google Drive Data in PHP
The CData ODBC driver for Google Drive enables you to create PHP applications with connectivity to Google Drive. Leverage the native support for ODBC in PHP.
-
Enable the Greenhouse JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Greenhouse.
-
Create SSAS Tabular Models from Sybase IQ Data
How to build a SQL Server Analysis Service Tabular Model from Sybase IQ using CData drivers.
-
How to Build an ETL App for Campaigner Data in Python with CData
Create ETL applications and real-time data pipelines for Campaigner in Python with petl.
-
Analyze Live Authorize.Net Data in SAS Viya
Use CData Connect AI to connect to Authorize.Net from SAS Viya and deploy self-service analytics using live Authorize.Net.
-
Use the CData Software JDBC Driver for Onfleet in MicroStrategy
Connect to Onfleet in MicroStrategy Developer using the CData Software JDBC Driver for Onfleet.
-
Using the CData Software ODBC Driver for Google Contacts in PyCharm
Connect to Google Contacts as an ODBC data source in PyCharm using the CData Software ODBC Driver for Google Contacts.
-
Configure the CData JDBC Driver for Hubstaff in a Connection Pool in Tomcat
Connect to Hubstaff from a connection pool in Tomcat.
-
How to Visualize SAP Ariba Source Data in Python with pandas
Use pandas and other modules to analyze and visualize live SAP Ariba Source in Python.
-
Establish a Live Connection with Klipfolio Data using Tableau Bridge
The CData ODBC Driver for Klipfolio enables you to integrate live Klipfolio into Tableau Cloud dashboards using the Tableau Bridge.
-
Use the CData Software JDBC Driver for SharePoint Excel Services in MicroStrategy
Connect to SharePoint Excel Services in MicroStrategy Developer using the CData Software JDBC Driver for SharePoint Excel Services.
-
Integrating Antigravity CLI with Webex via CData CLI
Connect Webex to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automated Continuous Billsby Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Billsby replication to Google Cloud SQL.
-
Build Google Drive-Connected Apps in Choreo
Use CData Connect AI to connect to Google Drive Data from Choreo and build custom apps using live Google Drive.
-
How to Connect to Live BigQuery Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Google BigQuery without replication.
-
Visualize Placid Data in Tableau
The CData ODBC driver for Placid enables you integrate Placid into Tableau dashboards.
-
Create Act CRM Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Act CRM from PowerBI.com to create Power BI Dataflows with real-time data.
-
Using the CData Software ODBC Driver for Odoo in PyCharm
Connect to Odoo as an ODBC data source in PyCharm using the CData Software ODBC Driver for Odoo.
-
Automated Continuous Wistia Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Wistia replication to IBM DB2.
-
Create JotForm Dataflows on PowerBI.com
Connect to the CData Power BI Connector for JotForm from PowerBI.com to create Power BI Dataflows with real-time data.