CData Software - Knowledge Base
Recent Articles
-
Integrate Cursor with Live Cosmos DB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Azure Cosmos DB from within the editor.
-
Automated Continuous Shippo Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Shippo replication to OneLake in Microsoft Fabric.
-
Visualize SFTP in Tableau
The CData ODBC driver for SFTP enables you integrate SFTP into Tableau dashboards.
-
Automated Continuous SAP Ariba Procurement Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to Google BigQuery.
-
Build MVC Applications with Connectivity to SAP ByDesign
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SAP ByDesign from an ASP.NET MVC application.
-
Access Clio from MySQL in PHP
Connect to Clio through the standard MySQL libraries in PHP.
-
How to Create Power BI Visual Reports with Real-Time Amazon Marketplace
Use CData Power BI Connectors to visualize Amazon Marketplace in Power BI.
-
How to Visualize Oracle HCM Cloud Data in Python with pandas
Use pandas and other modules to analyze and visualize live Oracle HCM Cloud in Python.
-
Connecting Mastra with Acumatica via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time data across 300+ enterprise sources no replication required.
-
Visualize Azure Data Lake Storage in TIBCO Spotfire through ADO.NET
Integrate Azure Data Lake Storage into dashboards in TIBCO Spotfire.
-
How to create an RPA flow for Slack in UiPath Studio
Use the Slack ODBC Driver to create workflows that access real-time Slack without any coding.
-
Natively Connect to Amazon DynamoDB in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Amazon DynamoDB. Leverage the native support for ODBC in PHP.
-
Bidirectional Access to Amazon S3 from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Amazon S3 in Filemaker Pro for Mac or Windows.
-
Connect to Oracle SCM in Google Apps Script via SQL Gateway
Use the ODBC Driver for Oracle SCM and the SQL Gateway to access Oracle SCM from Google Apps Script.
-
How to Connect to Live SAP SuccessFactors in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your SAP SuccessFactors for you.
-
How to work with Drip in Apache Spark using SQL
Access and process Drip in Apache Spark using the CData Software JDBC Driver.
-
How to create an RPA flow for EnterpriseDB in UiPath Studio
Use the EnterpriseDB ODBC Driver to create workflows that access real-time EnterpriseDB without any coding.
-
Connect to MariaDB from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for MariaDB to connect to MariaDB and execute queries in PowerBuilder.
-
Analyze Snowflake in Infragistics Reveal
Use the CData API Server to create an OData API on top of Snowflake and visualize live Snowflake in Infragistics Reveal.
-
Import Real-Time Google Sheets via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Google Sheets in ColdFusion.
-
Use the CData ODBC Driver for Salesloft from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Salesloft to connect to Salesloft from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Salesloft in Excel.
-
Process & Analyze Todoist in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Todoist .
-
Connect to ClickUp from a Connection Pool in WebLogic
Use the CData JDBC Driver for ClickUp to connect to ClickUp from Web applications running on WebLogic.
-
Analyze Office 365 in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Microsoft Office 365 and visualize live Microsoft Office 365 in Infragistics Reveal.
-
Import Zendesk into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Zendesk. In this article, you will use the OData format to import Zendesk into Microsoft Power Query.
-
Build a Simple VCL Application for Todoist
How to build a simple VCL Application to view Todoist in RAD Studio using the CData ODBC Driver for Todoist.
-
Automated Continuous PostgreSQL Replication to SingleStore
Use CData Sync for automated, continuous, customizable PostgreSQL replication to SingleStore.
-
View Reports on Real-Time Presto in Power BI Report Server
Use the CData ODBC Driver for Presto to visualize Presto in Power BI Desktop and then publish them to Power BI Report Server.
-
Replicate Quickbase to Multiple Databases via the CData Sync CLI
Replicate Quickbase to disparate databases with a single configuration.
-
Publish Smartsheet-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Smartsheet.
-
Automate Cloudant Replication to Azure Synapse
Use CData Sync to customize and automate IBM Cloudant replication to Azure Synapse.
-
Use Dash to Build to Web Apps on Amazon Athena
Create Python applications that use pandas and Dash to build Amazon Athena-connected web apps.
-
How to connect to Hive in DBVisualizer
Integrate Apache Hive with visual data analysis tools and data connection wizards in DBVisualizer
-
SAS xpt Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SAS xpt facts in real time.
-
Import and Visualize Google Cloud Storage in Power View
Create data visualizations based on Google Cloud Storage in Excel.
-
Replicate Google Analytics from PowerShell
Write a quick PowerShell script to query Google Analytics. Use connectivity to the live data to replicate Google Analytics to SQL Server.
-
Configure the CData JDBC Driver for SAP BusinessObjects BI in a Connection Pool in Tomcat
Connect to SAP BusinessObjects BI from a connection pool in Tomcat.
-
Build AI/ML Models with Live Quickbase Data using Dataiku
-