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

CData Software - Knowledge Base

Recent Articles

Access Shopify from MySQL in Amazon QuickSight

Connect to Shopify and build visualizations of Shopify using a MySQL Connection in Amazon QuickSight.
Consume Adobe Analytics OData Feeds in PowerBuilder

This article demonstrates how to consume Adobe Analytics as OData feeds from PowerBuilder using the API Server.
Analyze Sage 300 in R via ODBC

Create data visualizations and use high-performance statistical functions to analyze Sage 300 in Microsoft R Open.
Build Oracle Service Cloud-Connected Web Apps with Axios and CData Connect Cloud

Use CData Connect Cloud to connect to live Oracle Service Cloud and build Oracle Service Cloud-connected web apps with Axios.
Visualize Live HBase of Power BI Report Builder in Power BI Service

Use CData Power BI Connectors to connect to live Apache HBase using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
Automated Continuous WordPress Replication to Oracle

Use CData Sync for automated, continuous, customizable WordPress replication to Oracle.
Build Apps with Live MongoDB in Adalo using CData Connect Cloud

Use CData Connect Cloud to integrate live MongoDB into the Adalo platform and build custom mobile and web applications with real-time MongoDB.
Create Dynamic SAP BusinessObjects BI Grids Using the Infragistics XamDataGrid

Learn how you can connect SAP BusinessObjects BI to Infragistics XamDataGrid to build dynamic grids.
Replicate Azure Blob Storage to Multiple Databases via the CData Sync CLI

Replicate Azure Blob Storage to disparate databases with a single configuration.
Use the CData Software ODBC Driver for Azure Data Lake Storage in SAS for Real-Time Reporting and Analytics

Connect to real-time Azure Data Lake Storage in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Azure Data Lake Storage.
Automated Continuous Harvest Replication to Amazon S3

Use CData Sync for automated, continuous, customizable Harvest replication to Amazon S3.
Access Live Facebook Ads in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

Connect to Facebook Ads from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
Build Act CRM-Connected Apps in Mendix

Use CData Connect Cloud to create an OData feed for Act CRM and create custom apps in Mendix.
Explore Geographical Relationships in Pinterest with Power Map

Create data visualizations with Pinterest in Power Map.
Visualize Vault CRM in Sisense

Create an ElastiCube in Sisense app with access to Veeva Vault & Vault CRM.
Load Amazon Athena to a Database Using Embulk

Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Amazon Athena to a database.
Configure the CData JDBC Driver for Stripe in a Connection Pool in Tomcat

Connect to Stripe from a connection pool in Tomcat.
How to Create Power BI Visual Reports with Real-Time Jira

Use CData Power BI Connectors to visualize Atlassian Jira in Power BI.
Automated Continuous CSV Replication to Google Cloud SQL

Use CData Sync for automated, continuous, customizable CSV replication to Google Cloud SQL.
How to integrate Metabase with Confluence

Use CData Connect Cloud to connect to live Atlassian Confluence and create an interactive dashboard in Metabase from Atlassian Confluence.
Build Semantic Layer Views for Access in APOS Live Data Gateway

Use the CData Connector for Access in APOS Live Data Gateway to build Semantic Layer Views for Microsoft Access.
Connect to MongoDB as a Linked Server via SQL Gateway

Use the SQL Gateway and the ODBC Driver to set up a linked server for MongoDB.
Access Zendesk from MySQL in HeidiSQL

Use CData ODBC Driver and SQL Gateway to connect and query live Zendesk from HeidiSQL.
Query IBM Informix in DataGrip

Create a Data Source for IBM Informix in DataGrip and use SQL to query live IBM Informix.
Visualize Presto in TIBCO Spotfire through ADO.NET

Integrate Presto into dashboards in TIBCO Spotfire.
Integrate JotForm in the Pentaho Report Designer

Publish reports based on JotForm in the Pentaho BI tool.
How to Connect to Microsoft Project in Using Python: 6 Steps

Create Python applications on Linux/UNIX machines with connectivity to Microsoft Project. Leverage the pyodbc module for ODBC in Python.
Visualize Salesforce Data Cloud from Tableau

Use the Tableau Desktop business intelligence tool to connect to Salesforce Data Cloud.
Add PayPal to Informatica Enterprise Data Catalog

Use the CData Software JDBC Driver for PayPal with the Informatica Enterprise Data Catalog to classify and organize data.
Extend Google Sheets with FHIR

Make calls to the API Server from Google Apps Script.
Load HubSpot to a Database Using Embulk

Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load HubSpot to a database.
Automated Continuous Oracle Eloqua Replication to IBM DB2

Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to IBM DB2.
Use the CData Software JDBC Driver for Jira in MicroStrategy Web

Connect to Atlassian Jira in MicroStrategy Web using the CData Software JDBC Driver for Jira.
Connect to Live MariaDB in MicroStrategy through CData Connect Cloud

Create a live connection to MariaDB in CData Connect Cloud and connect to your MariaDB from MicroStrategy.
Connect to Zuora in Aqua Data Studio

Access Zuora from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
Connect and Query Live Smartsheet Data in Databricks with CData Connect Cloud

Use CData Connect Cloud to integrate live Smartsheet into Databricks
Design BIRT Reports on Zoho Creator

Provide current Zoho Creator to your embedded analytics.
Automated Continuous Exact Online Replication to Oracle

Use CData Sync for automated, continuous, customizable Exact Online replication to Oracle.
Analyze MySQL in Infragistics Reveal

Use CData Connect Cloud to create on OData API on top of MySQL and visualize live MySQL in Infragistics Reveal.
Integrate SAP SuccessFactors in Pentaho Data Integration

Build ETL pipelines based on SAP SuccessFactors in the Pentaho Data Integration tool.
Create a Data Access Object for SAP BusinessObjects BI using JDBI

A brief overview of creating a SQL Object API for SAP BusinessObjects BI in JDBI.
Object-Relational Mapping (ORM) with SAP Entities in Java

Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to SAP ERP/NetWeaver into a Java-based ORM framework, Hibernate.
Access Live Monday.com in SAS JMP via ODBC

You can use the CData ODBC Driver to integrate Monday.com into the statistical analysis tools available in SAS JMP. This article shows how to use Monday.com in the Graph Builder and Query Builder.
Visualize Microsoft Exchange in TIBCO Spotfire through ODBC

The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Microsoft Exchange into TIBCO Spotfire.
How to connect to Monday.com from IntelliJ

Integrate connectivity to Monday.com with wizards in IntelliJ.
DataBind Controls to Impala in Delphi

DataBind to Apache Impala in Delphi with standard data access components and controls.
Create Dynamic Box Grids Using the Infragistics XamDataGrid

Learn how you can connect Box to Infragistics XamDataGrid to build dynamic grids.
Import Real-Time Azure Active Directory via ODBC in ColdFusion to Build Applications

Use CData ODBC drivers to import and use Azure Active Directory in ColdFusion.
Bind Live Epicor Kinetic Data in Wijmo FlexGrid with CData API Server

With CData API Server, easily create OData endpoints for live Epicor Kinetic data
Extend Google Sheets with Workday

Make calls to the API Server from Google Apps Script.
DataBind Controls to Adobe Target in Delphi

DataBind to Adobe Target in Delphi with standard data access components and controls.
Model, Search, and Visualize Live Yahoo! Japan Data Solution in ThoughtSpot

Use CData Connect Cloud to connect to live Yahoo! Japan Data Solution for modeling, searching, and visualizing.
Add PingOne to Informatica Enterprise Data Catalog

Use the CData Software JDBC Driver for PingOne with the Informatica Enterprise Data Catalog to classify and organize data.
How to Access Live Oracle Eloqua in Power Automate Desktop via ODBC

The CData ODBC Driver for Oracle Eloqua enables you to integrate Oracle Eloqua into workflows built using Microsoft Power Automate Desktop.
Connect to Oracle in Ruby

Connect to Oracle Database in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
Use the CData Software ODBC Driver for OData in MicroStrategy Web

Connect to OData in MicroStrategy Web using the CData Software ODBC Driver for OData.
Load WooCommerce to a Database Using Embulk

Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load WooCommerce to a database.
Automated Continuous Salesforce Pardot Replication to MySQL

Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to MySQL.
Prepare, Blend, and Analyze Backlog in Alteryx Designer (Connect Cloud)

Build workflows to access live Backlog for self-service data analytics.
How to connect PolyBase to HubDB

Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live HubDB.
How to Import Data from Xero into Google Sheets

Import Xero Accounting into a Google spreadsheet that is automatically refreshed.
Connect to Drip in RazorSQL

Connect to Drip from wizards and query Drip from the GUI in the RazorSQL database management tool.
A PostgreSQL Interface for Azure Data Catalog (MySQL Remoting via JDBC)

Use the Remoting features of the Azure Data Catalog JDBC Driver to create a PostgreSQL entry-point for data access.
Publish Reports with Epicor Kinetic in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Epicor Kinetic.
Consume GitHub OData Feeds in PowerBuilder

This article demonstrates how to consume GitHub as OData feeds from PowerBuilder using the API Server.
Connect to xBase from PowerBuilder via ADO.NET

This article demonstrates how to access xBase from Appeon PowerBuilder using the CData ADO.NET Provider for xBase.
Query Redis in DataGrip

Create a Data Source for Redis in DataGrip and use SQL to query live Redis.
Build Semantic Layer Views for Zoho Books in APOS Live Data Gateway

Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Zoho Books.
Automated Continuous Oracle Financials Cloud Replication to Oracle

Use CData Sync for automated, continuous, customizable Oracle Financials Cloud replication to Oracle.
Load Sugar CRM to a Database Using Embulk

Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Sugar CRM to a database.
Access Live Xero in Excel 365 Online (Excel for the web)

Connect to Xero Accounting from Excel 365 Online (Excel for the web) with CData Connect Cloud.
Connect to Teradata from a Connection Pool in Jetty

The Teradata JDBC Driver supports connection pooling: This article shows how to connect faster to Teradata from Web apps in Jetty.
Connect to LDAP Objects in DBArtisan

Use wizards in DBArtisan to configure LDAP as a data source.
Query Oracle Service Cloud using the OData SDK for PHP

Use the API Server and the OData PHP SDK to easily consume Oracle Service Cloud entities in PHP by modeling them as objects.
Connect to Trello from a Connection Pool in JBoss

Integrate Trello into Java servlets: Use the Management Console in JBoss to install the Trello JDBC Driver.
Automated Continuous Shippo Replication to Microsoft Access

Use CData Sync for automated, continuous, customizable Shippo replication to Microsoft Access.
Perform Batch Operations with SAP Business One in Apache NiFi

Connect to SAP Business One and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
Build Semantic Layer Views for Xero in APOS Live Data Gateway

Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Xero Accounting.
Process & Analyze Microsoft Planner in Databricks (AWS)

Use CData, AWS, and Databricks to perform data engineering and data science on live Microsoft Planner .
Build Greenplum-Connected Visualizations in datapine

Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Pivotal GreenPlum.
How to connect to Oracle Eloqua in DBVisualizer

Integrate Oracle Eloqua with visual data analysis tools and data connection wizards in DBVisualizer
Automated Continuous DB2 Replication to Amazon Redshift

Use CData Sync for automated, continuous, customizable DB2 replication to Amazon Redshift.
Use CData Connect Cloud to Access Stripe in Microsoft Power Pivot

Use CData Connect Cloud to connect to live Stripe in the Power Pivot business intelligence tool.
Natively Connect to MailChimp in PHP

The CData ODBC driver for MailChimp enables you to create PHP applications with connectivity to MailChimp. Leverage the native support for ODBC in PHP.
Replicate Sybase from PowerShell

Write a quick PowerShell script to query Sybase. Use connectivity to the live data to replicate Sybase to SQL Server.
Extend Google Sheets with IBM Cloud Object Storage

Make calls to the API Server from Google Apps Script.
Build Apps with Live Cvent Using the Low-Code Development Platform of Mendix