PI Integrator for Business Analytics

Configure the Oracle target

Save PDF

Save PDF

Complete the procedure below to configure the Oracle target and test your connection to the Oracle database.

Install Oracle Database Access Components.

See Install Oracle Database Access Components.
Create the Oracle target. For more information, see Add a publish target.

On the Administration page, click the Targets tab. Then select the target in the Publish Targets list.

Note: If you have already selected your target, skip to the next step.

Configure the Oracle target with the following parameters:

Parameter	Description
Data Source	Oracle Net Services name, connect descriptor, or alias that identifies the Oracle database Note: See Install Oracle Database Access Components for information on how the Oracle Net Services name is specified.
Username	Username used to connect to the Oracle database
Password	Password used to connect to the Oracle database

Parameter

Description

Data Source

Oracle Net Services name, connect descriptor, or alias that identifies the Oracle database

Note: See Install Oracle Database Access Components for information on how the Oracle Net Services name is specified.

Username

Username used to connect to the Oracle database

Password

Password used to connect to the Oracle database

Click Connect to verify that you can connect to the database.
Click Save Changes.
Give users access to the Oracle target. For more information, see Grant access to targets.