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

[Former Member]

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

[former_member217070 · Accepted solution]

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!

Bryan

[Former Member · Accepted solution]

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

[former_member217070 · Accepted solution]

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.

Bryan

[Former Member · Accepted solution]

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.

Thanks