Cognos Access Manager macro's help

[gotike]

Hello ,

I need to write a cognos script which need to pull the user id information from the SQL Server data base Custom table and then create the users , user classes in the LDAP directory server namespace

i am wondering are there any delivered macros for this function or need a write a custom macro any thoughts or ideas

Thanks in Advance,
sunny

 

[Draoued]

check the Access Manager batch Maintenance application and Help.

If you are able to generate by yourself a text file with the needed information , you could automate the user creation and user-class with it.

Schedule it at a proper time , because Access Manager Batch maintenance , is locking the namespace. Which will cause an error message on the web application if users are trying to logon at this time.

 

[gotike]

Draoued,
Thanks ! I have gone through the Aceess Manager Batch Maintance guide , here we have three i/p files ...
1)USER CLASS I/P FILE 2)USER I/P FILE 3)ALL OBJECTS I/P FILE
which input files i have to use, can you please help me on it.

Thanks,
sunny

 

[Draoued]

If you use a ALL object type of file then you can put all the commands in it.

For example you can try in the Access Manager Batch maintenance UI the following file:

//Create a User class called User Class 1
AddUserClass,"User Class 1 ","Root User Class"
// Create a user
AddUser,"LastName FirstName"
// Assign a Basic Signon to the created user
AddUserBasicSignon,"LastName FirstName","MySignon"
// Set the default password to user created
SetUserBasicSignonProperty,"LastName FirstName","MySignon",Password,"MyInitialPassword"
// Force user to change password at the first logon
SetUserBasicSignonProperty,"LastName FirstName","MySignon","ChangePasswordAtNextLogon","yes"
// Assign the user to the user class created
AddUserToUserClass,"LastName FirstName","User Class 1

 

[gotike]

Hi Draoued,
Thank you very much for the information.I have the data base file , in that i have empno, based on the empno i have to create the User id in the Access manager(LDAP), the above script is works for one user, i am having more than 100 employees in the data base file.How can i pass "empno' to the "All Object I/P File", please help me on it.

Where are you located ? can i have your contact number.

Thanks,
siva

 

[Draoued]

Sorry not giving my phone or contact info.

Then create a sql which is generating such file.
Or extra the information from your database and in excel you add the needed information , or create a script/batch which is using the empno as a variable and looping untill the end.