CData Software - Knowledge Base
Recent Articles
-
Integrate LibreChat with Live ActiveCampaign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live ActiveCampaign data from within the chat interface.
-
How to Connect to Live CSV Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your CSV data for you.
-
How to Connect to Live ShipEngine Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live ShipEngine data without replication.
-
Connect to Freshsales 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 Freshsales and work with Freshsales data in your FileMaker application.
-
Integrate Goose with Live SAP BusinessObjects BI Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live SAP BusinessObjects BI data from within the local AI agent.
-
Getting Started with the CData ADO.NET Provider for Beeminder
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Integrate AgileCRM with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate AgileCRM with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to AgileCRM data.
-
Replicate Missive Data to Multiple Databases via the CData Sync CLI
Replicate Missive data to disparate databases with a single configuration.
-
How to connect to PhantomBuster Data from Spring Boot
Connect to PhantomBuster in a Spring Boot Application using the CData API Driver for JDBC
-
Migrating data from Parquet to Google BigQuery using CData SSIS Components.
Easily push Parquet data to Google BigQuery using the CData SSIS Tasks for Parquet and Google BigQuery.
-
Connect to Active Directory Data in Aqua Data Studio
Access Active Directory data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create Data Visualizations Based On Instagram Data in Mode
Use CData Connect AI to connect to Instagram Data from Mode and build visualizations using live Instagram data.
-
Access Live SAP Business Warehouse Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live SAP Business Warehouse data through MCP integration.
-
Automated Continuous SAP Concur Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable SAP Concur replication to Azure SQL Database.
-
Access Oracle Eloqua Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Oracle Eloqua data from HeidiSQL.
-
How to connect to PagerDuty Data in DBVisualizer
Integrate PagerDuty data with visual data analysis tools and data connection wizards in DBVisualizer
-
Manage Marketo Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Marketo.
-
Migrating data from Mailjet to Google BigQuery using CData SSIS Components.
Easily push Mailjet data to Google BigQuery using the CData SSIS Tasks for Mailjet and Google BigQuery.
-
Connect to and Visualize Live MYOB AccountRight Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live MYOB AccountRight data.
-
Replicate Printful Data to Multiple Databases via the CData Sync CLI
Replicate Printful data to disparate databases with a single configuration.
-
Explore Geographical Relationships in ClickUp Data with Power Map
Create data visualizations with ClickUp data in Power Map.
-
Access Live Lakebase 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 Lakebase data through MCP integration.
-
Bidirectional Access to Hive Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Hive data in Filemaker Pro for Mac or Windows.
-
Integrate Open WebUI with Live GitLab Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live GitLab data from within the chat interface.
-
Integrate with Placid Data in JReport Designer
Create charts and reports based on Placid data in JReport Designer.
-
Integrate SAP with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SAP with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SAP data.
-
Validate Hugging Face Data with QuerySurge
Access and validate Hugging Face data in QuerySurge using the CData JDBC Driver.
-
Excel Spreadsheet Automation on FormSite Data with the QUERY Formula
Pull data from FormSite, automate spreadsheets, and more with the QUERY formula.
-
Integrate Trae with Live Cassandra Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Cassandra data from within the AI-powered IDE.
-
Integrate Live SurveyMonkey Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SurveyMonkey data to Blue Prism using the CData ODBC Driver for SurveyMonkey to create automated workflows for repetitive business tasks.
-
Integrate Trae with Live Sybase Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Sybase data from within the AI-powered IDE.
-
LINQ to ScrapingBee 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 ScrapingBee Data Provider.
-
Access Zuora Data from MySQL in Amazon QuickSight
Connect to Zuora and build visualizations of Zuora data using a MySQL Connection in Amazon QuickSight.
-
Access QuickBooks Online Data from MySQL in Amazon QuickSight
Connect to QuickBooks Online and build visualizations of QuickBooks Online data using a MySQL Connection in Amazon QuickSight.
-
Integrate Theia IDE with Live SAP Concur 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 SAP Concur data from within the development environment.
-
DataBind Controls to EmailOctopus Data in Delphi
DataBind to EmailOctopus data in Delphi with standard data access components and controls.
-
Enable the Campaigner JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Campaigner data.
-
Automate ConvertAPI Data Replication to Azure Data Lake
Use CData Sync to customize and automate ConvertAPI data replication to Azure Data Lake.
-
Use the CData Software JDBC Driver for Egnyte in MicroStrategy Desktop
Connect to Egnyte data in MicroStrategy Desktop using the CData Software JDBC Driver for Egnyte.
-
Connect to Google Forms Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Google Forms and work with Google Forms data in your FileMaker applications.
-
Integrating Gumloop with Slack Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Slack data within automated workflows.
-
Create Dynamic SFTP Grids Using the Infragistics XamDataGrid
Learn how you can connect SFTP to Infragistics XamDataGrid to build dynamic grids.
-
Load Brex Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Brex data to a database.
-
Access Live Discord Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Discord data from your Excel spreadsheets.
-
Integrate GraphQL Data in Pentaho Data Integration
Build ETL pipelines based on GraphQL data in the Pentaho Data Integration tool.
-
Create Redshift-Connected Dashboards in Grafana
Connect to Redshift Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Redshift data.
-
Visualize Testmonitor Data in Tableau
The CData ODBC driver for Testmonitor enables you integrate Testmonitor data into Tableau dashboards.
-
Integrating Gumloop with BambooHR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on BambooHR data within automated workflows.
-
Connect to Act-On Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Act-On to connect to Act-On data and execute queries in PowerBuilder.
-
How to Work with Dynamics 365 Data in ETL Validator JDBC
Connect to Dynamics 365 from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate with Live Lakebase Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Lakebase from the MuleSoft Anypoint Platform to integrate live Lakebase data into custom reports and dashboards.
-
Analyze Live Shortcut Data in SAS Viya
Use CData Connect AI to connect to Shortcut data from SAS Viya and deploy self-service analytics using live Shortcut data.
-
Create SSAS Tabular Models from Simplesat Data
How to build a SQL Server Analysis Service Tabular Model from Simplesat data using CData drivers.
-
Visualize Live Parallel Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Parallel data.
-
Edit and Search External Greenplum Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Greenplum data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Greenplum Data objects that you can access from apps and the dashboard.
-
Connect to Kintone Data in Google Apps Script via Connect AI
Use CData Connect AI to access Kintone data in Google Apps Script.
-
Build Data Flows from ZohoDesk to SQL Server using SSIS
Easily back up ZohoDesk data to SQL Server using the SSIS components for ZohoDesk.
-
How to Connect Flowise AI Agents to Live MYOB AccountRight 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 MYOB AccountRight data without replication.
-
Build a Simple VCL Application for Google Calendar Data
How to build a simple VCL Application to view Google Calendar data in RAD Studio using the CData ODBC Driver for Google Calendar.
-
How to Query Short.io Data in MySQL Workbench
Execute MySQL queries against live Short.io data from MySQL Workbench.
-
LINQ to XML 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 XML Data Provider.
-
Use the CData Software JDBC Driver for FTP in MicroStrategy Desktop
Connect to FTP data in MicroStrategy Desktop using the CData Software JDBC Driver for FTP.
-
Replicate Multiple Keap Accounts
Replicate multiple Keap accounts to one or many databases.
-
How to create Attio federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Attio data in MySQL .
-
Connecting Pipedream with Freshdesk 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 Freshdesk data in real time.
-
Build ActiveCampaign-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live ActiveCampaign data and build ActiveCampaign-connected web apps with Axios.
-
Connect to SpaceX 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 SpaceX and work with SpaceX data in your FileMaker application.
-
Integrate with Live Avro Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Avro from the MuleSoft Anypoint Platform to integrate live Avro data into custom reports and dashboards.
-
Build Bitly Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Bitly data and build visualizations in Tableau.
-
Bind Live SurveyMonkey Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SurveyMonkey data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
A PostgreSQL Interface for Act CRM Data using the CData ODBC Driver
Use the SQL Gateway and Act CRM ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create SSAS Tabular Models from Paylocity Data
How to build a SQL Server Analysis Service Tabular Model from Paylocity data using CData drivers.
-
Build Semantic Layer Views for Cvent Data in APOS Live Data Gateway
Use the CData Connector for Cvent in APOS Live Data Gateway to build Semantic Layer Views for Cvent data.
-
How to Connect to Live SQL Server 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 SQL Server data through natural language.
-
Integrate with live PostgreSQL Data in Jitterbit
Use CData Connect AI to connect to and integrate live PostgreSQL data in Jitterbit.
-
Create Informatica Mappings From/To an ODBC Data Source for Microsoft OneDrive
Create an ODBC connection to Microsoft OneDrive in Informatica and browse and transfer Microsoft OneDrive data.
-
Automated Continuous ZeroBounce Replication to Amazon S3
Use CData Sync for automated, continuous, customizable ZeroBounce replication to Amazon S3.
-
Creating FTP-Connected Applications in Unqork
You can use CData Connect AI to feed FTP data to Unqork and build custom business apps.
-
Create Data Visualizations in Cognos BI with Flowlu Data
Access Flowlu data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrate Salesforce Pardot Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Salesforce Pardot data from Informatica Cloud.
-
Import Jira Assets Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Jira Assets Data and provide access to live Jira Assets data for custom reports in the Power BI Service.
-
DataBind Controls to PayPal Data in Delphi
DataBind to PayPal data in Delphi with standard data access components and controls.
-
Connect to SAP SuccessFactors Data from HeidiSQL
Use CData Connect AI to connect to and query live SAP SuccessFactors data from HeidiSQL.
-
Integrating Claude Code CLI with Todoist 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.
-
Query Microsoft Teams Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Microsoft Teams entities in PHP by modeling them as objects.
-
Access Live BambooHR Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live BambooHR data through MCP integration.
-
Use the CData Software ODBC Driver for Adobe Experience Manager in SAS for Real-Time Reporting and Analytics
Connect to real-time Adobe Experience Manager data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Adobe Experience Manager.
-
Integrate Jira Assets with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Jira Assets with External Services.
-
Use Biml to Build SSIS Tasks to Replicate PhantomBuster Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate PhantomBuster data to SQL Server.
-
Create Informatica Mappings From/To a JDBC Data Source for Qualaroo
Create Qualaroo data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Cohere Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Cohere facts in real time.
-
A PostgreSQL Interface for Google Forms Data (MySQL Remoting via JDBC)
Use the Remoting features of the Google Forms JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect PolyBase to Paddle
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Paddle data.
-
Connect to ConstantContact Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for ConstantContact data in Airbyte.
-
Automated Continuous Microsoft Entra ID Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Microsoft Entra ID replication to Apache Cassandra.
-
Getting Started with the CData ADO.NET Provider for Vercel
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Build IBM Cloud Object Storage-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 IBM Cloud Object Storage data without replication.
-
Connect to SparkPost Data in RazorSQL
Connect to SparkPost from wizards and query SparkPost data from the GUI in the RazorSQL database management tool.
-
Back Up MariaDB data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for MariaDB. In this article, we will employ an SSIS workflow to populate a database with MariaDB data data.
-
How to connect Amazon QuickSight to Attio Data
Create a connection to Attio data in CData Connect AI and insert Attio data into Amazon QuickSight SPICE to build interactive dashboards.