$serverName = 'usgsserver' + $participantNumber
$fullyQualifiedServerName = $serverName + '.database.windows.net'
$dataWarehouseName = 'usgsdataset'
$adminUser = 'usgsadmin'
$adminPassword = 'P@ssword' + $participantNumber
$dWConnectionString = "Server=tcp:$fullyQualifiedServerName,1433;Initial Catalog=$dataWarehouseName;User ID=$adminuser;Password=$adminPassword;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"
$dwConnectionString_Secure = ConvertTo-SecureString -String $dwConnectionString -AsPlainText -Force
$stagingAccountName = "usgsstaging" + $participantNumber
$stagingAccountKey = (Get-AzureRmStorageAccountKey -ResourceGroupName $resourceGroupName -Name $stagingAccountName).Value[0]
$stagingAccountKey_Secure = ConvertTo-SecureString -String $stagingAccountKey -AsPlainText -Force
$stagingAccountURL = "https://$stagingAccountName.blob.core.windows.net"
$stagingAccountConnectionString = "DefaultEndpointsProtocol=https;AccountName=$stagingAccountName;AccountKey=$stagingAccountKey"
$stagingAccountConnectionString_Secure = ConvertTo-SecureString -String $stagingAccountConnectionString -AsPlainText -Force