CData Software - Knowledge Base
Recent Articles
-
Manage Authorize.Net Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Authorize.Net.
-
Integrate Real-Time Access to Wave Financial in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Wave Financial in real time.
-
How to connect to ServiceNow Data in DBVisualizer
Integrate ServiceNow with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrating Codex CLI with SingleStore 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.
-
Visualize Redshift Data in Tableau
The CData ODBC driver for Redshift enables you integrate Amazon Redshift into Tableau dashboards.
-
Create Vertica-Connected Nintex Workflows
Use CData Connect AI to connect to Vertica Data from Nintex Workflow Cloud and build custom workflows using live Vertica.
-
Easily Integrate Mocean Data in Lazarus Pascal IDE
Learn how to easily integrate live Mocean in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrating OpenCode Terminal with AlloyDB 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 Connect to Live Epicor Kinetic Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Epicor Kinetic for you.
-
Migrating data from Mocean to Snowflake using CData SSIS Components.
Easily push Mocean to Snowflake using the CData SSIS Tasks for Mocean and Snowflake.
-
Visualize Act-On Data in TIBCO Spotfire through ADO.NET
Integrate Act-On into dashboards in TIBCO Spotfire.
-
Connect to Real-Time Teamwork Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Teamwork in Power Apps.
-
How to Access Live Splunk Data in Visual Studio Code via Cline
Run CData MCP Server for Splunk on Windows Subsytem for Linux (WSL) and connect to live Splunk from the Cline extension in Visual Studio Code.
-
Extract, Transform, and Load Teamgate Data in Informatica PowerCenter
Create a simple Workflow for Teamgate in Informatica PowerCenter.
-
How to Create Power BI Visual Reports with Real-Time Amplitude Data
Use CData Power BI Connectors to visualize Amplitude in Power BI.
-
Use the CData Software ODBC Driver for Autopilot in MicroStrategy Web
Connect to Autopilot in MicroStrategy Web using the CData Software ODBC Driver for Autopilot.
-
How to import Wrike Data into Apache Solr
Use the CData Software JDBC Driver for Wrike in Data Import Handler and create an automated import of Wrike to Apache Solr Enterprise Search platform.
-
Using the CData Software ODBC Driver for Guru in PyCharm
Connect to Guru as an ODBC data source in PyCharm using the CData Software ODBC Driver for Guru.
-
Configure the CData JDBC Driver for Kafka in a Connection Pool in Tomcat
Connect to Apache Kafka from a connection pool in Tomcat.
-
Access Paylocity Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Paylocity from your Oracle system.
-
Integrating GitHub Copilot CLI with Monday.com 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.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed ZohoDesk to Power BI dashboards. Simply drag and drop ZohoDesk into data visuals on the Power BI canvas.
-
Connect to Adobe Experience Manager Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Adobe Experience Manager and the SQL Gateway to access Adobe Experience Manager from Google Apps Script.
-
Build MVC Applications with Connectivity to Calendly Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Calendly from an ASP.NET MVC application.
-
Access Live Cloudant 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 IBM Cloudant through MCP integration.
-
How to import CouchDB Data into Apache Solr
Use the CData Software JDBC Driver for CouchDB in Data Import Handler and create an automated import of Apache CouchDB to Apache Solr Enterprise Search platform.
-
Object-Relational Mapping (ORM) with SAP Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to SAP ERP/NetWeaver into a Java-based ORM framework, Hibernate.
-
Analyze Teradata Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Teradata from Power Pivot. You will use the Table Import Wizard to load Teradata. You can visually build the import query or use any SQL supported by the driver.
-
Build HCL Domino-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for HCL Domino to explore live HCL Domino Data in GitHub Copilot to assist with building HCL Domino-powered applications.
-
Feed Campaigner Data into FineReport
How to set Campaigner as a JDBC data source in FineReport.
-
How to import BigQuery Data into Apache Solr
Use the CData Software JDBC Driver for BigQuery in Data Import Handler and create an automated import of Google BigQuery to Apache Solr Enterprise Search platform.
-
Build Semantic Layer Views for Freshservice Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Freshservice.
-
ETL Spark in Oracle Data Integrator
This article shows how to transfer Apache Spark SQL into a data warehouse using Oracle Data Integrator.
-
Connect to Airtable Data from a Connection Pool in Jetty
The Airtable JDBC Driver supports connection pooling: This article shows how to connect faster to Airtable from Web apps in Jetty.
-
Bind Live Azure Table Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Azure Table data
-
Build Phoenix-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Apache Phoenix.
-
Use the CData Software JDBC Driver for BenchmarkEmail in MicroStrategy Desktop
Connect to BenchmarkEmail in MicroStrategy Desktop using the CData Software JDBC Driver for BenchmarkEmail.
-
How to connect to Perigon Data in DBVisualizer
Integrate Perigon with visual data analysis tools and data connection wizards in DBVisualizer
-
Use the CData Software ODBC Driver for Pingdom in SAS for Real-Time Reporting and Analytics
Connect to real-time Pingdom in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Pingdom.
-
How to connect PolyBase to Stack Exchange
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Stack Exchange.
-
Visualize SAP BusinessObjects BI Data in Sisense
Create an ElastiCube in Sisense app with access to SAP BusinessObjects BI.
-
Build SAS Data Sets-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for SAS Data Sets to explore live SAS Data Sets Data in Gemini Code Assist to assist with building SAS Data Sets-powered applications.
-
Replicate Adobe Target Data from PowerShell
Write a quick PowerShell script to query Adobe Target. Use connectivity to the live data to replicate Adobe Target to SQL Server.
-
Access Live Cassandra Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Apache Cassandra from your Google Sheets.
-
Connect to Act CRM from a Connection Pool in WebLogic
Use the CData JDBC Driver for Act CRM to connect to Act CRM from Web applications running on WebLogic.
-
How to Query Live CapsuleCRM Data in Claude Desktop
Connect to and query live CapsuleCRM Data in Claude Desktop using CData MCP Server.
-
Build Dashboards with QuickBooks Online Data in DBxtra
Create dynamic dashboards and perform analytics based on QuickBooks Online in DBxtra.
-
Visualize Cosmos DB Data in TIBCO Spotfire through ADO.NET
Integrate Azure Cosmos DB into dashboards in TIBCO Spotfire.
-
How to Access Live Templated Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Templated enables you to integrate Templated into workflows built using Microsoft Power Automate Desktop.
-
Query Google Cloud Storage Data in DataGrip
Create a Data Source for Google Cloud Storage in DataGrip and use SQL to query live Google Cloud Storage.
-
Integrate Bannerbear with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Bannerbear with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Bannerbear.
-
Connect to Onfleet Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Onfleet in the Denodo Virtual DataPort Administrator.
-
Connect to Lakebase from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Lakebase, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to PostgreSQL Data in Aqua Data Studio
Access PostgreSQL from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create Informatica Mappings From/To an ODBC Data Source for Workday
Create an ODBC connection to Workday in Informatica and browse and transfer Workday.
-
Load MailChimp Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load MailChimp to a database.
-
Integrating LangGraph with Okta Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Okta within automated workflows.
-
Automated Continuous SAP HANA Replication to IBM DB2
Use CData Sync for automated, continuous, customizable SAP HANA replication to IBM DB2.
-
Visualize Live QuickBooks Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live QuickBooks Desktop using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
ETL Ontraport in Oracle Data Integrator
This article shows how to transfer Ontraport into a data warehouse using Oracle Data Integrator.
-
Use Agno to Talk to Your Amazon Athena Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Amazon Athena for you.
-
Build Jira-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Jira Data from Zoho Analytics and import live Atlassian Jira.
-
Automated Continuous SendPulse Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SendPulse replication to OneLake in Microsoft Fabric.
-
Create Twilio-Connected Dashboards in Grafana
Connect to Twilio Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Twilio.
-
How to Query Square Data in MySQL Workbench
Execute MySQL queries against live Square from MySQL Workbench.
-
Build Monday.com-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Monday.com to explore live Monday.com Data in Cursor to assist with building Monday.com-powered applications.
-
Connect to Quickbase Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Quickbase.
-
Use Azure AI Foundry to Talk to Your Azure Analysis Services 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 Azure Analysis Services for you.
-
Connect to Amazon Athena Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Amazon Athena to connect to Amazon Athena and execute queries in PowerBuilder.
-
Connect to Scrapfly in SpagoBI
Create reports featuring live Scrapfly in SpagoBI Studio. Host Scrapfly reports on SpagoBI Server.
-
Automated Continuous Procore Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Procore replication to Google BigQuery.
-
Integrating GitHub Copilot CLI with SAP Ariba Source 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 Salesforce Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Salesforce Data and connect to Salesforce & Force.com in Akorbi Digital RunMyProcess.
-
Create Zoho CRM-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Zoho CRM Data from OutSystems and build custom enterprise apps using live Zoho CRM.
-
Build Semantic Layer Views for JobNimbus Data in APOS Live Data Gateway
Use the CData Connector for JobNimbus in APOS Live Data Gateway to build Semantic Layer Views for JobNimbus.
-
Integrating LangChain with Oracle SCM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Oracle SCM within automated workflows.
-
LINQ to Azure Analysis Services 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 Azure Analysis Services Data Provider.
-
Building Dynamic Web Pages with MessageBird Data Using AngularJS
Create single-page applications with live connectivity to MessageBird using the CData API Server.
-
Import Real-Time Insightly Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Insightly in ColdFusion.
-
Use the CData Software JDBC Driver for CockroachDB in MicroStrategy
Connect to CockroachDB in MicroStrategy Developer using the CData Software JDBC Driver for CockroachDB.
-
Query JobNimbus Data in ColdFusion
Write standard ColdFusion data access code to connect to JobNimbus.
-
Query, Visualize, and Share live BigQuery Data in Redash
Use CData Connect AI to connect to live Google BigQuery in Redash for querying, visualizing, and sharing.
-
Import Real-Time Freshsales Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Freshsales in ColdFusion.
-
Build Apps with Live Snowflake Data Using the Low-Code Development Platform of Mendix
Connect Snowflake with Mendix to build apps using the CData JDBC Driver for Snowflake.
-
Build Dashboards with LaunchDarkly Data in DBxtra
Create dynamic dashboards and perform analytics based on LaunchDarkly in DBxtra.
-
Use the CData Software ODBC Driver for SendPulse in SAS for Real-Time Reporting and Analytics
Connect to real-time SendPulse in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SendPulse.
-
How to Connect to Live Sage 200 Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Sage 200 for you.
-
Replicate Dotmailer Data in Heroku for Use in Salesforce Connect
Replicate Dotmailer to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate Live Sybase IQ Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Sybase IQ and integrate live Sybase IQ into apps built in Microsoft Power Apps.
-
Bidirectional Access to SAS Data Sets Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SAS Data Sets in Filemaker Pro for Mac or Windows.
-
Automate WooCommerce Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live WooCommerce and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
DataBind Controls to Superchat Data in C++Builder
DataBind to Superchat in C++Builder with standard components and controls.
-
Getting Started with the CData SSIS Components for ConvertKit
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ConvertKit.
-
How to Query Live JSON Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live JSON data in natural language using Python.
-
How to create Planio federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Planio in MySQL .
-
Getting Started with the CData ODBC Driver for BenchmarkEmail
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for BenchmarkEmail.
-
Access Live Dynamics CRM Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Microsoft Dynamics CRM from your Excel spreadsheets.
-
Natively Connect to Salesforce Data in PHP
The CData ODBC driver for Salesforce enables you to create PHP applications with connectivity to Salesforce & Force.com. Leverage the native support for ODBC in PHP.
-
Use the CData Software ODBC Driver for Amazon S3 in SAS for Real-Time Reporting and Analytics
Connect to real-time Amazon S3 in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Amazon S3.
-
Getting Started with the CData JDBC Driver for Aha!
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Aha!.