Configuring Database Member Source

You use the Database type to obtain users from database, such as, SQL Server, Teradata, DB2, PostgreSQL, or Oracle. An ODBC connection to the database must be setup to retrieve user information.

The following table describes the connection variable settings for the databases supported in Policy Management.

Creating Database Member Source

This section describes the procedure on how to create a database member source.

To create a Database Member Source:

1. On the ESA Web UI, navigate to Policy Management > Roles & Member Source > Member Sources.

2. Click Add New Member Source.

   The New Member Source screen appears.

3. Enter a unique name for the file member source in the Name text box.

4. Type the description in the Description text box.

5. Select Database from the Source Type drop-down list.

6. Select one of the following database from the Source drop-down list.

   • Teradata
   • Oracle
   • SQL Server
   • DB2
   • PostgreSQL

7. To enable the usage of a custom data source name, switch the Use Custom DSN toggle.

   1. Enter the custom data source name in the DSN text box.
   2. Ensure that the specified DSN is present in the odbc.ini configuration file located in the /opt/protegrity/mbs/conf/ directory.

8. If you are selecting the Oracle database as the source database, then enter the service name in the Service Name text box.

   Note: This step is applicable for the Oracle database only.

9. If you are not using Custom DSN, then the following steps are applicable.

   1. Enter the database name in the Database text box.

   2. Enter the host name in the Host text box.

   3. Enter the port to connect to the database in the Port text box.

10. Enter the username in the Username text box.

11. Enter the password in the Password text box.

12. Click Save.

The message Member Source has been created successfully appears.

• ←Previous
• Next→