DNA User Guide › File Menu › Execute Batch File

Execute Batch File

When importing a large volume of data (which could involve several gigabytes in several source files), processing can take many hours. Therefore, a batch processing option enables processing during off-hours in accordance with a predetermined order determined by the Role Engineer.

The following list shows the typical order of commands in a batch file:

1. IMPORT RACF
2. IMPORT CSV
3. MERGE CFG
4. ENRICH UDB
5. ENRICH RDB
6. FILTER CFG

The input for batch file executions are XML text files, which should follow XML text file rules. The file extension is ".sbt", for example, "merge.sbt".

If the batch file is run from the Microsoft Windows desktop, the command line for executing the file is entered using the following format:

EurekifySageDNA-V32.exe<.sbt file name>

For example, EurekifySageDNA-V32.exe merge.sbt

Alternatively, the batch file can be run by selecting Run Batch File from the File menu.

Batch File: Example 1:

<BATCH>
<COMMAND
ACTION="IMPORT RACF"
CONFIG="Config.cfg"
USERS_DB="UsersDB.udb"
RES_DB="ResDB.rdb"
USERS="RacfUsers.txt"
GROUPS="RacfGroups.txt"
PROFILES_4="DataSetProfiles.txt"
PROFILES_5="GetresProfiles.txt"
UACC="true"
SUPP_HR="HR.txt"
GROUPS_AS_ROLES="false"
ADD_ACL_ENTITIES="true"/>

<COMMAND
ACTION="IMPORT CSV"
CONFIG="Config.cfg"
USERS_DB="UsersDB.udb"
RES_DB="ResDB.rdb"
ROLE="roles.txt"
USER_RES="user_res.txt"
USER_ROLE="user_role.txt"
ROLE_RES="role_res.txt"
ROLE_ROLE="role_role.txt"/>

<COMMAND
ACTION="EXPORT CSV"
CONFIG="Config.cfg"
ROLE="roles.txt"
USER_RES="user_res.txt"
USER_ROLE="user_role.txt"
ROLE_RES="role_res.txt"
ROLE_ROLE="role_role.txt"/>
<COMMAND
ACTION="MERGE CFG"
FIRST_CFG="First.cfg"
SECOND_CFG="Second.cfg"
TARGET_CFG="Target.cfg"
TARGET_UDB="Target.udb"
TARGET_RDB="Target.rdb"/>

<COMMAND
ACTION="ENRICH UDB"
SOURCE_UDB="Source.udb"
TARGET_UDB="Target.udb"
SUPP_FILE="HR.txt"/>

<COMMAND
ACTION="ENRICH RDB"
SOURCE_RDB="Source.rdb"
TARGET_RDB="Target.rdb"
SUPP_FILE="ResDB.txt"/>
</BATCH>

Batch file Example 2:

<BATCH>
<COMMAND
ACTION="IMPORT RACF"
CONFIG="Config.cfg"
USERS_DB="UsersDB.udb"
RES_DB="ResDB.rdb"
USERS="RacfUsers.txt"
GROUPS="RacfGroups.txt"
PROFILES_4="DataSetProfiles.txt"
PROFILES_5="GetresProfiles.txt"
UACC="true"
SUPP_HR="HR.txt"
GROUPS_AS_ROLES="false"
ADD_ACL_ENTITIES="true"/>

<COMMAND
ACTION="IMPORT CSV"
CONFIG="Config.cfg"
USERS_DB="UsersDB.udb"
RES_DB="ResDB.rdb"
ROLE="roles.txt"
USER_RES="user_res.txt"
USER_ROLE="user_role.txt"
ROLE_RES="role_res.txt"
ROLE_ROLE="role_role.txt"/>
<COMMAND
ACTION="EXPORT CSV"
CONFIG="Config.cfg"
ROLE="roles.txt"
USER_RES="user_res.txt"
USER_ROLE="user_role.txt"
ROLE_RES="role_res.txt"
ROLE_ROLE="role_role.txt"/>

<COMMAND
ACTION="MERGE CFG"
FIRST_CFG="First.cfg"
SECOND_CFG="Second.cfg"
TARGET_CFG="Target.cfg"
TARGET_UDB="Target.udb"
TARGET_RDB="Target.rdb"/>

<COMMAND
ACTION="ENRICH UDB"
SOURCE_UDB="Source.udb"
TARGET_UDB="Target.udb"
SUPP_FILE="HR.txt"/>

<COMMAND
ACTION="ENRICH RDB"
SOURCE_RDB="Source.rdb"
TARGET_RDB="Target.rdb"
SUPP_FILE="ResDB.txt"/>
</BATCH>

Batch File Example 3 (with Filters):

<BATCH>
<COMMAND ACTION="FILTER CFG" SOURCE_CFG="ConfigWithRoles.cfg" TARGET_CFG="UsersFiltered.cfg">
<CONDITION ENTITY="USER" FROM=" " TO="zzzzzzzzz" FIELD="PERSON_ID"/>
<CONDITION ENTITY="USER" FROM=" " TO="zzzzzzzzz" FIELD="USER_NAME"/>
<CONDITION ENTITY="USER" FROM=" " TO="zzzzzzzzz" FIELD="ORG_NAME"/>
<CONDITION ENTITY="USER" FROM=" " TO="zzzzzzzzz" FIELD="ORG_TYPE"/>
<CONDITION ENTITY="USER" FROM=" " TO="zzzzzzzzz" FIELD="FIELD_1"/>
<CONDITION ENTITY="USER" FROM=" " TO="zzzzzzzzz" FIELD="FIELD_6"/>
<CONDITION ENTITY="USER" FROM="0" TO="99999999" FIELD="DIRECT_RESOURCES"/>
<CONDITION ENTITY="USER" FROM="0" TO="99999999" FIELD="TOTAL_RESOURCES"/>
<CONDITION ENTITY="USER" FROM="0" TO="99999999" FIELD="DIRECT_ROLES"/>
</COMMAND>

<COMMAND ACTION="FILTER CFG" SOURCE_CFG="ConfigWithRoles.cfg" TARGET_CFG="RolesFiltered.cfg">
<CONDITION ENTITY="ROLE" FROM=" " TO="zzzzzzzzz" FIELD="NAME"/>
<CONDITION ENTITY="ROLE" FROM=" " TO="zzzzzzzzz" FIELD="DESCRIPTION"/>
<CONDITION ENTITY="ROLE" FROM=" " TO="zzzzzzzzz" FIELD="ORG"/>
<CONDITION ENTITY="ROLE" FROM=" " TO="zzzzzzzzz" FIELD="OWNER"/>
<CONDITION ENTITY="ROLE" FROM="0" TO="99999999" FIELD="DIRECT_RESOURCES"/>
<CONDITION ENTITY="ROLE" FROM="0" TO="99999999" FIELD="DIRECT_USERS"/>
<CONDITION ENTITY="ROLE" FROM="0" TO="99999999" FIELD="PARENT_ROLES"/>
<CONDITION ENTITY="ROLE" FROM="0" TO="99999999" FIELD="CHILD_ROLES"/>
</COMMAND>

<COMMAND ACTION="FILTER CFG" SOURCE_CFG="ConfigWithRoles.cfg" TARGET_CFG="ResourcesFiltered.cfg">
<CONDITION ENTITY="RESOURCE" FROM=" " TO="zzzzzzzzz" FIELD="RES_NAME_1"/>
<CONDITION ENTITY="RESOURCE" FROM=" " TO="zzzzzzzzz" FIELD="RES_NAME_2"/>
<CONDITION ENTITY="RESOURCE" FROM=" " TO="zzzzzzzzz" FIELD="RES_NAME_3"/>
<CONDITION ENTITY="RESOURCE" FROM=" " TO="zzzzzzzzz" FIELD="FIELD_1"/>
<CONDITION ENTITY="RESOURCE" FROM=" " TO="zzzzzzzzz" FIELD="FIELD_6"/>
<CONDITION ENTITY="RESOURCE" FROM="0" TO="99999999" FIELD="DIRECT_USERS"/>
<CONDITION ENTITY="RESOURCE" FROM="0" TO="99999999" FIELD="TOTAL_USERS"/>
<CONDITION ENTITY="RESOURCE" FROM="0" TO="99999999" FIELD="DIRECT_ROLES"/>
</COMMAND>
</BATCH>