The extraction from SAP object to File storage has a lot in common with standard SAP table to Storage extraction. The same steps are required in order to execute the extraction. However, there are some differences in the way how the data and metadata are stored on file storage. On this page, we are going to focus on these differences. In order to set up the extraction, you can follow the steps as described in the chapter SAP table to Storage.
Glue tables on file storage
As in the case of the standard SAP table to Storage scenario, the creation of the Glue table is required before the extraction objects can be created. However, because the storage is file-based, there is no possibility to create a database table-like object in order to store data. Therefore, only metadata in JSON format are stored on the target storage during the Glue table activation, describing the Glue table. More information about the creation of a Glue table on file storage can be found in the chapter Create a Glue table on File storage. You can also find more information about Glue table metadata in the section JSON metadata structure.
...
During the extraction process itself, two types of files are created, These are data files and metadata files for extraction (Glue request). The creation of the files is dependent on the settings defined within File storage options. In the next section, we are going to discuss the particular files and how they can be configured,
...
In the default configuration, the data file is created as a CSV file for each transferred package. Each data file has an iteration (package) number appended to its name and is stored in the destination defined by File storage options within the Glue table. The data file naming can be configured using Glue Settings - Binary Storage settings using parameter Binary data file name.
...
With the default configuration, one metadata file is created for each Glue request transferred to storage. Using the default configuration, the metadata JSON files are stored within the same location as defined in File storage options.
...
The name of the metadata files is defined and can be configured via Glue Settings - Binary storage settings using parameter Binary request metadata file name.
...