38 lines
3.1 KiB
PowerShell
38 lines
3.1 KiB
PowerShell
# Script to set DBT environment variables permanently for User
|
|
# Run this script once to configure all environment variables for all targets
|
|
|
|
Write-Host "Setting DBT environment variables for all targets..." -ForegroundColor Green
|
|
Write-Host ""
|
|
Write-Host "It can runs slowly, please wait with patience ..." -ForegroundColor Red
|
|
Write-Host ""
|
|
|
|
# POC Environment
|
|
Write-Host "Setting POC environment variables..." -ForegroundColor Cyan
|
|
[System.Environment]::SetEnvironmentVariable('DBT_PROFILE_TARGET_TYPE_POC', 'oracle', 'User')
|
|
[System.Environment]::SetEnvironmentVariable('DBT_PROFILE_TARGET_HOST_POC', 'PE-lzprd-mrds-tst-dmarsdb1.adb.eu-frankfurt-1.oraclecloud.com', 'User')
|
|
[System.Environment]::SetEnvironmentVariable('DBT_PROFILE_TARGET_USER_POC', 'MRDS_LOADER', 'User')
|
|
[System.Environment]::SetEnvironmentVariable('DBT_PROFILE_TARGET_PASSWORD_POC', 'Mars_db_12345678', 'User')
|
|
[System.Environment]::SetEnvironmentVariable('DBT_PROFILE_TARGET_PORT_POC', '1521', 'User')
|
|
[System.Environment]::SetEnvironmentVariable('DBT_DATABASE_NAME_POC', 'G9E081DDAD95B2D_DMARSDB1', 'User')
|
|
[System.Environment]::SetEnvironmentVariable('DBT_PROFILE_TARGET_SERVICE_NAME_POC', 'g9e081ddad95b2d_dmarsdb1_low.adb.oraclecloud.com', 'User')
|
|
|
|
# DEV Environment
|
|
Write-Host "Setting DEV environment variables..." -ForegroundColor Cyan
|
|
[System.Environment]::SetEnvironmentVariable('DBT_PROFILE_TARGET_TYPE_DEV', 'oracle', 'User')
|
|
[System.Environment]::SetEnvironmentVariable('DBT_PROFILE_TARGET_HOST_DEV', 'PE-lzprd-mrds-tst-dmopdb.adb.eu-frankfurt-1.oraclecloud.com', 'User')
|
|
[System.Environment]::SetEnvironmentVariable('DBT_PROFILE_TARGET_USER_DEV', 'MRDS_LOADER', 'User')
|
|
[System.Environment]::SetEnvironmentVariable('DBT_PROFILE_TARGET_PASSWORD_DEV', 'Tesat_ysklLawga_uskjas3', 'User')
|
|
[System.Environment]::SetEnvironmentVariable('DBT_PROFILE_TARGET_PORT_DEV', '1521', 'User')
|
|
[System.Environment]::SetEnvironmentVariable('DBT_DATABASE_NAME_DEV', 'G9E081DDAD95B2D_DMOPDB', 'User')
|
|
[System.Environment]::SetEnvironmentVariable('DBT_PROFILE_TARGET_SERVICE_NAME_DEV', 'g9e081ddad95b2d_dmopdb_medium.adb.oraclecloud.com', 'User')
|
|
|
|
|
|
Write-Host ""
|
|
Write-Host "All environment variables have been set successfully!" -ForegroundColor Green
|
|
Write-Host ""
|
|
Write-Host "IMPORTANT: You need to restart PowerShell for changes to take effect." -ForegroundColor Yellow
|
|
Write-Host ""
|
|
Write-Host "To verify, open a NEW PowerShell window and run:" -ForegroundColor Yellow
|
|
Write-Host " Get-ChildItem Env: | Where-Object Name -like 'DBT_*'" -ForegroundColor White
|
|
|
|
|