Step 1) Required Resources

Lakehouse Optimizer requires the following resources to already be created:

• Azure Resource Requirements

Step 2) Configuration Prerequisites

• Azure KeyVault needs to be preconfigured with the following secrets:

  • msft-provider-auth-secret - This is the Service Principal client secret

  • mssql-password - The SQL database password

  • storage-account-key - The access key used for the Azure storage account.
    Note: this is optional, needed only if you don’t want to access the storage account using the Service Principal.

  • application-encryption-secret - used for app encryption. This value is essentially a random string password, so generate accordingly.

...

• https://blueprinttechnologies.atlassian.net/wiki/spaces/BLMPD/pages/2571567105/Azure+VM+Docker+with+Azure+Service+Management#How-do-I-configure-the-Azure-Active-Directory-Service-Principal%3F

Step 3) Installation procedure

1. SSH into the BPLM VM configured at Step 1) Required Resources.

   1. download the install archive by running the following command:

RHEL:

wget https://bplmdemoappstg.blob.core.windows.net/deployment/vm-azure/lho_rhel.zip

Ubuntu:

wget https://bplmdemoappstg.blob.core.windows.net/deployment/vm-azure/bplm-install.zip

...

1. Extract the archive contents
   unzip archive<archivename>.zip -d <destination folder>

2. In the destination directory you should see the following files:

   Code Block
   .env docker-compose.yml setup.sh start.sh

   1. script setup.sh will install Docker and other automation tools (e.g. OpenSSL)

3. Before you start the setup you need to fill the .env file with the needed information (url of the app, Key Vault url, etc). Open the file in your editor of choice and fill in the values.

   1. Please find a brief explanation of the .env values below

   2. Code Block

      APPSERVICE_URL=##public DNS of LHO #defaultapplication iseg: https://<vm<VM DNS NAME> dns> AZURE_KEYVAULT_TENANTID= ### Azure ActiveEntra DirectoryID tenantTenant ID AZURE_KEYVAULT_URI= #### can be found in keyvault properties page in azure portal AZURE_MANAGED_IDENTITY_ID= ### VM system assigned identity objcetobject ID AZURE_MANAGED_IDENTITY_APP_ID= # app id of VM system assigned identity. Can be found under the vm name in Enterprise application directory) SERVICE_PRINCIPAL_CLIENTID= # Service principal tied to app registration client (also called app) id SERVICE_PRINCIPAL_OBJECTID= # Service principal tied to app registration object ID SERVICE_PRINCIPAL_TENANTID=## Azure # Azure Active Directory tenant IDEntra ID Tenant ID SQL_DATABASE=lakehouse # or some other database created specifically for LHO SQL_SERVER_HOST= # canSQL beserver found'server inname' sqlproperty server propertieseg: lhosqlexample.database.windows.net SQL_USER=# #SQL username of sql server STORAGE_AZURE_ACCOUNT= # storage account name hosting container for lakehouse optimizer STORAGE_AZURE_CONTAINER= # container name created for lakehouse

4. Run the setup.sh.

   Code Block
   language s
   bash chmod +x setup.sh start.sh ./setup.sh -d=FQDNforLakehouse -v=LakehouseVersion

   where FQDNforLakehouse

   --cert_domain "<App DNS Name>" --email_certbot "ITAdmin@company.com"

   • cert_domain is Fully Qualified Domain Name where LakehouseVersion is the LHM version you want to installof the application. Used to generate self-signed certificate

   • email_certbot email address notified when cert is pending expiration.

   • e.g. .bash /setup.sh -d=my-lhm-deployment.com -v=2.5.0

   Note: when prompted if you want to use the Service Principal to access the storage account please keep in mind that if you choose Yes, the Key Vault should not contain the storage-account-key secret and if you choose No you will have to have that secret in the Key Vault.

5. If the setup.sh executed successfully you can run the start.sh script to start the system.

   Code Blockbash

   pull down the app container and start the application.

   1. Lakehouse Optimizer leverages a containerized application. This container is hosted in Blueprint’s Azure Container Registry (ACR). If you have not been provided an ACR token, please reach out to Blueprint support

      Code Block
      ./start.sh -

   u=ACRUser -p=ACRPass

...

ACR username and ACR password to be used by docker to pull the BPLM images from the container registry: bplm-acr-token / <password to be provided upon deployment>

...

where ACRUser is the Blueprint Docker Registry user

1. 1. -acr_username <provided token name>

• where acr_username is the ACR token name provided by Blueprint

  • start.sh will prompt you for the token password

• e.g.bash /start.sh -u=johnlho-doe-user -p=1234a54-3f4324-x3234acr-ex