SyncEditor doesn't show all columns of view, both SSMS and Data Importer do

Question

HI all, 
 
 I was wondering if anyone could help provide some insight as to what might be going on here. 
 
 I am connecting to a new MSSQL view for my current project. When connecting to the view in SyncEditor I am given only a limited list of the columns. However, when looking at the same view as the same account either in SSMS or in OneIdentity Data Importer I can access all of the columns. 
 
 while this means I can accomplish my task with the data importer I would prefer to use the sync editor if I can get this solved.

Thanks, 
 -Aaron

Markus Weiss-Ehlers · Accepted Answer

If the native MSSQL Connector is unable to infer the data type of these columns you have two options. 
 Option 1: In the view convert the data type Flag(bit) to a boolean. 
 Option 2: Use the generic ADO.NET connector, because you want to read the information anyways.

Markus Weiss-Ehlers · Answer

It would help if you could provide the schema information of the SQL view. Especially which data types, field length, nullability, and such. The thing is that the wizard wants you to pick a unique key at this point and nullable fields are not unique by definition and therefore will not be displayed (as far as I remember).

Endpoint Privilege Management

SyncEditor doesn't show all columns of view, both SSMS and Data Importer do

Top Replies