CData Software - Knowledge Base
Recent Articles
-
Visualize Workday Data in Sisense
Create an ElastiCube in Sisense app with access to Workday.
-
Connect to PabblySubscriptions in SpagoBI
Create reports featuring live PabblySubscriptions in SpagoBI Studio. Host PabblySubscriptions reports on SpagoBI Server.
-
Connect to Grafana Data in RapidMiner
Integrate Grafana with standard components and data source configuration wizards in RapidMiner Studio.
-
Add JSON Services to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for JSON with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrating Codex CLI with SQL Analysis Services 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.
-
Automated Continuous Impala Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Impala replication to Amazon S3.
-
Automated Continuous SharePoint Replication to MongoDB
Use CData Sync for automated, continuous, customizable SharePoint replication to MongoDB.
-
Integrate Shortcut with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Shortcut with External Services.
-
Connect to RSS Feeds in Aqua Data Studio
Access RSS Feeds from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Query Access Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Access entities in PHP by modeling them as objects.
-
How to Connect to & Open Bitly Data in Microsoft Excel
This article uses the CData ODBC driver for Bitly to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Access Gong Data from MySQL in PHP
Connect to Gong through the standard MySQL libraries in PHP.
-
Import Real-Time Zendesk Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Zendesk in ColdFusion.
-
Getting Started with the CData JDBC Driver for Onfleet
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Onfleet.
-
Publish Avalara AvaTax-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Avalara AvaTax.
-
Query Amazon DynamoDB Data as a MySQL Database in Node.js
Execute MySQL queries against Amazon DynamoDB from Node.js.
-
Build Dotmailer-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Dotmailer.
-
Build LinkedIn Visualizations in Tableau Cloud
Use CData Connect AI to connect to live LinkedIn and build visualizations in Tableau Cloud.
-
Query Salesforce Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Salesforce & Force.com from Node.js.
-
Use the CData Software JDBC Driver for Lakebase in MicroStrategy
Connect to Lakebase in MicroStrategy Developer using the CData Software JDBC Driver for Lakebase.
-
Connect to PayPal Data from PowerBuilder via ADO.NET
This article demonstrates how to access PayPal from Appeon PowerBuilder using the CData ADO.NET Provider for PayPal.
-
How to Visualize Box 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 Box in Python.
-
Getting Started with the CData Power BI Connector for CockroachDB
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for CockroachDB.
-
Connect to Salesforce CRM Analytics Data in CloverDX (formerly CloverETL)
Transfer Salesforce CRM Analytics using the visual workflow in the CloverDX data integration tool.
-
Create Informatica Mappings From/To an ODBC Data Source for Freshservice
Create an ODBC connection to Freshservice in Informatica and browse and transfer Freshservice.
-
Connect to Highrise Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Highrise CRM.
-
Connect to and Query HelloSign Data in QlikView over ODBC
Create data visualizations with HelloSign in QlikView.
-
Build ADP-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for ADP to explore live ADP Data in GitHub Copilot to assist with building ADP-powered applications.
-
Integrate Live Email Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Analyze Sybase IQ Data in Cognos Analytics
Use CData Connect AI to connect to Sybase IQ Data from Cognos Analytics and analyze live Sybase IQ.
-
Query BigCommerce Data in ColdFusion
Write standard ColdFusion data access code to connect to BigCommerce.
-
Query Adobe Target Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Adobe Target and perform CRUD operations on Adobe Target from Node.js.
-
Integrate Freshservice Data in Pentaho Data Integration
Build ETL pipelines based on Freshservice in the Pentaho Data Integration tool.
-
How to Easily Query Impala Data in OpenOffice Base
Connect to Impala data in OpenOffice Base using the CData ODBC Driver for Impala and generate reports with live data insights.
-
How to Connect to Retently Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Retently. Leverage the pyodbc module for ODBC in Python.
-
How to load Short.io data into Elasticsearch via Logstash
Introducing a simple method to load Short.io data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate Theia IDE with Live IBM Cloud Object Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
How to Build an ETL App for Oracle Eloqua Data in Python with CData Connect AI
Build ETL pipelines that read and write live Oracle Eloqua in Python with petl and the CData Connect AI Python SDK.
-
Connect to Zendesk from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Zendesk, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Live Azure DevOps Data in MicroStrategy through CData Connect AI
Create a live connection to Azure DevOps Data in CData Connect AI and connect to your Azure DevOps from MicroStrategy.
-
Connect to Coda Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Coda and work with Coda in your FileMaker application.
-
How to create Cvent federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Cvent in MySQL .
-
Replicate SageHR Data to Multiple Databases via the CData Sync CLI
Replicate SageHR to disparate databases with a single configuration.
-
A PostgreSQL Interface for PabblySubscriptions Data using the CData ODBC Driver
Use the SQL Gateway and PabblySubscriptions ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Microsoft Entra ID Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to and Visualize Live SAP SuccessFactors Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SAP SuccessFactors.
-
Create SharePoint Excel Services Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SharePoint Excel Services data access from reports, embedded analytics, and more.
-
Query Sybase IQ Data in DataGrip
Create a Data Source for Sybase IQ in DataGrip and use SQL to query live Sybase IQ.
-
Analyze Copper Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Copper from Power Pivot. You will use the Table Import Wizard to load Copper. You can visually build the import query or use any SQL supported by the driver.
-
Configure the CData JDBC Driver for Front in a Connection Pool in Tomcat
Connect to Front from a connection pool in Tomcat.
-
Build Semantic Layer Views for Stripe Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Stripe.
-
Getting Started with the CData Python Connector for Active Directory
Learn to install and license the CData Python Connector
-
Replicate Multiple Google Search Accounts via the CData Sync CLI
Replicate multiple Google Search accounts to one or many databases.
-
Build Semantic Layer Views for Everhour Data in APOS Live Data Gateway
Use the CData Connector for Everhour in APOS Live Data Gateway to build Semantic Layer Views for Everhour.
-
Integrate Kafka Data in the Pentaho Report Designer
Publish reports based on Apache Kafka in the Pentaho BI tool.
-
Getting Started with the CData Python Connector for SharePoint Excel Services
Learn to install and license the CData Python Connector
-
Enable the Beeminder JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Beeminder.
-
Use the CData Software ODBC Driver for Phoenix in MicroStrategy
Connect to Apache Phoenix in MicroStrategy Developer using the CData Software ODBC Driver for Phoenix.
-
Integrate Google Ads Data in Pentaho Data Integration
Build ETL pipelines based on Google Ads in the Pentaho Data Integration tool.
-
Getting Started with the CData ADO.NET Provider for Templated
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Integrating GitHub Copilot CLI with Microsoft Office 365 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.
-
How to integrate FormSite with Apache Airflow
Access and process FormSite in Apache Airflow using the CData JDBC Driver.
-
Connect to FreeAgent Data in CloverDX (formerly CloverETL)
Transfer FreeAgent using the visual workflow in the CloverDX data integration tool.
-
Natively Connect to Wistia Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Wistia. Leverage the native support for ODBC in PHP.
-
Build Agents in Relevance AI with Access to Live MailChimp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on MailChimp within intelligent agent workflows.
-
Connect to PayPal from Asprova with CData Software ODBC Driver for PayPal
This article shows how to connect faster to PayPal data from Asprova.
-
Connect to ClickTime Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to ClickTime and work with ClickTime in your FileMaker application.
-
Connect to SharePoint Data in Google Apps Script via Connect AI
Use CData Connect AI to access Microsoft SharePoint in Google Apps Script.
-
How to Work with Zoho Recruit Data in AWS Glue Jobs Using JDBC
Connect to Zoho Recruit from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Analyze Microsoft Dataverse Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Microsoft Dataverse (CDS) and visualize Microsoft Dataverse (CDS) in SAP Analytics Cloud.
-
How to Connect to Live Kintone 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 Kintone without replication.
-
Integrate with Bullhorn CRM Data in JReport Designer
Create charts and reports based on Bullhorn CRM in JReport Designer.
-
Access Live Odoo Data in TIBCO Data Virtualization
Use the Odoo Tibco DV Adapter to create a Odoo ERP data source in TIBCO Data Virtualization Studio and gain access to live Odoo ERP from your TDV Server.
-
How to Work with Hacker News Data in AWS Glue Jobs Using JDBC
Connect to Hacker News from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Connect WooCommerce 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 WooCommerce data in real time using natural language.
-
Migrating data from Instantly to Databricks using CData SSIS Components.
Easily push Instantly to Databricks using the CData SSIS Tasks for Instantly and Databricks.
-
DataBind Controls to Excel Data in Delphi
DataBind to Microsoft Excel in Delphi with standard data access components and controls.
-
How to Connect DBeaver to Azure Analysis Services via a JDBC Driver
Manage Azure Analysis Services with visual tools in DBeaver like the query browser.
-
Access PagerDuty Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live PagerDuty from HeidiSQL.
-
Query Live AlloyDB Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Google AlloyDB directly from the development environment.
-
Connect to Quaderno Data in CloverDX (formerly CloverETL)
Transfer Quaderno using the visual workflow in the CloverDX data integration tool.
-
Extract, Transform, and Load Twilio Data in Informatica PowerCenter
Create a simple Workflow for Twilio in Informatica PowerCenter.
-
Connect and Visualize Live Splunk Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Splunk into the Databricks platform and create visualization dashboards with real-time Splunk.
-
Build Apps with Live Salesforce Data Using the Low-Code Development Platform of Mendix
Connect Salesforce & Force.com with Mendix to build apps using the CData JDBC Driver for Salesforce.
-
How to connect and process CloudConvert from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live CloudConvert.
-
Connect to Lakebase Data in Jaspersoft Studio
Execute SQL to remote Lakebase in Jaspersoft Studio.
-
Use the CData SSIS Components to Insert New or Update Existing EnterpriseDB Records from SQL Server
Easily push SQL Server data to EnterpriseDB using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into EnterpriseDB or update existing records with data from a SQL Server database.
-
Connect to Zoho Inventory Data in HULFT Integrate
Connect to Zoho Inventory as a JDBC data source in HULFT Integrate
-
Choosing the Best Method to Connect BigQuery to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Google BigQuery from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate Gong with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Gong with External Services.
-
Build MVC Applications with Connectivity to Spark Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Spark from an ASP.NET MVC application.
-
Build Voice Agents in ElevenLabs with access to Live Klaviyo Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Klaviyo.
-
Automated Continuous Oracle Eloqua Replication to Vertica
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to Vertica.
-
Build Apps with Live SAP BusinessObjects BI Data Using the Low-Code Development Platform of Mendix
Connect SAP BusinessObjects BI with Mendix to build apps using the CData JDBC Driver for SAP BusinessObjects BI.
-
How to import SAP Business One Data into Apache Solr
Use the CData Software JDBC Driver for SAP Business One in Data Import Handler and create an automated import of SAP Business One to Apache Solr Enterprise Search platform.
-
Visualize Live Klaviyo Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Klaviyo.
-
Visualize Live SurveyMonkey Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SurveyMonkey.
-
Publish OneNote-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Microsoft OneNote.
-
How to Work with Oracle Service Cloud Data in ETL Validator JDBC
Connect to Oracle Service Cloud from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Connect Flowise AI Agents to Live Zoho Books 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 Zoho Books without replication.