External Database Connection Strings
PAM supports a wide range of the most popularly used databases system in the market.
When configuring PAM to use your own database, you will need to supply the database connection string.
In general, the connection string will comply with the following example:
db-host or db-host:port
NOTE: The installation process does not create its own database or tablespace but rather makes use of an existing one. With that in mind, please ensure one with the name “PamDB” already exists as this will be used by the application.
Apache Derby
db-host or db-host:port
Microsoft SQL Server
db-host or db-host:port
MySQL
db-host or db-host:port
Oracle
Service: //db-host/db-service
Instance: //db-host:port:SID
PostgreSQL
db-host or db-host:port
PostgreSQL database account management
PAM users get manage accounts in PostgreSQL database including Check Status and Password Reset tasks including direct and shadow account access as well as permission and workflow based password unlock and custom script execution.
Initially hidden record type for PostgreSQL database including check status and password reset tasks based on the PostgreSQL Connection string given by:
host:port/database, host/database, host[:port]/database
or full JDBC connection string:
jdbc:postgresql://host[:port]/database
To enable account management:
- Connection (Type: String, Display Name: Connection String) to define host:port/database connection string
- CommandUser (Type: String, Display Name: Command User) to define account login
- CommandPassword (Type: String, Display Name: Command Password) to define account password
If you want to change the database after deployment, please see the following article for more information: Changing PAM’s back-end Database.