Thursday 11 October 2012

Extract Projects using Command extractprojects

Using the extractprojects Utility to Extract Projects

You can use the Oracle BI Server utility extractprojects to extract projects from a given repository without the overhead of the MUD environment. The extractprojects utility is available on both Windows and UNIX systems. You can only use extractprojects with binary repositories in RPD format.
The extractprojects utility generates an RPD file that includes the set of projects you specify. The utility does not perform other tasks that are performed when you check out projects using the Administration Tool, like saving an original repository file or tracking the extract as a check-out in the MUD directory.
Before running extractprojects, you must first run bi-init to launch a command prompt that is properly initialized.

Syntax 
The extractprojects utility takes the following parameters:
extractprojects -B base_repository_name -O output_repository_name {-I input_project_name} [-P repository_password] [-L]
Where:
base_repository_name is the name and path of the repository from which you want to extract projects.
output_repository_name is the name and path of the repository generated by the utility.
input_project_name is the name of a project you want to extract. You can enter multiple projects. Be sure to precede each project entry with -I (for example, -I project1 -I project2). If the project name contains spaces, enclose it in double quotes (for example, "project 1").
repository_password is the password for the repository from which you want to extract projects.
Note that the repository_password argument is optional. If you do not provide the password argument, you are prompted to enter the password when you run the command. To minimize the risk of security breaches, Oracle recommends that you do not provide password arguments either on the command line or in scripts. Note that the password argument is supported for backward compatibility only, and will be removed in a future release.
- L enables logging. When logging is enabled, a log file in the format ProjExtr.YYYYMMDD.HHMMSS.xml is created in the Oracle BI Server logging directory. For example:
ORACLE_INSTANCE/diagnostics/logs/OracleBIServerComponent/coreapplication_obisn/ProjExtr.20100616.082904.xml
Example 
The following example extracts project1 and project2 from my_repos.rpd and creates a new repository called extract_repos.rpd:
extractprojects -B my_repos.rpd -O extract_repos.rpd -I project1 -I project2
Give password: my_rpd_password
Note:
Be sure to provide the full pathnames to your repository files, both the input file and the output file, if they are located in a different directory.

No comments:

Post a Comment