{"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, ODP, or CDS views. 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":"72c40f68-fbb4-421a-a18b-5664aa81d1a8","collection":"contentId-5110147776","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":"887fd61f-a675-43c6-b799-6e3b3094c9ae","collection":"contentId-5110147776","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":"9a603990-0e3c-426e-9f7e-353ffbaf55cf","collection":"contentId-5110147776","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":"8f6bf37b-e1c3-4f0f-9bd6-3ec9ce53e25c","collection":"contentId-5110147776","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":"037a75ca-d25d-4cb0-86c1-5849b74f1839","collection":"contentId-5110147776","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":"https://datavard.atlassian.net/wiki/spaces/DATAVARD/pages/5110140560"}}]},{"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 and Google BigQuery Streaming storage types. 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":"https://datavard.atlassian.net/wiki/spaces/DATAVARD/pages/5110149039"}}]},{"text":". ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Table Name (Optional): ","type":"text","marks":[{"type":"strong"}]},{"text":"Only displayed for Google BigQuery, Google BigQuery Streaming, 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/5110140753/Glue-2502+Create+SNP+Glue+table+on+File+storage#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":"https://datavard.atlassian.net/wiki/spaces/DATAVARD/pages/5110140335"}}]},{"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":"26cfa009-92e4-4f44-b557-4476c3256976","collection":"contentId-5110147776","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":"panel","attrs":{"panelType":"note"},"content":[{"type":"paragraph","content":[{"text":"When using a CDS view as the source, set the source object type parameter to 'GL_TAB' and populate it with the target glue table name during queue generation.","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":"8e6d8c51-65cc-48c6-8d7d-e9ac0228ed65","collection":"contentId-5110147776","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":"a9874770-0792-493b-a40a-3818cfed3438","collection":"contentId-5110147776","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":"a6f2b0c3-64da-442e-9366-a95659d20245","collection":"contentId-5110147776","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":"cfeac656-0c46-4085-9a50-57c7c5057fa1","collection":"contentId-5110147776","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":"https://datavard.atlassian.net/wiki/spaces/DATAVARD/pages/5110139613"}}]},{"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":"https://datavard.atlassian.net/wiki/pages/createpage.action?spaceKey=DATAVARD&title=%28Glue-2502%29Extractor%202.0%20Objects&linkCreation=true&fromPageId=5110147776"}}]},{"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":"d73d085a-891f-44de-86b3-1cf4ffb2f8b5","collection":"contentId-5110147776","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":"c2afdf25-b841-4ba8-b1c6-dc6c111b5531","collection":"contentId-5110147776","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":"25d5c0d5-db68-4f3f-9eaf-91f75e611dba","collection":"contentId-5110147776","type":"file","height":432}}]},{"type":"paragraph"}],"version":1}

Browser not supported