CData Software - Knowledge Base
Recent Articles
-
How to Easily Query Quaderno Data in OpenOffice Base
Connect to Quaderno data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Query Live Google Ads Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Google Ads data through a conversational interface.
-
Connect to and Visualize Live Clari Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Clari data.
-
Import and Visualize SAP HANA Data in Power View
Create data visualizations based on SAP HANA data in Excel.
-
Automate Parallel Data Replication to Azure Synapse
Use CData Sync to customize and automate Parallel data replication to Azure Synapse.
-
How to Access Live EmailOctopus Data in Power Automate Desktop via ODBC
The CData ODBC Driver for EmailOctopus enables you to integrate EmailOctopus data into workflows built using Microsoft Power Automate Desktop.
-
How to connect and process Microsoft Planner data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Microsoft Planner data.
-
Bridge Simplesat Connectivity with Apache NiFi
Access and process Simplesat data in Apache NiFi using the CData JDBC Driver.
-
Create Apps from Outreach.io Data in Qlik Sense Cloud
Use CData Connect AI to connect to Outreach.io Data and build apps from live Outreach.io data in Qlik Sense Cloud.
-
A PostgreSQL Interface for Brex Data (MySQL Remoting via JDBC)
Use the Remoting features of the Brex JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build BenchmarkEmail-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for BenchmarkEmail Data and create custom apps in Mendix.
-
LINQ to Landbot 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 Landbot Data Provider.
-
Connect to Tally 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 Tally data.
-
Integrate Stack Exchange Data in Pentaho Data Integration
Build ETL pipelines based on Stack Exchange data in the Pentaho Data Integration tool.
-
How to Seamlessly Import Calendly Data into IBM SPSS Modeler
Integrate Calendly data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Impala from Asprova with CData Software ODBC Driver for Impala
This article shows how to connect faster to Impala data from Asprova.
-
How to connect to Sendwithus Data in DBVisualizer
Integrate Sendwithus data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Zoho CRM Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Zoho CRM and the Script function in FileMaker Pro to connect to Zoho CRM and work with Zoho CRM data in your FileMaker application.
-
Connect to Teradata Data from PowerBuilder via ADO.NET
This article demonstrates how to access Teradata data from Appeon PowerBuilder using the CData ADO.NET Provider for Teradata.
-
Integrating Kiro with SAP HANA 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.
-
Connect to Discord in SpagoBI
Create reports featuring live Discord data in SpagoBI Studio. Host Discord reports on SpagoBI Server.
-
Integrating LangGraph with Campaigner Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Campaigner data within automated workflows.
-
Automated Continuous Toggl Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Toggl replication to Apache Kafka.
-
Connect to Grafana Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Grafana and work with Grafana data in your FileMaker applications.
-
Use Agno to Talk to Your SAP Ariba Procurement 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 SAP Ariba Procurement data for you.
-
Integrate LibreChat with Live Testmonitor Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Testmonitor data from within the chat interface.
-
Outreach.io Reporting in OBIEE with the Outreach.io JDBC Driver
Deploy the Outreach.io JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Access Amazon Marketplace Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Amazon Marketplace data from HeidiSQL.
-
Explore Geographical Relationships in Autopilot Data with Power Map
Create data visualizations with Autopilot data in Power Map.
-
How to publish and share Yelp Data dashboards with Tableau Server
The CData ODBC driver for Yelp enables you integrate Yelp data into Tableau dashboards.
-
Build Greenhouse-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Greenhouse Data and create custom apps in Mendix.
-
Create Informatica Mappings From/To an ODBC Data Source for Zoho Creator
Create an ODBC connection to Zoho Creator in Informatica and browse and transfer Zoho Creator data.
-
Integrate with Live Kintone Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Kintone from the MuleSoft Anypoint Platform to integrate live Kintone data into custom reports and dashboards.
-
Connect to CouchDB Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for CouchDB data in the Denodo Virtual DataPort Administrator.
-
Use Azure AI Foundry to Talk to Your Oracle Sales 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 Oracle Sales data for you.
-
Use Agno to Talk to Your Airtable 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 Airtable data for you.
-
Getting Started with the CData SSIS Components for Sage Intacct
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Sage Intacct.
-
Operational Reporting on ConstantContact Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote ConstantContact data.
-
Natively Connect to Pingdom Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Pingdom data. Leverage the native support for ODBC in PHP.
-
Create Power BI Reports on Real-Time eBay Data
Use the CData ODBC Driver for eBay to visualize eBay data in Power BI Desktop.
-
Using the CData Software ODBC Driver for Mailgun in PyCharm
Connect to Mailgun as an ODBC data source in PyCharm using the CData Software ODBC Driver for Mailgun.
-
ETL Notion in Oracle Data Integrator
This article shows how to transfer Notion data into a data warehouse using Oracle Data Integrator.
-
Viewing Sugar CRM Data in RAD Studio Data Explorer
How to view Sugar CRM data in RAD Studio Data Explorer using the CData ODBC Driver for Sugar CRM.
-
Migrating data from Oracle Sales to Snowflake using CData SSIS Components.
Easily push Oracle Sales data to Snowflake using the CData SSIS Tasks for Oracle Sales and Snowflake.
-
How to connect and process Tavily data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Tavily data.
-
Query Live Zoho Projects Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Zoho Projects data through a conversational interface.
-
Build a Simple VCL Application for Oracle HCM Cloud Data
How to build a simple VCL Application to view Oracle HCM Cloud data in RAD Studio using the CData ODBC Driver for Oracle HCM Cloud.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for MariaDB
Provide connectivity to MariaDB data through an SAP BusinessObjects universe.
-
Integrate LibreChat with Live MongoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live MongoDB data from within the chat interface.
-
Build Data Flows from Mixpanel to SQL Server using SSIS
Easily back up Mixpanel data to SQL Server using the SSIS components for Mixpanel.
-
Integrate Real-Time Access to Gmail in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Gmail data in real time.
-
DataBind Charts to Figshare Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Figshare 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.
-
Publish Crystal Reports on SageHR Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SageHR data.
-
Create Data Visualizations in Cognos BI with Procore Data
Access Procore data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Replicate Miro Data from PowerShell
Write a quick PowerShell script to query Miro data. Use connectivity to the live data to replicate Miro data to SQL Server.
-
How to Access Live Adobe Experience Manager Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Adobe Experience Manager enables you to integrate Adobe Experience Manager data into workflows built using Microsoft Power Automate Desktop.
-
Access Live Odoo 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 Odoo data through MCP integration.
-
Build Voice Agents in ElevenLabs with access to Live Teradata Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Teradata data.
-
Connect Shopify to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Shopify with IBM WebSphere for seamless data integration and connectivity.
-
Natively Connect to Google Cloud Storage Data in PHP
The CData ODBC driver for Google Cloud Storage enables you to create PHP applications with connectivity to Google Cloud Storage data. Leverage the native support for ODBC in PHP.
-
Integrate Google's Vertex AI Agent with Live Procore 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 Procore data within intelligent workflows.
-
Create Facebook Ads-Connected Dashboards in Grafana
Connect to Facebook Ads Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Facebook Ads data.
-
Automated Continuous Billsby Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Billsby replication to Google BigQuery.
-
Create Datasets from eBay in Domo Workbench and Build Visualizations of eBay Data in Domo
Use the CData Software ODBC Driver for eBay to create datasets from eBay data in Domo Workbench and then build visualizations in the Domo service.
-
Use Dash to Build to Web Apps on MySQL Data
Create Python applications that use pandas and Dash to build MySQL-connected web apps.
-
Use Microsoft Copilot Studio to talk to your MYOB AccountRight 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 MYOB AccountRight data for you.
-
Connect to XML from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from XML data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Teradata Data in Ruby
Connect to Teradata data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Vercel Data in CloverDX (formerly CloverETL)
Transfer Vercel data using the visual workflow in the CloverDX data integration tool.
-
Connect to and Visualize Live SAP ByDesign Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SAP ByDesign data.
-
Use the CData Software ODBC Driver for Square in SAS for Real-Time Reporting and Analytics
Connect to real-time Square data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Square.
-
Use the CData ODBC Driver for Webex in Microsoft Power Query
You can use the CData Webex ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Webex data into Microsoft Power Query.
-
Integrating Antigravity CLI with MYOB AccountRight data via CData CLI
Connect MYOB AccountRight data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automated Continuous Google Directory Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Google Directory replication to Azure SQL Database.
-
How to Connect to Odoo Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Odoo data. Leverage the pyodbc module for ODBC in Python.
-
Access Live Google Spanner Data in AWS Lambda
Connect to live Google Spanner data in AWS Lambda using the CData JDBC Driver.
-
Analyze Live Google Contacts Data in SAS Viya
Use CData Connect AI to connect to Google Contacts data from SAS Viya and deploy self-service analytics using live Google Contacts data.
-
Access Azure DevOps Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Azure DevOps data.
-
How to Work with Adobe Analytics Data in AWS Glue Jobs Using JDBC
Connect to Adobe Analytics from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to use SQLAlchemy ORM to access Dropbox Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Dropbox data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Cohere
Provide connectivity to Cohere data through an SAP BusinessObjects universe.
-
Connect to Hive Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Hive data in the Denodo Virtual DataPort Administrator.
-
Automated Continuous Teamwork Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Teamwork replication to AlloyDB.
-
Integrating Dataiku with PolarTeamPro Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live PolarTeamPro data.
-
Connect to Trello Data in Claris FileMaker Pro
Use the CData ODBC Driver for Trello in FileMaker Pro to connect to Trello and work with Trello data in your FileMaker applications.
-
Connect to Postmark Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Postmark data using standard SQL.
-
Build Charts with LightSpeedRetail Data in Clear Analytics
Create dynamic charts and perform analytics based on LightSpeedRetail data in Clear Analytics.
-
Integrate with FHIR Data in JReport Designer
Create charts and reports based on FHIR data in JReport Designer.
-
Natively Connect to ConstantContact Data in PHP
The CData ODBC driver for ConstantContact enables you to create PHP applications with connectivity to ConstantContact data. Leverage the native support for ODBC in PHP.
-
Create Dashboards and Visualize Live Exa Data in Geckoboard
Use CData Connect AI to connect to live Exa data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect XML to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect XML with IBM WebSphere for seamless data integration and connectivity.
-
Connect to Sage 300 Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Sage 300 to connect to Sage 300 data and execute queries in PowerBuilder.
-
Automate API Data Replication to Couchbase
Use CData Sync to Customize and automate API data replication to Couchbase.
-
Consume Redshift OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Redshift feeds that reflect any changes in SAP Lumira.
-
How to Connect Couchbase 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 Couchbase data in real time using natural language.
-
Automated Continuous GitHub Replication to Databricks
Use CData Sync for automated, continuous, customizable GitHub replication to Databricks.
-
Automate Kintone Data Replication to Azure Data Lake
Use CData Sync to customize and automate Kintone data replication to Azure Data Lake.
-
Create Cloudant-Connected Business Apps in AppSheet
Connect to Cloudant Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Cloudant data.
-
Getting Started with the CData Connect AI Python SDK for Paymo
Install the CData Connect AI Python SDK to read live Paymo data with standard DB-API 2.0 Python code.
-
Connect to Xero Data in Aqua Data Studio
Access Xero data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.