TABLE OF CONTENTS

• Using a Single Email Address for Multiple Datamining Accounts
  • Overview
  • Account Creation Constraints
  • Solution: Plus Addressing for Email Aliases
    • Steps
  • Use Case Example
  • Auth Tokens for Scripted Access
    • Key Points
      • Example Auth Token
  • Related Articles
• Further Support

Using a Single Email Address for Multiple Datamining Accounts

Overview

ManagementStudio supports providing live data to applications such as Power BI through Datamining endpoints. Secure access to this data often requires authenticated ManagementStudio user accounts, each associated with a unique email address. This article explains how administrators can create and manage multiple Datamining user accounts using variations of a single email address.

Account Creation Constraints

When adding a new user account in ManagementStudio, the following fields are required:

• Username
• First Name
• Last Name
• Email address

ManagementStudio prevents the creation of multiple accounts using the same email address across all projects. Administrators cannot reuse their own email address directly for additional Datamining accounts.

Solution: Plus Addressing for Email Aliases

To create multiple accounts tied to the same base email address, you can use “plus addressing”—a feature supported by email providers such as Microsoft Exchange and Gmail.

Steps

1. When prompted for an email during new account creation, use a plus alias format:

   • Original email: bonnie.smith@thiscompany.com
   • Alias email: bonnie.smith+MigrationStatusPowerBIReport@thiscompany.com

2. Complete the account creation process as normal. ManagementStudio will recognise this as a unique email address and allow account creation.

3. The alias delivers mail to the original mailbox. The user can receive system notifications, including password reset emails, for the new account.

Note: Ensure that your organisation’s mail system supports plus addressing. Test this by sending an email to a plus alias before deploying this method.

Use Case Example

An administrator needs to provide authenticated access to a Power BI Datamining endpoint. By creating a new user account using a plus alias of her email, she receives the password configuration email in the same mailbox, enabling secure endpoint access for the Power BI integration.

Auth Tokens for Scripted Access

ManagementStudio allows generation of authentication (Auth) tokens for user accounts. Auth tokens can be used in scripts, Power BI, or REST calls to the Datamining engine.

Key Points

• Tokens are generated for a specific user account.
• The administrator must know the account password to create a token.
• Tokens are displayed only at creation and cannot be recovered later.
• Deleting or disabling the user account disables all tokens associated with it.
• Expiry date is set when the token is created.
• One account can have multiple tokens.

Example Auth Token

eyJhbGciOiJIUzI1NiIrInR5cCI6IkpXVCJ9.eyJodHRwOi8vc2NoZW1hcy54bWxzb2FwLm9yZy93cy8yMDA1LzA1L2lkZW50aXR5L2NsYWltcy9uYW1lIjoiRGF2ZSIsImlzcyI6Imh0dHA6Ly9NYW5hZ2VtZW50U3R1ZGlvLmNvbSIpFGImF1ZCI6Imh0dHA6Ly9991NYW5hZ2VtZW50U3R1ZGlvLmNvbSIsIm5iZiI6IjE3MzMyMjIwNzIiLCJleHYYWAiOiIxNzM1NjA0NTEyIn0.d5qfcPRKKXjmFBh_FqgyhFfbTxCV6VyZXE05VyVy4_s

Related Articles

• REST API Endpoints

Further Support

For additional assistance, visit the ManagementStudio Service Desk to search the knowledge base or submit a support ticket.