CData Software - Knowledge Base
Recent Articles
-
Use the CData Software ODBC Driver for BigCommerce in MicroStrategy
Connect to BigCommerce in MicroStrategy Developer using the CData Software ODBC Driver for BigCommerce.
-
Connect and Visualize Live SAP Fieldglass Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live SAP Fieldglass into the Databricks platform and create visualization dashboards with real-time SAP Fieldglass.
-
Access Live Snowflake 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 Snowflake through MCP integration.
-
Connect to Gumroad from Asprova with CData Software ODBC Driver for Gumroad
This article shows how to connect faster to Gumroad data from Asprova.
-
Connect to Outlook Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live FTP Servers using the Model Context Protocol.
-
Build SendGrid-Connected Apps in Choreo
Use CData Connect AI to connect to SendGrid Data from Choreo and build custom apps using live SendGrid.
-
Create Reports with Wrike Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Wrike.
-
Use the CData ODBC Driver for Todoist in Microsoft Power Query
You can use the CData Todoist ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Todoist into Microsoft Power Query.
-
Automated Continuous Google Calendar Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Google Calendar replication to Azure SQL Database.
-
Integrating OpenCode Terminal with Brex 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 Query Live SAP Netweaver Gateway Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SAP Netweaver Gateway data in natural language using Python.
-
Connect to ZohoExpense Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ZohoExpense to connect to ZohoExpense and execute queries in PowerBuilder.
-
Integrating Kiro CLI with Google Contacts 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 MVC Applications with Connectivity to Google Sheets Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Google Sheets from an ASP.NET MVC application.
-
MySQL Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on MySQL facts in real time.
-
How to Access Live Monday.com Data in Visual Studio Code via Cline
Run CData MCP Server for Monday.com on Windows Subsytem for Linux (WSL) and connect to live Monday.com from the Cline extension in Visual Studio Code.
-
Automate MariaDB Data Replication to Azure Synapse
Use CData Sync to customize and automate MariaDB replication to Azure Synapse.
-
Connect to Omnisend from Asprova with CData Software ODBC Driver for Omnisend
This article shows how to connect faster to Omnisend data from Asprova.
-
Build Scrapfly-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Scrapfly.
-
Using the CData Software ODBC Driver for Facebook Ads in PyCharm
Connect to Facebook Ads as an ODBC data source in PyCharm using the CData Software ODBC Driver for Facebook Ads.
-
Moving Data from Wave Financial to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Wave Financial data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build Amazon Marketplace-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Amazon Marketplace Data from Zoho Analytics and import live Amazon Marketplace.
-
Use Manus AI to Talk to Your IBM Informix 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 IBM Informix.
-
Connect Adobe Commerce to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Adobe Commerce using the CData Python MCP Server.
-
Automated Continuous Epicor Kinetic Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Epicor Kinetic replication to delimited files (CSV/TSV).
-
Use the CData Software ODBC Driver for Raisers Edge NXT in MicroStrategy
Connect to Raisers Edge NXT in MicroStrategy Developer using the CData Software ODBC Driver for Raisers Edge NXT.
-
How to connect and process Perigon from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Perigon.
-
Use the CData Software ODBC Driver for Cohere in SAS for Real-Time Reporting and Analytics
Connect to real-time Cohere in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Cohere.
-
Build Apps with Live EmailOctopus Data Using the Low-Code Development Platform of Mendix
Connect EmailOctopus with Mendix to build apps using the CData API Driver for JDBC.
-
Visualize Live GitLab Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live GitLab into custom reports in Power BI.
-
Build a Simple VCL Application for Sybase Data
How to build a simple VCL Application to view Sybase in RAD Studio using the CData ODBC Driver for Sybase.
-
Use Azure AI Foundry to Talk to Your Dropbox Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Dropbox for you.
-
Connect Facebook to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Facebook with IBM WebSphere for seamless data integration and connectivity.
-
How to update BigCommerce from Excel
This article explains how to transfer data from Excel to BigCommerce using the Excel Add-In for BigCommerce.
-
Automated Continuous REST Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable REST replication to OneLake in Microsoft Fabric.
-
Automate Microsoft Dataverse Data Replication to Couchbase
Use CData Sync to Customize and automate Microsoft Dataverse (CDS) replication to Couchbase.
-
Automated Continuous SAS xpt Replication to Vertica
Use CData Sync for automated, continuous, customizable SAS xpt replication to Vertica.
-
Connect to Real-Time OData Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for OData and Dataflow to import and use OData in Power Apps.
-
How to connect SharePoint with SAP Netweaver Gateway Data through external lists
Provide SAP Netweaver Gateway to SharePoint users as an external list.
-
Query Pinterest Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Pinterest entities in PHP by modeling them as objects.
-
Feed Paylocity Data into FineReport
How to set Paylocity as a JDBC data source in FineReport.
-
xBase Reporting in OBIEE with the xBase JDBC Driver
Deploy the xBase JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Configure the CData JDBC Driver for Google Directory in a Connection Pool in Tomcat
Connect to Google Directory from a connection pool in Tomcat.
-
How to connect to Reckon Accounts Hosted Data from IntelliJ
Integrate connectivity to Reckon Accounts Hosted with wizards in IntelliJ.
-
Integrating Codex CLI with Microsoft Exchange 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 to Notion Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Notion in the Denodo Virtual DataPort Administrator.
-
How to update JSON from Excel
This article explains how to transfer data from Excel to JSON using the Excel Add-In for JSON.
-
Load Salesforce CRM Analytics Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Salesforce CRM Analytics to a database.
-
Connect to and Visualize Live Pushbullet Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Pushbullet.
-
Access Recurly 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 Recurly.
-
Access Live Pipeline CRM Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Pipeline CRM into the statistical analysis tools available in SAS JMP. This article shows how to use Pipeline CRM in the Graph Builder and Query Builder.
-
Creating AlloyDB-Connected Applications in Unqork
You can use CData Connect AI to feed Google AlloyDB to Unqork and build custom business apps.
-
Consume Zoho Projects OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Zoho Projects feeds that reflect any changes in SAP Lumira.
-
Automated Continuous SQL Server Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SQL Server replication to AlloyDB.
-
Build Dashboards with Stack Exchange Data in Dundas BI
Create dynamic dashboards and perform analytics based on Stack Exchange in Dundas BI.
-
How to connect to REST Data from Spring Boot
Connect to REST in a Spring Boot Application using the CData JDBC Driver for REST
-
Use the CData Software ODBC Driver for Harvest in MicroStrategy Web
Connect to Harvest in MicroStrategy Web using the CData Software ODBC Driver for Harvest.
-
Easily Integrate Keap Data in Lazarus Pascal IDE
Learn how to easily integrate live Keap in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Zuora Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Zuora in Airbyte.
-
Automated Continuous ZohoExpense Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable ZohoExpense replication to Google BigQuery.
-
Deploy the ADO.NET Provider for Pipeliner CRM on an SSRS Report Server
Connect to Pipeliner CRM 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.
-
Create Power BI Reports on Real-Time CouchDB Data
Use the CData ODBC Driver for CouchDB to visualize Apache CouchDB in Power BI Desktop.
-
Connect to PayPal Data from Crystal Reports
Use CData Connect AI to connect to and report on live PayPal from Crystal Reports.
-
Build PostgreSQL-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for PostgreSQL to explore live PostgreSQL Data in GitHub Copilot to assist with building PostgreSQL-powered applications.
-
A PostgreSQL Interface for Printful Data using the CData ODBC Driver
Use the SQL Gateway and Printful ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create Data Visualizations Based On Square Data in Mode
Use CData Connect AI to connect to Square Data from Mode and build visualizations using live
-
Getting Started with the CData SSIS Components for Monday.com
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Monday.com.
-
Getting Started with the CData ADO.NET Provider for Outlook
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Create Power BI Reports on Real-Time Notion Data
Use the CData ODBC Driver for Notion to visualize Notion in Power BI Desktop.
-
Connect to Sendwithus Data from a Connection Pool in Jetty
The Sendwithus JDBC Driver supports connection pooling: This article shows how to connect faster to Sendwithus from Web apps in Jetty.
-
Work with SQL Analysis Services Data in FoxPro
Load SQL Analysis Services into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Work with GitLab Data in ETL Validator JDBC
Connect to GitLab from ETL Validator jobs using the CData Software JDBC Driver.
-
Use Databricks Agent Bricks to Talk to Your Redis Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Redis for you.
-
Prepare, Blend, and Analyze Vimeo Data in Alteryx Designer (ODBC)
Build workflows to access live Vimeo for self-service data analytics.
-
Use JayDeBeApi to access Mailgun Data in Python
Use standard Python scripting and the development environment of your choice to access live Mailgun.
-
Build Automated Authorize.Net-Connected Workflows in Zapier
Use CData Connect AI to connect to live Authorize.Net and build automated workflows in Zapier.
-
Build Visualizations of Helpscout Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Helpscout in Birst.
-
Connect to and Query ZendeskSell Data in QlikView over ODBC
Create data visualizations with ZendeskSell in QlikView.
-
Connect to Oracle Service Cloud Data in Jaspersoft Studio
Execute SQL to remote Oracle Service Cloud in Jaspersoft Studio.
-
LINQ to Mistral AI 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 Mistral AI Data Provider.
-
Create Data Visualizations in Cognos BI with Databricks Data
Access Databricks as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
GraphQL Reporting in OBIEE with the GraphQL JDBC Driver
Deploy the GraphQL JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Access Replication to Oracle
Use CData Sync for automated, continuous, customizable Access replication to Oracle.
-
Automated Continuous Raisers Edge NXT Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to OneLake in Microsoft Fabric.
-
Visualize Facebook Data in TIBCO Spotfire through ADO.NET
Integrate Facebook into dashboards in TIBCO Spotfire.
-
Create Informatica Mappings From/To a JDBC Data Source for Amazon S3
Create Amazon S3 data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to ZohoMarketingHub Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ZohoMarketingHub to connect to ZohoMarketingHub and execute queries in PowerBuilder.
-
Connect to Gorgias Data in CloverDX (formerly CloverETL)
Transfer Gorgias using the visual workflow in the CloverDX data integration tool.
-
Integrating Oracle Data in Talend Cloud Data Management Platform
Connect Oracle Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Oracle.
-
How to Query Microsoft Entra ID Data in MySQL Workbench
Execute MySQL queries against live Microsoft Entra ID from MySQL Workbench.
-
Access Live ActiveCampaign Data in TIBCO Data Virtualization
Use the ActiveCampaign Tibco DV Adapter to create a ActiveCampaign data source in TIBCO Data Virtualization Studio and gain access to live ActiveCampaign from your TDV Server.
-
Analyze Samanage Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Samanage with the CData JDBC Driver for Samanage.
-
Build Charts with Timely Data in Clear Analytics
Create dynamic charts and perform analytics based on Timely in Clear Analytics.
-
Connect to Okta Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Okta in Airbyte.
-
Connect to Couchbase Data in HULFT Integrate
Connect to Couchbase as a JDBC data source in HULFT Integrate
-
How to integrate Metabase with Dropbox Data
Use CData Connect AI to connect to live Dropbox and create an interactive dashboard in Metabase from Dropbox.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Asana
Provide connectivity to Asana through an SAP BusinessObjects universe.
-
Automate Accelo Data Replication to Azure Synapse
Use CData Sync to customize and automate Accelo replication to Azure Synapse.
-
Use Biml to Build SSIS Tasks to Replicate SurveyMonkey Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SurveyMonkey to SQL Server.