8. Setup an Action Sending a CSV File via Mail

Scenario Every day five specific tables are loaded. After all these tables have been successfully loaded a CSV file should be sent per mail, based on a view containing business logic based on these 5 tables.

Therefore, setup an action, in this case of the type ‘exp_mail’, which should be triggered every time the application status of the application containing all five tables as components changes to ‘FINISHED_TYPE = FINAL’. To do so follow the steps below:

1. Create an application

2. Add components to the application

3. Create a formatting rule for the CSV file

4. Create an action

5. Add the action to the application

8.1. Create an application

• Add an application

• Add database objects to an application

• Add an export format

• Add action export

Finally, define the action itself:

• Add mail action export

Check the table RED_APP_ACTIONS after having followed this guide.