CData Software - Knowledge Base
Recent Articles
-
Analyze RSS Feeds in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of RSS Feeds and visualize the live Feeds in Slingshot (formerly Reveal BI) for seamless insights.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Drift
Provide connectivity to Drift through an SAP BusinessObjects universe.
-
Viewing SAP SuccessFactors LMS Data in RAD Studio Data Explorer
How to view SAP SuccessFactors LMS in RAD Studio Data Explorer using the CData ODBC Driver for SAP SuccessFactors LMS.
-
Access Live HubSpot Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live HubSpot from your Excel spreadsheets.
-
Connect Wistia Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Wistia using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Use the CData Software JDBC Driver for Nuclia in MicroStrategy Desktop
Connect to Nuclia in MicroStrategy Desktop using the CData Software JDBC Driver for Nuclia.
-
Explore Geographical Relationships in Quickbase Data with Power Map
Create data visualizations with Quickbase in Power Map.
-
Easily Integrate LinkedIn Ads Data in Lazarus Pascal IDE
Learn how to easily integrate live LinkedIn Ads in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create Datasets from Redis in Domo Workbench and Build Visualizations of Redis Data in Domo
Use the CData Software ODBC Driver for Redis to create datasets from Redis in Domo Workbench and then build visualizations in the Domo service.
-
Create Reports with Microsoft Entra ID Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft Entra ID.
-
Automated Continuous Shopify Replication to Vertica
Use CData Sync for automated, continuous, customizable Shopify replication to Vertica.
-
Access Mixpanel Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Mixpanel from HeidiSQL.
-
Connect to Bright Data Data from a Connection Pool in Jetty
The Bright Data JDBC Driver supports connection pooling: This article shows how to connect faster to Bright Data from Web apps in Jetty.
-
Create Datasets from Jodoo in Domo Workbench and Build Visualizations of Jodoo Data in Domo
Use the CData Software ODBC Driver for Jodoo to create datasets from Jodoo in Domo Workbench and then build visualizations in the Domo service.
-
How to Connect to & Open Phoenix Data in Microsoft Excel
This article uses the CData ODBC driver for Phoenix to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Mailjet Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Mailjet and the SQL Gateway to access Mailjet from Google Apps Script.
-
Connect to LinkedIn 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 LinkedIn.
-
Edit and Search External Presto Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Presto to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Presto Data objects that you can access from apps and the dashboard.
-
How to work with Act CRM Data in Apache Spark using SQL
Access and process Act CRM Data in Apache Spark using the CData Software JDBC Driver.
-
Build Voice Agents in ElevenLabs with access to Live Bullhorn CRM Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Bullhorn CRM.
-
Excel Spreadsheet Automation on Facebook Data with the QUERY Formula
Pull data from Facebook, automate spreadsheets, and more with the QUERY formula.
-
Query Helpscout Data in ColdFusion
Write standard ColdFusion data access code to connect to Helpscout.
-
Connect to Shippo Data from a Connection Pool in JBoss
Integrate Shippo into Java servlets: Use the Management Console in JBoss to install the Shippo JDBC Driver.
-
Connecting Moonlit Workflow with Odoo Data 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 Odoo ERP in real time.
-
Use the CData Software ODBC Driver for Monday.com in MicroStrategy Desktop
Connect to Monday.com in MicroStrategy Desktop using the CData Software ODBC Driver for Monday.com.
-
Connect to Salesforce Marketing Data from PowerBuilder via ADO.NET
This article demonstrates how to access Salesforce Marketing Cloud from Appeon PowerBuilder using the CData ADO.NET Provider for Salesforce Marketing.
-
Connect to Coda Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Coda as an External Source in Dremio.
-
How to Easily Query Elasticsearch Data in OpenOffice Base
Connect to Elasticsearch data in OpenOffice Base using the CData ODBC Driver for Elasticsearch and generate reports with live data insights.
-
Automated Continuous Float Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Float replication to Google Cloud SQL.
-
Automated Continuous Vault CRM Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Vault CRM replication to delimited files (CSV/TSV).
-
DataBind Controls to Xero Data in C++Builder
DataBind to Xero Accounting in C++Builder with standard components and controls.
-
Create Datasets from Paylocity in Domo Workbench and Build Visualizations of Paylocity Data in Domo
Use the CData Software ODBC Driver for Paylocity to create datasets from Paylocity in Domo Workbench and then build visualizations in the Domo service.
-
How to Connect Square Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Square data in real time using natural language.
-
Connect to Instantly Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Instantly to connect to Instantly and execute queries in PowerBuilder.
-
How to Connect to Oracle Eloqua Reporting Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Oracle Eloqua Reporting. Leverage the pyodbc module for ODBC in Python.
-
How to connect PolyBase to Google Tasks
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google Tasks.
-
Extend Google Sheets with Avalara AvaTax Data
Make calls to Avalara AvaTax from Google Apps Script via the API Server.
-
Create Informatica Mappings From/To an ODBC Data Source for SFTP
Create an ODBC connection to SFTP in Informatica and browse and transfer SFTP.
-
Automated Continuous Google Ad Manager Replication to SingleStore
Use CData Sync for automated, continuous, customizable Google Ad Manager replication to SingleStore.
-
Connect to IBM Cloud Object Storage 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 IBM Cloud Object Storage.
-
Connect to Foursquare Data from a Connection Pool in Jetty
The Foursquare JDBC Driver supports connection pooling: This article shows how to connect faster to Foursquare from Web apps in Jetty.
-
Import Zuora Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Zuora. In this article, you will use the OData format to import Zuora into Microsoft Power Query.
-
Connect to Shopify Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Shopify using standard SQL.
-
Integrate Real-Time Access to Smartsheet in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Smartsheet in real time.
-
Getting Started with the CData Excel Add-In for Asana
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Asana.
-
Query Pinterest Data as a MySQL Database in Node.js
Execute MySQL queries against Pinterest from Node.js.
-
Integrate Stack Exchange Data in the Pentaho Report Designer
Publish reports based on Stack Exchange in the Pentaho BI tool.
-
Connect to Act-On Data from a Connection Pool in Jetty
The Act-On JDBC Driver supports connection pooling: This article shows how to connect faster to Act-On from Web apps in Jetty.
-
Create Informatica Mappings From/To a JDBC Data Source for SendInBlue
Create SendInBlue data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Dashboards with Salesforce CRM Analytics Data in Dundas BI
Create dynamic dashboards and perform analytics based on Salesforce CRM Analytics in Dundas BI.
-
DataBind Charts to Postmark Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Postmark 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 Confluence Data from a Connection Pool in JBoss
Integrate Atlassian Confluence into Java servlets: Use the Management Console in JBoss to install the Confluence JDBC Driver.
-
How to update Zoho CRM from Excel
This article explains how to transfer data from Excel to Zoho CRM using the Excel Add-In for Zoho CRM.
-
Build Automated Workflows with Live Microsoft Ads Data in Workato
Use CData Connect AI to connect to live Microsoft Ads and build automated workflows in Workato.
-
How to Easily Query Mouseflow Data in OpenOffice Base
Connect to Mouseflow data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to JDBC-ODBC Bridge Data from a Connection Pool in JBoss
Integrate JDBC-ODBC Bridge into Java servlets: Use the Management Console in JBoss to install the JDBC-ODBC Bridge JDBC Driver.
-
Integrate LibreChat with Live Tally Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Tally ERP from within the chat interface.
-
Integrating Boomi Agentstudio with ActiveCampaign Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to ActiveCampaign, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Migrating data from Marketo to Snowflake using CData SSIS Components.
Easily push Marketo to Snowflake using the CData SSIS Tasks for Marketo and Snowflake.
-
Choosing the Best Method to Connect ZohoExpense to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ZohoExpense from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use the CData Software JDBC Driver for Oracle Eloqua in MicroStrategy
Connect to Oracle Eloqua in MicroStrategy Developer using the CData Software JDBC Driver for Oracle Eloqua.
-
Connect to Zoho Projects Data in CloverDX (formerly CloverETL)
Transfer Zoho Projects using the visual workflow in the CloverDX data integration tool.
-
How to Connect Flowise AI Agents to Live Amazon DynamoDB 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 Amazon DynamoDB without replication.
-
Connect to Avaza Data from PowerBuilder via ADO.NET
This article demonstrates how to access Avaza from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Use the CData Software ODBC Driver for Zendesk in MicroStrategy
Connect to Zendesk in MicroStrategy Developer using the CData Software ODBC Driver for Zendesk.
-
Enable the Dynamics 365 JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Microsoft Dynamics 365.
-
Create Informatica Mappings From/To an ODBC Data Source for Sage Intacct
Create an ODBC connection to Sage Intacct in Informatica and browse and transfer Sage Intacct.
-
Feed Excel Data into FineReport
How to set Microsoft Excel as a JDBC data source in FineReport.
-
Connect Campaigner to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Campaigner using the CData Python MCP Server.
-
How to Work with Auth0 Data in ETL Validator JDBC
Connect to Auth0 from ETL Validator jobs using the CData Software JDBC Driver.
-
Write a Simple Go Application to work with Helpscout Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Helpscout.
-
Access Discord Data from MySQL in PHP
Connect to Discord through the standard MySQL libraries in PHP.
-
Seamlessly Bring SAP Ariba Source Data into Retool Using CData Connect AI
Integrate SAP Ariba Source data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Rapidly Develop LightSpeedRetail-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 LightSpeedRetail.
-
Model, Search, and Visualize Live Act CRM Data in ThoughtSpot
Use CData Connect AI to connect to live Act CRM for modeling, searching, and visualizing.
-
Automated Continuous HCL Domino Replication to SQL Server
Use CData Sync for automated, continuous, customizable HCL Domino replication to SQL Server.
-
Automated Continuous Aircall Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Aircall replication to PostgreSQL.
-
DataBind Controls to GitLab Data in C++Builder
DataBind to GitLab in C++Builder with standard components and controls.
-
Create CapsuleCRM Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time CapsuleCRM data access from reports, embedded analytics, and more.
-
How to create Visio diagrams from Databricks Data
Automatically update Databricks with the changes you make to Visio master shapes.
-
Seamlessly Bring Microsoft Entra ID Data into Retool Using CData Connect AI
Integrate Microsoft Entra ID data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Working with Adobe Commerce Data in LINQPad
Execute LINQ queries to Adobe Commerce in LINQPad.
-
How to connect to Calendly Data with Squirrel SQL client
Connect to Calendly and execute queries in the Squirrel SQL Client.
-
Query Pipeliner CRM Data in ColdFusion
Write standard ColdFusion data access code to connect to Pipeliner CRM.
-
How to integrate Invoiced with Apache Airflow
Access and process Invoiced in Apache Airflow using the CData JDBC Driver.
-
Use the CData Software JDBC Driver for Hive in MicroStrategy
Connect to Apache Hive in MicroStrategy Developer using the CData Software JDBC Driver for Hive.
-
Replicate LinkedIn Data in Heroku for Use in Salesforce Connect
Replicate LinkedIn to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Object-Relational Mapping (ORM) with SAP HANA Data 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 SAP HANA into a Java-based ORM framework, Hibernate.
-
Replicate DB2 for i Data to Multiple Databases via the CData Sync CLI
Replicate DB2 for i to disparate databases with a single configuration.
-
Connect to EnterpriseDB Data from HeidiSQL
Use CData Connect AI to connect to and query live EnterpriseDB from HeidiSQL.
-
Access Salesforce Data in QlikView Using the CData ODBC Driver for Salesforce
The CData ODBC drivers expand your ability to work with data from a wide variety of data sources. For example, you can use the ODBC drivers to create visualizations that organize and present your Salesforce data in QlikView. In this article we outline simple steps to use CData ODBC Drivers from QlikView.
-
Model Freshservice Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Freshservice, enabling the direct import of real-time Freshservice.
-
Integrate ChartMogul with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate ChartMogul with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to ChartMogul.
-
Integrate LibreChat with Live Facebook Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Facebook Ads from within the chat interface.
-
Migrating data from AfterShip to Databricks using CData SSIS Components.
Easily push AfterShip to Databricks using the CData SSIS Tasks for AfterShip and Databricks.
-
Automate Float Data Replication to Azure Synapse
Use CData Sync to customize and automate Float replication to Azure Synapse.
-
Use the CData ODBC Driver for SAP Ariba Procurement from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SAP Ariba Procurement to connect to SAP Ariba Procurement from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SAP Ariba Procurement in Excel.
-
Use the CData Software JDBC Driver for Dropbox in MicroStrategy Web
Connect to Dropbox in MicroStrategy Web using the CData Software JDBC Driver for Dropbox.
-
Integrating Cursor CLI with Zoom 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.
-
Back Up SageHR to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with SageHR data.