CData Software - Knowledge Base
Recent Articles
-
How to Connect to Live Exact Online Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Exact Online for you.
-
Integrate Cursor with Live eBay Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live eBay from within the editor.
-
Access SpaceX Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SpaceX from HeidiSQL.
-
Integrating Jira Assets Data in Talend Cloud Data Management Platform
Connect Jira Assets Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Jira Assets.
-
Connect to IBM Informix Data in RazorSQL
Connect to IBM Informix from wizards and query IBM Informix from the GUI in the RazorSQL database management tool.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Paylocity
Provide connectivity to Paylocity through an SAP BusinessObjects universe.
-
Helpscout Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Helpscout facts in real time.
-
Natively Connect to Mode Data in PHP
The CData ODBC driver for Mode enables you to create PHP applications with connectivity to Mode. Leverage the native support for ODBC in PHP.
-
How to connect to SuiteCRM Data in DBVisualizer
Integrate SuiteCRM with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Apps from Dynamics 365 Business Central Data in Qlik Sense Cloud
Use CData Connect AI to connect to Dynamics 365 Business Central Data and build apps from live Dynamics 365 Business Central in Qlik Sense Cloud.
-
Create Datasets from Webex in Domo Workbench and Build Visualizations of Webex Data in Domo
Use the CData Software ODBC Driver for Webex to create datasets from Webex in Domo Workbench and then build visualizations in the Domo service.
-
Getting Started with the CData Tableau Connector for Certinia
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Certinia.
-
Replicate Shippo Data in Heroku for Use in Salesforce Connect
Replicate Shippo to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Edit and Search Google Campaign Manager 360 External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Google Campaign Manager 360 to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Google Campaign Manager 360 objects that you can access from apps and the dashboard.
-
Connect Databricks to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Databricks using the CData Python MCP Server.
-
How to Connect to Live Acumatica Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Acumatica ERP securely in real time.
-
A PostgreSQL Interface for NetSuite Data using the CData ODBC Driver
Use the SQL Gateway and NetSuite ODBC Driver to create a PostgreSQL entry-point for data access.
-
Model MarkLogic Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and MarkLogic, enabling the direct import of real-time MarkLogic.
-
Analyze Timely Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Timely and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Natively Connect to XML Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to XML Files. Leverage the native support for ODBC in PHP.
-
Access Live Cvent Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Cvent through MCP integration.
-
Build GitHub-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for GitHub to explore live GitHub Data in Cursor to assist with building GitHub-powered applications.
-
How to Connect to Live Google Sheets 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 Google Sheets for you.
-
Build Visualizations of Teamgate Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Teamgate in Birst.
-
Getting Started with the CData ODBC Driver for Teamwork
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Teamwork.
-
Automated Continuous Invoiced Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Invoiced replication to Azure SQL Database.
-
Access Live SAS Data Sets 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 SAS Data Sets through MCP integration.
-
Integrate Live Dynamics 365 Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Dynamics 365 from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Microsoft Dynamics 365.
-
Access Zendesk Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Zendesk from HeidiSQL.
-
Connect to and Query Active Directory Data in QlikView over ODBC
Create data visualizations with Active Directory in QlikView.
-
Access Live CockroachDB 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 CockroachDB through MCP integration.
-
How to Design REST Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to REST from mobile and tablet Power Apps.
-
Build Foursquare-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData API Driver for MCP Server to explore live Foursquare Data in Gemini Code Assist to assist with building Foursquare-powered applications.
-
Connect to Acumatica Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Acumatica Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to Snapchat Ads 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 Snapchat Ads.
-
Connect to and Query ZohoSubscriptions Data in QlikView over ODBC
Create data visualizations with ZohoSubscriptions in QlikView.
-
Connect to Cloudflare Data in DBeaver
Use the CData ODBC Driver to connect to Cloudflare in DBeaver.
-
Integrate Open WebUI with Live Dynamics CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Microsoft Dynamics CRM from within the chat interface.
-
Build AlloyDB-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to AlloyDB Data from Zoho Analytics and import live Google AlloyDB.
-
Visualize Productboard Data in Tableau
The CData ODBC driver for Productboard enables you integrate Productboard into Tableau dashboards.
-
Seamlessly Bring Zoho Inventory Data into Retool Using CData Connect AI
Integrate Zoho Inventory data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
LINQ to Bitly Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Bitly Data Provider.
-
Use Databricks Agent Bricks to Talk to Your Dropbox Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Dropbox for you.
-
Visualize Pipedrive Data in TIBCO Spotfire through ADO.NET
Integrate Pipedrive into dashboards in TIBCO Spotfire.
-
How to import Pinterest Data into Apache Solr
Use the CData Software JDBC Driver for Pinterest in Data Import Handler and create an automated import of Pinterest to Apache Solr Enterprise Search platform.
-
Create Power BI Reports on Real-Time EnterpriseDB Data
Use the CData ODBC Driver for EnterpriseDB to visualize EnterpriseDB in Power BI Desktop.
-
Snowflake Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Snowflake through CData Connect AI using different applications and tools.
-
Natively Connect to MailerSend Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to MailerSend. Leverage the native support for ODBC in PHP.
-
Create Reports with Shortcut Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Shortcut.
-
How to connect PolyBase to Billsby
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Billsby.
-
Create Couchbase-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Couchbase Data from OutSystems and build custom enterprise apps using live Couchbase.
-
Access Live QuickBooks Online Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live QuickBooks Online data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Access Live PayPal Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live PayPal data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Integrate Cline with Live Snapchat Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Snapchat Ads from within your IDE.
-
Integrating Kiro CLI with Dynamics NAV 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 Visualize PostgreSQL Data in Python with pandas
Use pandas and other modules to analyze and visualize live PostgreSQL in Python.
-
Automated Continuous Box Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Box replication to OneLake in Microsoft Fabric.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed ZohoPeople to Power BI dashboards. Simply drag and drop ZohoPeople into data visuals on the Power BI canvas.
-
Use the CData Software ODBC Driver for Presto in MicroStrategy Desktop
Connect to Presto in MicroStrategy Desktop using the CData Software ODBC Driver for Presto.
-
Provide OData Services of Cvent Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Cvent by developing a WCF Service Application.
-
Access Live Tanda Data in Coginiti Pro
Connect to and query live Tanda from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use the CData Software ODBC Driver for Cloudflare in MicroStrategy Desktop
Connect to Cloudflare in MicroStrategy Desktop using the CData Software ODBC Driver for Cloudflare.
-
Build ZohoPeople-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live ZohoPeople.
-
A PostgreSQL Interface for Cvent Data using the CData ODBC Driver
Use the SQL Gateway and Cvent ODBC Driver to create a PostgreSQL entry-point for data access.
-
DataBind Charts to ZohoExpense Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to ZohoExpense 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 Google Sheets Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Google Sheets Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Create Informatica Mappings From/To an ODBC Data Source for Zuora
Create an ODBC connection to Zuora in Informatica and browse and transfer Zuora.
-
How to connect to Adobe Target Data in DBVisualizer
Integrate Adobe Target with visual data analysis tools and data connection wizards in DBVisualizer
-
Trigger Sybase IQ IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Sybase IQ with standard wizards in Logic Apps.
-
Connect to Oracle Service Cloud Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Oracle Service Cloud.
-
Automated Continuous Cosmos DB Replication to MySQL
Use CData Sync for automated, continuous, customizable Cosmos DB replication to MySQL.
-
How to Connect to Live SAP Ariba Procurement Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live SAP Ariba Procurement securely in real time.
-
Automated Continuous Excel Replication to SQL Server
Use CData Sync for automated, continuous, customizable Excel replication to SQL Server.
-
Automated Continuous AdRoll Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable AdRoll replication to delimited files (CSV/TSV).
-
Access Wistia Data from MySQL in Amazon QuickSight
Connect to Wistia and build visualizations of Wistia using a MySQL Connection in Amazon QuickSight.
-
Create Data Visualizations Based On Dropbox Data in Mode
Use CData Connect AI to connect to Dropbox Data from Mode and build visualizations using live
-
Automated Continuous Recurly Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Recurly replication to delimited files (CSV/TSV).
-
Access Live Zoom Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Zoom into the statistical analysis tools available in SAS JMP. This article shows how to use Zoom in the Graph Builder and Query Builder.
-
Access Live Parquet Data in AWS Lambda
Connect to live Apache Parquet in AWS Lambda using the CData JDBC Driver.
-
Build Airtable-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Airtable to explore live Airtable Data in Gemini Code Assist to assist with building Airtable-powered applications.
-
Replicate Amazon S3 Data from PowerShell
Write a quick PowerShell script to query Amazon S3. Use connectivity to the live data to replicate Amazon S3 to SQL Server.
-
Automated Continuous Aweber Replication to Oracle
Use CData Sync for automated, continuous, customizable Aweber replication to Oracle.
-
Connect to HubSpot from a Connection Pool in WebLogic
Use the CData JDBC Driver for HubSpot to connect to HubSpot from Web applications running on WebLogic.
-
Create Dynamic Recurly Grids Using the Infragistics XamDataGrid
Learn how you can connect Recurly to Infragistics XamDataGrid to build dynamic grids.
-
Integrating Kiro CLI with Recurly 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.
-
Using the CData Software ODBC Driver for Dynamics CRM in PyCharm
Connect to Dynamics CRM as an ODBC data source in PyCharm using the CData Software ODBC Driver for Dynamics CRM.
-
Build Hive-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Apache Hive and build web apps with connectivity to live Apache Hive.
-
Easily Integrate Mode Data in Lazarus Pascal IDE
Learn how to easily integrate live Mode in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrating OpenCode Terminal with SAP Business One 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.
-
Build NetSuite-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for NetSuite Data and create custom apps in Mendix.
-
Work with Access Data in FoxPro
Load Microsoft Access into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use the CData Software ODBC Driver for Gumroad in SAS for Real-Time Reporting and Analytics
Connect to real-time Gumroad in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Gumroad.
-
Automate Office 365 Data Replication to Azure Synapse
Use CData Sync to customize and automate Microsoft Office 365 replication to Azure Synapse.
-
How to Connect to Live Excel Online 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 Microsoft Excel Online without replication.
-
Migrating data from EmailOctopus to Snowflake using CData SSIS Components.
Easily push EmailOctopus to Snowflake using the CData SSIS Tasks for EmailOctopus and Snowflake.
-
Connect to Smartsheet from Asprova with CData Software ODBC Driver for Smartsheet
This article shows how to connect faster to Smartsheet data from Asprova.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Raisers Edge NXT to Power BI dashboards. Simply drag and drop Raisers Edge NXT into data visuals on the Power BI canvas.
-
Create Data Visualizations in Cognos BI with Short.io Data
Access Short.io as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to use SQLAlchemy ORM to access Raisers Edge NXT Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Raisers Edge NXT.
-
Create Apps from Workday Data in Qlik Sense Cloud
Use CData Connect AI to connect to Workday Data and build apps from live Workday in Qlik Sense Cloud.