CData Software - Knowledge Base
Recent Articles
-
Integrate Yelp Data in Pentaho Data Integration
Build ETL pipelines based on Yelp data in the Pentaho Data Integration tool.
-
Visualize Live Qualaroo Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Qualaroo data.
-
How to Connect Flowise AI Agents to Live Bright Data 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 Bright Data data without replication.
-
Object-Relational Mapping (ORM) with PostgreSQL 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 PostgreSQL data into a Java-based ORM framework, Hibernate.
-
View Reports on Real-Time Pingdom Data in Power BI Report Server
Use the CData ODBC Driver for Pingdom to visualize Pingdom data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating LangGraph with ZohoExpense Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on ZohoExpense data within automated workflows.
-
Operational Reporting on SAP BusinessObjects BI Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SAP BusinessObjects BI data.
-
How to Access Live Tanda Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Tanda enables you to integrate Tanda data into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Splunk Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Splunk data replication to OneLake in Microsoft Fabric.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SpaceX
Provide connectivity to SpaceX data through an SAP BusinessObjects universe.
-
Access Phoenix Data from MySQL in PHP
Connect to Phoenix through the standard MySQL libraries in PHP.
-
Access Live Google Drive Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Google Drive data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Wrike Data Replication to Teradata
Use CData Sync to Customize and automate Wrike data replication to Teradata.
-
Getting Started with the CData SSIS Components for Nuclia
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Nuclia.
-
How to Connect to & Open LDAP Objects in Microsoft Excel
This article uses the CData ODBC driver for LDAP to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Query Microsoft Planner Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Microsoft Planner entities in PHP by modeling them as objects.
-
Visualize Live Amazon DynamoDB Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Amazon DynamoDB data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create Perplexity-Connected Business Apps in AppSheet
Connect to Perplexity Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Perplexity data.
-
Getting Started with the CData Excel Add-In for Vimeo
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Vimeo.
-
Use the CData Software JDBC Driver for PolarTeamPro in MicroStrategy Web
Connect to PolarTeamPro data in MicroStrategy Web using the CData Software JDBC Driver for PolarTeamPro.
-
Connect to Bright Data Data from AWS Glue
Use CData Connect AI to gain access to live Bright Data data from your AWS Glue jobs.
-
Getting Started with the CData Excel Add-In for PabblySubscriptions
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for PabblySubscriptions.
-
Replicate Productboard Data in Heroku for Use in Salesforce Connect
Replicate Productboard data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Getting Started with the CData Python Connector for Telegram
Learn to install and license the CData Python Connector and configure a connection to live Telegram data.
-
Access Live Telegram Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Telegram data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Zoho Creator Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Zoho Creator Data and connect to Zoho Creator data in Akorbi Digital RunMyProcess.
-
Build Apps with Live MongoDB Data Using the Low-Code Development Platform of Mendix
Connect MongoDB data with Mendix to build apps using the CData JDBC Driver for MongoDB.
-
How to Connect to Live Azure Synapse 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 Azure Synapse data through natural language.
-
Establish a Live Connection with Google Ad Manager Data using Tableau Bridge
The CData ODBC Driver for Google Ad Manager enables you to integrate live Google Ad Manager data into Tableau Cloud dashboards using the Tableau Bridge.
-
Visualize Greenplum Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Greenplum data.
-
How to Query Live Sybase Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Sybase data data in natural language using Python.
-
How to use SQLAlchemy ORM to access Excel Online Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Excel Online data.
-
Automated Continuous Epicor Kinetic Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Epicor Kinetic replication to AlloyDB.
-
Create ZohoPeople-Connected Business Apps in AppSheet
Connect to ZohoPeople Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to ZohoPeople data.
-
How to connect PolyBase to QuickBooks Time
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live QuickBooks Time data.
-
How to Connect to Live VWO 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 VWO data without replication.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Short.io
Provide connectivity to Short.io data through an SAP BusinessObjects universe.
-
Create Oracle Sales Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Oracle Sales data access from reports, embedded analytics, and more.
-
Connect to Marketo Data in DBeaver
Use the CData ODBC Driver to connect to Marketo data in DBeaver.
-
Create Data Visualizations in Cognos BI with MySQL Data
Access MySQL data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build an OLAP Cube in SSAS from Couchbase Data
Establish a connection to Couchbase data data from SQL Server Analysis Services, and use the Couchbase Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to HDFS from Asprova with CData Software ODBC Driver for HDFS
This article shows how to connect faster to HDFS data from Asprova.
-
Use Claude to Talk to Your SAP Ariba Procurement 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 SAP Ariba Procurement data for you.
-
Build MVC Applications with Connectivity to Facebook Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Facebook from an ASP.NET MVC application.
-
Automated Continuous Deel Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Deel replication to Azure SQL Database.
-
Connect to Snowflake Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Snowflake data.
-
Build AI Agents with Square 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 Square data through CData Connect AI.
-
Create Reports from Snowflake Data in Looker Studio
Use CData Connect AI to gain access to live Snowflake data and create custom reports in Looker Studio.
-
Connect to ElevenLabs Data from a Connection Pool in Jetty
The ElevenLabs JDBC Driver supports connection pooling: This article shows how to connect faster to ElevenLabs data from Web apps in Jetty.
-
Getting Started with the CData Excel Add-In for CapsuleCRM
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for CapsuleCRM.
-
Create QuickBooks Time-Connected Business Apps in AppSheet
Connect to QuickBooks Time Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to QuickBooks Time data.
-
Use the CData ODBC Driver for Brex in Microsoft Power Query
You can use the CData Brex ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Brex data into Microsoft Power Query.
-
Visualize Live Bright Data Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Bright Data data into custom reports in Power BI.
-
Build Ontraport-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Ontraport data.
-
How to integrate Google Translate with Apache Airflow
Access and process Google Translate data in Apache Airflow using the CData JDBC Driver.
-
Automated Continuous CSV Replication to AlloyDB
Use CData Sync for automated, continuous, customizable CSV replication to AlloyDB.
-
Query, Visualize, and Share live Snowflake Data in Redash
Use CData Connect AI to connect to live Snowflake data in Redash for querying, visualizing, and sharing.
-
Connect to Strava from Asprova with CData Software ODBC Driver for Strava
This article shows how to connect faster to Strava data from Asprova.
-
How to integrate Typeform with Apache Airflow
Access and process Typeform data in Apache Airflow using the CData JDBC Driver.
-
Use Biml to Build SSIS Tasks to Replicate BenchmarkEmail Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate BenchmarkEmail data to SQL Server.
-
Build a Simple VCL Application for Pipeline CRM Data
How to build a simple VCL Application to view Pipeline CRM data in RAD Studio using the CData ODBC Driver for Pipeline CRM.
-
DataBind Controls to DocuSign Data in C++Builder
DataBind to DocuSign data in C++Builder with standard components and controls.
-
Interact with Live PolarTeamPro Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live PolarTeamPro data.
-
Configuring Clustering for CData Sync
A basic guide to configuring clustering in CData Sync, including setup of the shared application directory, application database, and cluster mode.
-
A PostgreSQL Interface for BenchmarkEmail Data (MySQL Remoting via JDBC)
Use the Remoting features of the BenchmarkEmail JDBC Driver to create a PostgreSQL entry-point for data access.
-
Import Real-Time ZohoExpense Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use ZohoExpense data in ColdFusion.
-
Integrate CapsuleCRM Data in Pentaho Data Integration
Build ETL pipelines based on CapsuleCRM data in the Pentaho Data Integration tool.
-
Use Dash to Build Web Apps on Coda Data via CData Connect AI
Build interactive Dash web apps on live Coda data using pandas and the CData Connect AI Python SDK.
-
Build Azure Table Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Azure Table data and build visualizations in Tableau Cloud.
-
Use the CData Software ODBC Driver for Zoho Inventory in MicroStrategy Desktop
Connect to Zoho Inventory data in MicroStrategy Desktop using the CData Software ODBC Driver for Zoho Inventory.
-
How to Work with Odoo Data in ETL Validator JDBC
Connect to Odoo from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Moosend Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Moosend and work with Moosend data in your FileMaker applications.
-
Seamlessly Bring Email Data into Retool Using CData Connect AI
Integrate Email data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Automate LightSpeedRetail Integration Tasks from PowerShell
Are you in search of a quick and easy way to access LightSpeedRetail data from PowerShell? This article demonstrates how to utilize the LightSpeedRetail Cmdlets for tasks like connecting to LightSpeedRetail data, automating operations, downloading data, and more.
-
Analyze MongoDB Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for MongoDB from Power Pivot. You will use the Table Import Wizard to load MongoDB data. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Xero Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Xero Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Use the CData ODBC Driver for Active Directory in Microsoft Power Query
You can use the CData Active Directory ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Active Directory data into Microsoft Power Query.
-
Getting Started with the CData Tableau Connector for Oracle Financials Cloud
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Oracle Financials Cloud.
-
Use Azure AI Foundry to Talk to Your ZohoSubscriptions 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 ZohoSubscriptions data for you.
-
Automated Continuous Mouseflow Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Mouseflow replication to Google Cloud SQL.
-
Connect to Real-Time HCL Domino Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for HCL Domino and Dataflow to import and use HCL Domino data in Power Apps.
-
Automated Continuous Gong Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Gong replication to delimited files (CSV/TSV).
-
Integrating LangChain with CSV Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on CSV data within automated workflows.
-
Integrate with ConvertKit Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ConvertKit data to a JSON file on disk.
-
Build AI Agents with SAP Ariba Procurement 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 SAP Ariba Procurement data through CData Connect AI.
-
Connect to Accelo Data in CloverDX (formerly CloverETL)
Transfer Accelo data using the visual workflow in the CloverDX data integration tool.
-
Use the CData Software ODBC Driver for Unbounce in SAS for Real-Time Reporting and Analytics
Connect to real-time Unbounce data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Unbounce.
-
Connect to Mistral AI from Asprova with CData Software ODBC Driver for Mistral AI
This article shows how to connect faster to Mistral AI data from Asprova.
-
Build Apps with Live MailerSend Data Using the Low-Code Development Platform of Mendix
Connect MailerSend data with Mendix to build apps using the CData API Driver for JDBC.
-
How to Visualize Toggl Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Toggl data in Python.
-
Seamlessly Bring Timely Data into Retool Using CData Connect AI
Integrate Timely data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Automated Continuous SAP BusinessObjects BI Replication to Oracle
Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to Oracle.
-
Access Amazon DynamoDB Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Amazon DynamoDB data from HeidiSQL.
-
Access Codat Data from MySQL in PHP
Connect to Codat through the standard MySQL libraries in PHP.
-
Load Tanda Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Tanda data to a database.
-
Explore Geographical Relationships in CloudConvert Data with Power Map
Create data visualizations with CloudConvert data in Power Map.
-
Use Dash to Build to Web Apps on Tally Data
Create Python applications that use pandas and Dash to build Tally-connected web apps.
-
Excel Spreadsheet Automation with the CDATAQUERY Formula
The CData Excel Add-In provides formulas that can pull data from different data sources into your spreadsheet. For example, the Google provider can create a spreadsheet of directions. In this article we show how to use the CDATAQUERY formula to automate spreadsheets.
-
A PostgreSQL Interface for Adobe Experience Manager Data (MySQL Remoting via JDBC)
Use the Remoting features of the Adobe Experience Manager JDBC Driver to create a PostgreSQL entry-point for data access.
-
Replicate ClickUp Data to Multiple Databases via the CData Sync CLI
Replicate ClickUp data to disparate databases with a single configuration.