Database Installation
Pre-Installation Checklist
During database installation you will going to :
Create a new schema
Create a user with full read/write access to the Product 360 schemas, including the ability to create tables
So you will need a database user which has enough permissions to create other users and schemas, talk to your local DBA to get you an appropriate account. To setup a database and the database user management is not the scope of this installation instruction, however you will find some database setup/configuration hints in the next section DBMS Installation and Configuration Hints which should support you with the important points in matter of the Product 360 database installation.
Database Administration Tool
For database setup and configuration you will need a Database Administration Tool. For example MS SQL Server Management Studio or Oracle SQL Developer
After the database setup Test the connection by using the database administration tool installed on the Product 360 server to log in to the database
Database Information
During database setup you will have to provide a physical volume location on where to store the data and log files of the Product 360 databases
In case you need to use the special character '\' for an instance name of your database, you have to escape it with an additional backslash.
E.g. your instance name for a database is 'myDatabase\myInstance' then you have to define 'myDatabase\\myInstance' in the properties file
Default Product 360 Database Ports
Ensure you be aware of the database ports your database server is running on.
Port
Database
1433
MSSQL
1521
Oracle