Skip to main content

Datometry Documentation

Preparing for Deployment of Hyper-Q on Azure Synapse

Before you deploy Hyper-Q verify that the Microsoft Azure environment meets the following requirements.

Hyper-Q Software and License

Datometry makes available the following items necessary for installation. These files need to be copied to the Hyper-Q VM for installation.

Table 1. Hyper-Q Software and License

Hyper-Q Filename

Description

hyperq-version-cloud_database.tar.gz

RPM packages with which to install the Hyper-Q software.

dtm.lic

License file specific to your subscription.



Azure Synapse Instance

You must have available the name of the Azure Synapse instance, hostname, and network port to which clients can connect. To learn more, see the article Azure Synapse Analytics in the Microsoft Azure documentation.

Azure Subscription Privileges and Credentials

You must have the following privileges within the Azure subscription and credentials on the Azure Synapse instance to which you are connecting Hyper-Q. You need these credentials to install, not to operate, the system. The installation automatically creates an account with which to operate Hyper-Q.

Caution

Avoid using highly privileged user IDs such as an overall Azure administrative account. Datometry defaults to the customer’s information access management (User Management) policies for individuals that need access to the system. Password requirements are as recommended by the customer.

Permissions in the Azure Subscription

The user performing the installation must have an account in the Azure subscription, with permissions to provision virtual machines within that subscription. To learn more, see Azure Synapse Analytics in the Microsoft Azure documentation.

Permissions in Azure Synapse

You must create several database objects in the Azure Synapse instance. Therefore, you must have sufficient permissions to perform the following operations in the Azure Synapse Analytics instance that you are connecting to Hyper-Q:

  • Create a schema.

  • Create a user.

  • Create a role.

  • Add a user to the newly created role.

  • Permission to create a login in the master database.

Access to the Microsoft ODBC Suite

Access to the Microsoft ODBC Suite URL from within your Azure subscription is required to register the Microsoft ODBC driver and mssql-tools package.

Verify that you have access to the following URL:

https://packages.microsoft.com/config/rhel/7

Note

If the Microsoft ODBC Suite URL is not accessible from within your Azure subscription due to restrictive policies, you can install the packages manually. You must first download the ODBC drivers outside of your Azure subscription, and then upload them to the virtual machine you create to run Hyper-Q.