CData Software - Knowledge Base
Recent Articles
-
Import Real-Time Retently Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Retently data in ColdFusion.
-
Connect to Highrise Data in RapidMiner
Integrate Highrise data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Connect to Live eBay 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 eBay data for you.
-
Integrate Google's Vertex AI Agent with Live SAP Ariba Source Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live SAP Ariba Source data within intelligent workflows.
-
Connect to and Visualize Live Google Directory Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Directory data.
-
Use the CData Software ODBC Driver for Everhour in MicroStrategy
Connect to Everhour data in MicroStrategy Developer using the CData Software ODBC Driver for Everhour.
-
Create a Data Access Object for PhantomBuster Data using JDBI
A brief overview of creating a SQL Object API for PhantomBuster data in JDBI.
-
Integrate Open WebUI with Live Dropbox Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Dropbox data from within the chat interface.
-
Connect to Outreach.io Data in Ruby
Connect to Outreach.io data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Getting Started with the CData JDBC Driver for Mixpanel
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Mixpanel.
-
Use Claude to Talk to Your eBay Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your eBay Analytics data for you.
-
Integrating LangChain with Jira Assets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Jira Assets data within automated workflows.
-
Integrate YouTube Analytics with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate YouTube Analytics with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to YouTube Analytics data.
-
Create XML-Connected Business Apps in AppSheet
Connect to XML Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to XML data.
-
Connect to RabbitMQ Data in RapidMiner
Integrate RabbitMQ data with standard components and data source configuration wizards in RapidMiner Studio.
-
Deploy the ADO.NET Provider for Azure Data Catalog on an SSRS Report Server
Connect to Azure Data Catalog data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
How to Connect to Live Okta 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 Okta data for you.
-
Integrate Theia IDE with Live Moosend 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 Moosend data from within the development environment.
-
Create Instagram-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Instagram Data from OutSystems and build custom enterprise apps using live Instagram data.
-
How to Query Live CloudConvert Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live CloudConvert data data in natural language using Python.
-
Analyze HDFS Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of HDFS data and visualize live HDFS data in Infragistics Reveal.
-
Build MVC Applications with Connectivity to Amazon Marketplace Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Amazon Marketplace from an ASP.NET MVC application.
-
Use the CData Software ODBC Driver for Amazon DynamoDB in SAS for Real-Time Reporting and Analytics
Connect to real-time Amazon DynamoDB data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Amazon DynamoDB.
-
Load Amazon S3 Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Amazon S3 data to a database.
-
How to Query Salesforce Marketing Data in MySQL Workbench
Execute MySQL queries against live Salesforce Marketing data from MySQL Workbench.
-
Connect to Aha! Data from a Connection Pool in Jetty
The Aha! JDBC Driver supports connection pooling: This article shows how to connect faster to Aha! data from Web apps in Jetty.
-
Link Billsby with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Billsby data in Filemaker Pro for Mac or Windows.
-
Object-Relational Mapping (ORM) with Facebook 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 Facebook Ads data into a Java-based ORM framework, Hibernate.
-
Integrating Codex with Superchat 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.
-
Integrate Live PolarTeamPro Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to PolarTeamPro from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live PolarTeamPro data.
-
Integrating Kiro with Google Analytics 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.
-
Operational Reporting on Pipeline CRM Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Pipeline CRM data.
-
Enable the Nuclia JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Nuclia data.
-
Connect to Salesforce Marketing from Asprova with CData Software ODBC Driver for Salesforce Marketing
This article shows how to connect faster to Salesforce Marketing data from Asprova.
-
Use JayDeBeApi to access Nuclia Data in Python
Use standard Python scripting and the development environment of your choice to access live Nuclia data.
-
Automated Continuous eBay Replication to SingleStore
Use CData Sync for automated, continuous, customizable eBay replication to SingleStore.
-
How to Connect to Live ZohoMarketingHub 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 ZohoMarketingHub data for you.
-
How to integrate Deel with Apache Airflow
Access and process Deel data in Apache Airflow using the CData JDBC Driver.
-
Connect to Opsgenie Data in CloverDX (formerly CloverETL)
Transfer Opsgenie data using the visual workflow in the CloverDX data integration tool.
-
DataBind Charts to AfterShip Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to AfterShip data 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.
-
Choosing the Best Method to Connect Guru to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Guru data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Cloudflare Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Cloudflare to connect to Cloudflare data and execute queries in PowerBuilder.
-
Create Redis-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Redis Data from OutSystems and build custom enterprise apps using live Redis data.
-
Query Microsoft Teams Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Microsoft Teams data from Node.js.
-
Access Live MYOB AccountRight Data in Coginiti Pro
Connect to and query live MYOB AccountRight data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create Google Spanner-Connected Dashboards in Grafana
Connect to Google Spanner Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Google Spanner data.
-
LINQ to Wrike 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 Wrike Data Provider.
-
Connect to HCL Domino Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for HCL Domino data.
-
Integrate with Google Forms Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Google Forms data in SnapLogic.
-
Automated Continuous Keap Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Keap replication to AlloyDB.
-
Consume SAS xpt OData Feeds in PowerBuilder
This article demonstrates how to consume SAS xpt data as OData feeds from PowerBuilder using the API Server.
-
Connect Authorize.Net Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Authorize.Net data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Deploy the ADO.NET Provider for Google Sheets on an SSRS Report Server
Connect to Google Sheets data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Automated Continuous Miro Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Miro replication to PostgreSQL.
-
Connect and Visualize Live Authorize.Net Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Authorize.Net data into the Databricks platform and create visualization dashboards with real-time Authorize.Net data.
-
How to create an RPA flow for VWO Data in UiPath Studio
Use the VWO ODBC Driver to create workflows that access real-time VWO data without any coding.
-
Build Agents in Relevance AI with Access to Live Facebook Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Facebook Ads data within intelligent agent workflows.
-
Build an OLAP Cube in SSAS from Zoho Books Data
Establish a connection to Zoho Books data data from SQL Server Analysis Services, and use the Zoho Books Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use Azure AI Foundry to Talk to Your API 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 API data for you.
-
Viewing PDFMonkey Data in RAD Studio Data Explorer
How to view PDFMonkey data in RAD Studio Data Explorer using the CData ODBC Driver for PDFMonkey.
-
Connect to Zoom Data from HeidiSQL
Use CData Connect AI to connect to and query live Zoom data from HeidiSQL.
-
Connect to Raisers Edge NXT Data from AWS Glue
Use CData Connect AI to gain access to live Raisers Edge NXT data from your AWS Glue jobs.
-
Visualize Live HDFS Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live HDFS data.
-
Automated Continuous Elasticsearch Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Elasticsearch replication to Amazon S3.
-
Replicate FHIR Data in Heroku for Use in Salesforce Connect
Replicate FHIR data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Reckon Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Reckon and the Script function in FileMaker Pro to connect to Reckon and work with Reckon data in your FileMaker application.
-
Automated Continuous SageHR Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SageHR replication to PostgreSQL.
-
Access Live Sage 300 Data in TIBCO Data Virtualization
Use the Sage 300 Tibco DV Adapter to create a Sage 300 data data source in TIBCO Data Virtualization Studio and gain access to live Sage 300 data from your TDV Server.
-
Seamlessly Bring SAP Ariba Procurement Data into Retool Using CData Connect AI
Integrate SAP Ariba Procurement data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect Reckon Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Reckon data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Access DB2 Data Using Entity Framework
This article shows how to access DB2 data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Rootly Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Rootly facts in real time.
-
How to update Amazon Athena from Excel
This article explains how to transfer data from Excel to Amazon Athena using the Excel Add-In for Amazon Athena.
-
Use the CData ODBC Driver for Auth0 from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Auth0 to connect to Auth0 data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Auth0 data in Excel.
-
Connect Active Directory Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Active Directory data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to integrate Metabase with Reckon Accounts Hosted Data
Use CData Connect AI to connect to live Reckon Accounts Hosted data and create an interactive dashboard in Metabase from Reckon Accounts Hosted data.
-
Integrate SingleStore with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SingleStore with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SingleStore data.
-
How to use SQLAlchemy ORM to access Sage 200 Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Sage 200 data.
-
Build Visualizations of CloudConvert Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of CloudConvert data in Birst.
-
View Reports on Real-Time Printify Data in Power BI Report Server
Use the CData ODBC Driver for Printify to visualize Printify data in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Live MongoDB Data in PostGresSQL Interface through CData Connect AI
Create a live connection to MongoDB in CData Connect AI and connect to your MongoDB data from PostgreSQL.
-
Build Dashboards with Productboard Data in DBxtra
Create dynamic dashboards and perform analytics based on Productboard data in DBxtra.
-
Viewing SAP BusinessObjects BI Data in RAD Studio Data Explorer
How to view SAP BusinessObjects BI data in RAD Studio Data Explorer using the CData ODBC Driver for SAP BusinessObjects BI.
-
Integrate ActiveCampaign Data in Pentaho Data Integration
Build ETL pipelines based on ActiveCampaign data in the Pentaho Data Integration tool.
-
How to Visualize Front Data in Python with pandas
Use pandas and other modules to analyze and visualize live Front data in Python.
-
DataBind Azure DevOps Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Azure DevOps with the DevExpress Windows Forms and Web controls to provide Azure DevOps data to a chart.
-
Prepare, Blend, and Analyze Grafana Data in Alteryx Designer (ODBC)
Build workflows to access live Grafana data for self-service data analytics.
-
How to work with Gumroad Data in Apache Spark using SQL
Access and process Gumroad Data in Apache Spark using the CData Software JDBC Driver.
-
Visualize Hubstaff Data in TIBCO Spotfire through ADO.NET
Integrate Hubstaff data into dashboards in TIBCO Spotfire.
-
How to Seamlessly Import LDAP Data into IBM SPSS Modeler
Integrate LDAP data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Query Pushbullet Data in DataGrip
Create a Data Source for Pushbullet in DataGrip and use SQL to query live Pushbullet data.
-
Natively Connect to Superchat Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Superchat data. Leverage the native support for ODBC in PHP.
-
Automated Continuous ZohoPeople Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable ZohoPeople replication to Apache Kafka.
-
Sage 300 Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Sage 300 data through CData Connect AI using different applications and tools.
-
Work with Live Vault CRM Data in Power Query
Use CData Connect AI to connect to Vault CRM data and work with live Vault CRM data in Microsoft Power Query.
-
Connect to ClickUp Data in RazorSQL
Connect to ClickUp from wizards and query ClickUp data from the GUI in the RazorSQL database management tool.
-
Use Microsoft Copilot Studio to talk to your Freshdesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Freshdesk data for you.
-
Connect to Real-Time Shortcut Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Shortcut data in Power Apps.
-
Integrating Dataiku with Samanage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Samanage data.
-
ETL Tavily in Oracle Data Integrator
This article shows how to transfer Tavily data into a data warehouse using Oracle Data Integrator.