CData Software - Knowledge Base
Recent Articles
-
Automate JobNimbus Integration Tasks from PowerShell
Are you in search of a quick and easy way to access JobNimbus from PowerShell? This article demonstrates how to utilize the JobNimbus Cmdlets for tasks like connecting to JobNimbus, automating operations, downloading data, and more.
-
Connect to Live Oracle SCM Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Oracle SCM in CData Connect AI and connect to your Oracle SCM from PostgreSQL.
-
Connect to Google Contacts Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Google Contacts to connect to Google Contacts and execute queries in PowerBuilder.
-
Use Biml to Build SSIS Tasks to Replicate Customer.io Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Customer.io to SQL Server.
-
Automate Demio Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Demio from PowerShell? This article demonstrates how to utilize the Demio Cmdlets for tasks like connecting to Demio, automating operations, downloading data, and more.
-
Getting Started with the CData JDBC Driver for ChargeOver
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for ChargeOver.
-
Build Semantic Layer Views for ZohoMarketingHub Data in APOS Live Data Gateway
Use the CData Connector for ZohoMarketingHub in APOS Live Data Gateway to build Semantic Layer Views for ZohoMarketingHub.
-
Connect to Clari Data in RapidMiner
Integrate Clari with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrating Codex CLI with Intercom 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.
-
Bridge Stack Exchange Connectivity with Apache NiFi
Access and process Stack Exchange in Apache NiFi using the CData JDBC Driver.
-
Connect to Supabase Data from a Connection Pool in JBoss
Integrate Supabase into Java servlets: Use the Management Console in JBoss to install the Supabase JDBC Driver.
-
Integrating Claude Code CLI with Calendly 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.
-
Automate Sage 300 Data Replication to Couchbase
Use CData Sync to Customize and automate Sage 300 replication to Couchbase.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Oracle Eloqua
Provide connectivity to Oracle Eloqua through an SAP BusinessObjects universe.
-
Configure the CData JDBC Driver for Office 365 in a Connection Pool in Tomcat
Connect to Microsoft Office 365 from a connection pool in Tomcat.
-
Rapidly Develop Google Cloud Storage-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Google Cloud Storage.
-
Integrating Cursor CLI with Zuora 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 Stripe Replication to Vertica
Use CData Sync for automated, continuous, customizable Stripe replication to Vertica.
-
Use CData Connect AI to Access Oracle Sales Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Oracle Sales in the Power Pivot business intelligence tool.
-
How to Connect DBeaver to Telegram via a JDBC Driver
Manage Telegram with visual tools in DBeaver like the query browser.
-
Automated Continuous CapsuleCRM Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable CapsuleCRM replication to OneLake in Microsoft Fabric.
-
Create Certinia-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Certinia Data from OutSystems and build custom enterprise apps using live Certinia.
-
Analyze GraphQL Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for GraphQL from Power Pivot. You will use the Table Import Wizard to load GraphQL. You can visually build the import query or use any SQL supported by the driver.
-
Excel Spreadsheet Automation on ConvertAPI Data with the QUERY Formula
Pull data from ConvertAPI, automate spreadsheets, and more with the QUERY formula.
-
Build Visualizations of Perplexity Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Perplexity in Birst.
-
How to import Browserless Data into Apache Solr
Use the CData Software JDBC Driver for Browserless in Data Import Handler and create an automated import of Browserless to Apache Solr Enterprise Search platform.
-
Migrating data from Procore to Databricks using CData SSIS Components.
Easily push Procore to Databricks using the CData SSIS Tasks for Procore and Databricks.
-
Getting Started with the CData Tableau Connector for Perplexity
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Write a Simple Go Application to work with HelloSign Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to HelloSign.
-
How to Create Power BI Visual Reports with Real-Time Coda Data
Use CData Power BI Connectors to visualize Coda in Power BI.
-
Create Greenhouse Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Greenhouse from PowerBI.com to create Power BI Dataflows with real-time data.
-
Using the CData Software ODBC Driver for Short.io in PyCharm
Connect to Short.io as an ODBC data source in PyCharm using the CData Software ODBC Driver for Short.io.
-
Integrate LibreChat with Live JSON Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live JSON from within the chat interface.
-
Integrate ADP with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate ADP with External Services.
-
Connect to Salesloft Data in JRuby
Create a simple JRuby app with access to live Salesloft.
-
Bidirectional Access to SAP Ariba Source Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SAP Ariba Source in Filemaker Pro for Mac or Windows.
-
Query Live Tally 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 Tally ERP directly from the development environment.
-
Query Greenplum Data in DataGrip
Create a Data Source for Greenplum in DataGrip and use SQL to query live Pivotal GreenPlum.
-
Import Real-Time Nuclia Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Nuclia in ColdFusion.
-
Automated Continuous Quaderno Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Quaderno replication to Apache Kafka.
-
Automate Quaderno Data Replication to SAP HANA
Use CData Sync to customize and automate Quaderno replication to SAP HANA.
-
How to Work with CSV Data in AWS Glue Jobs Using JDBC
Connect to CSV from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use Grok to Talk to Your Greenplum 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 Pivotal GreenPlum for you.
-
Integrate Zoho Books Data into Power Automate Desktop using CData Connect
CData Connect for Zoho Books Data enables you to integrate Zoho Books into workflows built using Microsoft Power Automate Desktop.
-
Process & Analyze Lakebase Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Lakebase Data.
-
Getting Started with the CData ADO.NET Provider for LionDesk
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Using the CData Software ODBC Driver for Rootly in PyCharm
Connect to Rootly as an ODBC data source in PyCharm using the CData Software ODBC Driver for Rootly.
-
Connect to GitLab Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live GitLab.
-
Integrating Antigravity CLI with Printify via CData CLI
Connect Printify to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrating Codex CLI with Adobe Analytics 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 create an RPA flow for Shortcut Data in UiPath Studio
Use the Shortcut ODBC Driver to create workflows that access real-time Shortcut without any coding.
-
Automated Continuous Salesforce CRM Analytics Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Salesforce CRM Analytics replication to OneLake in Microsoft Fabric.
-
Build Adobe Experience Manager-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Adobe Experience Manager to explore live Adobe Experience Manager Data in Cursor to assist with building Adobe Experience Manager-powered applications.
-
View Reports on Real-Time Jira Assets Data in Power BI Report Server
Use the CData ODBC Driver for Jira Assets to visualize Jira Assets in Power BI Desktop and then publish them to Power BI Report Server.
-
Provide OData Services of Adobe Experience Manager Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Adobe Experience Manager by developing a WCF Service Application.
-
Build MVC Applications with Connectivity to JobNimbus Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access JobNimbus from an ASP.NET MVC application.
-
Build an OLAP Cube in SSAS from Mixpanel Data
Establish a connection to Mixpanel data from SQL Server Analysis Services, and use the Mixpanel Data Provider to build OLAP cubes for use in analytics and reporting.
-
Query Azure DevOps Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Azure DevOps and perform CRUD operations on Azure DevOps from Node.js.
-
Integrate Open WebUI with Live Google Cloud Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Google Cloud Storage from within the chat interface.
-
Create Datasets from Qualaroo in Domo Workbench and Build Visualizations of Qualaroo Data in Domo
Use the CData Software ODBC Driver for Qualaroo to create datasets from Qualaroo in Domo Workbench and then build visualizations in the Domo service.
-
Build Data Flows from SQL Server to Azure Synapse through SSIS
Easily push SQL Server data to Azure Synapse using the CData SSIS Tasks for Azure Synapse.
-
Replicate Codat Data to Multiple Databases via the CData Sync CLI
Replicate Codat to disparate databases with a single configuration.
-
Automated Continuous SAP BusinessObjects BI Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to Amazon S3.
-
View Reports on Real-Time Google Contacts Data in Power BI Report Server
Use the CData ODBC Driver for Google Contacts to visualize Google Contacts in Power BI Desktop and then publish them to Power BI Report Server.
-
Replicate Google Ads Data in Heroku for Use in Salesforce Connect
Replicate Google Ads to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Moving Data from MessageBird to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live MessageBird data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Load Cloudflare Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Cloudflare to a database.
-
Build Quickbase-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Quickbase to explore live Quickbase Data in Claude Code to assist with building Quickbase-powered applications.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Clockify
Provide connectivity to Clockify through an SAP BusinessObjects universe.
-
How to Access Live Zendesk Data in Visual Studio Code via Cline
Run CData MCP Server for Zendesk on Windows Subsytem for Linux (WSL) and connect to live Zendesk from the Cline extension in Visual Studio Code.
-
How to Connect to Live Tally 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 Tally ERP through natural language.
-
Query SuiteCRM Data in ColdFusion
Write standard ColdFusion data access code to connect to SuiteCRM.
-
Build PayPal-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for PayPal Data and create custom apps in Bubble.
-
Connect ServiceDesk Plus Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your ServiceDesk Plus using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Getting Started with the CData SSIS Components for Figshare
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Figshare.
-
Use Biml to Build SSIS Tasks to Replicate Egnyte Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Egnyte to SQL Server.
-
Connect to Humanity Data in JRuby
Create a simple JRuby app with access to live Humanity.
-
Build Data Flows from Humanity to SQL Server using SSIS
Easily back up Humanity to SQL Server using the SSIS components for Humanity.
-
Use JayDeBeApi to access SendInBlue Data in Python
Use standard Python scripting and the development environment of your choice to access live SendInBlue.
-
Viewing Figshare Data in RAD Studio Data Explorer
How to view Figshare in RAD Studio Data Explorer using the CData ODBC Driver for Figshare.
-
Use the CData ODBC Driver for Asana from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Asana to connect to Asana from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Asana in Excel.
-
Visualize SAP Business Warehouse 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 SAP Business Warehouse into TIBCO Spotfire.
-
Automated Continuous Act-On Replication to Oracle
Use CData Sync for automated, continuous, customizable Act-On replication to Oracle.
-
Integrate SAP Fieldglass Data into Power Automate Desktop using CData Connect
CData Connect for SAP Fieldglass Data enables you to integrate SAP Fieldglass into workflows built using Microsoft Power Automate Desktop.
-
Migrating data from Teamwork to Databricks using CData SSIS Components.
Easily push Teamwork to Databricks using the CData SSIS Tasks for Teamwork and Databricks.
-
Validate SurveyMonkey Data with QuerySurge
Access and validate SurveyMonkey in QuerySurge using the CData JDBC Driver.
-
Bridge ZarMoney Connectivity with Apache NiFi
Access and process ZarMoney in Apache NiFi using the CData JDBC Driver.
-
Use Biml to Build SSIS Tasks to Replicate Printful Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Printful to SQL Server.
-
How to Access Live Zoho CRM Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Zoho CRM enables you to integrate Zoho CRM into workflows built using Microsoft Power Automate Desktop.
-
Work with Bannerbear Data in FoxPro
Load Bannerbear into a FoxPro database. This article includes full code and a walk-through of the process.
-
Feed Reckon Data into FineReport
How to set Reckon as a JDBC data source in FineReport.
-
How to Connect to Live Asana 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 Asana for you.
-
Connect to Aha! Data in NetBeans
Connect to Aha! in NetBeans with the data source configuration wizard.
-
Build a Singer.io Tap for Beeminder With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Beeminder data using
-
Integrating Couchbase Data in Talend Cloud Data Management Platform
Connect Couchbase Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Couchbase.
-
Connecting Pipedream with Facebook 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 Facebook data in real time.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Cloudant
Provide connectivity to IBM Cloudant through an SAP BusinessObjects universe.
-
Automated Continuous LeadDesk Replication to SQLite
Use CData Sync for automated, continuous, customizable LeadDesk replication to SQLite.
-
Automated Continuous Oracle Eloqua Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to AlloyDB.
-
Seamlessly Bring Azure Synapse Data into Retool Using CData Connect AI
Integrate Azure Synapse data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.