FDS :: Data is inserted into target table with one or more reference columns as empty even though data exists due to domain separation<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Please follow the below information when using Foundation Data Sync for Consumer along with Domain Separation: When domain separation is installed, Users that exist in the instance may have a domain assigned to them, which helps in managing and organizing user access and permissions within the system. This domain assignment is crucial for maintaining security and ensuring that users only have access to the resources and data they are authorized to use. The steps in ETL for each subscription item will be configured by the user, and upon completion of the integration step, which is the final stage in the process, ETL will be activated. Subsequently, FDS will create a scheduled import job that will be utilized to process the data received from the provider, ensuring a seamless and efficient data transfer process. This scheduled import job is being created with "Run as" as the user configuring the ETL. If that user does not have the necessary domain visibility over other data, then reference columns in the target rows will be empty, which may impact the accuracy and completeness of the data being transferred. It is essential to ensure that the user configuring the ETL has the appropriate domain permissions to avoid any potential issues with data visibility and integrity. For example: User A, who belongs to the domain (XYZ), is configuring the ETL process. The scheduled import job is set to run under the context of User A. However, when a row containing a column, such as 'company', is being processed, the input data for the company (Company1) with its associated domain (C1) will not be visible to User A during the processing of this payload. Consequently, the resulting data inserted into the target table will have the 'company' column appear as empty, due to the lack of domain visibility for User A. Steps to be performed: 1. Go to System Import Sets -> Administration -> Scheduled Imports 2. Search with subscription item number in the "Name" field 3. Change the "Run as" field to System administrator or any user who has privileges to create data in the target table 4. Save the record. Note: This will affect the sample payload processing as the import job is not yet created considering the user's domain.