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 a tabular data format, i.e. the characteristics must be only in rows, and the column axis can contain only one structure.

SNP 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). More information can be found in 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 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 SNP Glue™ Table Consumer using target Glue table
Create Extraction Process
Extraction Process

Browser not supported