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

CData Software - Knowledge Base

Recent Articles

Connect to BigCommerce in Jaspersoft Studio

Execute SQL to remote BigCommerce in Jaspersoft Studio.
Build Pipelines with Live Microsoft Exchange in Google Cloud Data Fusion (via CData Connect Cloud)

Use CData Connect Cloud to connect to Microsoft Exchange from Google Cloud Data Fusion, enabling the integration of live Microsoft Exchange into the building and management of effective data pipelines.
Build HubDB-Connected Web Apps in Servoy

Use Servoy Developer to easily connect to HubDB and build web apps with connectivity to live HubDB.
How to pipe Hive to CSV in PowerShell

Use standard PowerShell cmdlets to access Hive tables.
Import Real-Time Reckon via ODBC in ColdFusion to Build Applications

Use CData ODBC drivers to import and use Reckon in ColdFusion.
Replicate Azure DevOps from PowerShell

Write a quick PowerShell script to query Azure DevOps. Use connectivity to the live data to replicate Azure DevOps to SQL Server.
Automated Continuous Paylocity Replication to OneLake in Microsoft Fabric

Use CData Sync for automated, continuous, customizable Paylocity replication to OneLake in Microsoft Fabric.
Use the CData Software ODBC Driver for FHIR in MicroStrategy Desktop

Connect to FHIR in MicroStrategy Desktop using the CData Software ODBC Driver for FHIR.
Access Live Azure Synapse in Excel 365 Online (Excel for the web)

Connect to Azure Synapse from Excel 365 Online (Excel for the web) with CData Connect Cloud.
Create Apps from Databricks in Qlik Sense Cloud

Use CData Connect Cloud to connect to Databricks and build apps from live Databricks in Qlik Sense Cloud.
Use Dash to Build to Web Apps on Greenhouse

Create Python applications that use pandas and Dash to build Greenhouse-connected web apps.
Automated Continuous Google Ads Replication to Amazon Redshift

Use CData Sync for automated, continuous, customizable Google Ads replication to Amazon Redshift.
Create Klipfolio-Connected Business Apps in AppSheet

Use CData Software Connect Server to connect to Klipfolio from AppSheet and build custom business apps using live Klipfolio.
Automated Continuous Twitter Ads Replication to Databricks

Use CData Sync for automated, continuous, customizable Twitter Ads replication to Databricks.
How to load Authorize.Net data into Elasticsearch via Logstash

Introducing a simple method to load Authorize.Net data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
Query Google Calendar as a SQL Server Database in Node.js

Execute SQL Server queries against Google Calendar from Node.js.
Replicate Multiple Procore Accounts

Replicate multiple Procore accounts to one or many databases.
Integrate with Salesloft using Apache Camel2

Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Salesloft to a JSON file on disk.
Access Live OData Services in AWS Lambda (with IntelliJ IDEA)

Connect to live OData in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
How to Connect the Power BI Service to Dropbox: Complete Guide

Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
Connect to Oracle HCM Cloud from Filemaker Pro (Mac)

Use CData Connect Cloud to connect to and query live Oracle HCM Cloud from Filemaker Pro on Mac.
Access Live Backlog in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

Connect to Backlog from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
Automated Oracle Service Cloud Replication to Teradata

Use CData Sync to Customize and automate Oracle Service Cloud replication to Teradata.
Natively Connect to Dynamics 365 Business Central in PHP

The CData ODBC driver for Dynamics 365 Business Central enables you to create PHP applications with connectivity to Dynamics 365 Business Central. Leverage the native support for ODBC in PHP.
Work with Live Zoho Projects in Power Query

Use CData Connect Cloud to connect to Zoho Projects and work with live Zoho Projects in Microsoft Power Query.
How to integrate Metabase with Smartsheet

Use CData Connect Cloud to connect to live Smartsheet and create an interactive dashboard in Metabase from Smartsheet.
How to Connect the Power BI Service to Amazon Athena: Complete Guide

Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
Integrate Bitbucket in the Pentaho Report Designer

Publish reports based on Bitbucket in the Pentaho BI tool.
How to update eBay from Excel

This article explains how to transfer data from Excel to eBay using the Excel Add-In for eBay.
Create Apps from SharePoint in Qlik Sense Cloud

Use CData Connect Cloud to connect to SharePoint and build apps from live Microsoft SharePoint in Qlik Sense Cloud.
Use the CData Software ODBC Driver for PayPal in MicroStrategy

Connect to PayPal in MicroStrategy Developer using the CData Software ODBC Driver for PayPal.
Connect to SAP HANA from PowerBuilder via ODBC

This article demonstrates how to use the CData ODBC Driver for SAP HANA to connect to SAP HANA and execute queries in PowerBuilder.
Connect to Trello from PowerBuilder via ODBC

This article demonstrates how to use the CData ODBC Driver for Trello to connect to Trello and execute queries in PowerBuilder.
Easily Integrate Zoho Books in Lazarus Pascal IDE

Learn how to easily integrate live Zoho Books in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
Use the CData Software ODBC Driver for Quickbase in SAS for Real-Time Reporting and Analytics

Connect to real-time Quickbase in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Quickbase.
View Reports on Real-Time GraphQL in Power BI Report Server

Use the CData ODBC Driver for GraphQL to visualize GraphQL in Power BI Desktop and then publish them to Power BI Report Server.
Build Semantic Layer Views for NetSuite in APOS Live Data Gateway

Use the CData Connector for NetSuite in APOS Live Data Gateway to build Semantic Layer Views for NetSuite CRM & ERP.
Build a Simple VCL Application for Office 365

How to build a simple VCL Application to view Microsoft Office 365 in RAD Studio using the CData ODBC Driver for Office 365.
Analyze Kintone with Power Pivot

This article walks you through the process of using the CData ODBC Driver for Kintone from Power Pivot. You will use the Table Import Wizard to load Kintone. You can visually build the import query or use any SQL supported by the driver.
Access Live QuickBooks Online in Google Sheets through Connect Spreadsheets

Use Connect Spreadsheets by CData to gain access to live QuickBooks Online from your Google Sheets.
Connect to SAP Ariba Procurement as an External Source in Dremio

Use the CData JDBC Driver to connect to SAP Ariba Procurement as an External Source in Dremio.
Create SSAS Tabular Models from TaxJar

How to build a SQL Server Analysis Service Tabular Model from TaxJar using CData drivers.
How to Connect DBeaver to Salesforce Marketing via a JDBC Driver

Manage Salesforce Marketing Cloud with visual tools in DBeaver like the query browser.
Use the CData ODBC Driver for Quickbase from SharePoint Excel Services

This article demonstrates how to use the CData ODBC Driver for Quickbase to connect to Quickbase from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Quickbase in Excel.
Build Dashboards with Amazon S3 in DBxtra

Create dynamic dashboards and perform analytics based on Amazon S3 in DBxtra.
Use JayDeBeApi to access Amazon DynamoDB in Python

Use standard Python scripting and the development environment of your choice to access live Amazon DynamoDB.
Configure the CData JDBC Driver for Google Sheets in a Connection Pool in Tomcat

Connect to Google Sheets from a connection pool in Tomcat.
Connect to Oracle HCM Cloud in DBArtisan

Use wizards in DBArtisan to configure Oracle HCM Cloud as a data source.
Connect to Azure Synapse through External Services in Salesforce

Use CData Connect Cloud to securely connect Salesforce External Services with Azure Synapse using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
Connect to Veeva Vault in Jaspersoft Studio

Execute SQL to remote Veeva Vault & Vault CRM in Jaspersoft Studio.
How to Build an ETL App for Kintone in Python with CData

Create ETL applications and real-time data pipelines for Kintone in Python with petl.
Stream OneNote into Apache Kafka Topics

Access and stream Microsoft OneNote in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
Use JayDeBeApi to access Drip in Python

Use standard Python scripting and the development environment of your choice to access live Drip.
Access Live OneNote in Excel (Desktop) via Connect Cloud

Use CData Connect Cloud to gain access to live Microsoft OneNote from your Excel spreadsheets.
Automated Continuous Drift Replication to SQLite

Use CData Sync for automated, continuous, customizable Drift replication to SQLite.
Automated Continuous SharePoint Excel Services Replication to Snowflake

Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to Snowflake.
Query SAP BusinessObjects BI in MySQL Workbench

Create a virtual MySQL database for SAP BusinessObjects BI in CData Software Connect (or Connect Server) and work with live SAP BusinessObjects BI in MySQL Workbench.
DataBind Charts to Drift

Use the standard ADO.NET procedures for databinding to provide bidirectional access to Drift 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.
Connect to Real-Time Printify Data in Power Apps Using Dataflows to Build Custom Applications