Is it possible to build a script in Hyperion that autologs required credentials into the ODS(sql database) when the queries are run?

71 views Asked by At

It will be painfully obvious I'm new to the space so apologies in advance for lack of code/maybe even understanding.

I'm using Oracle Hyperion financial reporting software and connecting to the ODS regularly to get data updated and am tired of logging into the database(s) each time I run the .bqy file queries.

Is there a javascript code that can be run on the hyperion side that would auto login in the required credentials? I realize this may be inefficient compared to trying to add a user access to the database directly, but trust me it will be very difficult to do at this point in time.

Thanks for any tips you may have.

0

There are 0 answers