CData Software Knowledge Base

Excel Spreadsheet Automation on Dynamics 365 with the QUERY Formula

Pull data, automate spreadsheets, and more with the QUERY formula.

How to Connect DBeaver to Blackbaud FE NXT via a JDBC Driver

Manage Blackbaud FE NXT with visual tools in DBeaver like the query browser.

Connect to Sage 200 from Excel & GoogleSheets!

Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Sage 200, and over 250 other data sources, right inside your Excel and Google spreadsheets!

Use the CData Software JDBC Driver for Salesforce Pardot in MicroStrategy Web

Connect to Salesforce Pardot in MicroStrategy Web using the CData Software JDBC Driver for Salesforce Pardot.

Rapidly Develop Harvest-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.

DataBind Controls to REST in Delphi

DataBind to REST in Delphi with standard data access components and controls.

How to connect SharePoint with HBase through external lists

Provide Apache HBase to SharePoint users as an external list.

Access Live Cassandra in TIBCO Data Virtualization

Use the CData Software TIBCO DV Adapter for Cassandra to create a Apache Cassandra source in TIBCO Data Virtualization Studio and gain access to live Apache Cassandra from your TDV Server.

Design BIRT Reports on Sage 200

Provide current Sage 200 to your embedded analytics.

Analyze OneNote in Looker

Use CData Connect Cloud to connect to OneNote from Looker and build custom apps using live Microsoft OneNote.

Connect to TaxJar from Asprova with CData Software ODBC Driver for TaxJar

This article shows how to connect faster to TaxJar data from Asprova.

Connect to Raisers Edge NXT from HeidiSQL

Use CData Connect Cloud to connect to and query live Raisers Edge NXT from HeidiSQL.

Access HubSpot as a Remote Oracle Database

Use the Oracle ODBC Gateway and Heterogeneous Services technology to access HubSpot from your Oracle system.

Access NetSuite from MySQL in HeidiSQL

Use CData ODBC Driver and SQL Gateway to connect and query live NetSuite CRM & ERP from HeidiSQL.

Use the CData Software ODBC Driver for Dynamics CRM in MicroStrategy Desktop

Connect to Microsoft Dynamics CRM in MicroStrategy Desktop using the CData Software ODBC Driver for Dynamics CRM.

Connect to Slack in DBeaver

Use the CData ODBC Driver to connect to Slack in DBeaver.

Migrating data from Asana to Google BigQuery using CData SSIS Components.

Easily push Asana to Google BigQuery using the CData SSIS Tasks for Asana and Google BigQuery.

Connect to Confluence in Google Apps Script via Connect Cloud

Use CData Connect Cloud to access Atlassian Confluence in Google Apps Script.

Connect to Workday from HeidiSQL

Use CData Connect Cloud to connect to and query live Workday from HeidiSQL.

Configure the CData JDBC Driver for Excel in a Connection Pool in Tomcat

Connect to Microsoft Excel from a connection pool in Tomcat.

How to connect and process Oracle HCM Cloud from Azure Databricks

Use CData, Azure, and Databricks to perform data engineering and data science on live Oracle HCM Cloud.

Connect to TaxJar in Jaspersoft Studio

Execute SQL to remote TaxJar in Jaspersoft Studio.

Perform Batch Operations with Zoho Projects in Apache NiFi

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

How to create an RPA flow for Azure Active Directory in UiPath Studio

Use the Azure Active Directory ODBC Driver to create workflows that access real-time Azure Active Directory without any coding.

Write a Simple Go Application to work with Adobe Target on Linux

Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Adobe Target.

Automate Parquet Integration Tasks from PowerShell

Are you in search of a quick and easy way to access Apache Parquet from PowerShell? This article demonstrates how to utilize the Parquet Cmdlets for tasks like connecting to Apache Parquet, automating operations, downloading data, and more.

Access Wave Financial from MySQL in Amazon QuickSight

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

Import Printful into Microsoft Power Query

The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Printful. In this article, you will use the OData format to import Printful into Microsoft Power Query.

Analyze Workday in R via ODBC

Create data visualizations and use high-performance statistical functions to analyze Workday in Microsoft R Open.

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.

Integrate Live Oracle Sales into Custom Business Apps Built in Power Apps

Use CData Connect Cloud to connect to Oracle Sales and integrate live Oracle Sales into apps built in Microsoft Power Apps.

Process & Analyze SAP HANA XS Advanced in Databricks (AWS)

Use CData, AWS, and Databricks to perform data engineering and data science on live SAP HANA XS Advanced .

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

Connect to Salesforce & Force.com from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

Connect to Monday.com through External Services in Salesforce

Use CData Connect Cloud to securely connect Salesforce External Services with Monday.com using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

Analyze EventBrite in Infragistics Reveal

Use the CData API Server to create an OData API on top of Eventbrite and visualize live Eventbrite in Ingragistics Reveal.

Operational Reporting on SAP Ariba Source from Spotfire Server

Create and share Spotfire data visualizations with real-time connectivity to remote SAP Ariba Source.

Integrate Live Zoho Inventory into Custom Business Apps Built in Power Apps

Use CData Connect Cloud to connect to Zoho Inventory and integrate live Zoho Inventory into apps built in Microsoft Power Apps.

Use the CData ODBC Driver for Aha in Microsoft Power Query

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

Consume CockroachDB OData Feeds in SAP Lumira

Use the API Server to create data visualizations on CockroachDB feeds that reflect any changes in SAP Lumira.

Connect to Asana in Aqua Data Studio

Access Asana from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

Automated Continuous Azure Active Directory Replication to Databricks

Use CData Sync for automated, continuous, customizable Azure Active Directory replication to Databricks.

Build Dashboards with Oracle HCM Cloud in Dundas BI

Create dynamic dashboards and perform analytics based on Oracle HCM Cloud in Dundas BI.

Build Dashboards with Odoo in DBxtra

Create dynamic dashboards and perform analytics based on Odoo ERP in DBxtra.

Connect to Bullhorn CRM in Ruby

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

Automated Continuous REST Replication to AlloyDB

Use CData Sync for automated, continuous, customizable REST replication to AlloyDB.

Automated Continuous Shippo Replication to Google Cloud SQL

Use CData Sync for automated, continuous, customizable Shippo replication to Google Cloud SQL.

Integrate Zoho CRM in Your Informatica Cloud Instance

Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Zoho CRM from Informatica Cloud.

How to update eBay from Excel

This article explains how to transfer data from Excel to eBay using the Excel Add-In for eBay.

Connect to Power BI XMLA in NetBeans

Connect to Power BI XMLA in NetBeans with the data source configuration wizard.

CData Software - Knowledge Base

Recent Articles