Preconditions

1. Create SELECT SQL script

Create SELECT SQL script to get data for DoH Members Update.

2. Create SQL to report successful DoH Members Upload

Create, for examle, sql script for successful upload.

3. Create SQL to report DoH Members Upload failure

Create, for examle, sql script for upload failure.

Configuration

The following settings are required to be made for DoH Members Upload via 'SelectSql':

1. Go to Greenrain Automation Settings

Log in to Greenrain Automation. Select "Settings" from the Toolbar → 'Greenrain Automation Settings' form opens.

Image Added

Figure1.

2. Configure DoH Members Upload tab

Figure2.

Select "DoH Members Update" tab and configure settings:

1. 'Upload member details with data from DoH Personal Profile Service': should be checked.
2. 'Flag 'Is Resident' is mandatory': set the flag to specify for UAE/non UAE resident the date will be received from DoH Personal Profile service.
3. 'Person Profile data expiry interval": set '30' for example.
4. 'Choose where Greenrain Automation will get data from':
   1. 'SelectSql' value should be selected from drop-down list.
   2. 'Connection string to the database'. Click "Configure Database Connection..." button and set Database = Name of the Customer database (see Preconditionsp.2). Click "OK" button (if you wish to test the connection string click the "Test Connection String" button.).
   3. 'SELECT SQL' (mandatory setting). Specify a script to get data provided by user to generate PersonRegister transaction (refer to Preconditions p.1).
   4. 'SQL to report successful Person.Register upload' (optional setting). Specify a script for successful upload (refer to Preconditions p.2).
      1. 'SQL to report Person.Register upload failure' (optional setting). Specify a script for upload failure (refer to Preconditions p.3).
   5. Click "Save" button.

3. Check common configuration

DoH Members Update

refer to Excel File