CData Software Knowledge Base

Design BIRT Reports on JDBC-ODBC Bridge

Provide current JDBC-ODBC Bridge to your embedded analytics.

Import Real-Time Twitter Ads via JDBC in ColdFusion to Build Applications

Use CData JDBC drivers to import and use Twitter Ads in ColdFusion.

Access eBay from MySQL in HeidiSQL

Use CData ODBC Driver and SQL Gateway to connect and query live eBay from HeidiSQL.

Create Dynamic Zoho CRM Grids Using the Infragistics XamDataGrid

Learn how you can connect Zoho CRM to Infragistics XamDataGrid to build dynamic grids.

Create Apps from Sage Cloud Accounting in Qlik Sense Cloud

Use CData Connect Cloud to connect to Sage Cloud Accounting and build apps from live Sage Business Cloud Accounting in Qlik Sense Cloud.

Connect Greenplum to AI Assistants With the CData Python MCP Server

Learn how to give AI assistants like Claude direct access to live Pivotal GreenPlum using the CData Python MCP Server.

How to connect to OneNote from Spring Boot

Connect to OneNote in a Spring Boot Application using CData JDBC OneNote Driver

Process & Analyze SAP Business One in Databricks (AWS)

Use CData, AWS, and Databricks to perform data engineering and data science on live SAP Business One .

Use the CData Software ODBC Driver for Tally in MicroStrategy Web

Connect to Tally ERP in MicroStrategy Web using the CData Software ODBC Driver for Tally.

Automate Redshift Replication to SAP HANA

Use CData Sync to customize and automate Amazon Redshift replication to SAP HANA.

Access Live Azure Analysis Services in AWS Lambda

Connect to live Azure Analysis Services in AWS Lambda using the CData JDBC Driver.

Connect to Active Directory as a Linked Server via SQL Gateway

Use the SQL Gateway and the ODBC Driver to set up a linked server for Active Directory.

Create Power BI Reports on Real-Time Stripe

Use the CData ODBC Driver for Stripe to visualize Stripe in Power BI Desktop.

Create SharePoint-Connected Business Apps in AppSheet

Connect to SharePoint via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to Microsoft SharePoint.

Use the CData Software JDBC Driver for Salesforce in MicroStrategy Web

Connect to Salesforce & Force.com in MicroStrategy Web using the CData Software JDBC Driver for Salesforce.

How to connect to Cosmos DB from IntelliJ

Integrate connectivity to Azure Cosmos DB with wizards in IntelliJ.

Automated Continuous Snapchat Ads Replication to Oracle

Use CData Sync for automated, continuous, customizable Snapchat Ads replication to Oracle.

How to Connect to Odoo in Using Python: 6 Steps

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

Visualize Google Analytics in Tableau

The CData ODBC driver for Google Analytics enables you integrate Google Analytics into Tableau dashboards.

Working with WooCommerce in LINQPad

Execute LINQ queries to WooCommerce in LINQPad.

Automated Continuous SendGrid Replication to Local Delimited Files

Use CData Sync for automated, continuous, customizable SendGrid replication to delimited files (CSV/TSV).

Create SSAS Tabular Models from Jira Assets

How to build a SQL Server Analysis Service Tabular Model from Jira Assets using CData drivers.

Connect to LinkedIn in Jaspersoft Studio

Execute SQL to remote LinkedIn in Jaspersoft Studio.

Build Semantic Layer Views for Azure DevOps in APOS Live Data Gateway

Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Azure DevOps.

How to Connect to SAP ByDesign in Using Python: 6 Steps

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

Connect to Google Analytics in CloverDX (formerly CloverETL)

Transfer Google Analytics using the visual workflow in the CloverDX data integration tool.

Automated Continuous Tableau CRM Analytics Replication to AlloyDB

Use CData Sync for automated, continuous, customizable Tableau CRM Analytics replication to AlloyDB.

Visualize Basecamp from Tableau

Use the Tableau Desktop business intelligence tool to connect to Basecamp.

Integrate SAP Ariba Source in the Pentaho Report Designer

Publish reports based on SAP Ariba Source in the Pentaho BI tool.

Connect to Reckon from Blazor Apps

Build ASP.NET Core Blazor C# apps that integrate with real-time Reckon using standard SQL.

Connect to SAP BusinessObjects BI in DBeaver

Use the CData ODBC Driver to connect to SAP BusinessObjects BI in DBeaver.

Connect to eBay Analytics from a Connection Pool in Jetty

The eBay Analytics JDBC Driver supports connection pooling: This article shows how to connect faster to eBay Analytics from Web apps in Jetty.

DataBind Klipfolio to the DevExpress Data Grid

Use the CData Software ADO.NET Provider for Klipfolio with the DevExpress Windows Forms and Web controls to provide Klipfolio to a chart.

Integrate Jira Assets in Your Informatica Cloud Instance

Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Jira Assets from Informatica Cloud.

Configure the CData JDBC Driver for Aha in a Connection Pool in Tomcat

Connect to Aha! from a connection pool in Tomcat.

Connect to Redis in Airbyte ELT Pipelines

Use CData Connect Cloud to build ELT pipelines for Redis in Airbyte.

Work with SuiteCRM in FoxPro

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

Import Real-Time Paylocity via JDBC in ColdFusion to Build Applications

Use CData JDBC drivers to import and use Paylocity in ColdFusion.

Build Visualizations of Salesloft in Birst

Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Salesloft in Birst.

Automated Continuous XML Replication to Microsoft Access

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

Connect to Zendesk as an External Data Source using PolyBase

Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live Zendesk.

Integrate Sage 300 in the Pentaho Report Designer

Publish reports based on Sage 300 in the Pentaho BI tool.

How to Connect to & Open Zoho Projects in Microsoft Excel

This article uses the CData ODBC driver for Zoho Projects to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

Connect to Adobe Analytics in RazorSQL

Connect to Adobe Analytics from wizards and query Adobe Analytics from the GUI in the RazorSQL database management tool.

Connect to Highrise in DBArtisan

Use wizards in DBArtisan to configure Highrise CRM as a data source.

How to Work with Microsoft Planner in ETL Validator JDBC

Connect to Microsoft Planner from ETL Validator jobs using the CData Software JDBC Driver.

Create SSAS Tabular Models from PayPal

How to build a SQL Server Analysis Service Tabular Model from PayPal using CData drivers.

Creating Microsoft Planner-Connected Applications in Unqork

You can use CData Connect Cloud to feed Microsoft Planner to Unqork and build custom business apps.

Prepare, Blend, and Analyze ADP in Alteryx Designer (Connect Cloud)

Build workflows to access live ADP for self-service data analytics.

Visualize Aha in Sisense

Create an ElastiCube in Sisense app with access to Aha!.

Use JayDeBeApi to access Zoho Books in Python

Use standard Python scripting and the development environment of your choice to access live Zoho Books.

Migrating data from SAP BusinessObjects BI to Snowflake using CData SSIS Components.

Easily push SAP BusinessObjects BI to Snowflake using the CData SSIS Tasks for SAP BusinessObjects BI and Snowflake.

Connect to Google Directory from HeidiSQL

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

Integrate Azure Data Catalog in Your Informatica Cloud Instance

Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Azure Data Catalog from Informatica Cloud.

Edit and Search Drift External Objects in Salesforce Connect (API Server)

Use the API Server to securely provide OData feeds of Drift to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Drift objects that you can access from apps and the dashboard.

Connect to Facebook Ads in the Denodo Platform

Use CData driver technologies to create a virtual data source for Facebook Ads in the Denodo Virtual DataPort Administrator.

Visualize Live Blackbaud FE NXT in the Power BI Service

Use CData Connect Cloud to connect to live Blackbaud FE NXT and create custom reports in the Power BI Service through the On-Premises Gateway.

Create Informatica Mappings From/To a JDBC Data Source for RSS

Create RSS data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

Process & Analyze Google Ads in Databricks (AWS)

Use CData, AWS, and Databricks to perform data engineering and data science on live Google Ads .

Connect to XML from a Connection Pool in JBoss

Integrate XML Files into Java servlets: Use the Management Console in JBoss to install the XML JDBC Driver.

How to integrate WordPress with Apache Airflow

Access and process WordPress in Apache Airflow using the CData JDBC Driver.

Connect to Dynamics CRM from Asprova with CData Software ODBC Driver for Dynamics CRM

This article shows how to connect faster to Dynamics CRM data from Asprova.

Create Paylocity-Connected Dashboards in Grafana

Connect to Paylocity via CData Connect Cloud in Grafana and create custom business dashboards with real-time access to Paylocity.

CData Software - Knowledge Base

Recent Articles