{"type":"doc","content":[{"type":"layoutSection","content":[{"type":"layoutColumn","attrs":{"width":66.66},"content":[{"type":"paragraph","content":[{"text":"SNP Glue™ Objects Generation is a tool that is used to generate multiple extraction objects from multiple sources which can be SAP tables, InfoCubes, DSOs, ADSOs, or ODP. This functionality is available via transaction code ","type":"text"},{"text":"/DVD/GL_OBJ_GEN.","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"layoutColumn","attrs":{"width":33.33},"content":[{"type":"paragraph","content":[{"text":"In this section:","type":"text","marks":[{"type":"strong"}]}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"children","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"55c56a21454a12f089c5cb9e98a8128d"},"schemaVersion":{"value":"2"},"title":"Child pages (Children Display)"}},"localId":"910fa032-452a-48cf-8e79-342c1d777f06"}}]}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"Currently, only the generation of SNP Glue™ tables, SNP Glue™ queues, Extractor 1.0 objects, and Extractor 2.0 objects are supported.","type":"text"}]}]},{"type":"paragraph","content":[{"text":"The main screen is divided into multiple sections. Each section is dedicated to specifying parameters for different objects or functionality settings. You can find ","type":"text"},{"text":"Source selection","type":"text","marks":[{"type":"strong"}]},{"text":", ","type":"text"},{"text":"SNP Glue™ table generation, SNP Glue™ queue generation, Extractor generation, Extractor 2.0 generation, and Settings ","type":"text","marks":[{"type":"strong"}]},{"text":"parameters on the main screen.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":65.0},"content":[{"type":"media","attrs":{"width":1240,"id":"0dcafa96-fd71-44f5-9503-064bb29176d0","collection":"contentId-4510328804","type":"file","height":904}}]},{"type":"heading","attrs":{"level":5},"content":[{"text":"Source selection","type":"text"}]},{"type":"paragraph","content":[{"text":"This section specifies the list of source objects for which we want to generate SNP Glue™ objects. You need to select the object type and then an option specifying the selection of objects.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":30.0},"content":[{"type":"media","attrs":{"width":515,"id":"32085c35-b4e0-4f59-bf39-df44d8b62875","collection":"contentId-4510328804","type":"file","height":63}}]},{"type":"paragraph","content":[{"text":"For internal SAP objects","type":"text","marks":[{"type":"em"}]}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":30.0},"content":[{"type":"media","attrs":{"width":542,"id":"95376023-2902-40d1-90ae-2cf14d726df1","collection":"contentId-4510328804","type":"file","height":84}}]},{"type":"paragraph","content":[{"text":"For external tables","type":"text","marks":[{"type":"em"}]}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"width":531,"id":"16f210f7-7888-47d1-a94a-573a7c519458","collection":"contentId-4510328804","type":"file","height":84}}]},{"type":"paragraph","content":[{"text":"For ODP","type":"text","marks":[{"type":"em"}]}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Parameters:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Source type:","type":"text","marks":[{"type":"strong"}]},{"text":" Defines the type of all objects specified by the selection. SAP tables, InfoCubes, Tables from External storage, DSOs, ADSOs, and ODP are available.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Storage ID (only for External):","type":"text","marks":[{"type":"strong"}]},{"text":" Defines the storage ID from storage management where the External table is located.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Table is View (only for External):","type":"text","marks":[{"type":"strong"}]},{"text":" Defines if the table on external storage is/isn’t view.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Context (only for ODP): ","type":"text","marks":[{"type":"strong"}]},{"text":"Defines the name of the ODP Context also known as Provider in Monitor Delta Queues.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"SNP Glue™ table generation","type":"text"}]},{"type":"paragraph","content":[{"text":"This section specifies the way SNP Glue™ tables should be generated. The selection can be adjusted by double-clicking the row in ALV Grid and adjusting values in the ","type":"text"},{"text":"Settings ","type":"text","marks":[{"type":"strong"}]},{"text":"section.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":75.0},"content":[{"type":"media","attrs":{"width":930,"id":"6b50168a-3a68-4fb8-a0a3-f9c606c672cd","collection":"contentId-4510328804","type":"file","height":678}}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Parameters:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Name prefix: ","type":"text","marks":[{"type":"strong"}]},{"text":"Prefix of the SNP Glue™ table, e.g. if ZGL_ is entered, the SNP Glue™ table with the name ","type":"text"},{"text":"ZGL_","type":"text","marks":[{"type":"strong"}]},{"text":"MAKT will be generated for SAP table MAKT (generally, the SNP Glue™ table name consists of ++).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Name suffix: ","type":"text","marks":[{"type":"strong"}]},{"text":"Suffix of the SNP Glue™ table, e.g. if _TAB is entered, the SNP Glue™ table with the name MAKT","type":"text"},{"text":"_TAB ","type":"text","marks":[{"type":"strong"}]},{"text":"will be generated for SAP table MAKT (generally, the SNP Glue™ table name consists of ++).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Package: ","type":"text","marks":[{"type":"strong"}]},{"text":"Package in which you want to save your generated objects.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Folder: ","type":"text","marks":[{"type":"strong"}]},{"text":"Folder in which you want to save your generated objects. Only available if allowed in SNP Glue™ settings (","type":"text"},{"text":"/dvd/gl_sett","type":"text","marks":[{"type":"strong"}]},{"text":"). If the folder does not exist, it will be generated.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Storage ID: ","type":"text","marks":[{"type":"strong"}]},{"text":"Target storage ID.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Meaningful fields:","type":"text","marks":[{"type":"strong"}]},{"text":" Flag indicating whether ","type":"text"},{"text":"Meaningful fields functionality","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/DATAVARD/pages/4510321986"}}]},{"text":" should be used.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Add deletion flag: ","type":"text","marks":[{"type":"strong"}]},{"text":"Flag will add a field for the deletion flag. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Do not activate:","type":"text","marks":[{"type":"strong"}]},{"text":" Only objects with status saved will be generated when checked.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Google Cloud Cortex: ","type":"text","marks":[{"type":"strong"}]},{"text":"Only displayed for Google BigQuery. The flag will add Google Cloud Cortex-specific fields RECORDSTAMP, OPERATION_FLAG, IS_DELETED into Glue Table. More information can be found in the chapter ","type":"text"},{"text":"Google Cloud Cortex integration","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/DATAVARD/pages/4510330050"}}]},{"text":". ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Table Name (Optional): ","type":"text","marks":[{"type":"strong"}]},{"text":"Only displayed for Google BigQuery, Kafka and Snowflake storages. The name of the database table that will be created on the storage. The field could contain the following placeholders:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":": Will be replaced with the source object name in uppercase.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":": Will be replaced with the source object name in lowercase.","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Add SNP Glue™ request field: ","type":"text","marks":[{"type":"strong"}]},{"text":"When checked, the field GLREQUEST will be added to the SNP Glue™ table structure.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Set SNP Glue™ request as key: ","type":"text","marks":[{"type":"strong"}]},{"text":"When checked, the field GLREQUEST will be a part of the primary key in the SNP Glue™ table structure.","type":"text"},{"text":" ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Settings for binary storage: ","type":"text","marks":[{"type":"strong"}]},{"text":" Setting specific for binary storage. These settings will be ignored when transparent storage is used. More information can be found in the chapter ","type":"text"},{"text":"File storage options","type":"text","marks":[{"type":"link","attrs":{"href":"https://datavard.atlassian.net/wiki/spaces/DATAVARD/pages/4510322178#FILE_STOR_OPTIONS"}}]},{"text":".","type":"text"}]}]}]},{"type":"panel","attrs":{"panelType":"note"},"content":[{"type":"paragraph","content":[{"text":"Storage ID is a mandatory parameter. You can use F4 help to select a valid value for these parameters.","type":"text"}]}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"For more information about SNP Glue™ tables, see the following page ","type":"text"},{"text":"Create SNP Glue™ Table","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/DATAVARD/pages/4510321767"}}]},{"text":".","type":"text"}]}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"Be aware that not all storages allow the name of the SNP Glue™ table with a non-alphabetical character at the beginning. ","type":"text"}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"SNP Glue™ queue generation","type":"text"}]},{"type":"paragraph","content":[{"text":"This section specifies the way the SNP Glue™ queue should be generated. The selection can be adjusted by double-clicking the row in ALV Grid and adjusting values in the ","type":"text"},{"text":"Settings ","type":"text","marks":[{"type":"strong"}]},{"text":"section.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":75.0},"content":[{"type":"media","attrs":{"width":1259,"id":"b8711a80-e87e-41cb-a50d-291f27ed7baf","collection":"contentId-4510328804","type":"file","height":571}}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Parameters:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Name prefix: ","type":"text","marks":[{"type":"strong"}]},{"text":"Prefix of the SNP Glue™ queue, e.g. if ZGL_ is entered, the SNP Glue™ queue with a name starting with ZGL_ will be generated (generally, the SNP Glue™ queue name consists of ++).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Name suffix: ","type":"text","marks":[{"type":"strong"}]},{"text":"Suffix of the SNP Glue™ queue. E.g. if _Q is entered, the SNP Glue™ queue with a name ending with _Q will be generated (generally, the SNP Glue™ queue name consists of ++).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Package: ","type":"text","marks":[{"type":"strong"}]},{"text":"Package in which you want to save your generated objects.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Folder: ","type":"text","marks":[{"type":"strong"}]},{"text":"Folder in which you want to save your generated objects. Only available if allowed in SNP Glue™ settings (","type":"text"},{"text":"/dvd/gl_sett","type":"text","marks":[{"type":"strong"}]},{"text":"). If the folder does not exist, it will be generated.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Source object type: ","type":"text","marks":[{"type":"strong"}]},{"text":"Type of the source object ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"DDIC:","type":"text","marks":[{"type":"strong"}]},{"text":" DDIC object","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"GL_TAB:","type":"text","marks":[{"type":"strong"}]},{"text":" SNP Glue™ table","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"QUEUE:","type":"text","marks":[{"type":"strong"}]},{"text":" SNP Glue™ Queue object","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Source object ID: ","type":"text","marks":[{"type":"strong"}]},{"text":"For the DDIC source object type the value should be ","type":"text"},{"text":"0","type":"text","marks":[{"type":"strong"}]},{"text":". This is automatically added after entering the DDIC source type and pressing enter.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Extractor generation","type":"text"}]},{"type":"paragraph","content":[{"text":"This section specifies the way SNP Glue™ Extractor objects should be generated. The selection can be adjusted by double-clicking the row in ALV Grid and adjusting values in the ","type":"text"},{"text":"Settings ","type":"text","marks":[{"type":"strong"}]},{"text":"section.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":65.0},"content":[{"type":"media","attrs":{"width":928,"id":"d29edb54-07f9-4a2d-8f75-36205ed4ad42","collection":"contentId-4510328804","type":"file","height":682}}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Parameters:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Name prefix","type":"text","marks":[{"type":"strong"}]},{"text":":","type":"text"},{"text":" ","type":"text","marks":[{"type":"strong"}]},{"text":"Prefix of the Extractor 1.0 object, e.g. if ZGL_ is entered, the Extractor object with a name starting with ZGL_ will be generated (generally, the SNP Glue™ table name consists of ++).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Name suffix: ","type":"text","marks":[{"type":"strong"}]},{"text":"Suffix of the Extractor 1.0 object, e.g. if _TAB is entered, the Extractor object with a name ending with _TAB will be generated (generally, the SNP Glue™ table name consists of ++).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Package: ","type":"text","marks":[{"type":"strong"}]},{"text":"Package in which you want to save your generated objects.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Target SNP Glue™ table ID: ","type":"text","marks":[{"type":"strong"}]},{"text":"ID of generated SNP Glue™ table which will be set as a target. (This is the ID from the ","type":"text"},{"text":"SNP Glue™ table generation ","type":"text","marks":[{"type":"strong"}]},{"text":"section)","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Delta type: ","type":"text","marks":[{"type":"strong"}]},{"text":"Delta type used for data extraction.","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Read deleted entries: ","type":"text","marks":[{"type":"strong"}]},{"text":"When checked with Trigger delta, extraction will also transfer deleted records. ","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Skip initial full load:","type":"text","marks":[{"type":"strong"}]},{"text":" When checked, the initial extraction will transfer no data. Just delta will be initialized.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Truncate target table:","type":"text","marks":[{"type":"strong"}]},{"text":" When checked, the target table will be truncated (data will be deleted) before each extraction.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Mark key fields for selection:","type":"text","marks":[{"type":"strong"}]},{"text":" When checked, the fields from the primary key will be used for selection in SNP Glue™ Variants.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Do not activate:","type":"text","marks":[{"type":"strong"}]},{"text":" Only objects with status saved will be generated when checked.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Variant prefix: ","type":"text","marks":[{"type":"strong"}]},{"text":"Prefix of the Variant (generally, the SNP Glue™ Variant name consists of ++).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Variant suffix:","type":"text","marks":[{"type":"strong"}]},{"text":" Suffix of the Variant (generally, the SNP Glue™ Variant name consists of ++).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Variant package size: ","type":"text","marks":[{"type":"strong"}]},{"text":"Package size used for SNP Glue™ Variant. This parameter specifies the number of rows transferred to the target storage within a single package.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Extractor 2.0 generation","type":"text"}]},{"type":"paragraph","content":[{"text":"This section specifies the way SNP Glue™ Extractor 2.0 objects should be generated. The selection can be adjusted by double-clicking the row in ALV Grid and adjusting values in the ","type":"text"},{"text":"Settings ","type":"text","marks":[{"type":"strong"}]},{"text":"section.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":50.0},"content":[{"type":"media","attrs":{"width":930,"id":"fc3d77bd-87cd-4843-9492-cbc64be72ddd","collection":"contentId-4510328804","type":"file","height":681}}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Parameters:","type":"text"}]},{"type":"paragraph","content":[{"text":"All parameters are divided into 4 sections:","type":"text"}]},{"type":"heading","attrs":{"level":5},"content":[{"text":"General","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Name prefix: ","type":"text","marks":[{"type":"strong"}]},{"text":"Prefix of the Extractor 2.0 object E.g. if ZGL_ is entered, the Extractor 2.0 objects with a name starting with ZGL_ will be generated (generally, the SNP Glue™ table name consists of ++).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Package: ","type":"text","marks":[{"type":"strong"}]},{"text":"Package in which you want to save your generated objects.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Folder: ","type":"text","marks":[{"type":"strong"}]},{"text":"Folder in which you want to save your generated objects. Only available if allowed in SNP Glue™ settings (","type":"text"},{"text":"/dvd/gl_sett","type":"text","marks":[{"type":"strong"}]},{"text":"). If the folder does not exist, it will be generated.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Source object type: ","type":"text","marks":[{"type":"strong"}]},{"text":"Type of the source object ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"DDIC:","type":"text","marks":[{"type":"strong"}]},{"text":" DDIC object","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"GL_TAB:","type":"text","marks":[{"type":"strong"}]},{"text":" SNP Glue™ table","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"QUEUE:","type":"text","marks":[{"type":"strong"}]},{"text":" SNP Glue™ Queue object","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Source object ID: ","type":"text","marks":[{"type":"strong"}]},{"text":"For the DDIC source object type the value should be “0”. This is automatically added after entering the DDIC source type and pressing enter.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Target object type","type":"text","marks":[{"type":"strong"}]},{"text":": Type of the target object ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"GL_TAB:","type":"text","marks":[{"type":"strong"}]},{"text":" SNP Glue™ Table","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"QUEUE:","type":"text","marks":[{"type":"strong"}]},{"text":" SNP Glue™ Queue object","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Target object ID: ","type":"text","marks":[{"type":"strong"}]},{"text":"ID of a generated object which will be set as a target (this is the ID from the ","type":"text"},{"text":"SNP Glue™ table generation ","type":"text","marks":[{"type":"strong"}]},{"text":"section).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Do not activate","type":"text","marks":[{"type":"strong"}]},{"text":": Only objects with status saved will be generated when checked.","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":75.0},"content":[{"type":"media","attrs":{"width":868,"id":"2c9e67ab-2faf-47d7-877c-c5536260f410","collection":"contentId-4510328804","type":"file","height":505}}]},{"type":"heading","attrs":{"level":5},"content":[{"text":"Fetcher","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Name suffix: ","type":"text","marks":[{"type":"strong"}]},{"text":"Suffix of the Extractor 2.0 Fetcher. E.g. if _F is entered, the Fetcher with a name ending with _F will be generated (generally, the SNP Glue™ table name consists of ++).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Delta type: ","type":"text","marks":[{"type":"strong"}]},{"text":"Delta type used for data extraction.","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Read deleted entries: ","type":"text","marks":[{"type":"strong"}]},{"text":"When checked with Trigger delta, extraction will also transfer deleted records. ","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Use deduplication:","type":"text","marks":[{"type":"strong"}]},{"text":" When checked, it removes duplicate values from a single data load, keeping only the latest value for each record. Relevant only to the ADSO source. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Mark key fields for selection:","type":"text","marks":[{"type":"strong"}]},{"text":" When checked, selected fields from the primary key will be used for selection in SNP Glue™ Variants.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Read all clients:","type":"text","marks":[{"type":"strong"}]},{"text":" Checkbox to fetch data from the SAP table for all clients, the table must have the ","type":"text"},{"text":"MANDT","type":"text","marks":[{"type":"strong"}]},{"text":" field.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Use DB aggregation (relevant only for InfoCube): ","type":"text","marks":[{"type":"strong"}]},{"text":"Checkbox for using Database aggregation.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Use CUBE aggregates (relevant only for InfoCube): ","type":"text","marks":[{"type":"strong"}]},{"text":"Checkbox for using InfoCube aggregates.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Subscriber name (relevant only for ODP): ","type":"text","marks":[{"type":"strong"}]},{"text":"Name of the ODQ subscriber, default is ","type":"text"},{"text":"SNP GLUE.","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Subscriber process (relevant only for ODP): ","type":"text","marks":[{"type":"strong"}]},{"text":"Name of the subscriber process, default is ","type":"text"},{"text":"SNP_PROCESS.","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Execution mode (relevant only for ODP): ","type":"text","marks":[{"type":"strong"}]},{"text":"Mode of the execution can also be changed in the extraction process execution screen.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":5},"content":[{"text":"SNP Glue™ Table Consumer","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Name suffix: ","type":"text","marks":[{"type":"strong"}]},{"text":"Suffix of the Extractor 2.0 SNP Glue™ Table Consumer. E.g. if _C is entered, the Consumer with a name ending with _C will be generated (generally, the SNP Glue™ table name consists of ++).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable merge: ","type":"text","marks":[{"type":"strong"}]},{"text":"This flag enables merge functionality in the Consumer.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":5},"content":[{"text":"Extraction Process","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Name suffix: ","type":"text","marks":[{"type":"strong"}]},{"text":"Suffix of the Extractor 2.0 Extraction Process. E.g. if _P is entered, the Extraction Process with a name ending with _P will be generated (generally, the SNP Glue™ table name consists of ++).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Apply field routines: ","type":"text","marks":[{"type":"strong"}]},{"text":"This flag automatically applies to all field routines.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Queue processing","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":75.0},"content":[{"type":"media","attrs":{"width":1110,"id":"cce3e45d-6be7-4a08-b2aa-da245e479e35","collection":"contentId-4510328804","type":"file","height":194}}]},{"type":"paragraph","content":[{"text":"The queue processing button will prefill automatically 2 groups of Extraction 2.0 objects necessary for Queue execution:","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The first group is handling insertion into SNP Glue™ Queue (from SAP table to SNP Glue™ Queue).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The second group is handling pulling data from Queue (from SNP Glue™ Queue to SNP Glue™ table (any target)).","type":"text"}]}]}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"More about SNP Glue™ Queues can be found in the chapter ","type":"text"},{"text":"\"Heavy lifting\" extraction using Queue","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/DATAVARD/pages/4510321123"}}]},{"text":".","type":"text"}]}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"More information about SNP Glue™ Extractor 2.0 objects can be found in the chapter ","type":"text"},{"text":"Extractor 2.0","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/DATAVARD/pages/4510323010"}}]},{"text":" and its sub-pages.","type":"text"}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Executing object generation","type":"text"}]},{"type":"paragraph","content":[{"text":"When the parameters are filled, based on your requirements, you can proceed to object generation itself.","type":"text"}]},{"type":"paragraph","content":[{"text":"You can choose from two options. You can either generate objects in the dialog process by pressing the ","type":"text"},{"text":"Generate","type":"text","marks":[{"type":"strong"}]},{"text":" button from the toolbar or generate objects in the background job by pressing ","type":"text"},{"text":"Generate (background)","type":"text","marks":[{"type":"strong"}]},{"text":".","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":40.0},"content":[{"type":"media","attrs":{"width":871,"id":"b3ab8128-579f-4a51-8af0-12c9718883ae","collection":"contentId-4510328804","type":"file","height":82}}]},{"type":"paragraph","content":[{"text":"In case you choose ","type":"text"},{"text":"Generate (background)","type":"text","marks":[{"type":"strong"}]},{"text":",","type":"text"},{"text":" ","type":"text","marks":[{"type":"strong"}]},{"text":"the SAP standard dialog for background job scheduling will appear as shown in the following image:","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":40.0},"content":[{"type":"media","attrs":{"width":730,"id":"0b92c155-795c-4acf-bb51-1140a3598efd","collection":"contentId-4510328804","type":"file","height":604}}]},{"type":"paragraph","content":[{"text":"In case you choose to ","type":"text"},{"text":"Generate","type":"text","marks":[{"type":"strong"}]},{"text":" in the dialog process, you will see the pop-up with logs after object generation is finished. These logs will give you a general overview of objects generated using this functionality. In the following image you can see an example:","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":40.0},"content":[{"type":"media","attrs":{"width":612,"id":"a0e3f52c-8d2f-4a4c-8524-2059b41ff76b","collection":"contentId-4510328804","type":"file","height":432}}]},{"type":"paragraph"}],"version":1}

Browser not supported