Repository Database in Azure SQL Managed Instance - DSS 6 | Data Source Solutions Documentation
Documentation: Repository Database in Azure SQL Managed Instance - DSS 6 | Data Source Solutions Documentation
Repository Database in Azure SQL Managed Instance
Data Source Solutions DSS allows you to create repository database in Azure SQL Managed Instance.
It is recommended to create a new database (schema) for DSS repository. If an existing database is to be used for DSS repository, then the DSS repository tables can be separated by creating a new database schema and associating it with DSS's user as follows:
create schema <em>schemaname</em>;
Grants for Repository Database
The following grants are required for the repository database user in Azure SQL Managed Instance:
grant create table to <em>username</em>;
grant create procedure to <em>username</em>;
grant select, insert, delete, update on schema::<em>schemaname</em> to <em>username</em>;
grant control on schema::<em>schemaname</em> to <em>username</em>;
alter user <em>username</em> with default_schema=<em>schemaname</em>;
Repository Database Connection
This section describes the details required for connecting to the repository database in Azure SQL Managed Instance:
| Field | Description | Equivalent Hub Server Property |
|---|---|---|
| SERVER | Fully qualified host name of the Azure SQL Managed Instance. The format for this field is:
|
SqlServer_Server |
| DATABASE | Name of the database in Azure SQL Managed Instance. | Database_Name |
| AUTHENTICATION METHOD | Authentication method for connecting DSS to Azure SQL Managed Instance database. Available options are:
|
SqlServer_Authentication_Method |
| OAUTH2 ENDPOINT | URL used for obtaining the bearer token with credential token. Ensure that you are using the OAuth 2.0 endpoint. The URL path should include v2.0. The format for the endpoint URL is |
Azure_OAuth2_Endpoint |
| CLIENT ID | Client ID used to obtain Microsoft Entra ID (formerly Azure Active Directory) access token. This field is available only if the AUTHENTICATION METHOD is set to Access Token. |
Azure_OAuth2_Client_Id |
| CLIENT SECRET KEY | Secret key of the CLIENT ID. | Azure_OAuth2_Client_Secret |
| USER | Username for connecting DSS to the database in Azure SQL Managed Instance. This field is available only if the AUTHENTICATION METHOD is set to User and Password or Microsoft Entra ID. For Azure SQL Database, if the AUTHENTICATION METHOD is set to User and Password, this is the user name and host name of the Azure SQL Database server. The format to be used is username@hostname. Example: dssuser@cbiz2nhmpv |
Database_User / Azure_OAuth2_User |
| PASSWORD | Password for the USER. | Database_Password |
Advanced Settings
| Field | Description | Equivalent Hub Server Property |
|---|---|---|
| LINUX / UNIX ODBC DRIVER MANAGER LIBRARY PATH |
Directory path where the ODBC Driver Manager Library is installed. This field is applicable only for Linux/Unix operating system. For a default installation, the ODBC Driver Manager Library is available at /usr/lib64 and does not need to be specified. However, when UnixODBC is installed in for example /opt/unixodbc the value for this field would be /opt/unixodbc/lib. |
ODBC_DM_Lib_Path |
| LINUX / UNIX ODBCSYSINI | Directory path where the odbc.ini and odbcinst.ini files are located. This field is applicable only for Linux/Unix operating system. For a default installation, these files are available at /etc directory and do not need to be specified using this field. However, when UnixODBC is installed in for example /opt/unixodbc the value for this field would be /opt/unixodbc/etc. |
ODBC_Sysini |
| ODBC DRIVER | Name of the user defined (installed) ODBC driver used for connecting DSS to the Azure SQL Managed Instance. | ODBC_Driver |