Follow

Configure Discovery Hub® with Azure SQL Single Database and Azure Analysis Services

Overview

This guide will cover how to deploy and configure your environment using the Azure Marketplace App: Discovery Hub and Azure SQL DB and AAS

The deployment of the Azure resources will vary depending on Azure resource availability. Deploying Azure SQL Single Database and Azure Analysis Services generally takes ~15. Configuring your Discovery Hub environment generally takes ~20 minutes.

Complete the following steps to configure Discovery Hub with Azure Single Database and Azure Analysis Services:

  1. Configure Accounts and Permissions
  2. On-Premise Data Gateway Setup and Configuration
  3. Find the server names
  4. Connect to the virtual machine
  5. Configure the Discovery Hub Environment
    • Activate Discovery Hub
    • Add a Modern Data Warehouse
    • Add Azure Analysis Service Tabular Model
  6. Configure the ODX Server

1. Deploy Discovery Hub® and Azure SQL Database and Azure Analysis Services

  1. Go to https://azuremarketplace.microsoft.com/en-us/marketplace/
  2. If you are not signed in to your account, sign in now
  3. In the Azure Marketplace, perform a search for TimeXtender
  4. Select the deployment option from the search results.
  5. Scroll down and select Get it Now and then select Continue. You will be redirected to a page that contains a wizard for creating your resources.
  6. In Step 1 of the wizard, configure basic settings, and then click OK

AzureSQLDB_AAS.png

Setting Description Default Value Requirements
Virtual Machine Name The name of the virtual machine Discoveryhub-vm Must be between 3 and 79 characters long and contain letters, numbers and hyphens only.
Subscription The subscription to place the resources in    
Resource Group The resources group that will contain all deployment items   Must be an empty resource group
Location Location of the resource group    

 

7. In Step 2 of the wizard, configure the SQL Server’s resources and settings, and then click OK.

AzureSQLDB_AASStep2.png

Setting

Description

Default Value

Requirements

Admin Username

Administrator for Azure SQL logical server

 

Alphanumeric characters between 2-30 characters long. Cannot contain any invalid usernames (i.e. admin, root, etc.)

Admin Password

Administrator password for Azure SQL logical server

 

Must contain at least 12 characters, with at least 1 letter and 1 number.

Confirm Password

 

 

Must contain at least 12 characters, with at least 1 letter and 1 number.

Enable Advanced Threat Protection

A unified security package for discovering and classifying sensitive data, surfacing and mitigating potential database vulnerabilities, and detecting anomalous activities that could indicate a threat to your database.

No

 

Allow Azure services to access server

Enable this to allow applications from Azure to connect to this server. Examples of when you would want to enable this: using the Query editor in the portal or connecting your Azure VM to your Azure SQL database. 

Yes

 

 

8. In Step 3 of the wizard, configure the Analysis Services resources and settings, and then click OK.

AzureSQLDB_AASStep3.png

Setting

Description

Default Value

Requirements

Pricing Tier

Choose the tier (size) of Azure Analysis Services

 

Must be a valid Azure Active Directory user

Administrator

Administrator of Azure Analysis Services

 

Must be a valid Azure Active Directory user

 

9. In Step 4 of the Wizard, configure the Virtual Machine’s resources and settings and click OK.

AzureSQLDB_AASStep4.png

Setting

Description

Default Value

Requirements

Virtual machine password

Administrator username for the virtual machine

 

Cannot be the name “Administrator”

Administrator’s password

Password for the virtual machine administrator

 

The password must contain at least 12 characters, with at least 1 letter and 1 number

Confirm Password

 

 

Must contain at least 12 characters, with at least 1 letter and 1 number

Virtual Machine Size

Size of the virtual machine

Standard_DS2_V2 

 

Diagnostic storage account

Select an existing storage account or create a new one.

<virtual machine name>-randomly generated number

Must be unique

Public IP Address for the VM

Select an existing IP address or create a new one

<virtual machine name>-ip

 

DNS Prefix for the public IP Address

DNS prefix for the public IP address

<virtual machine name>-randomly generated number

Must be unique

Virtual Network

Select an existing virtual network or create a new one

VirtualNetwork

 

Virtual Network Address Space

Address space for the virtual network

10.0.0.0/16

Minimum /29 prefix

Subnet name

Name of the subnet that will contain the application server

Subnet

 

Subnet Address Prefix

Address range for the managed instance subnet

10.0.0.0/24

Minimum /29 prefix

  1. In Step 5 of the Wizard, confirm the summary settings by clicking
  2. In Step 6 of the wizard, review the terms of the agreements and click Create to initialize the deployment to the resource group you chose.

 

*Please note that deployment time will vary depending on Azure resource availability. Select the Notifications icon at the top to view the status of your deployment

2. Configure Accounts and Permissions

Ensure the users, user groups, and service accounts have the necessary access and rights to the new server. Below are the required access and rights.

Accounts 

User Accounts 

Identify and/or create the following user accounts. Azure Active Directory (AAD), is recommended if using the Hybrid or Cloud configurations but the permissions are the same for local Active Directory (AD). If utilizing Azure Analysis Services then Azure Active Directory is required.  

  1. One user account for each Discovery Hub developer. 
  2. One Service Account must be created for each “non-development” environment. These will be used to run the Discovery Hub Multiple Environment and Scheduler Services. 

Security Group 

Create an Active Directory (AD) Security Group called TXDevelopers and add the developer user accounts. This will make it easier to apply permissions as developers work on and off the project. 

Application Server 

Local or Domain Administrator on the Application Server. This is required to be able to start and stop services. 

Database Permissions

Azure SQL Database 

The following permissions are needed when using Azure SQL DB: 

  • Data sources – db_datareader 
  • Target databases - Server admin, Azure Active Directory admin or dbmanager role in the master database. If hosting the project repository in Azure SQL DB then a SQL account is required. If using contained database users, then use the db_owner role. 

See the following article for more information on Azure SQL Database logins: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-manage-logins

Azure Analysis Services 

The following permissions are needed when using Azure Analysis Services (AAS): 

  • Analysis Services Admin permissions based from an Azure Active Directory login.

3. Find the Server Names

1. Once your items have been deployed to your resource group, navigate to the resource group in Azure that contains all of the deployment items. This was assigned when configuring basic settings.

2. While viewing the Resource Group that contains all of your deployment items, find the SQL Server and click on it.

3. Scroll-down the menu bar to find Properties and click on it. Once you click on Properties there will be a field called Server Name. Save this name somewhere safe because it will be needed for configuring your Discovery Hub®

AzureServerName.png

4. To find the server name for Azure Analysis Services, go back to your Resource Group, find your Analysis Services resource and click on it.

5. When viewing the Overview section of the menu bar, there will be a field named Management Server name. Save this name somewhere safe because it will be needed for AAS endpoint.

AAS_Server_Name.png

4. On-Premise data gateway setup and configuration

If you are connecting to on-premises data sources, you will need to configure an on-premises data gateway to provide secure data transfer between on-premises data sources and your Azure Analysis Services servers in the cloud.

5. Connect to the Virtual Machine

1. In order to activate and configure Discovery Hub, connect to the application server deployed on Azure. Navigate to the resource group in Azure that contains all of the deployment items. 

2. Locate the Virtual Machine in the resource group and click on it.

3. While viewing the page for the virtual machine, click Connect and download the RDP

4. Open the RDP file once it has downloaded and click Connect

5. Enter in the credentials to connect to the virtual machine that you created earlier and click Ok to connect.

Connect_to_VM.png

6.Configure the Discovery Hub® Environment

Activate Discovery Hub

Once you are connected to the Virtual Machine, activate your Discovery Hub instance following the instructions below to set up the project repository and ensure that the Discovery Hub Scheduler service is up and running. The latest version of Discovery Hub is already downloaded and installed on the virtual machine so you can skip steps 1-7 on the accompanying article.

Configure the Discovery Hub Environment

 

Add a Modern Data Warehouse

1. Once you have created your project, right-click Data Warehouse, and then select Add Data Warehouse

Add_DW_1.png

2. In the Name field, type a name for the data warehouse. The name cannot exceed 15 characters in length

3. In the Server Name field, enter the server name for the database you created.

4. In the Database field, type the name of a new database, and then click Create

5. Select SQL Server Authentication and enter the SQL Server credentials that you created earlier.

Add_DW_2.png

6. Click OK to close the window and return to Discovery Hub.

Adding Azure Analysis Services Tabular Model

  1. In Discovery Hub®, go to the Semantic tab, right-click on Models and select Add Semantic Model.
  2. Give your semantic model a name and click OK
  3. Expand your new model, right-click on Endpoints, and select Add Analysis Services Tabular Endpoint
  4. In the Name field, type a name for the endpoint.
  5. In the Server Name field, enter the server name for the Azure Analysis Services deployed earlier.
  6. In the Database field, type the name of a new or existing database.
    • If you type in the name for a new database, it will not appear in Analysis Services until you deploy your model.
  7. Select SQL Server Authentication and type in the Azure Analysis Services credentials that you assigned earlier.
    • You can use the service account, but only if it has rights on the Azure Analysis Services server.
  8. Click OK to close the window and return to Discovery Hub.

7. Configure the ODX Server

 

Please see the article, Configure and Manage the ODX Server, for configuring the ODX Server using SQL Server data storage.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.