CData Software - Knowledge Base
Recent Articles
-
Query Webex Data as a MySQL Database in Node.js
Execute MySQL queries against Webex data from Node.js.
-
Integrate Elasticsearch Data in Pentaho Data Integration
Build ETL pipelines based on Elasticsearch data 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 data from PowerShell? This article demonstrates how to utilize the Splunk Cmdlets for tasks like connecting to Splunk data, automating operations, downloading data, and more.
-
How to Connect DBeaver to Zoho Books via a JDBC Driver
Manage Zoho Books data 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 data.
-
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 data 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 data to a chart.
-
Create Salesforce Data 360-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Salesforce Data 360 Data from Klipfolio and build custom visualizations using live Salesforce Data 360 data.
-
Connect to Microsoft Entra ID Data in Jaspersoft Studio
Execute SQL to remote Microsoft Entra ID data 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 data. 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 data.
-
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 data, 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 data from Node.js.
-
Build Dashboards with Lakebase Data in DBxtra
Create dynamic dashboards and perform analytics based on Lakebase data in DBxtra.
-
Create Dynamics NAV-Connected Applications in Appsmith
Connect to Dynamics NAV Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Dynamics NAV data.
-
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 Excel Online data 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 data into Microsoft Power Query.
-
Integrate with Outreach.io Data in JReport Designer
Create charts and reports based on Outreach.io data 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's built-in AI agents to securely access and query live Oracle Eloqua data from within the development environment.
-
Replicate ScrapingBee Data to Multiple Databases
Replicate ScrapingBee data to disparate databases with a point-and-click configuration.
-
Use the CData Software JDBC Driver for Cvent in MicroStrategy Web
Connect to Cvent data in MicroStrategy Web using the CData Software JDBC Driver for Cvent.
-
Access Live CircleCI Data in AWS Lambda
Connect to live CircleCI data 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 Avro data 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 data into Tableau dashboards.
-
Connect to Jodoo from a Connection Pool in WebLogic
Use the CData JDBC Driver for Jodoo to connect to Jodoo data 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 data 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 Dynamics CRM data for you.
-
Connect to Simplesat Data from a Connection Pool in JBoss
Integrate Simplesat data 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 data 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 data 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 data.
-
Connect to ADP Data in JRuby
Create a simple JRuby app with access to live ADP data.
-
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 Access data 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 data.
-
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 data 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 data.
-
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 data 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 Vault CRM data 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 data from HeidiSQL.
-
Use Claude to Talk to Your ZohoPeople 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 ZohoPeople data for you.
-
Build Data Flows from PhantomBuster to SQL Server using SSIS
Easily back up PhantomBuster data 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 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 data in Jitterbit.
-
Query Live Mailgun Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Mailgun data through a conversational interface.
-
Integrate Zoho Projects Data in Pentaho Data Integration
Build ETL pipelines based on Zoho Projects data 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 data in Power Apps.
-
How to connect to Typeform Data from IntelliJ
Integrate connectivity to Typeform data 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 data into Tableau dashboards.
-
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 data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SQL Analysis Services data 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 data.
-
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 data into TIBCO Spotfire.
-
Connect to Amazon Marketplace in SpagoBI
Create reports featuring live Amazon Marketplace data 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 data 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 data and visualize live Couchbase data in Infragistics Reveal.
-
Build Automated Oracle Eloqua-Connected Workflows in Zapier
Use CData Connect AI to connect to live Oracle Eloqua data and build automated workflows in Zapier.
-
Integrate with SuiteCRM Data in SnapLogic
Use CData Connect AI to connect to and integrate with live SuiteCRM data in SnapLogic.
-
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 data 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 data 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 data 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 data.
-
Load MessageBird Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load MessageBird data to a database.
-
Create Data Visualizations in Cognos BI with Testmonitor Data
Access Testmonitor data 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 data in SpagoBI Studio. Host Keap reports on SpagoBI Server.
-
Interact with Live PostgreSQL Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live PostgreSQL data.
-
How to connect to Pingdom Data with Squirrel SQL client
Connect to Pingdom data and execute queries in the Squirrel SQL Client.
-
How to Build an ETL App for GetResponse Data in Python with CData Connect AI
Extract and transform live GetResponse data in Python with petl and the CData Connect AI Python SDK.
-
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 data within intelligent agent workflows.
-
Connect to ZohoPeople Data in DBArtisan
Use wizards in DBArtisan to configure ZohoPeople data as a data source.
-
Replicate Guru Data to Multiple Databases
Replicate Guru data to disparate databases with a point-and-click configuration.
-
Integrate Live Freshteam Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Freshteam data 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 data.
-
Use the CData Software JDBC Driver for Dotmailer in MicroStrategy Desktop
Connect to Dotmailer data 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 Jira data from MicroStrategy.
-
Build a Simple VCL Application for Pinecone Data
How to build a simple VCL Application to view Pinecone data 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 data 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 data 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 HBase data.
-
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 data in your FileMaker application.
-
Use the CData Software JDBC Driver for ServiceDesk Plus in MicroStrategy
Connect to ServiceDesk Plus data 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 Impala 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.
-
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 data. Leverage the pyodbc module for ODBC in Python.
-
Connect to Spark Data in RazorSQL
Connect to Spark from wizards and query Spark data 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 data 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 Confluence data directly from the development environment.
-
Replicate Attio Data from PowerShell
Write a quick PowerShell script to query Attio data. Use connectivity to the live data to replicate Attio data 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 data.
-
Validate Google Calendar Data with QuerySurge
Access and validate Google Calendar data in QuerySurge using the CData JDBC Driver.
-
Integrating Codex with AgileCRM 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.
-
How to Visualize Deel Data in Python with pandas
Use pandas and other modules to analyze and visualize live Deel data in Python.
-
Create Google Campaign Manager 360-Connected Business Apps in AppSheet
Connect to Google Campaign Manager 360 Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Google Campaign Manager 360 data.