BI Architecting & Solutions

Here I will be covering few most commonly used WLST topics as below: Creating application roles Deleting application roles Assigning users to the application roles Revoking users from the application roles Listing out users in an application role(s) Creating users In all these scripts I will be using a csv file as an input source (as it is more convenient). You may also prefer to user various input sources for the WLST scripts which are indeed python scripts, but you would need to have those relevant modules installed as well. csv module comes with the OS package. WLST scripts are python scripts (.py). All the scripts are preferred to be kept under the below location: <middleware_home>/oracle_common/common/bin 1. Creating application roles: Here the source is  Resp.csv file; this file contains the list of Application roles to be created as below. Note: The source file in this scenario is placed at the same location of the file. We use th...

First we will look into how to write into a database table using only JS and also the limitations. Then how to overcome those limitations. Writeback using JS: Create a JS function to write into a database table as below: eg: In this example I am using a Oracle 11g R2 database function <function_name> ( < parameter1, parameter2,... > )  { var conObj = new ActiveXObject('ADODB.Connection'); var connectionString = "Provider=OraOLEDB.Oracle;Data Source= <tns-entry> ;User Id= <schema name> ;Password= <schema password> ;"; conObj.Open(connectionString); var rs = new ActiveXObject("ADODB.Recordset"); var sql = " INSERT INTO DUMMY_TABLE(X1,X2,...) VALUES ("+parameter1+","+parameter2+",...) "; rs.Open(sql,conObj); var sq = "commit"; rs.Open(sq,conObj); //rs.close; conObj.close; location.reload(); //close(); } Append the above code after modification in common.js file loca...

Create an xml file somewhere in the middleware home: eg: "<middleware_home>/obieecustomLinks/ customlinks.xml " <?xml version="1.0" encoding="utf-8"?> <customLinks xmlns="com.siebel.analytics.web/customlinks/v1"> <link id="l5" name=" <name of the tag> " description=" <any description> " src=" <copy paste the dashboard page url or provide any custom url> " target="self">    <locations>       <location name=" header " insertBefore=" home " />    </locations> </link> </customLinks> Add the below tags into instanceconfig.xml file: <CustomLinks>       <Enabled>true</Enabled>       <filePath> <middleware_home> /obieecustomLinks/customlinks.xml</filePath> </CustomLinks> You see the custom link is now available on the left side of home .