BEx Query to Storage scenario can be used if you want to replicate the data from BEx Query to data storage.
The only requirement is the navigational state of BEx Query must have tabular data format, i.e. the characteristics must be only in rows, and the column axis can contain only one structure.
Datavard Glue extraction process executes BEx Query with the specified variable selection, performs a transformation of the data, and stores it in the target storage. This can be RDBMS storage (Oracle, MSSQL, etc.), file system (HDFS, Azure Blob, Azure Data Lake Storage, AWS S3, etc.), Hadoop (Hive, Impala), or cloud solution (AWS Redshift, Azure Databricks, Google BigQuery). For more information, please see the Storage Management documentation.
Below, you can find a step-by-step manual of how to set up and execute the extraction of data from BEx Query to Storage.
- Create (Glue-2111) BEx Query Fetcher (BICS)
- Create target Glue Table (with the use of option "Import fields" from "BEx Query (BICS)") defining the data structure on the target storage
- Create (Glue-2111) Glue Table Consumer using target Glue table
- Create (Glue-2111) Extraction Process
- Execute extraction