Setup Microsoft SQL Server - EcoSys - - Installation & Upgrade - Hexagon PPM

EcoSys Connect Installation and Configuration

PPMProduct
EcoSys
PPMCategory_custom
Installation & Upgrade
Version_EcoSys
1.1

Microsoft SQL Server database prerequisites and setup.

Microsoft SQL Server Prerequisites

  1. Enable the "Allow remote connections to server" setting.

EcoSys Connect Collation Support

The EcoSys Connect requires a Case Insensitive (CI) collation.

Setting Up the SQL Server Database

  1. Edit the \database\create\sqlserver\setup\create.sql script:

    • If a password other than "ecuser" is used for "ecuser" login, modify the portion of the script that creates the "ecuser" login and password.

      Create Login as ECUSER with password = ecuser

  2. Execute the create.sql

    Script as SA or a privileged user.

  3. Apply schema updates as follows:

    1. Copy the correct JDBC jar file to the \database\upgrade folder

    2. Open the \database\upgrade\liquibase.properties file for editing

      1. Locate the SQL Server section, set the URL, username, Password, liquibaseSchemaName, and classpath based on your environment.

      2. Save the file.

    3. Open a shell on the host

    4. Change directories to \database\upgrade

    5. Ensure JAVA is on the path
      JRE 1.8 or above is required

    6. Run the command upgrade.bat

    7. The result of the command appears as follows: