CData Software - Knowledge Base
Recent Articles
-
Automate Tasks in Power Automate Using the CData API Server
Automate Salesforce Pardot actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Connect to and Query Apify Data in QlikView over ODBC
Create data visualizations with Apify in QlikView.
-
Access Pipedrive Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Pipedrive from your Oracle system.
-
Build Agents in Relevance AI with Access to Live Dynamics CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Microsoft Dynamics CRM within intelligent agent workflows.
-
Connect to Sybase IQ Data in CloverDX (formerly CloverETL)
Transfer Sybase IQ using the visual workflow in the CloverDX data integration tool.
-
Build Elasticsearch-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Elasticsearch to explore live Elasticsearch Data in GitHub Copilot to assist with building Elasticsearch-powered applications.
-
Access Live XML Data in AWS Lambda
Connect to live XML Files in AWS Lambda using the CData JDBC Driver.
-
Build Charts with CouchDB Data in Clear Analytics
Create dynamic charts and perform analytics based on Apache CouchDB in Clear Analytics.
-
Use the CData ODBC Driver for Trello from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Trello to connect to Trello from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Trello in Excel.
-
Access Live SendInBlue Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SendInBlue into the statistical analysis tools available in SAS JMP. This article shows how to use SendInBlue in the Graph Builder and Query Builder.
-
Build AlloyDB-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for AlloyDB to explore live AlloyDB Data in Gemini Code Assist to assist with building AlloyDB-powered applications.
-
Establish a Live Connection with Blackbaud FE NXT Data using Tableau Bridge
The CData ODBC Driver for Blackbaud FE NXT enables you to integrate live Blackbaud FE NXT into Tableau Cloud dashboards using the Tableau Bridge.
-
Visualize Cassandra Data in TIBCO Spotfire through ADO.NET
Integrate Apache Cassandra into dashboards in TIBCO Spotfire.
-
Connect to Box from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Box, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Explore Geographical Relationships in Microsoft OneDrive Data with Power Map
Create data visualizations with Microsoft OneDrive in Power Map.
-
Integrating MariaDB Data in Talend Cloud Data Management Platform
Connect MariaDB Data with Talend Cloud Data Management Platform using the CData JDBC Driver for MariaDB.
-
Use the CData Software ODBC Driver for Microsoft Entra ID in MicroStrategy Web
Connect to Microsoft Entra ID in MicroStrategy Web using the CData Software ODBC Driver for Microsoft Entra ID.
-
Connect to Campaigner Data from a Connection Pool in JBoss
Integrate Campaigner into Java servlets: Use the Management Console in JBoss to install the Campaigner JDBC Driver.
-
Explore Geographical Relationships in PabblySubscriptions Data with Power Map
Create data visualizations with PabblySubscriptions in Power Map.
-
Connecting Agentforce with HCL Domino 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 HCL Domino for you.
-
How to work with LinkedIn Ads Data in Apache Spark using SQL
Access and process LinkedIn Ads Data in Apache Spark using the CData Software JDBC Driver.
-
Object-Relational Mapping (ORM) with Microsoft Ads 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 Microsoft Ads into a Java-based ORM framework, Hibernate.
-
Integrating Claude Code CLI with Kintone 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.
-
Visualize Live NetSuite SuiteAnalytics Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live NetSuite SuiteAnalytics into custom reports in Power BI.
-
Enable the Nethunt JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Nethunt.
-
Connect and Query Live Microsoft Exchange Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Microsoft Exchange into Databricks
-
Getting Started with the CData Excel Add-In for Quickbase
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Quickbase.
-
Operational Reporting on Discord Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Discord.
-
Build Dashboards with Notion Data in DBxtra
Create dynamic dashboards and perform analytics based on Notion in DBxtra.
-
Visualize ZohoExpense Data in Tableau
The CData ODBC driver for ZohoExpense enables you integrate ZohoExpense into Tableau dashboards.
-
Build a Singer.io Tap for Freshteam With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Freshteam data using
-
Feed Deel Data into FineReport
How to set Deel as a JDBC data source in FineReport.
-
Connect to ServiceDesk Plus Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for ServiceDesk Plus.
-
How to Query Live YouTube Analytics Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live YouTube Analytics data in natural language using Python.
-
Automated Continuous HelloSign Replication to MySQL
Use CData Sync for automated, continuous, customizable HelloSign replication to MySQL.
-
DataBind Controls to Act-On Data in C++Builder
DataBind to Act-On in C++Builder with standard components and controls.
-
How to Connect to Live Quickbase 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 Quickbase for you.
-
Creating ActiveCampaign-Connected Applications in Unqork
You can use CData Connect AI to feed ActiveCampaign to Unqork and build custom business apps.
-
Integrate Cline with Live Active Directory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Active Directory from within your IDE.
-
Create Datasets from JotForm in Domo Workbench and Build Visualizations of JotForm Data in Domo
Use the CData Software ODBC Driver for JotForm to create datasets from JotForm in Domo Workbench and then build visualizations in the Domo service.
-
Process & Analyze Microsoft Entra ID Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Microsoft Entra ID Data.
-
Automated Continuous Oracle Replication to SingleStore
Use CData Sync for automated, continuous, customizable Oracle replication to SingleStore.
-
Connect to Dynamics CRM Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Microsoft Dynamics CRM.
-
Use Agno to Talk to Your Sage 200 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Sage 200 for you.
-
LINQ to Amplitude 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 Amplitude Data Provider.
-
Use the CData ODBC Driver for Hubstaff from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Hubstaff to connect to Hubstaff from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Hubstaff in Excel.
-
Getting Started with the CData SSIS Components for CampaignMonitor
Complete guide to installing, licensing, and connecting with the CData SSIS Components for CampaignMonitor.
-
Import Databricks Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Databricks Data and provide access to live Databricks for custom reports in the Power BI Service.
-
Manage SendGrid Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SendGrid.
-
How to connect to Vault CRM Data from IntelliJ
Integrate connectivity to Veeva Vault & Vault CRM with wizards in IntelliJ.
-
Create Dynamic Teamgate Grids Using the Infragistics XamDataGrid
Learn how you can connect Teamgate to Infragistics XamDataGrid to build dynamic grids.
-
Analyze Zoho Inventory Data in Looker
Use CData Connect AI to connect to Zoho Inventory Data from Looker and build custom apps using live Zoho Inventory.
-
Build Dynamics 365 Business Central-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Dynamics 365 Business Central to explore live Dynamics 365 Business Central Data in GitHub Copilot to assist with building Dynamics 365 Business Central-powered applications.
-
Integrating Claude Code CLI with Sage 200 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 Apps with Live Redshift Data Using the Low-Code Development Platform of Mendix
Connect Amazon Redshift with Mendix to build apps using the CData JDBC Driver for Redshift.
-
Integrate with Live QuickBooks Time Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to QuickBooks Time from the MuleSoft Anypoint Platform to integrate live QuickBooks Time into custom reports and dashboards.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for GetResponse
Provide connectivity to GetResponse through an SAP BusinessObjects universe.
-
Access Live HelloSign Data in AWS Lambda (with IntelliJ IDEA)
Connect to live HelloSign in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
A PostgreSQL Interface for ZeroBounce Data using the CData ODBC Driver
Use the SQL Gateway and ZeroBounce ODBC Driver to create a PostgreSQL entry-point for data access.
-
Easily Integrate Email Data in Lazarus Pascal IDE
Learn how to easily integrate live Email in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Easily Integrate MySQL Data in Lazarus Pascal IDE
Learn how to easily integrate live MySQL in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous EnterpriseDB Replication to SQLite
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to SQLite.
-
Getting Started with the CData Tableau Connector for SuiteCRM
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SuiteCRM.
-
Working with Gmail Data in LINQPad
Execute LINQ queries to Gmail in LINQPad.
-
DataBind Controls to ClickTime Data in C++Builder
DataBind to ClickTime in C++Builder with standard components and controls.
-
Connect to and Query Asana Data in QlikView over ODBC
Create data visualizations with Asana in QlikView.
-
Automated Continuous Rebilly Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Rebilly replication to Google Cloud SQL.
-
Connect to Clari Data in HULFT Integrate
Connect to Clari as a JDBC data source in HULFT Integrate
-
Use Dash to Build to Web Apps on Codat Data
Create Python applications that use pandas and Dash to build Codat-connected web apps.
-
How to Connect to HDFS Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Apache HDFS. Leverage the pyodbc module for ODBC in Python.
-
Connect to Live Azure DevOps Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Azure DevOps in CData Connect AI and connect to your Azure DevOps from PostgreSQL.
-
Connect to Opsgenie Data from PowerBuilder via ADO.NET
This article demonstrates how to access Opsgenie from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to load Square data into Elasticsearch via Logstash
Introducing a simple method to load Square data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automate Bitbucket Data Replication to Couchbase
Use CData Sync to Customize and automate Bitbucket replication to Couchbase.
-
How to connect to CockroachDB Data in DBVisualizer
Integrate CockroachDB with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous SharePoint Replication to SQLite
Use CData Sync for automated, continuous, customizable SharePoint replication to SQLite.
-
Design BIRT Reports on SAP Ariba Source Data
Provide current SAP Ariba Source to your embedded analytics.
-
Connect to Copper Data in DBArtisan
Use wizards in DBArtisan to configure Copper as a data source.
-
DataBind Charts to Vercel Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Vercel 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.
-
Automated Continuous Optimizely Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Optimizely replication to PostgreSQL.
-
Using the CData Software ODBC Driver for Azure DevOps in PyCharm
Connect to Azure DevOps as an ODBC data source in PyCharm using the CData Software ODBC Driver for Azure DevOps.
-
Query, Visualize, and Share live SAP HANA Data in Redash
Use CData Connect AI to connect to live SAP HANA in Redash for querying, visualizing, and sharing.
-
Validate CouchDB Data with QuerySurge
Access and validate Apache CouchDB in QuerySurge using the CData JDBC Driver.
-
Extract, Transform, and Load Facebook Ads Data in Informatica PowerCenter
Create a simple Workflow for Facebook Ads in Informatica PowerCenter.
-
Connect to iContact Data from a Connection Pool in JBoss
Integrate iContact into Java servlets: Use the Management Console in JBoss to install the iContact JDBC Driver.
-
Automated Continuous Stack Exchange Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Stack Exchange replication to PostgreSQL.
-
How to Seamlessly Import AdRoll Data into IBM SPSS Modeler
Integrate AdRoll data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Extract, Transform, and Load ServiceDesk Plus Data in Informatica PowerCenter
Create a simple Workflow for ServiceDesk Plus in Informatica PowerCenter.
-
Use Dash to Build to Web Apps on Twitter Ads Data
Create Python applications that use pandas and Dash to build Twitter Ads-connected web apps.
-
Build Dashboards with Workday Data in Dundas BI
Create dynamic dashboards and perform analytics based on Workday in Dundas BI.
-
Connect Toggl Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Toggl using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Azure Data Catalog Data in Jaspersoft Studio
Execute SQL to remote Azure Data Catalog in Jaspersoft Studio.
-
Connect to Kintone Data in DBArtisan
Use wizards in DBArtisan to configure Kintone as a data source.
-
Use the CData ODBC Driver for Printify in Microsoft Power Query
You can use the CData Printify ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Printify into Microsoft Power Query.
-
Access Live Couchbase Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Couchbase from your Google Sheets.
-
Feed Amazon S3 Data into FineReport
How to set Amazon S3 as a JDBC data source in FineReport.
-
Use Agno to Talk to Your GitLab Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your GitLab for you.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live MariaDB using the Model Context Protocol.
-
Connect to NetSuite Data from PowerBuilder via ADO.NET
This article demonstrates how to access NetSuite CRM & ERP from Appeon PowerBuilder using the CData ADO.NET Provider for NetSuite.
-
Getting Started with the CData ODBC Driver for Reply.io
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Reply.io.