CData Software - Knowledge Base
Recent Articles
-
How to Connect Flowise AI Agents to Live EnterpriseDB Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live EnterpriseDB data without replication.
-
Visualize Live Eventbrite Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Eventbrite data.
-
Integrating Claude Code CLI with SendGrid 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 Stack Exchange Data from PowerBuilder via ADO.NET
This article demonstrates how to access Stack Exchange data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Publish Reports with Monday.com Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Monday.com data.
-
Build an OLAP Cube in SSAS from Amazon Athena Data
Establish a connection to Amazon Athena data data from SQL Server Analysis Services, and use the Amazon Athena Data Provider to build OLAP cubes for use in analytics and reporting.
-
Access Live Highrise Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Highrise data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrating LlamaIndex with Google Spanner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Google Spanner data in real time.
-
Excel Spreadsheet Automation on SAP Ariba Source Data with the QUERY Formula
Pull data from SAP Ariba Source, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous Tickspot Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Tickspot replication to Apache Cassandra.
-
Getting Started with the CData Connect AI Python SDK for Dropbox
Install the CData Connect AI Python SDK to read and write live Dropbox data with standard DB-API 2.0 Python code.
-
Build Apps with Live Mailgun data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Mailgun data into the Adalo platform and build custom mobile and web applications with real-time Mailgun data.
-
Stream OnePageCrm Data into Apache Kafka Topics
Access and stream OnePageCrm data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Replicate Beeminder Data to Multiple Databases via the CData Sync CLI
Replicate Beeminder data to disparate databases with a single configuration.
-
How to connect PolyBase to Nuclia
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Nuclia data.
-
Getting Started with the CData Connect AI Python SDK for Sendwithus
Install the CData Connect AI Python SDK to read live Sendwithus data with standard DB-API 2.0 Python code.
-
Connecting GenSpark with Pinterest Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Pinterest data without any replication or custom integration required.
-
Create Dynamic Clio Grids Using the Infragistics XamDataGrid
Learn how you can connect Clio to Infragistics XamDataGrid to build dynamic grids.
-
Perform Batch Operations with Dynamics CRM Data in Apache NiFi
Connect to Dynamics CRM data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Integrate Cline with Live Act CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Act CRM data from within your IDE.
-
Build a Singer.io Tap for Tanda With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Tanda data using the CData Python Connector.
-
Add HelloSign Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for HelloSign with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automate Google Directory Data Replication to SAP HANA
Use CData Sync to customize and automate Google Directory data replication to SAP HANA.
-
Connect to Landbot Data in RazorSQL
Connect to Landbot from wizards and query Landbot data from the GUI in the RazorSQL database management tool.
-
Connect to Cassandra in SpagoBI
Create reports featuring live Cassandra data in SpagoBI Studio. Host Cassandra reports on SpagoBI Server.
-
Getting Started with the CData Power BI Connector for Beeminder
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Access Live Front Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Front data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use Dash to Build Web Apps on FTP Data via CData Connect AI
Build interactive Dash web apps on live FTP data using pandas and the CData Connect AI Python SDK.
-
Connect to ZohoSubscriptions Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live ZohoSubscriptions data from Filemaker Pro on Mac.
-
Connect to Typeform Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Typeform data.
-
How to Connect to Live Paymo Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Paymo data for you.
-
Access Live Box Data in Coginiti Pro
Connect to and query live Box data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use the CData Software JDBC Driver for Sugar CRM in MicroStrategy Desktop
Connect to Sugar CRM data in MicroStrategy Desktop using the CData Software JDBC Driver for Sugar CRM.
-
How to Query ADP Data in MySQL Workbench
Execute MySQL queries against live ADP data from MySQL Workbench.
-
Add Hugging Face Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Hugging Face with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Microsoft Dataverse Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Microsoft Dataverse data.
-
FTP Reporting in OBIEE with the FTP JDBC Driver
Deploy the FTP JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to SAP Hybris C4C Data from a Connection Pool in Jetty
The SAP Hybris C4C JDBC Driver supports connection pooling: This article shows how to connect faster to SAP Hybris C4C data from Web apps in Jetty.
-
Build Semantic Layer Views for VWO Data in APOS Live Data Gateway
Use the CData Connector for VWO in APOS Live Data Gateway to build Semantic Layer Views for VWO data.
-
Connect to Webflow in SpagoBI
Create reports featuring live Webflow data in SpagoBI Studio. Host Webflow reports on SpagoBI Server.
-
Integrate Cline with Live FTP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live FTP data from within your IDE.
-
Connecting Agentforce with FTP Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your FTP data for you.
-
Model, Search, and Visualize Live ADP Data in ThoughtSpot
Use CData Connect AI to connect to live ADP data for modeling, searching, and visualizing.
-
Integrate with Tavily Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Tavily data to a JSON file on disk.
-
Build a Simple VCL Application for Impala Data
How to build a simple VCL Application to view Impala data in RAD Studio using the CData ODBC Driver for Impala.
-
Access Live Blackbaud FE NXT Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Blackbaud FE NXT data from your Google Sheets.
-
Feed Bugsnag Data into FineReport
How to set Bugsnag data as a JDBC data source in FineReport.
-
Connect to XML Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live XML data.
-
How to Connect to & Open XML Data in Microsoft Excel
This article uses the CData ODBC driver for XML to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Provide OData Services of SpaceX Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SpaceX data by developing a WCF Service Application.
-
Seamlessly Bring Google Cloud Storage Data into Retool Using CData Connect AI
Integrate Google Cloud Storage data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect to LinkedIn Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to LinkedIn.
-
Search External Exa Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Exa data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Exa Data objects that you can access from apps and the dashboard.
-
Integrate Open WebUI with Live Oracle SCM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Oracle SCM data from within the chat interface.
-
Connect to Webflow Data in RapidMiner
Integrate Webflow data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Easily Query PayPal Data in OpenOffice Base
Connect to PayPal data in OpenOffice Base using the CData ODBC Driver for PayPal and generate reports with live data insights.
-
Build Automated Google Cloud Storage-Connected Workflows in Zapier
Use CData Connect AI to connect to live Google Cloud Storage data and build automated workflows in Zapier.
-
Connect to Pushbullet Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Pushbullet data.
-
Create SSAS Tabular Models from DocuSign Data
How to build a SQL Server Analysis Service Tabular Model from DocuSign data using CData drivers.
-
Replicate Optimizely Data to Multiple Databases via the CData Sync CLI
Replicate Optimizely data to disparate databases with a single configuration.
-
Object-Relational Mapping (ORM) with Clio 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 Clio data into a Java-based ORM framework, Hibernate.
-
Integrate Datadog with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Datadog with External Services.
-
Connect to QuickBooks Online Data from PowerBuilder via JDBC
This article demonstrates how to access QuickBooks Online data from PowerBuilder using the QuickBooks Online JDBC Driver.
-
Build Apps with Live ElevenLabs Data Using the Low-Code Development Platform of Mendix
Connect ElevenLabs data with Mendix to build apps using the CData API Driver for JDBC.
-
A PostgreSQL Interface for Blackbaud FE NXT Data (MySQL Remoting via JDBC)
Use the Remoting features of the Blackbaud FE NXT JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Real-Time Freshdesk Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Freshdesk and Dataflow to import and use Freshdesk data in Power Apps.
-
Analyze Google Ads Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Google Ads data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to Contentful Data in DBArtisan
Use wizards in DBArtisan to configure Contentful data as a data source.
-
Access Rebilly 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 Rebilly data.
-
Access Twilio Data from MySQL in Amazon QuickSight
Connect to Twilio and build visualizations of Twilio data using a MySQL Connection in Amazon QuickSight.
-
Connect to GitLab Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to GitLab and work with GitLab data in your FileMaker application.
-
Analyze Live Azure Data Catalog Data in SAS Viya
Use CData Connect AI to connect to Azure Data Catalog data from SAS Viya and deploy self-service analytics using live Azure Data Catalog data.
-
How to Access PostgreSQL Data Using Entity Framework
This article shows how to access PostgreSQL data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Seamlessly Import Airtable Data into IBM SPSS Modeler
Integrate Airtable data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build AfterShip-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live AfterShip data.
-
Integrating Claude Code CLI with Adobe Commerce 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 ConstantContact-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live ConstantContact data.
-
Automated Continuous Sentry Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Sentry replication to PostgreSQL.
-
How to Connect to & Open Square Data in Microsoft Excel
This article uses the CData ODBC driver for Square to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to SurveyMonkey Data from AWS Glue
Use CData Connect AI to gain access to live SurveyMonkey data from your AWS Glue jobs.
-
PabblySubscriptions Reporting in OBIEE with the PabblySubscriptions JDBC Driver
Deploy the PabblySubscriptions JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Load BenchmarkEmail Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load BenchmarkEmail data to a database.
-
Connect to Real-Time SharePoint Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for SharePoint and Dataflow to import and use SharePoint data in Power Apps.
-
Use Dash to Build to Web Apps on Adobe Analytics Data
Create Python applications that use pandas and Dash to build Adobe Analytics-connected web apps.
-
How to Visualize SAS Data Sets Data in Python with pandas
Use pandas and other modules to analyze and visualize live SAS Data Sets data in Python.
-
Connect to MariaDB Data in CloverDX (formerly CloverETL)
Transfer MariaDB data using the visual workflow in the CloverDX data integration tool.
-
Build Data Flows from SQL Server to Cvent through SSIS
Easily push SQL Server data to Cvent using the CData SSIS Tasks for Cvent.
-
Integrating Cursor with Zoho Recruit 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 SingleStore-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for SingleStore Data and create custom apps in Bubble.
-
Use the CData Software JDBC Driver for SAP Ariba Procurement in MicroStrategy Desktop
Connect to SAP Ariba Procurement data in MicroStrategy Desktop using the CData Software JDBC Driver for SAP Ariba Procurement.
-
Enable the TaxJar JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with TaxJar data.
-
Use Biml to Build SSIS Tasks to Replicate Toggl Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Toggl data to SQL Server.
-
How to Create Power BI Visual Reports with Real-Time AlloyDB Data
Use CData Power BI Connectors to visualize AlloyDB data in Power BI.
-
Getting Started with the CData JDBC Driver for Nethunt
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Nethunt.
-
Replicate SendInBlue Data from PowerShell
Write a quick PowerShell script to query SendInBlue data. Use connectivity to the live data to replicate SendInBlue data to SQL Server.
-
Use the CData Software ODBC Driver for Sage 200 in MicroStrategy Web
Connect to Sage 200 data in MicroStrategy Web using the CData Software ODBC Driver for Sage 200.
-
Integrating OpenCode with HubSpot 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 AgileCRM Data from PowerBuilder via JDBC
This article demonstrates how to access AgileCRM data from PowerBuilder using the AgileCRM JDBC Driver.
-
Search External Oracle Financials Cloud Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Oracle Financials Cloud data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Oracle Financials Cloud Data objects that you can access from apps and the dashboard.
-
Migrating data from Salesloft to Databricks using CData SSIS Components.
Easily push Salesloft data to Databricks using the CData SSIS Tasks for Salesloft and Databricks.