Relational Connection

STEP1:

In Work Flow Select CONNECTIONS > RELATIONAL.

 

Relational Connection

STEP 2:

Click on : New…

SELECT SUBTYPE : ORACLE


STEP3:

Create a SOURCE Connection.

Provide a name to the source connection i.e., OLAP_INFRA

Enter USER NAME i.e., INFRATRAIN(schema name)

Enter CONNECT STRING : used database name

Enter PASSWORD (schema password)

Select CODE PAGE  as shown in the below screen shot and then click OK.


After execution of STEP 3 the screen will look like this:


Step 4:

Execute Step 3 again to create Target Connection.

Create a TARGET Connection.

Provide a name to the target connection i.e., OLTP_INFRA

Enter USER NAME i.e., INFRATRAIN(schema name)

Enter PASSWORD (schema password)

Select CODE PAGE  as shown in STEP 3 and then click OK.


Now the connection is ready to be used.

 

Leave A Reply

Your email address will not be published. Required fields are marked *