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