CData Software - Knowledge Base
Recent Articles
-
Integrate Bitbucket Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Bitbucket from Informatica Cloud.
-
Use CData Connect AI to Access SAS Data Sets Data in Microsoft Power Pivot
Use CData Connect AI to connect to live SAS Data Sets in the Power Pivot business intelligence tool.
-
Creating API-Connected Applications in Unqork
You can use CData Connect AI to feed API to Unqork and build custom business apps.
-
DataBind Controls to Copper Data in C++Builder
DataBind to Copper in C++Builder with standard components and controls.
-
How to Query Live SQL Server Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Microsoft SQL Server data in natural language using Python.
-
TigerGraph Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on TigerGraph facts in real time.
-
Visualize ADP Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to ADP.
-
Getting Started with the CData JDBC Driver for Moosend
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Moosend.
-
Connect to REST Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for REST.
-
Bridge Square Connectivity with Apache NiFi
Access and process Square in Apache NiFi using the CData JDBC Driver.
-
Build Agents in Relevance AI with Access to Live Kintone Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Kintone within intelligent agent workflows.
-
Connect to Mixpanel Data in JRuby
Create a simple JRuby app with access to live Mixpanel.
-
Automated Continuous Figshare Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Figshare replication to delimited files (CSV/TSV).
-
Connect Omnisend to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Omnisend using the CData Python MCP Server.
-
Create Apps from IBM Informix Data in Qlik Sense Cloud
Use CData Connect AI to connect to IBM Informix Data and build apps from live IBM Informix in Qlik Sense Cloud.
-
Visualize AlloyDB 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 Google AlloyDB into TIBCO Spotfire.
-
How to update OData from Excel
This article explains how to transfer data from Excel to OData using the Excel Add-In for OData.
-
Connect to CockroachDB Data in NetBeans
Connect to CockroachDB in NetBeans with the data source configuration wizard.
-
How to Work with Exact Online Data in AWS Glue Jobs Using JDBC
Connect to Exact Online from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Cassandra Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Cassandra Data and connect to Apache Cassandra in Akorbi Digital RunMyProcess.
-
How to Work with GitHub Data in AWS Glue Jobs Using JDBC
Connect to GitHub from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build a Simple VCL Application for Jira Assets Data
How to build a simple VCL Application to view Jira Assets in RAD Studio using the CData ODBC Driver for Jira Assets.
-
Connect to Dynamics NAV Data from a Connection Pool in Jetty
The Dynamics NAV JDBC Driver supports connection pooling: This article shows how to connect faster to Microsoft Dynamics NAV from Web apps in Jetty.
-
Connect to Webflow Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Webflow using standard SQL.
-
How to connect to Jodoo Data from IntelliJ
Integrate connectivity to Jodoo with wizards in IntelliJ.
-
Create Power BI Reports on Real-Time Authorize.Net Data
Use the CData ODBC Driver for Authorize.Net to visualize Authorize.Net in Power BI Desktop.
-
DataBind Controls to Email Data in C++Builder
DataBind to Email in C++Builder with standard components and controls.
-
How to use SQLAlchemy ORM to access Billsby Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Billsby.
-
Automated Continuous Google Analytics Replication to MySQL
Use CData Sync for automated, continuous, customizable Google Analytics replication to MySQL.
-
DataBind Controls to Act CRM Data in C++Builder
DataBind to Act CRM in C++Builder with standard components and controls.
-
Integrating Antigravity CLI with Microsoft OneNote via CData CLI
Connect Microsoft OneNote to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Publish Crystal Reports on Amazon S3 Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Amazon S3.
-
Getting Started with the CData Tableau Connector for Mixpanel
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Automated Continuous Azure DevOps Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Azure DevOps replication to PostgreSQL.
-
How to Query Live ShipEngine Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ShipEngine data in natural language using Python.
-
Trigger Zoho Projects IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Zoho Projects with standard wizards in Logic Apps.
-
Build Dashboards with SurveyMonkey Data in DBxtra
Create dynamic dashboards and perform analytics based on SurveyMonkey in DBxtra.
-
Visualize Live ADP Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live ADP into custom reports in Power BI.
-
Integrating Odoo Data in Talend Cloud Data Management Platform
Connect Odoo Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Odoo.
-
Viewing SAS Data Sets Data in RAD Studio Data Explorer
How to view SAS Data Sets in RAD Studio Data Explorer using the CData ODBC Driver for SAS Data Sets.
-
Create Data Visualizations in Cognos BI with Sage 200 Data
Access Sage 200 as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build Dashboards with Google Forms Data in DBxtra
Create dynamic dashboards and perform analytics based on Google Forms in DBxtra.
-
Build Dashboards with Autopilot Data in DBxtra
Create dynamic dashboards and perform analytics based on Autopilot in DBxtra.
-
How to Easily Query Insightly Data in OpenOffice Base
Connect to Insightly data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Build DB2-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for DB2 to explore live DB2 Data in Claude Code to assist with building DB2-powered applications.
-
Build Data Flows from Shopify to SQL Server using SSIS
Easily back up Shopify to SQL Server using the SSIS components for Shopify.
-
Use the CData Software JDBC Driver for Epicor Kinetic in MicroStrategy
Connect to Epicor Kinetic in MicroStrategy Developer using the CData Software JDBC Driver for Epicor Kinetic.
-
Build Apps with Live Supabase Data Using the Low-Code Development Platform of Mendix
Connect Supabase with Mendix to build apps using the CData API Driver for JDBC.
-
View Reports on Real-Time Slack Data in Power BI Report Server
Use the CData ODBC Driver for Slack to visualize Slack in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate with Sage Cloud Accounting Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Sage Business Cloud Accounting to a JSON file on disk.
-
Build LinkedIn-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to LinkedIn and build web apps with connectivity to live LinkedIn.
-
Process & Analyze SharePoint Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SharePoint Data.
-
Work with Live Acumatica Data in Power Query
Use CData Connect AI to connect to Acumatica ERP and work with live Acumatica ERP in Microsoft Power Query.
-
How to Create Power BI Visual Reports with Real-Time Box Data
Use CData Power BI Connectors to visualize Box in Power BI.
-
How to Connect the Power BI Service to Azure Data Lake Storage: Complete Guide
Connect to the CData Software Power BI Connector for Azure Data Lake Storage from PowerBI.com to provide real-time Azure Data Lake Storage across the organization.
-
Integrate with Live NetSuite SuiteAnalytics Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to NetSuite SuiteAnalytics from the MuleSoft Anypoint Platform to integrate live NetSuite SuiteAnalytics into custom reports and dashboards.
-
Build Semantic Layer Views for Mailgun Data in APOS Live Data Gateway
Use the CData Connector for Mailgun in APOS Live Data Gateway to build Semantic Layer Views for Mailgun.
-
Automated Continuous Accelo Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Accelo replication to Amazon S3.
-
Connect to Okta Data from a Connection Pool in Jetty
The Okta JDBC Driver supports connection pooling: This article shows how to connect faster to Okta from Web apps in Jetty.
-
Migrating data from SurveyMonkey to Snowflake using CData SSIS Components.
Easily push SurveyMonkey to Snowflake using the CData SSIS Tasks for SurveyMonkey and Snowflake.
-
Create Dashboards and Visualize Live Zuora Data in Geckoboard
Use CData Connect AI to connect to live Zuora and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Create Power BI Reports on Real-Time Browserless Data
Use the CData ODBC Driver for Browserless to visualize Browserless in Power BI Desktop.
-
Query Amazon S3 Data in DataGrip
Create a Data Source for Amazon S3 in DataGrip and use SQL to query live Amazon S3.
-
Getting Started with the CData Python Connector for MySQL
Learn to install and license the CData Python Connector
-
Deploy the ADO.NET Provider for Oracle HCM Cloud on an SSRS Report Server
Connect to Oracle HCM Cloud 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.
-
Using Mail Merge with Salesforce, SharePoint, or Google Contacts
The CData ODBC Drivers can be used from tools like Mail Merge in Microsoft Word to access live data from various sources (QuickBooks, Salesforce, SharePoint etc.). This article uses the CData ODBC Driver for Salesforce with Mail Merge, but this procedure can be follwoed for other CData ODBC drivers.
-
Create Zoho Projects-Connected Applications in Appsmith
Connect to Zoho Projects Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Zoho Projects.
-
How to Work with Freshdesk Data in AWS Glue Jobs Using JDBC
Connect to Freshdesk from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Analyze Redshift Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Amazon Redshift and visualize Amazon Redshift in SAP Analytics Cloud.
-
Use the CData Software ODBC Driver for Sage Intacct in MicroStrategy Web
Connect to Sage Intacct in MicroStrategy Web using the CData Software ODBC Driver for Sage Intacct.
-
Getting Started with the CData Excel Add-In for Microsoft Dataverse
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Microsoft Dataverse.
-
Build Data Flows from OpenWeatherMap to SQL Server using SSIS
Easily back up OpenWeatherMap to SQL Server using the SSIS components for OpenWeatherMap.
-
Connect to RSS Feeds in Google Apps Script via SQL Gateway
Use the ODBC Driver for RSS and the SQL Gateway to access RSS Feeds from Google Apps Script.
-
Access Live Instagram Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Instagram in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use the CData ODBC Driver for CSV from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for CSV to connect to CSV/TSV Files from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring CSV/TSV Files in Excel.
-
Connect to Real-Time IBM Cloud Object Storage Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for IBM Cloud Object Storage and Dataflow to import and use IBM Cloud Object Storage in Power Apps.
-
Use the CData Software JDBC Driver for Customer.io in MicroStrategy Desktop
Connect to Customer.io in MicroStrategy Desktop using the CData Software JDBC Driver for Customer.io.
-
Use the CData ODBC Driver for Optimizely in Microsoft Power Query
You can use the CData Optimizely ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Optimizely into Microsoft Power Query.
-
Visualize Live Oracle HCM Cloud Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Oracle HCM Cloud into custom reports in Power BI.
-
Automate Google Directory Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Google Directory from PowerShell? This article demonstrates how to utilize the Google Directory Cmdlets for tasks like connecting to Google Directory, automating operations, downloading data, and more.
-
Build Dashboards with IBM Cloud Object Storage Data in DBxtra
Create dynamic dashboards and perform analytics based on IBM Cloud Object Storage in DBxtra.
-
Getting Started with the CData ODBC Driver for GitHub
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for GitHub.
-
Migrating data from Databricks to Snowflake using CData SSIS Components.
Easily push Databricks to Snowflake using the CData SSIS Tasks for Databricks and Snowflake.
-
Connect to Drip Data in Aqua Data Studio
Access Drip from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Reply.io Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Reply.io using standard SQL.
-
Getting Started with the CData SSIS Components for LionDesk
Complete guide to installing, licensing, and connecting with the CData SSIS Components for LionDesk.
-
Integrating OpenCode Terminal with Webex 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.
-
Query Smartsheet Data as a MySQL Database in Node.js
Execute MySQL queries against Smartsheet from Node.js.
-
How to connect to Clari Data with Squirrel SQL client
Connect to Clari and execute queries in the Squirrel SQL Client.
-
Automated Continuous Shopify Replication to MongoDB
Use CData Sync for automated, continuous, customizable Shopify replication to MongoDB.
-
Add JobNimbus Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for JobNimbus with the Informatica Enterprise Data Catalog to classify and organize data.
-
Model Zoho Projects Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Zoho Projects, enabling the direct import of real-time Zoho Projects.
-
Import and Visualize Salesforce Data in Power View
Create data visualizations based on Salesforce & Force.com in Excel.
-
Connect to Sentry Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Sentry to connect to Sentry and execute queries in PowerBuilder.
-
Integrating Antigravity CLI with OData via CData CLI
Connect OData to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Visualize Live Ontraport Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Ontraport.
-
Connect to eBay Data from Crystal Reports
Use CData Connect AI to connect to and report on live eBay from Crystal Reports.
-
Getting Started with the CData Python Connector for Paylocity
Learn to install and license the CData Python Connector
-
How to connect and process Mocean from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Mocean.
-
Integrating Claude Code CLI with QuickBooks 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.