CData Software - Knowledge Base
Recent Articles
-
How to Connect to Live Oracle Sales from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Oracle Sales through natural language.
-
Choosing the Best Method to Connect HubDB to SQL Server: 5 Options Explained
Discover multiple ways to connect and use HubDB from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Visualize Live CockroachDB in the Power BI Service
Use CData Connect AI to connect to live CockroachDB and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Migrating data from Sybase IQ to Google BigQuery using CData SSIS Components.
Easily push Sybase IQ to Google BigQuery using the CData SSIS Tasks for Sybase IQ and Google BigQuery.
-
How to connect to Oracle Eloqua from Spring Boot
Connect to Oracle Eloqua in a Spring Boot Application using CData JDBC Oracle Eloqua Driver
-
Connect and Query Live Databricks Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Databricks into Databricks
-
How to connect and process Zoho CRM from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Zoho CRM.
-
Connecting Moonlit Workflow with ShipStation via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your ShipStation in real time.
-
Access GraphQL in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for GraphQL.
-
Integrating LangChain with Redshift via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Amazon Redshift within automated workflows.
-
Object-Relational Mapping (ORM) with Oracle Financials Cloud 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 Oracle Financials Cloud into a Java-based ORM framework, Hibernate.
-
Connect to Google Cloud Storage in RazorSQL
Connect to Google Cloud Storage from wizards and query Google Cloud Storage from the GUI in the RazorSQL database management tool.
-
How to Build an ETL App for Azure DevOps in Python with CData
Create ETL applications and real-time data pipelines for Azure DevOps in Python with petl.
-
Use the CData Software ODBC Driver for Dynamics 365 in MicroStrategy Web
Connect to Microsoft Dynamics 365 in MicroStrategy Web using the CData Software ODBC Driver for Dynamics 365.
-
Build Charts with Sage 200 in Clear Analytics
Create dynamic charts and perform analytics based on Sage 200 in Clear Analytics.
-
Connect to Google Directory from AWS Glue
Use CData Connect AI to gain access to live Google Directory from your AWS Glue jobs.
-
Build Automated Workflows with Live Bullhorn CRM in Workato
Use CData Connect AI to connect to live Bullhorn CRM and build automated workflows in Workato.
-
Connect to Salesforce Marketing in RazorSQL
Connect to Salesforce Marketing from wizards and query Salesforce Marketing Cloud from the GUI in the RazorSQL database management tool.
-
How to Connect to Reckon in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Reckon. Leverage the pyodbc module for ODBC in Python.
-
Connect to Couchbase in HULFT Integrate
Connect to Couchbase as a JDBC data source in HULFT Integrate
-
Create SSAS Tabular Models from HubDB
How to build a SQL Server Analysis Service Tabular Model from HubDB using CData drivers.
-
Integrating Boomi Agentstudio with Adobe Analytics via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Adobe Analytics, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Automated Continuous Google Calendar Replication to Oracle
Use CData Sync for automated, continuous, customizable Google Calendar replication to Oracle.
-
Query Google Spanner through ODBC in Node.js
Use node-odbc to execute SQL queries against Google Spanner from Node.js.
-
Connect to Presto from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Presto from Filemaker Pro on Mac.
-
Import Excel Online Using Azure Data Factory
Use CData Connect AI to connect to Excel Online from Azure Data Factory and import live Microsoft Excel Online.
-
Use Azure AI Foundry to Talk to Your Sage Cloud Accounting via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Sage Business Cloud Accounting for you.
-
Create Data Visualizations Based On Epicor Kinetic in Mode
Use CData Connect AI to connect to Epicor Kinetic from Mode and build visualizations using live
-
Connect to Pinterest in JRuby
Create a simple JRuby app with access to live Pinterest.
-
Automated Continuous Drift Replication to MySQL
Use CData Sync for automated, continuous, customizable Drift replication to MySQL.
-
Import Office 365 into the Power BI Service for Visualizations
Use CData Connect AI to connect to Office 365 and provide access to live Microsoft Office 365 for custom reports in the Power BI Service.
-
Consume eBay OData Feeds in SAP Lumira
Use the API Server to create data visualizations on eBay feeds that reflect any changes in SAP Lumira.
-
How to Connect to Live CockroachDB from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your CockroachDB through natural language.
-
Bridge Azure Active Directory Connectivity with Apache NiFi
Access and process Azure Active Directory in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous Harvest Replication to MySQL
Use CData Sync for automated, continuous, customizable Harvest replication to MySQL.
-
Provide OData Services of Odoo from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Odoo ERP by developing a WCF Service Application.
-
Automated Continuous SAP Ariba Source Replication to Oracle
Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to Oracle.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SAS xpt
Provide connectivity to SAS XPORT through an SAP BusinessObjects universe.
-
Use the CData ODBC Driver for Klipfolio from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Klipfolio to connect to Klipfolio from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Klipfolio in Excel.
-
Automated Continuous Adobe Commerce Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to Google Cloud SQL.
-
Connect to Quickbase from HeidiSQL
Use CData Connect AI to connect to and query live Quickbase from HeidiSQL.
-
Integrate WooCommerce in Pentaho Data Integration
Build ETL pipelines based on WooCommerce in the Pentaho Data Integration tool.
-
Edit and Search SAP Concur External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of SAP Concur to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create SAP Concur objects that you can access from apps and the dashboard.
-
Analyze Avro in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Apache Avro in Microsoft R Open.
-
Access Live HubSpot in Coginiti Pro
Connect to and query live HubSpot from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous HCL Domino Replication to MySQL
Use CData Sync for automated, continuous, customizable HCL Domino replication to MySQL.
-
Connect to Zoho Books in Google Apps Script via SQL Gateway
Use the ODBC Driver for Zoho Books and the SQL Gateway to access Zoho Books from Google Apps Script.
-
How to use SQLAlchemy ORM to access Microsoft Planner in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Microsoft Planner.
-
Replicate Vertica to Multiple Databases via the CData Sync CLI
Replicate Vertica to disparate databases with a single configuration.
-
How to Work with LinkedIn in AWS Glue Jobs Using JDBC
Connect to LinkedIn from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous Microsoft Dataverse Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Microsoft Dataverse replication to Google Cloud SQL.
-
Create Apps from Presto in Qlik Sense Cloud
Use CData Connect AI to connect to Presto and build apps from live Presto in Qlik Sense Cloud.
-
Connecting GenSpark with Sage 200 via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to enterprise data across 300+ systems without any replication or custom integration required.
-
Create Google Campaign Manager 360-Connected Business Apps in AppSheet
Connect to Google Campaign Manager 360 via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Google Campaign Manager 360.
-
Create a Data Access Object for Calendly using JDBI
A brief overview of creating a SQL Object API for Calendly in JDBI.
-
Integrate Freshdesk in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Freshdesk from Informatica Cloud.
-
How to create ServiceNow federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for ServiceNow in MySQL .
-
Automate Azure DevOps Replication to Azure Data Lake
Use CData Sync to customize and automate Azure DevOps replication to Azure Data Lake.
-
Access Live Amazon S3 in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Amazon S3 from your Excel spreadsheets.
-
Build Apps with Live Google Spanner Using the Low-Code Development Platform of Mendix
-