CData Software - Knowledge Base
Recent Articles
-
How to connect and process Pipeline CRM data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Pipeline CRM data.
-
Feed Testmonitor Data into FineReport
How to set Testmonitor data 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 data 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 data 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 data.
-
Visualize Live Smartsheet Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Smartsheet data 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 data and build web apps with connectivity to live Guru data.
-
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 data from Web apps in Jetty.
-
How to connect to Paddle Data in DBVisualizer
Integrate Paddle data 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 data 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 Impala data and integrate live Impala data into apps built in Microsoft Power Apps.
-
Viewing Monday.com Data in RAD Studio Data Explorer
How to view Monday.com data 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 data replication to Couchbase.
-
Connecting Moonlit Workflow with Timely Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Timely data in real time.
-
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 data to a JSON file on disk.
-
How to connect to Square Data with Squirrel SQL client
Connect to Square data and execute queries in the Squirrel SQL Client.
-
Build AI Agents with Guru 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 Guru data through CData Connect AI.
-
How to use SQLAlchemy ORM to access Salesloft Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Salesloft data.
-
Access SparkPost Data from MySQL in Amazon QuickSight
Connect to SparkPost and build visualizations of SparkPost data 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 HBase data 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 data from your Excel spreadsheets.
-
Automated Continuous ElevenLabs Replication to SQLite
Use CData Sync for automated, continuous, customizable ElevenLabs replication to SQLite.
-
How to Access Live SendPulse Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SendPulse enables you to integrate SendPulse data into workflows built using Microsoft Power Automate Desktop.
-
Query Salesforce Data 360 Data as a SQL Server Database in Node.js
Execute SQL Server queries against Salesforce Data 360 data from Node.js.
-
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 data through MCP integration.
-
Connect to HBase Data in RazorSQL
Connect to HBase from wizards and query HBase data from the GUI in the RazorSQL database management tool.
-
Query Live Epicor Kinetic Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Epicor Kinetic data through a conversational interface.
-
Explore Geographical Relationships in Clockify Data with Power Map
Create data visualizations with Clockify data 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 data.
-
How to Build an ETL App for OnePageCrm Data in Python with CData
Create ETL applications and real-time data pipelines for OnePageCrm data in Python with petl.
-
Connect to Mistral AI Data from PowerBuilder via ADO.NET
This article demonstrates how to access Mistral AI data 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 data 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 data 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 data and execute queries in the Squirrel SQL Client.
-
Automate Square Data Replication to Azure Data Lake
Use CData Sync to customize and automate Square data replication to Azure Data Lake.
-
Integrate Parallel Data in Pentaho Data Integration
Build ETL pipelines based on Parallel data in the Pentaho Data Integration tool.
-
Connect to Salesloft from a Connection Pool in WebLogic
Use the CData JDBC Driver for Salesloft to connect to Salesloft data from Web applications running on WebLogic.
-
Integrating Kiro with TaxJar 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 Access FreshBooks Data Using Entity Framework
This article shows how to access FreshBooks data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrate with OnePageCrm Data in JReport Designer
Create charts and reports based on OnePageCrm data in JReport Designer.
-
Replicate Multiple CockroachDB Accounts
Replicate multiple CockroachDB accounts to one or many databases.
-
How to Connect to Live OneNote Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your OneNote data through natural language.
-
How to Build an ETL App for LinkedIn Ads Data in Python with CData
Create ETL applications and real-time data pipelines for LinkedIn Ads data in Python with petl.
-
A PostgreSQL Interface for SQL Server Data using the CData ODBC Driver
Use the SQL Gateway and SQL Server ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to and Query Odoo Data in QlikView over ODBC
Create data visualizations with Odoo data in QlikView.
-
Use Microsoft Copilot Studio to talk to your BambooHR 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 BambooHR data for you.
-
Create a Data Access Object for Sybase Data using JDBI
A brief overview of creating a SQL Object API for Sybase data in JDBI.
-
Automate NetSuite SuiteAnalytics Data Replication to Azure Data Lake
Use CData Sync to customize and automate NetSuite SuiteAnalytics data replication to Azure Data Lake.
-
How to Access Live Oracle Service Cloud Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Oracle Service Cloud enables you to integrate Oracle Service Cloud data into workflows built using Microsoft Power Automate Desktop.
-
Build Apps with Live GetResponse data in Adalo using CData Connect AI
Use CData Connect AI to integrate live GetResponse data into the Adalo platform and build custom mobile and web applications with real-time GetResponse data.
-
Connect to Close Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Close and the SQL Gateway to access Close data from Google Apps Script.
-
Create Toggl-Connected Dashboards in Grafana
Connect to Toggl Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Toggl data.
-
Access Live GetResponse Data in Excel 365 Online (Excel for the web)
Connect to GetResponse data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Establish a Live Connection with Freshdesk Data using Tableau Bridge
The CData ODBC Driver for Freshdesk enables you to integrate live Freshdesk data into Tableau Cloud dashboards using the Tableau Bridge.
-
Using the CData Software ODBC Driver for AfterShip in PyCharm
Connect to AfterShip as an ODBC data source in PyCharm using the CData Software ODBC Driver for AfterShip.
-
Viewing Xero Data in RAD Studio Data Explorer
How to view Xero data in RAD Studio Data Explorer using the CData ODBC Driver for Xero.
-
Use Azure AI Foundry to Talk to Your eBay 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 eBay data for you.
-
Access Coinbase Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Coinbase data from HeidiSQL.
-
Freshteam Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Freshteam data through CData Connect AI using different applications and tools.
-
Build Visualizations of Azure Analysis Services Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Azure Analysis Services data in Birst.
-
Automated Continuous Teamwork Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Teamwork replication to PostgreSQL.
-
Viewing Onfleet Data in RAD Studio Data Explorer
How to view Onfleet data in RAD Studio Data Explorer using the CData ODBC Driver for Onfleet.
-
Connecting Pipedream with LDAP Objects via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on LDAP data in real time.
-
Integrate Live Toggl Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Toggl from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Toggl data.
-
Build Data Flows from Spark to SQL Server using SSIS
Easily back up Spark data to SQL Server using the SSIS components for Spark.
-
How to Seamlessly Import Dynamics 365 Business Central Data into IBM SPSS Modeler
Integrate Dynamics 365 Business Central data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to OpenWeatherMap Data as an External Source in Dremio
Use the CData JDBC Driver to connect to OpenWeatherMap as an External Source in Dremio.
-
How to connect to Google Ads Data in DBVisualizer
Integrate Google Ads data with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous Adobe Analytics Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Adobe Analytics replication to Azure SQL Database.
-
LINQ to GraphQL 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 GraphQL Data Provider.
-
Integrating Antigravity CLI with GitHub data via CData CLI
Connect GitHub data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build a Singer.io Tap for Adobe Commerce With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Adobe Commerce data using the CData Python Connector.
-
Build Data Flows from BambooHR to SQL Server using SSIS
Easily back up BambooHR data to SQL Server using the SSIS components for BambooHR.
-
Automated Continuous Sage Intacct Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Sage Intacct replication to Amazon Redshift.
-
How to Build an ETL App for QuickBooks Time Data in Python with CData Connect AI
Extract and transform live QuickBooks Time data in Python with petl and the CData Connect AI Python SDK.
-
Explore Geographical Relationships in Beeminder Data with Power Map
Create data visualizations with Beeminder data in Power Map.
-
Replicate Mailgun Data to Multiple Databases
Replicate Mailgun data to disparate databases with a point-and-click configuration.
-
Integrate Goose with Live eBay Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live eBay data from within the local AI agent.
-
Bridge SingleStore Connectivity with Apache NiFi
Access and process SingleStore data in Apache NiFi using the CData JDBC Driver.
-
Getting Started with the CData Tableau Connector for Slack
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Slack.
-
How to Access HCL Domino Data Using Entity Framework
This article shows how to access HCL Domino data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Connect DBeaver to LaunchDarkly via a JDBC Driver
Manage LaunchDarkly data with visual tools in DBeaver like the query browser.
-
Automated Continuous Microsoft Exchange Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to AlloyDB.
-
Create Power BI Reports on Real-Time FreeAgent Data
Use the CData ODBC Driver for FreeAgent to visualize FreeAgent data in Power BI Desktop.
-
Use Microsoft Copilot Studio and Microsoft Teams to Talk to Your Data via Connect AI
Leverage the CData Connect AI Remote MCP server to enable Microsoft Teams to securely answer questions and take actions on your data for you.
-
Consume HBase OData Feeds in SAP Lumira
Use the API Server to create data visualizations on HBase feeds that reflect any changes in SAP Lumira.
-
Connect to ShipEngine Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with ShipEngine Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Replicate Greenplum Data to Multiple Databases
Replicate Greenplum data to disparate databases with a point-and-click configuration.
-
A PostgreSQL Interface for Close Data using the CData ODBC Driver
Use the SQL Gateway and Close ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect and Query Live GitLab Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live GitLab data into Databricks and enable direct, live querying and analysis without replication.
-
Getting Started with the CData Python Connector for Teamgate
Learn to install and license the CData Python Connector and configure a connection to live Teamgate data.
-
Consume OneNote OData Feeds in SAP Lumira
Use the API Server to create data visualizations on OneNote feeds that reflect any changes in SAP Lumira.
-
Create SSAS Tabular Models from Todoist Data
How to build a SQL Server Analysis Service Tabular Model from Todoist data using CData drivers.
-
Build an OLAP Cube in SSAS from xBase Data
Establish a connection to xBase data data from SQL Server Analysis Services, and use the xBase Data Provider to build OLAP cubes for use in analytics and reporting.
-
Sage 300 Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Sage 300 facts in real time.