All required Tables and Entities must be generated first. This in turn will create the corresponding Data sets and Extracts, but at this stage no data is loaded in the SQL Database.
It is important to Generate System Entities first before generating other Entities, this is to create the required security, “%SYSecurity” and “%SYSecurityList”, for generating the rest of the Entities.
These steps must be followed:
In Entity Maintenance, select all the Entities that start with SY.
In the action menu, choose Generate Extracts and click Apply Action (
).A report will be generated for this process. This report should be reviewed to ensure there are no errors.
This process will create records in the Extracts Maintenance area where all extracts are prefixed with X_.
Data sets are also automatically created in Data Set Definitions at this point.
Generating Entities will create corresponding Datasets and Extracts.
Once generating SY* tables are completed, repeat the steps above for generating the rest of the required tables.