CData Software Knowledge Base

Automated Continuous IBM Cloud Data Engine Replication to Azure SQL

Use CData Sync for automated, continuous, customizable IBM Cloud Data Engine replication to Azure SQL.

Feed Redshift into FineReport

How to set Amazon Redshift as a JDBC data source in FineReport.

Natively Connect to Tableau CRM Analytics in PHP via ODBC (Linux)

Create PHP applications on Linux/UNIX machines with connectivity to Tableau CRM Analytics. Leverage the native support for ODBC in PHP.

How to Visualize Microsoft Dataverse Data in Python with pandas

Use pandas and other modules to analyze and visualize live Microsoft Dataverse (CDS) in Python.

Use CData Connect Cloud to Access Snowflake in Microsoft Power Pivot

Use CData Connect Cloud to connect to live Snowflake in the Power Pivot business intelligence tool.

Access JSON Services from MySQL in PHP

Connect to JSON through the standard MySQL libraries in PHP.

Connect to EventBrite in DigitalSuite Studio through RunMyProcess DSEC

Use Arkobi Digital

Rapidly Develop QuickBooks Online-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.

Create Data Visualizations in Cognos BI with SAP Ariba Source

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

DataBind Controls to Authorize.Net in C++Builder

DataBind to Authorize.Net in C++Builder with standard components and controls.

Bridge ShipStation Connectivity with Apache NiFi

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

Visualize Live Google Search Results of Power BI Report Builder in Power BI Service

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

Use Dash to Build to Web Apps on SAP Fieldglass

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

Import Cosmos DB into FileMaker Pro

Create reports that integrate Azure Cosmos DB in Filemaker Pro.

Visualize SAP Concur in TIBCO Spotfire through OData

Integrate SAP Concur into dashboards in TIBCO Spotfire.

How to publish and share Excel Online dashboards with Tableau Server

The CData ODBC driver for Excel Online enables you integrate Microsoft Excel Online into Tableau dashboards.

Connect to and Query Snowflake in QlikView over ODBC

Create data visualizations with Snowflake in QlikView.

Use the CData Software ODBC Driver for QuickBooks in MicroStrategy Desktop

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

Create Bullhorn CRM-Connected Visualizations in Klipfolio

Use CData Connect Cloud to connect to Bullhorn CRM from Klipfolio and build custom visualizations using live Bullhorn CRM.

Use Biml to Build SSIS Tasks to Replicate SAP Fieldglass to SQL Server

Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAP Fieldglass to SQL Server.

Automated Continuous Oracle HCM Cloud Replication to Oracle

Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to Oracle.

Access Live REST in Coginiti Pro

Connect to and query live REST from the GUI in the Coginiti Pro: SQL Analytics Tool.

Access Live Blackbaud FE NXT in Excel (Desktop) via Connect Cloud

Use CData Connect Cloud to gain access to live Blackbaud FE NXT from your Excel spreadsheets.

How to pipe SAP HANA to CSV in PowerShell

Use standard PowerShell cmdlets to access SAP HANA tables.

How to Work with Trello in ETL Validator JDBC

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

Bidirectional Access to Hive from FileMaker Pro

Use the MySQL Remoting feature of the JDBC driver to integrate Apache Hive in Filemaker Pro for Mac or Windows.

How to Connect to & Open HDFS in Microsoft Excel

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

Create Datasets from Procore in Domo Workbench and Build Visualizations of Procore in Domo

Use the CData Software ODBC Driver for Procore to create datasets from Procore in Domo Workbench and then build visualizations in the Domo service.

How to integrate SFTP with Apache Airflow

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

Automate Bing Ads Replication to SAP HANA

Use CData Sync to customize and automate Bing Ads replication to SAP HANA.

Create Datasets from Xero in Domo Workbench and Build Visualizations of Xero in Domo

Use the CData Software ODBC Driver for Xero to create datasets from Xero Accounting in Domo Workbench and then build visualizations in the Domo service.

Access MYOB AccountRight from MySQL in Amazon QuickSight

Connect to MYOB AccountRight and build visualizations of MYOB AccountRight using a MySQL Connection in Amazon QuickSight.

Integrate Live Acumatica into Amazon SageMaker Canvas with RDS

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

How to import EventBrite into Apache Solr

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

Salesloft Reporting and Star Schemas in OBIEE

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

How to Connect DBeaver to Cvent via a JDBC Driver

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

Viewing JotForm in RAD Studio Data Explorer

How to view JotForm in RAD Studio Data Explorer using the CData ODBC Driver for JotForm.

How to publish and share GraphQL dashboards with Tableau Server

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

Integrate with live Smaregi in Jitterbit

Use CData Connect Cloud to connect to and integrate live Smaregi in Jitterbit.

Build Semantic Layer Views for GraphQL in APOS Live Data Gateway

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

How to connect Amazon QuickSight to Asana

Create a connection to Asana in CData Connect Cloud and insert Asana into Amazon QuickSight SPICE to build interactive dashboards.

Connect to Hive in NetBeans

Connect to Apache Hive in NetBeans with the data source configuration wizard.

Google Calendar Reporting and Star Schemas in OBIEE

Create a star schema that shows perspectives on Google Calendar facts in real time.

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

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

Integrate Phoenix into Automated Tasks with Power Automate

Use CData Software Connect Server to create a virtual SQL Server database for Apache Phoenix and integrate live Apache Phoenix into your Power Automate (Microsoft Flow) tasks.

Connect to RSS Feeds as a Linked Server via SQL Gateway

Use the SQL Gateway and the ODBC Driver to set up a linked server for RSS Feeds.

Natively Connect to CouchDB in PHP

The CData ODBC driver for CouchDB enables you to create PHP applications with connectivity to Apache CouchDB. Leverage the native support for ODBC in PHP.

Connect to and Query Live Salesforce Data in QlikView (vina ODBC)

Create data visualizations with Salesforce data in QlikView.

Automate Amazon Athena Replication to Azure Data Lake

Use CData Sync to customize and automate Amazon Athena replication to Azure Data Lake.

How to create Visio diagrams from WooCommerce

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

Build Apps with Live Monday.com in Adalo using CData Connect Cloud

Use CData Connect Cloud to integrate live Monday.com into the Adalo platform and build custom mobile and web applications with real-time Monday.com.

Analyze Oracle Sales in SAP Analytics Cloud

Use CData Connect Cloud to create an OData API on top of Oracle Sales and visualize Oracle Sales in SAP Analytics Cloud.

Build Invoiced-Connected ETL Processes in Google Data Fusion

Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Invoiced.

Prepare, Blend, and Analyze Zendesk in Alteryx Designer (ODBC)

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

Excel Spreadsheet Automation on Airtable with the QUERY Formula

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

How to Build an ETL App for Highrise in Python with CData

Create ETL applications and real-time data pipelines for Highrise CRM in Python with petl.

How to pipe SAP HANA XS Advanced to CSV in PowerShell

Use standard PowerShell cmdlets to access SAP HANA XS Advanced tables.

Build a PostgreSQL Interface for LDAP Objects using the CData JDBC Driver

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

Visualize Quickbase in TIBCO Spotfire through ODBC

The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Quickbase into TIBCO Spotfire.

Access Live Stripe in AWS Lambda (with IntelliJ IDEA)

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

Feed ActiveCampaign into FineReport

How to set ActiveCampaign as a JDBC data source in FineReport.

Connect to Sybase in HULFT Integrate

Connect to Sybase as a JDBC data source in HULFT Integrate

Connect to OData Services in Google Apps Script via SQL Gateway

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

Import Real-Time Azure Analysis Services via JDBC in ColdFusion to Build Applications

Use CData JDBC drivers to import and use Azure Analysis Services in ColdFusion.

Connect to Yahoo! Ads in RunMyProcess through Connect Cloud

Use CData Connect Cloud to create on OData API for Yahoo! Ads and connect to Yahoo! Ads in Akorbi Digital RunMyProcess.

How to Connect to Sage Cloud Accounting in Using Python: 6 Steps

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

Build Dashboards with HubDB in Dundas BI

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

Connect to Zendesk in JRuby

Create a simple JRuby app with access to live Zendesk.

Use the Connect Server to Access eBay Analytics in Microsoft Power Pivot

Use the Connect Server to connect to live eBay Analytics in the Power Pivot business intelligence tool.

Replicate SAS xpt to Multiple Databases

Replicate SAS XPORT to disparate databases with a point-and-click configuration.

Integrate Presto in the Pentaho Report Designer

Publish reports based on Presto in the Pentaho BI tool.

How to Work with JSON Services in ETL Validator JDBC

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

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

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

Build Adobe Commerce-Connected Apps in Choreo

Use CData Connect Cloud to connect to Adobe Commerce from Choreo and build custom apps using live Adobe Commerce.

Create SAP HANA-Connected Dashboards in Grafana

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

Build Splunk-Connected Visualizations in datapine

Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Splunk.

Visualize ActiveCampaign in Sisense

Create an ElastiCube in Sisense app with access to ActiveCampaign.

Create Reports with Zoho Projects in SAP Crystal Reports

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

Bidirectional Access to Certinia from FileMaker Pro

Use the MySQL Remoting feature of the JDBC driver to integrate Certinia in Filemaker Pro for Mac or Windows.

Build MongoDB-Connected Web Apps with Axios and CData Connect Cloud

Use CData Connect Cloud to connect to live MongoDB and build MongoDB-connected web apps with Axios.

PowerShell Scripting to Replicate Cvent to MySQL

Write a simple PowerShell script to replicate Cvent to a MySQL database.

Connect to Google Drive from a Connection Pool in WebLogic

Use the CData JDBC Driver for Google Drive to connect to Google Drive from Web applications running on WebLogic.

Work with MarkLogic in FoxPro

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

Natively Connect to CockroachDB in PHP

The CData ODBC driver for CockroachDB enables you to create PHP applications with connectivity to CockroachDB. Leverage the native support for ODBC in PHP.

How to Connect to Snapchat Ads in Using Python: 6 Steps

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

Connect to Confluence from Crystal Reports

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

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

Connect to Shippo from a connection pool in Tomcat.

Analyze Confluence in SAP Analytics Cloud

Use CData Connect Cloud to create an OData API on top of Atlassian Confluence and visualize Atlassian Confluence in SAP Analytics Cloud.

Automated Continuous Paylocity Replication to Microsoft Access

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

Access ClickUp from MySQL in HeidiSQL

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

Integrate with Drift in JReport Designer

Create charts and reports based on Drift in JReport Designer.

Automate Sugar CRM Replication to Azure Data Lake

Use CData Sync to customize and automate Sugar CRM replication to Azure Data Lake.

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

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

LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Phoenix Data Provider.

CData Software - Knowledge Base

Recent Articles