CData Software Knowledge Base

Use the CData Software JDBC Driver for Acumatica in MicroStrategy Web

Connect to Acumatica ERP in MicroStrategy Web using the CData Software JDBC Driver for Acumatica.

Connect to Oracle HCM Cloud in Google Apps Script via SQL Gateway

Use the ODBC Driver for Oracle HCM Cloud and the SQL Gateway to access Oracle HCM Cloud from Google Apps Script.

Access Excel Online as a Remote Oracle Database

Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Microsoft Excel Online from your Oracle system.

Create Dynamic Snowflake Grids Using the Infragistics XamDataGrid

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

Connect to Todoist in the Denodo Platform

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

Provide OData Services of SendGrid from a WCF Application

In this article, we will demonstrate the process of generating an OData feed for SendGrid by developing a WCF Service Application.

Connect to Backlog from Crystal Reports

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

Access MariaDB from MySQL in HeidiSQL

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

Automated Continuous Instagram Replication to Snowflake

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

Automate Impala Tasks in Power Automate Using CData API Server

With CData API Server, easily create OData endpoints for live Apache Impala and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.

Build Dashboards with Microsoft OneDrive in Dundas BI

Create dynamic dashboards and perform analytics based on Microsoft OneDrive in Dundas BI.

View Reports on Real-Time Hive in Power BI Report Server

Use the CData ODBC Driver for Hive to visualize Apache Hive in Power BI Desktop and then publish them to Power BI Report Server.

Visualize Live Twitter Ads in Tableau

Use CData Tableau Connectors and Tableau Desktop to visualize live Twitter Ads.

Query Dynamics 365 Business Central in DataGrip

Create a Data Source for Dynamics 365 Business Central in DataGrip and use SQL to query live Dynamics 365 Business Central.

How to connect PolyBase to Dynamics NAV

Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Microsoft Dynamics NAV.

Access Pinterest from MySQL in HeidiSQL

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

Integrate with Dynamics CRM in JReport Designer

Create charts and reports based on Microsoft Dynamics CRM in JReport Designer.

Connect to Zuora in DigitalSuite Studio through RunMyProcess DSEC

Use Arkobi Digital

Feed Dynamics CRM into FineReport

How to set Microsoft Dynamics CRM as a JDBC data source in FineReport.

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

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

Connect to Bitbucket in SpagoBI

Create reports featuring live Bitbucket in SpagoBI Studio. Host Bitbucket reports on SpagoBI Server.

Building Dynamic Web Pages with Instagram Using AngularJS

Create single-page applications with live connectivity to Instagram using the CData API Server.

Natively Connect to SAP Netweaver Gateway in PHP via ODBC (Linux)

Create PHP applications on Linux/UNIX machines with connectivity to SAP Netweaver Gateway. Leverage the native support for ODBC in PHP.

Analyze Freshdesk in Infragistics Reveal

Use CData Connect Cloud to create on OData API on top of Freshdesk and visualize live Freshdesk in Infragistics Reveal.

Working with PayPal in LINQPad

Execute LINQ queries to PayPal in LINQPad.

Connect to and Visualize Live Drip in Tableau Prep

Use CData Tableau Connectors and Tableau Prep Builder to visualize live Drip.

Automated Continuous Presto Replication to Amazon S3

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

Visualize Live Microsoft Dataverse in the Power BI Service

Use CData Connect Cloud to connect to live Microsoft Dataverse (CDS) and create custom reports in the Power BI Service through the On-Premises Gateway.

Create Apps from SendGrid in Qlik Sense Cloud

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

Consume QuickBooks OData Feeds in SAP Lumira

Use the API Server to create data visualizations on QuickBooks feeds that reflect any changes in SAP Lumira.

How to connect and process Apache Cassandra from Azure Databricks

Use CData, Azure, and Databricks to perform data engineering and data science on live Apache Cassandra.

How to Work with MarkLogic in ETL Validator JDBC

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

Build Charts with Sybase IQ in Clear Analytics

Create dynamic charts and perform analytics based on Sybase IQ in Clear Analytics.

Connect to Oracle from a Connection Pool in WebLogic

Use the CData JDBC Driver for Oracle to connect to Oracle Database from Web applications running on WebLogic.

How to publish and share Tally dashboards with Tableau Server

The CData ODBC driver for Tally enables you integrate Tally ERP into Tableau dashboards.

Build a PostgreSQL Interface for Sybase IQ using the CData JDBC Driver

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

Visualize Twitter from Tableau

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

Integrate with GitHub in JReport Designer

Create charts and reports based on GitHub in JReport Designer.

Access Live Paylocity in Excel (Desktop) via Connect Cloud

Use CData Connect Cloud to gain access to live Paylocity from your Excel spreadsheets.

Replicate Azure Blob Storage in Heroku for Use in Salesforce Connect

Replicate Azure Blob Storage to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

Visualize Live ConstantContact of Power BI Report Builder in Power BI Service

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

Automated Continuous SAP Replication to Apache Kafka

Use CData Sync for automated, continuous, customizable SAP replication to Apache Kafka.

Create Coinbase Reports on JasperReports Server

Deploy the CData JDBC Driver on JasperReports Server to provide real-time Coinbase data access from reports, embedded analytics, and more.

Integrate FHIR in Pentaho Data Integration

Build ETL pipelines based on FHIR in the Pentaho Data Integration tool.

How to create Dynamics 365 Business Central federated tables in MySQL

Use the SQL Gateway and the ODBC Driver to set up federated tables for Dynamics 365 Business Central in MySQL .

How to connect to Epicor Kinetic in DBVisualizer

Integrate Epicor Kinetic with visual data analysis tools and data connection wizards in DBVisualizer

Import and Visualize HubDB in Power View

Create data visualizations based on HubDB in Excel.

Automated Continuous SAP ByDesign Replication to Local Delimited Files

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

Build Semantic Layer Views for Redis in APOS Live Data Gateway

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

Use Biml to Build SSIS Tasks to Replicate Jira to SQL Server

Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Atlassian Jira to SQL Server.

Build Vault CRM-Connected Apps in Choreo

Use CData Connect Cloud to connect to Vault CRM from Choreo and build custom apps using live Veeva Vault & Vault CRM.

Explore Geographical Relationships in Klaviyo with Power Map

Create data visualizations with Klaviyo in Power Map.

How to Connect to Live Google Campaign Manager 360 in n8n Workflows and Agents (via CData Connect Cloud)

Leverage the CData Connect Cloud Remote MCP Server to enable n8n to securely read and take actions on your Google Campaign Manager 360 for you.

How to Work with Zendesk in AWS Glue Jobs Using JDBC

Connect to Zendesk from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

Use the CData Software ODBC Driver for Amazon DynamoDB in MicroStrategy Desktop

Connect to Amazon DynamoDB in MicroStrategy Desktop using the CData Software ODBC Driver for Amazon DynamoDB.

Visualize ServiceNow in Tableau

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

Visualize Live Wave Financial of Power BI Report Builder in Power BI Service

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

How to Work with Adobe Analytics in AWS Glue Jobs Using JDBC

Connect to Adobe Analytics from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

Query HBase in ColdFusion

Write standard ColdFusion data access code to connect to Apache HBase.

Create SSAS Tabular Models from YouTube Analytics

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

How to create Visio diagrams from Azure Table

Automatically update Azure Table Storage with the changes you make to Visio master shapes.

Query EventBrite from Node.js

Use the OData endpoint of the CData API Server to connect to your Eventbrite and perform CRUD operations on EventBrite from Node.js.

Create Reports with Coinbase in SAP Crystal Reports

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

Use the CData Software ODBC Driver for Coinbase in MicroStrategy

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

Use Dash to Build to Web Apps on Shippo

Create Python applications that use pandas and Dash to build Shippo-connected web apps.

HBase Reporting in OBIEE with the HBase JDBC Driver

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

How to create an RPA flow for LDAP Objects in UiPath Studio

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

Connect to SAP BusinessObjects BI as a SQL Server Linked Server

Use CData Connect Cloud to create a linked server for live SAP BusinessObjects BI.

Use the CData API Server in Microsoft Power BI

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

Connect to BigCommerce in Google Apps Script via SQL Gateway

Use the ODBC Driver for BigCommerce and the SQL Gateway to access BigCommerce from Google Apps Script.

Integrate Live Sage 200 into Custom Business Apps Built in Power Apps

Use CData Connect Cloud to connect to Sage 200 and integrate live Sage 200 into apps built in Microsoft Power Apps.

A PostgreSQL Interface for Office 365 using the CData ODBC Driver

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

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

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

How to publish and share Klaviyo dashboards with Tableau Server

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

Migrating data from Amazon S3 to Snowflake using CData SSIS Components.

Easily push Amazon S3 to Snowflake using the CData SSIS Tasks for Amazon S3 and Snowflake.

Connect to IBM Informix from Excel & GoogleSheets!

Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from IBM Informix, and over 250 other data sources, right inside your Excel and Google spreadsheets!

Replicate Sage 300 to Multiple Databases

Replicate Sage 300 to disparate databases with a point-and-click configuration.

Create an SAP BusinessObjects Universe on the CData JDBC Driver for Freshdesk

Provide connectivity to Freshdesk through an SAP BusinessObjects universe.

Create Dynamic Oracle Eloqua Grids Using the Infragistics XamDataGrid

Learn how you can connect Oracle Eloqua to Infragistics XamDataGrid to build dynamic grids.

Operational Reporting on OData Services from Spotfire Server

Create and share Spotfire data visualizations with real-time connectivity to remote OData.

Migrating data from Azure Data Lake Storage to Snowflake using CData SSIS Components.

Easily push Azure Data Lake Storage to Snowflake using the CData SSIS Tasks for Azure Data Lake Storage and Snowflake.

Automated Continuous Sage 300 Replication to Microsoft Access

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

Automated Continuous Instagram Replication to AlloyDB

Use CData Sync for automated, continuous, customizable Instagram replication to AlloyDB.

Automated Continuous LDAP Replication to SQLite

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

Automated Continuous Blackbaud FE NXT Replication to Apache Kafka

Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to Apache Kafka.

How to connect to XML in DBVisualizer

Integrate XML Files with visual data analysis tools and data connection wizards in DBVisualizer

Analyze Google Data Catalog in Slingshot with CData API Server

Use the CData API Server to build an OData API on top of Google Data Catalog and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.

How to create SAS xpt federated tables in MySQL

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

How to Access Live SendGrid in Visual Studio Code via Cline

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

Integrate Live AlloyDB into Amazon SageMaker Canvas with RDS

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

Connect to Trello in the Denodo Platform

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

Visualize Live Calendly in Tableau

Use CData Tableau Connectors and Tableau Desktop to visualize live Calendly.

CData Software - Knowledge Base

Recent Articles