CData Software - Knowledge Base
Recent Articles
-
Back Up SAP BusinessObjects BI to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SAP BusinessObjects BI. In this article, we will employ an SSIS workflow to populate a database with SAP BusinessObjects BI data.
-
Access Live GitHub in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live GitHub from your Excel spreadsheets.
-
Connect to Azure Table in HULFT Integrate
Connect to Azure Table as a JDBC data source in HULFT Integrate
-
Build Cosmos DB-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Cosmos DB from Zoho Analytics and import live Azure Cosmos DB.
-
Automated Continuous Raisers Edge NXT Replication to SQL Server
Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to SQL Server.
-
DataBind Controls to TaxJar in Delphi
DataBind to TaxJar in Delphi with standard data access components and controls.
-
Bridge Marketo Connectivity with Apache NiFi
Access and process Marketo in Apache NiFi using the CData JDBC Driver.
-
How to Query Live FHIR in Perplexity MacOS Desktop
Connect to and query live FHIR in Perplexity Desktop using the CData MCP Server.
-
DataBind Controls to Greenplum in C++Builder
DataBind to Pivotal GreenPlum in C++Builder with standard components and controls.
-
Work with Todoist in FoxPro
Load Todoist into a FoxPro database. This article includes full code and a walk-through of the process.
-
A PostgreSQL Interface for Drift using the CData ODBC Driver
Use the SQL Gateway and Drift ODBC Driver to create a PostgreSQL entry-point for data access.
-
Natively Connect to Zoho Creator in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Zoho Creator. Leverage the native support for ODBC in PHP.
-
Create Adobe Analytics-Connected Dashboards in Grafana
Connect to Adobe Analytics via CData Connect AI in Grafana and create custom business dashboards with real-time access to Adobe Analytics.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Bullhorn CRM to Power BI dashboards. Simply drag and drop Bullhorn CRM into data visuals on the Power BI canvas.
-
How to Connect to Live Monday.com from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Monday.com for you.
-
Connect to RSS Feeds from PowerBuilder via JDBC
This article demonstrates how to access RSS Feeds from PowerBuilder using the RSS JDBC Driver.
-
Create Reports with Avalara AvaTax in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Avalara AvaTax.
-
Automated Continuous Tableau CRM Analytics Replication to SQLite
Use CData Sync for automated, continuous, customizable Tableau CRM Analytics replication to SQLite.
-
Trigger Microsoft Planner IFTTT Flows in Azure App Service
This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
-
Connect to Power BI XMLA in Aqua Data Studio
Access Power BI XMLA from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
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.
-
Import Real-Time Oracle HCM Cloud via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Oracle HCM Cloud in ColdFusion.
-
Bind Live SAP HANA Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SAP HANA data
-
Using the CData Software ODBC Driver for Zoom in PyCharm
Connect to Zoom as an ODBC data source in PyCharm using the CData Software ODBC Driver for Zoom.
-
Build Workday-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Workday and create custom apps in Bubble.
-
How to publish and share ShipStation dashboards with Tableau Server
The CData ODBC driver for ShipStation enables you integrate ShipStation into Tableau dashboards.
-
Creating Couchbase-Connected Applications in Unqork
You can use CData Connect AI to feed Couchbase to Unqork and build custom business apps.
-
Create MYOB AccountRight-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to MYOB AccountRight from Klipfolio and build custom visualizations using live MYOB AccountRight.
-
Connect to PingOne as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for PingOne.
-
Automated Continuous Microsoft Exchange Replication to SQLite
Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to SQLite.
-
Connect to SAP Netweaver Gateway from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SAP Netweaver Gateway using standard SQL.
-
Natively Connect to Oracle Financials Cloud in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Oracle Financials Cloud. Leverage the native support for ODBC in PHP.
-
Add Oracle SCM to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Oracle SCM with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Connect to & Open Jira Assets in Microsoft Excel
This article uses the CData ODBC driver for Jira Assets to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Reckon Accounts Hosted in Jaspersoft Studio
Execute SQL to remote Reckon Accounts Hosted in Jaspersoft Studio.
-
How to Connect to Amazon DynamoDB in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Amazon DynamoDB. Leverage the pyodbc module for ODBC in Python.
-
Use Dash to Build to Web Apps on WordPress
Create Python applications that use pandas and Dash to build WordPress-connected web apps.
-
How to Connect to Live Couchbase 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 Couchbase without replication.
-
Publish Reports with Redis in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Redis.
-
Create Adobe Commerce-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Adobe Commerce from OutSystems and build custom enterprise apps using live Adobe Commerce.
-
Build Charts with SAP Netweaver Gateway in Clear Analytics
Create dynamic charts and perform analytics based on SAP Netweaver Gateway in Clear Analytics.
-
Connect to SAP Ariba Source in RapidMiner
Integrate SAP Ariba Source with standard components and data source configuration wizards in RapidMiner Studio.
-
Create MarkLogic Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Access Zoho Creator from MySQL in PHP
Connect to Zoho Creator through the standard MySQL libraries in PHP.
-
Connect to and Query Oracle Eloqua in QlikView over ODBC
Create data visualizations with Oracle Eloqua in QlikView.
-
Build Reckon-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Reckon and build Reckon-connected web apps with Axios.
-
Add SAP HANA XS Advanced to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SAP HANA XS Advanced with the Informatica Enterprise Data Catalog to classify and organize data.
-
Getting Started with the CData ODBC Driver for Snowflake
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Snowflake.
-
Connect to HBase as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Apache HBase.
-
Validate Harvest with QuerySurge
Access and validate Harvest in QuerySurge using the CData JDBC Driver.
-
Publish Smartsheet-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Smartsheet.
-
Connect to Hive in DBeaver
Use the CData ODBC Driver to connect to Apache Hive in DBeaver.
-
Connect to OneNote through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with OneNote using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Connect the Power BI Service to Twitter Ads: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
How to connect to Acumatica with Squirrel SQL client
Connect to Acumatica ERP and execute queries in the Squirrel SQL Client.
-
Getting Started with the CData Excel Add-In for Dropbox
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Dropbox.
-
Integrate with live Azure Synapse in Jitterbit
Use CData Connect AI to connect to and integrate live Azure Synapse in Jitterbit.
-
Connect to Epicor Kinetic from a Connection Pool in JBoss
Integrate Epicor Kinetic into Java servlets: Use the Management Console in JBoss to install the Epicor Kinetic JDBC Driver.
-
How to connect to Airtable from Spring Boot
Connect to Airtable in a Spring Boot Application using CData JDBC Airtable Driver
-
Configure the CData JDBC Driver for Sage Cloud Accounting in a Connection Pool in Tomcat
Connect to Sage Business Cloud Accounting from a connection pool in Tomcat.
-
Connect to LinkedIn Ads in Google Apps Script via Connect AI
Use CData Connect AI to access LinkedIn Ads in Google Apps Script.
-
How to Query Live Couchbase in Claude Desktop
Connect to and query live Couchbase in Claude Desktop using the CData MCP Server.
-
Connect to xBase in Jaspersoft Studio
Execute SQL to remote xBase in Jaspersoft Studio.
-
Connect to Certinia from a Connection Pool in JBoss
Integrate Certinia into Java servlets: Use the Management Console in JBoss to install the Certinia JDBC Driver.
-
Automated Continuous XML Replication to AlloyDB
Use CData Sync for automated, continuous, customizable XML replication to AlloyDB.
-
Connect to Paylocity in NetBeans
Connect to Paylocity in NetBeans with the data source configuration wizard.
-
Use the CData API Server to Access Highrise in Microsoft PowerPivot
Use the CData API Server to connect to live Highrise CRM in the Power Pivot business intelligence tool.
-
View Reports on Real-Time Certinia in Power BI Report Server
Use the CData ODBC Driver for Certinia to visualize Certinia in Power BI Desktop and then publish them to Power BI Report Server.
-
Access Outreach.io from MySQL in Amazon QuickSight
Connect to Outreach.io and build visualizations of Outreach.io using a MySQL Connection in Amazon QuickSight.
-
How to Access Live Instagram in Power Automate Desktop via ODBC
The CData ODBC Driver for Instagram enables you to integrate Instagram into workflows built using Microsoft Power Automate Desktop.
-
Build Gmail-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Gmail from Zoho Analytics and import live Gmail.
-
Getting Started with the CData PowerShell Cmdlets for FHIR
-