CData Software - Knowledge Base
Recent Articles
-
Connect to TigerGraph Data in NetBeans
Connect to TigerGraph data in NetBeans with the data source configuration wizard.
-
Connect to Yelp Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Yelp and the SQL Gateway to access Yelp data from Google Apps Script.
-
Integrate with Postmark Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Postmark data to a JSON file on disk.
-
How to integrate Discord with Apache Airflow
Access and process Discord data in Apache Airflow using the CData JDBC Driver.
-
How to Connect the Power BI Service to Wave Financial: Complete Guide
Connect to the CData Software Power BI Connector for Wave Financial from PowerBI.com to provide real-time Wave Financial data across the organization.
-
Use Biml to Build SSIS Tasks to Replicate Pipedrive Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Pipedrive data to SQL Server.
-
Create Dynamic Presto Grids Using the Infragistics XamDataGrid
Learn how you can connect Presto to Infragistics XamDataGrid to build dynamic grids.
-
Getting Started with the CData Connect AI Python SDK for HubDB
Install the CData Connect AI Python SDK to read and write live HubDB data with standard DB-API 2.0 Python code.
-
Connect to Google Cloud Storage Data in NetBeans
Connect to Google Cloud Storage data in NetBeans with the data source configuration wizard.
-
Integrate Real-Time Access to BigQuery in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to BigQuery data in real time.
-
Link AdRoll with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate AdRoll data in Filemaker Pro for Mac or Windows.
-
Connecting Mastra with Typeform Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Typeform data, no replication required.
-
Automated Continuous ServiceNow Replication to Oracle
Use CData Sync for automated, continuous, customizable ServiceNow replication to Oracle.
-
Connect to Bitly Data in CloverDX (formerly CloverETL)
Transfer Bitly data using the visual workflow in the CloverDX data integration tool.
-
Connect to Coinbase Data in RapidMiner
Integrate Coinbase data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to connect to Oracle SCM Data from Spring Boot
Connect to Oracle SCM in a Spring Boot Application using the CData JDBC Driver for Oracle SCM
-
Automated Continuous Wistia Replication to Databricks
Use CData Sync for automated, continuous, customizable Wistia replication to Databricks.
-
Connect to Sage Cloud Accounting Data in Aqua Data Studio
Access Sage Cloud Accounting data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Use CData Connect AI to Access Pipedrive Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Pipedrive data in the Power Pivot business intelligence tool.
-
Connect to Cloudant Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Cloudant.
-
Build Google Directory-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Google Directory Data from Zoho Analytics and import live Google Directory data.
-
Automated Continuous Impala Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Impala replication to delimited files (CSV/TSV).
-
Query Unbounce Data in ColdFusion
Write standard ColdFusion data access code to connect to Unbounce data.
-
Build Charts with PDFMonkey Data in Clear Analytics
Create dynamic charts and perform analytics based on PDFMonkey data in Clear Analytics.
-
Integrate Live Printify Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Printify from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Printify data.
-
How to Connect to Live Microsoft 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 Microsoft Ads data through natural language.
-
Configure the CData JDBC Driver for Databricks in a Connection Pool in Tomcat
Connect to Databricks data from a connection pool in Tomcat.
-
Access HubDB 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 HubDB data.
-
Integrate OpenCode with Live Twitter Ads Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Twitter Ads data from within your AI coding agent.
-
A PostgreSQL Interface for Mixpanel Data (MySQL Remoting via JDBC)
Use the Remoting features of the Mixpanel JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Microsoft Planner Data in TIBCO Spotfire through OData
Integrate Microsoft Planner data into dashboards in TIBCO Spotfire.
-
How to connect to SAP HANA XS Advanced Data from Spring Boot
Connect to SAP HANA XS Advanced in a Spring Boot Application using the CData JDBC Driver for SAP HANA XS Advanced
-
Connect to Onfleet Data from PowerBuilder via ADO.NET
This article demonstrates how to access Onfleet data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Integrating Kiro with Lakebase 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 the CData Software ODBC Driver for Box in MicroStrategy Web
Connect to Box data in MicroStrategy Web using the CData Software ODBC Driver for Box.
-
How to connect Amazon QuickSight to Spark Data
Create a connection to Spark data in CData Connect AI and insert Spark data into Amazon QuickSight SPICE to build interactive dashboards.
-
ETL Shippo in Oracle Data Integrator
This article shows how to transfer Shippo data into a data warehouse using Oracle Data Integrator.
-
Validate Google Sheets Data with QuerySurge
Access and validate Google Sheets data in QuerySurge using the CData JDBC Driver.
-
Connect to Okta Data from AWS Glue
Use CData Connect AI to gain access to live Okta data from your AWS Glue jobs.
-
Create SSAS Tabular Models from Supabase Data
How to build a SQL Server Analysis Service Tabular Model from Supabase data using CData drivers.
-
Getting Started with the CData Power BI Connector for Vercel
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Integrating Dataiku with SAP BusinessObjects BI Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SAP BusinessObjects BI data.
-
SAP Netweaver Gateway Reporting in OBIEE with the SAP Netweaver Gateway JDBC Driver
Deploy the SAP Netweaver Gateway JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Visualize ZohoSubscriptions Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to ZohoSubscriptions data.
-
Integrate Dify with Live MailChimp Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live MailChimp data.
-
Query Google Calendar Data as a SQL Server Database in Node.js
Execute SQL Server queries against Google Calendar data from Node.js.
-
Automate Sybase IQ Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Sybase IQ data from PowerShell? This article demonstrates how to utilize the Sybase IQ Cmdlets for tasks like connecting to Sybase IQ data, automating operations, downloading data, and more.
-
Getting Started with the CData Python Connector for SAP
Learn to install and license the CData Python Connector and configure a connection to live SAP data.
-
How to Connect to Live ADP Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your ADP data for you.
-
Object-Relational Mapping (ORM) with ADP 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 ADP data into a Java-based ORM framework, Hibernate.
-
Use the CData Software JDBC Driver for Teamwork in MicroStrategy
Connect to Teamwork data in MicroStrategy Developer using the CData Software JDBC Driver for Teamwork.
-
Build Voice Agents in ElevenLabs with access to Live Dropbox Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Dropbox data.
-
Connect and Visualize Live Okta Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Okta data into the Databricks platform and create visualization dashboards with real-time Okta data.
-
Model, Search, and Visualize Live Timely Data in ThoughtSpot
Use CData Connect AI to connect to live Timely data for modeling, searching, and visualizing.
-
Replicate AgileCRM Data to Multiple Databases via the CData Sync CLI
Replicate AgileCRM data to disparate databases with a single configuration.
-
Model, Search, and Visualize Live Cvent Data in ThoughtSpot
Use CData Connect AI to connect to live Cvent data for modeling, searching, and visualizing.
-
Work with Live LinkedIn Data in Power Query
Use CData Connect AI to connect to LinkedIn data and work with live LinkedIn data in Microsoft Power Query.
-
How to Connect to & Open NetSuite Data in Microsoft Excel
This article uses the CData ODBC driver for NetSuite to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Connect the Power BI Service to ClickTime: Complete Guide
Connect to the CData Software Power BI Connector for ClickTime from PowerBI.com to provide real-time ClickTime data across the organization.
-
Build MVC Applications with Connectivity to HCL Domino Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access HCL Domino from an ASP.NET MVC application.
-
Use Azure AI Foundry to Talk to Your Freshservice Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Freshservice data for you.
-
Automate Cassandra Data Replication to Azure Data Lake
Use CData Sync to customize and automate Cassandra data replication to Azure Data Lake.
-
Migrating data from ZohoPeople to Databricks using CData SSIS Components.
Easily push ZohoPeople data to Databricks using the CData SSIS Tasks for ZohoPeople and Databricks.
-
Integrate LinkedIn Data in Pentaho Data Integration
Build ETL pipelines based on LinkedIn data in the Pentaho Data Integration tool.
-
Use the CData Software ODBC Driver for Google Translate in SAS for Real-Time Reporting and Analytics
Connect to real-time Google Translate data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Google Translate.
-
Create Anaplan-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Anaplan Data from OutSystems and build custom enterprise apps using live Anaplan data.
-
Create Data Visualizations in Cognos BI with Mode Data
Access Mode data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Certinia Reporting in OBIEE with the Certinia JDBC Driver
Deploy the Certinia JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to connect Amazon QuickSight to Mailjet Data
Create a connection to Mailjet data in CData Connect AI and insert Mailjet data into Amazon QuickSight SPICE to build interactive dashboards.
-
Timely Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Timely facts in real time.
-
Connect to Discourse Data from a Connection Pool in Jetty
The Discourse JDBC Driver supports connection pooling: This article shows how to connect faster to Discourse data from Web apps in Jetty.
-
Automated Continuous Codat Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Codat replication to AlloyDB.
-
Automate Grafana Data Replication to Couchbase
Use CData Sync to Customize and automate Grafana data replication to Couchbase.
-
Replicate HelloSign Data to Multiple Databases via the CData Sync CLI
Replicate HelloSign data to disparate databases with a single configuration.
-
Build Charts with Nuclia Data in Clear Analytics
Create dynamic charts and perform analytics based on Nuclia data in Clear Analytics.
-
Create SAP Fieldglass-Connected Applications in Appsmith
Connect to SAP Fieldglass Data via CData Connect AI in Appsmith and create custom business applications with real-time access to SAP Fieldglass data.
-
Import Real-Time Apify Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Apify data in ColdFusion.
-
Use Databricks Agent Bricks to Talk to Your Workday Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Workday data for you.
-
Integrating Codex with Keap 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.
-
Natively Connect to Short.io Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Short.io data. Leverage the native support for ODBC in PHP.
-
How to Query Zuora Data in MySQL Workbench
Execute MySQL queries against live Zuora data from MySQL Workbench.
-
Automate SageHR Data Replication to Azure Synapse
Use CData Sync to customize and automate SageHR data replication to Azure Synapse.
-
ETL Azure Data Lake Storage in Oracle Data Integrator
This article shows how to transfer Azure Data Lake Storage data into a data warehouse using Oracle Data Integrator.
-
Model, Search, and Visualize Live Splunk Data in ThoughtSpot
Use CData Connect AI to connect to live Splunk data for modeling, searching, and visualizing.
-
Getting Started with the CData Python Connector for Toggl
Learn to install and license the CData Python Connector and configure a connection to live Toggl data.
-
Connect to Salesloft in SpagoBI
Create reports featuring live Salesloft data in SpagoBI Studio. Host Salesloft reports on SpagoBI Server.
-
Publish AfterShip-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live AfterShip data.
-
Use Biml to Build SSIS Tasks to Replicate Airtable Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Airtable data to SQL Server.
-
Use Biml to Build SSIS Tasks to Replicate Facebook Ads Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Facebook Ads data to SQL Server.
-
Create Reports with Oracle HCM Cloud Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Oracle HCM Cloud data.
-
Integrating Codex with SQL Analysis Services 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 Boomi Agentstudio with MailChimp Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to MailChimp data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Use Agno to Talk to Your Phoenix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Phoenix data for you.
-
Build an OLAP Cube in SSAS from Avalara AvaTax Data
Establish a connection to Avalara AvaTax data data from SQL Server Analysis Services, and use the Avalara AvaTax Data Provider to build OLAP cubes for use in analytics and reporting.
-
Visualize Dropbox Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Dropbox data.
-
Automated Continuous CapsuleCRM Replication to SQLite
Use CData Sync for automated, continuous, customizable CapsuleCRM replication to SQLite.
-
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.
-
Integrating Antigravity CLI with ShipEngine data via CData CLI
Connect ShipEngine data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate Live Sage 300 Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Sage 300 data from within the IDE.
-
Getting Started with the CData Connect AI Python SDK for BambooHR
Install the CData Connect AI Python SDK to read live BambooHR data with standard DB-API 2.0 Python code.