CData Software - Knowledge Base
Recent Articles
-
Access Live Blackbaud FE NXT 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 Blackbaud FE NXT data through MCP integration.
-
Use the CData Software JDBC Driver for Moosend in MicroStrategy
Connect to Moosend data in MicroStrategy Developer using the CData Software JDBC Driver for Moosend.
-
Build Dashboards with Landbot Data in DBxtra
Create dynamic dashboards and perform analytics based on Landbot data in DBxtra.
-
Access Miro 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 Miro data.
-
Access QuickBooks Company File Data from DBeaver
Use the CData JDBC Driver for QuickBooks to access QuickBooks as a JDBC data source through the DBeaver connection manager.
-
Build Data Flows from Google Translate to SQL Server using SSIS
Easily back up Google Translate data to SQL Server using the SSIS components for Google Translate.
-
Connect to Phoenix from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Phoenix data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to Connect to Live BambooHR 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 BambooHR data for you.
-
How to Query Live ChartMogul Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ChartMogul data data in natural language using Python.
-
How to Connect to Live Cvent 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 Cvent data for you.
-
Build AI/ML Models with Live Amazon Athena Data using Dataiku
Connect Amazon Athena Data with Dataiku using the CData JDBC Driver for Amazon Athena.
-
Publish Discord-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Discord data.
-
Create SAP Business One Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SAP Business One data access from reports, embedded analytics, and more.
-
Analyze Salesforce Marketing Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Salesforce Marketing data with the CData JDBC Driver for Salesforce Marketing.
-
Integrating OpenCode with Close 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.
-
Analyze Snowflake Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Snowflake data in Microsoft R Open.
-
How to connect to Foursquare Data in DBVisualizer
Integrate Foursquare data with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate Avro Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Avro data from Informatica Cloud.
-
Create Informatica Mappings From/To a JDBC Data Source for Outreach.io
Create Outreach.io data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Create Sage 300 Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Sage 300 data access from reports, embedded analytics, and more.
-
How to Connect Flowise AI Agents to Live SAP Business One 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 SAP Business One data without replication.
-
Integrate Theia IDE with Live Shopify Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Shopify data from within the development environment.
-
Natively Connect to SendGrid Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SendGrid data. Leverage the native support for ODBC in PHP.
-
Validate GitLab Data with QuerySurge
Access and validate GitLab data in QuerySurge using the CData JDBC Driver.
-
Connect Kintone Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Kintone data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Easily Integrate HBase Data in Lazarus Pascal IDE
Learn how to easily integrate live HBase data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Visualize Campaigner Data in Tableau
The CData ODBC driver for Campaigner enables you integrate Campaigner data into Tableau dashboards.
-
Connect to Missive Data from a Connection Pool in Jetty
The Missive JDBC Driver supports connection pooling: This article shows how to connect faster to Missive data from Web apps in Jetty.
-
View Reports on Real-Time Blackbaud FE NXT Data in Power BI Report Server
Use the CData ODBC Driver for Blackbaud FE NXT to visualize Blackbaud FE NXT data in Power BI Desktop and then publish them to Power BI Report Server.
-
Automated Continuous Landbot Replication to MySQL
Use CData Sync for automated, continuous, customizable Landbot replication to MySQL.
-
How to Connect to SuiteCRM Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SuiteCRM data. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous WordPress Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable WordPress replication to Apache Kafka.
-
How to Work with Campaigner Data in ETL Validator JDBC
Connect to Campaigner from ETL Validator jobs using the CData Software JDBC Driver.
-
Getting Started with the CData Python Connector for Harvest
Learn to install and license the CData Python Connector and configure a connection to live Harvest data.
-
Access Live Shopify Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Shopify data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automate SendGrid Data Replication to Couchbase
Use CData Sync to Customize and automate SendGrid data replication to Couchbase.
-
Work with Supabase Data in FoxPro
Load Supabase data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to MySQL Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for MySQL Data and connect to MySQL data in Akorbi Digital RunMyProcess.
-
How to use SQLAlchemy ORM to access Egnyte Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Egnyte data.
-
Create Reports from Shortcut Data in Looker Studio
Use CData Connect AI to gain access to live Shortcut data and create custom reports in Looker Studio.
-
Integrating Codex with MarkLogic 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.
-
Automated MongoDB Data Replication to Teradata
Use CData Sync to Customize and automate MongoDB data replication to Teradata.
-
Integrate ConstantContact Data into Power Automate Desktop using CData Connect
CData Connect for ConstantContact Data enables you to integrate ConstantContact data into workflows built using Microsoft Power Automate Desktop.
-
Connect to PostgreSQL Data in JRuby
Create a simple JRuby app with access to live PostgreSQL data.
-
Moving Data from Front to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Front data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to integrate Metabase with SAS Data Sets Data
Use CData Connect AI to connect to live SAS Data Sets data and create an interactive dashboard in Metabase from SAS Data Sets data.
-
Publish Cloudflare-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Cloudflare data.
-
Query AgileCRM Data in DataGrip
Create a Data Source for AgileCRM in DataGrip and use SQL to query live AgileCRM data.
-
Create SAP Concur-Connected Business Apps in AppSheet
Connect to SAP Concur Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to SAP Concur data.
-
Explore Geographical Relationships in EnterpriseDB Data with Power Map
Create data visualizations with EnterpriseDB data in Power Map.
-
Build Agents in Relevance AI with Access to Live Acumatica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Acumatica data within intelligent agent workflows.
-
How to Work with Phoenix Data in AWS Glue Jobs Using JDBC
Connect to Phoenix from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use the CData Software ODBC Driver for Basecamp in MicroStrategy
Connect to Basecamp data in MicroStrategy Developer using the CData Software ODBC Driver for Basecamp.
-
Feed RSS Feeds into FineReport
How to set RSS feeds as a JDBC data source in FineReport.
-
Analyze Teamwork Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Teamwork data in Microsoft R Open.
-
EmailOctopus Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on EmailOctopus facts in real time.
-
Working with Zoho CRM Data in LINQPad
Execute LINQ queries to Zoho CRM data in LINQPad.
-
Create a Data Access Object for CSV Data using JDBI
A brief overview of creating a SQL Object API for CSV data in JDBI.
-
How to Work with xBase Data in AWS Glue Jobs Using JDBC
Connect to xBase from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create Highrise Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Highrise from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create a Data Access Object for Kafka Data using JDBI
A brief overview of creating a SQL Object API for Kafka data in JDBI.
-
Prepare, Blend, and Analyze MailChimp Data in Alteryx Designer (Connect AI)
Build workflows to access live MailChimp data for self-service data analytics.
-
How to connect to MongoDB Data from IntelliJ
Integrate connectivity to MongoDB data with wizards in IntelliJ.
-
Getting Started with the CData Power BI Connector for Presto
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Presto.
-
Build Twilio-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Twilio data without replication.
-
Replicate SpaceX Data in Heroku for Use in Salesforce Connect
Replicate SpaceX data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Query Timely Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Timely data from Node.js.
-
DataBind Controls to eBay Data in C++Builder
DataBind to eBay data in C++Builder with standard components and controls.
-
How to Seamlessly Import Microsoft Planner Data into IBM SPSS Modeler
Integrate Microsoft Planner data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Visualize JotForm Data in Tableau
The CData ODBC driver for JotForm enables you integrate JotForm data into Tableau dashboards.
-
Getting Started with the CData Excel Add-In for Amazon Marketplace
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Amazon Marketplace.
-
Integrating OpenCode with HBase 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.
-
Microsoft Teams Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Microsoft Teams data through CData Connect AI using different applications and tools.
-
Integrating Cursor with HubDB 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.
-
Access Live eBay Analytics Data in Excel 365 Online (Excel for the web)
Connect to eBay Analytics data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Access Everhour 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 Everhour data.
-
Connect to and Visualize Live Rootly Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Rootly data.
-
Query SAP Ariba Procurement Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SAP Ariba Procurement data from Node.js.
-
Integrating LangGraph with LinkedIn Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on LinkedIn data within automated workflows.
-
Bridge Elorus Connectivity with Apache NiFi
Access and process Elorus data in Apache NiFi using the CData JDBC Driver.
-
Connect Slack to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Slack with IBM WebSphere for seamless data integration and connectivity.
-
Build Data Flows from SQL Server to Microsoft Planner through SSIS
Easily push SQL Server data to Microsoft Planner using the CData SSIS Tasks for Microsoft Planner.
-
DataBind Controls to Discord Data in Delphi
DataBind to Discord data in Delphi with standard data access components and controls.
-
Viewing Intercom Data in RAD Studio Data Explorer
How to view Intercom data in RAD Studio Data Explorer using the CData ODBC Driver for Intercom.
-
Access Live Sage 300 Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Sage 300 data from your Excel spreadsheets.
-
Connect to SAP Ariba Procurement Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SAP Ariba Procurement as an External Source in Dremio.
-
Automated Continuous Salesforce Replication to Oracle
Use CData Sync for automated, continuous, customizable Salesforce replication to Oracle.
-
Automated Continuous Pinecone Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Pinecone replication to Amazon Redshift.
-
Connect to Recurly Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Recurly and the SQL Gateway to access Recurly data from Google Apps Script.
-
Automated Continuous Sage 300 Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Sage 300 replication to Azure SQL Database.
-
Automated Continuous GitLab Replication to Vertica
Use CData Sync for automated, continuous, customizable GitLab replication to Vertica.
-
Query Klipfolio Data in DataGrip
Create a Data Source for Klipfolio in DataGrip and use SQL to query live Klipfolio data.
-
Connect to Real-Time Vault CRM Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Vault CRM and Dataflow to import and use Vault CRM data in Power Apps.
-
Connect to Bullhorn CRM Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Bullhorn CRM data from Filemaker Pro on Mac.
-
Create Twitter Ads-Connected Applications in Appsmith
Connect to Twitter Ads Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Twitter Ads data.
-
How to create an RPA flow for Short.io Data in UiPath Studio
Use the Short.io ODBC Driver to create workflows that access real-time Short.io data without any coding.
-
Connect to Google Calendar Data in DBArtisan
Use wizards in DBArtisan to configure Google Calendar data as a data source.
-
How to Access Excel Data Using Entity Framework
This article shows how to access Excel data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Getting Started with the CData Tableau Connector for Adobe Target
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Adobe Target.
-
Connect Gong to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Gong data using the CData Python MCP Server.