|
Quantum VS Help: File Maintenance |
To facilitate the maintenance and running of ETL Routines certain User Permissions must be enabled, along with other prerequisites.
Note: For further details see ETL Maintenance.
The following User Permissions may be used to enable (or disable) features relating to ETL Maintenance:
|
User Permission |
Definition
|
|
File Maintenance > ETL Routines:
|
|
|
Create
|
Enables the User to create new ETL Routines.
|
|
Edit
|
Enables the User to edit ETL Routines.
|
|
Delete
|
Enables the User to delete ETL Routines.
|
|
View
|
Enables the User to view ETL Routine records and Finder.
|
|
System Administration > Data Loader:
|
|
|
ETL Export |
Enables the User to access 'export' ETL Routines.
|
|
ETL Import
|
Enables the User to access 'import' ETL Routines.
|
|
ETL Add
|
Enables the User to access 'add' ETL Routines.
|
|
ETL Update |
Enables the User to access 'update' ETL Routines.
|
|
Note: The 'Data Loader' User Permissions can be used to control which ETL Routines a User will be presented with when running an ETL routine. Examples: (1) A User with ETL Export enabled and ETL Import disabled will be presented with export routines but not import routines. (2) A User with ETL Add enabled and ETL Update disabled will be presented with routines which add data only, and not routines which update existing data. |
|
User Permissions are enabled or disabled for a User via the Role they have been assigned - see Creating Roles.
User Permissions may be switched on or off for the current session only by selecting Tools > User Permissions from the Toolbar - Main Menu to display the Edit User Session Permissions Window (requires supervisor permissions). Check the boxes to allow permissions to the relevant application functions, then click OK. The procedure is similar to that used when Creating Roles.
Note: Newly-created User Permissions are typically not set for a User when upgrading to a new release of Quantum VS.
Before ETL Routine records can be created it will be necessary for an EDP Professional Services Implementer to set up values in the table file 'Data' (Data Loader Definitions) using Table File Maintenance. The 'Data' table file holds values which link the back-end Cobol routine (e.g. ETL6SL02) with a more user-friendly term associated with a data import or export routine (e.g. Customers).
IMPORTANT: Program values in the 'Data' table file must be set up by an EDP implementer; it is not necessary for Users to set these up.
NEXT: ETL Routine Maintenance