Creating RDBMS Schema for ODI Source Datastore

You need to create a schema to host the ODI source datastore. In these OBEs you use the RDBMS user/schema ODI_STAGE for the tables used in these examples.
Note: You created the schemas for the flat file target model in the OBE: "Creating an ODI Project and Interface: Exporting a Flat File to a Flat File".
Note: If you completed the OBE " Creating an ODI Project and Interface: Exporting a Flat File to a RDBMS Table" earlier, you should already have ODI_STAGE schema created. In this case, you can skip Step1 and Step 2.
To create a new RDBMS schema for the ODI datastore, perform the following steps:

1.	Start SQL Developer. You will create the new schema/user by executing the following SQL commands: create user ODI_STAGE identified by ODI_STAGE default tablespace users temporary tablespace temp; grant connect, resource, create trigger, create view to ODI_STAGE;
2.	If not done before, in SQL Developer create new connection called ODI_STAGE. Enter User name as ODI_STAGE with password ODI_STAGE. For SID enter ORCL. Click Test to verify connection, and then click Connect.
3 .	Create your source table and populate it with data by executing the SQL commands provided below. Expand connection ODI_STAGE > Tables > TRG_SALES_PERSON and verify that the table is created successfully. Note: You may find these commands in the text file frovided with this OBE. To access this file, click HERE. CREATE table "SRC_SALES_PERSON" ( "SALES_PERSON_ID" NUMBER(8,0) NOT NULL, "FIRST_NAME" VARCHAR2(80), "LAST_NAME" VARCHAR2(80), "DATE_HIRED" VARCHAR2(80), "DATE_UPDATED" DATE NOT NULL, constraint "TRG_SALES_PERSON_PK" primary key("SALES_PERSON_ID") ) / begin insert into ODI_STAGE.SRC_SALES_PERSON values (11,'Andrew','Andersen','22/02/1999',sysdate); insert into ODI_STAGE.SRC_SALES_PERSON values (12,'John','Galagers','20/04/2000',sysdate); insert into ODI_STAGE.SRC_SALES_PERSON values (13,'Jeffrey','Jeferson','32422',sysdate); insert into ODI_STAGE.SRC_SALES_PERSON values (20,'Jennie','Daumesnil','28/02/1988',sysdate); insert into ODI_STAGE.SRC_SALES_PERSON values (21,'Steve','Barrot','24/09/1992',sysdate); insert into ODI_STAGE.SRC_SALES_PERSON values (22,'Mary','Carlin','14/03/1995',sysdate); insert into ODI_STAGE.SRC_SALES_PERSON values (30,'Paul','Moore','36467',sysdate); insert into ODI_STAGE.SRC_SALES_PERSON values (31,'Paul','Edwood','18/03/2003',sysdate); insert into ODI_STAGE.SRC_SALES_PERSON values (32,'Megan','Keegan','29/05/2001',sysdate); insert into ODI_STAGE.SRC_SALES_PERSON values (40,'Rodolph','Bauman','29/05/2000',sysdate); insert into ODI_STAGE.SRC_SALES_PERSON values (41,'Stanley','Fischer','37233',sysdate); insert into ODI_STAGE.SRC_SALES_PERSON values (42,'Brian','Schmidt','25/08/1992',sysdate); insert into ODI_STAGE.SRC_SALES_PERSON values (50,'Anish','Ishimoto','30/01/1992',sysdate); insert into ODI_STAGE.SRC_SALES_PERSON values (51,'Cynthia','Nagata','28/02/1994',sysdate); insert into ODI_STAGE.SRC_SALES_PERSON values (52,'William','Kudo','28/03/1993',sysdate); end