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

CData Software - Knowledge Base

Recent Articles

Replicate Drip from PowerShell

Write a quick PowerShell script to query Drip. Use connectivity to the live data to replicate Drip to SQL Server.
Publish Reports with Excel Online in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Microsoft Excel Online.
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.
Integrate with live SharePoint in Jitterbit

Use CData Connect Cloud to connect to and integrate live Microsoft SharePoint in Jitterbit.
Query Azure Data Catalog as a MySQL Database in Node.js

Execute MySQL queries against Azure Data Catalog from Node.js.
Replicate Airtable to Multiple Databases

Replicate Airtable to disparate databases with a point-and-click configuration.
Integrate Act CRM in Your Informatica Cloud Instance

Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Act CRM from Informatica Cloud.
Create Informatica Mappings From/To a JDBC Data Source for Amazon Marketplace

Create Amazon Marketplace data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
Create Monday.com-Connected Nintex Workflows

Use CData Connect Cloud to connect to Monday.com from Nintex Workflow Cloud and build custom workflows using live Monday.com.
Use Biml to Build SSIS Tasks to Replicate ADP to SQL Server

Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ADP to SQL Server.
DataBind Charts to Google Analytics

Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google Analytics 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.
Load Shippo to a Database Using Embulk

Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Shippo to a database.
Connect to BambooHR in DBArtisan

Use wizards in DBArtisan to configure BambooHR as a data source.
Process & Analyze Oracle Eloqua in Databricks (AWS)

Use CData, AWS, and Databricks to perform data engineering and data science on live Oracle Eloqua .
How to Build Dynamic React Apps with Raisers Edge NXT

Use the CData Connect and React to Build Dynamic Web Apps with Live Raisers Edge NXT .
Build Epicor Kinetic Visualizations in Tableau Cloud

Use CData Connect Cloud to connect to live Epicor Kinetic and build visualizations in Tableau Cloud.
How to Build Dynamic React Apps with Salesforce

Use the CData Connect and React to Build Dynamic Web Apps with Live Salesforce .
Use the Connect Server to Access FTP in Microsoft Power Pivot

Use the Connect Server to connect to live FTP Servers in the Power Pivot business intelligence tool.
Query Jira in DataGrip

Create a Data Source for Jira in DataGrip and use SQL to query live Atlassian Jira.
Connect to xBase as a Linked Server via SQL Gateway

Use the SQL Gateway and the ODBC Driver to set up a linked server for xBase.
Automated Continuous SQL Server Replication to Amazon S3

Use CData Sync for automated, continuous, customizable SQL Server replication to Amazon S3.
Using the CData Software ODBC Driver for HarperDB in PyCharm

Connect to HarperDB as an ODBC data source in PyCharm using the CData Software ODBC Driver for HarperDB.
Work with Dynamics 365 Business Central in FoxPro

Load Dynamics 365 Business Central into a FoxPro database. This article includes full code and a walk-through of the process.
Build Asana Visualizations in Tableau Cloud

Use CData Connect Cloud to connect to live Asana and build visualizations in Tableau Cloud.
Extract, Transform, and Load LDAP Objects in Informatica PowerCenter

Create a simple Workflow for LDAP in Informatica PowerCenter.
Replicate Multiple YouTube Analytics Accounts

Replicate multiple YouTube Analytics accounts to one or many databases.
Automated Continuous Snapchat Ads Replication to Google BigQuery

Use CData Sync for automated, continuous, customizable Snapchat Ads replication to Google BigQuery.
Import Google Cloud Storage into FileMaker Pro

Create reports that integrate Google Cloud Storage in Filemaker Pro.
Automated Continuous Avro Replication to IBM DB2

Use CData Sync for automated, continuous, customizable Avro replication to IBM DB2.
Connect to Live Impala in MicroStrategy through CData Connect Cloud

Create a live connection to Impala in CData Connect Cloud and connect to your Apache Impala from MicroStrategy.
Connect to Pipedrive as a Linked Server via SQL Gateway

Use the SQL Gateway and the ODBC Driver to set up a linked server for Pipedrive.
Replicate Stripe to Multiple Databases

Replicate Stripe to disparate databases with a point-and-click configuration.
Working with Oracle Service Cloud in LINQPad

Execute LINQ queries to Oracle Service Cloud in LINQPad.
Connect to Splunk from a Connection Pool in JBoss

Integrate Splunk into Java servlets: Use the Management Console in JBoss to install the Splunk JDBC Driver.
Visualize Live NetSuite in Power BI (via CData Connect Cloud)

Use the CData Power BI Connector and CData Connect Cloud to integrate live NetSuite CRM & ERP into custom reports in Power BI.
Integrate Salesloft with External Services using SnapLogic

Use CData JDBC drivers in SnapLogic to integrate Salesloft with External Services.
Connect to Greenhouse from a Connection Pool in Jetty

The Greenhouse JDBC Driver supports connection pooling: This article shows how to connect faster to Greenhouse from Web apps in Jetty.
How to create an RPA flow for Klipfolio in UiPath Studio

Use the Klipfolio ODBC Driver to create workflows that access real-time Klipfolio without any coding.
DataBind Controls to Klaviyo in C++Builder

DataBind to Klaviyo in C++Builder with standard components and controls.
Connect to Google Analytics in RunMyProcess through Connect Cloud

Use CData Connect Cloud to create on OData API for Google Analytics and connect to Google Analytics in Akorbi Digital RunMyProcess.
Create Informatica Mappings From/To a JDBC Data Source for Stripe

Create Stripe data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
Create Reports with Kintone in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Kintone.
Perform Batch Operations with Dynamics 365 Business Central in Apache NiFi

Connect to Dynamics 365 Business Central and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
Connect to SAP ByDesign from a Connection Pool in JBoss

Integrate SAP Business ByDesign into Java servlets: Use the Management Console in JBoss to install the SAP ByDesign JDBC Driver.
Use the CData SSIS Components to Insert New or Update Existing REST Records from SQL Server

Easily push SQL Server data to REST using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into REST or update existing records with data from a SQL Server database.
DataBind Charts to Parquet

Use the standard ADO.NET procedures for databinding to provide bidirectional access to Apache Parquet 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.
Integrate OData Services in the Pentaho Report Designer

Publish reports based on OData in the Pentaho BI tool.
Connect to Google Drive in DigitalSuite Studio through RunMyProcess DSEC

Use Arkobi Digital
A PostgreSQL Interface for SQL Analysis Services using the CData ODBC Driver

Use the SQL Gateway and SQL Analysis Services ODBC Driver to create a PostgreSQL entry-point for data access.
Access Live LinkedIn Ads in Coginiti Pro

Connect to and query live LinkedIn Ads from the GUI in the Coginiti Pro: SQL Analytics Tool.
Establish a Live Connection with YouTube Analytics using Tableau Bridge

The CData ODBC Driver for YouTube Analytics enables you to integrate live YouTube Analytics into Tableau Cloud dashboards using the Tableau Bridge.
Bridge Okta Connectivity with Apache NiFi

Access and process Okta in Apache NiFi using the CData JDBC Driver.
Automated Continuous SAP Concur Replication to SingleStore

Use CData Sync for automated, continuous, customizable SAP Concur replication to SingleStore.
Create Datasets from Pinterest in Domo Workbench and Build Visualizations of Pinterest in Domo

Use the CData Software ODBC Driver for Pinterest to create datasets from Pinterest in Domo Workbench and then build visualizations in the Domo service.
Connect to Zoho Inventory in DBArtisan

Use wizards in DBArtisan to configure Zoho Inventory as a data source.
Create eBay Analytics-Connected Business Apps in AppSheet

Use CData Software Connect Server to connect to eBay Analytics from AppSheet and build custom business apps using live eBay Analytics.
Integrate Real-Time Access to Procore in SAPUI5 MVC Apps

Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Procore in real time.
Using the CData Software ODBC Driver for Paylocity in PyCharm

Connect to Paylocity as an ODBC data source in PyCharm using the CData Software ODBC Driver for Paylocity.
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Airtable

Provide connectivity to Airtable through an SAP BusinessObjects universe.
Access Amazon S3 in PHP through Connect Server

Connect to Amazon S3 through the standard SQL Server libraries in PHP.
Create SSAS Tabular Models from Google Sheets

How to build a SQL Server Analysis Service Tabular Model from Google Sheets using CData drivers.
How to Visualize Google Directory Data in Python with pandas

Use pandas and other modules to analyze and visualize live Google Directory in Python.
Connect to and Query MySQL in QlikView over ODBC

Create data visualizations with MySQL in QlikView.
Access OneNote as a Remote Oracle Database

Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Microsoft OneNote from your Oracle system.
Automated Continuous IBM Informix Replication to Microsoft Access

Use CData Sync for automated, continuous, customizable IBM Informix replication to Microsoft Access.
How to connect to Salesforce Pardot in DBVisualizer

Integrate Salesforce Pardot with visual data analysis tools and data connection wizards in DBVisualizer
Design BIRT Reports on Asana

Provide current Asana to your embedded analytics.
Import Excel Online into the Power BI Service for Visualizations

Use CData Connect Cloud to connect to Excel Online and provide access to live Microsoft Excel Online for custom reports in the Power BI Service.
How to Connect to & Open HubDB in Microsoft Excel

This article uses the CData ODBC driver for HubDB to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
Write a Simple Go Application to work with Todoist on Linux

Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Todoist.
Connect to MySQL as a SQL Server Linked Server

Use CData Connect Cloud to create a linked server for live MySQL.
How to connect to SAP Ariba Procurement from Spring Boot

Connect to SAP Ariba Procurement in a Spring Boot Application using CData JDBC SAP Ariba Procurement Driver
CData Connect: Derived Views and Query Federation

Explore the Derived Views and Query Federation features of CData Connect.
Excel Spreadsheet Automation on Redis with the QUERY Formula

Pull data, automate spreadsheets, and more with the QUERY formula.
Connect to Couchbase in JRuby

Create a simple JRuby app with access to live Couchbase.
Visualize Live Kintone in Tableau

Use CData Tableau Connectors and Tableau Desktop to visualize live Kintone.
Access Drift in PHP through Connect Server

Connect to Drift through the standard SQL Server libraries in PHP.
Build Automated Workflows with Live OData Services in Workato

Use CData Connect Cloud to connect to live OData and build automated workflows in Workato.
Access Zoho Books as a Remote Oracle Database

Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Zoho Books from your Oracle system.
Extract, Transform, and Load Marketo in Informatica PowerCenter

Create a simple Workflow for Marketo in Informatica PowerCenter.
Create MariaDB-Connected Applications in Appsmith

Connect to MariaDB via CData Connect Cloud in Appsmith and create custom business applications with real-time access to MariaDB.
Create a Data Access Object for Invoiced using JDBI

A brief overview of creating a SQL Object API for Invoiced in JDBI.
Use the CData ODBC Driver for Azure Synapse from SharePoint Excel Services

This article demonstrates how to use the CData ODBC Driver for Azure Synapse to connect to Azure Synapse from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Azure Synapse in Excel.
How to load AlloyDB data into Elasticsearch via Logstash

Introducing a simple method to load AlloyDB data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
Publish Oracle-Connected Dashboards in Tableau Server via JDBC

Use CData JDBC drivers and Tableau Server to visualize live Oracle Database.
Publish PayPal-Connected Dashboards in Tableau Server via JDBC

Use CData JDBC drivers and Tableau Server to visualize live PayPal.
Visualize Live SurveyMonkey in Power BI (via CData Connect Cloud)

Use the CData Power BI Connector and CData Connect Cloud to integrate live SurveyMonkey into custom reports in Power BI.
Import Real-Time Google Ad Manager via ODBC in ColdFusion to Build Applications

Use CData ODBC drivers to import and use Google Ad Manager in ColdFusion.
Build Apps with Live BigQuery Using the Low-Code Development Platform of Mendix