00197725-12_GS_SE3.11_EN.pdf - 第39页
Getting Started SIPLACE Explorer 3 SIPLACE Explorer Runtime Envi ronment from 3.11 (R20-2) Edition 11/2020 EN 3 9 3 Fig. 3 - 19 S tep 5: configure system database After entering the da t abase access paramet ers, we st…
3 SIPLACE Explorer Runtime Environment Getting Started SIPLACE Explorer
Edition 11/2020 EN from 3.11 (R20-2)
38
3.6.1.6 Step 5 - Configure System Database
Now, you can configure the SIPLACE Explorer System database settings:
– Microsoft SQL Server instance:port number
You can add the port number to the SQL Server instance, separated by a colon, for
example: PLK0495A\SIPLACE_2005EXPR:12345.
– Database name
– User Name
– Password
f you have imported a production line from the OIS the SIPLACE Explorer database settings
are automatically adopted.
NOTE
Click on the Browse for SQL instances icon. All SQL server instances available will be
shown in the Select SQL Server instance dialog box.
If the Select SQL Server instance dialog box shows no entries, you need to specify the SQL
server instance manually in the MS SQL Server field. 3
Getting Started SIPLACE Explorer 3 SIPLACE Explorer Runtime Environment
from 3.11 (R20-2) Edition 11/2020 EN
39
3
Fig. 3 - 19 Step 5: configure system database
After entering the database access parameters, we strongly recommend that you check the
connection to the database Click Test to check whether the connection to the database can be
established.
If the connection does not function properly or the database does not already exist, you will
see the following information box:
3
Fig. 3 - 20 DB error
Click on the Setup DB Connection button.
Start the DB Connection Wizard setup sequence, to configure the SIPLACE Explorer
system database. For a detailed description, please see “Database Connection Wizard” on
page 54. 3
3 SIPLACE Explorer Runtime Environment Getting Started SIPLACE Explorer
Edition 11/2020 EN from 3.11 (R20-2)
40
If the connection functions properly, you will see the following information box:
3
Fig. 3 - 21 Success
Click OK. The system will check the database data.
If the database has data from SIPLACE Explorer 2.0 - 3.10, you will need to convert the
database for SIPLACE 3.11, due to the changed data structure in the SIPLACE Explorer
3.11 database. Follow the instructions at “Converting the Database” on page 58. 3
Dependent of the database size, you can compress the database, the following information
window will open:
3
Fig. 3 - 22 Database compression
Follow the instructions at “Compressing the Database” on page 60.
After you have established the database connection and converted the database for SIPLACE
Explorer 3.11, you need to define the maintenance details for the system database, with the
Maintenance button.
The DB Maintenance dialog box will open. In this dialog box the following functionalities
are available:
– create a new archiving schedule for the database
– edit the default maintenance schedule
– database compression
– automate the database backup
The archiving process involves taking data from the database and saving it in a file, so that
the size of the database can be controlled. 3
All input fields will be disabled. To start or edit a DB maintenance schedule, you must have
administrator privileges for the database and the database connection must already be
established. 3