Database Imports

[sab2]

hi,

we are creating a DB for our disconnected applications. We have 50 applications which we are loading into the database and then doing imports into Saviynt.

Is there a way to import all applications into Saviynt at once through one DB import job? or does each import need to be done specially to one application?

In other words, for application1 we need to run the DB application import for application1 accounts.

and then we would run DB accounts import for application2. Can this all be done simultaneously?

[rushikeshvartak]

You can import all application in one XML and one connection 

<dataMapping>
<sql-query description="Import" uniquecolumnsascommaseparated="name" >
<![CDATA[select accountName,securitysystemname,endpointname,entitlementtype,role,accountstatus,updatedate from accounts]]>
</sql-query>
<incrementalcondition>
<![CDATA['${incrementalcolmaxval.format("yyyy-MM-dd")}']]>
</incrementalcondition>
<mapper description="Import" ifusernotexists="create" addOnlyMode="true" deleteaccountentitlement="true" dateformat="date" incrementalcolumn="updatedate" systems="SecSystemName">
<mapfield saviyntproperty="accounts.name" sourceproperty="accountName" type="character"/>
<mapfield saviyntproperty="securitysystems.systemname" sourceproperty="'securitysystemname1','securitysystemname2'" type="character"/>
<mapfield saviyntproperty="endpoints.endpointname" sourceproperty="endpointname" type="character"/>
<mapfield saviyntproperty="entitlementtypes.entitlementname" sourceproperty="entitlementtype" type="character"/>
<mapfield saviyntproperty="entitlementvalues.entitlementvalue" sourceproperty="role" type="character"/>
<mapfield saviyntproperty="accounts.status" sourceproperty="accountstatus" type="number"/>
<mapfield saviyntproperty="accounts.customproperty25" sourceproperty="updatedate" type="date"/>
</mapper>
</dataMapping>