CData Software Knowledge Base

Connect to Quickbase in RazorSQL

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

Import Oracle Using Azure Data Factory

Use CData Connect Cloud to connect to Oracle from Azure Data Factory and import live Oracle Database.

Connect and Visualize Live AlloyDB Data in Databricks Lakehouse Federation with CData Connect Cloud

Use CData Connect Cloud to integrate live Google AlloyDB into the Databricks platform and create visualization dashboards with real-time Google AlloyDB.

Connect to Kintone from PowerBuilder via ADO.NET

This article demonstrates how to access Kintone from Appeon PowerBuilder using the CData ADO.NET Provider for Kintone.

Publish Reports with Box in SAP Crystal Reports

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

Connect to BigCommerce in HULFT Integrate

Connect to BigCommerce as a JDBC data source in HULFT Integrate

PowerShell Scripting to Replicate Azure Data Lake Storage to MySQL

Write a simple PowerShell script to replicate Azure Data Lake Storage to a MySQL database.

Bridge LinkedIn Ads Connectivity with Apache NiFi

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

Create a Data Access Object for CouchDB using JDBI

A brief overview of creating a SQL Object API for Apache CouchDB in JDBI.

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

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

Connect to Live Azure Table in PostGresSQL Interface through CData Connect Cloud

Create a live connection to Azure Table in CData Connect Cloud and connect to your Azure Table Storage from PostgreSQL.

How to import Dynamics 365 Business Central into Apache Solr

Use the CData Software JDBC Driver for Dynamics 365 Business Central in Data Import Handler and create an automated import of Dynamics 365 Business Central to Apache Solr Enterprise Search platform.

Use the CData API Server in Microsoft Power BI

You can use the CData API Server to feed Apache HDFS to Power BI dashboards. Simply drag and drop Apache HDFS into data visuals on the Power BI canvas.

Automated Continuous Trello Replication to Amazon Redshift

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

How to Create Power BI Visual Reports with Real-Time Klaviyo

Use CData Power BI Connectors to visualize Klaviyo in Power BI.

Visualize Avro from Tableau

Use the Tableau Desktop business intelligence tool to connect to Apache Avro.

Create a Data Access Object for Amazon DynamoDB using JDBI

A brief overview of creating a SQL Object API for Amazon DynamoDB in JDBI.

Perform Batch Operations with Active Directory in Apache NiFi

Connect to Active Directory and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

Process & Analyze Jira Service Management in Databricks (AWS)

Use CData, AWS, and Databricks to perform data engineering and data science on live Jira Service Management .

Working with Zoho Creator in LINQPad

Execute LINQ queries to Zoho Creator in LINQPad.

Connect to Microsoft Planner as an External Source in Dremio

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

Connect to Typeform from a Connection Pool in JBoss

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

Stream Tableau CRM Analytics into Apache Kafka Topics

Access and stream Tableau CRM Analytics in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

Access Live Zoho Books in AWS Lambda (with IntelliJ IDEA)

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

Create SAP Ariba Source-Connected Visualizations in Klipfolio

Use CData Connect Cloud to connect to SAP Ariba Source from Klipfolio and build custom visualizations using live SAP Ariba Source.

How to create an RPA flow for Zoho Creator in UiPath Studio

Use the Zoho Creator ODBC Driver to create workflows that access real-time Zoho Creator without any coding.

Connect to MariaDB through External Services in Salesforce

Use CData Connect Cloud to securely connect Salesforce External Services with MariaDB using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

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

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

Validate Zoom with QuerySurge

Access and validate Zoom in QuerySurge using the CData JDBC Driver.

Automated Continuous Box Replication to SQL Server

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

Connect to RSS Feeds in Ruby

Connect to RSS Feeds in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

Publish Reports with Shippo in SAP Crystal Reports

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

How to Access Live Jira Service Management in Visual Studio Code via Cline

Run the CData MCP Server for Jira Service Management on Windows Subsytem for Linux (WSL) and connect to live Atlassian Jira Service Management from the Cline extension in Visual Studio Code.

Connect to SAP ByDesign in DBeaver

Use the CData ODBC Driver to connect to SAP Business ByDesign in DBeaver.

Access Live Microsoft Project in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

Connect to Microsoft Project from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

Access Monday.com from MySQL in Amazon QuickSight

Connect to Monday.com and build visualizations of Monday.com using a MySQL Connection in Amazon QuickSight.

Creating Salesforce-Connected Applications in Unqork

You can use CData Connect Cloud to feed Salesforce & Force.com to Unqork and build custom business apps.

Deploy the ADO.NET Provider for Tableau CRM Analytics on an SSRS Report Server

Connect to Tableau CRM Analytics from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

Connect to Jira Service Management from PowerBuilder via ADO.NET

This article demonstrates how to access Atlassian Jira Service Management from Appeon PowerBuilder using the CData ADO.NET Provider for Jira Service Management.

Access Live Certinia Data in Tableau with CData API Server

With CData API Server, easily create OData endpoints for live Certinia data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.

Create Square Dataflows on PowerBI.com

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

Use the CData Software JDBC Driver for TaxJar in MicroStrategy Desktop

Connect to TaxJar in MicroStrategy Desktop using the CData Software JDBC Driver for TaxJar.

Query Dynamics 365 as a SQL Server Database in Node.js

Execute SQL Server queries against Microsoft Dynamics 365 from Node.js.

Build SAP ByDesign-Connected Dashboards Using Zoho Analytics

Use CData Connect Cloud to connect to SAP ByDesign from Zoho Analytics and import live SAP Business ByDesign.

Automated Continuous MongoDB Replication to SQLite

Use CData Sync for automated, continuous, customizable MongoDB replication to SQLite.

Process & Analyze FTP in Databricks (AWS)

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

Create Reports from Active Directory in Looker Studio

Use CData Connect Cloud to gain access to live Active Directory and create custom reports in Looker Studio.

How to Access Live Harvest in Power Automate Desktop via ODBC

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

Publish Crystal Reports on Snowflake

Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Snowflake.

How to Access Live Redshift in Visual Studio Code via Cline

Run the CData MCP Server for Redshift on Windows Subsytem for Linux (WSL) and connect to live Amazon Redshift from the Cline extension in Visual Studio Code.

Build Freshdesk Visualizations in Tableau Desktop

Use CData Connect Cloud to connect to live Freshdesk and build visualizations in Tableau.

Enable the Google Spanner JDBC Driver in KNIME

Use standard data access components in KNIME to create charts and reports with Google Spanner.

Automated Continuous Google Directory Replication to Apache Cassandra

Use CData Sync for automated, continuous, customizable Google Directory replication to Apache Cassandra.

Connect to OData Services in RazorSQL

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

Analyze IBM Informix in Cognos Analytics

Use CData Connect Cloud to connect to IBM Informix from Cognos Analytics and analyze live IBM Informix.

How to Connect DBeaver to Google Data Catalog via a JDBC Driver

Manage Google Data Catalog with visual tools in DBeaver like the query browser.

How to integrate Sybase IQ with Apache Airflow

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

Visualize SharePoint Excel Services in TIBCO Spotfire through OData

Integrate SharePoint Excel Services into dashboards in TIBCO Spotfire.

Load Power BI XMLA to a Database Using Embulk

Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Power BI XMLA to a database.

How to Connect the Power BI Service to Dropbox: Complete Guide

Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.

How to Connect DBeaver to CockroachDB via a JDBC Driver

Manage CockroachDB with visual tools in DBeaver like the query browser.

Build Google Contacts-Connected Apps in Mendix

Use CData Connect Cloud to create an OData feed for Google Contacts and create custom apps in Mendix.

Access Twitter Ads as a Remote Oracle Database

Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Twitter Ads from your Oracle system.

CData Software - Knowledge Base

Recent Articles