CData Software Knowledge Base

DataBind Controls to Zoom in Delphi

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

Connect to QuickBooks Time from a Connection Pool in WebLogic

Use the CData JDBC Driver for QuickBooks Time to connect to QuickBooks Time from Web applications running on WebLogic.

Import and Visualize Impala in Power View

Create data visualizations based on Apache Impala in Excel.

How to connect Amazon QuickSight to HubSpot

Create a connection to HubSpot in CData Connect Cloud and insert HubSpot into Amazon QuickSight SPICE to build interactive dashboards.

How to connect and process Instagram from Azure Databricks

Use CData, Azure, and Databricks to perform data engineering and data science on live Instagram

Replicate OneNote from PowerShell

Write a quick PowerShell script to query Microsoft OneNote. Use connectivity to the live data to replicate Microsoft OneNote to SQL Server.

Use the CData Software ODBC Driver for Oracle Service Cloud in MicroStrategy

Connect to Oracle Service Cloud in MicroStrategy Developer using the CData Software ODBC Driver for Oracle Service Cloud.

Automated Continuous Acumatica Replication to SQL Server

Use CData Sync for automated, continuous, customizable Acumatica replication to SQL Server.

Excel Spreadsheet Automation on IBM Informix with the QUERY Formula

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

Use the CData Software ODBC Driver for Reckon Accounts Hosted in MicroStrategy

Connect to Reckon Accounts Hosted in MicroStrategy Developer using the CData Software ODBC Driver for Reckon Accounts Hosted.

Analyze Parquet with Power Pivot

This article walks you through the process of using the CData ODBC Driver for Parquet from Power Pivot. You will use the Table Import Wizard to load Apache Parquet. You can visually build the import query or use any SQL supported by the driver.

How to connect Amazon QuickSight to Workday

Create a connection to Workday in CData Connect Cloud and insert Workday into Amazon QuickSight SPICE to build interactive dashboards.

Connect to Zoho Inventory in DigitalSuite Studio through RunMyProcess DSEC

Use Arkobi Digital

Connect to Parquet in SpagoBI

Create reports featuring live Apache Parquet in SpagoBI Studio. Host Parquet reports on SpagoBI Server.

Build SAS xpt-Connected Dashboards in Redash

Use CData Software Connect Server to create a virtual SQL Server Database for SAS XPORT and build visualizations and dashbaords from SAS XPORT in Redash.

Build Jira-Connected Apps in Mendix

Use CData Connect Cloud to create an OData feed for Jira and create custom apps in Mendix.

Connect to Sage 200 from Crystal Reports

Use CData Connect Cloud to connect to and report on live Sage 200 from Crystal Reports.

Automated Continuous xBase Replication to MySQL

Use CData Sync for automated, continuous, customizable xBase replication to MySQL.

Automate Oracle Sales Replication to Azure Synapse

Use CData Sync to customize and automate Oracle Sales replication to Azure Synapse.

Connect to Sage 300 as an External Source in Dremio

Use the CData JDBC Driver to connect to Sage 300 as an External Source in Dremio.

Build Dashboards with MariaDB in Dundas BI

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

Use JayDeBeApi to access Sage 200 in Python

Use standard Python scripting and the development environment of your choice to access live Sage 200.

How to work with PingOne in Apache Spark using SQL

Access and process PingOne in Apache Spark using the CData Software JDBC Driver.

How to Access Live Pipedrive in Power Automate Desktop via ODBC

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

Connect to GraphQL in RapidMiner

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

Automated Continuous ConstantContact Replication to PostgreSQL

Use CData Sync for automated, continuous, customizable ConstantContact replication to PostgreSQL.

Bidirectional Access to Highrise from FileMaker Pro

Use the MySQL Remoting feature of the JDBC driver to integrate Highrise CRM in Filemaker Pro for Mac or Windows.

Integrate Act-On in the Pentaho Report Designer

Publish reports based on Act-On in the Pentaho BI tool.

Create Azure Table-Connected Visualizations in Klipfolio

Use CData Connect Cloud to connect to Azure Table from Klipfolio and build custom visualizations using live Azure Table Storage.

Visualize Live SAP ByDesign in Power BI (via CData Connect Cloud)

Use the CData Power BI Connector and CData Connect Cloud to integrate live SAP Business ByDesign into custom reports in Power BI.

Use the CData Software JDBC Driver for HarperDB in MicroStrategy Desktop

Connect to HarperDB in MicroStrategy Desktop using the CData Software JDBC Driver for HarperDB.

How to Use a Microsoft Access Database to Update Salesforce Marketing in Real Time

Update Salesforce Marketing data by creating a linked table in Microsoft Access with the CData Salesforce Marketing ODBC Driver.

Build Visualizations of SAS Data Sets in Birst

Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAS Data Sets in Birst.

Use the CData Software ODBC Driver for Harvest in MicroStrategy Web

Connect to Harvest in MicroStrategy Web using the CData Software ODBC Driver for Harvest.

Bidirectional Access to Adobe Commerce from FileMaker Pro

Use the MySQL Remoting feature of the JDBC driver to integrate Adobe Commerce in Filemaker Pro for Mac or Windows.

PowerShell Scripting to Replicate SAP Concur to MySQL

Write a simple PowerShell script to replicate SAP Concur to a MySQL database.

How to Build an ETL App for Google Ads in Python with CData

Create ETL applications and real-time data pipelines for Google Ads in Python with petl.

Create Datasets from Square in Domo Workbench and Build Visualizations of Square in Domo

Use the CData Software ODBC Driver for Square to create datasets from Square in Domo Workbench and then build visualizations in the Domo service.

Creating Excel Online-Connected Applications in Unqork

You can use CData Connect Cloud to feed Microsoft Excel Online to Unqork and build custom business apps.

CData Software - Knowledge Base

Recent Articles