CData Software - Knowledge Base
Recent Articles
-
How to connect to Brex Data in DBVisualizer
Integrate Brex with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Pipedrive Data in Google Apps Script via Connect AI
Use CData Connect AI to access Pipedrive in Google Apps Script.
-
Create OData-Connected Applications in Appsmith
Connect to OData Services via CData Connect AI in Appsmith and create custom business applications with real-time access to OData.
-
How to Visualize Mailjet Data in Python with pandas
Use pandas and other modules to analyze and visualize live Mailjet in Python.
-
Create SSAS Tabular Models from Omnisend Data
How to build a SQL Server Analysis Service Tabular Model from Omnisend using CData drivers.
-
Integrate Live ShipStation Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live ShipStation to Blue Prism using the CData ODBC Driver for ShipStation to create automated workflows for repetitive business tasks.
-
Access SAP HANA XS Advanced Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SAP HANA XS Advanced from HeidiSQL.
-
Create SurveyMonkey-Connected Applications in Appsmith
Connect to SurveyMonkey Data via CData Connect AI in Appsmith and create custom business applications with real-time access to SurveyMonkey.
-
Build Dashboards with SAS xpt Data in DBxtra
Create dynamic dashboards and perform analytics based on SAS XPORT in DBxtra.
-
How to Work with Redis Data in ETL Validator JDBC
Connect to Redis from ETL Validator jobs using the CData Software JDBC Driver.
-
Publish Reports with Suadeo Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Suadeo.
-
Connect Quickbase to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Quickbase using the CData Python MCP Server.
-
Integrating Antigravity CLI with Zuora via CData CLI
Connect Zuora to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Use the CData Software ODBC Driver for TaxJar in MicroStrategy
Connect to TaxJar in MicroStrategy Developer using the CData Software ODBC Driver for TaxJar.
-
Connect to and Visualize Live BenchmarkEmail Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live BenchmarkEmail.
-
How to Visualize ZohoDesk Data in Python with pandas
Use pandas and other modules to analyze and visualize live ZohoDesk in Python.
-
Natively Connect to Freshsales Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Freshsales. Leverage the native support for ODBC in PHP.
-
Automated Continuous Vault CRM Replication to SQL Server
Use CData Sync for automated, continuous, customizable Vault CRM replication to SQL Server.
-
Create Dashboards and Visualize Live Confluence Data in Geckoboard
Use CData Connect AI to connect to live Atlassian Confluence and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Create Reports from GitLab Data in Looker Studio
Use CData Connect AI to gain access to live GitLab and create custom reports in Looker Studio.
-
How to work with Moosend Data in Apache Spark using SQL
Access and process Moosend Data in Apache Spark using the CData Software JDBC Driver.
-
Connect and Visualize Live Highrise Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Highrise CRM into the Databricks platform and create visualization dashboards with real-time Highrise CRM.
-
Natively Connect to FTP Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to FTP Servers. Leverage the native support for ODBC in PHP.
-
Connect to Google Search Results through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Google Search Results using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Access Live FTP Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live FTP Servers through MCP integration.
-
Automate Amplitude Data Replication to Azure Data Lake
Use CData Sync to customize and automate Amplitude replication to Azure Data Lake.
-
Connect to Reply.io Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Reply.io and the SQL Gateway to access Reply.io from Google Apps Script.
-
How to Query Live Redis Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Redis data in natural language using Python.
-
Visualize Humanity Data in Tableau
The CData ODBC driver for Humanity enables you integrate Humanity into Tableau dashboards.
-
Use the CData ODBC Driver for Attio from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Attio to connect to Attio from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Attio in Excel.
-
Create Reports with Ontraport Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Ontraport.
-
Build a Singer.io Tap for Everhour With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Everhour data using
-
Connect to Highrise Data in Aqua Data Studio
Access Highrise CRM from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Analyze Excel Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Microsoft Excel in Microsoft R Open.
-
Connect to Aircall in SpagoBI
Create reports featuring live Aircall in SpagoBI Studio. Host Aircall reports on SpagoBI Server.
-
Build Apps with Live Google Directory Data Using the Low-Code Development Platform of Mendix
Connect Google Directory with Mendix to build apps using the CData JDBC Driver for Google Directory.
-
Integrate SpaceX with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SpaceX with External Services.
-
Create a Data Access Object for ZohoDesk Data using JDBI
A brief overview of creating a SQL Object API for ZohoDesk in JDBI.
-
A PostgreSQL Interface for Wrike Data using the CData ODBC Driver
Use the SQL Gateway and Wrike ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Seamlessly Import Instantly Data into IBM SPSS Modeler
Integrate Instantly data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Snapchat Ads Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Snapchat Ads and build visualizations in Tableau Cloud.
-
Connect to Mode Data in DBArtisan
Use wizards in DBArtisan to configure Mode as a data source.
-
Build Dashboards with SharePoint Excel Services Data in Dundas BI
Create dynamic dashboards and perform analytics based on SharePoint Excel Services in Dundas BI.
-
Visualize Live Snapchat Ads Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Snapchat Ads.
-
Analyze Adobe Target Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Adobe Target with the CData JDBC Driver for Adobe Target.
-
Connect to Quaderno Data in RapidMiner
Integrate Quaderno with standard components and data source configuration wizards in RapidMiner Studio.
-
Replicate LaunchDarkly Data to Multiple Databases via the CData Sync CLI
Replicate LaunchDarkly to disparate databases with a single configuration.
-
Visualize Harvest 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 Harvest into TIBCO Spotfire.
-
Query LeadDesk Data as a MySQL Database in Node.js
Execute MySQL queries against LeadDesk from Node.js.
-
How to connect PolyBase to Supabase
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Supabase.
-
Connect to Salesforce Pardot Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Salesforce Pardot as an External Source in Dremio.
-
Build AI/ML Models with Live Oracle Eloqua Data using Dataiku
Connect Oracle Eloqua Data with Dataiku using the CData JDBC Driver for Oracle Eloqua.
-
Create Datasets from Webflow in Domo Workbench and Build Visualizations of Webflow Data in Domo
Use the CData Software ODBC Driver for Webflow to create datasets from Webflow in Domo Workbench and then build visualizations in the Domo service.
-
Automate Amazon S3 Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Amazon S3 from PowerShell? This article demonstrates how to utilize the Amazon S3 Cmdlets for tasks like connecting to Amazon S3, automating operations, downloading data, and more.
-
Automated Continuous Tally Replication to SQLite
Use CData Sync for automated, continuous, customizable Tally replication to SQLite.
-
Create Data Visualizations in Cognos BI with Teamgate Data
Access Teamgate as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Google Ad Manager Data from HeidiSQL
Use CData Connect AI to connect to and query live Google Ad Manager from HeidiSQL.
-
Build SAP Business One-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live SAP Business One and build SAP Business One-connected web apps with Axios.
-
Connect to Missive Data in RazorSQL
Connect to Missive from wizards and query Missive from the GUI in the RazorSQL database management tool.
-
How to Connect to Harvest Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Harvest. Leverage the pyodbc module for ODBC in Python.
-
How to Connect to Live SAS Data Sets Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your SAS Data Sets for you.
-
Operational Reporting on Adobe Analytics Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Adobe Analytics.
-
Access CouchDB Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Apache CouchDB.
-
Integrate Front with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Front with External Services.
-
Integrate LibreChat with Live Shopify Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Shopify from within the chat interface.
-
How to integrate Wrike with Apache Airflow
Access and process Wrike in Apache Airflow using the CData JDBC Driver.
-
Visualize Google Spanner Data in TIBCO Spotfire through OData
Integrate Google Spanner into dashboards in TIBCO Spotfire.
-
Building Dynamic Web Pages with Highrise Data Using AngularJS
Create single-page applications with live connectivity to Highrise using the CData API Server.
-
Couchbase Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Couchbase through CData Connect AI using different applications and tools.
-
Create Datasets from Facebook in Domo Workbench and Build Visualizations of Facebook Data in Domo
Use the CData Software ODBC Driver for Facebook to create datasets from Facebook in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous Azure Data Catalog Replication to Snowflake
Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to Snowflake.
-
Create Datasets from Todoist in Domo Workbench and Build Visualizations of Todoist Data in Domo
Use the CData Software ODBC Driver for Todoist to create datasets from Todoist in Domo Workbench and then build visualizations in the Domo service.
-
Build Semantic Layer Views for HubDB Data in APOS Live Data Gateway
Use the CData Connector for HubDB in APOS Live Data Gateway to build Semantic Layer Views for HubDB.
-
DataBind Controls to CampaignMonitor Data in Delphi
DataBind to CampaignMonitor in Delphi with standard data access components and controls.
-
How to Build an ETL App for Oracle SCM Data in Python with CData
Create ETL applications and real-time data pipelines for Oracle SCM in Python with petl.
-
How to Connect DBeaver to Google Campaign Manager 360 via a JDBC Driver
Manage Google Campaign Manager 360 with visual tools in DBeaver like the query browser.
-
Use JayDeBeApi to access Excel Data in Python
Use standard Python scripting and the development environment of your choice to access live Microsoft Excel.
-
Use the CData ODBC Driver for SQL Server in Microsoft Power Query
You can use the CData SQL Server ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Microsoft SQL Server into Microsoft Power Query.
-
Replicate Multiple Zuora Accounts via the CData Sync CLI
Replicate multiple Zuora accounts to one or many databases.
-
Import Snowflake Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Snowflake. In this article, you will use the OData format to import Snowflake into Microsoft Power Query.
-
Create a Data Access Object for PingOne Data using JDBI
A brief overview of creating a SQL Object API for PingOne in JDBI.
-
Manage Accelo Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Accelo.
-
Build Bitbucket-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Bitbucket to explore live Bitbucket Data in Claude Code to assist with building Bitbucket-powered applications.
-
Create Data Visualizations in Cognos BI with NetSuite Data
Access NetSuite CRM & ERP as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Getting Started with the CData ADO.NET Provider for OneNote
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for OneNote.
-
Connect to MailerLite Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Build Automated Workflows with Live MariaDB Data in Workato
Use CData Connect AI to connect to live MariaDB and build automated workflows in Workato.
-
How to create Close federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Close in MySQL .
-
Create SSAS Tabular Models from Exa Data
How to build a SQL Server Analysis Service Tabular Model from Exa using CData drivers.
-
Create Data Visualizations in Cognos BI with Onfleet Data
Access Onfleet as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Easily Query SQL Server Data in OpenOffice Base
Connect to SQL Server data in OpenOffice Base using the CData ODBC Driver for SQL Server and generate reports with live data insights.
-
Build Dashboards with SageHR Data in DBxtra
Create dynamic dashboards and perform analytics based on SageHR in DBxtra.
-
Automated Continuous SQL Server Replication to Snowflake
Use CData Sync for automated, continuous, customizable SQL Server replication to Snowflake.
-
Connect to Unbounce Data from PowerBuilder via JDBC
This article demonstrates how to access Unbounce from PowerBuilder using the Unbounce JDBC Driver.
-
Visualize Zoho Projects Data in TIBCO Spotfire through OData
Integrate Zoho Projects into dashboards in TIBCO Spotfire.
-
Replicate NetSuite Data to Multiple Databases
Replicate NetSuite CRM & ERP to disparate databases with a point-and-click configuration.
-
Access Live Google Spanner Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Google Spanner into the statistical analysis tools available in SAS JMP. This article shows how to use Google Spanner in the Graph Builder and Query Builder.
-
Integrate Spark Data into Power Automate Desktop using CData Connect
CData Connect for Spark Data enables you to integrate Apache Spark SQL into workflows built using Microsoft Power Automate Desktop.
-
Integrate Live iContact Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live iContact to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Access Simplesat Data from MySQL in Amazon QuickSight
Connect to Simplesat and build visualizations of Simplesat using a MySQL Connection in Amazon QuickSight.