Export (0) Print
Expand All

Business Intelligence Governance automation using Windows PowerShell

SharePoint 2013
 

Applies to: SharePoint Server 2013 Enterprise

Topic Last Modified: 2013-12-18

Summary: Automate requests for data access by using Windows PowerShell, SharePoint lists, and workflows.

The articles in this section describe three scenarios in which you can use Windows PowerShell to automate your business processes.

Using Windows PowerShell to automate your business processes allows you to ensure that they are followed the same way each time they are used, giving you predictable results. It can also save your administrators some time by automating processes that might otherwise require a user to file a help ticket.

The purpose of these articles is to show some ideas around how to automate processes by using features like Windows PowerShell and SharePoint workflows. While these scenarios are specific to the business intelligence scenario of granting users access to data sources, the ideas can be applied to other areas also.

  • Self-service data access   In this scenario, a user requests access to a data source by using a SharePoint list and the requested access is configured automatically by the Windows PowerShell script.

    This scenario is covered in Self-service data access using Windows PowerShell.

  • Department-specific data access   In this scenario, a user requests access to a data source by using a SharePoint list and the Windows PowerShell script grants a specific level of access based on the user’s Department in Active Directory.

    This scenario is covered in Department-specific data access using Windows PowerShell.

  • Admin-approved data access   In this scenario, a user requests access to a data source by using a SharePoint list. The request is then copied by a workflow to another SharePoint list where administrators can approve or reject requests. The Windows PowerShell script processes those requests that the administrator approved.

    This scenario is covered in Admin-approved data access using Windows PowerShell.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft