Learn more
 

CData Software - Knowledge Base

Recent SQL Server Articles

Use Biml to Build SSIS Tasks to Replicate JSON Services to SQL Server

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

Query WordPress as a MySQL Database in Node.js

Execute MySQL queries against WordPress from Node.js.

Connect to ShipStation from Filemaker Pro (Mac)

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

Integrate with live SQL Server in Jitterbit

Use CData Connect Cloud to connect to and integrate live Microsoft SQL Server in Jitterbit.

Back Up Azure Cosmos DB to SQL Server through SSIS

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

Integrate with live MYOB AccountRight in Jitterbit

Use CData Connect Cloud to connect to and integrate live MYOB AccountRight in Jitterbit.

Access Dynamics GP from MySQL in Amazon QuickSight

Connect to Dynamics GP and build visualizations of Microsoft Dynamics GP using a MySQL Connection in Amazon QuickSight.

Build eBay-Connected Dashboards Using Zoho Analytics

Use CData Connect Cloud to connect to eBay from Zoho Analytics and import live eBay.

Create SharePoint Dashboards in Bold BI

Use CData Software Connect Server to create a virtual SQL Server Database for Microsoft SharePoint to build custom dashboards in Bold BI.

Model Smartsheet Using Azure Analysis Services

Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Smartsheet, enabling the direct import of real-time Smartsheet.

Connect to Exact Online as a Linked Server

Use the SQL Gateway and the ODBC Driver to set up a linked server for Exact Online.

Build ActiveCampaign Visualizations in Tableau Desktop

Use CData Connect Cloud to connect to live ActiveCampaign and build visualizations in Tableau.

How to connect PolyBase to MYOB AccountRight

Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live MYOB AccountRight.

Replicate Unbounce to Multiple Databases

Replicate Unbounce to disparate databases with a single configuration.

Visualize Live Google Data Catalog in the Power BI Service

Use CData Software Connect Server to create a virtual SQL Server database for Google Data Catalog and create custom reports in the Power BI Service.