OMrun Help Online Manual for OMrun Version 4

Environment


OMrun Environment Icon

Abstract

Overview in grid format of all source connection details like login credentials of databases, paths of flat files and reusable variable strings in an asccending Id order.

Aliases are key elements, starting always with an "@", and are used to select the data source within a data query.

Nested variables are allowed and are extracted during run time execution.

The connection string is extracted during run time execution from the matching data adapter.


Environment Characteristics

Existing environments are shown on the top of the Navigation Tree.
At least one environment is always selected, visible in the bread crumb.

There are two environment sections defined:

  • Local environment settings
    which are set specific for each environment.
  • Global environment settings
    which are usable throughout all environments of this business system specified.

For alias definition with the same name, the global alias is overwritten by the local alias. Define as much as possible within the global definition section and add specifics in the local section.


New

On Navigation Tree at environments level click on the right mouse button and select New.


Copy, Rename, Delete

On Navigation Tree at environments level click on the right mouse button and select Copy, Rename or Delete.


Field Description

Column Description
Id Id generated when adding a new environment row. Defines the sort order of the environment entries. It is allowed to manually change the number.
Alias Enter the Data Source Alias (Variable). Use always @ to begin with.
Db Type Select Data Type from drop down list. Data Types are defined in the configuration.
Server Enter server name or file destination.
Db Enter database name, schema name, file name or any string content of an OMIS Variable.
User Name Enter User Name used to login to the data source.
Password Enter password used to login to the data source. The password is not visible in plain text. It is hidden behind 6 asterisks [******] independent of the real length of the password. It is saved encrypted on any environment file [*.env] or log file [*.log.txt]. Passwords up to 40 characters long are allowed.
Trusted User Select trusted for login to the data source with credentials of the current windows user.

Environment examples for different Adapter Types

Alias Db Type Server Db Trusted User Example Query
@Access_2003 Access (OLEDB) D:\Excel\Migration Access_2003.mdb Checked SELECT VehicleId AS VehicleId, Mark AS Mark, Model AS Model, Color AS Color, EmptyWeight AS EmptyWeight FROM VehicleA WHERE Color = '@param1'
@DB2 IBM DB2 (IBM) Server name Database name Unchecked SELECT VehicleId AS VehicleId, Mark AS Mark, Model AS Model, Color AS Color, EmptyWeight AS EmptyWeight FROM @DB_Schema.VehicleA WHERE Color = '@param1'
@Excel_Vehicle Excel (OLEDB) + HDR D:\Excel\Migration Vehicle.xlsx Checked SELECT VehicleId AS VehicleId, Mark AS Mark, Model AS Model, Color AS Color, EmptyWeight AS EmptyWeight FROM [VehicleA$] WHERE Color = '@param1'
@Flatfile_Account FlatFile (OLEDB) – HDR D:\Excel\Migration n/a Checked SELECT L1 AS VehicleId, L2 AS Mark, L3 AS Model, L4 AS Color, L5 AS EmptyWeight FROM Vehicle_semi.txt WHERE L4 = '@param1'
@iSeries IBM AS/400 (IBM) Server name n/a Unchecked SELECT VehicleId AS VehicleId, Mark AS Mark, Model AS Model, Color AS Color, EmptyWeight AS EmptyWeight FROM VehicleA WHERE Color = '@param1'
@MySQL MySQL Server name:Port Schema name Unchecked SELECT VehicleId AS VehicleId, Mark AS Mark, Model AS Model, Color AS Color, EmptyWeight AS EmptyWeight FROM @DB_Schema.VehicleA WHERE Color = '@param1'
@Oracle Oracle Server name:Port Database name Unchecked SELECT VehicleId AS VehicleId, Mark AS Mark, Model AS Model, Color AS Color, EmptyWeight AS EmptyWeight FROM @DB_Schema.VehicleA WHERE Color = '@param1'
@Path_Excel OMIS Variable (OM) D:\Excel\Migration n/a Checked n/a
@SQLServer SQLServer Server name\SQL Server instance name Database name Unchecked / Checked SELECT VehicleId AS VehicleId, Mark AS Mark, Model AS Model, Color AS Color, EmptyWeight AS EmptyWeight FROM @DB_Schema.VehicleA WHERE Color = '@param1'