Note: Master Repository can be created both
manually and by running RCU(Repository creation utility)
SQL Script to create Database Schema
CREATE USER
SNPM1 IDENTIFIED BY ADMIN123 DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE
TEMP;
GRANT
CONNECT, RESOURCE TO SNPM1;
COMMIT;
Creating Master
Repository from ODI
Provide details for the newly created schema and also
provide a user with DBA privileges. Use a duplicate user with DBA privileges
and not SYS user.
Test the connection and go to next screen,
Then in the next proceed with Internal password storage,
Click Finish.
ODI will then start creating your work repository,
Log is also available of the creation process.
After the process is complete log in and test master
repository connection,
