Question Re: Scripted approach to onboarding a new BODS developer (Linux) in Technology Q&A

Scripted approach to onboarding a new BODS developer (Linux)

graham_macleod — Thu, 26 Jan 2023 09:52:08 GMT

I was wondering how administrators handling the onboarding of a new developer onto their development environment. the work flow goes like this.

We're using SAP BODS 4.2 SP14 with IPS 4.2 SP9.

Create repository schema on database (easily scripted)
Use repoman to format the schema (easily scripted)
Use svrcfg to associcate repository with the Job Server (svrcfg has command line options, but not for repo to JS associations)
Create enterprise user on CMC (unsure how to script)
Create entry for repository on CMC (unsure how to script)
Assign user security on repository for enterprise user (unsure how to script)
Add user permissions on Management Console for central repository (unsure how to script)

This is a long enough list, and done frequently enough to warrant a bit of effort to implement a scripted approach but other than the first two steps, I am unsure how to go about the rest of it. I suspect that 4, 5, and 6 could perhaps be done using the BO SDK, assuming it works on BO and IPS alike, but I've never seen a way other than the WebServices api on the management console to programmatically interact with the job server, and this doesn't seem to have an endpoint for managing the association of repositories.

Any help would be appreciated. Even if this can only be partially automated, it would be a step forward.

Thanks in advance

Graham

Re: Scripted approach to onboarding a new BODS developer (Linux)

jmuiruri — Thu, 26 Jan 2023 10:27:53 GMT

Greetings graham.macleod,

Regarding Step 3 & 6, i believe this can be achieved by using the BI SDK, the SDK has a lot of capabilities and you can find out more in the following documentation link

Business Intelligence Platform RESTful Web Service Developer Guide

Regarding the 4 & 5, you can check the documentation above and explore the web service to see whether that can be achieved. Open to hear other suggestions.

You can also submit an enhancement request, please see how to do that here 2553150

Best Regards,

Joseph

Re: Scripted approach to onboarding a new BODS developer (Linux)

graham_macleod — Thu, 26 Jan 2023 11:41:25 GMT

Thanks Joseph! I'll check that out. If I do come across a solution I'll post it here.