CData Software - Knowledge Base
Recent Articles
-
Write a Simple Go Application to work with Amazon DynamoDB on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Amazon DynamoDB.
-
Create Power BI Reports on Real-Time Office 365
Use the CData ODBC Driver for Office 365 to visualize Microsoft Office 365 in Power BI Desktop.
-
How to update SAP HANA from Excel
This article explains how to transfer data from Excel to SAP HANA using the Excel Add-In for SAP HANA.
-
Build Dashboards with Certinia in DBxtra
Create dynamic dashboards and perform analytics based on Certinia in DBxtra.
-
Integrating Claude Code with Tableau CRM Analytics via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Tableau CRM Analytics within assisted coding and automated development workflows.
-
Rapidly Develop Google Sheets-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Back Up Oracle Financials Cloud to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Oracle Financials Cloud. In this article, we will employ an SSIS workflow to populate a database with Oracle Financials Cloud data.
-
Build Charts with MailChimp in Clear Analytics
Create dynamic charts and perform analytics based on MailChimp in Clear Analytics.
-
Phoenix Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Phoenix facts in real time.
-
Automated Continuous Oracle Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Oracle replication to delimited files (CSV/TSV).
-
Visualize ServiceNow in Tableau
The CData ODBC driver for ServiceNow enables you integrate ServiceNow into Tableau dashboards.
-
Import Real-Time LinkedIn Ads via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use LinkedIn Ads in ColdFusion.
-
Build Semantic Layer Views for Jira in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Atlassian Jira.
-
Use Databricks Agent Bricks to Talk to Your Workday via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Workday for you.
-
Use the CData Software ODBC Driver for HarperDB in MicroStrategy Desktop
Connect to HarperDB in MicroStrategy Desktop using the CData Software ODBC Driver for HarperDB.
-
Import Real-Time Salesforce Pardot via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Salesforce Pardot in ColdFusion.
-
View Reports on Real-Time Confluence in Power BI Report Server
Use the CData ODBC Driver for Confluence to visualize Atlassian Confluence in Power BI Desktop and then publish them to Power BI Report Server.
-
Use the CData ODBC Driver for CockroachDB in Microsoft Power Query
You can use the CData CockroachDB ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import CockroachDB into Microsoft Power Query.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Zoho CRM using the Model Context Protocol.
-
Connect to Exact Online from AWS Glue
Use CData Connect AI to gain access to live Exact Online from your AWS Glue jobs.
-
Bridge Google Drive Connectivity with Apache NiFi
Access and process Google Drive in Apache NiFi using the CData JDBC Driver.
-
How to connect to Freshdesk in DBVisualizer
Integrate Freshdesk with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to MySQL in ACL Analytics
Connect to MySQL via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to MySQL.
-
View Reports on Real-Time Asana in Power BI Report Server
Use the CData ODBC Driver for Asana to visualize Asana in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate Live IBM Informix into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to IBM Informix from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live IBM Informix.
-
Access Live SurveyMonkey in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live SurveyMonkey through MCP integration.
-
How to Import Data from SAP HANA XS Advanced into Google Sheets
Import SAP HANA XS Advanced into a Google spreadsheet that is automatically refreshed.
-
Build Sage Intacct-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Sage Intacct.
-
How to Connect to Live Jira Service Management in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Atlassian Jira Service Management for you.
-
DataBind Charts to SAP
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SAP ERP/NetWeaver 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.
-
How to Connect to Google Directory in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Google Directory. Leverage the pyodbc module for ODBC in Python.
-
Edit and Search Oracle Sales External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Oracle Sales to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Oracle Sales objects that you can access from apps and the dashboard.
-
Replicate Multiple Azure DevOps Accounts
Replicate multiple Azure DevOps accounts to one or many databases.
-
Getting Started with the CData JDBC Driver for Klipfolio
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Klipfolio.
-
Access Live MailChimp in Excel 365 Online (Excel for the web)
Connect to MailChimp from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Automated Continuous LinkedIn Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable LinkedIn replication to Azure SQL Database.
-
Analyze Dynamics CRM in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Microsoft Dynamics CRM and visualize live Microsoft Dynamics CRM in Infragistics Reveal.
-
Build Microsoft Exchange-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Microsoft Exchange.
-
Connect to Smartsheet from PowerBuilder via JDBC
This article demonstrates how to access Smartsheet from PowerBuilder using the Smartsheet JDBC Driver.
-
Access GitHub from MySQL in Amazon QuickSight
Connect to GitHub and build visualizations of GitHub using a MySQL Connection in Amazon QuickSight.
-
How to create SAP SuccessFactors federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SAP SuccessFactors in MySQL .
-
Use Microsoft Copilot Studio to talk to your SAP Hybris C4C via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your SAP Hybris C4C for you.
-
Access Zoho Creator 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 Zoho Creator.
-
Integrate Theia IDE with Live Oracle SCM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
How to connect to SAP ByDesign from IntelliJ
Integrate connectivity to SAP Business ByDesign with wizards in IntelliJ.
-
Use the CData Software ODBC Driver for Redshift in MicroStrategy
Connect to Amazon Redshift in MicroStrategy Developer using the CData Software ODBC Driver for Redshift.
-
Build Agents in Relevance AI with Access to Live Cloudant via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on IBM Cloudant within intelligent agent workflows.
-
Connect to Splunk from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Splunk to connect to Splunk and execute queries in PowerBuilder.
-
Integrate Real-Time Access to CockroachDB in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to CockroachDB in real time.
-
Connect to Adobe Analytics in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Adobe Analytics and connect to Adobe Analytics in Akorbi Digital RunMyProcess.
-
Connect to Kafka in CloverDX (formerly CloverETL)
Transfer Apache Kafka using the visual workflow in the CloverDX data integration tool.
-
Bidirectional Access to Pipedrive from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Pipedrive in Filemaker Pro for Mac or Windows.
-
Build Apps with Live HubSpot in Adalo using CData Connect AI
Use CData Connect AI to integrate live HubSpot into the Adalo platform and build custom mobile and web applications with real-time HubSpot.
-
Visualize BigQuery in Tableau
The CData ODBC driver for BigQuery enables you integrate Google BigQuery into Tableau dashboards.
-
How to Build an ETL App for eBay in Python with CData
Create ETL applications and real-time data pipelines for eBay in Python with petl.
-
Connect Zoho CRM to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Zoho CRM with IBM WebSphere for seamless data integration and connectivity.
-
How to Access Live MongoDB in Power Automate Desktop via ODBC
The CData ODBC Driver for MongoDB enables you to integrate MongoDB into workflows built using Microsoft Power Automate Desktop.
-
Integrate Real-Time Access to Microsoft OneDrive in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Microsoft OneDrive in real time.
-
Access Live Kintone Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Kintone data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Connect to JSON Services Using the Script Function in Claris FileMaker Pro
-