Hyperion Essbase (MOSC)

MOSC Banner

How to secure sql login in maxl file that executes SQL rule

in Hyperion Essbase (MOSC) 13 commentsAnswered ✓

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""?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center