Create a repository using Oracle Data Integrator Studio

First, Creating the Database Schema

/*1th Step: Create a temporary table space*/Create Temporarytablespace user_temp tempfile'C:\app\ORACLE\oradata\orcl\user_temp.dbf'size 50m Autoextend on  Next50m maxsize 20480m extent management local; /*2nd Step: Create a data table space*/Createtablespace user_data Logging datafile'C:\app\ORACLE\oradata\orcl\user_data.dbf'size 50m Autoextend on  Next50m maxsize 20480m extent management local; /*3rd Step: Create a user and specify a tablespace*/Create UserOdi_repo identified byOdi_repodefaulttablespace user_dataTemporarytablespace user_temp; /*4th Step: Grant permissions to the user*/GrantConnect,resource,dba toOdi_repo;

Second, create Master Repository "and connect

Starting Odi64.exe, running the new Master Repository Wizard

Configure connection information, user name and port created for the first step

Ignore, character encoding issues

Enter the supervisor password

Created in

Created successfully

odi→ Connect New Login

Enter Repository connection information

When the connection succeeds, the Designer tab page is grayed out because the project exists in the repository

III. Create a work repository and connect

Log in to the Master repository, select topology → main repository Right-click New Job Repository,

By default, you can.

specifying types, developing

Log in to find the designer is not grayed out, indicating that the data archive successfully landed.

Create a repository using Oracle Data Integrator Studio