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

CData Software - Knowledge Base

Recent Articles

Build Freshdesk-Connected Apps in Bubble

Use CData Connect Cloud to create an OData feed for Freshdesk and create custom apps in Bubble.
A Comparison of Drivers for Amazon DynamoDB

An article comparing the read performance, client-side resource usage, and read capacity consumption of different JDBC drivers for Amazon DynamoDB.
Sansan Cloud Connectivity

Explore a compilation of guides and tutorials demonstrating how to establish connections to Sansan through CData Connect Cloud using different applications and tools.
Integrate with Typeform in JReport Designer

Create charts and reports based on Typeform in JReport Designer.
Access Live SurveyMonkey in Excel (Desktop) through Connect Spreadsheets

Use Connect Spreadsheets by CData to gain access to live SurveyMonkey from your Excel spreadsheets.
A PostgreSQL Interface for Zoho Books using the CData ODBC Driver

Use the SQL Gateway and Zoho Books ODBC Driver to create a PostgreSQL entry-point for data access.
Connect to Raisers Edge NXT in CloverDX (formerly CloverETL)

Transfer Raisers Edge NXT using the visual workflow in the CloverDX data integration tool.
Create an SAP BusinessObjects Universe on the CData ODBC Driver for IBM Informix

Provide connectivity to IBM Informix through an SAP BusinessObjects universe.
Build Semantic Layer Views for Bing Ads in APOS Live Data Gateway

Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Bing Ads.
Automated Continuous Adobe Commerce Replication to AlloyDB

Use CData Sync for automated, continuous, customizable Adobe Commerce replication to AlloyDB.
Access Microsoft Exchange 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 Microsoft Exchange.
Analyze Amazon S3 in Looker

Use CData Connect Cloud to connect to Amazon S3 from Looker and build custom apps using live Amazon S3.
Clio Reporting in OBIEE with the Clio JDBC Driver

Deploy the Clio JDBC driver on OBIEE to provide real-time reporting across the enterprise.
How to Access Oracle SCM Using Entity Framework

This article shows how to access Oracle SCM using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
Access Live Freshdesk in Excel (Desktop) via Connect Cloud

Use CData Connect Cloud to gain access to live Freshdesk from your Excel spreadsheets.
DataBind Controls to Microsoft Project in C++Builder

DataBind to Microsoft Project in C++Builder with standard components and controls.
How to Connect to Sage 300 in Using Python: 6 Steps

Create Python applications on Linux/UNIX machines with connectivity to Sage 300. Leverage the pyodbc module for ODBC in Python.
Integrate Excel with External Services using SnapLogic

Use CData JDBC drivers in SnapLogic to integrate Excel with External Services.
Work with Gmail in FoxPro

Load Gmail into a FoxPro database. This article includes full code and a walk-through of the process.
How to import OneNote into Apache Solr

Use the CData Software JDBC Driver for OneNote in Data Import Handler and create an automated import of Microsoft OneNote to Apache Solr Enterprise Search platform.
Build Dashboards with HubSpot in DBxtra

Create dynamic dashboards and perform analytics based on HubSpot in DBxtra.
Visualize Google Sheets in TIBCO Spotfire through ODBC

The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Google Sheets into TIBCO Spotfire.
DataBind Controls to xBase in C++Builder

DataBind to xBase in C++Builder with standard components and controls.
Manage Unbounce in DBArtisan as a JDBC Source

Use wizards in DBArtisan to create a JDBC data source for Unbounce.
Choosing the Best Method to Connect Azure Table to SQL Server: 5 Options Explained

Discover multiple ways to connect and use Azure Table Storage from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
Bind Live eBay Data in Wijmo FlexGrid with CData API Server

With CData API Server, easily create OData endpoints for live eBay data
Load DB2 to a Database Using Embulk

Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load IBM DB2 to a database.
DataBind Charts to Zoho Books

Use the standard ADO.NET procedures for databinding to provide bidirectional access to Zoho Books 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.
Build Google Contacts-Connected Dashboards Using Zoho Analytics

Use CData Connect Cloud to connect to Google Contacts from Zoho Analytics and import live Google Contacts.
Visualize SAP HANA XS Advanced in Sisense

Create an ElastiCube in Sisense app with access to SAP HANA XS Advanced.
Access Live Amazon DynamoDB in Excel 365 Online (Excel for the web)

Connect to Amazon DynamoDB from Excel 365 Online (Excel for the web) with CData Connect Cloud.
Establish a Live Connection with Azure DevOps using Tableau Bridge

The CData ODBC Driver for Azure DevOps enables you to integrate live Azure DevOps into Tableau Cloud dashboards using the Tableau Bridge.
Visualize Live MongoDB in the Power BI Service

Use CData Connect Cloud to connect to live MongoDB and create custom reports in the Power BI Service through the On-Premises Gateway.
Integrate with Live SAP SuccessFactors in MuleSoft (via CData Connect Cloud)

Use CData Connect Cloud to connect to SAP SuccessFactors from the MuleSoft Anypoint Platform to integrate live SAP SuccessFactors into custom reports and dashboards.
Query ShipStation in DataGrip

Create a Data Source for ShipStation in DataGrip and use SQL to query live ShipStation.
Import Reckon Accounts Hosted into Microsoft Power Query

The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Reckon Accounts Hosted. In this article, you will use the OData format to import Reckon Accounts Hosted into Microsoft Power Query.
Analyze Workday in Slingshot with CData API Server

Use the CData API Server to build an OData API on top of Workday and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
Create Informatica Mappings From/To an ODBC Data Source for SAP Netweaver Gateway

Create an ODBC connection to SAP Netweaver Gateway in Informatica and browse and transfer SAP Netweaver Gateway.
Connect to and Query SurveyMonkey in QlikView over ODBC

Create data visualizations with SurveyMonkey in QlikView.
Automated Continuous Basecamp Replication to Amazon Redshift

Use CData Sync for automated, continuous, customizable Basecamp replication to Amazon Redshift.
Connect to Greenplum in ACL Analytics

Connect to Pivotal GreenPlum via CData Connect Cloud in ACL Analytics to run your data analysis workflows with real-time access to Pivotal GreenPlum.
Work with Oracle Eloqua in FoxPro

Load Oracle Eloqua into a FoxPro database. This article includes full code and a walk-through of the process.
Build Data Flows from Google Sheets to SQL Server using SSIS

Easily back up Google Sheets to SQL Server using the SSIS components for Google Sheets.
Use the CData SSIS Components to Insert New or Update Existing Email Records from SQL Server

Easily push SQL Server data to Email using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Email or update existing records with data from a SQL Server database.
Create Dashboards and Visualize Live Act-On in Geckoboard

Use CData Connect Cloud to connect to live Act-On and create dashboards for real-time monitoring and visualization in Geckoboard.
Connect to QuickBooks Time from PowerBuilder via ADO.NET

This article demonstrates how to access QuickBooks Time from Appeon PowerBuilder using the CData ADO.NET Provider for QuickBooks Time.
Use JayDeBeApi to access QuickBooks Time in Python

Use standard Python scripting and the development environment of your choice to access live QuickBooks Time.
Automate Freshdesk Replication to Azure Synapse

Use CData Sync to customize and automate Freshdesk replication to Azure Synapse.
Automated Continuous Spark Replication to PostgreSQL

Use CData Sync for automated, continuous, customizable Spark replication to PostgreSQL.
Integrate HubDB in Pentaho Data Integration

Build ETL pipelines based on HubDB in the Pentaho Data Integration tool.
Connect Microsoft Planner to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

Connect to your Microsoft Planner using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
Automated Continuous Google Analytics Replication to Local Delimited Files

Use CData Sync for automated, continuous, customizable Google Analytics replication to delimited files (CSV/TSV).
Access Live Snowflake in Excel (Desktop) via Connect Cloud

Use CData Connect Cloud to gain access to live Snowflake from your Excel spreadsheets.
How to Connect to Cloudant in Using Python: 6 Steps

Create Python applications on Linux/UNIX machines with connectivity to IBM Cloudant. Leverage the pyodbc module for ODBC in Python.
DataBind Controls to SAP Netweaver Gateway in Delphi

DataBind to SAP Netweaver Gateway in Delphi with standard data access components and controls.
Access BambooHR as a Remote Oracle Database

Use the Oracle ODBC Gateway and Heterogeneous Services technology to access BambooHR from your Oracle system.
Replicate Airtable to Multiple Databases

Replicate Airtable to disparate databases with a point-and-click configuration.
Operational Reporting on ShipStation from Spotfire Server

Create and share Spotfire data visualizations with real-time connectivity to remote ShipStation.
Choosing the Best Method to Connect HubDB to SQL Server: 5 Options Explained

Discover multiple ways to connect and use HubDB from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
Connect eBay to AI Assistants With the CData Python MCP Server

Learn how to give AI assistants like Claude direct access to live eBay using the CData Python MCP Server.
Build AI/ML Models with Live GitHub Data using Dataiku