CData Software - Knowledge Base
Recent Articles
-
Connect to Live Box Data in MicroStrategy through CData Connect AI
Create a live connection to Box Data in CData Connect AI and connect to your Box from MicroStrategy.
-
How to connect to Redshift Data from Spring Boot
Connect to Redshift in a Spring Boot Application using the CData JDBC Driver for Redshift
-
Create Excel Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Excel from PowerBI.com to create Power BI Dataflows with real-time data.
-
Use Biml to Build SSIS Tasks to Replicate Scrapfly Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Scrapfly to SQL Server.
-
Build Dashboards with Printful Data in Dundas BI
Create dynamic dashboards and perform analytics based on Printful in Dundas BI.
-
Integrating GitHub Copilot CLI with Recurly 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 Klaviyo Data in the Pentaho Report Designer
Publish reports based on Klaviyo in the Pentaho BI tool.
-
Publish Reports with Excel Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft Excel.
-
How to connect to Aha! Data in DBVisualizer
Integrate Aha! with visual data analysis tools and data connection wizards in DBVisualizer
-
Access IBM Cloud Object Storage Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live IBM Cloud Object Storage from HeidiSQL.
-
How to Use a Microsoft Access Database to Update Smartsheet Data in Real Time
Update Smartsheet data by creating a linked table in Microsoft Access with the CData Smartsheet ODBC Driver.
-
Feed SuiteCRM Data into FineReport
How to set SuiteCRM as a JDBC data source in FineReport.
-
Use the CData Software JDBC Driver for Azure Data Catalog in MicroStrategy Desktop
Connect to Azure Data Catalog in MicroStrategy Desktop using the CData Software JDBC Driver for Azure Data Catalog.
-
Integrate Goose with Live Shopify Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Shopify from within the local AI agent.
-
How to Connect to Live QuickBooks Time 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 QuickBooks Time through natural language.
-
Import Elasticsearch Data Using Azure Data Factory
Use CData Connect AI to connect to Elasticsearch Data from Azure Data Factory and import live Elasticsearch.
-
Query CouchDB Data as a SQL Server Database in Node.js
Execute SQL Server queries against Apache CouchDB from Node.js.
-
Query GetResponse Data in DataGrip
Create a Data Source for GetResponse in DataGrip and use SQL to query live GetResponse.
-
Visualize Live Twilio Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Twilio into custom reports in Power BI.
-
Consume PayPal OData Feeds in PowerBuilder
This article demonstrates how to consume PayPal as OData feeds from PowerBuilder using the API Server.
-
Query Oracle Service Cloud Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Oracle Service Cloud from Node.js.
-
Getting Started with the CData Tableau Connector for Pushbullet
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Integrate Dropbox Data into Power Automate Desktop using CData Connect
CData Connect for Dropbox Data enables you to integrate Dropbox into workflows built using Microsoft Power Automate Desktop.
-
Use Microsoft Copilot Studio to talk to your GitLab Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your GitLab for you.
-
Edit and Search Box External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Box to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Box objects that you can access from apps and the dashboard.
-
Connect to EnterpriseDB Data in Jaspersoft Studio
Execute SQL to remote EnterpriseDB in Jaspersoft Studio.
-
Bind Live SAP Ariba Source Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SAP Ariba Source data
-
Load LDAP Objects to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load LDAP to a database.
-
Connect to Instagram Data from PowerBuilder via ADO.NET
This article demonstrates how to access Instagram from Appeon PowerBuilder using the CData ADO.NET Provider for Instagram.
-
Connect to Cloudant in SpagoBI
Create reports featuring live IBM Cloudant in SpagoBI Studio. Host Cloudant reports on SpagoBI Server.
-
Automated Continuous FormSite Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable FormSite replication to Google BigQuery.
-
Load SAP Business Warehouse Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SAP Business Warehouse to a database.
-
Bind Live Acumatica Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Acumatica data
-
Viewing RSS Feeds in RAD Studio Data Explorer
How to view RSS Feeds in RAD Studio Data Explorer using the CData ODBC Driver for RSS.
-
Connect to Mistral AI Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Mistral AI as an External Source in Dremio.
-
Automated Continuous Box Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Box replication to Amazon S3.
-
Getting Started with the CData ADO.NET Provider for Factorial
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
How to connect Amazon QuickSight to Microsoft Teams Data
Create a connection to Microsoft Teams in CData Connect AI and insert Microsoft Teams into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrate Live Cassandra Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Cassandra from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Apache Cassandra.
-
Feed Bright Data Data into FineReport
How to set Bright Data as a JDBC data source in FineReport.
-
Model Google Spanner Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Google Spanner, enabling the direct import of real-time Google Spanner.
-
Publish Crystal Reports on FormSite Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date FormSite.
-
Connect to Strava Data from a Connection Pool in Jetty
The Strava JDBC Driver supports connection pooling: This article shows how to connect faster to Strava from Web apps in Jetty.
-
Automated Continuous Sugar CRM Replication to SQLite
Use CData Sync for automated, continuous, customizable Sugar CRM replication to SQLite.
-
Extract, Transform, and Load xBase Data in Informatica PowerCenter
Create a simple Workflow for xBase in Informatica PowerCenter.
-
Getting Started with the CData ADO.NET Provider for Freshdesk
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Freshdesk.
-
How to load Aircall data into Elasticsearch via Logstash
Introducing a simple method to load Aircall data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build Apps with Live Hubstaff Data Using the Low-Code Development Platform of Mendix
Connect Hubstaff with Mendix to build apps using the CData API Driver for JDBC.
-
Analyze SendGrid Data in Looker
Use CData Connect AI to connect to SendGrid Data from Looker and build custom apps using live SendGrid.
-
Build a Simple VCL Application for Shippo Data
How to build a simple VCL Application to view Shippo in RAD Studio using the CData ODBC Driver for Shippo.
-
Connect to ClickTime Data from a Connection Pool in Jetty
The ClickTime JDBC Driver supports connection pooling: This article shows how to connect faster to ClickTime from Web apps in Jetty.
-
How to connect and process Procore from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Procore.
-
Visualize JobNimbus Data in TIBCO Spotfire through ADO.NET
Integrate JobNimbus into dashboards in TIBCO Spotfire.
-
Connecting Agentforce with Stripe Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Stripe for you.
-
Automated Continuous Jumpseller Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Jumpseller replication to Apache Kafka.
-
Access Live BambooHR Data in Coginiti Pro
Connect to and query live BambooHR from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
A PostgreSQL Interface for Zoho Inventory Data (MySQL Remoting via JDBC)
Use the Remoting features of the Zoho Inventory JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Access Live Zoho CRM Data in Visual Studio Code via Cline
Run CData MCP Server for Zoho CRM on Windows Subsytem for Linux (WSL) and connect to live Zoho CRM from the Cline extension in Visual Studio Code.
-
Connect to DB2 Data in RazorSQL
Connect to DB2 from wizards and query IBM DB2 from the GUI in the RazorSQL database management tool.
-
How to create an RPA flow for Microsoft OneDrive Data in UiPath Studio
Use the Microsoft OneDrive ODBC Driver to create workflows that access real-time Microsoft OneDrive without any coding.
-
Connect to and Visualize Live xBase Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live xBase.
-
Connect to Azure Data Lake Storage from Asprova with CData Software ODBC Driver for Azure Data Lake Storage
This article shows how to connect faster to Azure Data Lake Storage data from Asprova.
-
Query PayPal Data as a SQL Server Database in Node.js
Execute SQL Server queries against PayPal from Node.js.
-
Connect to ChargeOver Data from a Connection Pool in JBoss
Integrate ChargeOver into Java servlets: Use the Management Console in JBoss to install the ChargeOver JDBC Driver.
-
How to Connect Google Contacts Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Google Contacts data in real time using natural language.
-
Integrating LangChain with Shopify Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Shopify within automated workflows.
-
Connect to Hive Data in CloverDX (formerly CloverETL)
Transfer Apache Hive using the visual workflow in the CloverDX data integration tool.
-
How to Connect to Live SAP ByDesign 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 SAP Business ByDesign without replication.
-
How to Connect to Live SAP SuccessFactors LMS Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your SAP SuccessFactors LMS for you.
-
Connect to Zoom Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Zoom using standard SQL.
-
DataBind Controls to Foursquare Data in Delphi
DataBind to Foursquare in Delphi with standard data access components and controls.
-
Build a Simple VCL Application for Wrike Data
How to build a simple VCL Application to view Wrike in RAD Studio using the CData ODBC Driver for Wrike.
-
How to load Highrise data into Elasticsearch via Logstash
Introducing a simple method to load Highrise data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build an OLAP Cube in SSAS from ZohoPeople Data
Establish a connection to ZohoPeople data from SQL Server Analysis Services, and use the ZohoPeople Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Reports with MailerLite Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date MailerLite.
-
Natively Connect to SFTP Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SFTP. Leverage the native support for ODBC in PHP.
-
Visualize Live Couchbase Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Couchbase into custom reports in Power BI.
-
Integrate XML with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate XML with External Services.
-
DataBind Authorize.Net Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Authorize.Net with the DevExpress Windows Forms and Web controls to provide Authorize.Net to a chart.
-
Connect Sendwithus Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Sendwithus using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Migrating data from Pingdom to Databricks using CData SSIS Components.
Easily push Pingdom to Databricks using the CData SSIS Tasks for Pingdom and Databricks.
-
Integrate Freshservice Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Freshservice from Informatica Cloud.
-
Use the CData Software JDBC Driver for Google Calendar in MicroStrategy Web
Connect to Google Calendar in MicroStrategy Web using the CData Software JDBC Driver for Google Calendar.
-
Creating SAP Concur-Connected Applications in Unqork
You can use CData Connect AI to feed SAP Concur to Unqork and build custom business apps.
-
Integrate Cursor with Live NetSuite Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live NetSuite CRM & ERP from within the editor.
-
Automated Continuous Optimizely Replication to Oracle
Use CData Sync for automated, continuous, customizable Optimizely replication to Oracle.
-
Automated Continuous Couchbase Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Couchbase replication to Apache Kafka.
-
Integrate with ShipEngine Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ShipEngine to a JSON file on disk.
-
Connect to FTP Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for FTP Servers in Airbyte.
-
Visualize Quaderno Data in Tableau
The CData ODBC driver for Quaderno enables you integrate Quaderno into Tableau dashboards.
-
Automated Continuous QuickBooks Replication to AlloyDB
Use CData Sync for automated, continuous, customizable QuickBooks replication to AlloyDB.
-
Connecting Moonlit Workflow with Google Spanner Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Google Spanner in real time.
-
Integrate ActiveCampaign Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ActiveCampaign from Informatica Cloud.
-
Integrate Theia IDE with Live Elasticsearch Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
How to Access Live Oracle Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Oracle enables you to integrate Oracle Database into workflows built using Microsoft Power Automate Desktop.
-
How to Query Live Oracle HCM Cloud Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Oracle HCM Cloud data in natural language using Python.
-
Use the CData Software JDBC Driver for SAP Fieldglass in MicroStrategy Web
Connect to SAP Fieldglass in MicroStrategy Web using the CData Software JDBC Driver for SAP Fieldglass.
-
Build Suadeo-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Suadeo and build web apps with connectivity to live Suadeo.
-
Create Datasets from GetResponse in Domo Workbench and Build Visualizations of GetResponse Data in Domo
Use the CData Software ODBC Driver for GetResponse to create datasets from GetResponse in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous CData Connect AI Replication to SQLite
Use CData Sync for automated, continuous, customizable CData Connect AI replication to SQLite.