Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

DB Connector - SQL Server

Community_User
Saviynt Employee
Saviynt Employee
Originally posted on March 9 2020 at 23:35 UTC

Hello, we are working on an account import from a application database. The database server is SQL Server. We have designated the following settings:

URL: jdbc:sqlserver://<server IP>

UserName: Local SQL account

Password:

Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver

AccountsImport:

<dataMapping>

<before-import>

</before-import>

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

<![CDATA[

select UserId, Email, BranchCode from UserTable where BranchCode='567' OR BranchCode="890";

]]>

</sql-query>

<mapper description="This is the mapping field for Saviynt Field name" ifusernotexists="noaction">

<mapfield saviyntproperty="accounts.name" sourceproperty="UserId" type="character"></mapfield>

<mapfield saviyntproperty="accounts.CustomProperty1" sourceproperty="Email" type="character"></mapfield>

<mapfield saviyntproperty="accounts.CustomProperty2" sourceproperty="BranchCode" type="character"></mapfield>

</mapper>

<after-import description="EMAIL,BATCH,SQL">

</after-import>

</dataMapping>


We have two questions related to this:

When running the AccountImportFullJob, we are required to select a File Name. our options are datafiles, fail, process, sav, success,xmlschemaforexternaldbimport. The DB Connect documentation states that if we populate the AccountsIMport section, we are not required to upload the schema. I can't find any documentation tied to the FIle Name items listed as options.

When running the AccountImportFullJob, with any File Name option, we get the following error. it is referring to MySQL, but our connection is configured for SQL Server. The query runs just fine outside of Saviynt.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1

This message was previously posted on Saviynt's legacy forum by a community user and has been moved over to this forum for continued exposure.
Who Me Too'd this topic