CData Software Knowledge Base

Visualize OneNote from Tableau

Use the Tableau Desktop business intelligence tool to connect to Microsoft OneNote.

Bidirectional Access to IBM Cloud Object Storage from FileMaker Pro

Use the MySQL Remoting feature of the JDBC driver to integrate IBM Cloud Object Storage in Filemaker Pro for Mac or Windows.

Create Data Visualizations in Cognos BI with Zoho Books

Access Zoho Books as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

Connect to Vault CRM as a Linked Server via SQL Gateway

Use the SQL Gateway and the ODBC Driver to set up a linked server for Veeva Vault & Vault CRM.

Build Semantic Layer Views for EventBrite in APOS Live Data Gateway

Use the CData Connector for EventBrite in APOS Live Data Gateway to build Semantic Layer Views for Eventbrite.

Consume Databricks OData Feeds in PowerBuilder

This article demonstrates how to consume Databricks as OData feeds from PowerBuilder using the API Server.

Edit and Search External Square Objects in Salesforce Connect

Use CData Connect Cloud to securely provide OData feeds of Square to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Square objects that you can access from apps and the dashboard.

How to Visualize Oracle Sales Data in Python with pandas

Use pandas and other modules to analyze and visualize live Oracle Sales in Python.

How to import QuickBooks Online into Apache Solr

Use the CData Software JDBC Driver for QuickBooks Online in Data Import Handler and create an automated import of QuickBooks Online to Apache Solr Enterprise Search platform.

Access Live WooCommerce in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

Connect to WooCommerce from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

Replicate Multiple SAP Fieldglass Accounts via the CData Sync CLI

Replicate multiple SAP Fieldglass accounts to one or many databases.

A PostgreSQL Interface for ActiveCampaign using the CData ODBC Driver

Use the SQL Gateway and ActiveCampaign ODBC Driver to create a PostgreSQL entry-point for data access.

Use the CData ODBC Driver for HarperDB in Microsoft Power Query

You can use the CData HarperDB ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import HarperDB into Microsoft Power Query.

Connect to Presto from PowerBuilder via ODBC

This article demonstrates how to use the CData ODBC Driver for Presto to connect to Presto and execute queries in PowerBuilder.

Working with JSON Services in LINQPad

Execute LINQ queries to JSON in LINQPad.

Publish Reports with Sybase IQ in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Sybase IQ.

Visualize Live Yahoo! Japan Data Solution in Power BI (via CData Connect Cloud)

Use the CData Power BI Connector and CData Connect Cloud to integrate live Yahoo! Japan Data Solution into custom reports in Power BI.

Create Reports from SurveyMonkey in Looker Studio

Use CData Connect Cloud to gain access to live SurveyMonkey and create custom reports in Looker Studio.

Build Outreach.io-Connected Web Apps in Servoy

Use Servoy Developer to easily connect to Outreach.io and build web apps with connectivity to live Outreach.io.

Automate Sybase IQ Tasks in Power Automate Using CData API Server

With CData API Server, easily create OData endpoints for live Sybase IQ and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.

CData Virtuality 4.8 Release Notes: Resource Governor, Timezone Support for Jobs, New connectors, and More

Read the release notes for CData Virtuality 4.8, including the new Resource Governor, timezone support for jobs, new connectors, and a lot more.

Perform Batch Operations with EnterpriseDB in Apache NiFi

Connect to EnterpriseDB and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

Publish Bing Ads-Connected Dashboards in Tableau Server

Use CData Tableau Connectors and Tableau Server to visualize live Bing Ads.

Use the CData Software ODBC Driver for Azure Active Directory in MicroStrategy Desktop

Connect to Azure Active Directory in MicroStrategy Desktop using the CData Software ODBC Driver for Azure Active Directory.

Create Dynamic WooCommerce Grids Using the Infragistics XamDataGrid

Learn how you can connect WooCommerce to Infragistics XamDataGrid to build dynamic grids.

Build Dashboards with Salesloft in Dundas BI

Create dynamic dashboards and perform analytics based on Salesloft in Dundas BI.

Publish Smartsheet-Connected Dashboards in Tableau Server

Use CData Tableau Connectors and Tableau Server to visualize live Smartsheet.

Connect Pinterest to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

Connect to your Pinterest using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

Connect Access to AI Assistants With the CData Python MCP Server

Learn how to give AI assistants like Claude direct access to live Microsoft Access using the CData Python MCP Server.

Integrate Live SAP ByDesign into Custom Business Apps Built in Power Apps

Use CData Connect Cloud to connect to SAP Business ByDesign and integrate live SAP Business ByDesign into apps built in Microsoft Power Apps.

Replicate Multiple Oracle Financials Cloud Accounts via the CData Sync CLI

Replicate multiple Oracle Financials Cloud accounts to one or many databases.

Connect to Square from AWS Glue

Use CData Connect Cloud to gain access to live Square from your AWS Glue jobs.

Connect to Tableau CRM Analytics in Ruby

Connect to Tableau CRM Analytics in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

Query Klaviyo from Node.js

Use the OData endpoint of the CData API Server to connect to your Klaviyo and perform CRUD operations on Klaviyo from Node.js.

A PostgreSQL Interface for Exact Online using the CData ODBC Driver

Use the SQL Gateway and Exact Online ODBC Driver to create a PostgreSQL entry-point for data access.

Create SAP Ariba Procurement Reports on JasperReports Server

Deploy the CData JDBC Driver on JasperReports Server to provide real-time SAP Ariba Procurement data access from reports, embedded analytics, and more.

Migrating data from Google Sheets to Databricks using CData SSIS Components.

Easily push Google Sheets to Databricks using the CData SSIS Tasks for Google Sheets and Databricks.

Import Real-Time Marketo via ODBC in ColdFusion to Build Applications

Use CData ODBC drivers to import and use Marketo in ColdFusion.

Replicate SAP Business One in Heroku for Use in Salesforce Connect

Replicate SAP Business One to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

Operational Reporting on PingOne from Spotfire Server

Create and share Spotfire data visualizations with real-time connectivity to remote PingOne.

Use Claude to Talk to Your IBM Informix via CData Connect Cloud

Leverage CData Connect Cloud Remote MCP to enable Claude to securely answer questions and take actions on your IBM Informix for you.

How to connect to Sage 50 UK from IntelliJ

Integrate connectivity to Sage 50 UK with wizards in IntelliJ.

How to integrate Metabase with Google Ads

Use CData Connect Cloud to connect to live Google Ads and create an interactive dashboard in Metabase from Google Ads.

Integrate Google Sheets into Automated Tasks with Power Automate

Use CData Connect Cloud to connect to Google Sheets and integrate live Google Sheets into your Power Automate tasks.

Use Dash to Build to Web Apps on SAP HANA XS Advanced

Create Python applications that use pandas and Dash to build SAP HANA XS Advanced-connected web apps.

Work with Live PCA Sales in Power Query

Use CData Connect Cloud to connect to PCA Sales and work with live PCA Sales in Microsoft Power Query.

How to publish and share BambooHR dashboards with Tableau Server

The CData ODBC driver for BambooHR enables you integrate BambooHR into Tableau dashboards.

Analyze Google Spanner in Looker

Use CData Connect Cloud to connect to Google Spanner from Looker and build custom apps using live Google Spanner.

Creating Bing Ads-Connected Applications in Unqork

You can use CData Connect Cloud to feed Bing Ads to Unqork and build custom business apps.

Build Visualizations of Power BI XMLA in Birst

Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Power BI XMLA in Birst.

Access ClickUp from MySQL in Amazon QuickSight

Connect to ClickUp and build visualizations of ClickUp using a MySQL Connection in Amazon QuickSight.

Automate HDFS Replication to SAP HANA

Use CData Sync to customize and automate Apache HDFS replication to SAP HANA.

How to connect to Phoenix from IntelliJ

Integrate connectivity to Apache Phoenix with wizards in IntelliJ.

Connect to Twilio as an External Data Source using PolyBase

Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live Twilio.

Connect to Workday in RunMyProcess through Connect Cloud

Use CData Connect Cloud to create on OData API for Workday and connect to Workday in Akorbi Digital RunMyProcess.

Build Data Flows from SAP to SQL Server using SSIS

Easily back up SAP ERP/NetWeaver to SQL Server using the SSIS components for SAP.

Import and Visualize Amazon Marketplace in Power View

Create data visualizations based on Amazon Marketplace in Excel.

Trigger Paylocity IFTTT Flows in Azure App Service

This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.

How to Query Live Excel Online Data in Natural Language in Python using LlamaIndex

Use LlamaIndex to query live Microsoft Excel Online data in natural language using Python.

Publish Box-Connected Dashboards in Tableau Server

Use CData Tableau Connectors and Tableau Server to visualize live Box.

Edit and Search SFTP External Objects in Salesforce Connect (API Server)

Use the API Server to securely provide OData feeds of SFTP to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create SFTP objects that you can access from apps and the dashboard.

How to Access Live Bitbucket in Power Automate Desktop via ODBC

The CData ODBC Driver for Bitbucket enables you to integrate Bitbucket into workflows built using Microsoft Power Automate Desktop.

How to Visualize Teradata Data in Python with pandas

Use pandas and other modules to analyze and visualize live Teradata in Python.

Use the CData Software ODBC Driver for Zendesk in MicroStrategy

Connect to Zendesk in MicroStrategy Developer using the CData Software ODBC Driver for Zendesk.

Back Up SAP HANA to SQL Server through SSIS

Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SAP HANA. In this article, we will employ an SSIS workflow to populate a database with SAP HANA data.

Build Automated Workflows with Live Google Ads in Workato

Use CData Connect Cloud to connect to live Google Ads and build automated workflows in Workato.

Query Salesloft in ColdFusion

Write standard ColdFusion data access code to connect to Salesloft.

Connect to Jira in RunMyProcess through Connect Cloud

Use CData Connect Cloud to create on OData API for Jira and connect to Atlassian Jira in Akorbi Digital RunMyProcess.

Connect to Parquet in RapidMiner

Integrate Apache Parquet with standard components and data source configuration wizards in RapidMiner Studio.

Replicate JSON Services in Heroku for Use in Salesforce Connect

Replicate JSON to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

How to connect to PingOne in DBVisualizer

Integrate PingOne with visual data analysis tools and data connection wizards in DBVisualizer

How to Access Live Highrise in Power Automate Desktop via ODBC

The CData ODBC Driver for Highrise enables you to integrate Highrise CRM into workflows built using Microsoft Power Automate Desktop.

Integrate with SAP BusinessObjects BI in JReport Designer

Create charts and reports based on SAP BusinessObjects BI in JReport Designer.

Connect Power BI XMLA to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

Connect to your Power BI XMLA using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

CData Software - Knowledge Base

Recent Articles