These are the details which should be available to successfully connect with the database during the Informatica Power Center installation.
Database Type : Choose your Repository database (Oracle/SQL Server/Sybase)
Database user ID : Database user ID to connect database.
Username should have DBA access. This is to create a schema and load all the repository tables in the further installation steps.
Create a separate user instead of using the available local system users like sys or scott or system. This is to separate the Repository tables and avoid any manual mistakes which will lead to the corruption of the metadata tables.
User Password : Password
Schema Name : If Schema name is not provided default schema will be used.
Database Address and Port : Machine on which database in installed and default port number.
If Informatica is being installed in the same machine where oracle is installed, then you can use the machine name or the host name as ‘localhost’.
If the database is on some other machine then you need to get the machine’s alias name or the network name and use it where ever applicable.
The default port number for Oracle is always 1521
The default port number for SQL server is always 1433
*The ports numbers will change in most of the real time implementations and you need to get those details from the Informatica Administrators or the Oracle DBAs
Database Service Name : Database Name.
If you have used the default ‘SID’ or ‘service name’ it would be ‘orcl’ or ‘ORCL’ else the name which you have used during the installation of Oracle database.