How to secure sql login in maxl file that executes SQL rule
We are using Essbase 21.6.0.0.413, as delivered with EPM 11.2.19.
We have a PowerShell that calls a maxl statement that runs Essbase rules like the following:
import database $4.$5 data
connect as $6 identified by "$7" using server rules_file 'dTempRMS.rul'
to load_buffer with buffer_id 1
on error append to 'Logs\EssbaseLoad_dTempRMS.log';
We hired some security experts who found that we are exposing the sql database userid ($6) and password ($7) when we call this maxl from the PowerShell. The dTempRMS.rul is an Essbase rule that uses an ODBC connection on the Essbase server to connect to an SQL database.
1)Given that the ODBC connection has the database credentials, do we need to specify the "connect as $6 identified by "$7""?