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

CData Software - Knowledge Base

Recent Articles

Import Real-Time SAP SuccessFactors via JDBC in ColdFusion to Build Applications

Use CData JDBC drivers to import and use SAP SuccessFactors in ColdFusion.
How to integrate RSS with Apache Airflow

Access and process RSS Feeds in Apache Airflow using the CData JDBC Driver.
A PostgreSQL Interface for Shippo using the CData ODBC Driver

Use the SQL Gateway and Shippo ODBC Driver to create a PostgreSQL entry-point for data access.
Import Real-Time Amazon S3 via ODBC in ColdFusion to Build Applications

Use CData ODBC drivers to import and use Amazon S3 in ColdFusion.
Excel Spreadsheet Automation on Trello with the QUERY Formula

Pull data, automate spreadsheets, and more with the QUERY formula.
Deploy the ADO.NET Provider for Bitbucket on an SSRS Report Server

Connect to Bitbucket 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.
Create Datasets from Stripe in Domo Workbench and Build Visualizations of Stripe in Domo

Use the CData Software ODBC Driver for Stripe to create datasets from Stripe in Domo Workbench and then build visualizations in the Domo service.
Integrate Azure DevOps in Pentaho Data Integration

Build ETL pipelines based on Azure DevOps in the Pentaho Data Integration tool.
Visualize Highrise in Tableau

The CData ODBC driver for Highrise enables you integrate Highrise CRM into Tableau dashboards.
Publish Microsoft Exchange-Connected Dashboards in Tableau Server via JDBC

Use CData JDBC drivers and Tableau Server to visualize live Microsoft Exchange.
Automated Continuous Oracle SCM Replication to Local Delimited Files

Use CData Sync for automated, continuous, customizable Oracle SCM replication to delimited files (CSV/TSV).
How to Connect DBeaver to Google Spanner via a JDBC Driver

Manage Google Spanner with visual tools in DBeaver like the query browser.
Build Google Sheets Visualizations in Tableau Cloud

Use CData Connect Cloud to connect to live Google Sheets and build visualizations in Tableau Cloud.
Access Live Amazon DynamoDB in SAS JMP via ODBC

You can use the CData ODBC Driver to integrate Amazon DynamoDB into the statistical analysis tools available in SAS JMP. This article shows how to use Amazon DynamoDB in the Graph Builder and Query Builder.
Visualize Live Twitter Ads in Power BI (via CData Connect Cloud)

Use the CData Power BI Connector and CData Connect Cloud to integrate live Twitter Ads into custom reports in Power BI.
Excel Spreadsheet Automation on HBase with the QUERY Formula

Pull data, automate spreadsheets, and more with the QUERY formula.
Build Jira-Connected Apps in Choreo

Use CData Connect Cloud to connect to Jira from Choreo and build custom apps using live Atlassian Jira.
Query, Visualize, and Share live Gmail in Redash

Use CData Connect Cloud to connect to live Gmail in Redash for querying, visualizing, and sharing.
Connect and Visualize Live Google Drive Data in Databricks Lakehouse Federation with CData Connect Cloud

Use CData Connect Cloud to integrate live Google Drive into the Databricks platform and create visualization dashboards with real-time Google Drive.
How to Query Live Klaviyo Data in Natural Language in Python using LlamaIndex

Use LlamaIndex to query live Klaviyo data in natural language using Python.
DataBind Charts to Greenhouse

Use the standard ADO.NET procedures for databinding to provide bidirectional access to Greenhouse 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.
Validate SAP SuccessFactors with QuerySurge

Access and validate SAP SuccessFactors in QuerySurge using the CData JDBC Driver.
Connect to and Visualize Live Act-On in Tableau Prep

Use CData Tableau Connectors and Tableau Prep Builder to visualize live Act-On.
Back Up HubDB to SQL Server through SSIS

Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for HubDB. In this article, we will employ an SSIS workflow to populate a database with HubDB data.
Build Data Flows from SQL Server to Couchbase through SSIS

Easily push SQL Server data to Couchbase using the CData SSIS Tasks for Couchbase.
Analyze PostgreSQL in Infragistics Reveal

Use CData Connect Cloud to create on OData API on top of PostgreSQL and visualize live PostgreSQL in Infragistics Reveal.
Connect to Dropbox from a Connection Pool in Jetty

The Dropbox JDBC Driver supports connection pooling: This article shows how to connect faster to Dropbox from Web apps in Jetty.
How to connect to Highrise from Spring Boot

Connect to Highrise in a Spring Boot Application using CData JDBC Highrise Driver
How to integrate Metabase with OData Services

Use CData Connect Cloud to connect to live OData and create an interactive dashboard in Metabase from OData.
Analyze HCL Domino in R via ODBC

Create data visualizations and use high-performance statistical functions to analyze HCL Domino in Microsoft R Open.
Connect to XML from PowerBuilder via ADO.NET

This article demonstrates how to access XML Files from Appeon PowerBuilder using the CData ADO.NET Provider for XML.
Create Oracle Financials Cloud-Connected Enterprise Applications in OutSystems

Use CData Connect Cloud to connect to Oracle Financials Cloud from OutSystems and build custom enterprise apps using live Oracle Financials Cloud.
Connect to Azure Data Catalog from PowerBuilder via JDBC

This article demonstrates how to access Azure Data Catalog from PowerBuilder using the Azure Data Catalog JDBC Driver.
Automate Raisers Edge NXT Replication to SAP HANA

Use CData Sync to customize and automate Raisers Edge NXT replication to SAP HANA.
Query Xero as a MySQL Database in Node.js

Execute MySQL queries against Xero Accounting from Node.js.
How to Access Live SAP Ariba Source in Power Automate Desktop via ODBC

The CData ODBC Driver for SAP Ariba Source enables you to integrate SAP Ariba Source into workflows built using Microsoft Power Automate Desktop.
Integrate Google Cloud Storage in Pentaho Data Integration

Build ETL pipelines based on Google Cloud Storage in the Pentaho Data Integration tool.
Build Trello-Connected Apps in Bubble

Use CData Connect Cloud to create an OData feed for Trello and create custom apps in Bubble.
Validate Google Contacts with QuerySurge

Access and validate Google Contacts in QuerySurge using the CData JDBC Driver.
Build a Simple VCL Application for SingleStore

How to build a simple VCL Application to view SingleStore in RAD Studio using the CData ODBC Driver for SingleStore.
Automated Continuous SAS xpt Replication to IBM DB2

Use CData Sync for automated, continuous, customizable SAS xpt replication to IBM DB2.
Query MariaDB in MySQL Workbench

Create a virtual MySQL database for MariaDB in CData Software Connect (or Connect Server) and work with live MariaDB in MySQL Workbench.
Automated Continuous Salesforce Marketing Replication to Local Delimited Files

Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to delimited files (CSV/TSV).
Use the CData ODBC Driver for TaxJar from SharePoint Excel Services

This article demonstrates how to use the CData ODBC Driver for TaxJar to connect to TaxJar from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring TaxJar in Excel.
Connect to Oracle Financials Cloud in the Denodo Platform

Use CData driver technologies to create a virtual data source for Oracle Financials Cloud in the Denodo Virtual DataPort Administrator.
Create Google Drive Dashboards in Bold BI

Use CData Software Connect Server to create a virtual SQL Server Database for Google Drive to build custom dashboards in Bold BI.
Object-Relational Mapping (ORM) with GitHub 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 GitHub into a Java-based ORM framework, Hibernate.
Prepare, Blend, and Analyze Microsoft Project in Alteryx Designer (ODBC)

Build workflows to access live Microsoft Project for self-service data analytics.
Query Monday.com in MySQL Workbench

Create a virtual MySQL database for Monday.com in CData Software Connect (or Connect Server) and work with live Monday.com in MySQL Workbench.
Connect to SAP Netweaver Gateway in DigitalSuite Studio through RunMyProcess DSEC

Use Arkobi Digital
Use Biml to Build SSIS Tasks to Replicate Oracle Financials Cloud to SQL Server

Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Oracle Financials Cloud to SQL Server.
Integrate Dynamics 365 into Power Automate Desktop using CData Connect

CData Connect for Dynamics 365 enables you to integrate Microsoft Dynamics 365 into workflows built using Microsoft Power Automate Desktop.
How to publish and share SingleStore dashboards with Tableau Server

The CData ODBC driver for SingleStore enables you integrate SingleStore into Tableau dashboards.
Use the CData Software ODBC Driver for Microsoft Project in MicroStrategy

Connect to Microsoft Project in MicroStrategy Developer using the CData Software ODBC Driver for Microsoft Project.
Build Apps with Live Google Drive in Adalo using CData Connect Cloud

Use CData Connect Cloud to integrate live Google Drive into the Adalo platform and build custom mobile and web applications with real-time Google Drive.
Build MVC Applications with Connectivity to SAP ByDesign

This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SAP ByDesign from an ASP.NET MVC application.
Query Microsoft Project in MySQL Workbench

Create a virtual MySQL database for Microsoft Project in CData Software Connect (or Connect Server) and work with live Microsoft Project in MySQL Workbench.
A PostgreSQL Interface for Splunk using the CData ODBC Driver

Use the SQL Gateway and Splunk ODBC Driver to create a PostgreSQL entry-point for data access.
Query, Visualize, and Share live Square in Redash

Use CData Connect Cloud to connect to live Square in Redash for querying, visualizing, and sharing.
Automated Continuous HBase Replication to AlloyDB

Use CData Sync for automated, continuous, customizable HBase replication to AlloyDB.
How to integrate Metabase with MYOB AccountRight

Use CData Connect Cloud to connect to live MYOB AccountRight and create an interactive dashboard in Metabase from MYOB AccountRight.
View Reports on Real-Time SAP HANA XS Advanced in Power BI Report Server

Use the CData ODBC Driver for SAP HANA XS Advanced to visualize SAP HANA XS Advanced in Power BI Desktop and then publish them to Power BI Report Server.
Explore Geographical Relationships in Todoist with Power Map

Create data visualizations with Todoist in Power Map.
Enable the Sage 50 UK JDBC Driver in KNIME

Use standard data access components in KNIME to create charts and reports with Sage 50 UK.
Connect to OneNote in HULFT Integrate

Connect to OneNote as a JDBC data source in HULFT Integrate
How to create Bing Search federated tables in MySQL

Use the SQL Gateway and the ODBC Driver to set up federated tables for Bing Search in MySQL .
Stream LDAP Objects into Apache Kafka Topics

Access and stream LDAP in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
Use the CData ODBC Driver for Zuora from SharePoint Excel Services

This article demonstrates how to use the CData ODBC Driver for Zuora to connect to Zuora from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Zuora in Excel.
Use the CData Software JDBC Driver for CouchDB in MicroStrategy Desktop

Connect to Apache CouchDB in MicroStrategy Desktop using the CData Software JDBC Driver for CouchDB.
How to connect to Zenefits from Google Apps Script

Use CData Software Connect Server to access Zenefits in Google Apps Script.
Work with SAP Fieldglass in FoxPro

Load SAP Fieldglass into a FoxPro database. This article includes full code and a walk-through of the process.
Load Excel Online to a Database Using Embulk

Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft Excel Online to a database.
Build Google Calendar-Connected Apps in Choreo

Use CData Connect Cloud to connect to Google Calendar from Choreo and build custom apps using live Google Calendar.
Replicate Multiple Vertica Accounts via the CData Sync CLI

Replicate multiple Vertica accounts to one or many databases.
Visualize Blackbaud FE NXT in Tableau

The CData ODBC driver for Blackbaud FE NXT enables you integrate Blackbaud FE NXT into Tableau dashboards.
Use Biml to Build SSIS Tasks to Replicate SingleStore to SQL Server

Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SingleStore to SQL Server.
Access Live BigCommerce in Excel (Desktop) through Connect Spreadsheets

Use Connect Spreadsheets by CData to gain access to live BigCommerce from your Excel spreadsheets.
Access SurveyMonkey in PHP through Connect Server

Connect to SurveyMonkey through the standard SQL Server libraries in PHP.
DataBind Wijmo Grid to Drip

Provide real-time Drip to interactive controls.
Connect to MySQL from a Connection Pool in WebLogic

Use the CData JDBC Driver for MySQL to connect to MySQL from Web applications running on WebLogic.
Integrate with Asana using Apache Camel2

Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Asana to a JSON file on disk.
Natively Connect to Trello in PHP via ODBC (Linux)

Create PHP applications on Linux/UNIX machines with connectivity to Trello. Leverage the native support for ODBC in PHP.
Add SAS Data Sets to Informatica Enterprise Data Catalog

Use the CData Software JDBC Driver for SAS Data Sets with the Informatica Enterprise Data Catalog to classify and organize data.
Connect to Clio in HULFT Integrate

Connect to Clio as a JDBC data source in HULFT Integrate
Work with Coinbase in FoxPro

Load Coinbase into a FoxPro database. This article includes full code and a walk-through of the process.
Viewing Calendly in RAD Studio Data Explorer

How to view Calendly in RAD Studio Data Explorer using the CData ODBC Driver for Calendly.
Connect to MongoDB in Airbyte ELT Pipelines

Use CData Connect Cloud to build ELT pipelines for MongoDB in Airbyte.
Use the CData Software JDBC Driver for Facebook Ads in MicroStrategy Web

Connect to Facebook Ads in MicroStrategy Web using the CData Software JDBC Driver for Facebook Ads.
Create Data Visualizations Based On SAP Ariba Source in Mode

Use CData Connect Cloud to connect to SAP Ariba Source from Mode and build visualizations using live
Create Yahoo! Japan Data Solution-Connected Nintex Workflows

Use CData Connect Cloud to connect to Yahoo! Japan Data Solution from Nintex Workflow Cloud and build custom workflows using live Yahoo! Japan Data Solution.
How to integrate SAP ByDesign with Apache Airflow

Access and process SAP Business ByDesign in Apache Airflow using the CData JDBC Driver.
Use Dash to Build to Web Apps on Excel Online

Create Python applications that use pandas and Dash to build Excel Online-connected web apps.
Use the Connect Server to Access Clio in Microsoft Power Pivot

Use the Connect Server to connect to live Clio in the Power Pivot business intelligence tool.
Build Avalara AvaTax-Connected Apps in Mendix

Use CData Connect Cloud to create an OData feed for Avalara AvaTax and create custom apps in Mendix.
Connect to Veeva Vault in Google Apps Script via Connect Cloud

Use CData Connect Cloud to access Veeva Vault & Vault CRM in Google Apps Script.
Design BIRT Reports on Oracle Sales

Provide current Oracle Sales to your embedded analytics.
Automated Continuous QuickBooks Time Replication to MongoDB

Use CData Sync for automated, continuous, customizable QuickBooks Time replication to MongoDB.
Square Reporting and Star Schemas in OBIEE

Create a star schema that shows perspectives on Square facts in real time.
Create a Data Access Object for Raisers Edge NXT using JDBI

A brief overview of creating a SQL Object API for Raisers Edge NXT in JDBI.
Integrate eBay with External Services using SnapLogic

Use CData JDBC drivers in SnapLogic to integrate eBay with External Services.