CData Software - Knowledge Base
Recent Articles
-
Create Dynamic Discord Grids Using the Infragistics XamDataGrid
Learn how you can connect Discord to Infragistics XamDataGrid to build dynamic grids.
-
Replicate SAP Fieldglass Data from PowerShell
Write a quick PowerShell script to query SAP Fieldglass. Use connectivity to the live data to replicate SAP Fieldglass to SQL Server.
-
Connect to PagerDuty Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for PagerDuty and the SQL Gateway to access PagerDuty from Google Apps Script.
-
Integrating Cursor CLI with HDFS 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.
-
Connect Quickbase Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Quickbase using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
A PostgreSQL Interface for Webex Data using the CData ODBC Driver
Use the SQL Gateway and Webex ODBC Driver to create a PostgreSQL entry-point for data access.
-
DataBind SurveyMonkey Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for SurveyMonkey with the DevExpress Windows Forms and Web controls to provide SurveyMonkey to a chart.
-
Access Azure Synapse Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Azure Synapse from your Oracle system.
-
DataBind Controls to ZohoMarketingHub Data in C++Builder
DataBind to ZohoMarketingHub in C++Builder with standard components and controls.
-
Getting Started with the CData Excel Add-In for OneNote
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for OneNote.
-
Automated Continuous Aweber Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Aweber replication to Apache Cassandra.
-
How to import Brex Data into Apache Solr
Use the CData Software JDBC Driver for Brex in Data Import Handler and create an automated import of Brex to Apache Solr Enterprise Search platform.
-
Getting Started with the CData SSIS Components for HelloSign
Complete guide to installing, licensing, and connecting with the CData SSIS Components for HelloSign.
-
How to Create Power BI Visual Reports with Real-Time MariaDB Data
Use CData Power BI Connectors to visualize MariaDB in Power BI.
-
Import and Visualize Exact Online Data in Power View
Create data visualizations based on Exact Online in Excel.
-
Use Databricks Agent Bricks to Talk to Your SAP Ariba Source Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your SAP Ariba Source for you.
-
Build an OLAP Cube in SSAS from Foursquare Data
Establish a connection to Foursquare data from SQL Server Analysis Services, and use the Foursquare Data Provider to build OLAP cubes for use in analytics and reporting.
-
Replicate Xero Data from PowerShell
Write a quick PowerShell script to query Xero Accounting. Use connectivity to the live data to replicate Xero Accounting to SQL Server.
-
Connect to and Query ZeroBounce Data in QlikView over ODBC
Create data visualizations with ZeroBounce in QlikView.
-
Connect to Aircall Data in Aqua Data Studio
Access Aircall from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Import Certinia Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Certinia. In this article, you will use the OData format to import Certinia into Microsoft Power Query.
-
Use JayDeBeApi to access Sage Cloud Accounting Data in Python
Use standard Python scripting and the development environment of your choice to access live Sage Business Cloud Accounting.
-
Integrate Act CRM Data in the Pentaho Report Designer
Publish reports based on Act CRM in the Pentaho BI tool.
-
Automated Continuous Salesforce Pardot Replication to Snowflake
Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to Snowflake.
-
Connect to SAP SuccessFactors LMS from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from SAP SuccessFactors LMS, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Presto Data in Jaspersoft Studio
Execute SQL to remote Presto in Jaspersoft Studio.
-
Access Oracle SCM Data from MySQL in Amazon QuickSight
Connect to Oracle SCM and build visualizations of Oracle SCM using a MySQL Connection in Amazon QuickSight.
-
Chargebee Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Chargebee facts in real time.
-
Connect to Odoo Data from AWS Glue
Use CData Connect AI to gain access to live Odoo ERP from your AWS Glue jobs.
-
Getting Started with the CData ODBC Driver for Office 365
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Office 365.
-
Automated Continuous Ontraport Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Ontraport replication to PostgreSQL.
-
Use the CData Software ODBC Driver for Gmail in MicroStrategy Desktop
Connect to Gmail in MicroStrategy Desktop using the CData Software ODBC Driver for Gmail.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Sage 300
Provide connectivity to Sage 300 through an SAP BusinessObjects universe.
-
Integrating GitHub Copilot CLI with SAP Business Warehouse 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 SAP HANA-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to SAP HANA Data from Zoho Analytics and import live SAP HANA.
-
Create GitLab-Connected Dashboards in Grafana
Connect to GitLab Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to GitLab.
-
Use ChatGPT to Talk to Your Microsoft Exchange Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Microsoft Exchange for you.
-
Deploy the ADO.NET Provider for SageHR on an SSRS Report Server
Connect to SageHR from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Use the CData Software ODBC Driver for Vault CRM in SAS for Real-Time Reporting and Analytics
Connect to real-time Veeva Vault & Vault CRM in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Vault CRM.
-
DataBind Controls to Sage 300 Data in C++Builder
DataBind to Sage 300 in C++Builder with standard components and controls.
-
How to integrate CapsuleCRM with Apache Airflow
Access and process CapsuleCRM in Apache Airflow using the CData JDBC Driver.
-
Connect to Presto Data in Ruby
Connect to Presto in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connecting Agentforce with Airtable Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Airtable for you.
-
How to connect to Exa Data in DBVisualizer
Integrate Exa with visual data analysis tools and data connection wizards in DBVisualizer
-
Analyze Salesforce CRM Analytics Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Salesforce CRM Analytics and visualize live Salesforce CRM Analytics in Infragistics Reveal.
-
Object-Relational Mapping (ORM) with Epicor Kinetic 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 Epicor Kinetic into a Java-based ORM framework, Hibernate.
-
How to integrate Metabase with Power BI XMLA Data
Use CData Connect AI to connect to live Power BI XMLA and create an interactive dashboard in Metabase from Power BI XMLA.
-
Automated Continuous DB2 for i Replication to IBM DB2
Use CData Sync for automated, continuous, customizable DB2 for i replication to IBM DB2.
-
Write a Simple Go Application to work with Sage Cloud Accounting Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Sage Business Cloud Accounting.
-
Use the CData SSIS Components to Insert New or Update Existing Salesloft Records from SQL Server
Easily push SQL Server data to Salesloft using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Salesloft or update existing records with data from a SQL Server database.
-
Automated Continuous Printify Replication to SingleStore
Use CData Sync for automated, continuous, customizable Printify replication to SingleStore.
-
Bridge SAP HANA Connectivity with Apache NiFi
Access and process SAP HANA in Apache NiFi using the CData JDBC Driver.
-
Integrate Theia IDE with Live Outreach.io Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Analyze BambooHR Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze BambooHR in Microsoft R Open.
-
Use Dash to Build to Web Apps on Dynamics 365 Business Central Data
Create Python applications that use pandas and Dash to build Dynamics 365 Business Central-connected web apps.
-
Create Power BI Reports on Real-Time MYOB AccountRight Data
Use the CData ODBC Driver for MYOB AccountRight to visualize MYOB AccountRight in Power BI Desktop.
-
Integrating Claude Code CLI with Testmonitor 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 an SAP BusinessObjects Universe on the CData JDBC Driver for SuiteCRM
Provide connectivity to SuiteCRM through an SAP BusinessObjects universe.
-
Connecting Agentforce with Zuora Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Zuora for you.
-
Visualize Greenhouse Data in Tableau
The CData ODBC driver for Greenhouse enables you integrate Greenhouse into Tableau dashboards.
-
Rapidly Develop Billsby-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 Billsby.
-
Automated Continuous Azure Data Catalog Replication to SQL Server
Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to SQL Server.
-
Moving Data from PostgreSQL to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live PostgreSQL data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to SAP HANA XS Advanced Data from PowerBuilder via JDBC
This article demonstrates how to access SAP HANA XS Advanced from PowerBuilder using the SAP HANA XS Advanced JDBC Driver.
-
Connect to SAS xpt Data in DBArtisan
Use wizards in DBArtisan to configure SAS XPORT as a data source.
-
Getting Started with the CData JDBC Driver for Dropbox
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Dropbox.
-
Build Zoho CRM-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Zoho CRM and build web apps with connectivity to live Zoho CRM.
-
Connect to HelloSign Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time HelloSign using standard SQL.
-
Getting Started with the CData Tableau Connector for ZohoPeople
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Connect to DB2 Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time IBM DB2 using standard SQL.
-
Integrating Boomi Agentstudio with Greenplum Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Pivotal GreenPlum, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Natively Connect to OneNote Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Microsoft OneNote. Leverage the native support for ODBC in PHP.
-
Seamlessly Bring FHIR Data into Retool Using CData Connect AI
Integrate FHIR data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Build a Singer.io Tap for Microsoft Teams With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Microsoft Teams data using
-
Use the CData Software JDBC Driver for OpenWeatherMap in MicroStrategy Desktop
Connect to OpenWeatherMap in MicroStrategy Desktop using the CData Software JDBC Driver for OpenWeatherMap.
-
How to work with SendPulse Data in Apache Spark using SQL
Access and process SendPulse Data in Apache Spark using the CData Software JDBC Driver.
-
Create Zoho Inventory-Connected Nintex Workflows
Use CData Connect AI to connect to Zoho Inventory Data from Nintex Workflow Cloud and build custom workflows using live Zoho Inventory.
-
Viewing Notion Data in RAD Studio Data Explorer
How to view Notion in RAD Studio Data Explorer using the CData ODBC Driver for Notion.
-
How to Create Power BI Visual Reports with Real-Time PivotalTracker Data
Use CData Power BI Connectors to visualize PivotalTracker in Power BI.
-
How to Easily Query Bugsnag Data in OpenOffice Base
Connect to Bugsnag data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to Connect the Power BI Service to Strava: Complete Guide
Connect to the CData Software Power BI Connector for Strava from PowerBI.com to provide real-time Strava across the organization.
-
Analyze JSON Services in Looker
Use CData Connect AI to connect to JSON Services from Looker and build custom apps using live JSON.
-
Build Apollo-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Apollo Data from Zoho Analytics and import live Apollo.
-
Replicate Greenhouse Data from PowerShell
Write a quick PowerShell script to query Greenhouse. Use connectivity to the live data to replicate Greenhouse to SQL Server.
-
Connect to Microsoft Ads Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Microsoft Ads Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Analyze Stripe Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Stripe and visualize live Stripe in Infragistics Reveal.
-
Import and Visualize Outreach.io Data in Power View
Create data visualizations based on Outreach.io in Excel.
-
Connect Clari Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Clari using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build Amazon Athena-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Amazon Athena Data from Zoho Analytics and import live Amazon Athena.
-
How to work with AdRoll Data in Apache Spark using SQL
Access and process AdRoll Data in Apache Spark using the CData Software JDBC Driver.
-
How to Connect to & Open HubDB Data in Microsoft Excel
This article uses the CData ODBC driver for HubDB to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Query Everhour Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Everhour from Node.js.
-
A PostgreSQL Interface for CircleCI Data (MySQL Remoting via JDBC)
Use the Remoting features of the CircleCI JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software JDBC Driver for Databricks in MicroStrategy Web
Connect to Databricks in MicroStrategy Web using the CData Software JDBC Driver for Databricks.
-
Connect to SAP Hybris C4C Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SAP Hybris C4C to connect to SAP Hybris C4C and execute queries in PowerBuilder.
-
Connect to and Query MariaDB Data in QlikView over ODBC
Create data visualizations with MariaDB in QlikView.
-
Connect to Gmail Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Gmail Data and connect to Gmail in Akorbi Digital RunMyProcess.
-
Build a PostgreSQL Interface for Pipedrive Data using the CData JDBC Driver
Use the Remoting features of the Pipedrive JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use CData Connect AI to Access JSON Services in Microsoft Power Pivot
Use CData Connect AI to connect to live JSON in the Power Pivot business intelligence tool.
-
How to Connect to Live MYOB AccountRight Data 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 MYOB AccountRight through natural language.