Learn more
 

CData Software - Knowledge Base

Recent SQL Server Articles

Design BIRT Reports on SQL Analysis Services

Provide current SQL Analysis Services to your embedded analytics.

Analyze Epicor Kinetic in Looker

Use CData Connect Cloud to connect to Epicor Kinetic from Looker and build custom apps using live Epicor Kinetic.

Query Cassandra in MySQL Workbench

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

Back Up Google Ads to SQL Server through SSIS

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

A PostgreSQL Interface for Power BI XMLA

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

Start with CData Sync Part 3: Creating a Transformation Job

Use CData Sync to create a transformation job to manipulate your data.

Use the CData ODBC Driver for NetSuite in SAS JMP

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

Access Salesloft from MySQL in PHP

Connect to Salesloft through the standard MySQL libraries in PHP.

Build Splunk-Connected Visualizations in datapine

Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Splunk.

Use the CData ODBC Driver for BigQuery in SAS JMP

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

Connect to MariaDB as a Linked Server

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

Create Reports from FHIR in Looker Studio

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

Access Procore from MySQL in PHP

Connect to Procore through the standard MySQL libraries in PHP.

Build Oracle HCM Cloud-Connected Apps in Mendix

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

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

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