CData Software - Knowledge Base
Recent Articles
-
Integrating Boomi Agentstudio with SAP Ariba Procurement Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to SAP Ariba Procurement, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Create Informatica Mappings From/To a JDBC Data Source for Presto
Create Presto data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build a Singer.io Tap for Harvest With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Harvest data using
-
Connect to MYOB AccountRight Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Excel Spreadsheet Automation on Avro Data with the QUERY Formula
Pull data from Avro, automate spreadsheets, and more with the QUERY formula.
-
Connect to Scrapfly Data in RapidMiner
Integrate Scrapfly with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate with Google Ad Manager Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Google Ad Manager to a JSON file on disk.
-
Build MongoDB-Connected Apps in Choreo
Use CData Connect AI to connect to MongoDB Data from Choreo and build custom apps using live MongoDB.
-
Build AI/ML Models with Live Airtable Data using Dataiku
Connect Airtable Data with Dataiku using the CData JDBC Driver for Airtable.
-
Import Dynamics CRM Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Dynamics CRM Data and provide access to live Microsoft Dynamics CRM for custom reports in the Power BI Service.
-
Model, Search, and Visualize Live Cosmos DB Data in ThoughtSpot
Use CData Connect AI to connect to live Azure Cosmos DB for modeling, searching, and visualizing.
-
Integrate with OneNote Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Microsoft OneNote to a JSON file on disk.
-
Automated Continuous Google Campaign Manager 360 Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to PostgreSQL.
-
Prepare, Blend, and Analyze Billsby Data in Alteryx Designer (ODBC)
Build workflows to access live Billsby for self-service data analytics.
-
Extract, Transform, and Load MailerLite Data in Informatica PowerCenter
Create a simple Workflow for MailerLite in Informatica PowerCenter.
-
How to Connect to Live API Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live API without replication.
-
How to publish and share PostgreSQL Data dashboards with Tableau Server
The CData ODBC driver for PostgreSQL enables you integrate PostgreSQL into Tableau dashboards.
-
How to Query Live SAP Business Warehouse Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SAP Business Warehouse data in natural language using Python.
-
Replicate PostgreSQL Data to Multiple Databases
Replicate PostgreSQL to disparate databases with a point-and-click configuration.
-
Import Real-Time Cassandra Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Apache Cassandra in ColdFusion.
-
Getting Started with the CData ADO.NET Provider for Salesforce Pardot
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Salesforce Pardot.
-
Migrating data from Bannerbear to Snowflake using CData SSIS Components.
Easily push Bannerbear to Snowflake using the CData SSIS Tasks for Bannerbear and Snowflake.
-
Query Jumpseller Data as a MySQL Database in Node.js
Execute MySQL queries against Jumpseller from Node.js.
-
Connect to Real-Time Mailgun Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Mailgun in Power Apps.
-
Access Foursquare Data from MySQL in PHP
Connect to Foursquare through the standard MySQL libraries in PHP.
-
Use the CData Software JDBC Driver for Spark in MicroStrategy Desktop
Connect to Apache Spark SQL in MicroStrategy Desktop using the CData Software JDBC Driver for Spark.
-
Extend Google Sheets with Bullhorn CRM Data
Make calls to Bullhorn CRM from Google Apps Script via the API Server.
-
Visualize Microsoft Entra ID Data in Tableau
The CData ODBC driver for Microsoft Entra ID enables you integrate Microsoft Entra ID into Tableau dashboards.
-
Integrating Antigravity CLI with Placid via CData CLI
Connect Placid to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate Cline with Live FHIR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live FHIR from within your IDE.
-
Access Live Salesforce Pardot Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Salesforce Pardot through MCP integration.
-
Getting Started with the CData SSIS Components for Oracle Sales
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Oracle Sales.
-
Automated Continuous SAP Netweaver Gateway Replication to SingleStore
Use CData Sync for automated, continuous, customizable SAP Netweaver Gateway replication to SingleStore.
-
Access Auth0 Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Auth0.
-
Automated Continuous SAP Ariba Source Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to PostgreSQL.
-
Connect to and Visualize Live eBay Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live eBay.
-
Visualize FTP Data in Tableau
The CData ODBC driver for FTP enables you integrate FTP Servers into Tableau dashboards.
-
Build HubDB-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live HubDB.
-
Build Agents in Relevance AI with Access to Live Freshservice Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Freshservice within intelligent agent workflows.
-
How to Connect to Live Google Analytics Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Google Analytics securely in real time.
-
Query Oracle Eloqua Reporting Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Oracle Eloqua Reporting from Node.js.
-
SAP Ariba Procurement Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SAP Ariba Procurement facts in real time.
-
Use the CData Software ODBC Driver for Templated in SAS for Real-Time Reporting and Analytics
Connect to real-time Templated in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Templated.
-
Load Oracle SCM Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Oracle SCM to a database.
-
Access Live Google Search Results in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Search from your Excel spreadsheets.
-
Replicate Multiple Toggl Accounts
Replicate multiple Toggl accounts to one or many databases.
-
Access GraphQL Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access GraphQL from your Oracle system.
-
Connect to Google Drive Data in DBeaver
Use the CData ODBC Driver to connect to Google Drive in DBeaver.
-
Connect to SAP Concur from a Connection Pool in WebLogic
Use the CData JDBC Driver for SAP Concur to connect to SAP Concur from Web applications running on WebLogic.
-
Connect to Facebook Data in Ruby
Connect to Facebook in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Back Up Customer.io to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Customer.io data.
-
Bridge Accelo Connectivity with Apache NiFi
Access and process Accelo in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous Redis Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Redis replication to Apache Cassandra.
-
Viewing LionDesk Data in RAD Studio Data Explorer
How to view LionDesk in RAD Studio Data Explorer using the CData ODBC Driver for LionDesk.
-
Connect to Blackbaud FE NXT Data in Aqua Data Studio
Access Blackbaud FE NXT from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Manage Cohere Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Cohere.
-
Use the CData API Server to Access Zoho Books Data in Microsoft PowerPivot
Use the CData API Server to connect to live Zoho Books in the Power Pivot business intelligence tool.
-
Integrating Claude Code CLI with Cloudant 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.
-
Use the CData Software ODBC Driver for Eventbrite in SAS for Real-Time Reporting and Analytics
Connect to real-time Eventbrite in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Eventbrite.
-
Connect to Browserless Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Browserless.
-
How to connect PolyBase to Cvent
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Cvent.
-
How to Work with Mode Data in ETL Validator JDBC
Connect to Mode from ETL Validator jobs using the CData Software JDBC Driver.
-
Consume CouchDB OData Feeds in SAP Lumira
Use the API Server to create data visualizations on CouchDB feeds that reflect any changes in SAP Lumira.
-
Connect to Templated Data in NetBeans
Connect to Templated in NetBeans with the data source configuration wizard.
-
Create Dynamic Dynamics 365 Grids Using the Infragistics XamDataGrid
Learn how you can connect Dynamics 365 to Infragistics XamDataGrid to build dynamic grids.
-
How to Access Tickspot Data Using Entity Framework
This article shows how to access Tickspot using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Bind Live MariaDB Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live MariaDB data
-
Getting Started with the CData ODBC Driver for Wrike
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Wrike.
-
How to Connect to Live Zuora 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 Zuora for you.
-
Visualize Google Spanner Data in Tableau
The CData ODBC driver for Google Spanner enables you integrate Google Spanner into Tableau dashboards.
-
Use the CData Software ODBC Driver for Highrise in MicroStrategy Desktop
Connect to Highrise CRM in MicroStrategy Desktop using the CData Software ODBC Driver for Highrise.
-
Integrate MYOB AccountRight Data in Pentaho Data Integration
Build ETL pipelines based on MYOB AccountRight in the Pentaho Data Integration tool.
-
Build Apps with Live Oracle SCM Data Using the Low-Code Development Platform of Mendix
Connect Oracle SCM with Mendix to build apps using the CData JDBC Driver for Oracle SCM.
-
Create Reports with HDFS Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Apache HDFS.
-
Visualize Live Highrise Data in the Power BI Service
Use CData Connect AI to connect to live Highrise CRM and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating OpenCode Terminal with Gmail 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.
-
Create a Data Access Object for JobNimbus Data using JDBI
A brief overview of creating a SQL Object API for JobNimbus in JDBI.
-
Access Landbot Data from MySQL in PHP
Connect to Landbot through the standard MySQL libraries in PHP.
-
Publish Cloudant-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live IBM Cloudant.
-
Import Real-Time Zoho Creator Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Zoho Creator in ColdFusion.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live SQL Analysis Services within intelligent workflows.
-
Connect Dynamics CRM to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Microsoft Dynamics CRM using the CData Python MCP Server.
-
DataBind Splunk Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Splunk with the DevExpress Windows Forms and Web controls to provide Splunk to a chart.
-
How to Connect to Slack Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Slack. Leverage the pyodbc module for ODBC in Python.
-
How to Access Redshift Data Using Entity Framework
This article shows how to access Amazon Redshift using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Provide OData Services of Sage Intacct Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Sage Intacct by developing a WCF Service Application.
-
Getting Started with the CData ODBC Driver for Spotify
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Spotify.
-
How to create an RPA flow for Discourse Data in UiPath Studio
Use the Discourse ODBC Driver to create workflows that access real-time Discourse without any coding.
-
How to Connect to Live ServiceNow 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 ServiceNow for you.
-
Getting Started with the CData Excel Add-In for Google Tasks
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Google Tasks.
-
Prepare, Blend, and Analyze RSS Feeds in Alteryx Designer (ODBC)
Build workflows to access live RSS Feeds for self-service data analytics.
-
Create Pushbullet Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Pushbullet data access from reports, embedded analytics, and more.
-
How to Connect the Power BI Service to Insightly: Complete Guide
Connect to the CData Software Power BI Connector for Insightly from PowerBI.com to provide real-time Insightly across the organization.
-
Manage Grafana Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Grafana.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Basecamp
Provide connectivity to Basecamp through an SAP BusinessObjects universe.
-
Build Charts with ActiveCampaign Data in Clear Analytics
Create dynamic charts and perform analytics based on ActiveCampaign in Clear Analytics.
-
Query SAP Concur Data as a MySQL Database in Node.js
Execute MySQL queries against SAP Concur from Node.js.
-
Connect to Pipeline CRM Data in NetBeans
Connect to Pipeline CRM in NetBeans with the data source configuration wizard.
-
Connect CapsuleCRM to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect CapsuleCRM with IBM WebSphere for seamless data integration and connectivity.
-
Create Reports from MongoDB Data in Looker Studio
Use CData Connect AI to gain access to live MongoDB and create custom reports in Looker Studio.