Date: March 27,2015
The following document describes how to configure the Enterprise Random Password Manager (ERPM) Application Launcher for use with DB Artisan.
- Setup DB Artisan and the corresponding database client correctly. Each database has its own specific client which is supplied by the database vendor, not Lieberman Software. Be sure to configure the DB Artisan and database client pre-requisites and test your ability to launch and connect with DB Artisan prior to attempting to use the ERPM launcher.
Notes for Oracle: If working with Oracle, configure a proper tnsnames.ora file in the oracle client path (%ORACLE_HOME%\NETWORK\ADMIN) that has the connect descriptors filled out as ERPM supplies system names for oracle instances. For example, ERPM supplies a particular system name and a particular service name formatted as: SYSTEMNAME\SERVICENAME. In the example below, that translates to ORAWEB\ORCL.LSC.ENT.
So the tnsnames.ora file that DB Artisan uses must also be configured with the same information:
ORAWEB\ORCL.LSC.ENT = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oraweb.lsc.ent)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.lsc.ent) ) )
- Then in the application launcher configuration for DB Artisan set the following values:
- Run on the jump server = ENABLED
- Application: dbart.exe
- Application location: Installation path to the dbart.exe file.
- Command line: -R sqlserver://$(RemoteAccessTarget_TargetName) -D $(RemoteAccessTarget_TargetName) -U $(Username) -P $(Password)
The "sqlserver" clause at the beginning of the Command line setting, following -R, will change depending on the type of database being connected to. The "-R" this tells the DB Artisan program what type of DB to connect to and other required information about it. Read your DBArtisan documentation for specifics about different types of databases and what syntax they require. There is different syntax for SQL Server v Sybase v Oracle v MySQL, etc..
- Finally, select the Configure Allowable Account Types and enable DB Artisan for the appropriate database type, e.g. Oracle or Sybase or MS SQL Server, etc..