OBIEE External Table Authenticaion

Steps for Creating External Table Authencticaion


1) First create a table with username, password, and group_name


                                  

Open your rpd

2. Select Manage > Variables to open the Variable Manager.

3. Select Initialization Blocks on the left tree pane.

4. Right-click on white space in the right pane, and then click on New Initialization Block from the right-click menu.

5. In the Initialization Block dialog box, type the name for the initialization block.

6. Select Database from the Data Source Connection drop-down list.

7. Click Browse to search for the name of the connection pool this block will use. 

Fig (2): Initialization block SQLIn the Initialization String area, type the SQL statement that will be issued at authentication time

Create a USER System session variable, Right click on white space in the right pane

  

                                           

Creating a System Session variable

Assign the USER session variable to Authentication Initialization block