Show articles by: Integration Technology | Driver Technology | Recent Articles

CData Software - Knowledge Base

Recent Articles

How to integrate Metabase with Cosmos DB

Use CData Connect Cloud to connect to live Azure Cosmos DB and create an interactive dashboard in Metabase from Azure Cosmos DB.
How to connect to GraphQL from MS Excel on Mac OS X

Create a Data Source Name in iODBC with the CData ODBC Driver for GraphQL and work with GraphQL in Microsoft Excel on Mac OS X.
How to connect to Clio from MS Excel on Mac OS X

Create a Data Source Name in iODBC with the CData ODBC Driver for Clio and work with Clio in Microsoft Excel on Mac OS X.
Automated Continuous Harvest Replication to Amazon Redshift

Use CData Sync for automated, continuous, customizable Harvest replication to Amazon Redshift.
How to Connect DBeaver to Printify via a JDBC Driver

Manage Printify with visual tools in DBeaver like the query browser.
Visualize Avro in Sisense

Create an ElastiCube in Sisense app with access to Apache Avro.
Object-Relational Mapping (ORM) with Monday.com Entities in Java

Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Monday.com into a Java-based ORM framework, Hibernate.
Integrate Live SAP ByDesign into Amazon SageMaker Canvas with RDS

Use CData Connect Cloud to connect to SAP ByDesign from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SAP Business ByDesign.
Viewing Typeform in RAD Studio Data Explorer

How to view Typeform in RAD Studio Data Explorer using the CData ODBC Driver for Typeform.
Manage SAP Business One in DBArtisan as a JDBC Source

Use wizards in DBArtisan to create a JDBC data source for SAP Business One.
Access Live Calendly in SAS JMP via ODBC

You can use the CData ODBC Driver to integrate Calendly into the statistical analysis tools available in SAS JMP. This article shows how to use Calendly in the Graph Builder and Query Builder.
Access FTP as a Remote Oracle Database

Use the Oracle ODBC Gateway and Heterogeneous Services technology to access FTP Servers from your Oracle system.
Automated Continuous Cassandra Replication to Microsoft Access

Use CData Sync for automated, continuous, customizable Cassandra replication to Microsoft Access.
Build Automated Excel Online-Connected Workflows in Zapier

Use CData Connect Cloud to connect to live Microsoft Excel Online and build automated workflows in Zapier.
Author and Share Power BI Reports on Real-Time QuickBooks Time

Use the CData ODBC Driver for QuickBooks Time to visualize QuickBooks Time in Power BI Desktop and then upload to the Power BI service.
Automated Continuous PayPal Replication to SQL Server

Use CData Sync for automated, continuous, customizable PayPal replication to SQL Server.
Automate SAP Concur Replication to Couchbase

Use CData Sync to Customize and automate SAP Concur replication to Couchbase.
Automated Continuous Zenefits Replication to Google Cloud SQL

Use CData Sync for automated, continuous, customizable Zenefits replication to Google Cloud SQL.
Automated Continuous Bullhorn CRM Replication to Local Delimited Files

Use CData Sync for automated, continuous, customizable Bullhorn CRM replication to delimited files (CSV/TSV).
How to connect Amazon QuickSight to API

Create a connection to API in CData Connect Cloud and insert API into Amazon QuickSight SPICE to build interactive dashboards.
Build Cosmos DB-Connected Web Apps with Axios and CData Connect Cloud

Use CData Connect Cloud to connect to live Azure Cosmos DB and build Cosmos DB-connected web apps with Axios.
Feed BigCommerce into FineReport

How to set BigCommerce as a JDBC data source in FineReport.
DataBind Charts to HDFS

Use the standard ADO.NET procedures for databinding to provide bidirectional access to Apache HDFS from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
A PostgreSQL Interface for Invoiced (MySQL Remoting via JDBC)

Use the Remoting features of the Invoiced JDBC Driver to create a PostgreSQL entry-point for data access.
Automated Continuous Databricks Replication to MongoDB

Use CData Sync for automated, continuous, customizable Databricks replication to MongoDB.
Create Reports with SAS xpt in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date SAS XPORT.
Connect to Live Salesforce in MicroStrategy through CData Connect Cloud

Create a live connection to Salesforce in CData Connect Cloud and connect to your Salesforce & Force.com from MicroStrategy.
Provide OData Services of Raisers Edge NXT from a WCF Application

In this article, we will demonstrate the process of generating an OData feed for Raisers Edge NXT by developing a WCF Service Application.
Connect to SAS xpt in Ruby

Connect to SAS XPORT in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
Integrate with Unbounce using Apache Camel2

Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Unbounce to a JSON file on disk.
How to Build an ETL App for MailChimp in Python with CData

Create ETL applications and real-time data pipelines for MailChimp in Python with petl.
Use the CData Software ODBC Driver for Parquet in MicroStrategy

Connect to Apache Parquet in MicroStrategy Developer using the CData Software ODBC Driver for Parquet.
Access Live Authorize.Net in Coginiti Pro

Connect to and query live Authorize.Net from the GUI in the Coginiti Pro: SQL Analytics Tool.
Build Oracle Service Cloud-Connected Web Apps with Axios and CData Connect Cloud

Use CData Connect Cloud to connect to live Oracle Service Cloud and build Oracle Service Cloud-connected web apps with Axios.
Query Dynamics CRM in ColdFusion

Write standard ColdFusion data access code to connect to Microsoft Dynamics CRM.
How to Access WordPress Using Entity Framework

This article shows how to access WordPress using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
Access Greenhouse as a Remote Oracle Database

Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Greenhouse from your Oracle system.
Build Act CRM-Connected Apps in Mendix

Use CData Connect Cloud to create an OData feed for Act CRM and create custom apps in Mendix.
How to connect PolyBase to GraphQL

Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live GraphQL.
Query, Visualize, and Share live OneNote in Redash

Use CData Connect Cloud to connect to live Microsoft OneNote in Redash for querying, visualizing, and sharing.
Explore Geographical Relationships in Kintone with Power Map

Create data visualizations with Kintone in Power Map.
Visualize Live SAS xpt in the Power BI Service

Use CData Software Connect Server to create a virtual SQL Server database for SAS XPORT and create custom reports in the Power BI Service.
Connect to and Query Sage 50 UK in QlikView over ODBC

Create data visualizations with Sage 50 UK in QlikView.
How to connect to SQL Analysis Services from MS Excel on Mac OS X

Create a Data Source Name in iODBC with the CData ODBC Driver for SQL Analysis Services and work with SQL Analysis Services in Microsoft Excel on Mac OS X.
Replicate Reckon Accounts Hosted to Multiple Databases via the CData Sync CLI

Replicate Reckon Accounts Hosted to disparate databases with a single configuration.
DataBind Wijmo Grid to Impala

Provide real-time Apache Impala to interactive controls.
Build Automated Smartsheet-Connected Workflows in Zapier

Use CData Connect Cloud to connect to live Smartsheet and build automated workflows in Zapier.
Analyze Live Couchbase in SAS Viya

Use CData Connect Cloud to connect to Couchbase from SAS Viya and deploy self-service analytics using live Couchbase.
Integrate with Live Oracle Financials Cloud in MuleSoft (via CData Connect Cloud)

Use CData Connect Cloud to connect to Oracle Financials Cloud from the MuleSoft Anypoint Platform to integrate live Oracle Financials Cloud into custom reports and dashboards.
Analyze Spark in R via JDBC

Use standard R functions and the development environment of your choice to analyze Apache Spark SQL with the CData JDBC Driver for Spark.
Integrate Real-Time Access to eBay Analytics in SAPUI5 MVC Apps

Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to eBay Analytics in real time.
Build eBay-Connected Web Apps with Axios and CData Connect Cloud

Use CData Connect Cloud to connect to live eBay and build eBay-connected web apps with Axios.
Access Google Spanner from MySQL in PHP

Connect to Google Spanner through the standard MySQL libraries in PHP.
How to connect to Clio from IntelliJ

Integrate connectivity to Clio with wizards in IntelliJ.
Feed Sybase into FineReport

How to set Sybase as a JDBC data source in FineReport.
Visualize Monday.com in Tableau

The CData ODBC driver for Monday.com enables you integrate Monday.com into Tableau dashboards.
Analyze Todoist with Power Pivot

This article walks you through the process of using the CData ODBC Driver for Todoist from Power Pivot. You will use the Table Import Wizard to load Todoist. You can visually build the import query or use any SQL supported by the driver.
Import Real-Time ADP via JDBC in ColdFusion to Build Applications

Use CData JDBC drivers to import and use ADP in ColdFusion.
Excel Spreadsheet Automation on Smartsheet with the QUERY Formula

Pull data, automate spreadsheets, and more with the QUERY formula.
Automated Continuous Google Campaign Manager 360 Replication to Oracle

Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to Oracle.
Connect to LinkedIn Ads from AWS Glue

Use CData Connect Cloud to gain access to live LinkedIn Ads from your AWS Glue jobs.
Automated Continuous Tally Replication to Apache Cassandra

Use CData Sync for automated, continuous, customizable Tally replication to Apache Cassandra.
Build Visualizations of SQL Analysis Services in Birst

Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SQL Analysis Services in Birst.
Integrate Real-Time Access to Salesforce Marketing in SAPUI5 MVC Apps

Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Salesforce Marketing Cloud in real time.
Deploy the ADO.NET Provider for Highrise on an SSRS Report Server

Connect to Highrise CRM 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.
Automated Continuous Microsoft Exchange Replication to Azure SQL

Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to Azure SQL.
Replicate Google Ads from PowerShell

Write a quick PowerShell script to query Google Ads. Use connectivity to the live data to replicate Google Ads to SQL Server.
Automated Continuous MariaDB Replication to Google BigQuery

Use CData Sync for automated, continuous, customizable MariaDB replication to Google BigQuery.
Connect to and Query Zuora in QlikView over ODBC

Create data visualizations with Zuora in QlikView.
Automated Continuous Microsoft Project Replication to SQLite

Use CData Sync for automated, continuous, customizable Microsoft Project replication to SQLite.
Create Dynamic Adobe Commerce Grids Using the Infragistics XamDataGrid

Learn how you can connect Adobe Commerce to Infragistics XamDataGrid to build dynamic grids.
Use the CData ODBC Driver for SAP HANA from SharePoint Excel Services

This article demonstrates how to use the CData ODBC Driver for SAP HANA to connect to SAP HANA from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SAP HANA in Excel.
Automated Continuous WordPress Replication to Amazon S3

Use CData Sync for automated, continuous, customizable WordPress replication to Amazon S3.
Create Datasets from Sybase IQ in Domo Workbench and Build Visualizations of Sybase IQ in Domo

Use the CData Software ODBC Driver for Sybase IQ to create datasets from Sybase IQ in Domo Workbench and then build visualizations in the Domo service.
Build Data Flows from SurveyMonkey to SQL Server using SSIS

Easily back up SurveyMonkey to SQL Server using the SSIS components for SurveyMonkey.
Connect to and Query IBM Cloud Data Engine in QlikView over ODBC

Create data visualizations with IBM Cloud Data Engine in QlikView.
Automated Continuous Reckon Replication to SQL Server

Use CData Sync for automated, continuous, customizable Reckon replication to SQL Server.
Excel Spreadsheet Automation on HCL Domino with the QUERY Formula

Pull data, automate spreadsheets, and more with the QUERY formula.
Build Data Flows from SQL Server to Dynamics CRM through SSIS

Easily push SQL Server data to Dynamics CRM using the CData SSIS Tasks for Dynamics CRM.
Use the CData Software ODBC Driver for Acumatica in MicroStrategy

Connect to Acumatica ERP in MicroStrategy Developer using the CData Software ODBC Driver for Acumatica.
Create Reports with Jira Service Management in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Atlassian Jira Service Management.
Integrate with Azure Table using Apache Camel2

Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Azure Table Storage to a JSON file on disk.
Create Datasets from eBay Analytics in Domo Workbench and Build Visualizations of eBay Analytics in Domo

Use the CData Software ODBC Driver for eBay Analytics to create datasets from eBay Analytics in Domo Workbench and then build visualizations in the Domo service.
Automated Continuous BambooHR Replication to Apache Kafka

Use CData Sync for automated, continuous, customizable BambooHR replication to Apache Kafka.
Operational Reporting on Salesforce Data Cloud from Spotfire Server

Create and share Spotfire data visualizations with real-time connectivity to remote Salesforce Data Cloud.
Edit and Search External HubSpot Objects in Salesforce Connect

Use CData Connect Cloud to securely provide OData feeds of HubSpot to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create HubSpot objects that you can access from apps and the dashboard.
How to import Greenplum into Apache Solr

Use the CData Software JDBC Driver for Greenplum in Data Import Handler and create an automated import of Pivotal GreenPlum to Apache Solr Enterprise Search platform.
Provide OData Services of WooCommerce from a WCF Application

In this article, we will demonstrate the process of generating an OData feed for WooCommerce by developing a WCF Service Application.
Replicate Multiple Oracle SCM Accounts

Replicate multiple Oracle SCM accounts to one or many databases.
Analyze API in Infragistics Reveal

Use CData Connect Cloud to create on OData API on top of API and visualize live API in Infragistics Reveal.
Import Real-Time Aha via JDBC in ColdFusion to Build Applications

Use CData JDBC drivers to import and use Aha! in ColdFusion.
Create Datasets from Adobe Commerce in Domo Workbench and Build Visualizations of Adobe Commerce in Domo

Use the CData Software ODBC Driver for Adobe Commerce to create datasets from Adobe Commerce in Domo Workbench and then build visualizations in the Domo service.
Connect to Slack in Google Apps Script via Connect Cloud

Use CData Connect Cloud to access Slack in Google Apps Script.
Build Dashboards with Zenefits in Dundas BI

Create dynamic dashboards and perform analytics based on Zenefits in Dundas BI.
Automate SAP HANA XS Advanced Replication to Azure Data Lake

Use CData Sync to customize and automate SAP HANA XS Advanced replication to Azure Data Lake.
Query Avro through ODBC in Node.js

Use node-odbc to execute SQL queries against Apache Avro from Node.js.
How to connect and process PayPal from Azure Databricks

Use CData, Azure, and Databricks to perform data engineering and data science on live PayPal
Process & Analyze Google Directory in Databricks (AWS)

Use CData, AWS, and Databricks to perform data engineering and data science on live Google Directory .
Automated Continuous Power BI XMLA Replication to Google BigQuery

Use CData Sync for automated, continuous, customizable Power BI XMLA replication to Google BigQuery.
Connect to SendGrid from Asprova with CData Software ODBC Driver for SendGrid

This article shows how to connect faster to SendGrid data from Asprova.