CData Software Knowledge Base

Analyze Facebook with Power Pivot

This article walks you through the process of using the CData ODBC Driver for Facebook from Power Pivot. You will use the Table Import Wizard to load Facebook. You can visually build the import query or use any SQL supported by the driver.

Connect to Salesforce Pardot from a Connection Pool in WebLogic

Use the CData JDBC Driver for Salesforce Pardot to connect to Salesforce Pardot from Web applications running on WebLogic.

Integrate REST with External Services using SnapLogic

Use CData JDBC drivers in SnapLogic to integrate REST with External Services.

Access Certinia 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 Certinia.

How to create Visio diagrams from Google Drive

Automatically update Google Drive with the changes you make to Visio master shapes.

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

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

How to update Outreach.io from Excel

This article explains how to transfer data from Excel to Outreach.io using the Excel Add-In for Outreach.io.

Visualize Live Sage Intacct of Power BI Report Builder in Power BI Service

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

Access eBay from MySQL in HeidiSQL

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

Stream JSON Services into Apache Kafka Topics

Access and stream JSON in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

Access Google Data Catalog 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 Google Data Catalog.

Create Data Visualizations in Cognos BI with REST

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

Integrate Real-Time Access to Confluence in SAPUI5 MVC Apps

Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Atlassian Confluence in real time.

Integrate Live Workday into Amazon SageMaker Canvas with RDS

Use CData Connect Cloud to connect to Workday from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Workday.

Import Real-Time TaxJar via ODBC in ColdFusion to Build Applications

Use CData ODBC drivers to import and use TaxJar in ColdFusion.

Connect to Todoist in Jaspersoft Studio

Execute SQL to remote Todoist in Jaspersoft Studio.

Analyze Office 365 in R via ODBC

Create data visualizations and use high-performance statistical functions to analyze Microsoft Office 365 in Microsoft R Open.

Access Monday.com from MySQL in HeidiSQL

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

Query Cloudant as a SQL Server Database in Node.js

Execute SQL Server queries against IBM Cloudant from Node.js.

ETL SFTP in Oracle Data Integrator

This article shows how to transfer SFTP into a data warehouse using Oracle Data Integrator.

Rapidly Develop Jira Service Management-Driven Apps with Active Query Builder

Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.

Connect to Azure Table in Google Apps Script via Connect Cloud

Use CData Connect Cloud to access Azure Table Storage in Google Apps Script.

Build a PostgreSQL Interface for Procore using the CData JDBC Driver

Use the Remoting features of the Procore JDBC Driver to create a PostgreSQL entry-point for data access.

Connect to IBM Cloud Object Storage in DBeaver

Use the CData ODBC Driver to connect to IBM Cloud Object Storage in DBeaver.

Access Excel from MySQL in Amazon QuickSight

Connect to Excel and build visualizations of Microsoft Excel using a MySQL Connection in Amazon QuickSight.

Automated Continuous Twitter Replication to Amazon S3

Use CData Sync for automated, continuous, customizable Twitter replication to Amazon S3.

Bridge Square Connectivity with Apache NiFi

Access and process Square in Apache NiFi using the CData JDBC Driver.

How to use SQLAlchemy ORM to access Hive in Python

Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Apache Hive.

Build Data Flows from Zoho Books to SQL Server using SSIS

Easily back up Zoho Books to SQL Server using the SSIS components for Zoho Books.

Analyze Tally in SAP Analytics Cloud

Use the CData Connect Server to create an OData API on top of Tally ERP and visualize Tally ERP in SAP Analytics Cloud.

Integrate with live NetSuite in Jitterbit

Use CData Connect Cloud to connect to and integrate live NetSuite CRM & ERP in Jitterbit.

Query Blackbaud FE NXT in DataGrip

Create a Data Source for Blackbaud FE NXT in DataGrip and use SQL to query live Blackbaud FE NXT.

Import Real-Time Access via ODBC in ColdFusion to Build Applications

Use CData ODBC drivers to import and use Microsoft Access in ColdFusion.

Import Real-Time Microsoft Dataverse via ODBC in ColdFusion to Build Applications

Use CData ODBC drivers to import and use Microsoft Dataverse (CDS) in ColdFusion.

How to Connect to & Open Act CRM in Microsoft Excel

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

Configure the CData JDBC Driver for Excel Online in a Connection Pool in Tomcat

Connect to Microsoft Excel Online from a connection pool in Tomcat.

Use the CData Software JDBC Driver for Dynamics 365 Business Central in MicroStrategy

Connect to Dynamics 365 Business Central in MicroStrategy Developer using the CData Software JDBC Driver for Dynamics 365 Business Central.

Create Sansan-Connected Enterprise Applications in OutSystems

Use CData Connect Cloud to connect to Sansan from OutSystems and build custom enterprise apps using live Sansan.

Integrate with Redis using Apache Camel2

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

A PostgreSQL Interface for HubSpot using the CData ODBC Driver

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

Integrate with TaxJar in JReport Designer

Create charts and reports based on TaxJar in JReport Designer.

How to Query Live SendGrid Data in Natural Language in Python using LlamaIndex

Use LlamaIndex to query live SendGrid data in natural language using Python.

Extract, Transform, and Load Salesforce Pardot in Informatica PowerCenter

Create a simple Workflow for Salesforce Pardot in Informatica PowerCenter.

Create Data Visualizations in Cognos BI with Redshift

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

Visualize Live Google Directory in Power BI (via CData Connect Cloud)

Use the CData Power BI Connector and CData Connect Cloud to integrate live Google Directory into custom reports in Power BI.

Create Freshdesk Dataflows on PowerBI.com

Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.

Connect to Redshift from Crystal Reports

Use CData Connect Cloud to connect to and report on live Amazon Redshift from Crystal Reports.

How to Work with Odoo in ETL Validator JDBC

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

Automate Microsoft Exchange Replication to SAP HANA

Use CData Sync to customize and automate Microsoft Exchange replication to SAP HANA.

Create Zoho Books-Connected Nintex Workflows

Use CData Connect Cloud to connect to Zoho Books from Nintex Workflow Cloud and build custom workflows using live Zoho Books.

Build MVC Applications with Connectivity to Bullhorn CRM

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

DataBind Wijmo Grid to FTP

Provide real-time FTP Servers to interactive controls.

How to Visualize SingleStore Data in Python with pandas

Use pandas and other modules to analyze and visualize live SingleStore in Python.

Replicate Harvest from PowerShell

Write a quick PowerShell script to query Harvest. Use connectivity to the live data to replicate Harvest to SQL Server.

Integrate with Google Spanner in JReport Designer

Create charts and reports based on Google Spanner in JReport Designer.

How to connect to Printful with Squirrel SQL client

Connect to Printful and execute queries in the Squirrel SQL Client.

Integrate SAP Business One into Automated Tasks with Power Automate

Use CData Connect Cloud to connect to SAP Business One and integrate live SAP Business One into your Power Automate tasks.

Access Access from MySQL in PHP

Connect to Access through the standard MySQL libraries in PHP.

Analyze Databricks in R via JDBC

Use standard R functions and the development environment of your choice to analyze Databricks with the CData JDBC Driver for Databricks.

Automated Continuous EventBrite Replication to Local Delimited Files

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

How to Access Live ActiveCampaign in Power Automate Desktop via ODBC

The CData ODBC Driver for ActiveCampaign enables you to integrate ActiveCampaign into workflows built using Microsoft Power Automate Desktop.

Create Dashboards and Visualize Live Microsoft Dataverse in Geckoboard

Use CData Connect Cloud to connect to live Microsoft Dataverse (CDS) and create dashboards for real-time monitoring and visualization in Geckoboard.

Replicate Wave Financial for Use in Salesforce Connect

Replicate Wave Financial to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

Build a PostgreSQL Interface for Pinterest using the CData JDBC Driver

Use the Remoting features of the Pinterest JDBC Driver to create a PostgreSQL entry-point for data access.

How to Query Live Google Sheets Data in Natural Language in Python using LlamaIndex

Use LlamaIndex to query live Google Sheets data in natural language using Python.

Configure the CData JDBC Driver for Jira Service Management in a Connection Pool in Tomcat

Connect to Atlassian Jira Service Management from a connection pool in Tomcat.

Automated Continuous OData Replication to Amazon Redshift

Use CData Sync for automated, continuous, customizable OData replication to Amazon Redshift.

Build a PostgreSQL Interface for Cloudant using the CData JDBC Driver

Use the Remoting features of the Cloudant JDBC Driver to create a PostgreSQL entry-point for data access.

Automate Workday Replication to Azure Synapse

Use CData Sync to customize and automate Workday replication to Azure Synapse.

Bridge Tableau CRM Analytics Connectivity with Apache NiFi

Access and process Tableau CRM Analytics in Apache NiFi using the CData JDBC Driver.

Create Apps from Microsoft Project in Qlik Sense Cloud

Use CData Connect Cloud to connect to Microsoft Project and build apps from live Microsoft Project in Qlik Sense Cloud.

How to Visualize Shopify Data in Python with pandas

Use pandas and other modules to analyze and visualize live Shopify in Python.

Automated Continuous Zoho Projects Replication to SQL Server

Use CData Sync for automated, continuous, customizable Zoho Projects replication to SQL Server.

Connect to Greenhouse as an External Source in Dremio

Use the CData JDBC Driver to connect to Greenhouse as an External Source in Dremio.

Create Amazon S3 Dashboards in Bold BI

Use CData Software Connect Server to create a virtual SQL Server Database for Amazon S3 to build custom dashboards in Bold BI.

Build Dashboards with JSON Services in DBxtra

Create dynamic dashboards and perform analytics based on JSON in DBxtra.

Amazon DynamoDB Reporting and Star Schemas in OBIEE

Create a star schema that shows perspectives on Amazon DynamoDB facts in real time.

Create Jira Dashboards in Bold BI

Use CData Software Connect Server to create a virtual SQL Server Database for Atlassian Jira to build custom dashboards in Bold BI.

Zoho Books Reporting in OBIEE with the Zoho Books JDBC Driver

Deploy the Zoho Books JDBC driver on OBIEE to provide real-time reporting across the enterprise.

Access Live Freshdesk in AWS Lambda (with IntelliJ IDEA)

Connect to live Freshdesk in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

Replicate SQL Server for Use in Salesforce Connect

Replicate Microsoft SQL Server to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

Connect to GraphQL from PowerBuilder via ODBC

This article demonstrates how to use the CData ODBC Driver for GraphQL to connect to GraphQL and execute queries in PowerBuilder.

Automated Continuous SingleStore Replication to Databricks

Use CData Sync for automated, continuous, customizable SingleStore replication to Databricks.

How to Query Salesforce Data Cloud in MySQL Workbench

Execute MySQL queries against live Salesforce Data Cloud from MySQL Workbench.

Connect to Exact Online from Asprova with CData Software ODBC Driver for Exact Online

This article shows how to connect faster to Exact Online data from Asprova.

Use the CData Software ODBC Driver for SendGrid in MicroStrategy

Connect to SendGrid in MicroStrategy Developer using the CData Software ODBC Driver for SendGrid.

Replicate Hive to Multiple Databases

Replicate Apache Hive to disparate databases with a point-and-click configuration.

Visualize Bullhorn CRM in TIBCO Spotfire through OData

Integrate Bullhorn CRM into dashboards in TIBCO Spotfire.

Working with Coinbase in LINQPad

Execute LINQ queries to Coinbase in LINQPad.

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.

Access Greenhouse 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 Greenhouse.

Connect to Azure Table in HULFT Integrate

Connect to Azure Table as a JDBC data source in HULFT Integrate

CData Software - Knowledge Base

Recent Articles