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

CData Software - Knowledge Base

Recent Articles

Working with Amazon Marketplace in LINQPad

Execute LINQ queries to Amazon Marketplace in LINQPad.
Integrate Live Facebook into Amazon SageMaker Canvas with RDS

Use CData Connect Cloud to connect to Facebook from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Facebook.
Connect to Greenhouse in NetBeans

Connect to Greenhouse in NetBeans with the data source configuration wizard.
Bridge Epicor Kinetic Connectivity with Apache NiFi

Access and process Epicor Kinetic in Apache NiFi using the CData JDBC Driver.
Integrate NetSuite in Pentaho Data Integration

Build ETL pipelines based on NetSuite CRM & ERP in the Pentaho Data Integration tool.
Automate Impala Replication to Azure Synapse

Use CData Sync to customize and automate Apache Impala replication to Azure Synapse.
Analyze HubSpot in SAP Analytics Cloud

Use CData Connect Cloud to create an OData API on top of HubSpot and visualize HubSpot in SAP Analytics Cloud.
Access JSON Services from MySQL in Amazon QuickSight

Connect to JSON and build visualizations of JSON using a MySQL Connection in Amazon QuickSight.
Integrate with Live Google Calendar in MuleSoft (via CData Connect Cloud)

Use CData Connect Cloud to connect to Google Calendar from the MuleSoft Anypoint Platform to integrate live Google Calendar into custom reports and dashboards.
DataBind Oracle HCM Cloud to the DevExpress Data Grid

Use the CData Software ADO.NET Provider for Oracle HCM Cloud with the DevExpress Windows Forms and Web controls to provide Oracle HCM Cloud to a chart.
Bidirectional Access to Microsoft Dataverse from FileMaker Pro

Use the MySQL Remoting feature of the JDBC driver to integrate Microsoft Dataverse (CDS) in Filemaker Pro for Mac or Windows.
Model Twitter Using Azure Analysis Services

Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Twitter, enabling the direct import of real-time Twitter.
How to Visualize Oracle Service Cloud Data in Python with pandas

Use pandas and other modules to analyze and visualize live Oracle Service Cloud in Python.
Connect to MailChimp as an External Source in Dremio

Use the CData JDBC Driver to connect to MailChimp as an External Source in Dremio.
How to integrate Metabase with GMO MakeShop

Use CData Connect Cloud to connect to live GMO MakeShop and create an interactive dashboard in Metabase from GMO MakeShop.
Query, Visualize, and Share live SAP ByDesign in Redash

Use CData Connect Cloud to connect to live SAP Business ByDesign in Redash for querying, visualizing, and sharing.
Connect to Adobe Analytics in SpagoBI

Create reports featuring live Adobe Analytics in SpagoBI Studio. Host Adobe Analytics reports on SpagoBI Server.
Consume Oracle SCM OData Feeds in PowerBuilder

This article demonstrates how to consume Oracle SCM as OData feeds from PowerBuilder using the API Server.
Replicate Multiple Google Contacts Accounts

Replicate multiple Google Contacts accounts to one or many databases.
DataBind Charts to Klaviyo

Use the standard ADO.NET procedures for databinding to provide bidirectional access to Klaviyo from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
Use the CData API Server to Access OneNote in Microsoft PowerPivot

Use the CData API Server to connect to live Microsoft OneNote in the Power Pivot business intelligence tool.
Analyze Act CRM in SAP Analytics Cloud

Use CData Connect Cloud to create an OData API on top of Act CRM and visualize Act CRM in SAP Analytics Cloud.
Using the CData Software ODBC Driver for LDAP in PyCharm

Connect to LDAP as an ODBC data source in PyCharm using the CData Software ODBC Driver for LDAP.
Connect to Bing Ads from a Connection Pool in Jetty

The Bing Ads JDBC Driver supports connection pooling: This article shows how to connect faster to Bing Ads from Web apps in Jetty.
Create Informatica Mappings From/To an ODBC Data Source for ADP

Create an ODBC connection to ADP in Informatica and browse and transfer ADP.
Connect to Google Directory from a Connection Pool in WebLogic

Use the CData JDBC Driver for Google Directory to connect to Google Directory from Web applications running on WebLogic.
Analyze Kintone in SAP Analytics Cloud

Use CData Connect Cloud to create an OData API on top of Kintone and visualize Kintone in SAP Analytics Cloud.
Import and Visualize AlloyDB in Power View

Create data visualizations based on Google AlloyDB in Excel.
LINQ to MYOB AccountRight

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 MYOB AccountRight Data Provider.
Automate Odoo Replication to Couchbase

Use CData Sync to Customize and automate Odoo ERP replication to Couchbase.
Access Google Cloud Storage from MySQL in HeidiSQL

Use CData ODBC Driver and SQL Gateway to connect and query live Google Cloud Storage from HeidiSQL.
Migrating data from MongoDB to Databricks using CData SSIS Components.

Easily push MongoDB to Databricks using the CData SSIS Tasks for MongoDB and Databricks.
Access Pinterest as a Remote Oracle Database

Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Pinterest from your Oracle system.
How to Access Live Couchbase in Visual Studio Code via Cline

Run the CData MCP Server for Couchbase on Windows Subsytem for Linux (WSL) and connect to live Couchbase from the Cline extension in Visual Studio Code.
Trigger Oracle Service Cloud IFTTT Flows in Azure App Service

This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
Access Live Azure DevOps Data in Tableau with CData API Server

With CData API Server, easily create OData endpoints for live Azure DevOps data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
Connect to OneNote from Crystal Reports

Use CData Connect Cloud to connect to and report on live Microsoft OneNote from Crystal Reports.
How to Import Data from Facebook into Google Sheets

Import Facebook into a Google spreadsheet that is automatically refreshed.
Using CData JDBC Drivers from IntelliJ IDEA

CData JDBC Drivers make it easy for Java developers to work with a variety of data sources. In this article we show how to use any CData JDBC Driver to create a JDBC data source in the IntelliJ Java IDE. You will then use the JDBC data source to execute queries in the Table Editor.
Build Dashboards with Excel in DBxtra

Create dynamic dashboards and perform analytics based on Microsoft Excel in DBxtra.
How to connect SharePoint with Snowflake through external lists

Provide Snowflake to SharePoint users as an external list.
Create Reports with SQL Server in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Microsoft SQL Server.
Connect to HDFS from PowerBuilder via JDBC

This article demonstrates how to access Apache HDFS from PowerBuilder using the HDFS JDBC Driver.
Automated Continuous Snapchat Ads Replication to Apache Cassandra

Use CData Sync for automated, continuous, customizable Snapchat Ads replication to Apache Cassandra.
How to work with Azure Data Catalog in Apache Spark using SQL

Access and process Azure Data Catalog in Apache Spark using the CData Software JDBC Driver.
Use the CData API Server in Microsoft Power BI

You can use the CData API Server to feed SendGrid to Power BI dashboards. Simply drag and drop SendGrid into data visuals on the Power BI canvas.
Connect to and Query Drift in QlikView over ODBC

Create data visualizations with Drift in QlikView.
How to pipe Xero to CSV in PowerShell

Use standard PowerShell cmdlets to access Xero tables.
Integrate Access in the Pentaho Report Designer

Publish reports based on Microsoft Access in the Pentaho BI tool.
Automated Continuous MarkLogic Replication to Amazon Redshift

Use CData Sync for automated, continuous, customizable MarkLogic replication to Amazon Redshift.
Connect to Azure Synapse in Jaspersoft Studio

Execute SQL to remote Azure Synapse in Jaspersoft Studio.
Operational Reporting on IBM Cloud Object Storage from Spotfire Server

Create and share Spotfire data visualizations with real-time connectivity to remote IBM Cloud Object Storage.
Automated Continuous SAP Replication to Apache Cassandra

Use CData Sync for automated, continuous, customizable SAP replication to Apache Cassandra.
Use the CData API Server to Access xBase in Microsoft PowerPivot

Use the CData API Server to connect to live xBase in the Power Pivot business intelligence tool.
Access Live Shippo in AWS Lambda (with IntelliJ IDEA)

Connect to live Shippo in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
Build GMO MakeShop-Connected Apps in Mendix

Use CData Connect Cloud to create an OData feed for GMO MakeShop and create custom apps in Mendix.
How to Visualize Pinterest Data in Python with pandas

Use pandas and other modules to analyze and visualize live Pinterest in Python.
Connect to Live AlloyDB in MicroStrategy through CData Connect Cloud

Create a live connection to AlloyDB in CData Connect Cloud and connect to your Google AlloyDB from MicroStrategy.
Use the CData Software ODBC Driver for SAP ByDesign in MicroStrategy Desktop

Connect to SAP Business ByDesign in MicroStrategy Desktop using the CData Software ODBC Driver for SAP ByDesign.
How to Seamlessly Import Zoho Books Data into IBM SPSS Modeler

Integrate Zoho Books data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
Access Zoho Inventory as a Remote Oracle Database

Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Zoho Inventory from your Oracle system.
Publish JSON-Connected Dashboards in Tableau Server

Use CData Tableau Connectors and Tableau Server to visualize live JSON.
Create Instagram-Connected Nintex Workflows

Use CData Connect Cloud to connect to Instagram from Nintex Workflow Cloud and build custom workflows using live Instagram.
How to Easily Query Microsoft Teams in OpenOffice Base