Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    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!

    Bryan

    Add comment
    10|10000 characters needed characters exceeded

    • 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