CData Software - Knowledge Base
Recent Articles
-
Using the CData Software ODBC Driver for eBay Analytics in PyCharm
Connect to eBay Analytics as an ODBC data source in PyCharm using the CData Software ODBC Driver for eBay Analytics.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Optimizely
Provide connectivity to Optimizely through an SAP BusinessObjects universe.
-
How to Connect the Power BI Service to GraphQL: Complete Guide
Connect to the CData Software Power BI Connector for GraphQL from PowerBI.com to provide real-time GraphQL across the organization.
-
Connect to Certinia from Asprova with CData Software ODBC Driver for Certinia
This article shows how to connect faster to Certinia data from Asprova.
-
Replicate Multiple Drift Accounts via the CData Sync CLI
Replicate multiple Drift accounts to one or many databases.
-
Access Live Google Sheets Data in Coginiti Pro
Connect to and query live Google Sheets from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Manage Shortcut Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Shortcut.
-
Replicate Greenplum Data from PowerShell
Write a quick PowerShell script to query Pivotal GreenPlum. Use connectivity to the live data to replicate Pivotal GreenPlum to SQL Server.
-
Access Live WordPress Data in AWS Lambda (with IntelliJ IDEA)
Connect to live WordPress in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Freshteam Data in HULFT Integrate
Connect to Freshteam as a JDBC data source in HULFT Integrate
-
Getting Started with the CData JDBC Driver for Copper
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Copper.
-
Use the CData SSIS Components to Insert New or Update Existing Azure Synapse Records from SQL Server
Easily push SQL Server data to Azure Synapse using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Azure Synapse or update existing records with data from a SQL Server database.
-
Integrating Claude Code with Okta Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Okta within assisted coding and automated development workflows.
-
Migrating data from Shortcut to Databricks using CData SSIS Components.
Easily push Shortcut to Databricks using the CData SSIS Tasks for Shortcut and Databricks.
-
Query Azure Synapse Data as a SQL Server Database in Node.js
Execute SQL Server queries against Azure Synapse from Node.js.
-
Edit and Search Confluence External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Atlassian Confluence to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Confluence objects that you can access from apps and the dashboard.
-
Bridge Demio Connectivity with Apache NiFi
Access and process Demio in Apache NiFi using the CData JDBC Driver.
-
Build Semantic Layer Views for Spark Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Apache Spark SQL.
-
Visualize Everhour Data in TIBCO Spotfire through ADO.NET
Integrate Everhour into dashboards in TIBCO Spotfire.
-
How to Connect to Live PayPal Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your PayPal for you.
-
How to connect to Asana Data from Spring Boot
Connect to Asana in a Spring Boot Application using the CData JDBC Driver for Asana
-
Add Shippo Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Shippo with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Goose with Live LinkedIn Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live LinkedIn from within the local AI agent.
-
Use the CData ODBC Driver for SAP Netweaver Gateway in Microsoft Power Query
You can use the CData SAP Netweaver Gateway ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SAP Netweaver Gateway into Microsoft Power Query.
-
Integrate with live SAP SuccessFactors Data in Jitterbit
Use CData Connect AI to connect to and integrate live SAP SuccessFactors in Jitterbit.
-
Connect to Dynamics 365 Business Central Data in ACL Analytics
Connect to Dynamics 365 Business Central via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Dynamics 365 Business Central.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live MailChimp using the Model Context Protocol.
-
Access Live FreeAgent Data in Coginiti Pro
Connect to and query live FreeAgent from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use the CData SSIS Components to Insert New or Update Existing Spark Records from SQL Server
Easily push SQL Server data to Spark using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Spark or update existing records with data from a SQL Server database.
-
How to Connect to Live Zoho Inventory Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Zoho Inventory without replication.
-
Replicate Multiple Ontraport Accounts via the CData Sync CLI
Replicate multiple Ontraport accounts to one or many databases.
-
Easily Integrate LaunchDarkly Data in Lazarus Pascal IDE
Learn how to easily integrate live LaunchDarkly in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Drip Data in HULFT Integrate
Connect to Drip as a JDBC data source in HULFT Integrate
-
Process & Analyze Outreach.io Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Outreach.io Data.
-
DataBind Controls to EnterpriseDB Data in C++Builder
DataBind to EnterpriseDB in C++Builder with standard components and controls.
-
Connect to Real-Time Webflow Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Webflow in Power Apps.
-
Access Short.io Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Short.io from your Oracle system.
-
Automated Continuous SAP SuccessFactors Replication to Oracle
Use CData Sync for automated, continuous, customizable SAP SuccessFactors replication to Oracle.
-
Replicate Pipeliner CRM Data to Multiple Databases
Replicate Pipeliner CRM to disparate databases with a point-and-click configuration.
-
How to Connect the Power BI Service to ServiceDesk Plus: Complete Guide
Connect to the CData Software Power BI Connector for ServiceDesk Plus from PowerBI.com to provide real-time ServiceDesk Plus across the organization.
-
Create Data Visualizations in Cognos BI with SAS Data Sets Data
Access SAS Data Sets as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Access ShipStation Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access ShipStation from your Oracle system.
-
Build Apps with Live Avalara AvaTax Data Using the Low-Code Development Platform of Mendix
Connect Avalara AvaTax with Mendix to build apps using the CData JDBC Driver for Avalara AvaTax.
-
Visualize Live BigQuery Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Google BigQuery using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Consume Square OData Feeds in PowerBuilder
This article demonstrates how to consume Square as OData feeds from PowerBuilder using the API Server.
-
Connect to Live Quickbase Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Quickbase in CData Connect AI and connect to your Quickbase from PostgreSQL.
-
Connect to Stripe Data from Crystal Reports
Use CData Connect AI to connect to and report on live Stripe from Crystal Reports.
-
Access JDBC-ODBC Bridge Data 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 JDBC-ODBC Bridge.
-
Integrating Kiro CLI with SAP Business One Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Create Gong-Connected Applications in Appsmith
Connect to Gong Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Gong.
-
Use Microsoft Copilot Studio to talk to your NetSuite Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your NetSuite CRM & ERP for you.
-
Access Live Phoenix Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Phoenix data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Publish ChargeOver-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ChargeOver.
-
Analyze Dynamics NAV Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Microsoft Dynamics NAV and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Create Data Visualizations Based On BambooHR Data in Mode
Use CData Connect AI to connect to BambooHR Data from Mode and build visualizations using live
-
Automated Continuous MySQL Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable MySQL replication to Amazon Redshift.
-
Integrate Goose with Live Adobe Commerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Adobe Commerce from within the local AI agent.
-
How to Design Highrise Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Highrise from mobile and tablet Power Apps.
-
Use Dash to Build to Web Apps on Tavily Data
Create Python applications that use pandas and Dash to build Tavily-connected web apps.
-
Build a PostgreSQL Interface for Delighted Data using the CData JDBC Driver
Use the Remoting features of the Delighted JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect PolyBase to Hacker News
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Hacker News.
-
Getting Started with the CData Python Connector for FHIR
Learn to install and license the CData Python Connector
-
Connect to BigCommerce Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live BigCommerce.
-
How to Connect the Power BI Service to Access: Complete Guide
Connect to the CData Software Power BI Connector for Access from PowerBI.com to provide real-time Microsoft Access across the organization.
-
How to Build an ETL App for Parallel Data in Python with CData
Create ETL applications and real-time data pipelines for Parallel in Python with petl.
-
Bridge Copper Connectivity with Apache NiFi
Access and process Copper in Apache NiFi using the CData JDBC Driver.
-
DataBind Grafana Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Grafana to a chart.
-
Getting Started with the CData Power BI Connector for GraphQL
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for GraphQL.
-
Connect to Keap Data in RapidMiner
Integrate Keap with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Oracle HCM Cloud Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Oracle HCM Cloud using standard SQL.
-
Edit and Search Wave Financial External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Wave Financial to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Wave Financial objects that you can access from apps and the dashboard.
-
Integrate Goose with Live Amazon S3 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Amazon S3 from within the local AI agent.
-
Automated Continuous Salesloft Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Salesloft replication to Apache Kafka.
-
Integrate LibreChat with Live Oracle Sales Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Oracle Sales from within the chat interface.
-
Natively Connect to Harvest Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Harvest. Leverage the native support for ODBC in PHP.
-
Integrating Kiro CLI with Oracle Eloqua Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
How to Connect to & Open Autopilot Data in Microsoft Excel
This article uses the CData ODBC driver for Autopilot to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Live BigQuery Data in MicroStrategy through CData Connect AI
Create a live connection to BigQuery Data in CData Connect AI and connect to your Google BigQuery from MicroStrategy.
-
Configure the CData JDBC Driver for PayPal in a Connection Pool in Tomcat
Connect to PayPal from a connection pool in Tomcat.
-
Visualize Airtable Data in Sisense
Create an ElastiCube in Sisense app with access to Airtable.
-
Build a Simple VCL Application for PingOne Data
How to build a simple VCL Application to view PingOne in RAD Studio using the CData ODBC Driver for PingOne.
-
Enable the Accelo JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Accelo.
-
How to work with iContact Data in Apache Spark using SQL
Access and process iContact Data in Apache Spark using the CData Software JDBC Driver.
-
Integrate eBay Data in the Pentaho Report Designer
Publish reports based on eBay in the Pentaho BI tool.
-
Use the CData ODBC Driver for Sage Intacct from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Sage Intacct to connect to Sage Intacct from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Sage Intacct in Excel.
-
Use the CData Software JDBC Driver for Landbot in MicroStrategy Web
Connect to Landbot in MicroStrategy Web using the CData Software JDBC Driver for Landbot.
-
How to integrate OpenWeatherMap with Apache Airflow
Access and process OpenWeatherMap in Apache Airflow using the CData JDBC Driver.
-
How to connect to ZohoDesk Data from IntelliJ
Integrate connectivity to ZohoDesk with wizards in IntelliJ.
-
Connect to SAP SuccessFactors LMS Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for SAP SuccessFactors LMS in Airbyte.
-
Integrate Real-Time Access to QuickBooks in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to QuickBooks Desktop in real time.
-
Rapidly Develop IBM Cloud Object Storage-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by IBM Cloud Object Storage.
-
Validate Chargebee Data with QuerySurge
Access and validate Chargebee in QuerySurge using the CData JDBC Driver.
-
Automated Continuous BenchmarkEmail Replication to SQL Server
Use CData Sync for automated, continuous, customizable BenchmarkEmail replication to SQL Server.
-
Connect to Tanda Data in JRuby
Create a simple JRuby app with access to live Tanda.
-
How to create Cloudflare federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Cloudflare in MySQL .
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for RSS
Provide connectivity to RSS Feeds through an SAP BusinessObjects universe.
-
Build AI Agents with Oracle Financials Cloud Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Oracle Financials Cloud through CData Connect AI.
-
Getting Started with the CData Tableau Connector for Hacker News
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
How to create an RPA flow for ChargeOver Data in UiPath Studio
Use the ChargeOver ODBC Driver to create workflows that access real-time ChargeOver without any coding.
-
Import Real-Time Copper Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Copper in ColdFusion.