Before you use ODI, you must create a repository. The creation process is as follows:
1. Environment variable Setting
2. Using RCU
RCU is a usage program that creates a repository.
[email protected]:~$ $ODI_HOME/oracle_common/bin/rcu
Default entry, Next:
Select the database type and enter the connection information (the user name here must have DBA authority because Tablespace is created during post-creation, etc.)
Define prefix Name:
Select components:
Define the scheme password:
Custom variables:
Summary information:
Click ' Create ' to start configuring the repository
3. Open the ODI connection repository
[email protected]:~$ odi &
In the ODI interface, click "Connect to Repository" and enter the relevant information in the dialog box that appears, such as:
After the test connection is successful, click "OK" to open the interface as shown below:
Setting up Oracle Data Integrator Repository