CData Software Knowledge Base

Integrate with ShipStation using Apache Camel2

Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ShipStation to a JSON file on disk.

Build SAP-Connected ETL Processes in Google Data Fusion

Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SAP ERP/NetWeaver.

Build Charts with Salesforce Pardot in Clear Analytics

Create dynamic charts and perform analytics based on Salesforce Pardot in Clear Analytics.

SAP HANA XS Advanced Reporting in OBIEE with the SAP HANA XS Advanced JDBC Driver

Deploy the SAP HANA XS Advanced JDBC driver on OBIEE to provide real-time reporting across the enterprise.

Automate ClickUp Replication to Couchbase

Use CData Sync to Customize and automate ClickUp replication to Couchbase.

Create Informatica Mappings From/To an ODBC Data Source for MySQL

Create an ODBC connection to MySQL in Informatica and browse and transfer MySQL.

Build MVC Applications with Connectivity to Twitter

This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Twitter from an ASP.NET MVC application.

Build Interactive Dashboards from IBM Cloud Data Engine in Amazon QuickSight

Create a virtual SQL Server database for IBM Cloud Data Engine in CData Software Connect Server and import IBM Cloud Data Engine into Amazon QuickSight SPICE to build interactive dashboards.

DataBind Controls to SAP in Delphi

DataBind to SAP ERP/NetWeaver in Delphi with standard data access components and controls.

Use Biml to Build SSIS Tasks to Replicate Google Drive to SQL Server

Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Google Drive to SQL Server.

Create Reports with Reckon in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Reckon.

Create Data Visualizations in Cognos BI with Redis

Access Redis as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

Integrate Impala into Automated Tasks with Power Automate

Use CData Connect Cloud to connect to Apache Impala and integrate live Apache Impala into your Power Automate tasks.

Build Semantic Layer Views for Exact Online in APOS Live Data Gateway

Use the CData Connector for Exact Online in APOS Live Data Gateway to build Semantic Layer Views for Exact Online.

Create Data Visualizations in Cognos BI with Unbounce

Access Unbounce as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

Extract, Transform, and Load BigCommerce in Informatica PowerCenter

Create a simple Workflow for BigCommerce in Informatica PowerCenter.

Visualize Live Outreach.io of Power BI Report Builder in Power BI Service

Use CData Power BI Connectors to connect to live Outreach.io using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

How to Connect DBeaver to Sage 300 via a JDBC Driver

Manage Sage 300 with visual tools in DBeaver like the query browser.

A PostgreSQL Interface for ADP

Use the SQL Gateway and ADP ODBC Driver to create a PostgreSQL entry-point for data access.

Connect to Google Search Results in Ruby

Connect to Google Search in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

Automate IBM Cloud Object Storage Replication to SAP HANA

Use CData Sync to customize and automate IBM Cloud Object Storage replication to SAP HANA.

Connect to LinkedIn from HeidiSQL

Use CData Connect Cloud to connect to and query live LinkedIn from HeidiSQL.

How to Connect to ActiveCampaign in Using Python: 6 Steps

Create Python applications on Linux/UNIX machines with connectivity to ActiveCampaign. Leverage the pyodbc module for ODBC in Python.

Automated Continuous Google Campaign Manager 360 Replication to Vertica

Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to Vertica.

Automated Continuous Marketo Replication to Snowflake

Use CData Sync for automated, continuous, customizable Marketo replication to Snowflake.

Build Semantic Layer Views for Instagram in APOS Live Data Gateway

Use the CData Connector for Instagram in APOS Live Data Gateway to build Semantic Layer Views for Instagram.

How to create HubDB federated tables in MySQL

Use the SQL Gateway and the ODBC Driver to set up federated tables for HubDB in MySQL .

Explore Geographical Relationships in Sage 200 with Power Map

Create data visualizations with Sage 200 in Power Map.

Excel Spreadsheet Automation with the QUERY Formula

Pull data, automate spreadsheets, and more with the QUERY formula.

How to Access Tally Using Entity Framework

This article shows how to access Tally ERP using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

DataBind Controls to Avalara AvaTax in Delphi

DataBind to Avalara AvaTax in Delphi with standard data access components and controls.

Create an SAP BusinessObjects Universe on the CData JDBC Driver for Reckon Accounts Hosted

Provide connectivity to Reckon Accounts Hosted through an SAP BusinessObjects universe.

Create Data Visualizations Based On Azure Data Lake Storage in Mode

Use CData Connect Cloud to connect to Azure Data Lake Storage from Mode and build visualizations using live

Build SuiteCRM-Connected Dashboards in Redash

Use CData Software Connect Server to create a virtual SQL Server Database for SuiteCRM and build visualizations and dashbaords from SuiteCRM in Redash.

Automated Continuous EventBrite Replication to Microsoft Access

Use CData Sync for automated, continuous, customizable EventBrite replication to Microsoft Access.

Query SAP Ariba Procurement in DataGrip

Create a Data Source for SAP Ariba Procurement in DataGrip and use SQL to query live SAP Ariba Procurement.

How to connect to Microsoft Dataverse in DBVisualizer

Integrate Microsoft Dataverse (CDS) with visual data analysis tools and data connection wizards in DBVisualizer

Use the CData Software ODBC Driver for Unbounce in SAS for Real-Time Reporting and Analytics

Connect to real-time Unbounce in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Unbounce.

Work with HarperDB in FoxPro

Load HarperDB into a FoxPro database. This article includes full code and a walk-through of the process.

Build Dashboards with SAP Ariba Procurement in DBxtra

Create dynamic dashboards and perform analytics based on SAP Ariba Procurement in DBxtra.

CData Software - Knowledge Base

Recent Articles