CData Software - Knowledge Base
Recent Articles
-
Connect Jumpseller Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Jumpseller using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Use Dash to Build Web Apps on SAP ByDesign Data via CData Connect AI
Build interactive Dash web apps on live SAP Business ByDesign using pandas and the CData Connect AI Python SDK.
-
How to Query Live ZendeskSell Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ZendeskSell data in natural language using Python.
-
Integrate RabbitMQ Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live RabbitMQ from Informatica Cloud.
-
Build a Simple VCL Application for Dynamics CRM Data
How to build a simple VCL Application to view Microsoft Dynamics CRM in RAD Studio using the CData ODBC Driver for Dynamics CRM.
-
Automated Continuous Harvest Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Harvest replication to Google BigQuery.
-
Integrating OpenCode Terminal with Azure Table 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 Gumroad Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Gumroad data access from reports, embedded analytics, and more.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Exact Online
Provide connectivity to Exact Online through an SAP BusinessObjects universe.
-
Integrating Antigravity CLI with ClickUp via CData CLI
Connect ClickUp to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to SAP Concur Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SAP Concur in the Denodo Virtual DataPort Administrator.
-
Provide OData Services of Sentry Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Sentry by developing a WCF Service Application.
-
Connect to and Visualize Live BambooHR Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live BambooHR.
-
Use Claude to Talk to Your SAP BusinessObjects BI Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your SAP BusinessObjects BI for you.
-
Build Perigon-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Perigon.
-
Using the CData Software ODBC Driver for Sage 200 in PyCharm
Connect to Sage 200 as an ODBC data source in PyCharm using the CData Software ODBC Driver for Sage 200.
-
Query Odoo Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Odoo ERP and perform CRUD operations on Odoo from Node.js.
-
Connecting Mastra with Instagram Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Instagram, no replication required.
-
How to import Coinbase Data into Apache Solr
Use the CData Software JDBC Driver for Coinbase in Data Import Handler and create an automated import of Coinbase to Apache Solr Enterprise Search platform.
-
Use the CData API Server to Access QuickBooks Data in Microsoft PowerPivot
Use the CData API Server to connect to live QuickBooks Desktop in the Power Pivot business intelligence tool.
-
How to create an RPA flow for Asana Data in UiPath Studio
Use the Asana ODBC Driver to create workflows that access real-time Asana without any coding.
-
Use Manus AI to Talk to Your Microsoft Dataverse 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 Microsoft Dataverse (CDS).
-
Integrate Real-Time Access to SingleStore in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SingleStore in real time.
-
Migrating data from Zoho Projects to Databricks using CData SSIS Components.
Easily push Zoho Projects to Databricks using the CData SSIS Tasks for Zoho Projects and Databricks.
-
Using the CData Software ODBC Driver for Mailjet in PyCharm
Connect to Mailjet as an ODBC data source in PyCharm using the CData Software ODBC Driver for Mailjet.
-
Connect to and Query HDFS Data in QlikView over ODBC
Create data visualizations with Apache HDFS in QlikView.
-
Choosing the Best Method to Connect Cvent to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Cvent from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous Todoist Replication to SQLite
Use CData Sync for automated, continuous, customizable Todoist replication to SQLite.
-
Connect Avro to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Apache Avro using the CData Python MCP Server.
-
Connect to SQL Analysis Services from Asprova with CData Software ODBC Driver for SQL Analysis Services
This article shows how to connect faster to SQL Analysis Services data from Asprova.
-
Import Real-Time Billsby Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Billsby in ColdFusion.
-
Connect to Postmark from a Connection Pool in WebLogic
Use the CData JDBC Driver for Postmark to connect to Postmark from Web applications running on WebLogic.
-
Provide OData Services of Anaplan Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Anaplan by developing a WCF Service Application.
-
Integrate Microsoft OneDrive Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Microsoft OneDrive from Informatica Cloud.
-
Viewing Azure Data Lake Storage Data in RAD Studio Data Explorer
How to view Azure Data Lake Storage in RAD Studio Data Explorer using the CData ODBC Driver for Azure Data Lake Storage.
-
How to connect to Quickbase Data in DBVisualizer
Integrate Quickbase with visual data analysis tools and data connection wizards in DBVisualizer
-
Use Microsoft Copilot Studio to talk to your Sybase 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 Sybase for you.
-
Use Claude to Talk to Your Google Contacts Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Google Contacts for you.
-
Moving Data from Harvest to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Harvest data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Replicate Multiple Sybase IQ Accounts via the CData Sync CLI
Replicate multiple Sybase IQ accounts to one or many databases.
-
Create Datasets from SingleStore in Domo Workbench and Build Visualizations of SingleStore Data in Domo
Use the CData Software ODBC Driver for SingleStore to create datasets from SingleStore in Domo Workbench and then build visualizations in the Domo service.
-
Build AI/ML Models with Live Hacker News Data using Dataiku
Connect Hacker News Data with Dataiku using the CData API Driver for JDBC.
-
Integrate with Live Salesforce CRM Analytics Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Salesforce CRM Analytics from the MuleSoft Anypoint Platform to integrate live Salesforce CRM Analytics into custom reports and dashboards.
-
Access Live Parquet Data in TIBCO Data Virtualization
Use the Parquet Tibco DV Adapter to create a Apache Parquet data source in TIBCO Data Virtualization Studio and gain access to live Apache Parquet from your TDV Server.
-
How to Use a Microsoft Access Database to Update Dynamics 365 Business Central Data in Real Time
Update Dynamics 365 Business Central data by creating a linked table in Microsoft Access with the CData Dynamics 365 Business Central ODBC Driver.
-
Connect to ServiceDesk Plus from Asprova with CData Software ODBC Driver for ServiceDesk Plus
This article shows how to connect faster to ServiceDesk Plus data from Asprova.
-
Visualize Quaderno 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 Quaderno into TIBCO Spotfire.
-
How to Visualize OpenWeatherMap Data in Python with pandas
Use pandas and other modules to analyze and visualize live OpenWeatherMap in Python.
-
Build a Singer.io Tap for Microsoft Dataverse With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Microsoft Dataverse data using
-
Getting Started with the CData Power BI Connector for Accelo
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Import DB2 Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access IBM DB2. In this article, you will use the OData format to import IBM DB2 into Microsoft Power Query.
-
How to Visualize Paylocity Data in Python with pandas
Use pandas and other modules to analyze and visualize live Paylocity in Python.
-
Connect to Zoho CRM Data in Aqua Data Studio
Access Zoho CRM from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrate with LightSpeedRetail Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy LightSpeedRetail to a JSON file on disk.
-
How to Connect Flowise AI Agents to Live Bullhorn CRM 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 Bullhorn CRM without replication.
-
Process & Analyze Telegram Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Telegram Data.
-
Enable the BenchmarkEmail JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with BenchmarkEmail.
-
Automated Continuous Cassandra Replication to SingleStore
Use CData Sync for automated, continuous, customizable Cassandra replication to SingleStore.
-
Enable the Contentful JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Contentful.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Odoo
Provide connectivity to Odoo ERP through an SAP BusinessObjects universe.
-
Integrate Open WebUI with Live Sybase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Sybase from within the chat interface.
-
Import Real-Time iContact Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use iContact in ColdFusion.
-
Seamlessly Bring Raisers Edge NXT Data into Retool Using CData Connect AI
Integrate Raisers Edge NXT data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect to Mocean Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Mocean as an External Source in Dremio.
-
Automated Continuous MySQL Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable MySQL replication to delimited files (CSV/TSV).
-
Rapidly Develop Sybase IQ-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 Sybase IQ.
-
Automated Continuous QuickBooks Online Replication to IBM DB2
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to IBM DB2.
-
Replicate Sage Intacct Data from PowerShell
Write a quick PowerShell script to query Sage Intacct. Use connectivity to the live data to replicate Sage Intacct to SQL Server.
-
Use the CData Software ODBC Driver for Quickbase in MicroStrategy
Connect to Quickbase in MicroStrategy Developer using the CData Software ODBC Driver for Quickbase.
-
Integrating Reckon Data in Talend Cloud Data Management Platform
Connect Reckon Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Reckon.
-
Automated Continuous Amazon Marketplace Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Amazon Marketplace replication to Apache Kafka.
-
Automated Continuous Google Contacts Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Google Contacts replication to Google BigQuery.
-
Access Live Unbounce Data in Coginiti Pro
Connect to and query live Unbounce from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Provide OData Services of Calendly Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Calendly by developing a WCF Service Application.
-
Use CData Connect AI to Access Spark Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Apache Spark SQL in the Power Pivot business intelligence tool.
-
Work with eBay Analytics Data in FoxPro
Load eBay Analytics into a FoxPro database. This article includes full code and a walk-through of the process.
-
Query Azure Data Lake Storage Data in DataGrip
Create a Data Source for Azure Data Lake Storage in DataGrip and use SQL to query live Azure Data Lake Storage.
-
Create OpenWeatherMap Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time OpenWeatherMap data access from reports, embedded analytics, and more.
-
Build Vertica-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Vertica Data and create custom apps in Bubble.
-
ETL CSV in Oracle Data Integrator
This article shows how to transfer CSV/TSV Files into a data warehouse using Oracle Data Integrator.
-
How to Visualize Excel Online Data in Python with pandas
Use pandas and other modules to analyze and visualize live Microsoft Excel Online in Python.
-
Integrating OpenCode Terminal with Monday.com 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 Square 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 Square for you.
-
Getting Started with the CData ODBC Driver for CloudConvert
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for CloudConvert.
-
How to use SQLAlchemy ORM to access Blackbaud FE NXT Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Blackbaud FE NXT.
-
Deploy the ADO.NET Provider for Cloudant on an SSRS Report Server
Connect to IBM Cloudant 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.
-
Build AI/ML Models with Live RabbitMQ Data using Dataiku
Connect RabbitMQ Data with Dataiku using the CData API Driver for JDBC.
-
Import SAP BusinessObjects BI Data Using Azure Data Factory
Use CData Connect AI to connect to SAP BusinessObjects BI Data from Azure Data Factory and import live SAP BusinessObjects BI.
-
How to connect to Shippo Data with Squirrel SQL client
Connect to Shippo and execute queries in the Squirrel SQL Client.
-
How to Connect to Hacker News Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Hacker News. Leverage the pyodbc module for ODBC in Python.
-
Connect to Float Data in Jaspersoft Studio
Execute SQL to remote Float in Jaspersoft Studio.
-
Deploy the ADO.NET Provider for Jira on an SSRS Report Server
Connect to Atlassian Jira 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.
-
Replicate HubSpot Data from PowerShell
Write a quick PowerShell script to query HubSpot. Use connectivity to the live data to replicate HubSpot to SQL Server.
-
Integrate Live SAP Fieldglass Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SAP Fieldglass and integrate live SAP Fieldglass into apps built in Microsoft Power Apps.
-
Connect to Highrise Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Highrise to connect to Highrise CRM and execute queries in PowerBuilder.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SAP BusinessObjects BI using the Model Context Protocol.
-
Access Live Hubstaff Data in AWS Lambda
Connect to live Hubstaff in AWS Lambda using the CData JDBC Driver.
-
Migrating data from GitLab to Snowflake using CData SSIS Components.
Easily push GitLab to Snowflake using the CData SSIS Tasks for GitLab and Snowflake.
-
How to Create Power BI Visual Reports with Real-Time Reckon Accounts Hosted Data
Use CData Power BI Connectors to visualize Reckon Accounts Hosted in Power BI.
-
Visualize MessageBird 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 MessageBird into TIBCO Spotfire.