(Glue-2102) BEx Query to Storage

Owned by SNP
Last updated: Feb 19, 2021 by Marian Vidra
1 min read

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 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.

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