CData Software - Knowledge Base
Recent Articles
-
Integrating LangChain with PostgreSQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on PostgreSQL within automated workflows.
-
Use the CData ODBC Driver for RSS in Microsoft Power Query
You can use the CData RSS ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import RSS Feeds into Microsoft Power Query.
-
How to Import Data from Amazon Athena into Google Sheets
Import Amazon Athena into a Google spreadsheet that is automatically refreshed.
-
Connect to PivotalTracker Data from a Connection Pool in Jetty
The PivotalTracker JDBC Driver supports connection pooling: This article shows how to connect faster to PivotalTracker from Web apps in Jetty.
-
Build MVC Applications with Connectivity to Google Translate Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Google Translate from an ASP.NET MVC application.
-
Stream Asana Data into Apache Kafka Topics
Access and stream Asana in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Visualize Spark Data in TIBCO Spotfire through ADO.NET
Integrate Apache Spark SQL into dashboards in TIBCO Spotfire.
-
Work with Klipfolio Data in FoxPro
Load Klipfolio into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create a Data Access Object for Vercel Data using JDBI
A brief overview of creating a SQL Object API for Vercel in JDBI.
-
Visualize Miro Data in TIBCO Spotfire through OData
Integrate Miro into dashboards in TIBCO Spotfire.
-
Query, Visualize, and Share live Excel Online Data in Redash
Use CData Connect AI to connect to live Microsoft Excel Online in Redash for querying, visualizing, and sharing.
-
Integrate Campaigner Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Campaigner from Informatica Cloud.
-
Connect to Adobe Commerce Data from AWS Glue
Use CData Connect AI to gain access to live Adobe Commerce from your AWS Glue jobs.
-
Model MYOB AccountRight Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and MYOB AccountRight, enabling the direct import of real-time MYOB AccountRight.
-
Integrating Codex CLI with Short.io 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.
-
How to Query Mixpanel Data in MySQL Workbench
Execute MySQL queries against live Mixpanel from MySQL Workbench.
-
Create Informatica Mappings From/To a JDBC Data Source for Act CRM
Create Act CRM data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Rapidly Develop Harvest-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Harvest.
-
Analyze MailChimp Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for MailChimp from Power Pivot. You will use the Table Import Wizard to load MailChimp. You can visually build the import query or use any SQL supported by the driver.
-
How to Connect CouchDB Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live CouchDB data in real time using natural language.
-
Create Data Visualizations in Cognos BI with Microsoft Entra ID Data
Access Microsoft Entra ID as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Cosmos DB Data in NetBeans
Connect to Azure Cosmos DB in NetBeans with the data source configuration wizard.
-
Getting Started with the CData Python Connector for Optimizely
Learn to install and license the CData Python Connector
-
Build Google Contacts-Connected Apps in Choreo
Use CData Connect AI to connect to Google Contacts Data from Choreo and build custom apps using live Google Contacts.
-
Perform Batch Operations with SQL Server Data in Apache NiFi
Connect to Microsoft SQL Server and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Use Dash to Build to Web Apps on MarkLogic Data
Create Python applications that use pandas and Dash to build MarkLogic-connected web apps.
-
Viewing Salesforce Data 360 Data in RAD Studio Data Explorer
How to view Salesforce Data 360 in RAD Studio Data Explorer using the CData ODBC Driver for Salesforce Data 360.
-
How to Easily Query Bitly Data in OpenOffice Base
Connect to Bitly data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Access Live OneNote 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 Microsoft OneNote through MCP integration.
-
Create Zendesk-Connected Dashboards in Grafana
Connect to Zendesk Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Zendesk.
-
Connect to Discourse Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Discourse as an External Source in Dremio.
-
Create Data Visualizations in Cognos BI with Jira Assets Data
Access Jira Assets as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Publish Klaviyo-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Klaviyo.
-
Access Pinterest Data from MySQL in PHP
Connect to Pinterest through the standard MySQL libraries in PHP.
-
Connect to QuickBooks Online Data in Ruby
Connect to QuickBooks Online in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Connect to Live Cosmos DB Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Azure Cosmos DB for you.
-
Create Dynamic Aha! Grids Using the Infragistics XamDataGrid
Learn how you can connect Aha! to Infragistics XamDataGrid to build dynamic grids.
-
Replicate Freshteam Data in Heroku for Use in Salesforce Connect
Replicate Freshteam to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use JayDeBeApi to access CloudConvert Data in Python
Use standard Python scripting and the development environment of your choice to access live CloudConvert.
-
Integrating Antigravity CLI with GetResponse via CData CLI
Connect GetResponse to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Load SuiteCRM Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SuiteCRM to a database.
-
Use the CData Software JDBC Driver for EmailOctopus in MicroStrategy Web
Connect to EmailOctopus in MicroStrategy Web using the CData Software JDBC Driver for EmailOctopus.
-
Use ChatGPT to Talk to Your Trello Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Trello for you.
-
Connect to Azure Data Lake Storage Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Azure Data Lake Storage.
-
How to connect to SAP Netweaver Gateway Data with Squirrel SQL client
Connect to SAP Netweaver Gateway and execute queries in the Squirrel SQL Client.
-
Integrating Paylocity Data in Talend Cloud Data Management Platform
Connect Paylocity Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Paylocity.
-
Publish Crystal Reports on Klipfolio Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Klipfolio.
-
Connecting GenSpark with YouTube Analytics Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to YouTube Analytics without any replication or custom integration required.
-
Build Agents in Relevance AI with Access to Live Monday.com Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Monday.com within intelligent agent workflows.
-
Connect to HDFS Data as an External Source in Dremio
Use the CData JDBC Driver to connect to HDFS as an External Source in Dremio.
-
Visualize Zoho CRM Data in TIBCO Spotfire through ADO.NET
Integrate Zoho CRM into dashboards in TIBCO Spotfire.
-
Use the CData Software JDBC Driver for HDFS in MicroStrategy Desktop
Connect to Apache HDFS in MicroStrategy Desktop using the CData Software JDBC Driver for HDFS.
-
Integrate with Salesforce CRM Analytics Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Salesforce CRM Analytics to a JSON file on disk.
-
Create Snowflake Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Snowflake from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Import Data from Wrike into Google Sheets
Import Wrike into a Google spreadsheet that is automatically refreshed.
-
Configure the CData JDBC Driver for Apollo in a Connection Pool in Tomcat
Connect to Apollo from a connection pool in Tomcat.
-
Build Dashboards with PagerDuty Data in Dundas BI
Create dynamic dashboards and perform analytics based on PagerDuty in Dundas BI.
-
Creating Box-Connected Applications in Unqork
You can use CData Connect AI to feed Box to Unqork and build custom business apps.
-
Visualize Zoom Data in TIBCO Spotfire through OData
Integrate Zoom into dashboards in TIBCO Spotfire.
-
Integrating Cursor CLI with ChartMogul 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.
-
How to Create Power BI Visual Reports with Real-Time ZohoInvoice Data
Use CData Power BI Connectors to visualize ZohoInvoice in Power BI.
-
Integrate Azure DevOps Data in Pentaho Data Integration
Build ETL pipelines based on Azure DevOps in the Pentaho Data Integration tool.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Apache Impala within intelligent workflows.
-
Build Apps with Live NetSuite Data Using the Low-Code Development Platform of Mendix
Connect NetSuite CRM & ERP with Mendix to build apps using the CData JDBC Driver for NetSuite.
-
Automated Continuous Accelo Replication to SingleStore
Use CData Sync for automated, continuous, customizable Accelo replication to SingleStore.
-
Analyze BigCommerce Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze BigCommerce with the CData JDBC Driver for BigCommerce.
-
Automated Continuous Klipfolio Replication to Databricks
Use CData Sync for automated, continuous, customizable Klipfolio replication to Databricks.
-
Choosing the Best Method to Connect BambooHR to SQL Server: 5 Options Explained
Discover multiple ways to connect and use BambooHR from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Office 365 Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Microsoft Office 365 using standard SQL.
-
Connect to Qualaroo 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 Qualaroo and work with Qualaroo in your FileMaker application.
-
Integrate LinkedIn with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate LinkedIn with External Services.
-
Connect to Bitbucket Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Bitbucket and the Script function in FileMaker Pro to connect to Bitbucket and work with Bitbucket in your FileMaker application.
-
Build Visualizations of Spotify Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Spotify in Birst.
-
How to Connect to Calendly Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Calendly. Leverage the pyodbc module for ODBC in Python.
-
Integrating Codex CLI with Zuora 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 Figshare Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Figshare with the CData JDBC Driver for Figshare.
-
Automate ZohoExpense Data Replication to Couchbase
Use CData Sync to Customize and automate ZohoExpense replication to Couchbase.
-
Connect to SAP Ariba Source Data in ACL Analytics
Connect to SAP Ariba Source via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to SAP Ariba Source.
-
Create Mouseflow Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Mouseflow from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to PabblySubscriptions Data from a Connection Pool in Jetty
The PabblySubscriptions JDBC Driver supports connection pooling: This article shows how to connect faster to PabblySubscriptions from Web apps in Jetty.
-
Integrate Live Twilio Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Twilio to Blue Prism using the CData ODBC Driver for Twilio to create automated workflows for repetitive business tasks.
-
Integrate Spark with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Spark with External Services.
-
Build Semantic Layer Views for Quickbase Data in APOS Live Data Gateway
Use the CData Connector for Quickbase in APOS Live Data Gateway to build Semantic Layer Views for Quickbase.
-
Build Semantic Layer Views for Vercel Data in APOS Live Data Gateway
Use the CData Connector for Vercel in APOS Live Data Gateway to build Semantic Layer Views for Vercel.
-
Create Reports from Spark Data in Looker Studio
Use CData Connect AI to gain access to live Apache Spark SQL and create custom reports in Looker Studio.
-
Connect to MailerLite Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to MailerLite and work with MailerLite in your FileMaker applications.
-
Publish AfterShip-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live AfterShip.
-
Use Agno to Talk to Your Sybase 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 Sybase for you.
-
How to Connect to Live HBase 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 Apache HBase for you.
-
Use Azure AI Foundry to Talk to Your FHIR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your FHIR for you.
-
Connect to and Visualize Live Vercel Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Vercel.
-
Use the CData Software ODBC Driver for Miro in SAS for Real-Time Reporting and Analytics
Connect to real-time Miro in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Miro.
-
Seamlessly Bring MongoDB Data into Retool Using CData Connect AI
Integrate MongoDB data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Automate CampaignMonitor Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live CampaignMonitor and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Automated Continuous Elorus Replication to MongoDB
Use CData Sync for automated, continuous, customizable Elorus replication to MongoDB.
-
Configure the CData JDBC Driver for SAP Concur in a Connection Pool in Tomcat
Connect to SAP Concur from a connection pool in Tomcat.
-
Moving Data from Microsoft Teams to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Microsoft Teams data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to connect to ZendeskSell Data from IntelliJ
Integrate connectivity to ZendeskSell with wizards in IntelliJ.
-
Write a Simple Go Application to work with IBM Informix Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to IBM Informix.
-
Create Reports with Salesforce Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Salesforce & Force.com.