Show articles by: Integration Technology | Driver Technology | Recent Articles

CData Software - Knowledge Base

Recent Articles

Build Amazon S3-Connected Apps in Bubble

Use CData Connect Cloud to create an OData feed for Amazon S3 and create custom apps in Bubble.
Connect to Calendly as an External Source in Dremio

Use the CData JDBC Driver to connect to Calendly as an External Source in Dremio.
Create a Data Access Object for Google Drive using JDBI

A brief overview of creating a SQL Object API for Google Drive in JDBI.
LINQ to SharePoint Excel Services

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 SharePoint Excel Services Data Provider.
Access Live Sage 300 Data in Tableau with CData API Server

With CData API Server, easily create OData endpoints for live Sage 300 data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
Automated Dynamics NAV Replication to Teradata

Use CData Sync to Customize and automate Microsoft Dynamics NAV replication to Teradata.
How to Seamlessly Import Google Search Data into IBM SPSS Modeler

Integrate Google Search data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
Add Shippo to Informatica Enterprise Data Catalog

Use the CData Software JDBC Driver for Shippo with the Informatica Enterprise Data Catalog to classify and organize data.
Add JotForm to Informatica Enterprise Data Catalog

Use the CData Software JDBC Driver for JotForm with the Informatica Enterprise Data Catalog to classify and organize data.
Connect to Sybase from PowerBuilder via JDBC

This article demonstrates how to access Sybase from PowerBuilder using the Sybase JDBC Driver.
Use the CData ODBC Driver for SAP BusinessObjects BI from SharePoint Excel Services

This article demonstrates how to use the CData ODBC Driver for SAP BusinessObjects BI to connect to SAP BusinessObjects BI from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SAP BusinessObjects BI in Excel.
Build WordPress-Connected Apps in Choreo

Use CData Connect Cloud to connect to WordPress from Choreo and build custom apps using live WordPress.
Visualize Cosmos DB in Tableau

The CData ODBC driver for Cosmos DB enables you integrate Azure Cosmos DB into Tableau dashboards.
Deploy the ADO.NET Provider for JotForm on an SSRS Report Server

Connect to JotForm 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.
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Redshift

Provide connectivity to Amazon Redshift through an SAP BusinessObjects universe.
Replicate Asana from PowerShell

Write a quick PowerShell script to query Asana. Use connectivity to the live data to replicate Asana to SQL Server.
Create Facebook 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 Microsoft Teams Replication to Snowflake

Use CData Sync for automated, continuous, customizable Microsoft Teams replication to Snowflake.
Access Live Trello in AWS Lambda

Connect to live Trello in AWS Lambda using the CData JDBC Driver.
Use the CData Software JDBC Driver for Power BI XMLA in MicroStrategy

Connect to Power BI XMLA in MicroStrategy Developer using the CData Software JDBC Driver for Power BI XMLA.
Replicate Excel to Multiple Databases via the CData Sync CLI

Replicate Microsoft Excel to disparate databases with a single configuration.
Integrate Aha in Pentaho Data Integration

Build ETL pipelines based on Aha! in the Pentaho Data Integration tool.
Access Live WooCommerce Data in Tableau with CData API Server

With CData API Server, easily create OData endpoints for live WooCommerce data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
Automated Continuous MYOB AccountRight Replication to Oracle

Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to Oracle.
Natively Connect to Twilio in PHP via ODBC (Linux)

Create PHP applications on Linux/UNIX machines with connectivity to Twilio. Leverage the native support for ODBC in PHP.
Create ShipStation-Connected Visualizations in Klipfolio

Use CData Connect Cloud to connect to ShipStation from Klipfolio and build custom visualizations using live ShipStation.
Automated Continuous Avalara AvaTax Replication to Google Cloud SQL

Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to Google Cloud SQL.
Build Dashboards with Clio in Dundas BI

Create dynamic dashboards and perform analytics based on Clio in Dundas BI.
Connect to Azure Active Directory in RapidMiner

Integrate Azure Active Directory with standard components and data source configuration wizards in RapidMiner Studio.
How to connect and process SQL Server from Azure Databricks

Use CData, Azure, and Databricks to perform data engineering and data science on live SQL Server
Access Live Twilio in Coginiti Pro

Connect to and query live Twilio from the GUI in the Coginiti Pro: SQL Analytics Tool.
Access Highrise as a Remote Oracle Database

Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Highrise CRM from your Oracle system.
Creating Hive-Connected Applications in Unqork

You can use CData Connect Cloud to feed Apache Hive to Unqork and build custom business apps.
Build Twilio-Connected Apps in Choreo

Use CData Connect Cloud to connect to Twilio from Choreo and build custom apps using live Twilio.
Use Dash to Build to Web Apps on SharePoint Excel Services

Create Python applications that use pandas and Dash to build SharePoint Excel Services-connected web apps.
How to Query Live Amazon Athena Data in Natural Language in Python using LlamaIndex

Use LlamaIndex to query live Amazon Athena data in natural language using Python.
Connect to Facebook Ads in JRuby

Create a simple JRuby app with access to live Facebook Ads.
Create SAP ByDesign-Connected Dashboards in Grafana

Connect to SAP ByDesign via CData Connect Cloud in Grafana and create custom business dashboards with real-time access to SAP Business ByDesign.
A PostgreSQL Interface for Google Calendar (MySQL Remoting via JDBC)

Use the Remoting features of the Google Calendar JDBC Driver to create a PostgreSQL entry-point for data access.
How to work with Invoiced in Apache Spark using SQL

Access and process Invoiced in Apache Spark using the CData Software JDBC Driver.
How to connect PolyBase to Harvest

Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Harvest.
DataBind Controls to SAP HANA in C++Builder

DataBind to SAP HANA in C++Builder with standard components and controls.
Create SSAS Tabular Models from MailChimp

How to build a SQL Server Analysis Service Tabular Model from MailChimp using CData drivers.
Access Live Avalara AvaTax in AWS Lambda

Connect to live Avalara AvaTax in AWS Lambda using the CData JDBC Driver.
How to connect to SAP SuccessFactors in DBVisualizer

Integrate SAP SuccessFactors with visual data analysis tools and data connection wizards in DBVisualizer
Access Live Cosmos DB in AWS Lambda

Connect to live Azure Cosmos DB in AWS Lambda using the CData JDBC Driver.
Consume SQL Analysis Services OData Feeds in PowerBuilder

This article demonstrates how to consume SQL Analysis Services as OData feeds from PowerBuilder using the API Server.
Automate Microsoft Teams Replication to Azure Synapse

Use CData Sync to customize and automate Microsoft Teams replication to Azure Synapse.
Build Charts with Zuora in Clear Analytics

Create dynamic charts and perform analytics based on Zuora in Clear Analytics.
How to Work with OneNote in ETL Validator JDBC

Connect to OneNote from ETL Validator jobs using the CData Software JDBC Driver.
Automated Continuous Exact Online Replication to AlloyDB

Use CData Sync for automated, continuous, customizable Exact Online replication to AlloyDB.
Automate Adobe Commerce Replication to Couchbase

Use CData Sync to Customize and automate Adobe Commerce replication to Couchbase.
Access Live BambooHR Data in Tableau with CData API Server

With CData API Server, easily create OData endpoints for live BambooHR data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
Automated Continuous Basecamp Replication to Apache Cassandra

Use CData Sync for automated, continuous, customizable Basecamp replication to Apache Cassandra.
Automated Continuous Oracle Replication to SQL Server

Use CData Sync for automated, continuous, customizable Oracle replication to SQL Server.
Consume Phoenix OData Feeds in PowerBuilder

This article demonstrates how to consume Apache Phoenix as OData feeds from PowerBuilder using the API Server.
Analyze Google Ads in Infragistics Reveal

Use CData Connect Cloud to create on OData API on top of Google Ads and visualize live Google Ads in Infragistics Reveal.
Build Facebook-Connected Apps in Choreo

Use CData Connect Cloud to connect to Facebook from Choreo and build custom apps using live Facebook.
Perform Batch Operations with SAP HANA in Apache NiFi

Connect to SAP HANA and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
Analyze SingleStore with Power Pivot

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

Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Apache HBase.
How to Easily Query IBM Cloud Data Engine in OpenOffice Base