Click HERE to see how Saviynt Intelligence is transforming the industry. |
04/12/2022 01:01 PM
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
Solved! Go to Solution.