SA Data Extraction for Data Lake and Birst overview

System Administrator > Administration > SAA Reports > SAABE

Function acronym: SAABE

Use this report to create an extract of Distribution SX.e tables for use by Infor Distribution Analytics Content for Birst. The report creates two types of output: a comma-separated or pipe-separated text file for each table selected for extraction that can be uploaded in Birst, or data files to be placed in the Data Lake queue (DLQUEUE) to be loaded into the Infor Data Lake repository.

Use SA Audit Processing Administration to monitor and purge the records in the DLQUEUE table.

When you run the SA Data Extraction for Data Lake and Birst, you can optionally specify a date range, and then select the table or tables to be extracted.

When you select Text File as the Extract Type, the report extracts data as text files based on the standard temp-tables built for the REST API FetchWhere service. Not all tables are used to populate the domains supported in the current version of Distribution Analytics Content for Birst. Specify a value in the File Delimiter: (C)omma or (P)ipe option to determine the field delimiter used in the text file. The file delimiter option is intended for a future feature and is not fully supported in Birst at this time.

See the list of supported data load sources for Birst in Supported database extract tables for Birst.

When you select Data Lake as the Extract Type, the report extracts data for the selected tables and loads them into the Data Lake queue (DLQUEUE). The Data Connector web service sends the data through ION Messaging Service to the Infor Data Lake. The Data Lake Extract Type is currently available if you are running CloudSuite Distribution only.

See the list of supported data load sources for the Data Lake in Supported tables for Data Lake

Note: SA Data Extraction for Data Lake and Birst is used to send an initial data load only to the Data Lake. To update Data Lake data objects when database records are added, changed, or deleted after the initial load, you must activate database table replication in SA Administrator Options-System-Options.

See the Infor CloudSuite Distribution Configuration Guide for instructions for configuring the Data Lake integration.

You can print the extract file output to view, email, or Dropbox. If you are running Distribution SX.e on-premises, you can also print the output to a local file.

Specify a value in the Days to Extract option to extract data from the current day back the specified number of days. This is useful for setting up the SA Data Extraction for Data Lake and Birst as a stored report to do incremental data loads to Birst.