CData Software - Knowledge Base
Recent Articles
-
Connect to Excel Online Data in JRuby
Create a simple JRuby app with access to live Excel Online data.
-
Integrate Live SAP Business Warehouse Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live SAP Business Warehouse data from within the IDE.
-
Model BigCommerce Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and BigCommerce, enabling the direct import of real-time BigCommerce data.
-
Import Real-Time Adobe Experience Manager Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Adobe Experience Manager data in ColdFusion.
-
Integrating Cursor with Excel 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.
-
Connect to and Visualize Live EnterpriseDB Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live EnterpriseDB data.
-
How to use SQLAlchemy ORM to access Google Directory Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Directory data.
-
Building Dynamic Web Pages with Zendesk Data Using AngularJS
Create single-page applications with live connectivity to Zendesk using the CData API Server.
-
Connect to Sage 200 Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Sage 200 and the SQL Gateway to access Sage 200 data from Google Apps Script.
-
How to Work with PolarTeamPro Data in AWS Glue Jobs Using JDBC
Connect to PolarTeamPro from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Calendly
Provide connectivity to Calendly data through an SAP BusinessObjects universe.
-
Connect to ServiceNow Data in Aqua Data Studio
Access ServiceNow data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Working with Wave Financial Data in LINQPad
Execute LINQ queries to Wave Financial data in LINQPad.
-
Automated Continuous Figshare Replication to SingleStore
Use CData Sync for automated, continuous, customizable Figshare replication to SingleStore.
-
Model SingleStore Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SingleStore, enabling the direct import of real-time SingleStore data.
-
Connect to PostgreSQL Data in Jaspersoft Studio
Execute SQL to remote PostgreSQL data in Jaspersoft Studio.
-
Connect to Splunk Data from Crystal Reports
Use CData Connect AI to connect to and report on live Splunk data from Crystal Reports.
-
Access ActiveCampaign Data from MySQL in Amazon QuickSight
Connect to ActiveCampaign and build visualizations of ActiveCampaign data using a MySQL Connection in Amazon QuickSight.
-
Deploy the ADO.NET Provider for Gorgias on an SSRS Report Server
Connect to Gorgias data 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.
-
Trigger Square IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Square with standard wizards in Logic Apps.
-
Integrating Dataiku with Shopify Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Shopify data.
-
Integrate Trae with Live Twilio Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Twilio data from within the AI-powered IDE.
-
Integrating Kiro with Aweber 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.
-
Connect to Wrike Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Wrike data using standard SQL.
-
Query Typeform Data in ColdFusion
Write standard ColdFusion data access code to connect to Typeform data.
-
Integrate with live MailerLite Data in Jitterbit
Use CData Connect AI to connect to and integrate live MailerLite data in Jitterbit.
-
Integrate Paylocity with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Paylocity with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Paylocity data.
-
Import Gong Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Gong Data and provide access to live Gong data for custom reports in the Power BI Service.
-
Use JayDeBeApi to access Egnyte Data in Python
Use standard Python scripting and the development environment of your choice to access live Egnyte data.
-
Interact with Live Adobe Analytics Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Adobe Analytics data.
-
Process & Analyze Jumpseller Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Jumpseller Data.
-
Use Biml to Build SSIS Tasks to Replicate SAS Data Sets Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAS Data Sets data to SQL Server.
-
Automated Continuous Kintone Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Kintone replication to Google BigQuery.
-
Connect to Exa Data from PowerBuilder via JDBC
This article demonstrates how to access Exa data from PowerBuilder using the Exa JDBC Driver.
-
Create SSAS Tabular Models from Bullhorn CRM Data
How to build a SQL Server Analysis Service Tabular Model from Bullhorn CRM data using CData drivers.
-
Connect to Supabase 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 Supabase data.
-
Query Retently Data as a MySQL Database in Node.js
Execute MySQL queries against Retently data from Node.js.
-
Using the CData Software ODBC Driver for Outreach.io in PyCharm
Connect to Outreach.io as an ODBC data source in PyCharm using the CData Software ODBC Driver for Outreach.io.
-
Access EnterpriseDB 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 EnterpriseDB data.
-
Automated Continuous SpaceX Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SpaceX replication to Apache Cassandra.
-
Connect to ChartMogul Data from a Connection Pool in Jetty
The ChartMogul JDBC Driver supports connection pooling: This article shows how to connect faster to ChartMogul data from Web apps in Jetty.
-
DataBind Charts to Dynamics CRM Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Dynamics CRM data 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.
-
Build Visualizations of Supabase Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Supabase data in Birst.
-
Visualize Shopify Data in Tableau
The CData ODBC driver for Shopify enables you integrate Shopify data into Tableau dashboards.
-
Build Agents in Relevance AI with Access to Live MySQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on MySQL data within intelligent agent workflows.
-
Automated Continuous ShipEngine Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ShipEngine replication to delimited files (CSV/TSV).
-
Design BIRT Reports on Azure Data Catalog Data
Provide current Azure Data Catalog data to your embedded analytics.
-
Connect to Guru Data in Ruby
Connect to Guru data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Query Microsoft Planner Data as a MySQL Database in Node.js
Execute MySQL queries against Microsoft Planner data from Node.js.
-
Connect to DocuSign Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for DocuSign and the SQL Gateway to access DocuSign data from Google Apps Script.
-
Replicate Multiple LeadDesk Accounts
Replicate multiple LeadDesk accounts to one or many databases.
-
Connect to Oracle SCM Data from a Connection Pool in Jetty
The Oracle SCM JDBC Driver supports connection pooling: This article shows how to connect faster to Oracle SCM data from Web apps in Jetty.
-
Configure the CData JDBC Driver for BenchmarkEmail in a Connection Pool in Tomcat
Connect to BenchmarkEmail data from a connection pool in Tomcat.
-
Design BIRT Reports on Gumroad Data
Provide current Gumroad data to your embedded analytics.
-
Bind Live Google Ad Manager Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Google Ad Manager data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Connect to Simplesat Data in JRuby
Create a simple JRuby app with access to live Simplesat data.
-
Build Gorgias-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Gorgias data and build web apps with connectivity to live Gorgias data.
-
Build an OLAP Cube in SSAS from Twilio Data
Establish a connection to Twilio data data from SQL Server Analysis Services, and use the Twilio Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Connect to Live Bullhorn CRM 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 Bullhorn CRM data for you.
-
Getting Started with the CData Power BI Connector for Oracle Eloqua
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Oracle Eloqua.
-
Create Google Sheets-Connected Business Apps in AppSheet
Connect to Google Sheets Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Google Sheets data.
-
Natively Connect to Azure DevOps Data in PHP
The CData ODBC driver for Azure DevOps enables you to create PHP applications with connectivity to Azure DevOps data. Leverage the native support for ODBC in PHP.
-
Connect to Tickspot Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Tickspot to connect to Tickspot data and execute queries in PowerBuilder.
-
Integrate Live Phoenix Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Phoenix data and integrate live Phoenix data into apps built in Microsoft Power Apps.
-
Access Paddle Data from MySQL in PHP
Connect to Paddle through the standard MySQL libraries in PHP.
-
Integrate with live Cassandra Data in Jitterbit
Use CData Connect AI to connect to and integrate live Cassandra data in Jitterbit.
-
Perform Batch Operations with Highrise Data in Apache NiFi
Connect to Highrise data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Back Up Epicor Kinetic data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Epicor Kinetic. In this article, we will employ an SSIS workflow to populate a database with Epicor Kinetic data data.
-
Use Microsoft Copilot Studio to talk to your Twitter Ads 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 Twitter Ads data for you.
-
Connect to Simplesat Data in Jaspersoft Studio
Execute SQL to remote Simplesat data in Jaspersoft Studio.
-
How to connect and process MariaDB data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live MariaDB data.
-
Process & Analyze Shippo Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Shippo Data.
-
Connect to Cassandra 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 Cassandra data.
-
Automate eBay Analytics Integration Tasks from PowerShell
Are you in search of a quick and easy way to access eBay Analytics data from PowerShell? This article demonstrates how to utilize the eBay Analytics Cmdlets for tasks like connecting to eBay Analytics data, automating operations, downloading data, and more.
-
Query JobNimbus Data in DataGrip
Create a Data Source for JobNimbus in DataGrip and use SQL to query live JobNimbus data.
-
Create Tavily-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Tavily Data from OutSystems and build custom enterprise apps using live Tavily data.
-
Connect Slack Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Slack data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Import Pipedrive Data Using Azure Data Factory
Use CData Connect AI to connect to Pipedrive Data from Azure Data Factory and import live Pipedrive data.
-
Establish a Live Connection with MailerSend Data using Tableau Bridge
The CData ODBC Driver for MailerSend enables you to integrate live MailerSend data into Tableau Cloud dashboards using the Tableau Bridge.
-
Import Sybase IQ Data Using Azure Data Factory
Use CData Connect AI to connect to Sybase IQ Data from Azure Data Factory and import live Sybase IQ data.
-
Build Apps with Live TigerGraph Data Using the Low-Code Development Platform of Mendix
Connect TigerGraph data with Mendix to build apps using the CData JDBC Driver for TigerGraph.
-
Build Semantic Layer Views for Confluence Data in APOS Live Data Gateway
Use the CData Connector for Confluence in APOS Live Data Gateway to build Semantic Layer Views for Confluence data.
-
Manage MailerLite Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for MailerLite.
-
Connect to Bullhorn CRM Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Bullhorn CRM and the Script function in FileMaker Pro to connect to Bullhorn CRM and work with Bullhorn CRM data in your FileMaker application.
-
Automated Continuous Deel Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Deel data replication to OneLake in Microsoft Fabric.
-
Automated Continuous Lakebase Replication to MongoDB
Use CData Sync for automated, continuous, customizable Lakebase replication to MongoDB.
-
Connecting Pipedream with SAP Business Warehouse Data 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 SAP Business Warehouse data in real time.
-
Integrate Workday Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Workday data from Informatica Cloud.
-
How to integrate Tanda with Apache Airflow
Access and process Tanda data in Apache Airflow using the CData JDBC Driver.
-
Integrate with MarkLogic Data in SnapLogic
Use CData Connect AI to connect to and integrate with live MarkLogic data in SnapLogic.
-
Connect to Microsoft Exchange from a Connection Pool in WebLogic
Use the CData JDBC Driver for Microsoft Exchange to connect to Microsoft Exchange data from Web applications running on WebLogic.
-
Connect BambooHR to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect BambooHR with IBM WebSphere for seamless data integration and connectivity.
-
How to Query Live Amplitude Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Amplitude data data in natural language using Python.
-
Object-Relational Mapping (ORM) with PhantomBuster 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 PhantomBuster data into a Java-based ORM framework, Hibernate.
-
Operational Reporting on Marketo Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Marketo data.
-
Create MariaDB-Connected Applications in Appsmith
Connect to MariaDB Data via CData Connect AI in Appsmith and create custom business applications with real-time access to MariaDB data.
-
Connect to Shippo Data in DBeaver
Use the CData ODBC Driver to connect to Shippo data in DBeaver.
-
Connect and Query Live Adobe Commerce Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Adobe Commerce data into Databricks and enable direct, live querying and analysis without replication.
-
Write a Simple Go Application to work with Pinterest Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Pinterest data.
-
Connecting Moonlit Workflow with Elasticsearch 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 Elasticsearch data in real time.