CData Software Knowledge Base

Query Teradata as a SQL Server in Node.js

Execute SQL Server queries against Teradata from Node.js.

Query Kintone in MySQL Workbench

Create a virtual MySQL database for Kintone in CData Software Connect (or Connect Server) and work with live Kintone in MySQL Workbench.

Build Semantic Layer Views for Slack in APOS Live Data Gateway

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

Use JayDeBeApi to access Clio in Python

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

Connect to Microsoft OneDrive as a Linked Server via SQL Gateway

Use the SQL Gateway and the ODBC Driver to set up a linked server for Microsoft OneDrive.

Connect to Excel Online in Aqua Data Studio

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

Build Data Flows from SQL Server to MySQL through SSIS

Easily push SQL Server data to MySQL using the CData SSIS Tasks for MySQL.

Connect and Visualize Live Amazon DynamoDB Data in Databricks Lakehouse Federation with CData Connect Cloud

Use CData Connect Cloud to integrate live Amazon DynamoDB into the Databricks platform and create visualization dashboards with real-time Amazon DynamoDB.

Connect to SAP ByDesign as a Linked Server via SQL Gateway

Use the SQL Gateway and the ODBC Driver to set up a linked server for SAP Business ByDesign.

Work with Acumatica in FoxPro

Load Acumatica ERP into a FoxPro database. This article includes full code and a walk-through of the process.

How to use SQLAlchemy ORM to access JSON Services in Python

Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of JSON.

Provide OData Services of Sybase from a WCF Application

In this article, we will demonstrate the process of generating an OData feed for Sybase by developing a WCF Service Application.

Access TigerGraph from MySQL in Amazon QuickSight

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

Create Azure Synapse-Connected Dashboards in Grafana

Connect to Azure Synapse via CData Connect Cloud in Grafana and create custom business dashboards with real-time access to Azure Synapse.

How to Seamlessly Import Couchbase Data into IBM SPSS Modeler

Integrate Couchbase data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

How to connect to Azure Synapse with Squirrel SQL client

Connect to Azure Synapse and execute queries in the Squirrel SQL Client.

Use Biml to Build SSIS Tasks to Replicate Redshift to SQL Server

Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Amazon Redshift to SQL Server.

A PostgreSQL Interface for Excel Online using the CData ODBC Driver

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

Create Dynamic Oracle Sales Grids Using the Infragistics XamDataGrid

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

How to connect Amazon QuickSight to IBM Informix

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

Create Sugar CRM-Connected Enterprise Applications in OutSystems

Use CData Connect Cloud to connect to Sugar CRM from OutSystems and build custom enterprise apps using live Sugar CRM.

Access Live Office 365 in AWS Lambda

Connect to live Microsoft Office 365 in AWS Lambda using the CData JDBC Driver.

Use the CData Software JDBC Driver for Invoiced in MicroStrategy Web

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

Access Live Parquet in SAS JMP via ODBC

You can use the CData ODBC Driver to integrate Apache Parquet into the statistical analysis tools available in SAS JMP. This article shows how to use Apache Parquet in the Graph Builder and Query Builder.

PowerShell Scripting to Replicate Tally to MySQL

Write a simple PowerShell script to replicate Tally ERP to a MySQL database.

Connect to Bing Search Results in DBArtisan

Use wizards in DBArtisan to configure Bing Search as a data source.

Visualize Zenefits in Sisense

Create an ElastiCube in Sisense app with access to Zenefits.

Automated Continuous Teradata Replication to SingleStore

Use CData Sync for automated, continuous, customizable Teradata replication to SingleStore.

Publish NetSuite-Connected Dashboards in Tableau Server

Use CData Tableau Connectors and Tableau Server to visualize live NetSuite CRM & ERP.

How to Seamlessly Import Spark Data into IBM SPSS Modeler

Integrate Spark data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

Automated Continuous Sugar CRM Replication to Google BigQuery

Use CData Sync for automated, continuous, customizable Sugar CRM replication to Google BigQuery.

Build Data Flows from Pinterest to SQL Server using SSIS

Easily back up Pinterest to SQL Server using the SSIS components for Pinterest.

Stream Bing Search Results into Apache Kafka Topics

Access and stream Bing Search in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

How to Connect to & Open Twitter Ads in Microsoft Excel

This article uses the CData ODBC driver for Twitter Ads to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

Access Live BCart in Google Sheets via Connect Cloud

Use CData Connect Cloud to gain access to live BCart from your Google Sheets.

Visualize SuiteCRM from Tableau

Use the Tableau Desktop business intelligence tool to connect to SuiteCRM.

Automated Continuous Avro Replication to Local Delimited Files

Use CData Sync for automated, continuous, customizable Avro replication to delimited files (CSV/TSV).

Enable the WordPress JDBC Driver in KNIME

Use standard data access components in KNIME to create charts and reports with WordPress.

Connect to Azure Active Directory from Blazor Apps

Build ASP.NET Core Blazor C# apps that integrate with real-time Azure Active Directory using standard SQL.

Connect to Sage Cloud Accounting in HULFT Integrate

Connect to Sage Cloud Accounting as a JDBC data source in HULFT Integrate

Model, Search, and Visualize Live Oracle Service Cloud in ThoughtSpot

Use CData Connect Cloud to connect to live Oracle Service Cloud for modeling, searching, and visualizing.

Choosing the Best Method to Connect SingleStore to SQL Server: 5 Options Explained

Discover multiple ways to connect and use SingleStore from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

How to Seamlessly Import BambooHR Data into IBM SPSS Modeler

Integrate BambooHR data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

Create SAP Ariba Source Dataflows on PowerBI.com

Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.

Automated Continuous JotForm Replication to Vertica

Use CData Sync for automated, continuous, customizable JotForm replication to Vertica.

Connect to SAP HANA XS Advanced from Blazor Apps

Build ASP.NET Core Blazor C# apps that integrate with real-time SAP HANA XS Advanced using standard SQL.

Feed Xero into FineReport

How to set Xero Accounting as a JDBC data source in FineReport.

Import Zoom into the Power BI Service for Visualizations

Use CData Software Connect Server to create an OData feed for Zoom and create custom reports in the Power BI Service.

Manage GitHub in DBArtisan as a JDBC Source

Use wizards in DBArtisan to create a JDBC data source for GitHub.

How to work with Blackbaud FE NXT in Apache Spark using SQL

Access and process Blackbaud FE NXT in Apache Spark using the CData Software JDBC Driver.

Build Cassandra-Connected Web Apps in Servoy

Use Servoy Developer to easily connect to Apache Cassandra and build web apps with connectivity to live Apache Cassandra.

Author and Share Power BI Reports on Real-Time Authorize.Net

Use the CData ODBC Driver for Authorize.Net to visualize Authorize.Net in Power BI Desktop and then upload to the Power BI service.

DataBind Controls to Facebook Ads in Delphi

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

How to work with Airtable in Apache Spark using SQL

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

Access ShipStation from MySQL in HeidiSQL

Use CData ODBC Driver and SQL Gateway to connect and query live ShipStation from HeidiSQL.

Analyze OneNote in Cognos Analytics

Use CData Connect Cloud to connect to OneNote from Cognos Analytics and analyze live Microsoft OneNote.

How to Access Live Microsoft Dataverse in Power Automate Desktop via ODBC

The CData ODBC Driver for Microsoft Dataverse enables you to integrate Microsoft Dataverse (CDS) into workflows built using Microsoft Power Automate Desktop.

How to Access Zenefits Using Entity Framework

This article shows how to access Zenefits using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

Build Dashboards with YouTube Analytics in DBxtra

Create dynamic dashboards and perform analytics based on YouTube Analytics in DBxtra.

Replicate Amazon Athena for Use in Salesforce Connect

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

Build SAP Business One Visualizations in Tableau Desktop

Use CData Connect Cloud to connect to live SAP Business One and build visualizations in Tableau.

Aha Reporting and Star Schemas in OBIEE

Create a star schema that shows perspectives on Aha facts in real time.

DataBind Amazon DynamoDB to the DevExpress Data Grid

Use the CData Software ADO.NET Provider for Amazon DynamoDB with the DevExpress Windows Forms and Web controls to provide Amazon DynamoDB to a chart.

Connect to SAP Business One in Google Apps Script via SQL Gateway

Use the ODBC Driver for SAP Business One and the SQL Gateway to access SAP Business One from Google Apps Script.

Access Active Directory from MySQL in Amazon QuickSight

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

Visualize Live Microsoft Teams in Tableau

Use CData Tableau Connectors and Tableau Desktop to visualize live Microsoft Teams.

Create Reports with FHIR in SAP Crystal Reports

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

Enable the Snowflake JDBC Driver in KNIME

Use standard data access components in KNIME to create charts and reports with Snowflake.

Connect to Tally in RunMyProcess through Connect Server

Use CData Connect Server to create an OData API for Tally and connect to Tally ERP in Akorbi Digital RunMyProcess.

Build Data Flows from Sage 50 UK to SQL Server using SSIS

Easily back up Sage 50 UK to SQL Server using the SSIS components for Sage 50 UK.

Build Apps with Live Microsoft Dynamics CRM in Adalo using CData Connect Cloud

Use CData Connect Cloud to integrate live Microsoft Dynamics CRM into the Adalo platform and build custom mobile and web applications with real-time Microsoft Dynamics CRM.

Connect to TaxJar from a Connection Pool in JBoss

Integrate TaxJar into Java servlets: Use the Management Console in JBoss to install the TaxJar JDBC Driver.

Build Visualizations of Live Excel in Power BI (through CData Connect)

Use CData Connect to create a virtual database for Microsoft Excel and build custom reports in Power BI.

Integrate Real-Time Access to Phoenix in SAPUI5 MVC Apps

Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Apache Phoenix in real time.

Connect to Google Ads in Google Apps Script via SQL Gateway

Use the ODBC Driver for Google Ads and the SQL Gateway to access Google Ads from Google Apps Script.

Access Live Authorize.Net in SAS JMP via ODBC

You can use the CData ODBC Driver to integrate Authorize.Net into the statistical analysis tools available in SAS JMP. This article shows how to use Authorize.Net in the Graph Builder and Query Builder.

Import FHIR into FileMaker Pro

Create reports that integrate FHIR in Filemaker Pro.

Access Confluence from MySQL in Amazon QuickSight

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

How to pipe CouchDB to CSV in PowerShell

Use standard PowerShell cmdlets to access CouchDB tables.

Use the CData Software JDBC Driver for SAP Netweaver Gateway in MicroStrategy Web

Connect to SAP Netweaver Gateway in MicroStrategy Web using the CData Software JDBC Driver for SAP Netweaver Gateway.

Connect to Live Smartsheet in MicroStrategy through CData Connect Cloud

Create a live connection to Smartsheet in CData Connect Cloud and connect to your Smartsheet from MicroStrategy.

Connect to Presto from Filemaker Pro (Mac)

Use CData Connect Cloud to connect to and query live Presto from Filemaker Pro on Mac.

CData Software - Knowledge Base

Recent Articles