RNM

September 9, 2009

Syntax for AdminTool.exe command line script

Filed under: admintool, hack — rmoff @ 15:09

Bringing together in one place all of the script syntax that I’ve found so far for using with OBIEE’s AdminTool.exe /command

Details and examples on usage in the following blogs (where I compiled the commands from):


DON’T TRY THIS AT HOME!

I would only recommend this for read-only purposes such as generating the metadata dictionary or consistency check.


* OpenOnline DSN [user [password]]
- Opens the online repository. NB can’t edit properties without checking out objects first, and no way to do that from script.

* Open FileName [user [password]]
- opens the repository offline

* New FileName
- creates new repository offline

* Save
- saves opened repository

* SaveAs FileName
- saves opened repository under new name

* Close
- closes opened repository

* Exit
- closes AdminTool

* SetProperty “Variable” “” Initializer “”
* SetProperty “Connection Pool” “”.”” “User” “”
* SetProperty “Connection Pool” “”.”” “Password” “”
* SetProperty “Connection Pool” “”.”” “DSN” “”

* MessageBox [message]
- displays messagebox with the text, default message is “Siebel Analytics Administration Tool”

* ImportRepository {Online|Offline} {FileName|DSNname} [user [password]]
- initiates import from the other repository

* ImportRepositoryObject {Project|”Presentation Catalog”|User|”Security Group”|Variable} {Name|*} [True|False [True|False]]
- imports object(s) from the other repository

* ImportRepositoryExecute
- executes the repository import defined by previous calls to ImportRepository and ImportRepositoryExecute

* Compare FileName [user [password [outputFile]]]
- compares current repository with another repository

* Merge FileName1 FileName2 [DecisionFile] [user1 [password1 [user2 [password2]]]]
- merges repositories

* ConsistencyCheck [outputFileName]
- global consistency check

* BusinessModelConsistencyCheck businessModelName [outputFileName]
- consistency check for one business model

* CreateSubset NewRepositoryName MasterRepositoryName numberOfProjects project1 [project2 [project3 [...]]] [user [password]]
- creates and opens multi-user subset repository

* CheckinSubset ModifiedSubsetRepositoryName LockUserFullName [user [password]]
- checks in ModifiedSubsetRepository into master repository

* DescribeRepository Filename UTF-8
- triggers an export of the rpd metadata to the Filename file in UTF-8 codepage. This is similar to using the Administration Tool utility manually.

* GenerateMetadataDictionary Destination_Folder
- run the Metadata Dictionary export

* Hide
- hides AdminTool

* comment line starts with single quote ‘ character

About these ads

7 Comments

  1. Hi rnm,

    nice compilation, there we go. Please put up the big “don’t try this at home sign” for all the script kiddies out there.

    I would only recommend this for read-only purposes such as generating the metadata dictionary or consistency check.

    have a nice day

    @lex

    Comment by @lex — September 9, 2009 @ 19:45

    • Cheers @lex, updated as suggested.

      Comment by rnm1978 — September 10, 2009 @ 09:53

  2. It looks like it has been a while since you posted this but I am just now catching up. :-) First off, it is nice to have all of the known commands compiled in one spot. Thanks!

    And second, did you ever come across anything that could be used to change the LDAP server settings from a command line (admintool.exe, UDML, or otherwise)?

    Thanks again… I appreciate the posts and use them regularly.

    Kevin

    Comment by Kevin — February 22, 2011 @ 18:04

  3. [...] chap called Kevin posted a comment on a previous posting of mine asking did you ever come across anything that could be used to change the LDAP server settings [...]

    Pingback by Changing LDAP settings in an OBIEE RPD with UDML « RNM — February 23, 2011 @ 17:07

  4. [...] Moffatt's blog entry about Syntax for AdminTool.exe command line script:  https://rnm1978.wordpress.com/2009/09/09/syntax-for-admintool-exe-command-line-script/ Posted under Oracle BI EE No [...]

    Pingback by Generation of the Metadata Dictionary « ClearPeaks Blog — January 26, 2012 @ 16:21


RSS feed for comments on this post.

Sorry, the comment form is closed at this time.

The Silver is the New Black Theme. Create a free website or blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: