CData Software - Knowledge Base
Recent Articles
-
Connect to iContact Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for iContact and the SQL Gateway to access iContact from Google Apps Script.
-
How to connect and process Hubstaff from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Hubstaff.
-
How to Query Live MariaDB Data in Perplexity MacOS Desktop
Connect to and query live MariaDB Data in Perplexity Desktop using CData MCP Server.
-
Build Splunk-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Splunk.
-
Create Informatica Mappings From/To a JDBC Data Source for Productboard
Create Productboard data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Validate Printful Data with QuerySurge
Access and validate Printful in QuerySurge using the CData JDBC Driver.
-
Visualize Live Zendesk Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Zendesk using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Enable the Optimizely JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Optimizely.
-
Manage SAP HANA XS Advanced Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SAP HANA XS Advanced.
-
Connect to Google Campaign Manager 360 Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Google Campaign Manager 360 as an External Source in Dremio.
-
Build a PostgreSQL Interface for Greenhouse Data using the CData JDBC Driver
Use the Remoting features of the Greenhouse JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build SAP Fieldglass-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SAP Fieldglass and build web apps with connectivity to live SAP Fieldglass.
-
Using the CData Software ODBC Driver for WordPress in PyCharm
Connect to WordPress as an ODBC data source in PyCharm using the CData Software ODBC Driver for WordPress.
-
Query Invoiced Data as a MySQL Database in Node.js
Execute MySQL queries against Invoiced from Node.js.
-
ETL SAS xpt in Oracle Data Integrator
This article shows how to transfer SAS XPORT into a data warehouse using Oracle Data Integrator.
-
How to Build an ETL App for Google Calendar Data in Python with CData Connect AI
Build ETL pipelines that read and write live Google Calendar in Python with petl and the CData Connect AI Python SDK.
-
Object-Relational Mapping (ORM) with OneNote Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Microsoft OneNote into a Java-based ORM framework, Hibernate.
-
Use the CData Software ODBC Driver for Salesforce Pardot in MicroStrategy
Connect to Salesforce Pardot in MicroStrategy Developer using the CData Software ODBC Driver for Salesforce Pardot.
-
Visualize Live FreshBooks Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live FreshBooks.
-
Build Impala-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Impala to explore live Impala Data in Gemini Code Assist to assist with building Impala-powered applications.
-
Extract, Transform, and Load LionDesk Data in Informatica PowerCenter
Create a simple Workflow for LionDesk in Informatica PowerCenter.
-
Create SSAS Tabular Models from Beeminder Data
How to build a SQL Server Analysis Service Tabular Model from Beeminder using CData drivers.
-
Automated Continuous CouchDB Replication to Snowflake
Use CData Sync for automated, continuous, customizable CouchDB replication to Snowflake.
-
Replicate Microsoft Planner Data to Multiple Databases
Replicate Microsoft Planner to disparate databases with a point-and-click configuration.
-
Integrate Omnisend Data in the Pentaho Report Designer
Publish reports based on Omnisend in the Pentaho BI tool.
-
Integrate Strava Data in the Pentaho Report Designer
Publish reports based on Strava in the Pentaho BI tool.
-
Connect to Microsoft Exchange Data in Ruby
Connect to Microsoft Exchange in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Apps with Live SAP SuccessFactors LMS Data Using the Low-Code Development Platform of Mendix
Connect SAP SuccessFactors LMS with Mendix to build apps using the CData JDBC Driver for SAP SuccessFactors LMS.
-
Integrating Claude Code with Paylocity Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Paylocity within assisted coding and automated development workflows.
-
Use ChatGPT to Talk to Your Google Contacts Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Google Contacts for you.
-
Use Biml to Build SSIS Tasks to Replicate Apify Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Apify to SQL Server.
-
Connect to HelloSign Data as an External Source in Dremio
Use the CData JDBC Driver to connect to HelloSign as an External Source in Dremio.
-
How to Connect DBeaver to Delighted via a JDBC Driver
Manage Delighted with visual tools in DBeaver like the query browser.
-
Connect to IBM Informix from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from IBM Informix, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Provide OData Services of Quickbase Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Quickbase by developing a WCF Service Application.
-
Bidirectional Access to Productboard Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Productboard in Filemaker Pro for Mac or Windows.
-
Explore Geographical Relationships in Cassandra Data with Power Map
Create data visualizations with Apache Cassandra in Power Map.
-
Integrate with Zoom Data in JReport Designer
Create charts and reports based on Zoom in JReport Designer.
-
How to work with IBM Informix Data in Apache Spark using SQL
Access and process IBM Informix Data in Apache Spark using the CData Software JDBC Driver.
-
Access Dotmailer Data from MySQL in PHP
Connect to Dotmailer through the standard MySQL libraries in PHP.
-
How to connect to SAP Fieldglass Data with Squirrel SQL client
Connect to SAP Fieldglass and execute queries in the Squirrel SQL Client.
-
Create Dynamic Pinterest Grids Using the Infragistics XamDataGrid
Learn how you can connect Pinterest to Infragistics XamDataGrid to build dynamic grids.
-
Replicate PolarTeamPro Data to Multiple Databases
Replicate PolarTeamPro to disparate databases with a point-and-click configuration.
-
Configure the CData JDBC Driver for Autopilot in a Connection Pool in Tomcat
Connect to Autopilot from a connection pool in Tomcat.
-
Stream Cvent Data into Apache Kafka Topics
Access and stream Cvent in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Use the CData ODBC Driver for Impala from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Impala to connect to Apache Impala from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Apache Impala in Excel.
-
Visualize Paylocity Data in TIBCO Spotfire through OData
Integrate Paylocity into dashboards in TIBCO Spotfire.
-
Connect to WooCommerce Data in Jaspersoft Studio
Execute SQL to remote WooCommerce in Jaspersoft Studio.
-
Connect Azure Data Catalog to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Azure Data Catalog with IBM WebSphere for seamless data integration and connectivity.
-
Query Discourse Data as a MySQL Database in Node.js
Execute MySQL queries against Discourse from Node.js.
-
Access BigQuery Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Google BigQuery from HeidiSQL.
-
Import Real-Time Simplesat Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Simplesat in ColdFusion.
-
Migrating data from PhantomBuster to Databricks using CData SSIS Components.
Easily push PhantomBuster to Databricks using the CData SSIS Tasks for PhantomBuster and Databricks.
-
Manage Freshsales Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Freshsales.
-
Automated Continuous Freshdesk Replication to Databricks
Use CData Sync for automated, continuous, customizable Freshdesk replication to Databricks.
-
Integrating Dataiku with Couchbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Couchbase.
-
Object-Relational Mapping (ORM) with Optimizely Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Optimizely into a Java-based ORM framework, Hibernate.
-
Connect to and Visualize Live ZohoDesk Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live ZohoDesk.
-
Integrate Live SharePoint Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Microsoft SharePoint to Blue Prism using the CData ODBC Driver for SharePoint to create automated workflows for repetitive business tasks.
-
Use the CData Software ODBC Driver for Zendesk in SAS for Real-Time Reporting and Analytics
Connect to real-time Zendesk in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Zendesk.
-
How to Work with Presto Data in ETL Validator JDBC
Connect to Presto from ETL Validator jobs using the CData Software JDBC Driver.
-
Getting Started with the CData Python Connector for Mailgun
Learn to install and license the CData Python Connector
-
Creating EnterpriseDB-Connected Applications in Unqork
You can use CData Connect AI to feed EnterpriseDB to Unqork and build custom business apps.
-
Integrating Antigravity CLI with Stripe via CData CLI
Connect Stripe to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Analyze Wave Financial Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Wave Financial with the CData JDBC Driver for Wave Financial.
-
Connect to FreshBooks Data from PowerBuilder via JDBC
This article demonstrates how to access FreshBooks from PowerBuilder using the FreshBooks JDBC Driver.
-
Connect ChartMogul Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your ChartMogul using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Access Live Okta Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Okta from your Excel spreadsheets.
-
Automate eBay Analytics Data Replication to SAP HANA
Use CData Sync to customize and automate eBay Analytics replication to SAP HANA.
-
Use the CData Software ODBC Driver for Dotmailer in MicroStrategy Desktop
Connect to Dotmailer in MicroStrategy Desktop using the CData Software ODBC Driver for Dotmailer.
-
Publish ConstantContact-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ConstantContact.
-
Automated Continuous CSV Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable CSV replication to Apache Kafka.
-
Connect to SharePoint Excel Services Data in CloverDX (formerly CloverETL)
Transfer SharePoint Excel Services using the visual workflow in the CloverDX data integration tool.
-
Connect to Couchbase Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Query Apollo Data as a MySQL Database in Node.js
Execute MySQL queries against Apollo from Node.js.
-
Access Live Todoist Data in Coginiti Pro
Connect to and query live Todoist from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to connect PolyBase to Mailjet
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Mailjet.
-
Access Live Dynamics CRM Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Microsoft Dynamics CRM through MCP integration.
-
DataBind Controls to Sage Cloud Accounting Data in Delphi
DataBind to Sage Business Cloud Accounting in Delphi with standard data access components and controls.
-
Automated Continuous ClickTime Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable ClickTime replication to Amazon Redshift.
-
Query Campaigner Data in DataGrip
Create a Data Source for Campaigner in DataGrip and use SQL to query live Campaigner.
-
Integrating Claude Code CLI with Auth0 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.
-
Use Dash to Build to Web Apps on Guru Data
Create Python applications that use pandas and Dash to build Guru-connected web apps.
-
Create Data Visualizations in Cognos BI with Zendesk Data
Access Zendesk as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Extract, Transform, and Load FHIR Data in Informatica PowerCenter
Create a simple Workflow for FHIR in Informatica PowerCenter.
-
Getting Started with the CData ADO.NET Provider for Brex
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Integrate Elasticsearch with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Elasticsearch with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Elasticsearch.
-
View Reports on Real-Time Qualaroo Data in Power BI Report Server
Use the CData ODBC Driver for Qualaroo to visualize Qualaroo in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Pinterest Data in DBeaver
Use the CData ODBC Driver to connect to Pinterest in DBeaver.
-
Build Semantic Layer Views for Beeminder Data in APOS Live Data Gateway
Use the CData Connector for Beeminder in APOS Live Data Gateway to build Semantic Layer Views for Beeminder.
-
Connect to PayPal Data in Jaspersoft Studio
Execute SQL to remote PayPal in Jaspersoft Studio.
-
PostgreSQL Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on PostgreSQL facts in real time.
-
Natively Connect to Amazon DynamoDB Data in PHP
The CData ODBC driver for Amazon DynamoDB enables you to create PHP applications with connectivity to Amazon DynamoDB. Leverage the native support for ODBC in PHP.
-
Build Google Calendar-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Google Calendar and build Google Calendar-connected web apps with Axios.
-
Build a PostgreSQL Interface for Cloudant Data using the CData JDBC Driver
Use the Remoting features of the Cloudant JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Visualizations of PabblySubscriptions Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of PabblySubscriptions in Birst.
-
Access Azure Synapse 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 Azure Synapse.
-
Build Slack-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Slack to explore live Slack Data in Cursor to assist with building Slack-powered applications.
-
Create SSAS Tabular Models from Excel Online Data
How to build a SQL Server Analysis Service Tabular Model from Microsoft Excel Online using CData drivers.
-
Getting Started with the CData Excel Add-In for SharePoint
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SharePoint.