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

CData Software - Knowledge Base

Recent Articles

Connect to Live MongoDB in MicroStrategy through CData Connect Cloud

Create a live connection to MongoDB in CData Connect Cloud and connect to your MongoDB from MicroStrategy.
Consume SAP SuccessFactors OData Feeds in PowerBuilder

This article demonstrates how to consume SAP SuccessFactors as OData feeds from PowerBuilder using the API Server.
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Google Spanner

Provide connectivity to Google Spanner through an SAP BusinessObjects universe.
How to connect to Dynamics 365 from IntelliJ

Integrate connectivity to Microsoft Dynamics 365 with wizards in IntelliJ.
Replicate HBase for Use in Salesforce Connect

Replicate Apache HBase to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
Connect and Visualize Live QuickBooks Time Data in Databricks Lakehouse Federation with CData Connect Cloud

Use CData Connect Cloud to integrate live QuickBooks Time into the Databricks platform and create visualization dashboards with real-time QuickBooks Time.
Integrate Live Avalara AvaTax into Custom Business Apps Built in Power Apps

Use CData Connect Cloud to connect to Avalara AvaTax and integrate live Avalara AvaTax into apps built in Microsoft Power Apps.
Access Live SAP Ariba Procurement in Excel (Desktop) through Connect Spreadsheets

Use Connect Spreadsheets by CData to gain access to live SAP Ariba Procurement from your Excel spreadsheets.
Build Pipelines with Live Sage Cloud Accounting in Google Cloud Data Fusion (via CData Connect Cloud)

Use CData Connect Cloud to connect to Sage Cloud Accounting from Google Cloud Data Fusion, enabling the integration of live Sage Business Cloud Accounting into the building and management of effective data pipelines.
Work with Power BI XMLA in FoxPro

Load Power BI XMLA into a FoxPro database. This article includes full code and a walk-through of the process.
Build Workday-Connected Apps in Bubble

Use CData Connect Cloud to create an OData feed for Workday and create custom apps in Bubble.
Process & Analyze Elasticsearch in Databricks (AWS)

Use CData, AWS, and Databricks to perform data engineering and data science on live Elasticsearch .
Object-Relational Mapping (ORM) with SAP Ariba Source 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 SAP Ariba Source into a Java-based ORM framework, Hibernate.
Choosing the Best Method to Connect OData to SQL Server: 5 Options Explained

Discover multiple ways to connect and use OData from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
Deploy the ADO.NET Provider for ClickUp on an SSRS Report Server

Connect to ClickUp 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.
Build an OLAP Cube in SSAS from XML

Establish a connection to XML Files data from SQL Server Analysis Services, and use the XML Data Provider to build OLAP cubes for use in analytics and reporting.
Use the CData Software ODBC Driver for Oracle Financials Cloud in SAS for Real-Time Reporting and Analytics

Connect to real-time Oracle Financials Cloud in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Oracle Financials Cloud.
Automated Continuous BambooHR Replication to AlloyDB

Use CData Sync for automated, continuous, customizable BambooHR replication to AlloyDB.
Create Dashboards and Visualize Live GraphQL in Geckoboard

Use CData Connect Cloud to connect to live GraphQL and create dashboards for real-time monitoring and visualization in Geckoboard.
Create SSAS Tabular Models from Microsoft Exchange

How to build a SQL Server Analysis Service Tabular Model from Microsoft Exchange using CData drivers.
How to pipe Google Drive to CSV in PowerShell

Use standard PowerShell cmdlets to access Google Drive tables.
How to create Visio diagrams from MailChimp

Automatically update MailChimp with the changes you make to Visio master shapes.
Query HCL Domino as a SQL Server Database in Node.js

Execute SQL Server queries against HCL Domino from Node.js.
Access Live Highrise in SAS JMP via ODBC

You can use the CData ODBC Driver to integrate Highrise CRM into the statistical analysis tools available in SAS JMP. This article shows how to use Highrise CRM in the Graph Builder and Query Builder.
Integrate JDBC-ODBC Bridge with External Services using SnapLogic

Use CData JDBC drivers in SnapLogic to integrate JDBC-ODBC Bridge with External Services.
Create Datasets from Shopify in Domo Workbench and Build Visualizations of Shopify in Domo

Use the CData Software ODBC Driver for Shopify to create datasets from Shopify in Domo Workbench and then build visualizations in the Domo service.
Connect to and Query SAP Ariba Source in QlikView over ODBC

Create data visualizations with SAP Ariba Source in QlikView.
Using CData ODBC Drivers in Mac & Linux/Unix Environments

An introduction to and brief tutorial for configuring the CData Software ODBC Drivers in Mac OS X and Unix/Linux environments.
Seamlessly Bring QuickBooks Time into Retool Using CData Connect Cloud

Integrate QuickBooks Time data into Retool with CData Connect Cloud to build smarter apps and streamline workflows with real-time data access.
Build Salesforce Pardot-Connected Apps in Bubble

Use CData Connect Cloud to create an OData feed for Salesforce Pardot and create custom apps in Bubble.
Automated Continuous Office 365 Replication to Microsoft Access

Use CData Sync for automated, continuous, customizable Office 365 replication to Microsoft Access.
Create Informatica Mappings From/To an ODBC Data Source for Adobe Analytics

Create an ODBC connection to Adobe Analytics in Informatica and browse and transfer Adobe Analytics.
Integrate Zuora with External Services using SnapLogic

Use CData JDBC drivers in SnapLogic to integrate Zuora with External Services.
Build Oracle Financials Cloud-Connected Apps in Choreo

Use CData Connect Cloud to connect to Oracle Financials Cloud from Choreo and build custom apps using live Oracle Financials Cloud.
Connect to and Query Azure Analysis Services in QlikView over ODBC

Create data visualizations with Azure Analysis Services in QlikView.
Automated Continuous Box Replication to Azure SQL

Use CData Sync for automated, continuous, customizable Box replication to Azure SQL.
Query NetSuite from Node.js

Use the OData endpoint of the CData API Server to connect to your NetSuite CRM & ERP and perform CRUD operations on NetSuite from Node.js.
How to create an RPA flow for Snowflake in UiPath Studio

Use the Snowflake ODBC Driver to create workflows that access real-time Snowflake without any coding.
Automated Continuous Printify Replication to SQLite

Use CData Sync for automated, continuous, customizable Printify replication to SQLite.
Build MVC Applications with Connectivity to Google Campaign Manager 360

This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Google Campaign Manager 360 from an ASP.NET MVC application.
Model Oracle HCM Cloud Using Azure Analysis Services

Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Oracle HCM Cloud, enabling the direct import of real-time Oracle HCM Cloud.
Build Dashboards with Slack in Dundas BI

Create dynamic dashboards and perform analytics based on Slack in Dundas BI.
Connect to QuickBooks Online in DBeaver

Use the CData ODBC Driver to connect to QuickBooks Online in DBeaver.
Extract, Transform, and Load Sage 50 UK in Informatica PowerCenter

Create a simple Workflow for Sage 50 UK in Informatica PowerCenter.
Query Databricks as a SQL Server Database in Node.js

Execute SQL Server queries against Databricks from Node.js.
Connect to Yahoo! Ads from AWS Glue

Use CData Connect Cloud to gain access to live Yahoo! Ads from your AWS Glue jobs.
How to connect Amazon QuickSight to Microsoft Project

Create a connection to Microsoft Project in CData Connect Cloud and insert Microsoft Project into Amazon QuickSight SPICE to build interactive dashboards.
Consume Google Data Catalog OData Feeds in PowerBuilder

This article demonstrates how to consume Google Data Catalog as OData feeds from PowerBuilder using the API Server.
Use JayDeBeApi to access Microsoft Teams in Python

Use standard Python scripting and the development environment of your choice to access live Microsoft Teams.
Connect to BigCommerce from a Connection Pool in WebLogic

Use the CData JDBC Driver for BigCommerce to connect to BigCommerce from Web applications running on WebLogic.
Automated Continuous QuickBooks Replication to MySQL

Use CData Sync for automated, continuous, customizable QuickBooks replication to MySQL.
Connect to Smartsheet in RapidMiner

Integrate Smartsheet with standard components and data source configuration wizards in RapidMiner Studio.
Create Dynamic Adobe Analytics Grids Using the Infragistics XamDataGrid

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

This article demonstrates how to use the CData ODBC Driver for SAP Fieldglass to connect to SAP Fieldglass from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SAP Fieldglass in Excel.
How to work with SAP in Apache Spark using SQL

Access and process SAP in Apache Spark using the CData Software JDBC Driver.
Automated Continuous eBay Analytics Replication to PostgreSQL

Use CData Sync for automated, continuous, customizable eBay Analytics replication to PostgreSQL.
Create Data Visualizations Based On OData Services in Mode

Use CData Connect Cloud to connect to OData Services from Mode and build visualizations using live
Access Splunk from MySQL in PHP

Connect to Splunk through the standard MySQL libraries in PHP.
Extend Google Sheets with Zoho Creator

Make calls to the API Server from Google Apps Script.
Visualize Harvest in Tableau

The CData ODBC driver for Harvest enables you integrate Harvest into Tableau dashboards.
Connect to ServiceNow from Excel & GoogleSheets!

Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from ServiceNow, and over 250 other data sources, right inside your Excel and Google spreadsheets!
Use JayDeBeApi to access Dynamics 365 Business Central in Python

Use standard Python scripting and the development environment of your choice to access live Dynamics 365 Business Central.
Query SAP Business One as a SQL Server Database in Node.js

Execute SQL Server queries against SAP Business One from Node.js.
Integrate with Sage Intacct using Apache Camel2

Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Sage Intacct to a JSON file on disk.
Connect to PingOne in Claris FileMaker Pro