CData Software - Knowledge Base
Recent Articles
-
Automated Google Sheets Data Replication to Teradata
Use CData Sync to Customize and automate Google Sheets replication to Teradata.
-
How to Connect the Power BI Service to Google Analytics: Complete Guide
Connect to the CData Software Power BI Connector for Google Analytics from PowerBI.com to provide real-time Google Analytics across the organization.
-
How to Work with Outreach.io Data in AWS Glue Jobs Using JDBC
Connect to Outreach.io from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect Office 365 to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Microsoft Office 365 using the CData Python MCP Server.
-
Connect to DocuSign Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for DocuSign and the SQL Gateway to access DocuSign from Google Apps Script.
-
Build Dashboards with Apify Data in Dundas BI
Create dynamic dashboards and perform analytics based on Apify in Dundas BI.
-
Connect Adobe Analytics to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Adobe Analytics using the CData Python MCP Server.
-
How to connect PolyBase to SAP Ariba Procurement
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SAP Ariba Procurement.
-
Build Apps with Live SAP Business One in Adalo using CData Connect AI
Use CData Connect AI to integrate live SAP Business One into the Adalo platform and build custom mobile and web applications with real-time SAP Business One.
-
Build Gorgias-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Gorgias and build web apps with connectivity to live Gorgias.
-
Connect to Act-On Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Act-On in the Denodo Virtual DataPort Administrator.
-
Connect to OnePageCrm Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for OnePageCrm.
-
Automate Zoho Books Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Zoho Books and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to Connect DBeaver to Redshift via a JDBC Driver
Manage Amazon Redshift with visual tools in DBeaver like the query browser.
-
Automated Chargebee Data Replication to Teradata
Use CData Sync to Customize and automate Chargebee replication to Teradata.
-
Publish Reports with Klaviyo Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Klaviyo.
-
Connect and Visualize Live Greenhouse Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Greenhouse into the Databricks platform and create visualization dashboards with real-time Greenhouse.
-
Create Data Visualizations in Cognos BI with Google Translate Data
Access Google Translate as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Import Real-Time EnterpriseDB Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use EnterpriseDB in ColdFusion.
-
Automated Continuous SAP BusinessObjects BI Replication to MongoDB
Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to MongoDB.
-
Access Paddle Data from MySQL in PHP
Connect to Paddle through the standard MySQL libraries in PHP.
-
Query Lakebase Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Lakebase and perform CRUD operations on Lakebase from Node.js.
-
Bridge Confluence Connectivity with Apache NiFi
Access and process Atlassian Confluence in Apache NiFi using the CData JDBC Driver.
-
Connect to Delighted from a Connection Pool in WebLogic
Use the CData JDBC Driver for Delighted to connect to Delighted from Web applications running on WebLogic.
-
Connect to Dynamics CRM Data from PowerBuilder via ADO.NET
This article demonstrates how to access Microsoft Dynamics CRM from Appeon PowerBuilder using the CData ADO.NET Provider for Dynamics CRM.
-
ShipStation Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to ShipStation through CData Connect AI using different applications and tools.
-
Model, Search, and Visualize Live Azure Data Lake Storage Data in ThoughtSpot
Use CData Connect AI to connect to live Azure Data Lake Storage for modeling, searching, and visualizing.
-
Build Pipelines with Live Avro Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Avro from Google Cloud Data Fusion, enabling the integration of live Apache Avro into the building and management of effective data pipelines.
-
Access Live Couchbase Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Couchbase from your Excel spreadsheets.
-
Visualize Perplexity Data in TIBCO Spotfire through ADO.NET
Integrate Perplexity into dashboards in TIBCO Spotfire.
-
Connect to Miro Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Miro and work with Miro in your FileMaker applications.
-
Automated Continuous Greenhouse Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Greenhouse replication to Apache Cassandra.
-
How to Seamlessly Import MySQL Data into IBM SPSS Modeler
Integrate MySQL data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Feed Brex Data into FineReport
How to set Brex as a JDBC data source in FineReport.
-
Automated Continuous Dynamics CRM Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to Google BigQuery.
-
How to work with Apify Data in Apache Spark using SQL
Access and process Apify Data in Apache Spark using the CData Software JDBC Driver.
-
Use the CData Software ODBC Driver for LeadDesk in SAS for Real-Time Reporting and Analytics
Connect to real-time LeadDesk in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for LeadDesk.
-
Getting Started with the CData Python Connector for Klaviyo
Learn to install and license the CData Python Connector
-
Create MariaDB-Connected Applications in Appsmith
Connect to MariaDB Data via CData Connect AI in Appsmith and create custom business applications with real-time access to MariaDB.
-
How to connect SharePoint with Oracle SCM Data through external lists
Provide Oracle SCM to SharePoint users as an external list.
-
Working with Outlook Data in LINQPad
Execute LINQ queries to Outlook in LINQPad.
-
Work with BigQuery Data in FoxPro
Load Google BigQuery into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect and Query Live Adobe Commerce Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Adobe Commerce into Databricks
-
Write a Simple Go Application to work with Pinterest Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Pinterest.
-
Getting Started with the CData Python Connector for CockroachDB
Learn to install and license the CData Python Connector
-
Connect to Moosend Data in Aqua Data Studio
Access Moosend from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Access Google Sheets Data from MySQL in PHP
Connect to Google Sheets through the standard MySQL libraries in PHP.
-
Connect to WordPress Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for WordPress in the Denodo Virtual DataPort Administrator.
-
Build Apps with Live PingOne Data Using the Low-Code Development Platform of Mendix
Connect PingOne with Mendix to build apps using the CData JDBC Driver for PingOne.
-
Connecting Pipedream with Sage Intacct Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Sage Intacct data in real time.
-
Back Up Factorial to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Factorial data.
-
How to Design Certinia Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Certinia from mobile and tablet Power Apps.
-
Create BigCommerce-Connected Applications in Appsmith
Connect to BigCommerce Data via CData Connect AI in Appsmith and create custom business applications with real-time access to BigCommerce.
-
Use Manus AI to Talk to Your AlloyDB 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 Google AlloyDB.
-
Integrate Rootly with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Rootly with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Rootly.
-
DataBind Controls to Dotmailer Data in C++Builder
DataBind to Dotmailer in C++Builder with standard components and controls.
-
Build Visualizations of Marketo Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Marketo in Birst.
-
A PostgreSQL Interface for Instagram Data using the CData ODBC Driver
Use the SQL Gateway and Instagram ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Vault CRM Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Veeva Vault & Vault CRM replication to OneLake in Microsoft Fabric.
-
Visualize Procore Data in Tableau
The CData ODBC driver for Procore enables you integrate Procore into Tableau dashboards.
-
Automated Continuous Invoiced Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Invoiced replication to Apache Kafka.
-
How to Build an ETL App for Hacker News Data in Python with CData
Create ETL applications and real-time data pipelines for Hacker News in Python with petl.
-
Connecting Moonlit Workflow with HubSpot Data 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 HubSpot in real time.
-
Build Redshift-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Redshift to explore live Redshift Data in GitHub Copilot to assist with building Redshift-powered applications.
-
Automate Attio Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Attio from PowerShell? This article demonstrates how to utilize the Attio Cmdlets for tasks like connecting to Attio, automating operations, downloading data, and more.
-
How to Connect Azure Table 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 Azure Table data in real time using natural language.
-
Create Reports with Avaza Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Avaza.
-
Build LinkedIn Ads-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for LinkedIn Ads Data and create custom apps in Bubble.
-
DataBind Rebilly Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Rebilly to a chart.
-
Build Semantic Layer Views for PostgreSQL Data in APOS Live Data Gateway
Use the CData Connector for PostgreSQL in APOS Live Data Gateway to build Semantic Layer Views for PostgreSQL.
-
Automate Gmail Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Gmail from PowerShell? This article demonstrates how to utilize the Gmail Cmdlets for tasks like connecting to Gmail, automating operations, downloading data, and more.
-
How to Connect to Live Smartsheet Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Smartsheet without replication.
-
How to connect and process Toggl from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Toggl.
-
Automated Continuous eBay Replication to Databricks
Use CData Sync for automated, continuous, customizable eBay replication to Databricks.
-
Connect to AfterShip from Asprova with CData Software ODBC Driver for AfterShip
This article shows how to connect faster to AfterShip data from Asprova.
-
Build Agents in Relevance AI with Access to Live Impala Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Apache Impala within intelligent agent workflows.
-
Build a PostgreSQL Interface for Printify Data using the CData JDBC Driver
Use the Remoting features of the Printify JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Onfleet in SpagoBI
Create reports featuring live Onfleet in SpagoBI Studio. Host Onfleet reports on SpagoBI Server.
-
Query Oracle SCM Data in ColdFusion
Write standard ColdFusion data access code to connect to Oracle SCM.
-
Access Live LaunchDarkly Data in Coginiti Pro
Connect to and query live LaunchDarkly from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Getting Started with the CData Tableau Connector for Lakebase
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Lakebase.
-
Publish Crystal Reports on ChargeOver Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ChargeOver.
-
Connect to MailerSend Data in NetBeans
Connect to MailerSend in NetBeans with the data source configuration wizard.
-
Integrating Kiro CLI with GitLab 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 SAP BusinessObjects BI Data from HeidiSQL
Use CData Connect AI to connect to and query live SAP BusinessObjects BI from HeidiSQL.
-
Visualize Shopify Data in Sisense
Create an ElastiCube in Sisense app with access to Shopify.
-
How to Connect to Live Azure Analysis Services Data 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 Azure Analysis Services for you.
-
Excel Spreadsheet Automation on ChargeOver Data with the QUERY Formula
Pull data from ChargeOver, automate spreadsheets, and more with the QUERY formula.
-
Automate Certinia Data Replication to Azure Synapse
Use CData Sync to customize and automate Certinia replication to Azure Synapse.
-
How to Build an ETL App for eBay Data in Python with CData Connect AI
Build ETL pipelines that read and write live eBay in Python with petl and the CData Connect AI Python SDK.
-
Build Apps with Live Greenhouse Data Using the Low-Code Development Platform of Mendix
Connect Greenhouse with Mendix to build apps using the CData JDBC Driver for Greenhouse.
-
Build Semantic Layer Views for Freshdesk Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Freshdesk.
-
Replicate Sybase Data in Heroku for Use in Salesforce Connect
Replicate Sybase to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed WordPress to Power BI dashboards. Simply drag and drop WordPress into data visuals on the Power BI canvas.
-
DataBind Controls to Rootly Data in C++Builder
DataBind to Rootly in C++Builder with standard components and controls.
-
Enable the SFTP JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SFTP.
-
Getting Started with the CData Tableau Connector for Aweber
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Access Live QuickBooks Online Data in AWS Lambda
Connect to live QuickBooks Online in AWS Lambda using the CData JDBC Driver.
-
Write a Simple Go Application to work with Azure Analysis Services Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Azure Analysis Services.
-
Use the CData Software JDBC Driver for Zoho Inventory in MicroStrategy Web
Connect to Zoho Inventory in MicroStrategy Web using the CData Software JDBC Driver for Zoho Inventory.