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

CData Software - Knowledge Base

Recent Articles

Viewing SAS xpt in RAD Studio Data Explorer

How to view SAS XPORT in RAD Studio Data Explorer using the CData ODBC Driver for SAS xpt.
Automate xBase Replication to SAP HANA

Use CData Sync to customize and automate xBase replication to SAP HANA.
Access Stripe as a Remote Oracle Database

Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Stripe from your Oracle system.
Viewing Bullhorn CRM in RAD Studio Data Explorer

How to view Bullhorn CRM in RAD Studio Data Explorer using the CData ODBC Driver for Bullhorn CRM.
Build a PostgreSQL Interface for Cvent using the CData JDBC Driver

Use the Remoting features of the Cvent JDBC Driver to create a PostgreSQL entry-point for data access.
Build Data Flows from SQL Server to Facebook through SSIS

Easily push SQL Server data to Facebook using the CData SSIS Tasks for Facebook.
Automate Aha Replication to Azure Data Lake

Use CData Sync to customize and automate Aha! replication to Azure Data Lake.
Connect to DB2 in RazorSQL

Connect to DB2 from wizards and query IBM DB2 from the GUI in the RazorSQL database management tool.
Create Oracle HCM Cloud-Connected Enterprise Applications in OutSystems

Use CData Connect Cloud to connect to Oracle HCM Cloud from OutSystems and build custom enterprise apps using live Oracle HCM Cloud.
Visualize Dynamics 365 Business Central in TIBCO Spotfire through ODBC

The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Dynamics 365 Business Central into TIBCO Spotfire.
Automate SendGrid Replication to Azure Synapse

Use CData Sync to customize and automate SendGrid replication to Azure Synapse.
Build a Simple VCL Application for SAP SuccessFactors

How to build a simple VCL Application to view SAP SuccessFactors in RAD Studio using the CData ODBC Driver for SAP SuccessFactors.
Build Dashboards with Sybase in DBxtra

Create dynamic dashboards and perform analytics based on Sybase in DBxtra.
Connect to Amazon Marketplace as an External Data Source using PolyBase

Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live Amazon Marketplace.
Automate IBM Informix Replication to Azure Data Lake

Use CData Sync to customize and automate IBM Informix replication to Azure Data Lake.
Connect to Klipfolio in Aqua Data Studio

Access Klipfolio from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
Automate BigQuery Replication to Azure Data Lake

Use CData Sync to customize and automate Google BigQuery replication to Azure Data Lake.
Build a Simple VCL Application for Cvent

How to build a simple VCL Application to view Cvent in RAD Studio using the CData ODBC Driver for Cvent.
Operational Reporting on SFTP from Spotfire Server

Create and share Spotfire data visualizations with real-time connectivity to remote SFTP.
Use Biml to Build SSIS Tasks to Replicate Oracle SCM to SQL Server

Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Oracle SCM to SQL Server.
Build Dashboards with Drip in DBxtra

Create dynamic dashboards and perform analytics based on Drip in DBxtra.
Build Automated Adobe Analytics-Connected Workflows in Zapier

Use CData Connect Cloud to connect to live Adobe Analytics and build automated workflows in Zapier.
Connect to Sage Intacct in Ruby

Connect to Sage Intacct in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
Build Semantic Layer Views for SAP Ariba Procurement in APOS Live Data Gateway

Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for SAP Ariba Procurement.
Import Real-Time Sage Cloud Accounting via JDBC in ColdFusion to Build Applications

Use CData JDBC drivers to import and use Sage Business Cloud Accounting in ColdFusion.
Query, Visualize, and Share live Snapchat Ads in Redash

Use CData Connect Cloud to connect to live Snapchat Ads in Redash for querying, visualizing, and sharing.
Automated Continuous Basecamp Replication to PostgreSQL

Use CData Sync for automated, continuous, customizable Basecamp replication to PostgreSQL.
LINQ to Invoiced

LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Invoiced Data Provider.
Integrate with OData Services in JReport Designer

Create charts and reports based on OData in JReport Designer.
Automated Continuous Facebook Ads Replication to IBM DB2

Use CData Sync for automated, continuous, customizable Facebook Ads replication to IBM DB2.
Integrate BigCommerce into Automated Tasks with Power Automate

Use CData Connect Cloud to connect to BigCommerce and integrate live BigCommerce into your Power Automate tasks.
Access Azure Analysis Services from MySQL in PHP

Connect to Azure Analysis Services through the standard MySQL libraries in PHP.
Configure the CData JDBC Driver for Parquet in a Connection Pool in Tomcat

Connect to Apache Parquet from a connection pool in Tomcat.
PowerShell Scripting to Replicate Splunk to MySQL

Write a simple PowerShell script to replicate Splunk to a MySQL database.
Visualize Live Amazon S3 of Power BI Report Builder in Power BI Service

Use CData Power BI Connectors to connect to live Amazon S3 using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
Connect to QuickBooks Time from Blazor Apps

Build ASP.NET Core Blazor C# apps that integrate with real-time QuickBooks Time using standard SQL.
Build NetSuite-Connected Apps in Choreo

Use CData Connect Cloud to connect to NetSuite from Choreo and build custom apps using live NetSuite CRM & ERP.
Use the CData ODBC Driver for Kintone from SharePoint Excel Services

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

Connect to HarperDB in MicroStrategy Developer using the CData Software JDBC Driver for HarperDB.
Visualize ConstantContact from Tableau

Use the Tableau Desktop business intelligence tool to connect to ConstantContact.
Build Dashboards with Okta in Dundas BI

Create dynamic dashboards and perform analytics based on Okta in Dundas BI.
Use the CData Software ODBC Driver for SAP Netweaver Gateway in SAS for Real-Time Reporting and Analytics

Connect to real-time SAP Netweaver Gateway in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SAP Netweaver Gateway.
Replicate Google Calendar for Use in Salesforce Connect

Replicate Google Calendar to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
Connect to Zenefits in NetBeans

Connect to Zenefits in NetBeans with the data source configuration wizard.
Connect to OData Services as an External Source in Dremio

Use the CData JDBC Driver to connect to OData as an External Source in Dremio.
Replicate Multiple Printify Accounts via the CData Sync CLI

Replicate multiple Printify accounts to one or many databases.
Create MailChimp-Connected Applications in Appsmith

Connect to MailChimp via CData Connect Cloud in Appsmith and create custom business applications with real-time access to MailChimp.
Automated Continuous Sage 300 Replication to Vertica

Use CData Sync for automated, continuous, customizable Sage 300 replication to Vertica.
ETL Impala in Oracle Data Integrator

This article shows how to transfer Apache Impala into a data warehouse using Oracle Data Integrator.
Integrate AlloyDB in Pentaho Data Integration

Build ETL pipelines based on Google AlloyDB in the Pentaho Data Integration tool.
How to Easily Query Google Directory in OpenOffice Base