CData Software - Knowledge Base
Recent Articles
-
Query xBase Data as a MySQL Database in Node.js
Execute MySQL queries against xBase from Node.js.
-
Build AI Agents with Oracle SCM Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Oracle SCM through CData Connect AI.
-
A PostgreSQL Interface for Monday.com Data (MySQL Remoting via JDBC)
Use the Remoting features of the Monday.com JDBC Driver to create a PostgreSQL entry-point for data access.
-
Manage FTP Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for FTP.
-
Migrating data from CapsuleCRM to Google BigQuery using CData SSIS Components.
Easily push CapsuleCRM to Google BigQuery using the CData SSIS Tasks for CapsuleCRM and Google BigQuery.
-
Connect to Google Translate Data in Aqua Data Studio
Access Google Translate from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Connect to Live Reckon Accounts Hosted 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 Reckon Accounts Hosted for you.
-
Connect to Tanda Data in RapidMiner
Integrate Tanda with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous Notion Replication to MongoDB
Use CData Sync for automated, continuous, customizable Notion replication to MongoDB.
-
Connect to Airtable Data in Google Apps Script via Connect AI
Use CData Connect AI to access Airtable in Google Apps Script.
-
Import and Visualize Aircall Data in Power View
Create data visualizations based on Aircall in Excel.
-
Connect to Perigon Data from PowerBuilder via ADO.NET
This article demonstrates how to access Perigon from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for CouchDB
Provide connectivity to Apache CouchDB through an SAP BusinessObjects universe.
-
Build a PostgreSQL Interface for ServiceDesk Plus Data using the CData JDBC Driver
Use the Remoting features of the ServiceDesk Plus JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build MVC Applications with Connectivity to Coda Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Coda from an ASP.NET MVC application.
-
Configure the CData JDBC Driver for Aweber in a Connection Pool in Tomcat
Connect to Aweber from a connection pool in Tomcat.
-
Automated SingleStore Data Replication to Teradata
Use CData Sync to Customize and automate SingleStore replication to Teradata.
-
How to load REST data into Elasticsearch via Logstash
Introducing a simple method to load REST data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Work with QuickBooks Data in FoxPro
Load QuickBooks Desktop into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create a Data Access Object for Optimizely Data using JDBI
A brief overview of creating a SQL Object API for Optimizely in JDBI.
-
Integrating Email Data in Talend Cloud Data Management Platform
Connect Email Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Email.
-
Automated Continuous Dynamics NAV Replication to SingleStore
Use CData Sync for automated, continuous, customizable Dynamics NAV replication to SingleStore.
-
Connect SQL Analysis Services Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SQL Analysis Services using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build Apps with Live Bright Data Data Using the Low-Code Development Platform of Mendix
Connect Bright Data with Mendix to build apps using the CData API Driver for JDBC.
-
Migrating data from Supabase to Snowflake using CData SSIS Components.
Easily push Supabase to Snowflake using the CData SSIS Tasks for Supabase and Snowflake.
-
Build Data Flows from JSON to SQL Server using SSIS
Easily back up JSON to SQL Server using the SSIS components for JSON.
-
Build Smartsheet-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Smartsheet and build web apps with connectivity to live Smartsheet.
-
Back Up Sage Business Cloud Accounting to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Sage Cloud Accounting. In this article, we will employ an SSIS workflow to populate a database with Sage Business Cloud Accounting data.
-
How to Connect to & Open DocuSign Data in Microsoft Excel
This article uses the CData ODBC driver for DocuSign to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build DocuSign-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for DocuSign to explore live DocuSign Data in Gemini Code Assist to assist with building DocuSign-powered applications.
-
Connect to Outlook Data in CloverDX (formerly CloverETL)
Transfer Outlook using the visual workflow in the CloverDX data integration tool.
-
Connect to Amazon Marketplace Data in RazorSQL
Connect to Amazon Marketplace from wizards and query Amazon Marketplace from the GUI in the RazorSQL database management tool.
-
Creating Oracle Financials Cloud-Connected Applications in Unqork
You can use CData Connect AI to feed Oracle Financials Cloud to Unqork and build custom business apps.
-
Analyze GraphQL Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of GraphQL and visualize live GraphQL in Infragistics Reveal.
-
Connect to Azure DevOps Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to publish and share Kintone Data dashboards with Tableau Server
The CData ODBC driver for Kintone enables you integrate Kintone into Tableau dashboards.
-
Build Google Directory-Connected Apps in Choreo
Use CData Connect AI to connect to Google Directory Data from Choreo and build custom apps using live Google Directory.
-
Use JayDeBeApi to access SAP ByDesign Data in Python
Use standard Python scripting and the development environment of your choice to access live SAP Business ByDesign.
-
How to Import Data from Oracle SCM into Google Sheets
Import Oracle SCM into a Google spreadsheet that is automatically refreshed.
-
Integrating Antigravity CLI with PayPal via CData CLI
Connect PayPal to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Keap Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Keap using standard SQL.
-
Migrating data from YouTube Analytics to Snowflake using CData SSIS Components.
Easily push YouTube Analytics to Snowflake using the CData SSIS Tasks for YouTube Analytics and Snowflake.
-
Access Live Cosmos DB 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 Azure Cosmos DB through MCP integration.
-
How to connect and process Google Ads from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Google Ads.
-
Building Dynamic Web Pages with Wave Financial Data Using AngularJS
Create single-page applications with live connectivity to Wave Financial using the CData API Server.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Float
Provide connectivity to Float through an SAP BusinessObjects universe.
-
Connect to Close Data in DBArtisan
Use wizards in DBArtisan to configure Close as a data source.
-
How to Connect to & Open Snapchat Ads Data in Microsoft Excel
This article uses the CData ODBC driver for Snapchat Ads to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Getting Started with the CData ODBC Driver for Airtable
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Airtable.
-
Integrate Cline with Live SharePoint Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Microsoft SharePoint from within your IDE.
-
Create Dashboards and Visualize Live Dynamics CRM Data in Geckoboard
Use CData Connect AI to connect to live Microsoft Dynamics CRM and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrate Scrapfly with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Scrapfly with External Services.
-
Build Google Ads-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Google Ads and build Google Ads-connected web apps with Axios.
-
Integrating Kiro CLI with Teamwork 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.
-
Integrate LibreChat with Live Blackbaud FE NXT Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Blackbaud FE NXT from within the chat interface.
-
Design BIRT Reports on Aweber Data
Provide current Aweber to your embedded analytics.
-
How to Query Live OneNote Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Microsoft OneNote data in natural language using Python.
-
Build a PostgreSQL Interface for GraphQL Data using the CData JDBC Driver
Use the Remoting features of the GraphQL JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze ZendeskSell Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze ZendeskSell in Microsoft R Open.
-
Build MVC Applications with Connectivity to Suadeo Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Suadeo from an ASP.NET MVC application.
-
Integrate with Live Quickbase Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Quickbase from the MuleSoft Anypoint Platform to integrate live Quickbase into custom reports and dashboards.
-
Create Dynamic Azure Synapse Grids Using the Infragistics XamDataGrid
Learn how you can connect Azure Synapse to Infragistics XamDataGrid to build dynamic grids.
-
Access Freshteam Data from MySQL in PHP
Connect to Freshteam through the standard MySQL libraries in PHP.
-
Connect Facebook Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Facebook using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build an OLAP Cube in SSAS from Box Data
Establish a connection to Box data from SQL Server Analysis Services, and use the Box Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrating Datadog Data in Talend Cloud Data Management Platform
Connect Datadog Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to Query eBay Data in MySQL Workbench
Execute MySQL queries against live eBay from MySQL Workbench.
-
Publish Reports with SAS xpt Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAS XPORT.
-
Use the CData Software ODBC Driver for Smartsheet in SAS for Real-Time Reporting and Analytics
Connect to real-time Smartsheet in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Smartsheet.
-
Query Databricks Data in ColdFusion
Write standard ColdFusion data access code to connect to Databricks.
-
Create a Data Access Object for Oracle Sales Data using JDBI
A brief overview of creating a SQL Object API for Oracle Sales in JDBI.
-
Using the CData Software ODBC Driver for Pipedrive in PyCharm
Connect to Pipedrive as an ODBC data source in PyCharm using the CData Software ODBC Driver for Pipedrive.
-
Use Dash to Build to Web Apps on Couchbase Data
Create Python applications that use pandas and Dash to build Couchbase-connected web apps.
-
Explore Geographical Relationships in Google Drive Data with Power Map
Create data visualizations with Google Drive in Power Map.
-
DataBind Controls to Oracle Eloqua Reporting Data in Delphi
DataBind to Oracle Eloqua Reporting in Delphi with standard data access components and controls.
-
Use Grok to Talk to Your Zoho Books Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Zoho Books for you.
-
Replicate RSS Feeds in Heroku for Use in Salesforce Connect
Replicate RSS Feeds to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Import Oracle SCM Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Oracle SCM Data and provide access to live Oracle SCM for custom reports in the Power BI Service.
-
Connect to Anaplan Data in Jaspersoft Studio
Execute SQL to remote Anaplan in Jaspersoft Studio.
-
Visualize Pinterest Data in Sisense
Create an ElastiCube in Sisense app with access to Pinterest.
-
How to Connect to Live Hive Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Apache Hive securely in real time.
-
Feed Oracle Financials Cloud Data into FineReport
How to set Oracle Financials Cloud as a JDBC data source in FineReport.
-
Use Databricks Agent Bricks to Talk to Your Asana Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Asana for you.
-
Create Power BI Reports on Real-Time Jira Assets Data
Use the CData ODBC Driver for Jira Assets to visualize Jira Assets in Power BI Desktop.
-
Integrating LangGraph with PostgreSQL Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on PostgreSQL within automated workflows.
-
Visualize AfterShip Data in Tableau
The CData ODBC driver for AfterShip enables you integrate AfterShip into Tableau dashboards.
-
Perform Batch Operations with Zoho Creator Data in Apache NiFi
Connect to Zoho Creator and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Getting Started with the CData Excel Add-In for MarkLogic
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for MarkLogic.
-
Automate Zoho Inventory Data Replication to Azure Data Lake
Use CData Sync to customize and automate Zoho Inventory replication to Azure Data Lake.
-
Build a Simple VCL Application for LionDesk Data
How to build a simple VCL Application to view LionDesk in RAD Studio using the CData ODBC Driver for LionDesk.
-
Build a Simple VCL Application for VWO Data
How to build a simple VCL Application to view VWO in RAD Studio using the CData ODBC Driver for VWO.
-
Create Data Visualizations Based On Oracle Data in Mode
Use CData Connect AI to connect to Oracle Data from Mode and build visualizations using live
-
How to Easily Query Certinia Data in OpenOffice Base
Connect to Certinia data in OpenOffice Base using the CData ODBC Driver for Certinia and generate reports with live data insights.
-
Use the CData Software ODBC Driver for Opsgenie in MicroStrategy Web
Connect to Opsgenie in MicroStrategy Web using the CData Software ODBC Driver for Opsgenie.
-
How to Connect to Live Dynamics 365 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 Microsoft Dynamics 365 for you.
-
DataBind Couchbase Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Couchbase with the DevExpress Windows Forms and Web controls to provide Couchbase to a chart.
-
Getting Started with the CData Excel Add-In for Procore
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Procore.
-
Bridge Auth0 Connectivity with Apache NiFi
Access and process Auth0 in Apache NiFi using the CData JDBC Driver.
-
Create Reports with Customer.io Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Customer.io.
-
Use the CData ODBC Driver for Google Tasks in Microsoft Power Query
You can use the CData Google Tasks ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Google Tasks into Microsoft Power Query.