Controlling User and Password Credentials with Effective Dates

Edit online

You can now change database passwords on a scheduled basis in Sterling B2B Integrator.

When you add or modify a pool, you now can control user and password credentials with effective dates. Multiple user and password credentials are associated with a pool. A date/time entry indicates to Sterling B2B Integrator when to start using that credential for new connections. This applies primarily to external pools, although Sterling B2B Integrator database pools will also work.

You can use the following variables for the date format:

  • 15:00:00 3/16/09
  • 3/16/09 15:00:00
  • 3/16/2009 15:00:00
  • Sat, 12 Aug 1995 13:30:00 GMT
  • Sat, 12 Aug 1995 13:30:00 GMT+0430
Note: Other formats may be used as long as they follow the Internet Engineering Task Force (IETF) standard date syntax. For additional information, see http://www.ietf.org/rfc/rfc3339.txt.
Pool Property Description
newDBPool.password.1 = <new password>

You can specify alphabets and combination of alphabets and numbers for the password. You can use numbers for newDBPool.password.1 or newDBPool.password.2 as well as following examples:

  • newDBPool.password.a=password_a
  • newDBPool.effective.a=1/01/2005 09:35:00
  • newDBPool.password.b=password_b
  • newDBPool.effective.b=02/01/2009 09:35:00
  • newDBPool.password.c=password_c
  • newDBPool.effective.c=06/18/2009 11:07:00

newDBPool.effective.1 = <The date for the new password starts to take affect>

You can specify alphabets and combination of alphabets and numbers for the password. You can use numbers for newDBPool.password.1 or newDBPool.password.2 as well as following examples:

  • newDBPool.password.a=password_a
  • newDBPool.effective.a=1/01/2005 09:35:00
  • newDBPool.password.b=password_b
  • newDBPool.effective.b=02/01/2009 09:35:00
  • newDBPool.password.c=password_c
  • newDBPool.effective.c=06/18/2009 11:07:00