Prevent BOBJ data loss when Business user leaves
When a business user leaves the company the HR systems will trigger user deletion process which will eventually lock or remove the SAP user accounts in SAP ERP systems. Business Objects systems whose authentication is set to SAP will have only SAP aliases in BOBJ. This blog explains how to create Enterprise aliases to safeguard all SAP user accounts and their report objects in Business Objects systems. This is not applicable for those who Active Directory based login to their BOBJ systems.
Refer to SAP notr#note#1804839 — How to add or remove an Enterprise alias through a script in SAP BI 4.0. Use this sample code from to adapt to your requirements.
You can download the source code from GITHUB url: https://github.com/learnfire/MyBOBJSDK_Kit
Follow the below screen print steps to create the needed Enterprise Aliases with complex random passwords.
Create a JAVA Project in Eclipse and as show below.
Add the appropriate JRE. In this case, remove the JRE 1.8 and add the sapjvm JRE which is similar to one used by BOBJ Server.
Make Sure you have same sapjvm version in your machine as that of BOBJ server
Select the newly configured SAPJVM and remove any other jvm from the screen above.
Here you will add BOBJ Library files. For this you need BOBJ Client tools installed on your machine or you can get the library files form BOBJ Windows server.
Create a new Class
Copy and Past the Source Code
Export the code to JAR format
Import the JAR file to BOBJ as Program file object
The BOBJ part starts from here. No need for any login credentials inside the source code as the Program can run in the logged-in user context of BOBJ system.
Class name should match the namespace and class of the Source Code