Environment
Last updated
Last updated
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.
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.
Right click on navigation tree at parent level 'Environments' (in dark blue) and select New from dropdown menue.
Right click on navigation tree at child level of your environment name (in dark blue) and select Copy, Rename or Delete from dropdown menue.
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.
@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'
