DB Connection - Issues while import users

[Community_User]

Originally posted on July 5 2021 at 13:27 UTC

Team,

I have DB Connection which is pointing to Oracle database. Seems like while running the recon job users not loading into Saviynt.

Import JSON:

<dataMapping>

<sql-query description="This is the Source DB Query" uniquecolumnsascommaseparated="EMPLID">

<![CDATA[SELECT EMPLID,FIRST_NAME,LAST_NAME FROM <tablename>]]>

</sql-query>

<importsettings>

<zeroDayProvisioning>false</zeroDayProvisioning>

<userNotInFileAction>NOACTION</userNotInFileAction>

<checkRules>false</checkRules>

<buildUserMap>false</buildUserMap>

<generateSystemUsername>true</generateSystemUsername>

<userOperationsAllowed>UPDATE</userOperationsAllowed>

</importsettings>

<mapper description="This is the mapping field for Saviynt Field name" defaultrole="ROLE_END_USER" dateformat="date">

<mapfield saviyntproperty="customproperty1" sourceproperty="EMPLID" type="character"></mapfield>

<mapfield saviyntproperty="firstname" sourceproperty="FIRST_NAME" type="character"></mapfield>

<mapfield saviyntproperty="lastname" sourceproperty="LAST_NAME" type="character"></mapfield>

</mapper>

</dataMapping>

[Community_User]

Originally posted on July 15 2021 at 19:02 UTC

Hello,

Have you got any resolution? I am facing issues on entitlement import with oracle database.

[Community_User]

Originally posted on January 17 2022 at 16:36 UTC

Hi Sankara

Verify if EIC is using an older ojdbc.jar file such as ojdbc14.jar. If yes, replace the file with the latest supported ojdbc<n>.jar file. To check the details of supported ojdbc.jar files, visit the Oracle database vendor documentation and upload the correct JAR file in EIC. You can also contact the database administrator managing the target database. 

From Release v2021.0, the ojdbc.jar file is removed from the EIC war file. Use the external jar upload feature to upload JAR files. For more information on uploading JAR files, see Managing External Jar Files.