Migrate Users and Groups from Embedded WebLogic LDAP Server

If you subscribe to Oracle Analytics Cloud - Classic through a traditional metered or unmetered subscription you might be using an embedded WebLogic LDAP server for identity management. The way you migrate users and groups to Oracle Analytics Server depends whether your target environment uses the default WebLogic LDAP server for identity management or an alternative identity provider such as Oracle Internet Directory (OID LDAP).

If your source Oracle Analytics Cloud uses an embedded WebLogic LDAP server, use the wls_ldap_csv_exporter script to export users and groups to CSV files that you can migrate to Oracle Analytics Server. Prepare both CSV files so they contain all the information required and then import them on the target environment.

  1. Export users and groups from your source environment. Run the wls_ldap_csv_exporter script:
    $ /bi/app/public/bin/wls_ldap_csv_exporter -u weblogic_admin_user -c oracle_common_folder_path -D output_dir

    Typically, oracle_common_folder_path is the folder /bi/app/fmw/oracle_common

    This script creates two CSV files, one CSV file contains users and the other contains groups. There is also a log file, which describes any invalid or incompatible records that your target environment won’t understand.

    • Every user must have a default password.

    • Group memberships records are discarded from the group CSV file and mentioned in the log file; that is, where a group is a member of another group.

    Before you import CSV files on your target environment, take some time to make sure the CSV files contain all the information required by the target identity provider.

  2. Prepare both CSV files for migration.
    1. Review the log file for information about invalid or incomplete records.
    2. Review the users CSV file, ensure the information is complete, and delete extinct users you don't need any more.
    3. Repeat for the groups CSV file.
  3. Replicate users and groups on the target identity provider for Oracle Analytics Server.
    1. Import users from the CSV file you exported earlier.
    2. Import groups from the CSV file you exported earlier.