CData Software - Knowledge Base
Recent Articles
-
Access Live SAP Ariba Procurement Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live SAP Ariba Procurement through MCP integration.
-
Create SSAS Tabular Models from SAP Fieldglass Data
How to build a SQL Server Analysis Service Tabular Model from SAP Fieldglass using CData drivers.
-
Connect to Act-On Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Act-On Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect Hacker News to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Hacker News with IBM WebSphere for seamless data integration and connectivity.
-
Access Live Amazon DynamoDB Data in AWS Lambda
Connect to live Amazon DynamoDB in AWS Lambda using the CData JDBC Driver.
-
Publish MariaDB-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live MariaDB.
-
Integrate Live Twitter Ads Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Twitter Ads to Blue Prism using the CData ODBC Driver for Twitter Ads to create automated workflows for repetitive business tasks.
-
How to Use a Microsoft Access Database to Update Email Data in Real Time
Update Email data by creating a linked table in Microsoft Access with the CData Email ODBC Driver.
-
Automated Continuous MessageBird Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable MessageBird replication to Amazon Redshift.
-
Access PabblySubscriptions Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live PabblySubscriptions from HeidiSQL.
-
Build Data Flows from SQL Server to QuickBooks Online through SSIS
Easily push SQL Server data to QuickBooks Online using the CData SSIS Tasks for QuickBooks Online.
-
Access Qualaroo Data from MySQL in Amazon QuickSight
Connect to Qualaroo and build visualizations of Qualaroo using a MySQL Connection in Amazon QuickSight.
-
Bridge Redis Connectivity with Apache NiFi
Access and process Redis in Apache NiFi using the CData JDBC Driver.
-
Viewing Perigon Data in RAD Studio Data Explorer
How to view Perigon in RAD Studio Data Explorer using the CData ODBC Driver for Perigon.
-
Access Teradata Data from MySQL in Amazon QuickSight
Connect to Teradata and build visualizations of Teradata using a MySQL Connection in Amazon QuickSight.
-
Use the CData Software ODBC Driver for RabbitMQ in MicroStrategy
Connect to RabbitMQ in MicroStrategy Developer using the CData Software ODBC Driver for RabbitMQ.
-
Connect to Coda Data from a Connection Pool in Jetty
The Coda JDBC Driver supports connection pooling: This article shows how to connect faster to Coda from Web apps in Jetty.
-
Automated Continuous Facebook Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Facebook replication to Azure SQL Database.
-
Integrate Cursor with Live Oracle HCM Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Oracle HCM Cloud from within the editor.
-
Access Live Apify Data in AWS Lambda
Connect to live Apify in AWS Lambda using the CData JDBC Driver.
-
Getting Started with the CData JDBC Driver for ZarMoney
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for ZarMoney.
-
Connect to Unbounce Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Access Live Excel Online Data in Excel 365 Online (Excel for the web)
Connect to Microsoft Excel Online from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to Query Hacker News Data in MySQL Workbench
Execute MySQL queries against live Hacker News from MySQL Workbench.
-
Build MVC Applications with Connectivity to Freshdesk Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Freshdesk from an ASP.NET MVC application.
-
DataBind Paddle Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Paddle to a chart.
-
Moving Data from Landbot to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Landbot data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Use the CData SSIS Lookup Component to Insert New or Update Existing Salesforce Records from SQL Server
Easily push SQL Server data to Salesforce using the CData SSIS Components for Salesforce. This example uses an SSIS workflow to either insert new records into Salesforce or update existing records with data from a SQL Server database.
-
Access Superchat 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 Superchat.
-
Connect to GitLab from Asprova with CData Software ODBC Driver for GitLab
This article shows how to connect faster to GitLab data from Asprova.
-
Build Mocean-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Mocean and build web apps with connectivity to live Mocean.
-
Build AI/ML Models with Live Hubstaff Data using Dataiku
Connect Hubstaff Data with Dataiku using the CData API Driver for JDBC.
-
Connect to Oracle Service Cloud Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Oracle Service Cloud using standard SQL.
-
Integrating Dotmailer Data in Talend Cloud Data Management Platform
Connect Dotmailer Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Integrate Cursor with Live IBM Cloud Object Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live IBM Cloud Object Storage from within the editor.
-
Connect to Jira Assets Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Jira Assets Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to update HBase from Excel
This article explains how to transfer data from Excel to HBase using the Excel Add-In for HBase.
-
How to import SharePoint Data into Apache Solr
Use the CData Software JDBC Driver for SharePoint in Data Import Handler and create an automated import of Microsoft SharePoint to Apache Solr Enterprise Search platform.
-
Build Mouseflow-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Mouseflow.
-
Use the CData API Server to Access Customer.io Data in Microsoft PowerPivot
Use the CData API Server to connect to live Customer.io in the Power Pivot business intelligence tool.
-
Provide OData Services of SAP Ariba Source Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SAP Ariba Source by developing a WCF Service Application.
-
Access Live Azure Data Lake Storage Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Azure Data Lake Storage into the statistical analysis tools available in SAS JMP. This article shows how to use Azure Data Lake Storage in the Graph Builder and Query Builder.
-
Extract, Transform, and Load Autopilot Data in Informatica PowerCenter
Create a simple Workflow for Autopilot in Informatica PowerCenter.
-
Connect to Real-Time DocuSign Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for DocuSign and Dataflow to import and use DocuSign in Power Apps.
-
How to Access Live Moosend Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Moosend enables you to integrate Moosend into workflows built using Microsoft Power Automate Desktop.
-
Use Dash to Build to Web Apps on DocuSign Data
Create Python applications that use pandas and Dash to build DocuSign-connected web apps.
-
Edit and Search Outlook External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Outlook to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Outlook objects that you can access from apps and the dashboard.
-
Automated Continuous Google Spanner Replication to SQL Server
Use CData Sync for automated, continuous, customizable Google Spanner replication to SQL Server.
-
Build Snapchat Ads-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Snapchat Ads Data and create custom apps in Bubble.
-
Query Guru Data in DataGrip
Create a Data Source for Guru in DataGrip and use SQL to query live Guru.
-
Query Live Cosmos DB 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 Azure Cosmos DB directly from the development environment.
-
Visualize Mailjet Data in TIBCO Spotfire through ADO.NET
Integrate Mailjet into dashboards in TIBCO Spotfire.
-
Build Data Flows from Impala to SQL Server using SSIS
Easily back up Apache Impala to SQL Server using the SSIS components for Impala.
-
Create Dynamic Coda Grids Using the Infragistics XamDataGrid
Learn how you can connect Coda to Infragistics XamDataGrid to build dynamic grids.
-
How to integrate Grafana with Apache Airflow
Access and process Grafana in Apache Airflow using the CData JDBC Driver.
-
Create Brex Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Brex from PowerBI.com to create Power BI Dataflows with real-time data.
-
Use Dash to Build to Web Apps on BambooHR Data
Create Python applications that use pandas and Dash to build BambooHR-connected web apps.
-
Rapidly Develop FormSite-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 FormSite.
-
View Reports on Real-Time LeadDesk Data in Power BI Report Server
Use the CData ODBC Driver for LeadDesk to visualize LeadDesk in Power BI Desktop and then publish them to Power BI Report Server.
-
Visualize OnePageCrm Data in Sisense
Create an ElastiCube in Sisense app with access to OnePageCrm.
-
Build MVC Applications with Connectivity to Hacker News Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Hacker News from an ASP.NET MVC application.
-
Access Live Quaderno Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Quaderno into the statistical analysis tools available in SAS JMP. This article shows how to use Quaderno in the Graph Builder and Query Builder.
-
Replicate Multiple TaxJar Accounts via the CData Sync CLI
Replicate multiple TaxJar accounts to one or many databases.
-
DataBind Retently Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Retently to a chart.
-
How to Connect to Live Power BI XMLA 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 Power BI XMLA for you.
-
Query Parallel Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Parallel and perform CRUD operations on Parallel from Node.js.
-
Build Automated Blackbaud FE NXT-Connected Workflows in Zapier
Use CData Connect AI to connect to live Blackbaud FE NXT and build automated workflows in Zapier.
-
SendPulse Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SendPulse facts in real time.
-
Analyze Vercel Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Vercel and visualize live Vercel in Infragistics Reveal.
-
Load Vimeo Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Vimeo to a database.
-
Build Semantic Layer Views for Teamgate Data in APOS Live Data Gateway
Use the CData Connector for Teamgate in APOS Live Data Gateway to build Semantic Layer Views for Teamgate.
-
How to Connect to FHIR Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to FHIR. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous LaunchDarkly Replication to Snowflake
Use CData Sync for automated, continuous, customizable LaunchDarkly replication to Snowflake.
-
Automate Act CRM Data Replication to SAP HANA
Use CData Sync to customize and automate Act CRM replication to SAP HANA.
-
Access Shippo Data from MySQL in Amazon QuickSight
Connect to Shippo and build visualizations of Shippo using a MySQL Connection in Amazon QuickSight.
-
View Reports on Real-Time Coda Data in Power BI Report Server
Use the CData ODBC Driver for Coda to visualize Coda in Power BI Desktop and then publish them to Power BI Report Server.
-
How to update Gmail from Excel
This article explains how to transfer data from Excel to Gmail using the Excel Add-In for Gmail.
-
Viewing Klaviyo Data in RAD Studio Data Explorer
How to view Klaviyo in RAD Studio Data Explorer using the CData ODBC Driver for Klaviyo.
-
Use the CData Software ODBC Driver for Gumroad in MicroStrategy Web
Connect to Gumroad in MicroStrategy Web using the CData Software ODBC Driver for Gumroad.
-
Viewing Excel Online Data in RAD Studio Data Explorer
How to view Microsoft Excel Online in RAD Studio Data Explorer using the CData ODBC Driver for Excel Online.
-
How to connect to Elorus Data in DBVisualizer
Integrate Elorus with visual data analysis tools and data connection wizards in DBVisualizer
-
Automate MongoDB Data Replication to Azure Synapse
Use CData Sync to customize and automate MongoDB replication to Azure Synapse.
-
Getting Started with the CData ODBC Driver for ConvertAPI
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ConvertAPI.
-
Query Placid Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Placid and perform CRUD operations on Placid from Node.js.
-
Connect to ZohoMarketingHub Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ZohoMarketingHub in the Denodo Virtual DataPort Administrator.
-
Use the CData ODBC Driver for Bullhorn CRM from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Bullhorn CRM to connect to Bullhorn CRM from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Bullhorn CRM in Excel.
-
Integrate Cursor with Live Sybase IQ Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Sybase IQ from within the editor.
-
Connect Vault CRM to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Veeva Vault & Vault CRM using the CData Python MCP Server.
-
Migrating data from OpenWeatherMap to Databricks using CData SSIS Components.
Easily push OpenWeatherMap to Databricks using the CData SSIS Tasks for OpenWeatherMap and Databricks.
-
How to Easily Query FreeAgent Data in OpenOffice Base
Connect to FreeAgent data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Replicate SAP Netweaver Gateway Data in Heroku for Use in Salesforce Connect
Replicate SAP Netweaver Gateway to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate WooCommerce Data in Pentaho Data Integration
Build ETL pipelines based on WooCommerce in the Pentaho Data Integration tool.
-
Extract, Transform, and Load Mixpanel Data in Informatica PowerCenter
Create a simple Workflow for Mixpanel in Informatica PowerCenter.
-
How to work with Foursquare Data in Apache Spark using SQL
Access and process Foursquare Data in Apache Spark using the CData Software JDBC Driver.
-
Excel Spreadsheet Automation on Toggl Data with the QUERY Formula
Pull data from Toggl, automate spreadsheets, and more with the QUERY formula.
-
Publish Crystal Reports on Sage 200 Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Sage 200.
-
A PostgreSQL Interface for Bugsnag Data (MySQL Remoting via JDBC)
Use the Remoting features of the Bugsnag JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to QuickBooks Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to Oracle Sales Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Oracle Sales using standard SQL.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Jira Assets to Power BI dashboards. Simply drag and drop Jira Assets into data visuals on the Power BI canvas.