ExportToDataLake macro

The ExportToDataLake macro is used to export data from SCV to the Data Lake. This macro command is executed at the system level.

For executing the macro, the value in the Command field for the macro definition must be specified in this format:

ExportToDataLake([Table Area], [Table Group Name], [Table Name], [Include User-Defined], [Include Deleted], [Export Mode]>, [User-Defined Only], [Schema Prefix])
Note: The optional parameters are specified in [ ].

This table lists the parameters used to execute the ExportDataLake macro:

Parameter Name Description
Table Area The table area from which the tables are exported to the Data Lake.
Table Group Name The table group from which the tables are exported to Data Lake.
Table Name The table to be exported to the Data Lake.
Include User-Defined Determines if the user defined tables must be included in the export process.
Note: If this value is not specified, the user defined tables are not considered.
Include Deleted Determines if the deleted records must be included in the export process.
Note: If this value is not specified, deleted records are not considered.
Export Mode Determines if the data for the entire table or the changes since the last export must be exported. Possible values:
  • Full
  • Incremental
Note: If this value is not specified, the Full Table is considered.
User-Defined Only Determines if the user-defined table or all tables must be included in the export process.
Note: If not specified, all tables are exported to Data Lake.
Schema prefix The prefix to include in the Data Lake table name when exporting the data.

This table lists examples of the ExportToDataLake macro:

Requirement Syntax
Export all non-deleted data from all standard Outbox tables to Data Lake.

ExportToDataLake("Outbox", "", "", "", "", "", "", "")

ExportToDataLake("Outbox", "", "", "", "", "Full", "", "")

ExportToDataLake("Outbox", "", "", "", "No", "", "", "")

ExportToDataLake("Outbox", "", "", "", "No", "Full", "", "")

ExportToDataLake("Outbox", "", "", "No", "No", "Full", "", "")

Export all data from "SO_DEMAND_PLAN_AGGR" table to Data Lake, including records that are previously exported but not available in the new data set by marking them as deleted ExportToDataLake("", "", "SO_DEMAND_PLAN_AGGR", "No", "Yes", "Full", "", "")
Export non-deleted data from "SO_DEMAND_PLAN" to the Data Lake that has been updated since last export. ExportToDataLake("", "", "SO_DEMAND_PLAN", "No", "No", "Incremental", "", "")
Export all data from all user-defined Outbox tables to Data Lake including prefix "UD" in table names. ExportToDataLake("Outbox", "", "", "Yes", "No", "Full", "Yes", "UD")
Export all data from "SO_DEMAND_PLAN", to the Data Lake that has been updated since last export. ExportToDataLake("", "", "SO_DEMAND_PLAN", "", "Yes", "Incremental", "", "")