Copying MSI Version of Distribution File to Database Server

To autoupdate data from database server, copy update MSI package to the server.

If several different packages are copied to the server, to divide them, create a label that enables the user to explicitly identify update package.

Copying of MSI version of distribution file to database server enables the user to update Foresight Analytics Platform version directly from database server.

NOTE. The operation is available only for Oracle and MSSQL DBMS.

To execute copying, follow the steps:

Start the repository manager.

Load the RepoMngr.exe file from the folder with installed Foresight Analytics Platform.
Select the Foresight Analytics Platform 9.2 > Repository Manager item in the Windows main menu.

Select the Updating Platform and click the Continue button.
Specify parameters of update folder:

Folder. Specify the path to the folder where MSI files of Foresight Analytics Platform, MSI files of help systems (FP9Help_RU.msi, FP9Help_EN.msi), the Version.xml file, license file, and so on are located. The folder must contain the MSI files of Foresight Analytics Platform and the Version.xml file.
Label. Enter in the name of the label to identify this copy of Foresight Analytics Platform at database server. The label name will be further used to set up update.
Profile. Specify Foresight Analytics Platform version. By default the version of Foresight Analytics Platform is displayed, which is installed on the workstation, from which the MSI version is copied.
MSI Pack. Specify name of MSI package (FP9Standard.msi, FP9Full.msi); by default, the system shows the name of the MSI package corresponding to the Foresight Analytics Platform software package for the workstation, from which the MSI version is copied.

If the specified folder does not contain mandatory files, on attempt to go to the next page a message with a list of mandatory files appears.

Click the Next button to go to the next page.

Specify DBMS connection parameters:

DBMS Type. Select the DBMS type in the drop-down list. For details about available DBMS see the Supported DBMS subsection.

NOTE. Update from server database is available only for Oracle and MSSQL DBMS.

Advanced Settings. The button becomes available if setup is executed to a MS SQL server. In the advanced settings specify:
- File Group. If the file group is not specified by the user in the advanced settings, by default the box displays DEFAULT, and the file group specified in the database properties by default is used on connection.
- Scheme Administrator's Name in Database. The parameter is available in the dialog box if the database type is Microsoft SQL Server 2008\2012. The DATABASE OWNER data is used by default. If the DATABASE OWNER credentials are not available, specify the user who has the DB_OWNER privilege at the DBMS server. The system procedures are executed on behalf of the specified user.

Server. Enter server alias.
Database. The box is available if database type is set to Microsoft SQL Server DBMS. Set database name.
Schema. The box is available if the database type is Microsoft SQL Server DBMS. Specify the identifier of a user schema to use this schema in a database. The "dbo" is used by default.
User Name (Schema). PPUPDATE is entered into this box automatically.
Password. Enter the password for the PPUPDATE user.

IMPORTANT. To copy the MSI distribution file version, create a PPUPDATE user. The schema of this user will store Foresight Analytics Platform distribution file, and it will be taken from this schema on update.

Click the Check Connection button to check if the specified data is correct. An appropriate message appears if connection is successful or failed.

Click the Next button to start copying, at the same time, the progress is shown.

An appropriate message appears after the process has been completed, informing whether it has been completed successfully or any errors occurred.

Thus, having copied several versions of Foresight Analytics Platform to server and having assigned corresponding labels for them, it is possible to autoupdate Foresight Analytics Platform version on the client workstation by the set label on starting Foresight Analytics Platform.

Example

Click the Settings button in the login dialog box. The Parameters dialog box opens where go to the Update tab:

In the Source group, select the DB Server checkbox, and fill in the required box. In the Update Label list select the label name that identifies the required copy of Foresight Analytics Platform at database server.