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

CData Software - Knowledge Base

Recent Articles

Query Amazon Athena through ODBC in Node.js

Use node-odbc to execute SQL queries against Amazon Athena from Node.js.
Automate Sage 300 Integration Tasks from PowerShell

Are you in search of a quick and easy way to access Sage 300 from PowerShell? This article demonstrates how to utilize the Sage 300 Cmdlets for tasks like connecting to Sage 300, automating operations, downloading data, and more.
Publish Crystal Reports on LDAP Objects

Use the Report Wizard and standard ADO.NET to design a report based on up-to-date LDAP.
Getting Started with the CData SSIS Components for Zoho Creator

Complete guide to installing, licensing, and connecting with the CData SSIS Components for Zoho Creator.
Write a Simple Go Application to work with Calendly on Linux

Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Calendly.
Enable the Pipedrive JDBC Driver in KNIME

Use standard data access components in KNIME to create charts and reports with Pipedrive.
Connect to QuickBooks Time in DBArtisan

Use wizards in DBArtisan to configure QuickBooks Time as a data source.
Integrate with Live Sage 200 in MuleSoft (via CData Connect AI)

Use CData Connect AI to connect to Sage 200 from the MuleSoft Anypoint Platform to integrate live Sage 200 into custom reports and dashboards.
Build Databricks-Connected ETL Processes in Google Data Fusion

Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Databricks.
Automated Continuous Sage Intacct Replication to Local Delimited Files

Use CData Sync for automated, continuous, customizable Sage Intacct replication to delimited files (CSV/TSV).
Connect to Facebook Ads from PowerBuilder via ADO.NET

This article demonstrates how to access Facebook Ads from Appeon PowerBuilder using the CData ADO.NET Provider for Facebook Ads.
Work with MongoDB in FoxPro

Load MongoDB into a FoxPro database. This article includes full code and a walk-through of the process.
How to Connect Flowise AI Agents to Live Zoho CRM via CData Connect AI

Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live data without replication.
How to Seamlessly Import Sybase Data into IBM SPSS Modeler

Integrate Sybase data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
DataBind Basecamp to the DevExpress Data Grid

Use the CData Software ADO.NET Provider for Basecamp with the DevExpress Windows Forms and Web controls to provide Basecamp to a chart.
Access Live BigQuery Data in Tableau with CData API Server

With CData API Server, easily create OData endpoints for live BigQuery data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
Build a Simple VCL Application for Xero

How to build a simple VCL Application to view Xero Accounting in RAD Studio using the CData ODBC Driver for Xero.
Create Dynamic Coinbase Grids Using the Infragistics XamDataGrid

Learn how you can connect Coinbase to Infragistics XamDataGrid to build dynamic grids.
Use Biml to Build SSIS Tasks to Replicate SAP Concur to SQL Server

Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAP Concur to SQL Server.
Use the CData Software JDBC Driver for MariaDB in MicroStrategy Web

Connect to MariaDB in MicroStrategy Web using the CData Software JDBC Driver for MariaDB.
Automate Jira Service Management Tasks in Power Automate Using CData API Server

With CData API Server, easily create OData endpoints for live Atlassian Jira Service Management and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
LINQ to ShipStation

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 ShipStation Data Provider.
Automated Continuous CockroachDB Replication to Apache Kafka

Use CData Sync for automated, continuous, customizable CockroachDB replication to Apache Kafka.
Connect to Marketo from Filemaker Pro (Mac)

Use CData Connect AI to connect to and query live Marketo from Filemaker Pro on Mac.
Add Acumatica to Informatica Enterprise Data Catalog

Use the CData Software JDBC Driver for Acumatica with the Informatica Enterprise Data Catalog to classify and organize data.
Connect to Avalara AvaTax from a Connection Pool in Jetty

The Avalara AvaTax JDBC Driver supports connection pooling: This article shows how to connect faster to Avalara AvaTax from Web apps in Jetty.
Visualize Live Active Directory in Power BI (via CData Connect AI)

Use the CData Power BI Connector and CData Connect AI to integrate live Active Directory into custom reports in Power BI.
Creating Jira Service Management-Connected Applications in Unqork

You can use CData Connect AI to feed Atlassian Jira Service Management to Unqork and build custom business apps.
Analyze Kintone in Infragistics Reveal

Use the CData API Server to create an OData API on top of Kintone and visualize live Kintone in Infragistics Reveal.
Access Live Azure DevOps in Google Sheets through Connect Spreadsheets

Use Connect Spreadsheets by CData to gain access to live Azure DevOps from your Google Sheets.
Stream ServiceNow into Apache Kafka Topics

Access and stream ServiceNow in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
Connect to XML in HULFT Integrate

Connect to XML as a JDBC data source in HULFT Integrate
Load SAS xpt to a Database Using Embulk

Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SAS XPORT to a database.
Build AI/ML Models with Live Amazon Marketplace Data using Dataiku