Skip to main content

Installation

Requirements​

  • Operating System: Support for Windows Server 2012, 2012 R2, 2016, and 2019
  • Java: Embedded OpenJDK 11
  • Microsoft SQL Server version 2012 SP3 or higher
  • OpCon Server version 18.3 minimum
  • OpCon RestAPI must be active for each OpCon system participating in OpCon Deploy
  • To use the Diagram feature, the open source software Graphviz (version 2.38), is required. This can be downloaded from www.graphviz.org.
  • To implement Windows Authentication for the OpCon Deploy Client requires manual configuration after the installation is complete.
  • To implement Windows Authentication for the OpCon Impex Server requires OpCon versions 21.0.10, 20.0.15 or greater and manual configuration after the installation is complete.
  • Version 22.2 requires matching SMA OpCon ImpEx2 versions (OpCon 22.1 or greater, OpCon 22.0.2 or greater, opCon 21.0.14 or greater and OpCon 20.0.20 or greater).

Deploy Installation​

The OpCon Deploy installation process consists of three basic steps: the installation of the client software, the installation of the database, and the installation of the server software.

The client software may be installed as many times as required on any Windows system.

The database should only be installed once on a SQL Server environment. It can be installed on an existing SQL Server implementation used by OpCon or on a separate installation. There are no dependencies between an SMA OpCon database and an SMA OpCon Deploy database.

The server software must be installed on each OpCon system that participates in the OpCon Deploy environment. Each participating OpCon system must have a valid OpCon Deploy license and the OpCon RestAPI must be active on each system as OpCon Deploy uses the OpCon RestAPI to perform the license check.

One OpCon server in the OpCon Deploy environment should be designated the BatchScheduleServer which will be used to schedule Batch Deployments, archive tasks, and database backups. This server does not require an OpCon Deploy license, but must have the OpCon RestAPI active so requests can be passed for processing. The client software should be installed on the server and the SMADeployPath global property should be set to the installation directory.

A single software installer provides the installation for the three options:

  • The installation of the client software
  • The installation of the database
  • The installation of the server software

Deploy New or Upgrade Installation​

Complete the procedures in this section to install or upgrade all components:

  1. Log in to the Windows machine as a local Administrator.
  2. Download the files from the https://smatechnologies.files.com/ site.
  3. Enter your valid username and password and click Login.
  4. Navigate to the /OpCon Releases/Deploy folder.
  5. Download the software.
  6. Double-click the SMA OpCon Deploy.exe. The Select Language screen appears.
  7. Select the desired language for the installation screens and click OK. The Welcome screen displays.
  8. Click Next.
  9. To change the default installation directory, click Change, enter a new directory, and then click Next. [OR] To select the default installation directory, click Next. The Custom Setup screen display.
  10. By default, all items will be installed.
  11. Click Next.
  12. Enter the OpCon Deploy database connection information for the client:
  • OpCon Deploy database server name (If a MS SQL instance is being used, enter <servername>\<instancename>)
  • SQL Server login ID
  • SQL Server login ID password
  • Database name (default: SMAOpConDeploy)
  1. Click Next.
  2. Enter the definitions for the ImpEx2 Server:
  • OpCon database server name (If a MS SQL instance is being used, enter <servername>\<instancename>)
  • OpCon database name
  • OpCon database login ID
  • OpCon database login ID password
  • The port number to be used for the ImpEx2 server (default 9001 for non-TLS, 9011 for TLS)
  • Select if the connection uses TLS
  1. Click Next.
  2. Click Done.

Deploy Client New Installation​

Complete the procedures in this section to install a new OpCon Deploy Client:

  1. Log in to the Windows machine as a local Administrator.
  2. Download the files from the https://smatechnologies.files.com/ site.
  3. Enter your valid username and password and click Login.
  4. Navigate to the /OpCon Releases/Deploy folder.
  5. Download the software.
  6. Double-click the SMA OpCon Deploy.exe. The Select Language screen appears.
  7. Select the desired language for the installation screens and click OK. The Welcome screen displays.
  8. Click Next.
  9. To change the default installation directory, click Change, enter a new directory, and then click Next. [OR] To select the default installation directory, click Next. The Custom Setup screen display.
  10. By default, all items will be installed. For this installation, only the SMA OpCon Deploy Client should be installed. Follow these steps to deselect the other items from the list so that they are not installed:
  • Click on the icon to the left of the SMA OpCon Deploy Database item.
  • Select the X (This feature will not be available.) option from the drop-down list.
  • Click on the icon to the left of the SMA OpCon Deploy Server item.
  • Select the X (This feature will not be available.) option from the drop-down.
  1. Click Next.
  2. Enter the OpCon database connection information for the client:
  • OpCon Deploy database server name (If a MS SQL instance is being used, enter <servername>\<instancename>)
  • SQL Server login ID
  • SQL Server login ID password
  • Database name (default: SMAOpConDeploy)
  1. Click Next.
  2. Click Done.

Deploy Database New Installation​

Complete the procedures in this section to install a new OpCon Deploy Database:

  1. Log in to the Windows machine as a local Administrator.
  2. Download the files from the https://smatechnologies.files.com/ site.
  3. Enter your valid username and password and click Login.
  4. Navigate to the /OpCon Releases/Deploy folder.
  5. Download the software.
  6. Double-click the SMA OpCon Deploy.exe. The Select Language screen appears.
  7. Select the desired language for the installation screens and click OK. The Welcome screen displays.
  8. Click Next.
  9. To change the default installation directory, click Change, enter a new directory, and then click Next. [OR] To select the default installation directory, click Next. The Custom Setup screen display.
  10. By default, all items will be installed. For this installation, only the SMA OpCon Deploy Database should be installed. Follow these steps to deselect the other items from the list so that they are not installed:
  • Click on the icon to the left of the SMA OpCon Deploy Client item.
  • Select the X (This feature will not be available.) option from the drop-down list.
  • Click on the icon to the left of the SMA OpCon Deploy Server item.
  • Select the X (This feature will not be available.) option from the drop-down.
  1. Click Next.
  2. Enter the OpCon Deploy database connection information for the client:
  • OpCon Deploy database server name (If a named MS SQL instance is being used, enter <servername>\<instancename>)
  • In the "Connect using:" section of the screen, you may elect to use either Windows authentication or SQL Server authentication by selecting the corresponding radio button.
  • If you select SQL Server authentication, then you must enter:
    • SQL Server login ID
    • SQL Server login ID password
  • Database name (default: SMAOpConDeploy)
  1. Click Next.
  2. Click Done.

Deploy Server New Installation​

Complete the procedures in this section to install a new OpCon Deploy Server:

  1. Log in to the Windows machine as a local Administrator.
  2. Download the files from the https://smatechnologies.files.com/ site.
  3. Enter your valid username and password and click Login.
  4. Navigate to the /OpCon Releases/Deploy folder.
  5. Download the software.
  6. Double-click the SMA OpCon Deploy.exe. The Select Language screen appears.
  7. Select the desired language for the installation screens and click OK. The Welcome screen displays.
  8. Click Next.
  9. To change the default installation directory, click Change, enter a new directory, and then click Next. [OR] To select the default installation directory, click Next. The Custom Setup screen display.
  10. By default, all items will be installed. For this installation, only the SMA OpCon Deploy Server should be installed. Follow these steps to deselect the other items from the list so that they are not installed:
  • Click on the icon to the left of the SMA OpCon Deploy Client item.
  • Select the X (This feature will not be available.) option from the drop-down list.
  • Click on the icon to the left of the SMA OpCon Deploy Database item.
  • Select the X (This feature will not be available.) option from the drop-down.
  1. Click Next.
  2. Enter the definitions for the ImpEx2 Server:
  • OpCon database server name (If a MS SQL instance is being used, enter <servername>\<instancename>)
  • OpCon database name
  • OpCon database login ID
  • OpCon database login ID password
  • The port number to be used for the ImpEx2 server (default 9001 for non-TLS, 9011 for TLS)
  • Select if the connection uses TLS
  1. Click Next.
  2. Click Done.

Deploy Client Configuration​

The config.ini file contains the configuration statements that provide the connection to the OpCon Deploy database. After installation, the config.ini file can be found in the c:\ProgramData\OpConxps\Deploy\client directory.

Users may establish a connection to the OpCon Deploy database using Windows Authentication. The databaseUser should be left blank and the password of the Windows Domain user should be encrypted and placed in the config file (see databaseUser / databaseUserPassword).

Users may establish a TLS connection to the OpCon Deploy database if required by adding ;ssl=require to the database URL (see databaseURL).

debug​

Set to true or false. Should only be set to true at SMA Technologies' request.

ebeanServerName​

The name of the Ebean Server.

  • For MS SQL: mssql

databaseDriver​

The database driver software class name.

  • For MS SQL: net.sourceforge.jtds.jdbc.Driver

databaseURL​

The database URL. If a specific database instance is to be used for MS SQL, the instance name is appended after the database name.

  • For MS SQL: jdbc:jtds:sqlserver: //<server>/SMAOpConDeploy jdbc:jtds:sqlserver://<server>/SMAOpConDeploy;instance=INST001

The database URL. If TLS is required append the ;ssl=require to the URL.

  • For MS SQL: jdbc:jtds:sqlserver: //<server>/SMAOpConDeploy jdbc:jtds:sqlserver://<server>/SMAOpConDeploy;ssl=require

databaseUser​

The name of the database user who has the required privileges to all tables in the OpCon Deploy database. For Windows Authentication, the field should be left blank.

databaseUserPassword​

The password of the database user, encrypted using the Enterprise Manager encryption tool. For Windows Authentication, the field should contain the encrypted password of the Windows User.

minConnections​

Use the default value of 1.

maxConnections​

Use the default value of 25.

graphvizDirectory​

Used with diagram feature and defines the location of the GraphViz dot exe program.

diagramDirectory​

Used with diagram feature and defines the location of the created .dot and .pdf files.

devOpsOrganization​

Used with DevOps integration and consists of the Organization name.

devOpsToken​

Used with DevOps integration and consists of the PAT (Personal Access Token) of the user that is allowed to access the data in the DevOps repository.

Sample Deploy Client Configuration File​


# SMA OpCon Deploy Configuration File

#

###########################

#  General Settings Area  #

###########################


debug=false

ebeanServerName=mssql

databaseDriver=net.sourceforge.jtds.jdbc.Driver

databaseUrl=jdbc:jtds:sqlserver://VM-REPOS-SQL/SMAOpconDeploy

# example for connecting to a specific instance
# databaseUrl=jdbc:jtds:sqlserver://VM-REPOS-SQL/SMAOpConDeploy;instance=INST001       

# example for connection using SSL
# databaseUrl=jdbc:jtds:sqlserver://VM-REPOS-SQL/SMAOpConDeploy;ssl=require

# example for connecting to a specific instance using SSL
# databaseUrl=jdbc:jtds:sqlserver://VM-REPOS-SQL/SMAOpConDeploy;instance=INST001;ssl=require

databaseUser=ormadmin

databaseUserPassword=sYnk3bzpZybGPbSOrhsr4g==

minConnections=1

maxConnections=25

graphvizDirectory=F:\\GraphViz_238\\bin\\dot.exe

diagramDirectory=C:\\test\\relmgmt\\diagrams

devOpsOrganization=SMATechnologies

devOpsToken=xxxxxxxxxxxxxxxxxxxxxxxx

Sample Deploy Client Configuration File using Windows Authentication​


# SMA OpCon Deploy Configuration File

#

###########################

#  General Settings Area  #

###########################


debug=false

ebeanServerName=mssql

databaseDriver=net.sourceforge.jtds.jdbc.Driver

databaseUrl=jdbc:jtds:sqlserver://VM-REPOS-SQL/SMAOpconDeploy

# example for connecting to a specific instance
# databaseUrl=jdbc:jtds:sqlserver://VM-REPOS-SQL/SMAOpConDeploy;instance=INST001

# example for connection using SSL
# databaseUrl=jdbc:jtds:sqlserver://VM-REPOS-SQL/SMAOpConDeploy;ssl=require

# example for connecting to a specific instance using SSL
# databaseUrl=jdbc:jtds:sqlserver://VM-REPOS-SQL/SMAOpConDeploy;instance=INST001;ssl=require

databaseUser=

databaseUserPassword=sYnk3bzpZybGPbSOrhsr4g==

minConnections=1

maxConnections=25

graphvizDirectory=F:\\GraphViz_238\\bin\\dot.exe

diagramDirectory=C:\\test\\relmgmt\\diagrams

devOpsOrganization=SMATechnologies

devOpsToken=xxxxxxxxxxxxxxxxxxxxxxxx

OpCon Deploy Server Configuration​

The config.ini file contains the configuration statements that provide the connection to the local OpCon system. After installation, the config.ini file can be found in the c:\ProgramData\OpConxps\Deploy\Server directory.

Configuring Windows Authentication​

When using Windows Authentication, the SMA OpCon Impex2 RestAPI service must be executed using a Windows Domain user.

  • Stop the the SMA OpCon Impex2 RestAPI service.
  • Set the opcon.db.using.winauth property to true.
  • Change the service to execute under a specific account (Properties -> Log On not Local System Account).
  • Ensure the chosen account is registered with SQL Server.
  • While the db user and password entered during installation are not used, they should not be removed from the config.ini file.
  • Restart the the SMA OpCon Impex2 RestAPI service.

Deploy Server Configuration Statement Descriptions​

Tag NameDescription
opcon.server.nameThe name of the OpCon server to which the OpCon Deploy RESTFul Server will connect
opcon.db.nameThe name of the OpCon database to which the OpCon Deploy RESTFul Server will connect (e.g., OPCONXPS)
opcon.db.userThe name of a valid user who has privileges on the database named in the opcon.db.name definition (e.g., opconsam)
opcon.db.passwordThe password of the user named in the opcon.db.user definition
opcon.db.using.winauthIndicates if the connection to the OpCon Database should use Windows Authentication (values true or false)
opcon.db.connection.maxThe maximum number fo simultaneous database connections allowed to the OpCon database
web.portThe port number used by the OpCon Deploy RESTFul server (default 9001)
system.debugSet to true or false - Should only be set to true at SMA Technologies' request

Sample Deploy Server Configuration File​

#
# OpCon server connection information
#
opcon.server.name=EC2AMAZ-2QV0RKO
opcon.db.name=OPCONXPS
opcon.db.user=opconsam
opcon.db.password=sYnk3bzpZybGPbSOrhsr4g==
opcon.db.using.winauth=false
opcon.db.connection.max=10
#
# REST server configuration
#
web.port=9001
#
# Logger configuration
#
system.debug=false

Sample Deploy Server Configuration File using Windows Authentication​

#
# OpCon server connection information
#
opcon.server.name=EC2AMAZ-2QV0RKO
opcon.db.name=OPCONXPS
opcon.db.user=opconsam
opcon.db.password=sYnk3bzpZybGPbSOrhsr4g==
opcon.db.using.winauth=true
opcon.db.connection.max=10
#
# REST server configuration
#
web.port=9001
#
# Logger configuration
#
system.debug=false

Deploy Database Backup Scripts​

When implementing a production environment, it is necessary to take regular backups of the OpCon Deploy database.

The scripts in <program data>/SMAOpConDeploy\Utilities\Database directory can be used to implement database and transaction log backups.

A schedule (DEPLOY_UTILITIES.json) containing the task definitions for the backup process is available in the templates directory of the client software. The machine name, directory, frequency, and user code that the tasks run under need to be transformed to match the target environment. The global property SMADeployDataPath should be set to the client program data directory so the programs can be executed.