CData Software - Knowledge Base
Recent Articles
-
Microsoft Dataverse Reporting in OBIEE with the Microsoft Dataverse JDBC Driver
Deploy the Microsoft Dataverse JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to create an RPA flow for Adobe Analytics Data in UiPath Studio
Use the Adobe Analytics ODBC Driver to create workflows that access real-time Adobe Analytics data without any coding.
-
Query Highrise Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Highrise entities in PHP by modeling them as objects.
-
DataBind Charts to SAP Ariba Source Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SAP Ariba Source 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.
-
Connect to Azure Synapse Data in CloverDX (formerly CloverETL)
Transfer Azure Synapse data using the visual workflow in the CloverDX data integration tool.
-
Build Couchbase-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Couchbase data and build web apps with connectivity to live Couchbase data.
-
Connect to Clio Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Clio data.
-
How to Access Live Splunk Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Splunk enables you to integrate Splunk data into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Pipeliner CRM Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Pipeliner CRM replication to Amazon Redshift.
-
Integrating LlamaIndex with OneNote Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on OneNote data in real time.
-
Provide OData Services of Teradata Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Teradata data by developing a WCF Service Application.
-
Connect to Xero Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Xero data.
-
Operational Reporting on WooCommerce Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote WooCommerce data.
-
Integrate Live SAP HANA XS Advanced Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SAP HANA XS Advanced data and integrate live SAP HANA XS Advanced data into apps built in Microsoft Power Apps.
-
Build Dashboards with IBM Informix Data in Dundas BI
Create dynamic dashboards and perform analytics based on IBM Informix data in Dundas BI.
-
Getting Started with the CData Connect AI Python SDK for Shortcut
Install the CData Connect AI Python SDK to read live Shortcut data with standard DB-API 2.0 Python code.
-
Getting Started with the CData ADO.NET Provider for BigQuery
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for BigQuery.
-
Integrate Google's Antigravity Agent with Live Sage 200 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Sage 200 data using the Model Context Protocol.
-
Getting Started with the CData JDBC Driver for SendGrid
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SendGrid.
-
Integrate Coinbase with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Coinbase with External Services.
-
Visualize Excel Data in TIBCO Spotfire through ADO.NET
Integrate Excel data into dashboards in TIBCO Spotfire.
-
Integrate with Reply.io Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Reply.io data to a JSON file on disk.
-
Access Live Microsoft Ads Data in Coginiti Pro
Connect to and query live Microsoft Ads data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrate Open WebUI with Live Avalara AvaTax Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Avalara AvaTax data from within the chat interface.
-
Replicate MariaDB Data in Heroku for Use in Salesforce Connect
Replicate MariaDB data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate Live Foursquare Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Foursquare data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Replicate BambooHR Data from PowerShell
Write a quick PowerShell script to query BambooHR data. Use connectivity to the live data to replicate BambooHR data to SQL Server.
-
Query OneNote Data in DataGrip
Create a Data Source for OneNote in DataGrip and use SQL to query live OneNote data.
-
Analyze Google Sheets Data in Looker
Use CData Connect AI to connect to Google Sheets Data from Looker and build custom apps using live Google Sheets data.
-
Integrating LangChain with Samanage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Samanage data within automated workflows.
-
Access Live Oracle SCM Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Oracle SCM data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Build ShipEngine-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live ShipEngine data.
-
Access Live BenchmarkEmail Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live BenchmarkEmail data from your Excel spreadsheets.
-
Integrating Dataiku with Zendesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Zendesk data.
-
Replicate Perplexity Data from PowerShell
Write a quick PowerShell script to query Perplexity data. Use connectivity to the live data to replicate Perplexity data to SQL Server.
-
Connect to Datadog from a Connection Pool in WebLogic
Use the CData JDBC Driver for Datadog to connect to Datadog data from Web applications running on WebLogic.
-
Automated Continuous Elorus Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Elorus replication to Azure SQL Database.
-
How to Connect to Live GitLab Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your GitLab data for you.
-
Create Instagram-Connected Dashboards in Grafana
Connect to Instagram Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Instagram data.
-
How to integrate Metabase with Twilio Data
Use CData Connect AI to connect to live Twilio data and create an interactive dashboard in Metabase from Twilio data.
-
Working with Pinecone Data in LINQPad
Execute LINQ queries to Pinecone data in LINQPad.
-
Extract, Transform, and Load Elasticsearch Data in Informatica PowerCenter
Create a simple Workflow for Elasticsearch data in Informatica PowerCenter.
-
Build PostgreSQL-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to PostgreSQL Data from Zoho Analytics and import live PostgreSQL data.
-
Query Microsoft Exchange Data in DataGrip
Create a Data Source for Microsoft Exchange in DataGrip and use SQL to query live Microsoft Exchange data.
-
Query AdRoll Data through ODBC in Node.js
Use node-odbc to execute SQL queries against AdRoll data from Node.js.
-
Natively Connect to Postmark Data in PHP
The CData ODBC driver for Postmark enables you to create PHP applications with connectivity to Postmark data. Leverage the native support for ODBC in PHP.
-
Analyze SurveyMonkey Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SurveyMonkey data in Microsoft R Open.
-
Import LinkedIn Ads Data Using Azure Data Factory
Use CData Connect AI to connect to LinkedIn Ads Data from Azure Data Factory and import live LinkedIn Ads data.
-
Connect to BambooHR Data from a Connection Pool in JBoss
Integrate BambooHR data into Java servlets: Use the Management Console in JBoss to install the BambooHR JDBC Driver.
-
Analyze Trello Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Trello data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Access Greenhouse Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Greenhouse data from your Oracle system.
-
Use Manus AI to Talk to Your Tavily Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Tavily data.
-
Use the CData ODBC Driver for Clio from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Clio to connect to Clio data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Clio data in Excel.
-
A PostgreSQL Interface for Epicor Kinetic Data using the CData ODBC Driver
Use the SQL Gateway and Epicor Kinetic ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Access Brex Data Using Entity Framework
This article shows how to access Brex data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Use Azure AI Foundry to Talk to Your Slack 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 Slack data for you.
-
Load Hubstaff Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Hubstaff data to a database.
-
How to connect to ZohoExpense Data with Squirrel SQL client
Connect to ZohoExpense data and execute queries in the Squirrel SQL Client.
-
Automated Gumroad Data Replication to Teradata
Use CData Sync to Customize and automate Gumroad data replication to Teradata.
-
Prepare, Blend, and Analyze Amazon DynamoDB Data in Alteryx Designer (Connect AI)
Build workflows to access live Amazon DynamoDB data for self-service data analytics.
-
Access Access Data from MySQL in Amazon QuickSight
Connect to Access and build visualizations of Access data using a MySQL Connection in Amazon QuickSight.
-
Integrate Live Calendly Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Calendly data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
A PostgreSQL Interface for Cloudant Data (MySQL Remoting via JDBC)
Use the Remoting features of the Cloudant JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Cloudflare-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Cloudflare data.
-
Build Kintone-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Kintone data and build web apps with connectivity to live Kintone data.
-
How to Connect Flowise AI Agents to Live Adobe Commerce 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 Adobe Commerce data without replication.
-
Build Bitbucket Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Bitbucket data and build visualizations in Tableau.
-
Automated Continuous ShipEngine Replication to IBM DB2
Use CData Sync for automated, continuous, customizable ShipEngine replication to IBM DB2.
-
Access Splunk Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Splunk data from your Oracle system.
-
Build an OLAP Cube in SSAS from BenchmarkEmail Data
Establish a connection to BenchmarkEmail data data from SQL Server Analysis Services, and use the BenchmarkEmail Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use JayDeBeApi to access Mouseflow Data in Python
Use standard Python scripting and the development environment of your choice to access live Mouseflow data.
-
Operational Reporting on PingOne Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote PingOne data.
-
Create Dynamic Microsoft Exchange Grids Using the Infragistics XamDataGrid
Learn how you can connect Microsoft Exchange to Infragistics XamDataGrid to build dynamic grids.
-
How to Access ZohoMarketingHub Data Using Entity Framework
This article shows how to access ZohoMarketingHub data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Getting Started with the CData ODBC Driver for Square
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Square.
-
ETL Reply.io in Oracle Data Integrator
This article shows how to transfer Reply.io data into a data warehouse using Oracle Data Integrator.
-
Connect to MYOB AccountRight Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for MYOB AccountRight data in the Denodo Virtual DataPort Administrator.
-
Connect to Zuora Data in Claris FileMaker Pro
Use the CData ODBC Driver for Zuora in FileMaker Pro to connect to Zuora and work with Zuora data in your FileMaker applications.
-
How to publish and share NetSuite Data dashboards with Tableau Server
The CData ODBC driver for NetSuite enables you integrate NetSuite data into Tableau dashboards.
-
Visualize Live Freshdesk Data in the Power BI Service
Use CData Connect AI to connect to live Freshdesk data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize Microsoft Exchange Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Microsoft Exchange data into TIBCO Spotfire.
-
Operational Reporting on Auth0 Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Auth0 data.
-
Access SendInBlue Data from MySQL in PHP
Connect to SendInBlue through the standard MySQL libraries in PHP.
-
Integrating Attio Data in Talend Cloud Data Management Platform
Connect Attio Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Use the CData ODBC Driver for TigerGraph in Microsoft Power Query
You can use the CData TigerGraph ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import TigerGraph data into Microsoft Power Query.
-
Integrating Kiro with SAP SuccessFactors 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 Real-Time Jumpseller Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Jumpseller data in Power Apps.
-
Connect Cohere to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Cohere with IBM WebSphere for seamless data integration and connectivity.
-
How to use SQLAlchemy ORM to access Sentry Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Sentry data.
-
Query Certinia Data as a SQL Server Database in Node.js
Execute SQL Server queries against Certinia data from Node.js.
-
Connect to FreshBooks Data in RazorSQL
Connect to FreshBooks from wizards and query FreshBooks data from the GUI in the RazorSQL database management tool.
-
Integrate Timely Data into Power Automate Desktop using CData Connect
CData Connect for Timely Data enables you to integrate Timely data into workflows built using Microsoft Power Automate Desktop.
-
Zoho Projects Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Zoho Projects data through CData Connect AI using different applications and tools.
-
Use Biml to Build SSIS Tasks to Replicate PabblySubscriptions Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate PabblySubscriptions data to SQL Server.
-
Visualize Power BI XMLA Data in TIBCO Spotfire through OData
Integrate Power BI XMLA data into dashboards in TIBCO Spotfire.
-
Use Dash to Build Web Apps on MariaDB Data via CData Connect AI
Build interactive Dash web apps on live MariaDB data using pandas and the CData Connect AI Python SDK.
-
How to Seamlessly Import Cloudant Data into IBM SPSS Modeler
Integrate Cloudant data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Create SendInBlue Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SendInBlue from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to SharePoint Data in HULFT Integrate
Connect to SharePoint as a JDBC data source in HULFT Integrate
-
Integrate Dify with Live Dynamics 365 Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Dynamics 365 data.