Data Strategies
Updated 2 months ago
by
Stephanie Krenz
Add Data Strategies
To add a Data Strategy, click on Settings at the top, then on Data Strategies in the Data section on the left and then click on + Data Strategy at the top right.
Enter the following information:
- Name of the Data Strategy
- Input Data -> Determines what should happen to the data extracted from your SAP system
Input Data (left) | Input Data (right) | Description |
New Database | dab Nexus creates a new Database after every Run | |
Keep Database | Overwrite | dab Nexus creates a new database during the first run of a task, then the extracted data is overwritten with each subsequent run |
Keep Database | Delta Merge | dab Nexus creates a new database during the first run of a task, then the extracted data is appended to the existing data during each subsequent run |
Existing Database | Overwrite | dab Nexus writes the extracted data to an existing database, the data is overwritten with each subsequent run |
Existing Database | Delta Merge | dab Nexus writes the extracted data to an already existing database, with each subsequent run its data is appended to the already existing data |
Existing Database | New Schema | dab Nexus writes the extracted data to an existing database, a new database schema is created for each subsequent run |
- Automatic deletion after ... Days -> Here you can set how many days after the run has been executed the extracted data should be deleted
- Database Scheme -> Name your Data Strategy
- Processed Data -> Defines what should happen with the data after the analysis
Processed Data | Description |
Overwrite | The result data of the previous run is overwritten with each run |
New Result Set | The result data is written to a new database schema for each run |
- Automatic deletion after ... Days -> Here you can set how many days after the execution of the run the result data should be deleted
- Database Scheme -> Name your data strategy
- Automatically delete Database after ... Days -> only available if New Database was specified for Input Data
- Create or Create & Close -> With Create & Close you can save the settings you have made and the view is then automatically closed, you return to the list of created Data Strategies
A success message is displayed. Under the newly created data strategy, you can see the exact settings for the input data (data extracted from SAP) and processed data (result data after the analysis).
Interaction between Data Strategy and Table Strategy
You should pay particular attention to the Data Strategy regarding the Table Strategy in the Package Studio. The following table will help you gain an overview of how these interact with each other.
Here you will find the introduction to the Package Studio.
The possible results are:
- Discard -> The table is not written to the database
- Layout -> An empty table without rows is written to the database
- Overwrite -> The table is overwritten with each run
- Merge -> The table is merged with new data based on the primary key
- Append -> New data will be added to the table
- Once -> The table is written once and is neither overwritten nor merged in subsequent runs
Table Strategy Merge | Table Strategy Overwrite | Table Strategy Append | Table Strategy Layout | Virtual Table | |
Data Strategy New Database | Once | Once | Once | Layout | Discard |
Data Strategy Keep Database - Overwrite | Overwrite | Overwrite | Overwrite | Layout | Discard |
Data Strategy Keep Database - Delta Merge | Merge | Overwrite | Append | Layout | Discard |
Data Strategy Existing Database - Overwrite | Overwrite | Overwrite | Overwrite | Layout | Discard |
Data Strategy Existing Database - Delta Merge | Merge | Overwrite | Append | Layout | Discard |
Data Strategy Existing Database - New Schema | Once | Once | Once | Layout | Discard |
Change Data Strategies
The functions described below are available from dab Nexus version 1.14.
If you want to change an existing Data Strategy, you have the following options:
- Name of the Data Strategy
- Automatic deletion after ... Days -> this setting can always be changed for Input Data and Processed Data
- Automatically delete database after ... Days -> this setting can only be changed if New Database was specified for Input Data
