CData Software - Knowledge Base
Recent Articles
-
Connect to Figshare Data in Ruby
Connect to Figshare data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate Google's Vertex AI Agent with Live RSS Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live RSS feeds within intelligent workflows.
-
Integrating Cursor with Marketo 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.
-
Integrate with live JSON Services in Jitterbit
Use CData Connect AI to connect to and integrate live JSON services in Jitterbit.
-
Use Databricks Agent Bricks to Talk to Your SuiteCRM Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your SuiteCRM data for you.
-
Connect to Hubstaff Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Hubstaff.
-
Deploy the ADO.NET Provider for Procore on an SSRS Report Server
Connect to Procore data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Natively Connect to MarkLogic Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to MarkLogic data. Leverage the native support for ODBC in PHP.
-
Build Apps with Live SQL Analysis Services data in Adalo using CData Connect AI
Use CData Connect AI to integrate live SQL Analysis Services data into the Adalo platform and build custom mobile and web applications with real-time SQL Analysis Services data.
-
Use Databricks Agent Bricks to Talk to Your Paylocity Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Paylocity data for you.
-
Automated Continuous Google Ads Replication to MongoDB
Use CData Sync for automated, continuous, customizable Google Ads replication to MongoDB.
-
Natively Connect to SingleStore Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SingleStore data. Leverage the native support for ODBC in PHP.
-
How to Visualize Sage 200 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 Sage 200 data in Python.
-
Create SQL Analysis Services-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to SQL Analysis Services Data from OutSystems and build custom enterprise apps using live SQL Analysis Services data.
-
Automated Continuous Square Replication to MongoDB
Use CData Sync for automated, continuous, customizable Square replication to MongoDB.
-
Getting Started with the CData Excel Add-In for Close
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Close.
-
How to Connect to Live Microsoft OneDrive Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Microsoft OneDrive data for you.
-
Connect to xBase Data from AWS Glue
Use CData Connect AI to gain access to live xBase data from your AWS Glue jobs.
-
Connect and Query Live Hive Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Hive data into Databricks and enable direct, live querying and analysis without replication.
-
Automated Continuous Templated Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Templated replication to delimited files (CSV/TSV).
-
Automate Pinterest Data Replication to SAP HANA
Use CData Sync to customize and automate Pinterest data replication to SAP HANA.
-
Working with Printify Data in LINQPad
Execute LINQ queries to Printify data in LINQPad.
-
Integrate ZohoSubscriptions Data in the Pentaho Report Designer
Publish reports based on ZohoSubscriptions data in the Pentaho BI tool.
-
Create Informatica Mappings From/To an ODBC Data Source for Microsoft Exchange
Create an ODBC connection to Microsoft Exchange in Informatica and browse and transfer Microsoft Exchange data.
-
Build Email-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Email Data from Zoho Analytics and import live Email data.
-
How to connect PolyBase to SendGrid
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SendGrid data.
-
Connect to Copper Data in NetBeans
Connect to Copper data in NetBeans with the data source configuration wizard.
-
Visualize Live SageHR Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SageHR data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Live AgileCRM Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to AgileCRM data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Build Notion-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Notion data.
-
Back Up Azure Analysis Services data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Azure Analysis Services. In this article, we will employ an SSIS workflow to populate a database with Azure Analysis Services data data.
-
Connect to Salesforce Data 360 Data in NetBeans
Connect to Salesforce Data 360 data in NetBeans with the data source configuration wizard.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Gmail
Provide connectivity to Gmail data through an SAP BusinessObjects universe.
-
Use the CData Software JDBC Driver for JSON in MicroStrategy Web
Connect to JSON services in MicroStrategy Web using the CData Software JDBC Driver for JSON.
-
Import Outreach.io Data Using Azure Data Factory
Use CData Connect AI to connect to Outreach.io Data from Azure Data Factory and import live Outreach.io data.
-
Create Dynamic Hubstaff Grids Using the Infragistics XamDataGrid
Learn how you can connect Hubstaff to Infragistics XamDataGrid to build dynamic grids.
-
Access Oracle Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Oracle data from your Oracle system.
-
Build Semantic Layer Views for FHIR Data in APOS Live Data Gateway
Use the CData Connector for FHIR in APOS Live Data Gateway to build Semantic Layer Views for FHIR data.
-
Integrate with Wrike Data in JReport Designer
Create charts and reports based on Wrike data in JReport Designer.
-
Integrate Shortcut Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Shortcut data and integrate live Shortcut data into your Power Automate tasks.
-
Access NetSuite Data from MySQL in PHP
Connect to NetSuite through the standard MySQL libraries in PHP.
-
Object-Relational Mapping (ORM) with SendPulse 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 SendPulse data into a Java-based ORM framework, Hibernate.
-
Create Data Visualizations in Cognos BI with Everhour Data
Access Everhour data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create Apps from Mode Data in Qlik Sense Cloud
Use CData Connect AI to connect to Mode Data and build apps from live Mode data in Qlik Sense Cloud.
-
Connect to Customer.io from a Connection Pool in WebLogic
Use the CData JDBC Driver for Customer.io to connect to Customer.io data from Web applications running on WebLogic.
-
A PostgreSQL Interface for ServiceDesk Plus Data using the CData ODBC Driver
Use the SQL Gateway and ServiceDesk Plus ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Adobe Commerce Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to PostgreSQL.
-
Automated Continuous Jira Assets Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Jira Assets replication to delimited files (CSV/TSV).
-
Excel Spreadsheet Automation on SAS xpt Data with the QUERY Formula
Pull data from SAS xpt, automate spreadsheets, and more with the QUERY formula.
-
Integrate Real-Time Access to Odoo in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Odoo data in real time.
-
Getting Started with the CData Power BI Connector for Zoho Projects
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Zoho Projects.
-
Getting Started with the CData ODBC Driver for Miro
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Miro.
-
Prepare, Blend, and Analyze GetResponse Data in Alteryx Designer (ODBC)
Build workflows to access live GetResponse data for self-service data analytics.
-
Connect to Onfleet Data in DBeaver
Use the CData ODBC Driver to connect to Onfleet data in DBeaver.
-
Connect to ChartMogul Data in Jaspersoft Studio
Execute SQL to remote ChartMogul data in Jaspersoft Studio.
-
Automated Continuous Beeminder Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Beeminder replication to Apache Kafka.
-
Build Apps with Live Google Search Results Using the Low-Code Development Platform of Mendix
Connect Google Search results with Mendix to build apps using the CData JDBC Driver for Google Search.
-
Build Google Campaign Manager 360-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Google Campaign Manager 360 data and build Google Campaign Manager 360-connected web apps with Axios.
-
Import and Visualize Procore Data in Power View
Create data visualizations based on Procore data in Excel.
-
How to create an RPA flow for SharePoint Excel Services Data in UiPath Studio
Use the SharePoint Excel Services ODBC Driver to create workflows that access real-time SharePoint Excel Services data without any coding.
-
Query, Visualize, and Share live Oracle Data in Redash
Use CData Connect AI to connect to live Oracle data in Redash for querying, visualizing, and sharing.
-
Create a Data Access Object for Salesforce Pardot Data using JDBI
A brief overview of creating a SQL Object API for Salesforce Pardot data in JDBI.
-
How to Work with Workday Data in ETL Validator JDBC
Connect to Workday from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate with Live Active Directory Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Active Directory from the MuleSoft Anypoint Platform to integrate live Active Directory data into custom reports and dashboards.
-
Establish a Live Connection with Rootly Data using Tableau Bridge
The CData ODBC Driver for Rootly enables you to integrate live Rootly data into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Dashboards with Telegram Data in DBxtra
Create dynamic dashboards and perform analytics based on Telegram data in DBxtra.
-
Trigger Smartsheet IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Smartsheet with standard wizards in Logic Apps.
-
Integrate PingOne Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live PingOne data from Informatica Cloud.
-
Build eBay-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to eBay data and build web apps with connectivity to live eBay data.
-
Getting Started with the CData ADO.NET Provider for Google Ad Manager
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Google Ad Manager.
-
Use Databricks Agent Bricks to Talk to Your OneNote Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your OneNote data for you.
-
Automate Coinbase Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Coinbase data from PowerShell? This article demonstrates how to utilize the Coinbase Cmdlets for tasks like connecting to Coinbase data, automating operations, downloading data, and more.
-
Connecting Moonlit Workflow with Coda 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 Coda data in real time.
-
How to Access Printify Data Using Entity Framework
This article shows how to access Printify data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous Email Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Email replication to AlloyDB.
-
Import and Visualize Rebilly Data in Power View
Create data visualizations based on Rebilly data in Excel.
-
Interact with Live Oracle Eloqua Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Oracle Eloqua data.
-
Access Avalara AvaTax Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Avalara AvaTax data from HeidiSQL.
-
How to connect SharePoint with MariaDB Data through external lists
Provide MariaDB data to SharePoint users as an external list.
-
Use the CData Software JDBC Driver for MessageBird in MicroStrategy Desktop
Connect to MessageBird data in MicroStrategy Desktop using the CData Software JDBC Driver for MessageBird.
-
How to Build an ETL App for AgileCRM Data in Python with CData
Create ETL applications and real-time data pipelines for AgileCRM data in Python with petl.
-
Connect to SAP Fieldglass Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to SAP Fieldglass.
-
Integrate Cursor with Live Oracle Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Oracle data from within the editor.
-
Working with Sentry Data in LINQPad
Execute LINQ queries to Sentry data in LINQPad.
-
Interact with Live Zoho CRM Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Zoho CRM data.
-
Use Claude to Talk to Your Quickbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Quickbase data for you.
-
How to Connect the Power BI Service to Optimizely: Complete Guide
Connect to the CData Software Power BI Connector for Optimizely from PowerBI.com to provide real-time Optimizely data across the organization.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Google Spanner
Provide connectivity to Google Spanner data through an SAP BusinessObjects universe.
-
Build Semantic Layer Views for Dotmailer Data in APOS Live Data Gateway
Use the CData Connector for Dotmailer in APOS Live Data Gateway to build Semantic Layer Views for Dotmailer data.
-
Integrating GitHub Copilot with SAS Data Sets 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.
-
Automated Continuous Pinecone Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Pinecone replication to Google Cloud SQL.
-
How to work with Workday Data in Apache Spark using SQL
Access and process Workday Data in Apache Spark using the CData Software JDBC Driver.
-
Automated Continuous DB2 for i Replication to Databricks
Use CData Sync for automated, continuous, customizable DB2 for i replication to Databricks.
-
Connect to SurveyMonkey Data from PowerBuilder via ADO.NET
This article demonstrates how to access SurveyMonkey data from Appeon PowerBuilder using the CData ADO.NET Provider for SurveyMonkey.
-
Replicate Adobe Target Data to Multiple Databases
Replicate Adobe Target data to disparate databases with a point-and-click configuration.
-
Automated Continuous Microsoft Entra ID Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Microsoft Entra ID replication to Azure SQL Database.
-
Automated Continuous Tavily Replication to SingleStore
Use CData Sync for automated, continuous, customizable Tavily replication to SingleStore.
-
Connecting Pipedream with Yelp Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Yelp data in real time.
-
Automate Coda Data Replication to Azure Synapse
Use CData Sync to customize and automate Coda data replication to Azure Synapse.
-
Replicate SAP Netweaver Gateway Data to Multiple Databases
Replicate SAP Netweaver Gateway data to disparate databases with a point-and-click configuration.