CData Software - Knowledge Base
Recent Articles
-
Query Wave Financial Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Wave Financial from Node.js.
-
ETL Chargebee in Oracle Data Integrator
This article shows how to transfer Chargebee into a data warehouse using Oracle Data Integrator.
-
How to connect to Salesforce Data 360 Data with Squirrel SQL client
Connect to Salesforce Data 360 and execute queries in the Squirrel SQL Client.
-
Connect to Mixpanel Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Automated Continuous EmailOctopus Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable EmailOctopus replication to OneLake in Microsoft Fabric.
-
Automate Highrise Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Highrise CRM from PowerShell? This article demonstrates how to utilize the Highrise Cmdlets for tasks like connecting to Highrise CRM, automating operations, downloading data, and more.
-
How to create an RPA flow for Elorus Data in UiPath Studio
Use the Elorus ODBC Driver to create workflows that access real-time Elorus without any coding.
-
Integrating Claude Code with AlloyDB Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Google AlloyDB within assisted coding and automated development workflows.
-
How to Connect to Live Databricks Data 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 Databricks for you.
-
Query SAP Concur Data from Node.js
Use the OData endpoint of the CData API Server to connect to your SAP Concur and perform CRUD operations on SAP Concur from Node.js.
-
Integrating GitHub Copilot CLI with Google AlloyDB 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.
-
ETL SAP Hybris C4C in Oracle Data Integrator
This article shows how to transfer SAP Hybris C4C into a data warehouse using Oracle Data Integrator.
-
How to Connect to & Open Oracle SCM Data in Microsoft Excel
This article uses the CData ODBC driver for Oracle SCM to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrating OpenCode Terminal with Copper 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.
-
DataBind Controls to Bugsnag Data in C++Builder
DataBind to Bugsnag in C++Builder with standard components and controls.
-
Integrate FHIR with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate FHIR with External Services.
-
Visualize LinkedIn Data in TIBCO Spotfire through OData
Integrate LinkedIn into dashboards in TIBCO Spotfire.
-
Getting Started with the CData Excel Add-In for ZohoMarketingHub
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for ZohoMarketingHub.
-
Connect to LeadDesk from a Connection Pool in WebLogic
Use the CData JDBC Driver for LeadDesk to connect to LeadDesk from Web applications running on WebLogic.
-
Configure the CData JDBC Driver for Cassandra in a Connection Pool in Tomcat
Connect to Apache Cassandra from a connection pool in Tomcat.
-
Connect to Sugar CRM Data 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 Sugar CRM.
-
How to connect PolyBase to SAP SuccessFactors LMS
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SAP SuccessFactors LMS.
-
Build Templated-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Templated and build web apps with connectivity to live Templated.
-
How to connect Amazon QuickSight to GitLab Data
Create a connection to GitLab in CData Connect AI and insert GitLab into Amazon QuickSight SPICE to build interactive dashboards.
-
Replicate Multiple SharePoint Excel Services Accounts via the CData Sync CLI
Replicate multiple SharePoint Excel Services accounts to one or many databases.
-
Connect to Mailgun Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Mailgun to connect to Mailgun and execute queries in PowerBuilder.
-
Access Live Tally Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Tally ERP through MCP integration.
-
How to Connect Flowise AI Agents to Live HubSpot Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live HubSpot without replication.
-
Use Dash to Build to Web Apps on Egnyte Data
Create Python applications that use pandas and Dash to build Egnyte-connected web apps.
-
How to connect to Adobe Experience Manager Data in DBVisualizer
Integrate Adobe Experience Manager with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to and Query Grafana Data in QlikView over ODBC
Create data visualizations with Grafana in QlikView.
-
Visualize Mode Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Mode into TIBCO Spotfire.
-
Import Real-Time Shortcut Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Shortcut in ColdFusion.
-
Connect to Confluence Data 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 Atlassian Confluence.
-
How to publish and share Rootly Data dashboards with Tableau Server
The CData ODBC driver for Rootly enables you integrate Rootly into Tableau dashboards.
-
Automated Continuous Avro Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Avro replication to AlloyDB.
-
Access Live Wave Financial Data in Coginiti Pro
Connect to and query live Wave Financial from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build Dashboards with Adobe Analytics Data in DBxtra
Create dynamic dashboards and perform analytics based on Adobe Analytics in DBxtra.
-
Operational Reporting on Placid Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Placid.
-
Natively Connect to Wistia Data in PHP
The CData ODBC driver for Wistia enables you to create PHP applications with connectivity to Wistia. Leverage the native support for ODBC in PHP.
-
Use Dash to Build to Web Apps on CloudConvert Data
Create Python applications that use pandas and Dash to build CloudConvert-connected web apps.
-
Natively Connect to Templated Data in PHP
The CData ODBC driver for Templated enables you to create PHP applications with connectivity to Templated. Leverage the native support for ODBC in PHP.
-
Provide OData Services of Nethunt Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Nethunt by developing a WCF Service Application.
-
Connect to Amazon Marketplace Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Amazon Marketplace Data and connect to Amazon Marketplace in Akorbi Digital RunMyProcess.
-
Use the CData Software ODBC Driver for Stripe in MicroStrategy Desktop
Connect to Stripe in MicroStrategy Desktop using the CData Software ODBC Driver for Stripe.
-
Consume Avro OData Feeds in PowerBuilder
This article demonstrates how to consume Apache Avro as OData feeds from PowerBuilder using the API Server.
-
How to Seamlessly Import Google Forms Data into IBM SPSS Modeler
Integrate Google Forms data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Use the CData API Server to Access Google Search Results in Microsoft PowerPivot
Use the CData API Server to connect to live Google Search in the Power Pivot business intelligence tool.
-
A PostgreSQL Interface for ServiceDesk Plus Data (MySQL Remoting via JDBC)
Use the Remoting features of the ServiceDesk Plus JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use Manus AI to Talk to Your SAP Hybris C4C Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on SAP Hybris C4C.
-
Query Live Neo4J Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Neo4J directly from the development environment.
-
Integrate Cline with Live Zoom Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Zoom from within your IDE.
-
Excel Spreadsheet Automation on Databricks Data with the QUERY Formula
Pull data from Databricks, automate spreadsheets, and more with the QUERY formula.
-
Access Planio 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 Planio.
-
How to import Keap Data into Apache Solr
Use the CData Software JDBC Driver for Keap in Data Import Handler and create an automated import of Keap to Apache Solr Enterprise Search platform.
-
How to Connect to Live Sybase Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Sybase securely in real time.
-
Automated Continuous Parquet Replication to SQL Server
Use CData Sync for automated, continuous, customizable Parquet replication to SQL Server.
-
A PostgreSQL Interface for Microsoft Entra ID Data using the CData ODBC Driver
Use the SQL Gateway and Microsoft Entra ID ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Sentry
Provide connectivity to Sentry through an SAP BusinessObjects universe.
-
Visualize Live Authorize.Net Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Authorize.Net into custom reports in Power BI.
-
Integrating GitHub Copilot CLI with Facebook 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.
-
Connect to MailChimp from Asprova with CData Software ODBC Driver for MailChimp
This article shows how to connect faster to MailChimp data from Asprova.
-
How to Query Live Landbot Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Landbot data in natural language using Python.
-
Provide OData Services of Sendwithus Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Sendwithus by developing a WCF Service Application.
-
Create Apps from Salesforce Pardot Data in Qlik Sense Cloud
Use CData Connect AI to connect to Salesforce Pardot Data and build apps from live Salesforce Pardot in Qlik Sense Cloud.
-
Build Automated Oracle Financials Cloud-Connected Workflows in Zapier
Use CData Connect AI to connect to live Oracle Financials Cloud and build automated workflows in Zapier.
-
Build Semantic Layer Views for Oracle Data in APOS Live Data Gateway
Use the CData Connector for Oracle in APOS Live Data Gateway to build Semantic Layer Views for Oracle Database.
-
Analyze Smartsheet Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Smartsheet from Power Pivot. You will use the Table Import Wizard to load Smartsheet. You can visually build the import query or use any SQL supported by the driver.
-
Migrating data from SAS xpt to Databricks using CData SSIS Components.
Easily push SAS XPORT to Databricks using the CData SSIS Tasks for SAS xpt and Databricks.
-
Visualize Landbot Data in Tableau
The CData ODBC driver for Landbot enables you integrate Landbot into Tableau dashboards.
-
Integrating OpenCode Terminal with EmailOctopus 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.
-
Build Data Flows from SQL Server to HubSpot through SSIS
Easily push SQL Server data to HubSpot using the CData SSIS Tasks for HubSpot.
-
Access Live Jira Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Jira data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to connect to RSS Feeds with Squirrel SQL client
Connect to RSS Feeds and execute queries in the Squirrel SQL Client.
-
LINQ to Mocean Data
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 Mocean Data Provider.
-
Automated Continuous Tally Replication to MySQL
Use CData Sync for automated, continuous, customizable Tally replication to MySQL.
-
Build a Simple VCL Application for LightSpeedRetail Data
How to build a simple VCL Application to view LightSpeedRetail in RAD Studio using the CData ODBC Driver for LightSpeedRetail.
-
How to Connect to CircleCI Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to CircleCI. Leverage the pyodbc module for ODBC in Python.
-
Visualize Live Sugar CRM Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Sugar CRM.
-
How to Connect to Live Microsoft Teams 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 Microsoft Teams without replication.
-
Visualize QuickBooks Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load QuickBooks Desktop into TIBCO Spotfire.
-
Working with Workable Data in LINQPad
Execute LINQ queries to Workable in LINQPad.
-
Query CSV Data in DataGrip
Create a Data Source for CSV in DataGrip and use SQL to query live CSV/TSV Files.
-
How to Build an ETL App for Productboard Data in Python with CData
Create ETL applications and real-time data pipelines for Productboard in Python with petl.
-
Use Dash to Build to Web Apps on Sendwithus Data
Create Python applications that use pandas and Dash to build Sendwithus-connected web apps.
-
Automated Continuous SAP HANA Replication to SingleStore
Use CData Sync for automated, continuous, customizable SAP HANA replication to SingleStore.
-
Create Dashboards and Visualize Live BigCommerce Data in Geckoboard
Use CData Connect AI to connect to live BigCommerce and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect to ChargeOver Data in NetBeans
Connect to ChargeOver in NetBeans with the data source configuration wizard.
-
Choosing the Best Method to Connect SAP to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SAP ERP/NetWeaver from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use Biml to Build SSIS Tasks to Replicate Codat Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Codat to SQL Server.
-
Automate PingOne Integration Tasks from PowerShell
Are you in search of a quick and easy way to access PingOne from PowerShell? This article demonstrates how to utilize the PingOne Cmdlets for tasks like connecting to PingOne, automating operations, downloading data, and more.
-
How to connect to TigerGraph Data from Spring Boot
Connect to TigerGraph in a Spring Boot Application using the CData JDBC Driver for TigerGraph
-
Integrate Theia IDE with Live JSON Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Automated Continuous ShipStation Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable ShipStation replication to Google BigQuery.
-
Connect to Aircall from a Connection Pool in WebLogic
Use the CData JDBC Driver for Aircall to connect to Aircall from Web applications running on WebLogic.
-
Build Dashboards with Everhour Data in Dundas BI
Create dynamic dashboards and perform analytics based on Everhour in Dundas BI.
-
Query Billsby Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Billsby from Node.js.
-
Visualize Brex Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Brex.
-
Analyze Productboard Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Productboard in Microsoft R Open.
-
Automated Continuous MailerLite Replication to Oracle
Use CData Sync for automated, continuous, customizable MailerLite replication to Oracle.