Read-only BODI Jobs ....

dataservices job design
1

Few Questions Regarding Read-only BODI jobs …

  1. I want to make a BODI job as Read-only in prod …
  2. I want to make a project read-only (Secure Project) …

How can I make that one ?

We can make a full repository(DB) as read-only from DB perspective using grant permission … But
I want to do it in project or job level…

Can anybody please help me in this regard ?

HeadsUp (BOB member since 2011-01-14)

2

You should use a different model. My prod repo is secure because nobody knows the login for this repo. And nobody needs to as no development environment (=DS Designer) is allowed to connect to it. If new jobs/projects need to be moved into prod they are exported into an ATL file and imported automatically via the al_engine after thoroughly testing them.

Werner Daehn :de: (BOB member since 2004-12-17)

3

Thanks for the reply Werner …

Is there any way to import jobs / project silently, without using DS Designer ? But we can export the Jobs / Project from the command prompt… Please suggest…

HeadsUp (BOB member since 2011-01-14)

4

Werner Daehn :de: (BOB member since 2004-12-17)