CData Software - Knowledge Base
Recent Articles
-
Use JayDeBeApi to access Mixpanel Data in Python
Use standard Python scripting and the development environment of your choice to access live Mixpanel.
-
Use the CData Software ODBC Driver for Instantly in SAS for Real-Time Reporting and Analytics
Connect to real-time Instantly in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Instantly.
-
Use the CData Software ODBC Driver for Raisers Edge NXT in MicroStrategy Desktop
Connect to Raisers Edge NXT in MicroStrategy Desktop using the CData Software ODBC Driver for Raisers Edge NXT.
-
Access Live Helpscout Data in Coginiti Pro
Connect to and query live Helpscout from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrate Cursor with Live QuickBooks Time Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live QuickBooks Time from within the editor.
-
Enable the SAP Ariba Source JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SAP Ariba Source.
-
Work with Mailjet Data in FoxPro
Load Mailjet into a FoxPro database. This article includes full code and a walk-through of the process.
-
Replicate Multiple Mode Accounts via the CData Sync CLI
Replicate multiple Mode accounts to one or many databases.
-
Import Real-Time LeadDesk Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use LeadDesk in ColdFusion.
-
Create Dynamic MailChimp Grids Using the Infragistics XamDataGrid
Learn how you can connect MailChimp to Infragistics XamDataGrid to build dynamic grids.
-
Write a Simple Go Application to work with Authorize.Net Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Authorize.Net.
-
Configure the CData JDBC Driver for OneNote in a Connection Pool in Tomcat
Connect to Microsoft OneNote from a connection pool in Tomcat.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Jira Assets
Provide connectivity to Jira Assets through an SAP BusinessObjects universe.
-
Integrating Boomi Agentstudio with ShipStation Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to ShipStation, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to Work with Wrike Data in ETL Validator JDBC
Connect to Wrike from ETL Validator jobs using the CData Software JDBC Driver.
-
Getting Started with the CData Connect AI Python SDK for Marketo
Install the CData Connect AI Python SDK to read and write live Marketo with standard DB-API 2.0 Python code.
-
Build Dashboards with Tavily Data in DBxtra
Create dynamic dashboards and perform analytics based on Tavily in DBxtra.
-
Avro Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Apache Avro through CData Connect AI using different applications and tools.
-
Integrate Live MailerLite Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live MailerLite to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrating OpenCode Terminal with Parquet 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.
-
Migrating data from Oracle Financials Cloud to Google BigQuery using CData SSIS Components.
Easily push Oracle Financials Cloud to Google BigQuery using the CData SSIS Tasks for Oracle Financials Cloud and Google BigQuery.
-
Build Oracle Sales-Connected Apps in Choreo
Use CData Connect AI to connect to Oracle Sales Data from Choreo and build custom apps using live Oracle Sales.
-
Explore Geographical Relationships in CouchDB Data with Power Map
Create data visualizations with Apache CouchDB in Power Map.
-
Use Manus AI to Talk to Your Azure Analysis Services 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 Azure Analysis Services.
-
Build Automated Workflows with Live Jira Assets Data in Workato
Use CData Connect AI to connect to live Jira Assets and build automated workflows in Workato.
-
How to publish and share Pipeline CRM Data dashboards with Tableau Server
The CData ODBC driver for Pipeline CRM enables you integrate Pipeline CRM into Tableau dashboards.
-
DataBind Charts to Dynamics 365 Business Central Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Dynamics 365 Business Central 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.
-
Create Apps from Jira Data in Qlik Sense Cloud
Use CData Connect AI to connect to Jira Data and build apps from live Atlassian Jira in Qlik Sense Cloud.
-
Use the CData Software ODBC Driver for Spark in SAS for Real-Time Reporting and Analytics
Connect to real-time Apache Spark SQL in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Spark.
-
Excel Spreadsheet Automation on Instagram Data with the QUERY Formula
Pull data from Instagram, automate spreadsheets, and more with the QUERY formula.
-
Publish Crystal Reports on Demio Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Demio.
-
Create Data Visualizations Based On ServiceNow Data in Mode
Use CData Connect AI to connect to ServiceNow Data from Mode and build visualizations using live
-
Connect to Azure Data Catalog Data from PowerBuilder via JDBC
This article demonstrates how to access Azure Data Catalog from PowerBuilder using the Azure Data Catalog JDBC Driver.
-
Create Stack Exchange Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Stack Exchange from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Access Live Cosmos DB Data in Visual Studio Code via Cline
Run CData MCP Server for Cosmos DB on Windows Subsytem for Linux (WSL) and connect to live Azure Cosmos DB from the Cline extension in Visual Studio Code.
-
Automated Continuous Highrise Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Highrise replication to Google Cloud SQL.
-
How to Query Azure Data Catalog Data in MySQL Workbench
Execute MySQL queries against live Azure Data Catalog from MySQL Workbench.
-
Connect to Azure Table Data in HULFT Integrate
Connect to Azure Table as a JDBC data source in HULFT Integrate
-
Connect to Paddle Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Paddle using standard SQL.
-
Integrate Theia IDE with Live OData Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Natively Connect to Placid Data in PHP
The CData ODBC driver for Placid enables you to create PHP applications with connectivity to Placid. Leverage the native support for ODBC in PHP.
-
Build FreeAgent-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live FreeAgent.
-
Visualize Live Quickbase Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Quickbase into custom reports in Power BI.
-
Connect to Copper from a Connection Pool in WebLogic
Use the CData JDBC Driver for Copper to connect to Copper from Web applications running on WebLogic.
-
Connect to Greenhouse Data from a Connection Pool in Jetty
The Greenhouse JDBC Driver supports connection pooling: This article shows how to connect faster to Greenhouse from Web apps in Jetty.
-
Connect to Paymo Data in NetBeans
Connect to Paymo in NetBeans with the data source configuration wizard.
-
How to Build an ETL App for Adobe Commerce Data in Python with CData
Create ETL applications and real-time data pipelines for Adobe Commerce in Python with petl.
-
Query, Visualize, and Share live FHIR Data in Redash
Use CData Connect AI to connect to live FHIR in Redash for querying, visualizing, and sharing.
-
How to Connect to & Open Parallel Data in Microsoft Excel
This article uses the CData ODBC driver for Parallel to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
A PostgreSQL Interface for ElevenLabs Data using the CData ODBC Driver
Use the SQL Gateway and ElevenLabs ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to integrate Drift with Apache Airflow
Access and process Drift in Apache Airflow using the CData JDBC Driver.
-
Integrating Antigravity CLI with Amazon Redshift via CData CLI
Connect Amazon Redshift to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Natively Connect to Salesforce Marketing Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Salesforce Marketing Cloud. Leverage the native support for ODBC in PHP.
-
Write a Simple Go Application to work with AfterShip Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to AfterShip.
-
Create Microsoft OneDrive Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Microsoft OneDrive from PowerBI.com to create Power BI Dataflows with real-time data.
-
Access Smartsheet Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Smartsheet from HeidiSQL.
-
Stripe Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Stripe facts in real time.
-
Import Real-Time SQL Analysis Services Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SQL Analysis Services in ColdFusion.
-
How to connect and process Instantly from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Instantly.
-
Analyze HCL Domino Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze HCL Domino in Microsoft R Open.
-
Getting Started with the CData ODBC Driver for Quaderno
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Quaderno.
-
How to connect and process Pipeline CRM from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Pipeline CRM.
-
Feed Testmonitor Data into FineReport
How to set Testmonitor as a JDBC data source in FineReport.
-
Create a Data Access Object for Google Cloud Storage Data using JDBI
A brief overview of creating a SQL Object API for Google Cloud Storage in JDBI.
-
How to Connect to Live DocuSign 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 DocuSign for you.
-
Connect to SageHR Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SageHR.
-
Visualize Live Smartsheet Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Smartsheet using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Guru-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Guru and build web apps with connectivity to live Guru.
-
Connect to Aha! Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Aha! as an External Source in Dremio.
-
Connect to Amazon Marketplace Data from a Connection Pool in Jetty
The Amazon Marketplace JDBC Driver supports connection pooling: This article shows how to connect faster to Amazon Marketplace from Web apps in Jetty.
-
Use the CData API Server to Access Acumatica Data in Microsoft PowerPivot
Use the CData API Server to connect to live Acumatica ERP in the Power Pivot business intelligence tool.
-
How to connect to Paddle Data in DBVisualizer
Integrate Paddle with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate Goose with Live Freshservice Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Freshservice from within the local AI agent.
-
Integrate Live Impala Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Apache Impala and integrate live Apache Impala into apps built in Microsoft Power Apps.
-
Viewing Monday.com Data in RAD Studio Data Explorer
How to view Monday.com in RAD Studio Data Explorer using the CData ODBC Driver for Monday.com.
-
Automated Continuous Sage 200 Replication to SQLite
Use CData Sync for automated, continuous, customizable Sage 200 replication to SQLite.
-
Automate MarkLogic Data Replication to Couchbase
Use CData Sync to Customize and automate MarkLogic replication to Couchbase.
-
Integrate with Airtable Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Airtable to a JSON file on disk.
-
Replicate Multiple CData Connect AI Accounts
Replicate multiple CData Connect AI accounts to one or many databases.
-
How to connect to Square Data with Squirrel SQL client
Connect to Square and execute queries in the Squirrel SQL Client.
-
How to Import Data from Email into Google Sheets
Import Email into a Google spreadsheet that is automatically refreshed.
-
How to use SQLAlchemy ORM to access Salesloft Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Salesloft.
-
Hooking into Google Apps With CData Google Data Provider
Mike Gold reviews the CData Google Data Provider on C# Corner: This is a review of a component called the CData Google Data Provider which allows you to access the Google API through a SQL-like Data Provider interface. This provider opens up the entire Google Application Suite to the .NET developer through familiar ADO.NET tools and classes.
-
Access SparkPost Data from MySQL in Amazon QuickSight
Connect to SparkPost and build visualizations of SparkPost using a MySQL Connection in Amazon QuickSight.
-
Connect to RSS Feeds Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for RSS and the Script function in FileMaker Pro to connect to RSS and work with RSS Feeds in your FileMaker application.
-
A PostgreSQL Interface for FTP Data (MySQL Remoting via JDBC)
Use the Remoting features of the FTP JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software JDBC Driver for HBase in MicroStrategy
Connect to Apache HBase in MicroStrategy Developer using the CData Software JDBC Driver for HBase.
-
Access Live Adobe Commerce Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Adobe Commerce from your Excel spreadsheets.
-
How to Access Live SendPulse Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SendPulse enables you to integrate SendPulse into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Impala Replication to SQLite
Use CData Sync for automated, continuous, customizable Impala replication to SQLite.
-
Access Live ADP 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 ADP through MCP integration.
-
Connect to HBase Data in RazorSQL
Connect to HBase from wizards and query Apache HBase from the GUI in the RazorSQL database management tool.
-
Explore Geographical Relationships in Clockify Data with Power Map
Create data visualizations with Clockify in Power Map.
-
Build Voice Agents in ElevenLabs with access to Live Epicor Kinetic Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Epicor Kinetic.
-
How to Build an ETL App for OnePageCrm Data in Python with CData
Create ETL applications and real-time data pipelines for OnePageCrm in Python with petl.
-
Connect to Mistral AI Data from PowerBuilder via ADO.NET
This article demonstrates how to access Mistral AI from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Build Data Flows from Authorize.Net to SQL Server using SSIS
Easily back up Authorize.Net to SQL Server using the SSIS components for Authorize.Net.
-
Connect to JobNimbus Data from PowerBuilder via ADO.NET
This article demonstrates how to access JobNimbus from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to connect to MYOB AccountRight Data with Squirrel SQL client
Connect to MYOB AccountRight and execute queries in the Squirrel SQL Client.
-
Automate Square Data Replication to Azure Data Lake
Use CData Sync to customize and automate Square replication to Azure Data Lake.