Environment

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, also visible in the bread crumb (in green).

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 an alias definition with the same name on both sections, the global alias is overwritten by the local alias. Define as much as possible within the global definition section and add specific definitions in the local section only.

New

Right click on navigation tree at parent level Environments (in green) and select New from dropdown menue.

Copy, Rename, Delete

Right click on navigation tree at child level of your environment name (in this example: PROD) and select Copy, Rename or Delete from dropdown menue.

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.

Column

Description

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.

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'

Alias

Db Type

Server

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'

PreviousComponent NextScenario

Last updated 2 months ago