Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE 12.2.1.4 exportarchive command, syntax to export only RPD and Catalog (no security)

Accepted answer
427
Views
6
Comments
Joe_obieeoas
Joe_obieeoas Rank 5 - Community Champion

Hi Gurus,

OS is windows server 2016.

In command prompt (run as administrator), navigated to "Domain_Home\bitools\bin" and ran importarchive command as follows "importarchive.cmd ssi ABC.bar [noauthorization] encryptedpassword=xyz

when i ran this, i got the "import" process going and i noticed messages like...

Executed successfully preImportArchive for OfflineJaznContentPlugin Status object: true

Executed successfully importArchive for OfflineJaznContentPlugin Status object: true

Executed successfully postImportArchive for OfflineJaznContentPlugin Status object: true


I mentioned "[noauthorization]" in the import command, still wonder why this security is being imported.

Can you share the correct syntax so that i can exclude security and import/export only RPD and catalog to/from an instance.


Thanks

Best Answer

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner
    Answer ✓

    Out of curiosity: Why do you have square brackets around [noauthorization] but not around encryptionpassword?

    USAGE : <service instance key> <location of bar file to import> [nodatamodel] [nocontent] [noauthorization] [nodatasets] [nosearch] [noaction] [encryptionpassword=<encryption password for connections>]
     Description         : Import bar as a service instance
     Mandatory Arguments : service instance key and location of bar file
     Optional Arguments  : exclude list of values:nodatamodel nocontent noauthorization nodatasets nosearch
             nodatamodel        : Do not import RPD metadata content
             nocontent          : Do not import WEBCAT metadata content
             noauthorization    : Do not import JAZN metadata content
             nodatasets         : Do not import DSS metadata content
             nosearch           : Do not import Search metadata content
             noaction           : Do not import Action metadata content
             encryptionpassword : Encryption password for connections if any
    


    The square brackets in the help are only there to show you what are the optional arguments. It doesn't mean you literally type "[" and "]". Otherwise your own command should also say

    importarchive.cmd ssi ABC.bar [noauthorization] [encryptedpassword=xyz]

Answers

  • Joe_obieeoas
    Joe_obieeoas Rank 5 - Community Champion

    Hi Chris,

    Earlier i ran the command but without any optional parameters. At that time i did not use any square brackets for "encryptionpassword".

    So again followed suit.

    Thanks

  • AM_1
    AM_1 Rank 4 - Community Specialist

    Hi gurus!
    I need to only import the definition of application roles.
    Shall I use "nodatamodel nocontent nodatasets nosearch" ?
    Thanks!

  • [Deleted User]
    [Deleted User] Rank 7 - Analytics Coach

    @AM_1 Please open a new thread for your question. Don't hijack a thread which belonged to a different forum user.

  • AM_1
    AM_1 Rank 4 - Community Specialist

    @Christian Berg -Oracle Oops, sorry about that! I didn't mean to hijack the thread. I'll start a new one next time. Thanks for your patience!

  • [Deleted User]
    [Deleted User] Rank 7 - Analytics Coach

    @AM_1

    Just post your question in a new thread. Then it's yours and you can manage incoming answers.