To create or edit an interface data source, specify the database details.The following table describes options for Performance Management Architect interface datasource details configuration.
| EPM System Configurator Fields | Description | Your Information |
|---|---|---|
Database Type | Displays the database type. | |
Datasource Name | Accept the default name, or enter a name for the data source. | |
Server | Accept the default name, or enter the name of the server hosting the database. (The default displays based on the database type.) | |
Port | Accept the default port number, or enter the port number of the server hosting the database. (The default displays based on the database type.) | |
SID (Oracle) or Database (MS SQL Server or IBM DB2) | Enter the database name to use as an interface data source. If you are using Oracle RAC, enter the service name. | |
User | Enter the user name for the database used as the interface data source. | |
Password | Enter the password for the database used as the interface data source. | |
Create interface tables | Select to create the interface tables in the database. Oracle recommends that you select this option. |