Create datastore wizard

Once the database and tablespaces are created as described in the previous chapters, it is time to set up the users, roles and other objects which make up a BPS datastore (or schema).

Start the wizard by clicking on the Icon from the start menu:

• There are some instructions that you may read first. These instructions are a short summary of the topics explained in the previous chapters.
• Click Next to continue.

• Select the database you are using.
• Click Next to continue

• You will only see this if you selected Oracle as DB type.
• Enter the credentials of the DBA (normally this will be system)
• Select the TNS name. (BPS only supports this connection method of Oracle)
• Click Next to login and continue.

• You will only see this if you selected Oracle as DB type.
• Enter the credentials of the superuser (normally it is postgres)
• Enter host, post and the database created for BPS.
• Click Next to login and continue.

• Enter the name of the BPS owner, which will serve at same time as schema name.
• Enter the PIN code for the bps owner. Remember this is a integer number of 1 to 8 digits. In fact the database password may be prod1234, but here you only enter the numeric part, for example 1234.
• Click Next to continue.

• Select the tablespaces that you created for this BPS datastore.
• Click Next to continue.

• Enter a reasonable connection name.
• Normally you would allow this name to be shared for all users on this machine, so select to save in the system settings.
• Click Next to continue.

• The selections and settings made are displayed so you can check them.
• Check the confirmation checkbox if everything is OK, otherwise go back and fix what needs to be adjusted.
• Click Next to start creation of the datastore with these settings.

• The creation log is displayed while the actions are performed.
• If everything went well, the last message should be Database Successfully Initialized.
• Click Finish to terminate the wizard.