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

CData Software - Knowledge Base

Recent Articles

Access Office 365 as a Remote Oracle Database

Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Microsoft Office 365 from your Oracle system.
Integrate Active Directory with External Services using SnapLogic

Use CData JDBC drivers in SnapLogic to integrate Active Directory with External Services.
Using the CData Software ODBC Driver for IBM Cloud Object Storage in PyCharm

Connect to IBM Cloud Object Storage as an ODBC data source in PyCharm using the CData Software ODBC Driver for IBM Cloud Object Storage.
Query SAP SuccessFactors using the OData SDK for PHP

Use the API Server and the OData PHP SDK to easily consume SAP SuccessFactors entities in PHP by modeling them as objects.
How to Query SAP Concur in MySQL Workbench

Execute MySQL queries against live SAP Concur from MySQL Workbench.
How to connect to Box from Spring Boot

Connect to Box in a Spring Boot Application using CData JDBC Box Driver
Automated Continuous Exact Online Replication to Oracle

Use CData Sync for automated, continuous, customizable Exact Online replication to Oracle.
Natively Connect to Zuora in PHP via ODBC (Linux)

Create PHP applications on Linux/UNIX machines with connectivity to Zuora. Leverage the native support for ODBC in PHP.
Automated Continuous Cassandra Replication to Vertica

Use CData Sync for automated, continuous, customizable Cassandra replication to Vertica.
Establish a Live Connection with Certinia using Tableau Bridge

The CData ODBC Driver for Certinia enables you to integrate live Certinia into Tableau Cloud dashboards using the Tableau Bridge.
Model Dynamics 365 Using Azure Analysis Services

Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Dynamics 365, enabling the direct import of real-time Microsoft Dynamics 365.
Connect to GMO MakeShop from Crystal Reports

Use CData Connect Cloud to connect to and report on live GMO MakeShop from Crystal Reports.
Publish Zenefits-Connected Dashboards in Tableau Server

Use CData Tableau Connectors and Tableau Server to visualize live Zenefits.
How to Access Live Twitter Ads in Power Automate Desktop via ODBC

The CData ODBC Driver for Twitter Ads enables you to integrate Twitter Ads into workflows built using Microsoft Power Automate Desktop.
Access Jira from MySQL in Amazon QuickSight

Connect to Jira and build visualizations of Atlassian Jira using a MySQL Connection in Amazon QuickSight.
How to publish and share Acumatica dashboards with Tableau Server

The CData ODBC driver for Acumatica enables you integrate Acumatica ERP into Tableau dashboards.
Visualize Live Salesforce Marketing in Power BI (via CData Connect Cloud)

Use the CData Power BI Connector and CData Connect Cloud to integrate live Salesforce Marketing Cloud into custom reports in Power BI.
Migrating data from Salesforce to Google BigQuery using CData SSIS Components.

Easily push Salesforce & Force.com to Google BigQuery using the CData SSIS Tasks for Salesforce and Google BigQuery.
Publish Reports with MongoDB in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date MongoDB.
Visualize Live Cosmos DB in the Power BI Service

Use CData Connect Cloud to connect to live Azure Cosmos DB and create custom reports in the Power BI Service through the On-Premises Gateway.
Automate Asana Tasks in Power Automate Using CData API Server

With CData API Server, easily create OData endpoints for live Asana and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
Automated Continuous Sage 300 Replication to Oracle

Use CData Sync for automated, continuous, customizable Sage 300 replication to Oracle.
How to connect to Zoho Creator with Squirrel SQL client

Connect to Zoho Creator and execute queries in the Squirrel SQL Client.
Automated Continuous Parquet Replication to Vertica

Use CData Sync for automated, continuous, customizable Parquet replication to Vertica.
Edit and Search External Zoho Creator Objects in Salesforce Connect

Use CData Connect Cloud to securely provide OData feeds of Zoho Creator to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Zoho Creator objects that you can access from apps and the dashboard.
Replicate Multiple Cassandra Accounts via the CData Sync CLI

Replicate multiple Cassandra accounts to one or many databases.
Manage QuickBooks Time in DBArtisan as a JDBC Source

Use wizards in DBArtisan to create a JDBC data source for QuickBooks Time.
Access Live MongoDB in Excel (Desktop) via Connect Cloud

Use CData Connect Cloud to gain access to live MongoDB from your Excel spreadsheets.
Provide OData Services of Sugar CRM from a WCF Application

In this article, we will demonstrate the process of generating an OData feed for Sugar CRM by developing a WCF Service Application.
Automated Continuous Confluence Replication to MySQL

Use CData Sync for automated, continuous, customizable Confluence replication to MySQL.
Use the CData Software ODBC Driver for PayPal in SAS for Real-Time Reporting and Analytics

Connect to real-time PayPal in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for PayPal.
Prepare, Blend, and Analyze IBM Cloud Object Storage in Alteryx Designer (ODBC)

Build workflows to access live IBM Cloud Object Storage for self-service data analytics.
Automated Continuous HDFS Replication to PostgreSQL

Use CData Sync for automated, continuous, customizable HDFS replication to PostgreSQL.
Trigger Stripe IFTTT Flows in Azure App Service

This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
How to Import Data from Avro into Google Sheets

Import Apache Avro into a Google spreadsheet that is automatically refreshed.
Access IBM Informix from MySQL in Amazon QuickSight

Connect to IBM Informix and build visualizations of IBM Informix using a MySQL Connection in Amazon QuickSight.
Create Jira Service Management-Connected Visualizations in Klipfolio

Use CData Connect Cloud to connect to Jira Service Management from Klipfolio and build custom visualizations using live Atlassian Jira Service Management.
Connect to HubDB in Ruby

Connect to HubDB in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
Create Informatica Mappings From/To an ODBC Data Source for Gmail

Create an ODBC connection to Gmail in Informatica and browse and transfer Gmail.
Query GraphQL from Node.js

Use the OData endpoint of the CData API Server to connect to your GraphQL and perform CRUD operations on GraphQL from Node.js.
Access Live ActiveCampaign in Google Sheets via Connect Cloud

Use CData Connect Cloud to gain access to live ActiveCampaign from your Google Sheets.
Build a PostgreSQL Interface for Calendly using the CData JDBC Driver

Use the Remoting features of the Calendly JDBC Driver to create a PostgreSQL entry-point for data access.
How to connect SharePoint with IBM Cloud Object Storage through external lists

Provide IBM Cloud Object Storage to SharePoint users as an external list.
LINQ to Microsoft Exchange

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 Microsoft Exchange Data Provider.
Access Veeva Vault as a Remote Oracle Database

Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Veeva Vault & Vault CRM from your Oracle system.
How to connect to GitHub from Spring Boot

Connect to GitHub in a Spring Boot Application using CData JDBC GitHub Driver
How to Build an ETL App for Avalara AvaTax in Python with CData

Create ETL applications and real-time data pipelines for Avalara AvaTax in Python with petl.
Connect to SAP Ariba Procurement in Claris FileMaker Pro