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

CData Software - Knowledge Base

Recent Articles

Use the CData SSIS Components to Insert New or Update Existing IBM Informix Records from SQL Server

Easily push SQL Server data to IBM Informix using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into IBM Informix or update existing records with data from a SQL Server database.
How to connect PolyBase to YouTube Analytics

Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live YouTube Analytics.
How to Connect to Live Oracle Sales from Gemini CLI (via CData Connect AI)

Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Oracle Sales for you.
Automate Twilio Replication to Azure Synapse

Use CData Sync to customize and automate Twilio replication to Azure Synapse.
Design BIRT Reports on Google Spanner

Provide current Google Spanner to your embedded analytics.
Automated Continuous Microsoft Planner Replication to Oracle

Use CData Sync for automated, continuous, customizable Microsoft Planner replication to Oracle.
Visualize Live API in the Power BI Service

Use CData Connect AI to connect to live API and create custom reports in the Power BI Service through the On-Premises Gateway.
Integrate Real-Time Access to SAP Concur in SAPUI5 MVC Apps

Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SAP Concur in real time.
Connect to and Query Harvest in QlikView over ODBC

Create data visualizations with Harvest in QlikView.
How to connect to Zoho Books from IntelliJ

Integrate connectivity to Zoho Books with wizards in IntelliJ.
DataBind Charts to Monday.com

Use the standard ADO.NET procedures for databinding to provide bidirectional access to Monday.com 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 QuickBooks Time from PowerBuilder via JDBC

This article demonstrates how to access QuickBooks Time from PowerBuilder using the QuickBooks Time JDBC Driver.
Automated Continuous Azure Data Catalog Replication to Azure SQL Database

Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to Azure SQL Database.
Build Power BI XMLA-Connected Web Apps in Servoy

Use Servoy Developer to easily connect to Power BI XMLA and build web apps with connectivity to live Power BI XMLA.
Access Live Facebook Ads in AWS Lambda (with IntelliJ IDEA)

Connect to live Facebook Ads in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
Validate Dynamics CRM with QuerySurge

Access and validate Microsoft Dynamics CRM in QuerySurge using the CData JDBC Driver.
Consume Certinia OData Feeds in PowerBuilder

This article demonstrates how to consume Certinia as OData feeds from PowerBuilder using the API Server.
Integrating Claude Code with Oracle SCM via CData Connect AI

Leverage CData Connect AI to enable Claude Code to securely access and act on Oracle SCM within assisted coding and automated development workflows.
Object-Relational Mapping (ORM) with Epicor Kinetic 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 Epicor Kinetic into a Java-based ORM framework, Hibernate.
How to Connect DBeaver to Oracle HCM Cloud via a JDBC Driver

Manage Oracle HCM Cloud with visual tools in DBeaver like the query browser.
Create Reports from SAP Business One in Looker Studio

Use CData Connect AI to gain access to live SAP Business One and create custom reports in Looker Studio.
Connect to SurveyMonkey as an External Data Source using PolyBase

Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live SurveyMonkey.
Manage Reckon Accounts Hosted in DBArtisan as a JDBC Source

Use wizards in DBArtisan to create a JDBC data source for Reckon Accounts Hosted.
Access IBM Cloud Object Storage from MySQL in Amazon QuickSight

Connect to IBM Cloud Object Storage and build visualizations of IBM Cloud Object Storage using a MySQL Connection in Amazon QuickSight.
How to Access Live DocuSign in Power Automate Desktop via ODBC

The CData ODBC Driver for DocuSign enables you to integrate DocuSign into workflows built using Microsoft Power Automate Desktop.
Extend Google Sheets with Microsoft OneDrive

Make calls to the API Server from Google Apps Script.
Create Datasets from Zoho Inventory in Domo Workbench and Build Visualizations of Zoho Inventory in Domo

Use the CData Software ODBC Driver for Zoho Inventory to create datasets from Zoho Inventory in Domo Workbench and then build visualizations in the Domo service.
Viewing Excel in RAD Studio Data Explorer

How to view Microsoft Excel in RAD Studio Data Explorer using the CData ODBC Driver for Excel.
Publish Crystal Reports on Zoho Creator

Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Zoho Creator.
How to Query Live GraphQL in Perplexity MacOS Desktop

Connect to and query live GraphQL in Perplexity Desktop using the CData MCP Server.
Connect to Coinbase in Jaspersoft Studio

Execute SQL to remote Coinbase in Jaspersoft Studio.
DataBind Controls to Google Calendar in Delphi

DataBind to Google Calendar in Delphi with standard data access components and controls.
How to work with Aha in Apache Spark using SQL

Access and process Aha in Apache Spark using the CData Software JDBC Driver.
How to create an RPA flow for Kintone in UiPath Studio

Use the Kintone ODBC Driver to create workflows that access real-time Kintone without any coding.
How to Easily Query Confluence in OpenOffice Base