Oracle Analytics Cloud and Server

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

Extract User List in OBIEE

Received Response
646
Views
13
Comments
2»

Answers

  • Charles M
    Charles M Rank 6 - Analytics Lead

    2709444 -

    Example:

    1) Create two files: get_defaultAutn_dat.py and get_defaultAutn_dat.sh:

    get_defaultAutn_dat.py

    connect('weblogic','<weblogic_password>','localhost:7001')domainRuntime()cd ('/DomainServices/DomainRuntimeService/DomainConfiguration/bifoundation_domain/SecurityConfiguration/bifoundation_domain/DefaultRealm/myrealm/AuthenticationProviders/DefaultAuthenticator')cmo.exportData('DefaultAtn','/<path_to_file_location>/DefaultAuthenticator.dat', Properties())exit()

    get_defaultAutn_dat.sh

    #!/bin/ksh
    #
    # get_defaultAutn_dat
    ## http://docs.oracle.com/cd/E28280_01/web.1111/e13707/security_data_migration.htm#SECMG325
    # domainRuntime()
    # cd('DomainServices/DomainRuntimeService/DomainConfiguration/mydomain/SecurityConfiguration/mydomain/DefaultRealm/myrealm/path-to-MBean/mbeanname')
    # cmo.importData(format,filename,constraints)# (Doc ID 1926820.1)
    # domainRuntime()
    # cd ('/DomainServices/DomainRuntimeService/DomainConfiguration/base_domain/SecurityConfiguration/base_domain/DefaultRealm/myrealm/AuthenticationProviders/DefaultAuthenticator')
    # cmo.exportData('DefaultAtn','/private/defaultAutn.dat', Properties())MW_HOME=/<path_to_file_location>/Middleware
    export MW_HOMEDOMAIN_NAME=bifoundation_domain
    export DOMAIN_NAMEDOMAIN_HOME=${MW_HOME}/user_projects/domains/${DOMAIN_NAME}
    export DOMAIN_HOME. ${MW_HOME}/wlserver_10.3/server/bin/setWLSEnv.shjava weblogic.WLST get_defaultAutn_dat.py

    2) Execute the script

    ./get_defaultAutn_dat.sh

    3) The file will be in the specified path/location

    Two things. This does not use any 'SSL' protocol as written. Also, make sure the destination path is secure (e.g. restricted permissions).

    As Christian mentioned, take some time to understand the material first. Then maybe try in a Dev instance.

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

    Thanks for spelling it out so nicely and put together the code!

  • Charles M
    Charles M Rank 6 - Analytics Lead

    Thanks! It should hopefully get the job done .