CData Software Knowledge Base

Automated Continuous SAS xpt Replication to OneLake in Microsoft Fabric

Use CData Sync for automated, continuous, customizable SAS XPORT replication to OneLake in Microsoft Fabric.

How to use SQLAlchemy ORM to access Klaviyo in Python

Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Klaviyo.

Connect to Amazon Athena from Excel & GoogleSheets!

Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Amazon Athena, and over 250 other data sources, right inside your Excel and Google spreadsheets!

Connect to Quickbase in Aqua Data Studio

Access Quickbase from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

How to connect and process SAS XPORT from Azure Databricks

Use CData, Azure, and Databricks to perform data engineering and data science on live SAS XPORT.

How to Access Live SAS Data Sets in Visual Studio Code via Cline

Run the CData MCP Server for SAS Data Sets on Windows Subsytem for Linux (WSL) and connect to live SAS Data Sets from the Cline extension in Visual Studio Code.

Connect Excel Online to AI Assistants With the CData Python MCP Server

Learn how to give AI assistants like Claude direct access to live Microsoft Excel Online using the CData Python MCP Server.

Automated Continuous Invoiced Replication to Amazon Redshift

Use CData Sync for automated, continuous, customizable Invoiced replication to Amazon Redshift.

Import Real-Time Shopify via ODBC in ColdFusion to Build Applications

Use CData ODBC drivers to import and use Shopify in ColdFusion.

Analyze Google Spanner in R via JDBC

Use standard R functions and the development environment of your choice to analyze Google Spanner with the CData JDBC Driver for Google Spanner.

Build Dashboards with Office 365 in DBxtra

Create dynamic dashboards and perform analytics based on Microsoft Office 365 in DBxtra.

Visualize MongoDB in Sisense

Create an ElastiCube in Sisense app with access to MongoDB.

Use the CData ODBC Driver for Blackbaud FE NXT in Microsoft Power Query

You can use the CData Blackbaud FE NXT ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Blackbaud FE NXT into Microsoft Power Query.

Query, Visualize, and Share live SAP ByDesign in Redash

Use CData Connect AI to connect to live SAP Business ByDesign in Redash for querying, visualizing, and sharing.

Integrate HarperDB in Pentaho Data Integration

Build ETL pipelines based on HarperDB in the Pentaho Data Integration tool.

Google Drive Cloud Connectivity

Explore a compilation of guides and tutorials demonstrating how to establish connections to Google Drive through CData Connect AI using different applications and tools.

Connect to Microsoft Exchange from Excel & GoogleSheets!

Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Microsoft Exchange, and over 250 other data sources, right inside your Excel and Google spreadsheets!

Automated Continuous Act CRM Replication to Google Cloud SQL

Use CData Sync for automated, continuous, customizable Act CRM replication to Google Cloud SQL.

Back Up Zoho Creator to SQL Server through SSIS

Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Zoho Creator. In this article, we will employ an SSIS workflow to populate a database with Zoho Creator data.

Build Dashboards with SAP Hybris C4C in DBxtra

Create dynamic dashboards and perform analytics based on SAP Hybris C4C in DBxtra.

Automate Shopify Tasks in Power Automate Using CData API Server

With CData API Server, easily create OData endpoints for live Shopify and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.

Easily Integrate JotForm in Lazarus Pascal IDE

Learn how to easily integrate live JotForm in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

Bind Live Printify Data in Wijmo FlexGrid with CData API Server

With CData API Server, easily create OData endpoints for live Printify data

How to Query Live Zoho Projects Data in Natural Language in Python using LlamaIndex

Use LlamaIndex to query live Zoho Projects data in natural language using Python.

DataBind Controls to Invoiced in Delphi

DataBind to Invoiced in Delphi with standard data access components and controls.

Create Power BI Reports on Real-Time PostgreSQL

Use the CData ODBC Driver for PostgreSQL to visualize PostgreSQL in Power BI Desktop.

Work with Live Salesforce Pardot in Power Query

Use CData Connect AI to connect to Salesforce Pardot and work with live Salesforce Pardot in Microsoft Power Query.

Connect to Procore in JRuby

Create a simple JRuby app with access to live Procore.

Integrate Live SAP SuccessFactors into Amazon SageMaker Canvas with RDS

Use CData Connect AI to connect to SAP SuccessFactors from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SAP SuccessFactors.

Connecting Moonlit Workflow with MySQL via CData Connect AI MCP Server

Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your MySQL in real time.

View Reports on Real-Time Twilio in Power BI Report Server

Use the CData ODBC Driver for Twilio to visualize Twilio in Power BI Desktop and then publish them to Power BI Report Server.

How to pipe Oracle Service Cloud to CSV in PowerShell

Use standard PowerShell cmdlets to access Oracle Service Cloud tables.

Connect to Marketo as a SQL Server Linked Server

Use CData Connect AI to create a linked server for live Marketo.

Use Azure AI Foundry to Talk to Your SingleStore 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 SingleStore for you.

How to Access Live YouTube Analytics in Power Automate Desktop via ODBC

The CData ODBC Driver for YouTube Analytics enables you to integrate YouTube Analytics into workflows built using Microsoft Power Automate Desktop.

Automated Printify Replication to Teradata

Use CData Sync to Customize and automate Printify replication to Teradata.

Access JotForm from MySQL in PHP

Connect to JotForm through the standard MySQL libraries in PHP.

Build a Simple VCL Application for Outreach.io

How to build a simple VCL Application to view Outreach.io in RAD Studio using the CData ODBC Driver for Outreach.io.

Access LinkedIn Ads from MySQL in PHP

Connect to LinkedIn Ads through the standard MySQL libraries in PHP.

Create Oracle HCM Cloud Reports on JasperReports Server

Deploy the CData JDBC Driver on JasperReports Server to provide real-time Oracle HCM Cloud data access from reports, embedded analytics, and more.

Connect to Facebook Ads in DBeaver

Use the CData ODBC Driver to connect to Facebook Ads in DBeaver.

How to Create Power BI Visual Reports with Real-Time Google Drive

Use CData Power BI Connectors to visualize Google Drive in Power BI.

Access Live Pinterest in SAS JMP via ODBC

You can use the CData ODBC Driver to integrate Pinterest into the statistical analysis tools available in SAS JMP. This article shows how to use Pinterest in the Graph Builder and Query Builder.

How to connect PolyBase to LinkedIn Ads

Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live LinkedIn Ads.

Build Dashboards with Oracle HCM Cloud in DBxtra

Create dynamic dashboards and perform analytics based on Oracle HCM Cloud in DBxtra.

Visualize Live Unbounce in Tableau

Use CData Tableau Connectors and Tableau Desktop to visualize live Unbounce.

ETL Microsoft OneDrive in Oracle Data Integrator

This article shows how to transfer Microsoft OneDrive into a data warehouse using Oracle Data Integrator.

CData Software - Knowledge Base

Recent Articles