OBIEE 11g - extractprojects utility

About

This utility is used to extract projects from a given repository (B for base) to another repository (O for output).

You can choose the project by name of by uid.

Articles Related

Syntax

ExtractProjects 
   -b base_repository_pathname 
   -o output_repository_pathname 
   {-i input_project_name} 
   [{-u input_project_upgrade_id}] 
   [-p password] 
   [-l] 
   [-f uid_file_to_extract] 
   [-e projects_list_file_name]

where:

• Repository Options
  • -b : Base repository name
  • -p : Base and output Password repository
  • -o : Output repository name
• Project choice
  • -i : Input project name
  • -u : Input project upgradeid
  • -f : file containing uids to extract for a batch mode. Doesn't work.
• Logging
  • -l : Enable logging
• Extraction
  • -e : Extracting projects names file

Examples

Extract multiple project

• Extract from rp1.rpd to rp2.rpd projects project1 and project2 using password secret.

ExtractProjects -P secret -B rp1.rpd -O rp2.rpd -I project1 -I project2

Extract the list a projects in a file

• Extract projects names from rp1.rpd to projectslist.txt file. Password will be prompted.

ExtractProjects -B rp1.rpd -E project_filename.txt

Output project_filename.txt:

myFirstProject
mySecondProject
....

Extract project from a uid

• Get the uid

• Start the utility

extractprojects -B base.rpd -O output.rpd -U 9611d581-0c78-1000-81f1-c0a847290000

• It will give you the following console output and a new repository (output.rpd) with one project

Give password:
Everything OK

Documentation / Reference

• Obiee: Export Rpd Project Via Command Line