====== 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: {{ :bps2:createdb:img-1015.png |Start Menu}} ===== Welcome page ===== * 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. {{ :bps2:createdb:img-1000.png |Intro}} ===== Database type ===== * Select the database you are using. * Click //Next// to continue {{ :bps2:createdb:img-1001.png |Driver}} ===== Oracle DBA login ===== * 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. {{ :bps2:createdb:img-1003.png |Oracle}} ===== PostgreSQL superuser login ===== * 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. {{ :bps2:createdb:img-1002.png |PostgreSQL}} ===== BPS Owner / Schema ===== * 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. {{ :bps2:createdb:img-1004.png |Owner}} ===== Tablespace selection ===== * Select the tablespaces that you created for this BPS datastore. * Click //Next// to continue. {{ :bps2:createdb:img-1005.png |Tablespaces}} ===== Connection name ===== * 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. {{ :bps2:createdb:img-1006.png |Connection}} ===== Summary ===== * 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. {{ :bps2:createdb:img-1007.png |Summary}} ===== Creation log ===== * 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. {{ :bps2:createdb:img-1008.png |Log}}