CData Software - Knowledge Base



Recent Excel Online Articles

Migrating data from Excel Online to Google BigQuery using CData SSIS Components.

Easily push Microsoft Excel Online to Google BigQuery using the CData SSIS Tasks for Excel Online and Google BigQuery.

Integrate Excel Online in the Pentaho Report Designer

Publish reports based on Microsoft Excel Online in the Pentaho BI tool.

How to Build an ETL App for Excel Online in Python with CData

Create ETL applications and real-time data pipelines for Microsoft Excel Online in Python with petl.

Visualize Excel Online in TIBCO Spotfire through ODBC

The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Microsoft Excel Online into TIBCO Spotfire.

Use Dash to Build to Web Apps on Excel Online

Create Python applications that use pandas and Dash to build Excel Online-connected web apps.

How to use SQLAlchemy ORM to access Excel Online in Python

Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Microsoft Excel Online.

Connect Excel Online to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

Connect to your Microsoft Excel Online using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

Connect to Excel Online in DBArtisan

Use wizards in DBArtisan to configure Microsoft Excel Online as a data source.

Access Excel Online 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 Microsoft Excel Online.

Connect to Excel Online from Asprova with CData Software ODBC Driver for Excel Online

This article shows how to connect faster to Excel Online data from Asprova.

How to Access Excel Online Using Entity Framework

This article shows how to access Microsoft Excel Online using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

Working with Excel Online in LINQPad

Execute LINQ queries to Microsoft Excel Online in LINQPad.

Migrating data from Excel Online to Snowflake using CData SSIS Components.

Easily push Microsoft Excel Online to Snowflake using the CData SSIS Tasks for Excel Online and Snowflake.

Connect to Excel Online from PowerBuilder via ODBC

This article demonstrates how to use the CData ODBC Driver for Excel Online to connect to Microsoft Excel Online and execute queries in PowerBuilder.

How to connect SharePoint with Excel Online through external lists

Provide Microsoft Excel Online to SharePoint users as an external list.

Automate Excel Online Integration Tasks from PowerShell

Are you in search of a quick and easy way to access Microsoft Excel Online from PowerShell? This article demonstrates how to utilize the Excel Online Cmdlets for tasks like connecting to Microsoft Excel Online, automating operations, downloading data, and more.

Visualize Live Excel Online in Tableau

Use CData Tableau Connectors and Tableau Desktop to visualize live Microsoft Excel Online.

Integrate with Excel Online in JReport Designer

Create charts and reports based on Microsoft Excel Online in JReport Designer.

How to connect PolyBase to Excel Online

Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Microsoft Excel Online.

DataBind Excel Online to the DevExpress Data Grid

Use the CData Software ADO.NET Provider for Excel Online with the DevExpress Windows Forms and Web controls to provide Microsoft Excel Online to a chart.

Import and Visualize Excel Online in Power View

Create data visualizations based on Microsoft Excel Online in Excel.

Create an SAP BusinessObjects Universe on the CData JDBC Driver for Excel Online

Provide connectivity to Microsoft Excel Online through an SAP BusinessObjects universe.

Query Excel Online from Node.js

Use the OData endpoint of the CData API Server to connect to your Microsoft Excel Online and perform CRUD operations on Excel Online from Node.js.

How to Use a Microsoft Access Database to Update Excel Online in Real Time

Update Excel Online data by creating a linked table in Microsoft Access with the CData Excel Online ODBC Driver.

Using the CData Software ODBC Driver for Excel Online in PyCharm

Connect to Excel Online as an ODBC data source in PyCharm using the CData Software ODBC Driver for Excel Online.

Connect to Excel Online in RazorSQL

Connect to Excel Online from wizards and query Microsoft Excel Online from the GUI in the RazorSQL database management tool.

Connect to Excel Online from PowerBuilder via JDBC

This article demonstrates how to access Microsoft Excel Online from PowerBuilder using the Excel Online JDBC Driver.

LINQ to Excel Online

LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Excel Online Data Provider.

How to connect to Excel Online from IntelliJ

Integrate connectivity to Microsoft Excel Online with wizards in IntelliJ.

Analyze Excel Online in Infragistics Reveal

Use the CData API Server to create an OData API on top of Microsoft Excel Online and visualize live Microsoft Excel Online in Infragistics Reveal.

Extract, Transform, and Load Excel Online in Informatica PowerCenter

Create a simple Workflow for Microsoft Excel Online in Informatica PowerCenter.

Integrating Excel Online in Talend Cloud Data Management Platform

Connect Excel Online with Talend Cloud Data Management Platform using the [product_name].

Feed Excel Online into FineReport

How to set Microsoft Excel Online as a JDBC data source in FineReport.

Connect to and Visualize Live Excel Online in Tableau Prep

Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft Excel Online.

Build Data Flows from SQL Server to Excel Online through SSIS

Easily push SQL Server data to Excel Online using the CData SSIS Tasks for Excel Online.

ETL Excel Online in Oracle Data Integrator

This article shows how to transfer Microsoft Excel Online into a data warehouse using Oracle Data Integrator.

Connect to Excel Online from PowerBuilder via ADO.NET

This article demonstrates how to access Microsoft Excel Online from Appeon PowerBuilder using the CData ADO.NET Provider for Excel Online.

Connect to Excel Online in Jaspersoft Studio

Execute SQL to remote Microsoft Excel Online in Jaspersoft Studio.

Connect to Excel Online in Aqua Data Studio

Access Microsoft Excel Online from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

Replicate Excel Online from PowerShell

Write a quick PowerShell script to query Microsoft Excel Online. Use connectivity to the live data to replicate Microsoft Excel Online to SQL Server.

How to create Visio diagrams from Excel Online

Automatically update Microsoft Excel Online with the changes you make to Visio master shapes.

Connect to Excel Online as a Linked Server via SQL Gateway

Use the SQL Gateway and the ODBC Driver to set up a linked server for Microsoft Excel Online.

Use CData Connect AI to Access Excel Online in Microsoft Power Pivot

Use CData Connect AI to connect to live Microsoft Excel Online in the Power Pivot business intelligence tool.

Connect to Excel Online in RapidMiner

Integrate Microsoft Excel Online with standard components and data source configuration wizards in RapidMiner Studio.

Consume Excel Online OData Feeds in SAP Lumira

Use the API Server to create data visualizations on Excel Online feeds that reflect any changes in SAP Lumira.

How to Query Live Excel Online Data in Natural Language in Python using LlamaIndex

Use LlamaIndex to query live Microsoft Excel Online data in natural language using Python.

Provide OData Services of Excel Online from a WCF Application

In this article, we will demonstrate the process of generating an OData feed for Microsoft Excel Online by developing a WCF Service Application.

Connect to Excel Online in NetBeans

Connect to Microsoft Excel Online in NetBeans with the data source configuration wizard.

Viewing Excel Online in RAD Studio Data Explorer

How to view Microsoft Excel Online in RAD Studio Data Explorer using the CData ODBC Driver for Excel Online.

Integrate Live Excel Online into Blue Prism for Intelligent Robotic Process Automation (RPA)

Connect live Microsoft Excel Online to Blue Prism using the [product_name] to create automated workflows for repetitive business tasks.

Migrating data from Excel Online to Databricks using CData SSIS Components.

Easily push Microsoft Excel Online to Databricks using the CData SSIS Tasks for Excel Online and Databricks.

Create Reports with Excel Online in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Microsoft Excel Online.

PowerShell Scripting to Replicate Excel Online to MySQL

Write a simple PowerShell script to replicate Microsoft Excel Online to a MySQL database.

Visualize Excel Online in TIBCO Spotfire through OData

Integrate Microsoft Excel Online into dashboards in TIBCO Spotfire.

How to Connect to Excel Online in Using Python: 6 Steps

Create Python applications on Linux/UNIX machines with connectivity to Microsoft Excel Online. Leverage the pyodbc module for ODBC in Python.

Edit and Search Excel Online External Objects in Salesforce Connect (API Server)

Use the API Server to securely provide OData feeds of Microsoft Excel Online to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Excel Online objects that you can access from apps and the dashboard.

Create an SAP BusinessObjects Universe on the CData ODBC Driver for Excel Online

Provide connectivity to Microsoft Excel Online through an SAP BusinessObjects universe.

Visualize Excel Online in TIBCO Spotfire through ADO.NET

Integrate Microsoft Excel Online into dashboards in TIBCO Spotfire.

How to connect to Excel Online with Squirrel SQL client

Connect to Microsoft Excel Online and execute queries in the Squirrel SQL Client.

Analyze Excel Online in Slingshot with CData API Server

Use the CData API Server to build an OData API on top of Microsoft Excel Online and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.

Publish Reports with Excel Online in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Microsoft Excel Online.

Query Excel Online in ColdFusion

Write standard ColdFusion data access code to connect to Microsoft Excel Online.

Build Charts with Excel Online in Clear Analytics

Create dynamic charts and perform analytics based on Microsoft Excel Online in Clear Analytics.

Publish Excel Online-Connected Dashboards in Tableau Server

Use CData Tableau Connectors and Tableau Server to visualize live Microsoft Excel Online.

Object-Relational Mapping (ORM) with Excel Online 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 Microsoft Excel Online into a Java-based ORM framework, Hibernate.

Build an OLAP Cube in SSAS from Excel Online

Establish a connection to Microsoft Excel Online data from SQL Server Analysis Services, and use the Excel Online Data Provider to build OLAP cubes for use in analytics and reporting.

Build a Simple VCL Application for Excel Online

How to build a simple VCL Application to view Microsoft Excel Online in RAD Studio using the CData ODBC Driver for Excel Online.

Connect to Excel Online in JRuby

Create a simple JRuby app with access to live Microsoft Excel Online.

Connect to Excel Online in RunMyProcess through Connect AI

Use CData Connect AI to create on OData API for Excel Online and connect to Microsoft Excel Online in Akorbi Digital RunMyProcess.

DataBind Controls to Excel Online in Delphi

DataBind to Microsoft Excel Online in Delphi with standard data access components and controls.

Bidirectional Access to Excel Online from FileMaker Pro

Use the MySQL Remoting feature of the JDBC driver to integrate Microsoft Excel Online in Filemaker Pro for Mac or Windows.

Analyze Excel Online in SAP Analytics Cloud

Use CData Connect AI to create an OData API on top of Microsoft Excel Online and visualize Microsoft Excel Online in SAP Analytics Cloud.

Connect to Excel Online in CloverDX (formerly CloverETL)

Transfer Microsoft Excel Online using the visual workflow in the CloverDX data integration tool.

Analyze Excel Online in Infragistics Reveal

Use CData Connect AI to create on OData API on top of Microsoft Excel Online and visualize live Microsoft Excel Online in Infragistics Reveal.

Connect to Excel Online Using the Script Function in Claris FileMaker Pro

Use the [product_name] and the Script function in FileMaker Pro to connect to Excel Online and work with Microsoft Excel Online in your FileMaker application.

Publish Excel Online-Connected Dashboards in Tableau Server via JDBC

Use CData JDBC drivers and Tableau Server to visualize live Microsoft Excel Online.

Connect to Excel Online in Google Apps Script via Connect AI

Use CData Connect AI to access Microsoft Excel Online in Google Apps Script.

Design BIRT Reports on Excel Online

Provide current Microsoft Excel Online to your embedded analytics.

Load Excel Online to a Database Using Embulk

Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft Excel Online to a database.

Work with Excel Online in FoxPro

Load Microsoft Excel Online into a FoxPro database. This article includes full code and a walk-through of the process.

Building Dynamic Web Pages with Excel Online Using AngularJS

Create single-page applications with live connectivity to Excel Online using the CData API Server.

Connect to Excel Online in Claris FileMaker Pro

Use the [product_name] in FileMaker Pro to connect to Excel Online and work with Microsoft Excel Online in your FileMaker applications.

How to publish and share Excel Online dashboards with Tableau Server

The CData ODBC driver for Excel Online enables you integrate Microsoft Excel Online into Tableau dashboards.

Build MVC Applications with Connectivity to Excel Online

This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Excel Online from an ASP.NET MVC application.

Edit and Search External Excel Online Objects in Salesforce Connect

Use CData Connect AI to securely provide OData feeds of Microsoft Excel Online to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Excel Online objects that you can access from apps and the dashboard.

Access Excel Online as a Remote Oracle Database

Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Microsoft Excel Online from your Oracle system.

Enable the Excel Online JDBC Driver in KNIME

Use standard data access components in KNIME to create charts and reports with Microsoft Excel Online.

Publish Crystal Reports on Excel Online

Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Microsoft Excel Online.

How to Import Data from Excel Online into Google Sheets

Import Microsoft Excel Online into a Google spreadsheet that is automatically refreshed.

Connect to Excel Online from a Connection Pool in WebLogic

Use the CData JDBC Driver for Excel Online to connect to Microsoft Excel Online from Web applications running on WebLogic.

Build Dashboards with Excel Online in DBxtra

Create dynamic dashboards and perform analytics based on Microsoft Excel Online in DBxtra.

Use the CData ODBC Driver for Excel Online from SharePoint Excel Services

This article demonstrates how to use the CData ODBC Driver for Excel Online to connect to Microsoft Excel Online from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Microsoft Excel Online in Excel.

Build Excel Online-Connected Web Apps with Axios and CData Connect AI

Use CData Connect AI to connect to live Microsoft Excel Online and build Excel Online-connected web apps with Axios.

Explore Geographical Relationships in Excel Online with Power Map

Create data visualizations with Microsoft Excel Online in Power Map.

Connect to Excel Online in SpagoBI

Create reports featuring live Microsoft Excel Online in SpagoBI Studio. Host Excel Online reports on SpagoBI Server.

Consume Excel Online OData Feeds in PowerBuilder

This article demonstrates how to consume Microsoft Excel Online as OData feeds from PowerBuilder using the API Server.

DataBind Controls to Excel Online in C++Builder

DataBind to Microsoft Excel Online in C++Builder with standard components and controls.

Connect to Excel Online through External Services in Salesforce

Use CData Connect AI to securely connect Salesforce External Services with Excel Online using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

Create Informatica Mappings From/To a JDBC Data Source for Excel Online

Create Excel Online data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

Visualize Excel Online in Sisense

Create an ElastiCube in Sisense app with access to Microsoft Excel Online.

Connect to Excel Online in Ruby

Connect to Microsoft Excel Online in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

How to Connect DBeaver to Excel Online via a JDBC Driver

Manage Microsoft Excel Online with visual tools in DBeaver like the query browser.

Create Data Visualizations in Cognos BI with Excel Online

Access Microsoft Excel Online as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

Configure the CData JDBC Driver for Excel Online in a Connection Pool in Tomcat

Connect to Microsoft Excel Online from a connection pool in Tomcat.

Connect to Excel Online from a Connection Pool in JBoss

Integrate Microsoft Excel Online into Java servlets: Use the Management Console in JBoss to install the Excel Online JDBC Driver.

Extend Google Sheets with Excel Online

Make calls to the API Server from Google Apps Script.

Create Dynamic Excel Online Grids Using the Infragistics XamDataGrid

Learn how you can connect Excel Online to Infragistics XamDataGrid to build dynamic grids.

Establish a Live Connection with Excel Online using Tableau Bridge

The CData ODBC Driver for Excel Online enables you to integrate live Microsoft Excel Online into Tableau Cloud dashboards using the Tableau Bridge.

Integrate Excel Online in Pentaho Data Integration

Build ETL pipelines based on Microsoft Excel Online in the Pentaho Data Integration tool.

Natively Connect to Excel Online in PHP via ODBC (Linux)

Create PHP applications on Linux/UNIX machines with connectivity to Microsoft Excel Online. Leverage the native support for ODBC in PHP.

Natively Connect to Excel Online in PHP

The CData ODBC driver for Excel Online enables you to create PHP applications with connectivity to Microsoft Excel Online. Leverage the native support for ODBC in PHP.

Manage Excel Online in DBArtisan as a JDBC Source

Use wizards in DBArtisan to create a JDBC data source for Excel Online.

How to connect to Excel Online in DBVisualizer

Integrate Microsoft Excel Online with visual data analysis tools and data connection wizards in DBVisualizer

Deploy the ADO.NET Provider for Excel Online on an SSRS Report Server

Connect to Microsoft Excel Online 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.

Build AI/ML Models with Live Excel Online Data using Dataiku

Connect Excel Online Data with Dataiku using the [product_name].

Connect to Excel Online from Blazor Apps

Build ASP.NET Core Blazor C# apps that integrate with real-time Microsoft Excel Online using standard SQL.

Create SSAS Tabular Models from Excel Online

How to build a SQL Server Analysis Service Tabular Model from Microsoft Excel Online using CData drivers.

Connect to Excel Online from a Connection Pool in Jetty

The Excel Online JDBC Driver supports connection pooling: This article shows how to connect faster to Microsoft Excel Online from Web apps in Jetty.

How to Visualize Excel Online Data in Python with pandas

Use pandas and other modules to analyze and visualize live Microsoft Excel Online in Python.

Connect to Excel Online in Google Apps Script via SQL Gateway

Use the ODBC Driver for Excel Online and the SQL Gateway to access Microsoft Excel Online from Google Apps Script.

Build Automated Excel Online-Connected Workflows in Zapier

Use CData Connect AI to connect to live Microsoft Excel Online and build automated workflows in Zapier.

How to create Excel Online federated tables in MySQL

Use the SQL Gateway and the ODBC Driver to set up federated tables for Microsoft Excel Online in MySQL .

Visualize Excel Online from Tableau

Use the Tableau Desktop business intelligence tool to connect to Microsoft Excel Online.

Create Informatica Mappings From/To an ODBC Data Source for Excel Online

Create an ODBC connection to Excel Online in Informatica and browse and transfer Microsoft Excel Online.

Connect to and Query Excel Online in QlikView over ODBC

Create data visualizations with Microsoft Excel Online in QlikView.

Query Excel Online using the OData SDK for PHP

Use the API Server and the OData PHP SDK to easily consume Excel Online entities in PHP by modeling them as objects.

Back Up Microsoft Excel Online to SQL Server through SSIS

Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Excel Online. In this article, we will employ an SSIS workflow to populate a database with Microsoft Excel Online data.

Build Data Flows from Excel Online to SQL Server using SSIS

Easily back up Microsoft Excel Online to SQL Server using the SSIS components for Excel Online.

Connect to Live Excel Online in PostGresSQL Interface through CData Connect AI

Create a live connection to Excel Online in CData Connect AI and connect to your Microsoft Excel Online from PostgreSQL.

Build Dashboards with Excel Online in Dundas BI

Create dynamic dashboards and perform analytics based on Microsoft Excel Online in Dundas BI.

Create Apps from Excel Online in Qlik Sense Cloud

Use CData Connect AI to connect to Excel Online and build apps from live Microsoft Excel Online in Qlik Sense Cloud.

Analyze Excel Online with Power Pivot

This article walks you through the process of using the CData ODBC Driver for Excel Online from Power Pivot. You will use the Table Import Wizard to load Microsoft Excel Online. You can visually build the import query or use any SQL supported by the driver.

How to Connect to & Open Excel Online in Microsoft Excel

This article uses the CData ODBC driver for Excel Online to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

Visualize Excel Online in Tableau

The CData ODBC driver for Excel Online enables you integrate Microsoft Excel Online into Tableau dashboards.

Access Live Excel Online in SAS JMP via ODBC

You can use the CData ODBC Driver to integrate Microsoft Excel Online into the statistical analysis tools available in SAS JMP. This article shows how to use Microsoft Excel Online in the Graph Builder and Query Builder.

Migrating data from Excel Online to Google BigQuery using CData SSIS Components.

Easily push Microsoft Excel Online to Google BigQuery using the CData SSIS Tasks for Excel Online and Google BigQuery.

Integrate Excel Online in the Pentaho Report Designer

Publish reports based on Microsoft Excel Online in the Pentaho BI tool.

How to Build an ETL App for Excel Online in Python with CData

Create ETL applications and real-time data pipelines for Microsoft Excel Online in Python with petl.

Visualize Excel Online in TIBCO Spotfire through ODBC

The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Microsoft Excel Online into TIBCO Spotfire.

Use Dash to Build to Web Apps on Excel Online

Create Python applications that use pandas and Dash to build Excel Online-connected web apps.

How to use SQLAlchemy ORM to access Excel Online in Python

Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Microsoft Excel Online.

Connect Excel Online to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

Connect to your Microsoft Excel Online using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

Connect to Excel Online in DBArtisan

Use wizards in DBArtisan to configure Microsoft Excel Online as a data source.

Access Excel Online 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 Microsoft Excel Online.

Connect to Excel Online from Asprova with CData Software ODBC Driver for Excel Online

This article shows how to connect faster to Excel Online data from Asprova.

How to Access Excel Online Using Entity Framework

This article shows how to access Microsoft Excel Online using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

Working with Excel Online in LINQPad

Execute LINQ queries to Microsoft Excel Online in LINQPad.

Migrating data from Excel Online to Snowflake using CData SSIS Components.

Easily push Microsoft Excel Online to Snowflake using the CData SSIS Tasks for Excel Online and Snowflake.

Connect to Excel Online from PowerBuilder via ODBC

This article demonstrates how to use the CData ODBC Driver for Excel Online to connect to Microsoft Excel Online and execute queries in PowerBuilder.

How to connect SharePoint with Excel Online through external lists

Provide Microsoft Excel Online to SharePoint users as an external list.

Automate Excel Online Integration Tasks from PowerShell

Are you in search of a quick and easy way to access Microsoft Excel Online from PowerShell? This article demonstrates how to utilize the Excel Online Cmdlets for tasks like connecting to Microsoft Excel Online, automating operations, downloading data, and more.

Visualize Live Excel Online in Tableau

Use CData Tableau Connectors and Tableau Desktop to visualize live Microsoft Excel Online.

Integrate with Excel Online in JReport Designer

Create charts and reports based on Microsoft Excel Online in JReport Designer.

How to connect PolyBase to Excel Online

Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Microsoft Excel Online.

DataBind Excel Online to the DevExpress Data Grid

Use the CData Software ADO.NET Provider for Excel Online with the DevExpress Windows Forms and Web controls to provide Microsoft Excel Online to a chart.

Import and Visualize Excel Online in Power View

Create data visualizations based on Microsoft Excel Online in Excel.

Create an SAP BusinessObjects Universe on the CData JDBC Driver for Excel Online

Provide connectivity to Microsoft Excel Online through an SAP BusinessObjects universe.

Query Excel Online from Node.js

Use the OData endpoint of the CData API Server to connect to your Microsoft Excel Online and perform CRUD operations on Excel Online from Node.js.

How to Use a Microsoft Access Database to Update Excel Online in Real Time

Update Excel Online data by creating a linked table in Microsoft Access with the CData Excel Online ODBC Driver.

Using the CData Software ODBC Driver for Excel Online in PyCharm

Connect to Excel Online as an ODBC data source in PyCharm using the CData Software ODBC Driver for Excel Online.

Connect to Excel Online in RazorSQL

Connect to Excel Online from wizards and query Microsoft Excel Online from the GUI in the RazorSQL database management tool.

Connect to Excel Online from PowerBuilder via JDBC

This article demonstrates how to access Microsoft Excel Online from PowerBuilder using the Excel Online JDBC Driver.

LINQ to Excel Online

LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Excel Online Data Provider.

How to connect to Excel Online from IntelliJ

Integrate connectivity to Microsoft Excel Online with wizards in IntelliJ.

Analyze Excel Online in Infragistics Reveal

Use the CData API Server to create an OData API on top of Microsoft Excel Online and visualize live Microsoft Excel Online in Infragistics Reveal.

Extract, Transform, and Load Excel Online in Informatica PowerCenter

Create a simple Workflow for Microsoft Excel Online in Informatica PowerCenter.

Integrating Excel Online in Talend Cloud Data Management Platform

Connect Excel Online with Talend Cloud Data Management Platform using the [product_name].

Feed Excel Online into FineReport

How to set Microsoft Excel Online as a JDBC data source in FineReport.

Connect to and Visualize Live Excel Online in Tableau Prep

Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft Excel Online.

Build Data Flows from SQL Server to Excel Online through SSIS

Easily push SQL Server data to Excel Online using the CData SSIS Tasks for Excel Online.

ETL Excel Online in Oracle Data Integrator

This article shows how to transfer Microsoft Excel Online into a data warehouse using Oracle Data Integrator.

Connect to Excel Online from PowerBuilder via ADO.NET

This article demonstrates how to access Microsoft Excel Online from Appeon PowerBuilder using the CData ADO.NET Provider for Excel Online.

Connect to Excel Online in Jaspersoft Studio

Execute SQL to remote Microsoft Excel Online in Jaspersoft Studio.

Connect to Excel Online in Aqua Data Studio

Access Microsoft Excel Online from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

Replicate Excel Online from PowerShell

Write a quick PowerShell script to query Microsoft Excel Online. Use connectivity to the live data to replicate Microsoft Excel Online to SQL Server.

How to create Visio diagrams from Excel Online

Automatically update Microsoft Excel Online with the changes you make to Visio master shapes.

Connect to Excel Online as a Linked Server via SQL Gateway

Use the SQL Gateway and the ODBC Driver to set up a linked server for Microsoft Excel Online.

Use CData Connect AI to Access Excel Online in Microsoft Power Pivot

Use CData Connect AI to connect to live Microsoft Excel Online in the Power Pivot business intelligence tool.

Connect to Excel Online in RapidMiner

Integrate Microsoft Excel Online with standard components and data source configuration wizards in RapidMiner Studio.

Consume Excel Online OData Feeds in SAP Lumira

Use the API Server to create data visualizations on Excel Online feeds that reflect any changes in SAP Lumira.

How to Query Live Excel Online Data in Natural Language in Python using LlamaIndex

Use LlamaIndex to query live Microsoft Excel Online data in natural language using Python.

Provide OData Services of Excel Online from a WCF Application

In this article, we will demonstrate the process of generating an OData feed for Microsoft Excel Online by developing a WCF Service Application.

Connect to Excel Online in NetBeans

Connect to Microsoft Excel Online in NetBeans with the data source configuration wizard.

Viewing Excel Online in RAD Studio Data Explorer

How to view Microsoft Excel Online in RAD Studio Data Explorer using the CData ODBC Driver for Excel Online.

Integrate Live Excel Online into Blue Prism for Intelligent Robotic Process Automation (RPA)

Connect live Microsoft Excel Online to Blue Prism using the [product_name] to create automated workflows for repetitive business tasks.

Migrating data from Excel Online to Databricks using CData SSIS Components.

Easily push Microsoft Excel Online to Databricks using the CData SSIS Tasks for Excel Online and Databricks.

Create Reports with Excel Online in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Microsoft Excel Online.

PowerShell Scripting to Replicate Excel Online to MySQL

Write a simple PowerShell script to replicate Microsoft Excel Online to a MySQL database.

Visualize Excel Online in TIBCO Spotfire through OData

Integrate Microsoft Excel Online into dashboards in TIBCO Spotfire.

How to Connect to Excel Online in Using Python: 6 Steps

Create Python applications on Linux/UNIX machines with connectivity to Microsoft Excel Online. Leverage the pyodbc module for ODBC in Python.

Edit and Search Excel Online External Objects in Salesforce Connect (API Server)

Use the API Server to securely provide OData feeds of Microsoft Excel Online to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Excel Online objects that you can access from apps and the dashboard.

Create an SAP BusinessObjects Universe on the CData ODBC Driver for Excel Online

Provide connectivity to Microsoft Excel Online through an SAP BusinessObjects universe.

Visualize Excel Online in TIBCO Spotfire through ADO.NET

Integrate Microsoft Excel Online into dashboards in TIBCO Spotfire.

How to connect to Excel Online with Squirrel SQL client

Connect to Microsoft Excel Online and execute queries in the Squirrel SQL Client.

Analyze Excel Online in Slingshot with CData API Server

Use the CData API Server to build an OData API on top of Microsoft Excel Online and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.

Publish Reports with Excel Online in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Microsoft Excel Online.

Query Excel Online in ColdFusion

Write standard ColdFusion data access code to connect to Microsoft Excel Online.

Build Charts with Excel Online in Clear Analytics

Create dynamic charts and perform analytics based on Microsoft Excel Online in Clear Analytics.

Publish Excel Online-Connected Dashboards in Tableau Server

Use CData Tableau Connectors and Tableau Server to visualize live Microsoft Excel Online.

Object-Relational Mapping (ORM) with Excel Online 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 Microsoft Excel Online into a Java-based ORM framework, Hibernate.

Build an OLAP Cube in SSAS from Excel Online

Establish a connection to Microsoft Excel Online data from SQL Server Analysis Services, and use the Excel Online Data Provider to build OLAP cubes for use in analytics and reporting.

Build a Simple VCL Application for Excel Online

How to build a simple VCL Application to view Microsoft Excel Online in RAD Studio using the CData ODBC Driver for Excel Online.

Connect to Excel Online in JRuby

Create a simple JRuby app with access to live Microsoft Excel Online.

Connect to Excel Online in RunMyProcess through Connect AI

Use CData Connect AI to create on OData API for Excel Online and connect to Microsoft Excel Online in Akorbi Digital RunMyProcess.

DataBind Controls to Excel Online in Delphi

DataBind to Microsoft Excel Online in Delphi with standard data access components and controls.

Bidirectional Access to Excel Online from FileMaker Pro

Use the MySQL Remoting feature of the JDBC driver to integrate Microsoft Excel Online in Filemaker Pro for Mac or Windows.

Analyze Excel Online in SAP Analytics Cloud

Use CData Connect AI to create an OData API on top of Microsoft Excel Online and visualize Microsoft Excel Online in SAP Analytics Cloud.

Connect to Excel Online in CloverDX (formerly CloverETL)

Transfer Microsoft Excel Online using the visual workflow in the CloverDX data integration tool.

Analyze Excel Online in Infragistics Reveal

Use CData Connect AI to create on OData API on top of Microsoft Excel Online and visualize live Microsoft Excel Online in Infragistics Reveal.

Connect to Excel Online Using the Script Function in Claris FileMaker Pro

Use the [product_name] and the Script function in FileMaker Pro to connect to Excel Online and work with Microsoft Excel Online in your FileMaker application.

Publish Excel Online-Connected Dashboards in Tableau Server via JDBC

Use CData JDBC drivers and Tableau Server to visualize live Microsoft Excel Online.

Connect to Excel Online in Google Apps Script via Connect AI

Use CData Connect AI to access Microsoft Excel Online in Google Apps Script.

Design BIRT Reports on Excel Online

Provide current Microsoft Excel Online to your embedded analytics.

Load Excel Online to a Database Using Embulk

Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft Excel Online to a database.

Work with Excel Online in FoxPro

Load Microsoft Excel Online into a FoxPro database. This article includes full code and a walk-through of the process.

Building Dynamic Web Pages with Excel Online Using AngularJS

Create single-page applications with live connectivity to Excel Online using the CData API Server.

Connect to Excel Online in Claris FileMaker Pro

Use the [product_name] in FileMaker Pro to connect to Excel Online and work with Microsoft Excel Online in your FileMaker applications.

How to publish and share Excel Online dashboards with Tableau Server

The CData ODBC driver for Excel Online enables you integrate Microsoft Excel Online into Tableau dashboards.

Build MVC Applications with Connectivity to Excel Online

This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Excel Online from an ASP.NET MVC application.

Edit and Search External Excel Online Objects in Salesforce Connect

Use CData Connect AI to securely provide OData feeds of Microsoft Excel Online to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Excel Online objects that you can access from apps and the dashboard.

Access Excel Online as a Remote Oracle Database

Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Microsoft Excel Online from your Oracle system.

Enable the Excel Online JDBC Driver in KNIME

Use standard data access components in KNIME to create charts and reports with Microsoft Excel Online.

Publish Crystal Reports on Excel Online

Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Microsoft Excel Online.

How to Import Data from Excel Online into Google Sheets

Import Microsoft Excel Online into a Google spreadsheet that is automatically refreshed.

Connect to Excel Online from a Connection Pool in WebLogic

Use the CData JDBC Driver for Excel Online to connect to Microsoft Excel Online from Web applications running on WebLogic.

Build Dashboards with Excel Online in DBxtra

Create dynamic dashboards and perform analytics based on Microsoft Excel Online in DBxtra.

Use the CData ODBC Driver for Excel Online from SharePoint Excel Services

This article demonstrates how to use the CData ODBC Driver for Excel Online to connect to Microsoft Excel Online from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Microsoft Excel Online in Excel.

Build Excel Online-Connected Web Apps with Axios and CData Connect AI

Use CData Connect AI to connect to live Microsoft Excel Online and build Excel Online-connected web apps with Axios.

Explore Geographical Relationships in Excel Online with Power Map

Create data visualizations with Microsoft Excel Online in Power Map.

Connect to Excel Online in SpagoBI

Create reports featuring live Microsoft Excel Online in SpagoBI Studio. Host Excel Online reports on SpagoBI Server.

Consume Excel Online OData Feeds in PowerBuilder

This article demonstrates how to consume Microsoft Excel Online as OData feeds from PowerBuilder using the API Server.

DataBind Controls to Excel Online in C++Builder

DataBind to Microsoft Excel Online in C++Builder with standard components and controls.

Connect to Excel Online through External Services in Salesforce

Use CData Connect AI to securely connect Salesforce External Services with Excel Online using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

Create Informatica Mappings From/To a JDBC Data Source for Excel Online

Create Excel Online data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

Visualize Excel Online in Sisense

Create an ElastiCube in Sisense app with access to Microsoft Excel Online.

Connect to Excel Online in Ruby

Connect to Microsoft Excel Online in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

How to Connect DBeaver to Excel Online via a JDBC Driver

Manage Microsoft Excel Online with visual tools in DBeaver like the query browser.

Create Data Visualizations in Cognos BI with Excel Online

Access Microsoft Excel Online as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

Configure the CData JDBC Driver for Excel Online in a Connection Pool in Tomcat

Connect to Microsoft Excel Online from a connection pool in Tomcat.

Connect to Excel Online from a Connection Pool in JBoss

Integrate Microsoft Excel Online into Java servlets: Use the Management Console in JBoss to install the Excel Online JDBC Driver.

Extend Google Sheets with Excel Online

Make calls to the API Server from Google Apps Script.

Create Dynamic Excel Online Grids Using the Infragistics XamDataGrid

Learn how you can connect Excel Online to Infragistics XamDataGrid to build dynamic grids.

Establish a Live Connection with Excel Online using Tableau Bridge

The CData ODBC Driver for Excel Online enables you to integrate live Microsoft Excel Online into Tableau Cloud dashboards using the Tableau Bridge.

Integrate Excel Online in Pentaho Data Integration

Build ETL pipelines based on Microsoft Excel Online in the Pentaho Data Integration tool.

Natively Connect to Excel Online in PHP via ODBC (Linux)

Create PHP applications on Linux/UNIX machines with connectivity to Microsoft Excel Online. Leverage the native support for ODBC in PHP.

Natively Connect to Excel Online in PHP

The CData ODBC driver for Excel Online enables you to create PHP applications with connectivity to Microsoft Excel Online. Leverage the native support for ODBC in PHP.

Manage Excel Online in DBArtisan as a JDBC Source

Use wizards in DBArtisan to create a JDBC data source for Excel Online.

How to connect to Excel Online in DBVisualizer

Integrate Microsoft Excel Online with visual data analysis tools and data connection wizards in DBVisualizer

Deploy the ADO.NET Provider for Excel Online on an SSRS Report Server

Connect to Microsoft Excel Online 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.

Build AI/ML Models with Live Excel Online Data using Dataiku

Connect Excel Online Data with Dataiku using the [product_name].

Connect to Excel Online from Blazor Apps

Build ASP.NET Core Blazor C# apps that integrate with real-time Microsoft Excel Online using standard SQL.

Create SSAS Tabular Models from Excel Online

How to build a SQL Server Analysis Service Tabular Model from Microsoft Excel Online using CData drivers.

Connect to Excel Online from a Connection Pool in Jetty

The Excel Online JDBC Driver supports connection pooling: This article shows how to connect faster to Microsoft Excel Online from Web apps in Jetty.

How to Visualize Excel Online Data in Python with pandas

Use pandas and other modules to analyze and visualize live Microsoft Excel Online in Python.

Connect to Excel Online in Google Apps Script via SQL Gateway

Use the ODBC Driver for Excel Online and the SQL Gateway to access Microsoft Excel Online from Google Apps Script.

Build Automated Excel Online-Connected Workflows in Zapier

Use CData Connect AI to connect to live Microsoft Excel Online and build automated workflows in Zapier.

How to create Excel Online federated tables in MySQL

Use the SQL Gateway and the ODBC Driver to set up federated tables for Microsoft Excel Online in MySQL .

Visualize Excel Online from Tableau

Use the Tableau Desktop business intelligence tool to connect to Microsoft Excel Online.

Create Informatica Mappings From/To an ODBC Data Source for Excel Online

Create an ODBC connection to Excel Online in Informatica and browse and transfer Microsoft Excel Online.

Connect to and Query Excel Online in QlikView over ODBC

Create data visualizations with Microsoft Excel Online in QlikView.

Query Excel Online using the OData SDK for PHP

Use the API Server and the OData PHP SDK to easily consume Excel Online entities in PHP by modeling them as objects.

Back Up Microsoft Excel Online to SQL Server through SSIS

Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Excel Online. In this article, we will employ an SSIS workflow to populate a database with Microsoft Excel Online data.

Build Data Flows from Excel Online to SQL Server using SSIS

Easily back up Microsoft Excel Online to SQL Server using the SSIS components for Excel Online.

Connect to Live Excel Online in PostGresSQL Interface through CData Connect AI

Create a live connection to Excel Online in CData Connect AI and connect to your Microsoft Excel Online from PostgreSQL.

Build Dashboards with Excel Online in Dundas BI

Create dynamic dashboards and perform analytics based on Microsoft Excel Online in Dundas BI.

Create Apps from Excel Online in Qlik Sense Cloud

Use CData Connect AI to connect to Excel Online and build apps from live Microsoft Excel Online in Qlik Sense Cloud.