3447118 - Import remote table from SuccessFactors does not bring all fields

Import a remote table from SuccessFactors does not bring all fields. For example fields Type PicklistOption.

SAP Datasphere

Import a remote table from SuccessFactors

Fields defined with Type PicklistOption(e.g), which means that this field is exposed via SuccessFactors OData API as navigation property of this main Entity. Navigation properties of SuccessFactors entities are not supported by remote table feature in Datasphere.

One option is to use Data flow to consume navigation property as explained in Add a Source of Data Flow - "[optional] For source tables from OData remote connections, you can edit the depth properties of a selected source table in the OData Properties section. Click Edit OData Properties to open the OData Properties dialog. You can set the depth of the source table to either 1 or 2. "

KBA , DS-DI-RT , Remote Tables , DS-DI-CON , Connections , Problem