SBT Connector usage - Best Practice

Document ID : KB000019539
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

This document specifies how to use SBT Import connector from the portal

Solution:

Prepare the file:

When running an SBT file from a connector, a new XML tag USE_CONFIG should be defined


<BATCH>
<COMMAND     
 ACTION="IMPORT CSV" 
 ROLEID_AS_NUM="false" 
 CONFIG="..\Done\ConfigWithRoles-Test.cfg" 
 USERS_DB="..\Done\Users.udb" 
 RES_DB="..\Done\Resources.rdb" 
 ROLE="..\Done\Roles.csv" 
 USER_RES="..\Done\UserResource.csv" 
 USER_ROLE="..\Done\UserRole.csv" 
 ROLE_RES="..\Done\RoleResource.csv" 
 ROLE_ROLE="..\Done\RoleRole.csv">
</COMMAND>
<USE_CONFIG config="C:\batch\Done\ConfigWithRoles-Test.cfg"/>
</BATCH> 

The USE_CONFIG tag tells the connector which configuration to load into the predefined Universe and should contain the full path to the cfg file

Create the connector:

We configure an SBT connector from the Universe's Connectivity tab - Add Connector

Figure 1

Connector type should be Batch (SBT)

Figure 2

Once created and saved we can then run the sbt connector

Figure 3