CData Software - Knowledge Base
Recent Articles
-
Seamlessly Bring Snowflake Data into Retool Using CData Connect AI
Integrate Snowflake data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect to Sugar CRM Data from a Connection Pool in Jetty
The Sugar CRM JDBC Driver supports connection pooling: This article shows how to connect faster to Sugar CRM from Web apps in Jetty.
-
Query AlloyDB Data in DataGrip
Create a Data Source for AlloyDB in DataGrip and use SQL to query live Google AlloyDB.
-
Use the CData ODBC Driver for Freshdesk in Microsoft Power Query
You can use the CData Freshdesk ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Freshdesk into Microsoft Power Query.
-
How to Query Live SAP Hybris C4C Data in Claude Desktop
Connect to and query live SAP Hybris C4C Data in Claude Desktop using CData MCP Server.
-
Query Webex Data as a MySQL Database in Node.js
Execute MySQL queries against Webex from Node.js.
-
Integrate Elasticsearch Data in Pentaho Data Integration
Build ETL pipelines based on Elasticsearch in the Pentaho Data Integration tool.
-
Automate Splunk Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Splunk from PowerShell? This article demonstrates how to utilize the Splunk Cmdlets for tasks like connecting to Splunk, automating operations, downloading data, and more.
-
How to Connect DBeaver to Zoho Books via a JDBC Driver
Manage Zoho Books with visual tools in DBeaver like the query browser.
-
Connect to Exa from Asprova with CData Software ODBC Driver for Exa
This article shows how to connect faster to Exa data from Asprova.
-
Publish Crystal Reports on Highrise Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Highrise CRM.
-
Process & Analyze MailerSend Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live MailerSend Data.
-
How to create Google Translate federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Google Translate in MySQL .
-
DataBind Chargebee Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Chargebee to a chart.
-
Connect to Microsoft Entra ID Data in Jaspersoft Studio
Execute SQL to remote Microsoft Entra ID in Jaspersoft Studio.
-
How to Connect to Stripe Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Stripe. Leverage the pyodbc module for ODBC in Python.
-
Build Freshservice-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Freshservice.
-
Integrating Boomi Agentstudio with Outreach.io Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Outreach.io, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Query Salesforce Marketing Data as a SQL Server Database in Node.js
Execute SQL Server queries against Salesforce Marketing Cloud from Node.js.
-
Build Dashboards with Lakebase Data in DBxtra
Create dynamic dashboards and perform analytics based on Lakebase in DBxtra.
-
Use ChatGPT to Talk to Your Excel Online 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 Microsoft Excel Online for you.
-
Use the CData ODBC Driver for Dropbox in Microsoft Power Query
You can use the CData Dropbox ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Dropbox into Microsoft Power Query.
-
Integrate with Outreach.io Data in JReport Designer
Create charts and reports based on Outreach.io in JReport Designer.
-
Integrate Theia IDE with Live Oracle Eloqua Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Use the CData Software JDBC Driver for Cvent in MicroStrategy Web
Connect to Cvent in MicroStrategy Web using the CData Software JDBC Driver for Cvent.
-
Access Live CircleCI Data in AWS Lambda
Connect to live CircleCI in AWS Lambda using the CData JDBC Driver.
-
Connect to Avro Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Apache Avro from Filemaker Pro on Mac.
-
How to publish and share OnePageCrm Data dashboards with Tableau Server
The CData ODBC driver for OnePageCrm enables you integrate OnePageCrm into Tableau dashboards.
-
Connect to Jodoo from a Connection Pool in WebLogic
Use the CData JDBC Driver for Jodoo to connect to Jodoo from Web applications running on WebLogic.
-
Connect to Airtable Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Airtable from Filemaker Pro on Mac.
-
How to Connect to Live Dynamics CRM Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Microsoft Dynamics CRM for you.
-
Connect to Simplesat Data from a Connection Pool in JBoss
Integrate Simplesat into Java servlets: Use the Management Console in JBoss to install the Simplesat JDBC Driver.
-
Access Slack Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Slack from your Oracle system.
-
Integrating LangChain with Exact Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Exact Online within automated workflows.
-
Add Microsoft Planner Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Microsoft Planner with the Informatica Enterprise Data Catalog to classify and organize data.
-
Create Zendesk-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Zendesk Data from OutSystems and build custom enterprise apps using live Zendesk.
-
Connect to ADP Data in JRuby
Create a simple JRuby app with access to live ADP.
-
Getting Started with the CData ODBC Driver for GitLab
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for GitLab.
-
How to Access Live Access Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Access enables you to integrate Microsoft Access into workflows built using Microsoft Power Automate Desktop.
-
Connect to Bannerbear Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Bannerbear.
-
How to connect to Zuora Data from Spring Boot
Connect to Zuora in a Spring Boot Application using the CData JDBC Driver for Zuora
-
Connect to Aircall Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Aircall and work with Aircall in your FileMaker applications.
-
Create Zoho Projects-Connected Nintex Workflows
Use CData Connect AI to connect to Zoho Projects Data from Nintex Workflow Cloud and build custom workflows using live Zoho Projects.
-
Integrate with Live Zoom Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Zoom from the MuleSoft Anypoint Platform to integrate live Zoom into custom reports and dashboards.
-
Provide OData Services of Vault CRM Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Veeva Vault & Vault CRM by developing a WCF Service Application.
-
Access Samanage Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Samanage from HeidiSQL.
-
How to Query Live HubDB Data in Claude Desktop
Connect to and query live HubDB Data in Claude Desktop using CData MCP Server.
-
Build Data Flows from PhantomBuster to SQL Server using SSIS
Easily back up PhantomBuster to SQL Server using the SSIS components for PhantomBuster.
-
Natively Connect to Bright Data Data in PHP
The CData ODBC driver for Bright Data enables you to create PHP applications with connectivity to Bright Data. Leverage the native support for ODBC in PHP.
-
Integrate with live Google Ad Manager Data in Jitterbit
Use CData Connect AI to connect to and integrate live Google Ad Manager in Jitterbit.
-
Query PivotalTracker Data as a MySQL Database in Node.js
Execute MySQL queries against PivotalTracker from Node.js.
-
Integrate Zoho Projects Data in Pentaho Data Integration
Build ETL pipelines based on Zoho Projects in the Pentaho Data Integration tool.
-
Connect to Real-Time AfterShip Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use AfterShip in Power Apps.
-
Extend Google Sheets with Jira Assets Data
Make calls to Jira Assets from Google Apps Script via the API Server.
-
How to connect to Typeform Data from IntelliJ
Integrate connectivity to Typeform with wizards in IntelliJ.
-
How to publish and share Adobe Analytics Data dashboards with Tableau Server
The CData ODBC driver for Adobe Analytics enables you integrate Adobe Analytics into Tableau dashboards.
-
Edit and Search Raisers Edge NXT External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Raisers Edge NXT to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Raisers Edge NXT objects that you can access from apps and the dashboard.
-
Use the CData ODBC Driver for SQL Analysis Services from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SQL Analysis Services to connect to SQL Analysis Services from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SQL Analysis Services in Excel.
-
Create Reports with Attio Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Attio.
-
Automated Continuous AfterShip Replication to Databricks
Use CData Sync for automated, continuous, customizable AfterShip replication to Databricks.
-
Visualize Act-On 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 Act-On into TIBCO Spotfire.
-
Connect to Amazon Marketplace in SpagoBI
Create reports featuring live Amazon Marketplace in SpagoBI Studio. Host Amazon Marketplace reports on SpagoBI Server.
-
Choosing the Best Method to Connect Missive to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Missive from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Analyze Couchbase Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Couchbase and visualize live Couchbase in Infragistics Reveal.
-
Build Automated Oracle Eloqua-Connected Workflows in Zapier
Use CData Connect AI to connect to live Oracle Eloqua and build automated workflows in Zapier.
-
How to Connect to Live Google Campaign Manager 360 Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Google Campaign Manager 360 for you.
-
How to Connect the Power BI Service to SurveyMonkey: Complete Guide
Connect to the CData Software Power BI Connector for SurveyMonkey from PowerBI.com to provide real-time SurveyMonkey across the organization.
-
Object-Relational Mapping (ORM) with Cvent 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 Cvent into a Java-based ORM framework, Hibernate.
-
Build Oracle-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Oracle Database.
-
Build SAP Netweaver Gateway-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for SAP Netweaver Gateway to explore live SAP Netweaver Gateway Data in Gemini Code Assist to assist with building SAP Netweaver Gateway-powered applications.
-
Load MessageBird Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load MessageBird to a database.
-
Create Data Visualizations in Cognos BI with Testmonitor Data
Access Testmonitor as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Keap in SpagoBI
Create reports featuring live Keap in SpagoBI Studio. Host Keap reports on SpagoBI Server.
-
How to connect to Pingdom Data with Squirrel SQL client
Connect to Pingdom and execute queries in the Squirrel SQL Client.
-
Build Agents in Relevance AI with Access to Live ServiceNow Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on ServiceNow within intelligent agent workflows.
-
Connect to ZohoPeople Data in DBArtisan
Use wizards in DBArtisan to configure ZohoPeople as a data source.
-
Integrate Live Freshteam Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Freshteam to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Query SAP Business One Data in DataGrip
Create a Data Source for SAP Business One in DataGrip and use SQL to query live SAP Business One.
-
Use the CData Software JDBC Driver for Dotmailer in MicroStrategy Desktop
Connect to Dotmailer in MicroStrategy Desktop using the CData Software JDBC Driver for Dotmailer.
-
Connect to Live Jira Data in MicroStrategy through CData Connect AI
Create a live connection to Jira Data in CData Connect AI and connect to your Atlassian Jira from MicroStrategy.
-
Build a Simple VCL Application for Pinecone Data
How to build a simple VCL Application to view Pinecone in RAD Studio using the CData ODBC Driver for Pinecone.
-
How to connect to Elasticsearch Data from Spring Boot
Connect to Elasticsearch in a Spring Boot Application using the CData JDBC Driver for Elasticsearch
-
Connect to Kintone Data in Ruby
Connect to Kintone in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automate SurveyMonkey Data Replication to Azure Synapse
Use CData Sync to customize and automate SurveyMonkey replication to Azure Synapse.
-
Create Data Visualizations Based On HBase Data in Mode
Use CData Connect AI to connect to HBase Data from Mode and build visualizations using live
-
Connect to Instagram Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Instagram and the Script function in FileMaker Pro to connect to Instagram and work with Instagram in your FileMaker application.
-
Use the CData Software JDBC Driver for ServiceDesk Plus in MicroStrategy
Connect to ServiceDesk Plus in MicroStrategy Developer using the CData Software JDBC Driver for ServiceDesk Plus.
-
Deploy the ADO.NET Provider for Impala on an SSRS Report Server
Connect to Apache Impala 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.
-
How to Connect to SAS Data Sets Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SAS Data Sets. Leverage the pyodbc module for ODBC in Python.
-
Connect to Spark Data in RazorSQL
Connect to Spark from wizards and query Apache Spark SQL from the GUI in the RazorSQL database management tool.
-
Prepare, Blend, and Analyze Reply.io Data in Alteryx Designer (ODBC)
Build workflows to access live Reply.io for self-service data analytics.
-
Automated Continuous Drip Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Drip replication to PostgreSQL.
-
Automated Continuous Accelo Replication to Databricks
Use CData Sync for automated, continuous, customizable Accelo replication to Databricks.
-
Query Live Confluence 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 Atlassian Confluence directly from the development environment.
-
Replicate Attio Data from PowerShell
Write a quick PowerShell script to query Attio. Use connectivity to the live data to replicate Attio to SQL Server.
-
Automated Continuous Zoom Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Zoom replication to PostgreSQL.
-
Create SAP Netweaver Gateway-Connected Applications in Appsmith
Connect to SAP Netweaver Gateway Data via CData Connect AI in Appsmith and create custom business applications with real-time access to SAP Netweaver Gateway.
-
Validate Google Calendar Data with QuerySurge
Access and validate Google Calendar in QuerySurge using the CData JDBC Driver.
-
Integrating Codex CLI with AgileCRM 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 Visualize Deel Data in Python with pandas
Use pandas and other modules to analyze and visualize live Deel in Python.