CData Software - Knowledge Base
Recent Articles
-
Automate OData Services Replication to SAP HANA
Use CData Sync to customize and automate OData replication to SAP HANA.
-
How to publish and share Keap Data dashboards with Tableau Server
The CData ODBC driver for Keap enables you integrate Keap into Tableau dashboards.
-
Use JayDeBeApi to access Snowflake Data in Python
Use standard Python scripting and the development environment of your choice to access live Snowflake.
-
Natively Connect to Yelp Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Yelp. Leverage the native support for ODBC in PHP.
-
Connecting Moonlit Workflow with Sybase Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Sybase in real time.
-
Connect to Google Directory Data in Jaspersoft Studio
Execute SQL to remote Google Directory in Jaspersoft Studio.
-
How to Query Suadeo Data in MySQL Workbench
Execute MySQL queries against live Suadeo from MySQL Workbench.
-
Create SSAS Tabular Models from Keap Data
How to build a SQL Server Analysis Service Tabular Model from Keap using CData drivers.
-
Rapidly Develop FHIR-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 FHIR.
-
Build Sage Cloud Accounting-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Sage Business Cloud Accounting.
-
Connect to Exact Online Data in DBeaver
Use the CData ODBC Driver to connect to Exact Online in DBeaver.
-
Visualize CSV Data in TIBCO Spotfire through ADO.NET
Integrate CSV/TSV Files into dashboards in TIBCO Spotfire.
-
Access Salesloft Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Salesloft.
-
Excel Spreadsheet Automation on BigCommerce Data with the QUERY Formula
Pull data from BigCommerce, automate spreadsheets, and more with the QUERY formula.
-
Create GitLab-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to GitLab Data from OutSystems and build custom enterprise apps using live GitLab.
-
Trigger SingleStore IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for SingleStore with standard wizards in Logic Apps.
-
Build Charts with EnterpriseDB Data in Clear Analytics
Create dynamic charts and perform analytics based on EnterpriseDB in Clear Analytics.
-
Visualize Live Twilio Data in the Power BI Service
Use CData Connect AI to connect to live Twilio and create custom reports in the Power BI Service through the On-Premises Gateway.
-
DataBind Controls to Amazon Athena Data in Delphi
DataBind to Amazon Athena in Delphi with standard data access components and controls.
-
How to Work with Codat Data in AWS Glue Jobs Using JDBC
Connect to Codat from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Extract, Transform, and Load Oracle SCM Data in Informatica PowerCenter
Create a simple Workflow for Oracle SCM in Informatica PowerCenter.
-
Create SendPulse Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SendPulse from PowerBI.com to create Power BI Dataflows with real-time data.
-
Easily Integrate Office 365 Data in Lazarus Pascal IDE
Learn how to easily integrate live Microsoft Office 365 in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build Dashboards with Gong Data in DBxtra
Create dynamic dashboards and perform analytics based on Gong in DBxtra.
-
Build SAP Concur-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SAP Concur and build web apps with connectivity to live SAP Concur.
-
Getting Started with the CData JDBC Driver for TigerGraph
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for TigerGraph.
-
Create Google Campaign Manager 360-Connected Nintex Workflows
Use CData Connect AI to connect to Google Campaign Manager 360 Data from Nintex Workflow Cloud and build custom workflows using live Google Campaign Manager 360.
-
Integrate Live Databricks Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Databricks to Blue Prism using the CData ODBC Driver for Databricks to create automated workflows for repetitive business tasks.
-
Getting Started with the CData SSIS Components for GitLab
Complete guide to installing, licensing, and connecting with the CData SSIS Components for GitLab.
-
Integrating GitHub Copilot CLI with WooCommerce 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 Grok to Talk to Your Oracle HCM Cloud 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 Oracle HCM Cloud for you.
-
Prepare, Blend, and Analyze ZendeskSell Data in Alteryx Designer (ODBC)
Build workflows to access live ZendeskSell for self-service data analytics.
-
Moving Data from Salesloft to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Salesloft data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build an OLAP Cube in SSAS from Productboard Data
Establish a connection to Productboard data from SQL Server Analysis Services, and use the Productboard Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Connect NetSuite SuiteAnalytics 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 NetSuite SuiteAnalytics data in real time using natural language.
-
Bind Live Databricks Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Databricks data
-
Integrating LlamaIndex with Zuora Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Zuora in real time.
-
Use the CData API Server to Access MongoDB Data in Microsoft PowerPivot
Use the CData API Server to connect to live MongoDB in the Power Pivot business intelligence tool.
-
Visualize PhantomBuster 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 PhantomBuster into TIBCO Spotfire.
-
Migrating data from Azure Table to Databricks using CData SSIS Components.
Easily push Azure Table Storage to Databricks using the CData SSIS Tasks for Azure Table and Databricks.
-
Connect to Samanage Data in DBArtisan
Use wizards in DBArtisan to configure Samanage as a data source.
-
Use the CData ODBC Driver for LaunchDarkly in Microsoft Power Query
You can use the CData LaunchDarkly ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import LaunchDarkly into Microsoft Power Query.
-
Create Facebook-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Facebook Data from Klipfolio and build custom visualizations using live Facebook.
-
Getting Started with the CData JDBC Driver for SAP HANA
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SAP HANA.
-
Automated Continuous JSON Replication to MySQL
Use CData Sync for automated, continuous, customizable JSON replication to MySQL.
-
Publish Crystal Reports on SAP Ariba Procurement Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SAP Ariba Procurement.
-
Build Charts with QuickBooks Data in Clear Analytics
Create dynamic charts and perform analytics based on QuickBooks Desktop in Clear Analytics.
-
Access SendPulse Data from MySQL in PHP
Connect to SendPulse through the standard MySQL libraries in PHP.
-
Create Data Visualizations in Cognos BI with Opsgenie Data
Access Opsgenie as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Active Directory Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Active Directory through CData Connect AI using different applications and tools.
-
Migrating data from Jira Assets to Databricks using CData SSIS Components.
Easily push Jira Assets to Databricks using the CData SSIS Tasks for Jira Assets and Databricks.
-
How to Access Live Oracle HCM Cloud Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Oracle HCM Cloud enables you to integrate Oracle HCM Cloud into workflows built using Microsoft Power Automate Desktop.
-
Design BIRT Reports on RabbitMQ Data
Provide current RabbitMQ to your embedded analytics.
-
Build Google Campaign Manager 360-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Google Campaign Manager 360 Data from Zoho Analytics and import live Google Campaign Manager 360.
-
Connect to Epicor Kinetic Data in RapidMiner
Integrate Epicor Kinetic with standard components and data source configuration wizards in RapidMiner Studio.
-
Work with Presto Data in FoxPro
Load Presto into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to and Visualize Live MongoDB Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live MongoDB.
-
Connect to Real-Time Landbot Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Landbot in Power Apps.
-
Migrating data from Adobe Experience Manager to Snowflake using CData SSIS Components.
Easily push Adobe Experience Manager to Snowflake using the CData SSIS Tasks for Adobe Experience Manager and Snowflake.
-
Connect to Acumatica Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Acumatica ERP using standard SQL.
-
Connect ClickTime to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live ClickTime using the CData Python MCP Server.
-
Build ShipStation-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live ShipStation.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ClickTime
Provide connectivity to ClickTime through an SAP BusinessObjects universe.
-
Automated Continuous SAP Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SAP replication to Google BigQuery.
-
How to Work with Dynamics CRM Data in ETL Validator JDBC
Connect to Dynamics CRM from ETL Validator jobs using the CData Software JDBC Driver.
-
Getting Started with the CData Python Connector for Shippo
Learn to install and license the CData Python Connector
-
How to create LinkedIn Ads federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for LinkedIn Ads in MySQL .
-
How to connect to Mailgun Data from IntelliJ
Integrate connectivity to Mailgun with wizards in IntelliJ.
-
Viewing Splunk Data in RAD Studio Data Explorer
How to view Splunk in RAD Studio Data Explorer using the CData ODBC Driver for Splunk.
-
How to create an RPA flow for OData Services in UiPath Studio
Use the OData ODBC Driver to create workflows that access real-time OData without any coding.
-
Feed Google Analytics Data into FineReport
How to set Google Analytics as a JDBC data source in FineReport.
-
Connect to Amazon Athena Data in JRuby
Create a simple JRuby app with access to live Amazon Athena.
-
Extract, Transform, and Load Landbot Data in Informatica PowerCenter
Create a simple Workflow for Landbot in Informatica PowerCenter.
-
Import Real-Time Sybase IQ Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Sybase IQ in ColdFusion.
-
Use the CData Software ODBC Driver for Grafana in MicroStrategy Web
Connect to Grafana in MicroStrategy Web using the CData Software ODBC Driver for Grafana.
-
Access Live MailChimp Data in AWS Lambda (with IntelliJ IDEA)
Connect to live MailChimp in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Feed Google Cloud Storage Data into FineReport
How to set Google Cloud Storage as a JDBC data source in FineReport.
-
Create Data Visualizations Based On Zoom Data in Mode
Use CData Connect AI to connect to Zoom Data from Mode and build visualizations using live
-
Connect to Pushbullet Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Pushbullet and the SQL Gateway to access Pushbullet from Google Apps Script.
-
Access Hive Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Apache Hive from HeidiSQL.
-
Automated Continuous Act-On Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Act-On replication to Amazon Redshift.
-
Use the CData Software ODBC Driver for SFTP in MicroStrategy
Connect to SFTP in MicroStrategy Developer using the CData Software ODBC Driver for SFTP.
-
Automate HCL Domino Data Replication to Couchbase
Use CData Sync to Customize and automate HCL Domino replication to Couchbase.
-
Connect to Excel Online Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Microsoft Excel Online in the Denodo Virtual DataPort Administrator.
-
Use the CData Software JDBC Driver for Campaigner in MicroStrategy
Connect to Campaigner in MicroStrategy Developer using the CData Software JDBC Driver for Campaigner.
-
Access Live Google Cloud Storage Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Google Cloud Storage in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create SSAS Tabular Models from Mistral AI Data
How to build a SQL Server Analysis Service Tabular Model from Mistral AI using CData drivers.
-
Publish Reports with Cloudflare Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Cloudflare.
-
Access Procore Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Procore from HeidiSQL.
-
DataBind Charts to MariaDB Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to MariaDB 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.
-
Visualize Live Miro Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Miro.
-
Use Dash to Build Web Apps on Bullhorn CRM Data via CData Connect AI
Build interactive Dash web apps on live Bullhorn CRM using pandas and the CData Connect AI Python SDK.
-
Connect to Oracle Service Cloud Data in RapidMiner
Integrate Oracle Service Cloud with standard components and data source configuration wizards in RapidMiner Studio.
-
Create Zoho CRM-Connected Dashboards in Grafana
Connect to Zoho CRM Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Zoho CRM.
-
How to integrate Salesforce CRM Analytics with Apache Airflow
Access and process Salesforce CRM Analytics in Apache Airflow using the CData JDBC Driver.
-
Natively Connect to Chargebee Data in PHP
The CData ODBC driver for Chargebee enables you to create PHP applications with connectivity to Chargebee. Leverage the native support for ODBC in PHP.
-
Access Bitly Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Bitly from your Oracle system.
-
Connect to IBM Cloud Object Storage Data in NetBeans
Connect to IBM Cloud Object Storage in NetBeans with the data source configuration wizard.
-
How to Connect to Live HCL Domino Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your HCL Domino through natural language.
-
Build an OLAP Cube in SSAS from Browserless Data
Establish a connection to Browserless data from SQL Server Analysis Services, and use the Browserless Data Provider to build OLAP cubes for use in analytics and reporting.