CData Software - Knowledge Base
Recent Articles
-
Visualize QuickBooks Online Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to QuickBooks Online data.
-
Connect to Coda Data from PowerBuilder via ADO.NET
This article demonstrates how to access Coda data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Create PingOne-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to PingOne Data from OutSystems and build custom enterprise apps using live PingOne data.
-
Connect to and Visualize Live Samanage Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Samanage data.
-
Create Informatica Mappings From/To an ODBC Data Source for Foursquare
Create an ODBC connection to Foursquare in Informatica and browse and transfer Foursquare data.
-
Visualize Confluence Data in TIBCO Spotfire through ADO.NET
Integrate Confluence data into dashboards in TIBCO Spotfire.
-
Access Live Avalara AvaTax Data in AWS Lambda
Connect to live Avalara AvaTax data in AWS Lambda using the CData JDBC Driver.
-
How to Visualize Bitly Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Bitly data in Python.
-
Perplexity Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Perplexity data through CData Connect AI using different applications and tools.
-
LINQ to ZeroBounce 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 ZeroBounce Data Provider.
-
Visualize Live ADP Data in the Power BI Service
Use CData Connect AI to connect to live ADP data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Authorize.Net Data in Google Apps Script via Connect AI
Use CData Connect AI to access Authorize.Net data in Google Apps Script.
-
How to use SQLAlchemy ORM to access Redshift Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Redshift data.
-
Automated Continuous Foursquare Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Foursquare replication to Azure SQL Database.
-
Getting Started with the CData Tableau Connector for PayPal
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for PayPal.
-
How to connect to Klaviyo Data with Squirrel SQL client
Connect to Klaviyo data and execute queries in the Squirrel SQL Client.
-
A PostgreSQL Interface for Moosend Data using the CData ODBC Driver
Use the SQL Gateway and Moosend ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Claude Code with Microsoft Planner Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Microsoft Planner data within assisted coding and automated development workflows.
-
Connect to Eventbrite from Asprova with CData Software ODBC Driver for Eventbrite
This article shows how to connect faster to Eventbrite data from Asprova.
-
Integrate PingOne Data in Pentaho Data Integration
Build ETL pipelines based on PingOne data in the Pentaho Data Integration tool.
-
How to integrate Metabase with FTP Data
Use CData Connect AI to connect to live FTP data and create an interactive dashboard in Metabase from FTP data.
-
Choosing the Best Method to Connect Pinterest to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Pinterest data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build Shippo-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Shippo Data and create custom apps in Bubble.
-
Build Dashboards with Cloudflare Data in Dundas BI
Create dynamic dashboards and perform analytics based on Cloudflare data in Dundas BI.
-
How to create Visio diagrams from Microsoft Exchange Data
Automatically update Microsoft Exchange data with the changes you make to Visio master shapes.
-
Integrating Cursor with ZohoExpense 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.
-
Integrating Dataiku with Smartsheet Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Smartsheet data.
-
Access Live Google Analytics Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Analytics data from your Excel spreadsheets.
-
Automate Google Tasks Data Replication to Azure Data Lake
Use CData Sync to customize and automate Google Tasks data replication to Azure Data Lake.
-
Getting Started with the CData Excel Add-In for WordPress
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for WordPress.
-
Create ZohoPeople-Connected Dashboards in Grafana
Connect to ZohoPeople Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to ZohoPeople data.
-
How to Query Power BI XMLA Data in MySQL Workbench
Execute MySQL queries against live Power BI XMLA data from MySQL Workbench.
-
Getting Started with the CData Python Connector for SendPulse
Learn to install and license the CData Python Connector and configure a connection to live SendPulse data.
-
Viewing Mistral AI Data in RAD Studio Data Explorer
How to view Mistral AI data in RAD Studio Data Explorer using the CData ODBC Driver for Mistral AI.
-
Integrate Cursor with Live WordPress Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live WordPress data from within the editor.
-
Connecting Agentforce with Reckon Accounts Hosted Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Reckon Accounts Hosted data for you.
-
Build AI/ML Models with Live Mixpanel Data using Dataiku
Connect Mixpanel Data with Dataiku using the CData API Driver for JDBC.
-
Working with LaunchDarkly Data in LINQPad
Execute LINQ queries to LaunchDarkly data in LINQPad.
-
Connect to Square Data in HULFT Integrate
Connect to Square as a JDBC data source in HULFT Integrate
-
Integrating Dataiku with Freshteam Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Freshteam data.
-
Connect to Redshift 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 Redshift data.
-
Oracle Sales Reporting in OBIEE with the Oracle Sales JDBC Driver
Deploy the Oracle Sales JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use the CData Software ODBC Driver for Drip in MicroStrategy Desktop
Connect to Drip data in MicroStrategy Desktop using the CData Software ODBC Driver for Drip.
-
Getting Started with the CData JDBC Driver for Adobe Experience Manager
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Adobe Experience Manager.
-
Connect to Google Forms Data from a Connection Pool in JBoss
Integrate Google Forms data into Java servlets: Use the Management Console in JBoss to install the Google Forms JDBC Driver.
-
Access Adobe Analytics Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Adobe Analytics data from HeidiSQL.
-
Seamlessly Bring Cloudflare Data into Retool Using CData Connect AI
Integrate Cloudflare data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to Connect MailChimp 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 MailChimp data in real time using natural language.
-
Excel Spreadsheet Automation on Aha! Data with the QUERY Formula
Pull data from Aha!, automate spreadsheets, and more with the QUERY formula.
-
Connect to SparkPost Data from Crystal Reports
Use CData Connect AI to connect to and report on live SparkPost data from Crystal Reports.
-
Moving Data from Dynamics 365 to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Dynamics 365 data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Stream RSS Feeds into Apache Kafka Topics
Access and stream RSS feeds in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous PabblySubscriptions Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable PabblySubscriptions data replication to OneLake in Microsoft Fabric.
-
Create Shippo-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Shippo Data from OutSystems and build custom enterprise apps using live Shippo data.
-
Connect to Twilio 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 Twilio data.
-
Connect to Procore Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Procore data.
-
Integrate Live BigCommerce Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to BigCommerce data and integrate live BigCommerce data into apps built in Microsoft Power Apps.
-
Work with Attio Data in FoxPro
Load Attio data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Access Live Adobe Commerce Data in Excel 365 Online (Excel for the web)
Connect to Adobe Commerce data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Replicate Multiple Nuclia Accounts via the CData Sync CLI
Replicate multiple Nuclia accounts to one or many databases.
-
How to Connect to Live LinkedIn Ads Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your LinkedIn Ads data through natural language.
-
Process & Analyze Amplitude Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Amplitude Data.
-
Microsoft OneDrive Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Microsoft OneDrive data through CData Connect AI using different applications and tools.
-
Create Dynamic Templated Grids Using the Infragistics XamDataGrid
Learn how you can connect Templated to Infragistics XamDataGrid to build dynamic grids.
-
Integrate Grafana Data in Pentaho Data Integration
Build ETL pipelines based on Grafana data in the Pentaho Data Integration tool.
-
Query Exact Online Data in ColdFusion
Write standard ColdFusion data access code to connect to Exact Online data.
-
Replicate Multiple Zoho Projects Accounts
Replicate multiple Zoho Projects accounts to one or many databases.
-
Connect to Tally Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Tally Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Automated Continuous NetSuite Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable NetSuite replication to Azure SQL Database.
-
Visualize Aha! Data in TIBCO Spotfire through ADO.NET
Integrate Aha! data into dashboards in TIBCO Spotfire.
-
Automated Continuous PDFMonkey Replication to Vertica
Use CData Sync for automated, continuous, customizable PDFMonkey replication to Vertica.
-
How to Easily Query Teamgate Data in OpenOffice Base
Connect to Teamgate data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Create Smartsheet-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Smartsheet Data from OutSystems and build custom enterprise apps using live Smartsheet data.
-
How to Connect Flowise AI Agents to Live Microsoft Entra ID 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 Microsoft Entra ID data without replication.
-
Automated Continuous Excel Online Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Excel Online replication to AlloyDB.
-
Back Up Auth0 data 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 Auth0 data data.
-
Access SendPulse Data from MySQL in Amazon QuickSight
Connect to SendPulse and build visualizations of SendPulse data using a MySQL Connection in Amazon QuickSight.
-
How to work with Zoho Recruit Data in Apache Spark using SQL
Access and process Zoho Recruit Data in Apache Spark using the CData Software JDBC Driver.
-
Visualize AgileCRM Data in Tableau
The CData ODBC driver for AgileCRM enables you integrate AgileCRM data into Tableau dashboards.
-
How to import Sentry Data into Apache Solr
Use the CData Software JDBC Driver for Sentry in Data Import Handler and create an automated import of Sentry data to Apache Solr Enterprise Search platform.
-
Integrating Antigravity CLI with SAP Concur data via CData CLI
Connect SAP Concur data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Using the CData Software ODBC Driver for Salesforce CRM Analytics in PyCharm
Connect to Salesforce CRM Analytics as an ODBC data source in PyCharm using the CData Software ODBC Driver for Salesforce CRM Analytics.
-
Replicate Multiple Sage Intacct Accounts via the CData Sync CLI
Replicate multiple Sage Intacct accounts to one or many databases.
-
Connecting Moonlit Workflow with Mode 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 Mode data in real time.
-
Use the CData ODBC Driver for Workable in Microsoft Power Query
You can use the CData Workable ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Workable data into Microsoft Power Query.
-
How to Connect to Live OData Services from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your OData services through natural language.
-
Publish Reports with Dynamics CRM Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Dynamics CRM data.
-
Query Google Campaign Manager 360 Data as a SQL Server Database in Node.js
Execute SQL Server queries against Google Campaign Manager 360 data from Node.js.
-
Use the CData Software ODBC Driver for Hugging Face in MicroStrategy Desktop
Connect to Hugging Face data in MicroStrategy Desktop using the CData Software ODBC Driver for Hugging Face.
-
How to connect SharePoint with IBM Informix Data through external lists
Provide IBM Informix data to SharePoint users as an external list.
-
Automated Continuous Adobe Analytics Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Adobe Analytics replication to Amazon Redshift.
-
Automated Continuous Bright Data Replication to MongoDB
Use CData Sync for automated, continuous, customizable Bright Data replication to MongoDB.
-
Use the CData ODBC Driver for Zoho Creator from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Zoho Creator to connect to Zoho Creator data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Zoho Creator data in Excel.
-
Automated Continuous ConvertKit Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable ConvertKit replication to Apache Kafka.
-
Automate Azure Blob Storage Data Replication to Couchbase
Use CData Sync to Customize and automate Azure Blob Storage data replication to Couchbase.
-
How to Connect to Live Google Spanner Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Google Spanner data for you.
-
How to integrate Metabase with Office 365 Data
Use CData Connect AI to connect to live Office 365 data and create an interactive dashboard in Metabase from Office 365 data.
-
Connect to GraphQL Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live GraphQL data from Filemaker Pro on Mac.
-
Interact with Live SageHR Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live SageHR data.
-
Create Apps from Vertica Data in Qlik Sense Cloud
Use CData Connect AI to connect to Vertica Data and build apps from live Vertica data in Qlik Sense Cloud.