Excel Services Application: New Excel DataProvider In SharePoint 2013 Using PowerShell

This course will help you learn the basics or refresh your knowledge and then, provide a deeper understanding of advanced features to anyone interested in learning SharePoint 2013 from beginners to advanced users.

In this blog, we will learn how to add a new data provider to Excel Services Application using PowerShell cmdlets. SharePoint 2013 is a collaboration environment that organizations of all sizes can use to increase the efficiency of business processes.

Excel Service Application
  1. Excel Services is a business intelligence tool that allows you to share data-connected workbooks across an organization.
  2. Excel Services in SharePoint Server 2013 is a shared service that you can use to publish Excel 2013 workbooks on SharePoint Server.
Why we use these commands

Excel Services Application loads only workbooks that are stored in a trusted file location.

Steps
  • Open your SharePoint Management Shell.
  • Copy the below code.
  • Run this one.

    New-SPExcelDataProvider -ExcelServiceApplication <SPExcelServiceApplicationPipeBind> -ProviderId <String> -ProviderType <Oledb | Odbc | OdbcDsn> [-AssignmentCollection <SPAssignmentCollection>] [-Confirm [<SwitchParameter>]] [-Description <String>] [-WhatIf [<SwitchParameter>]]
Example

Get-SPExcelServiceApplication -identity "ExcelServiceApplication" | New-SPExcelDataProvider -providerID "DEMOOLEDB" -ProviderType OleDb -description "This is a DEMO OLEDB provider"

Conclusion

Was my blog helpful? If yes, please let me know and if not, please explain what was confusing or missing.

I’ll use your feedback to double-check the facts, add info and update this blog.
Ebook Download
View all
Learn
View all