(Glue-2308) BEx Query Data Replication

Owned by SNP
Aug 23, 2023

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 on how to set up and execute the extraction of data from BEx Query to Storage.

  1. Create BEx Query Fetcher (BICS).
  2. Create target Glue Table (with the use of the option Import fields from BEx Query (BICS)) defining the data structure on the target storage.
  3. Create SNP Glue™ Table Consumer using target Glue table.
  4. Create (Glue-2308) Extraction Process.
  5. (Glue-2308) Extraction Process.