CData Software Knowledge Base

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

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

Build a Simple VCL Application for Outreach.io

How to build a simple VCL Application to view Outreach.io in RAD Studio using the CData ODBC Driver for Outreach.io.

Access Live Azure Active Directory in AWS Lambda

Connect to live Azure Active Directory in AWS Lambda using the CData JDBC Driver.

Create Dynamics 365 Business Central-Connected Enterprise Applications in OutSystems

Use CData Connect Cloud to connect to Dynamics 365 Business Central from OutSystems and build custom enterprise apps using live Dynamics 365 Business Central.

Deploy the ADO.NET Provider for Azure Synapse on an SSRS Report Server

Connect to Azure Synapse from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

Discovering SaaS, Big Data, and NoSQL Metadata with JDBC

Use the CData JDBC Drivers to see the metadata for all of your SaaS, Big Data, RDBMS, and NoSQL data sources.

Extend Google Sheets with Sage 50 UK

Make calls to the API Server from Google Apps Script.

Feed Wave Financial into FineReport

How to set Wave Financial as a JDBC data source in FineReport.

Perform Batch Operations with Salesforce Pardot in Apache NiFi

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

Start Visualizing Facebook Ads Performance Using CData

Learn how to visualize Facebook Ads data using CData drivers and connectors and build interactive dashboards in Power BI, Tableau, Excel, and more.

Connect to Amazon DynamoDB as a SQL Server Linked Server

Use CData Connect Cloud to create a linked server for live Amazon DynamoDB.

LINQ to Kintone

LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Kintone Data Provider.

Connect to Zoho Books as an External Data Source using PolyBase

Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live Zoho Books.

Build Data Flows from Google Ad Manager to SQL Server using SSIS

Easily back up Google Ad Manager to SQL Server using the SSIS components for Google Ad Manager.

Prepare, Blend, and Analyze CouchDB in Alteryx Designer (ODBC)

Build workflows to access live Apache CouchDB for self-service data analytics.

BigCommerce Reporting in OBIEE with the BigCommerce JDBC Driver

Deploy the BigCommerce JDBC driver on OBIEE to provide real-time reporting across the enterprise.

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

Connect to Apache CouchDB from a connection pool in Tomcat.

Access AlloyDB from MySQL in PHP

Connect to AlloyDB through the standard MySQL libraries in PHP.

Manage Google Calendar in DBArtisan as a JDBC Source

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

Deploy CData SSIS Components on Azure Data Factory

Deploy an SSIS Package with CData components to the Azure Data Factory Cloud

Build Automated Workflows with Live Google Contacts in Workato

Use CData Connect Cloud to connect to live Google Contacts and build automated workflows in Workato.

Access NetSuite in Mule Applications Using the CData JDBC Driver

Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for NetSuite CRM & ERP.

Connect to GitHub in DBArtisan

Use wizards in DBArtisan to configure GitHub as a data source.

Natively Connect to DocuSign in PHP via ODBC (Linux)

Create PHP applications on Linux/UNIX machines with connectivity to DocuSign. Leverage the native support for ODBC in PHP.

Publish JotForm-Connected Dashboards in Tableau Server via JDBC

Use CData JDBC drivers and Tableau Server to visualize live JotForm.

Connect to Reckon Accounts Hosted from Blazor Apps

Build ASP.NET Core Blazor C# apps that integrate with real-time Reckon Accounts Hosted using standard SQL.

Query Trello using the OData SDK for PHP

Use the API Server and the OData PHP SDK to easily consume Trello entities in PHP by modeling them as objects.

Migrating data from Google Drive to Databricks using CData SSIS Components.

Easily push Google Drive to Databricks using the CData SSIS Tasks for Google Drive and Databricks.

A PostgreSQL Interface for Bitbucket (MySQL Remoting via JDBC)

Use the Remoting features of the Bitbucket JDBC Driver to create a PostgreSQL entry-point for data access.

Connect to and Visualize Live Google Sheets in Tableau Prep

Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Sheets.

Access ServiceNow from MySQL in PHP

Connect to ServiceNow through the standard MySQL libraries in PHP.

Automate REST Integration Tasks from PowerShell

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

Use the CData Software ODBC Driver for SAP Hybris C4C in SAS for Real-Time Reporting and Analytics

Connect to real-time SAP Hybris C4C in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SAP Hybris C4C.

How to Query Live SAP Ariba Procurement in Claude Desktop

Connect to and query live SAP Ariba Procurement in Claude Desktop using the CData MCP Server.

Use the CData Software ODBC Driver for Workday in SAS for Real-Time Reporting and Analytics

Connect to real-time Workday in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Workday.

How to create an RPA flow for PingOne in UiPath Studio

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

Import and Visualize Procore in Power View

Create data visualizations based on Procore in Excel.

Working with Oracle HCM Cloud in LINQPad

Execute LINQ queries to Oracle HCM Cloud in LINQPad.

Create a Data Access Object for ActiveCampaign using JDBI

A brief overview of creating a SQL Object API for ActiveCampaign in JDBI.

How to connect to Unbounce from Spring Boot

Connect to Unbounce in a Spring Boot Application using CData JDBC Unbounce Driver

How to Create Power BI Visual Reports with Real-Time Microsoft Teams

Use CData Power BI Connectors to visualize Microsoft Teams in Power BI.

Connect to Twilio in ACL Analytics

Connect to Twilio via CData Connect Cloud in ACL Analytics to run your data analysis workflows with real-time access to Twilio.

CData Software - Knowledge Base

Recent Articles