CData Software - Knowledge Base
Recent Articles
-
Connect Pipeliner CRM Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Pipeliner CRM data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrating Claude Code with SharePoint Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on SharePoint data within assisted coding and automated development workflows.
-
How to connect to SuiteCRM Data in DBVisualizer
Integrate SuiteCRM data with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate Productboard Data in the Pentaho Report Designer
Publish reports based on Productboard data in the Pentaho BI tool.
-
A PostgreSQL Interface for Zoho CRM Data using the CData ODBC Driver
Use the SQL Gateway and Zoho CRM ODBC Driver to create a PostgreSQL entry-point for data access.
-
Replicate Shippo Data in Heroku for Use in Salesforce Connect
Replicate Shippo data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use the CData ODBC Driver for Dynamics NAV from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Dynamics NAV to connect to Dynamics NAV data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Dynamics NAV data in Excel.
-
Build a Singer.io Tap for LinkedIn With the CData Python Connector
Learn how to easily build a Singer.io Tap for live LinkedIn data using the CData Python Connector.
-
Build Sybase IQ-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Sybase IQ data and build Sybase IQ-connected web apps with Axios.
-
How to Connect to Live Acumatica Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Acumatica data securely in real time.
-
A PostgreSQL Interface for NetSuite Data using the CData ODBC Driver
Use the SQL Gateway and NetSuite ODBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData Python Connector for BenchmarkEmail
Learn to install and license the CData Python Connector and configure a connection to live BenchmarkEmail data.
-
Analyze Live Sage 300 Data in SAS Viya
Use CData Connect AI to connect to Sage 300 data from SAS Viya and deploy self-service analytics using live Sage 300 data.
-
Model MarkLogic Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and MarkLogic, enabling the direct import of real-time MarkLogic data.
-
Integrate Open WebUI with Live SendPulse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live SendPulse data from within the chat interface.
-
How to Connect to Live Google Sheets 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 Google Sheets data for you.
-
Build Visualizations of Teamgate Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Teamgate data in Birst.
-
Getting Started with the CData ODBC Driver for Teamwork
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Teamwork.
-
Design BIRT Reports on PabblySubscriptions Data
Provide current PabblySubscriptions data to your embedded analytics.
-
Automated Continuous Invoiced Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Invoiced replication to Azure SQL Database.
-
Edit and Search External BigCommerce Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of BigCommerce data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create BigCommerce Data objects that you can access from apps and the dashboard.
-
Create a Data Access Object for Dynamics 365 Data using JDBI
A brief overview of creating a SQL Object API for Dynamics 365 data in JDBI.
-
Publish Greenplum-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Greenplum data.
-
Automated Continuous Quaderno Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Quaderno replication to Google BigQuery.
-
Integrate Live Dynamics 365 Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Dynamics 365 from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Dynamics 365 data.
-
Access Zendesk Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Zendesk data from HeidiSQL.
-
Access Live CockroachDB 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 CockroachDB data through MCP integration.
-
Connecting Mastra with Apify Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Apify data, no replication required.
-
How to create Drip federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Drip data in MySQL .
-
Connect to Acumatica Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Acumatica Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Access Live Notion 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 Notion data through MCP integration.
-
Connect to and Query ZohoSubscriptions Data in QlikView over ODBC
Create data visualizations with ZohoSubscriptions data in QlikView.
-
How to import Deel Data into Apache Solr
Use the CData Software JDBC Driver for Deel in Data Import Handler and create an automated import of Deel data to Apache Solr Enterprise Search platform.
-
Integrate LibreChat with Live SAP Hybris C4C Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live SAP Hybris C4C data from within the chat interface.
-
Model ZohoMarketingHub Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and ZohoMarketingHub, enabling the direct import of real-time ZohoMarketingHub data.
-
Connect to Active Directory Data in RazorSQL
Connect to Active Directory from wizards and query Active Directory data from the GUI in the RazorSQL database management tool.
-
Build Stripe-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 Stripe data without replication.
-
Create Informatica Mappings From/To an ODBC Data Source for Square
Create an ODBC connection to Square in Informatica and browse and transfer Square data.
-
Integrate Open WebUI with Live Dynamics CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Dynamics CRM data from within the chat interface.
-
Build AlloyDB-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to AlloyDB Data from Zoho Analytics and import live AlloyDB data.
-
Visualize Productboard Data in Tableau
The CData ODBC driver for Productboard enables you integrate Productboard data into Tableau dashboards.
-
How to connect and process ConvertAPI data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live ConvertAPI data.
-
Use Databricks Agent Bricks to Talk to Your Dropbox Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Dropbox data for you.
-
Build AI Agents with SAS xpt Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live SAS xpt data through CData Connect AI.
-
Integrate with Live FreshBooks Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to FreshBooks from the MuleSoft Anypoint Platform to integrate live FreshBooks data into custom reports and dashboards.
-
Use the CData Software JDBC Driver for Retently in MicroStrategy Desktop
Connect to Retently data in MicroStrategy Desktop using the CData Software JDBC Driver for Retently.
-
Snowflake Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Snowflake data through CData Connect AI using different applications and tools.
-
Natively Connect to MailerSend Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to MailerSend data. Leverage the native support for ODBC in PHP.
-
Automated Continuous SAP SuccessFactors Replication to MySQL
Use CData Sync for automated, continuous, customizable SAP SuccessFactors replication to MySQL.
-
Create Reports with Shortcut Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Shortcut data.
-
Use the CData Software JDBC Driver for ZohoSubscriptions in MicroStrategy
Connect to ZohoSubscriptions data in MicroStrategy Developer using the CData Software JDBC Driver for ZohoSubscriptions.
-
Extract, Transform, and Load Monday.com Data in Informatica PowerCenter
Create a simple Workflow for Monday.com data in Informatica PowerCenter.
-
Automated Continuous Google Cloud Storage Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Google Cloud Storage replication to Google BigQuery.
-
Automated Continuous QuickBooks Online Replication to AlloyDB
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to AlloyDB.
-
Provide OData Services of Vercel Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Vercel data by developing a WCF Service Application.
-
Replicate Bitly Data to Multiple Databases
Replicate Bitly data to disparate databases with a point-and-click configuration.
-
Create ZohoInvoice Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ZohoInvoice data access from reports, embedded analytics, and more.
-
Integrate SAP Netweaver Gateway Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAP Netweaver Gateway data from Informatica Cloud.
-
Creating Notion-Connected Applications in Unqork
You can use CData Connect AI to feed Notion data to Unqork and build custom business apps.
-
How to Visualize PostgreSQL Data in Python with pandas
Use pandas and other modules to analyze and visualize live PostgreSQL data in Python.
-
Connect AgileCRM Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your AgileCRM data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automated Continuous Box Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Box data replication to OneLake in Microsoft Fabric.
-
Create Reports from Bitly Data in Looker Studio
Use CData Connect AI to gain access to live Bitly data and create custom reports in Looker Studio.
-
Create Power BI Reports on Real-Time Humanity Data
Use the CData ODBC Driver for Humanity to visualize Humanity data in Power BI Desktop.
-
Integrating GitHub Copilot with Templated 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 Continuous GitLab Replication to IBM DB2
Use CData Sync for automated, continuous, customizable GitLab replication to IBM DB2.
-
Use Databricks Agent Bricks to Talk to Your Square Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Square data for you.
-
Replicate Multiple SendInBlue Accounts
Replicate multiple SendInBlue accounts to one or many databases.
-
Use the CData Software ODBC Driver for Presto in MicroStrategy Desktop
Connect to Presto data in MicroStrategy Desktop using the CData Software ODBC Driver for Presto.
-
Provide OData Services of Cvent Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Cvent data by developing a WCF Service Application.
-
Access Live Tanda Data in Coginiti Pro
Connect to and query live Tanda data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use the CData Software ODBC Driver for Cloudflare in MicroStrategy Desktop
Connect to Cloudflare data in MicroStrategy Desktop using the CData Software ODBC Driver for Cloudflare.
-
Build ZohoPeople-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live ZohoPeople data.
-
Automated Continuous Azure Blob Storage Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to Google BigQuery.
-
Connect to AfterShip Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for AfterShip to connect to AfterShip data and execute queries in PowerBuilder.
-
How to load PolarTeamPro data into Elasticsearch via Logstash
Introducing a simple method to load PolarTeamPro data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Consume Office 365 OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Office 365 feeds that reflect any changes in SAP Lumira.
-
How to connect to Adobe Target Data in DBVisualizer
Integrate Adobe Target data with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate Devin with Live Dynamics 365 Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Dynamics 365 data.
-
Migrating data from SageHR to Google BigQuery using CData SSIS Components.
Easily push SageHR data to Google BigQuery using the CData SSIS Tasks for SageHR and Google BigQuery.
-
Automated Continuous Cosmos DB Replication to MySQL
Use CData Sync for automated, continuous, customizable Cosmos DB replication to MySQL.
-
Automated Continuous Excel Replication to SQL Server
Use CData Sync for automated, continuous, customizable Excel replication to SQL Server.
-
Automated Continuous AdRoll Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable AdRoll replication to delimited files (CSV/TSV).
-
Use the CData Software ODBC Driver for Elasticsearch in MicroStrategy
Connect to Elasticsearch data in MicroStrategy Developer using the CData Software ODBC Driver for Elasticsearch.
-
Connecting Pipedream with Samanage 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 Samanage data in real time.
-
Automated Continuous Recurly Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Recurly replication to delimited files (CSV/TSV).
-
Connect to SingleStore Data in Aqua Data Studio
Access SingleStore data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create SSAS Tabular Models from Nuclia Data
How to build a SQL Server Analysis Service Tabular Model from Nuclia data using CData drivers.
-
Replicate Amazon S3 Data from PowerShell
Write a quick PowerShell script to query Amazon S3 data. Use connectivity to the live data to replicate Amazon S3 data to SQL Server.
-
Automated Continuous Aweber Replication to Oracle
Use CData Sync for automated, continuous, customizable Aweber replication to Oracle.
-
Create Dynamic Recurly Grids Using the Infragistics XamDataGrid
Learn how you can connect Recurly to Infragistics XamDataGrid to build dynamic grids.
-
Integrating Kiro with Recurly 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 Continuous Dynamics NAV Replication to Databricks
Use CData Sync for automated, continuous, customizable Dynamics NAV replication to Databricks.
-
Build Hive-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Hive data and build web apps with connectivity to live Hive data.
-
Analyze CockroachDB Data in Cognos Analytics
Use CData Connect AI to connect to CockroachDB Data from Cognos Analytics and analyze live CockroachDB data.
-
Easily Integrate Mode Data in Lazarus Pascal IDE
Learn how to easily integrate live Mode data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrating OpenCode with SAP Business One 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 NetSuite-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for NetSuite Data and create custom apps in Mendix.
-
Natively Connect to Copper Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Copper data. Leverage the native support for ODBC in PHP.
-
Freshservice Reporting in OBIEE with the Freshservice JDBC Driver
Deploy the Freshservice JDBC driver on OBIEE to provide real-time reporting across the enterprise.