CData Software - Knowledge Base
Recent Articles
-
Use Databricks Agent Bricks to Talk to Your Google Spanner Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Google Spanner for you.
-
How to Visualize LaunchDarkly Data in Python with pandas
Use pandas and other modules to analyze and visualize live LaunchDarkly in Python.
-
Connect to Google Search Results in JRuby
Create a simple JRuby app with access to live Google Search.
-
Create Oracle Service Cloud-Connected Dashboards in Grafana
Connect to Oracle Service Cloud Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Oracle Service Cloud.
-
Use the CData Software JDBC Driver for PDFMonkey in MicroStrategy Web
Connect to PDFMonkey in MicroStrategy Web using the CData Software JDBC Driver for PDFMonkey.
-
DataBind Controls to Zoho Inventory Data in Delphi
DataBind to Zoho Inventory in Delphi with standard data access components and controls.
-
Connect to Live SendGrid Data in PostGresSQL Interface through CData Connect AI
Create a live connection to SendGrid in CData Connect AI and connect to your SendGrid from PostgreSQL.
-
Process & Analyze Brex Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Brex Data.
-
How to Query Live Microsoft Exchange Data in Claude Desktop
Connect to and query live Microsoft Exchange Data in Claude Desktop using CData MCP Server.
-
Access Live Azure Synapse Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Azure Synapse from your Excel spreadsheets.
-
Connect to PostgreSQL Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live PostgreSQL.
-
Getting Started with the CData ADO.NET Provider for Mode
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Extract, Transform, and Load Google Search Results in Informatica PowerCenter
Create a simple Workflow for Google Search in Informatica PowerCenter.
-
Visualize SageHR 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 SageHR into TIBCO Spotfire.
-
Build Zoho CRM-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Zoho CRM.
-
Integrating GitHub Copilot CLI with Act-On 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 Gumloop with Zoho Books Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Zoho Books within automated workflows.
-
Create Sybase-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Sybase Data from OutSystems and build custom enterprise apps using live Sybase.
-
Visualize EmailOctopus Data in Tableau
The CData ODBC driver for EmailOctopus enables you integrate EmailOctopus into Tableau dashboards.
-
Automated Continuous Basecamp Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Basecamp replication to IBM DB2.
-
Automate Microsoft Exchange Data Replication to Azure Data Lake
Use CData Sync to customize and automate Microsoft Exchange replication to Azure Data Lake.
-
Build Apps with Live Moosend Data Using the Low-Code Development Platform of Mendix
Connect Moosend with Mendix to build apps using the CData API Driver for JDBC.
-
Write a Simple Go Application to work with SQL Server Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Microsoft SQL Server.
-
Integrating Antigravity CLI with Mouseflow via CData CLI
Connect Mouseflow to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Create Dynamic REST Grids Using the Infragistics XamDataGrid
Learn how you can connect REST to Infragistics XamDataGrid to build dynamic grids.
-
How to Use a Microsoft Access Database to Update Stripe Data in Real Time
Update Stripe data by creating a linked table in Microsoft Access with the CData Stripe ODBC Driver.
-
Operational Reporting on Zoho Projects Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Zoho Projects.
-
How to connect PolyBase to Highrise
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Highrise CRM.
-
Write a Simple Go Application to work with MailerLite Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to MailerLite.
-
Integrate Live Marketo Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Marketo from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Marketo.
-
Query Blackbaud FE NXT Data in ColdFusion
Write standard ColdFusion data access code to connect to Blackbaud FE NXT.
-
Connect to Demio Data in RazorSQL
Connect to Demio from wizards and query Demio from the GUI in the RazorSQL database management tool.
-
Integrate Real-Time Access to Okta in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Okta in real time.
-
Connect to Spark Data in CloverDX (formerly CloverETL)
Transfer Apache Spark SQL using the visual workflow in the CloverDX data integration tool.
-
Use the CData ODBC Driver for Foursquare in Microsoft Power Query
You can use the CData Foursquare ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Foursquare into Microsoft Power Query.
-
Replicate Float Data from PowerShell
Write a quick PowerShell script to query Float. Use connectivity to the live data to replicate Float to SQL Server.
-
Connect to SAP Concur Data in Aqua Data Studio
Access SAP Concur from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrate Theia IDE with Live Basecamp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Connect to Wave Financial Data from PowerBuilder via ADO.NET
This article demonstrates how to access Wave Financial from Appeon PowerBuilder using the CData ADO.NET Provider for Wave Financial.
-
Build Box-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Box Data and create custom apps in Bubble.
-
Create a Data Access Object for Mocean Data using JDBI
A brief overview of creating a SQL Object API for Mocean in JDBI.
-
DataBind Controls to Jira Data in Delphi
DataBind to Atlassian Jira in Delphi with standard data access components and controls.
-
Connect to Suadeo Data in Ruby
Connect to Suadeo in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Visualize Live Bullhorn CRM Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Bullhorn CRM.
-
Use the CData Software ODBC Driver for ElevenLabs in MicroStrategy Desktop
Connect to ElevenLabs in MicroStrategy Desktop using the CData Software ODBC Driver for ElevenLabs.
-
Access Live QuickBooks Online Data in AWS Lambda (with IntelliJ IDEA)
Connect to live QuickBooks Online in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Access Billsby Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Billsby from HeidiSQL.
-
Build Agents in Relevance AI with Access to Live GitLab Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on GitLab within intelligent agent workflows.
-
How to create OneNote federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Microsoft OneNote in MySQL .
-
Integrating Cursor CLI with Microsoft Teams 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 Factorial Data in Pentaho Data Integration
Build ETL pipelines based on Factorial in the Pentaho Data Integration tool.
-
Connect to HubSpot Data in HULFT Integrate
Connect to HubSpot as a JDBC data source in HULFT Integrate
-
Automated Continuous Datadog Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Datadog replication to OneLake in Microsoft Fabric.
-
Integrate Live OData Services into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to OData from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live OData.
-
Automated Continuous Helpscout Replication to MySQL
Use CData Sync for automated, continuous, customizable Helpscout replication to MySQL.
-
Connect to Google Spanner Data in ACL Analytics
Connect to Google Spanner via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Google Spanner.
-
Connect to Cvent Data in DBeaver
Use the CData ODBC Driver to connect to Cvent in DBeaver.
-
Access Live Sage 300 Data in Coginiti Pro
Connect to and query live Sage 300 from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Getting Started with the CData SSIS Components for BigCommerce
Complete guide to installing, licensing, and connecting with the CData SSIS Components for BigCommerce.
-
Use the CData Software ODBC Driver for CSV in MicroStrategy Web
Connect to CSV/TSV Files in MicroStrategy Web using the CData Software ODBC Driver for CSV.
-
Import Real-Time xBase Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use xBase in ColdFusion.
-
Access Foursquare Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Foursquare from HeidiSQL.
-
Integrating GitHub Copilot CLI with Google Ad Manager 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 Dataiku with Dynamics 365 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Microsoft Dynamics 365.
-
Build Dashboards with Aha! Data in DBxtra
Create dynamic dashboards and perform analytics based on Aha! in DBxtra.
-
Query SAP HANA XS Advanced Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SAP HANA XS Advanced from Node.js.
-
Visualize Lakebase Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Lakebase.
-
View Reports on Real-Time Keap Data in Power BI Report Server
Use the CData ODBC Driver for Keap to visualize Keap in Power BI Desktop and then publish them to Power BI Report Server.
-
Explore Geographical Relationships in iContact Data with Power Map
Create data visualizations with iContact in Power Map.
-
Integrate Cursor with Live DocuSign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live DocuSign from within the editor.
-
Configure the CData JDBC Driver for JotForm in a Connection Pool in Tomcat
Connect to JotForm from a connection pool in Tomcat.
-
Integrate Suadeo with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Suadeo with External Services.
-
Work with Vercel Data in FoxPro
Load Vercel into a FoxPro database. This article includes full code and a walk-through of the process.
-
Visualize SAP Ariba Procurement Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SAP Ariba Procurement.
-
How to Work with ZohoExpense Data in ETL Validator JDBC
Connect to ZohoExpense from ETL Validator jobs using the CData Software JDBC Driver.
-
Use Grok to Talk to Your Zoho CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Zoho CRM for you.
-
Publish Salesforce CRM Analytics-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Salesforce CRM Analytics.
-
Analyze Azure Data Lake Storage Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Azure Data Lake Storage in Microsoft R Open.
-
Object-Relational Mapping (ORM) with SAP SuccessFactors LMS 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 SAP SuccessFactors LMS into a Java-based ORM framework, Hibernate.
-
Edit and Search External SQL Analysis Services Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SQL Analysis Services to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SQL Analysis Services Data objects that you can access from apps and the dashboard.
-
Seamlessly Bring Snapchat Ads Data into Retool Using CData Connect AI
Integrate Snapchat Ads data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Automated Continuous IBM Cloud Object Storage Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable IBM Cloud Object Storage replication to Google BigQuery.
-
Build SAP Ariba Procurement-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live SAP Ariba Procurement.
-
Analyze Klipfolio Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Klipfolio with the CData JDBC Driver for Klipfolio.
-
Connect to FTP Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live FTP Servers.
-
A PostgreSQL Interface for Cloudflare Data using the CData ODBC Driver
Use the SQL Gateway and Cloudflare ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect and Query Live Zuora Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Zuora into Databricks
-
Integrating Antigravity CLI with Raisers Edge NXT via CData CLI
Connect Raisers Edge NXT to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Productboard Reporting in OBIEE with the Productboard JDBC Driver
Deploy the Productboard JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Analyze Office 365 Data in Looker
Use CData Connect AI to connect to Office 365 Data from Looker and build custom apps using live Microsoft Office 365.
-
Extract, Transform, and Load Insightly Data in Informatica PowerCenter
Create a simple Workflow for Insightly in Informatica PowerCenter.
-
View Reports on Real-Time Okta Data in Power BI Report Server
Use the CData ODBC Driver for Okta to visualize Okta in Power BI Desktop and then publish them to Power BI Report Server.
-
Access Live Blackbaud FE NXT 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 Blackbaud FE NXT through MCP integration.
-
How to Work with ZeroBounce Data in AWS Glue Jobs Using JDBC
Connect to ZeroBounce from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to ClickTime Data from a Connection Pool in JBoss
Integrate ClickTime into Java servlets: Use the Management Console in JBoss to install the ClickTime JDBC Driver.
-
Integrating LangChain with NetSuite SuiteAnalytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on NetSuite SuiteAnalytics within automated workflows.
-
Getting Started with the CData Python Connector for JSON
Learn to install and license the CData Python Connector
-
Connect to and Query Pinecone Data in QlikView over ODBC
Create data visualizations with Pinecone in QlikView.
-
Back Up Amazon Athena to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Amazon Athena. In this article, we will employ an SSIS workflow to populate a database with Amazon Athena data.
-
Connect to Live FHIR Data in MicroStrategy through CData Connect AI
Create a live connection to FHIR Data in CData Connect AI and connect to your FHIR from MicroStrategy.