Skip to Content

Is there a way to change the passwords in bulk in universe connection via utility?

Jul 19, 2017 at 08:53 PM


avatar image

We have hundreds od universe connection and as per password change policy the passwords will change every 90 days. So we want to do it efficiently instead of manually updating the password for each connection. Thanks

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Bryan Booth
Jul 21, 2017 at 08:29 PM

Hi, Rajesh,

The Developer's Guide for the Semantic Layer SDK states that the connection's "PASSWORD parameter is private and write-only." This means that you can write to it and publish it back to the CMS, but you'll get an error if you try to read from it.

if ( ConnectionParameter.getName().equals( DatabaseConnection.PASSWORD ) )
     ConnectionParameter.setValue( "NewPassword" ) ;

Good luck!


Show 3 Share
10 |10000 characters needed characters left characters exceeded

Thanks Bryan.

One follow up question, Is there a .net semantic layer sdk available? I only saw java semantic layer sdk available on sap site. Thanks


Hi, Rajesh,

There is a RESTful Web Services Semantic Layer SDK and a Java one, but no .NET one.

You can get information on the BI SDK's here.



Hi Bryan,

Hope you are doing great.

I did some more research and it seems I can't change the RDBMS connection passwords using restful sdk. I didn't find an API which would accept the post request and do it for me. Can you please let me know if my conclusion is correct?

If we could restful sdk to change the connection passwords that would be a great solution for me.

We don't use java in our environment at all so as a last resort we will have to turn to java semantic layer sdk which will cause us integration pain.