CData Software - Knowledge Base
Recent Articles
-
Connect to Parquet Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Parquet as an External Source in Dremio.
-
Automated Continuous Zoho CRM Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Zoho CRM replication to OneLake in Microsoft Fabric.
-
Build Greenhouse-Connected Apps in Choreo
Use CData Connect AI to connect to Greenhouse Data from Choreo and build custom apps using live Greenhouse.
-
Use the CData Software ODBC Driver for Neo4J in MicroStrategy Desktop
Connect to Neo4J in MicroStrategy Desktop using the CData Software ODBC Driver for Neo4J.
-
Seamlessly Bring Presto Data into Retool Using CData Connect AI
Integrate Presto data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Integrate MessageBird Data in the Pentaho Report Designer
Publish reports based on MessageBird in the Pentaho BI tool.
-
Connect to Teradata Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Teradata using standard SQL.
-
How to publish and share FHIR Data dashboards with Tableau Server
The CData ODBC driver for FHIR enables you integrate FHIR into Tableau dashboards.
-
How to Connect to SAP Business Warehouse Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SAP Business Warehouse. Leverage the pyodbc module for ODBC in Python.
-
Build Avro-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Avro to explore live Avro Data in Gemini Code Assist to assist with building Avro-powered applications.
-
Build SAP SuccessFactors-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SAP SuccessFactors and build web apps with connectivity to live SAP SuccessFactors.
-
Connect to QuickBooks Online Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for QuickBooks Online in the Denodo Virtual DataPort Administrator.
-
Edit and Search External Google Search Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Google Search to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Google Search Results objects that you can access from apps and the dashboard.
-
Visualize Shippo 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 Shippo into TIBCO Spotfire.
-
Integrating Antigravity CLI with Bullhorn CRM via CData CLI
Connect Bullhorn CRM to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to SAP Business One Data from a Connection Pool in JBoss
Integrate SAP Business One into Java servlets: Use the Management Console in JBoss to install the SAP Business One JDBC Driver.
-
Work with Live Zoho Projects Data in Power Query
Use CData Connect AI to connect to Zoho Projects and work with live Zoho Projects in Microsoft Power Query.
-
Connect to Monday.com Data in DBArtisan
Use wizards in DBArtisan to configure Monday.com as a data source.
-
How to Work with SAP Fieldglass Data in ETL Validator JDBC
Connect to SAP Fieldglass from ETL Validator jobs using the CData Software JDBC Driver.
-
How to update Act-On from Excel
This article explains how to transfer data from Excel to Act-On using the Excel Add-In for Act-On.
-
Replicate Chargebee Data to Multiple Databases
Replicate Chargebee to disparate databases with a point-and-click configuration.
-
Moving Data from Close to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Close data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Use Microsoft Copilot Studio to talk to your Freshservice 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 Freshservice for you.
-
Automated Continuous Procore Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Procore replication to Amazon S3.
-
Write a Simple Go Application to work with Invoiced Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Invoiced.
-
Toggl Reporting in OBIEE with the Toggl JDBC Driver
Deploy the Toggl JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to ADP Data in Aqua Data Studio
Access ADP from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Amazon S3
Provide connectivity to Amazon S3 through an SAP BusinessObjects universe.
-
How to Connect to Live DocuSign 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 DocuSign without replication.
-
Connect to WooCommerce Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time WooCommerce using standard SQL.
-
Excel Spreadsheet Automation on AgileCRM Data with the QUERY Formula
Pull data from AgileCRM, automate spreadsheets, and more with the QUERY formula.
-
Analyze SAP BusinessObjects BI Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of SAP BusinessObjects BI and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Automated Continuous Epicor Kinetic Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Epicor Kinetic replication to Amazon Redshift.
-
Bind Live Sage 300 Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Sage 300 data
-
Create Power BI XMLA-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Power BI XMLA Data from Klipfolio and build custom visualizations using live Power BI XMLA.
-
Viewing ADP Data in RAD Studio Data Explorer
How to view ADP in RAD Studio Data Explorer using the CData ODBC Driver for ADP.
-
Getting Started with the CData Excel Add-In for Dynamics CRM
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Dynamics CRM.
-
How to Work with ServiceNow Data in AWS Glue Jobs Using JDBC
Connect to ServiceNow from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use Biml to Build SSIS Tasks to Replicate Microsoft Exchange Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Microsoft Exchange to SQL Server.
-
Viewing Box Data in RAD Studio Data Explorer
How to view Box in RAD Studio Data Explorer using the CData ODBC Driver for Box.
-
Query Live Sage Intacct 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 Sage Intacct directly from the development environment.
-
Build Agents in Relevance AI with Access to Live Paylocity Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Paylocity within intelligent agent workflows.
-
Automate Reckon Accounts Hosted Data Replication to SAP HANA
Use CData Sync to customize and automate Reckon Accounts Hosted replication to SAP HANA.
-
Load Anaplan Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Anaplan to a database.
-
Replicate Oracle SCM Data to Multiple Databases via the CData Sync CLI
Replicate Oracle SCM to disparate databases with a single configuration.
-
DataBind Charts to QuickBooks Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to QuickBooks Desktop 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 Quaderno in SpagoBI
Create reports featuring live Quaderno in SpagoBI Studio. Host Quaderno reports on SpagoBI Server.
-
Configure the CData JDBC Driver for Pipedrive in a Connection Pool in Tomcat
Connect to Pipedrive from a connection pool in Tomcat.
-
How to Connect to Microsoft Entra ID Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Microsoft Entra ID. Leverage the pyodbc module for ODBC in Python.
-
Object-Relational Mapping (ORM) with Timely 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 Timely into a Java-based ORM framework, Hibernate.
-
Access Trello 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 Trello.
-
Integrating RSS Feeds in Talend Cloud Data Management Platform
Connect RSS Feeds with Talend Cloud Data Management Platform using the CData JDBC Driver for RSS.
-
Connect to LightSpeedRetail Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for LightSpeedRetail in the Denodo Virtual DataPort Administrator.
-
Build OneNote-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Microsoft OneNote and build web apps with connectivity to live Microsoft OneNote.
-
Publish SurveyMonkey-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SurveyMonkey.
-
Integrate MessageBird Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live MessageBird from Informatica Cloud.
-
Visualize Gmail Data in Sisense
Create an ElastiCube in Sisense app with access to Gmail.
-
Back Up Presto to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Presto. In this article, we will employ an SSIS workflow to populate a database with Presto data.
-
Load Smartsheet Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Smartsheet to a database.
-
Use the CData Software JDBC Driver for Databricks in MicroStrategy Desktop
Connect to Databricks in MicroStrategy Desktop using the CData Software JDBC Driver for Databricks.
-
Access Live ChartMogul Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate ChartMogul into the statistical analysis tools available in SAS JMP. This article shows how to use ChartMogul in the Graph Builder and Query Builder.
-
Rapidly Develop Google Campaign Manager 360-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 Google Campaign Manager 360.
-
Feed SAP Hybris C4C Data into FineReport
How to set SAP Hybris C4C as a JDBC data source in FineReport.
-
Connect to and Visualize Live Azure Data Catalog Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Azure Data Catalog.
-
Integrating OpenCode Terminal with Act-On 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 Live SAP BusinessObjects BI Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your SAP BusinessObjects BI for you.
-
Replicate Smartsheet Data to Multiple Databases
Replicate Smartsheet to disparate databases with a point-and-click configuration.
-
Connect to AfterShip Data from PowerBuilder via JDBC
This article demonstrates how to access AfterShip from PowerBuilder using the AfterShip JDBC Driver.
-
Access Live Xero Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Xero data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Connect to MYOB AccountRight Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for MYOB AccountRight.
-
Build a Singer.io Tap for Contentful With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Contentful data using
-
Integrating Dataiku with GitHub Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live GitHub.
-
Automated Continuous Shopify Replication to SQL Server
Use CData Sync for automated, continuous, customizable Shopify replication to SQL Server.
-
Provide OData Services of PabblySubscriptions Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for PabblySubscriptions by developing a WCF Service Application.
-
How to create Sage 200 federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Sage 200 in MySQL .
-
Design BIRT Reports on Microsoft OneDrive Data
Provide current Microsoft OneDrive to your embedded analytics.
-
Use the CData Software JDBC Driver for Presto in MicroStrategy
Connect to Presto in MicroStrategy Developer using the CData Software JDBC Driver for Presto.
-
Query Zendesk Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Zendesk and perform CRUD operations on Zendesk from Node.js.
-
Visualize Live Opsgenie Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Opsgenie.
-
Building Dynamic Web Pages with XML Data Using AngularJS
Create single-page applications with live connectivity to XML using the CData API Server.
-
Connect Factorial to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Factorial using the CData Python MCP Server.
-
Automated Continuous Hive Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Apache Hive replication to OneLake in Microsoft Fabric.
-
Integrating Antigravity CLI with Pipeline CRM via CData CLI
Connect Pipeline CRM to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
View Reports on Real-Time Float Data in Power BI Report Server
Use the CData ODBC Driver for Float to visualize Float in Power BI Desktop and then publish them to Power BI Report Server.
-
Working with Redis Data in LINQPad
Execute LINQ queries to Redis in LINQPad.
-
How to connect to Gong Data from Spring Boot
Connect to Gong in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to Neo4J Data in Claris FileMaker Pro
Use the CData ODBC Driver for Neo4J in FileMaker Pro to connect to Neo4J and work with Neo4J in your FileMaker applications.
-
Use the CData Software JDBC Driver for Mode in MicroStrategy Web
Connect to Mode in MicroStrategy Web using the CData Software JDBC Driver for Mode.
-
Configure the CData JDBC Driver for WordPress in a Connection Pool in Tomcat
Connect to WordPress from a connection pool in Tomcat.
-
Build Wistia-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Wistia.
-
Access Live MYOB AccountRight Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live MYOB AccountRight through MCP integration.
-
Use the CData Software JDBC Driver for Twilio in MicroStrategy Web
Connect to Twilio in MicroStrategy Web using the CData Software JDBC Driver for Twilio.
-
Connect to and Query Tanda Data in QlikView over ODBC
Create data visualizations with Tanda in QlikView.
-
Access Front Data from MySQL in Amazon QuickSight
Connect to Front and build visualizations of Front using a MySQL Connection in Amazon QuickSight.
-
How to connect to Coinbase Data with Squirrel SQL client
Connect to Coinbase and execute queries in the Squirrel SQL Client.
-
How to Visualize WordPress Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live WordPress in Python.
-
Automated Continuous Insightly Replication to Vertica
Use CData Sync for automated, continuous, customizable Insightly replication to Vertica.
-
Connect to Chargebee Data from PowerBuilder via ADO.NET
This article demonstrates how to access Chargebee from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Use the CData Software ODBC Driver for ChargeOver in MicroStrategy Web
Connect to ChargeOver in MicroStrategy Web using the CData Software ODBC Driver for ChargeOver.
-
Integrate GitLab Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live GitLab from Informatica Cloud.