Preconditions

1. Create Greenrain Automation database schema

Create the required database tables by running the script.

2. Create Customer database schema

Create the required database tables by running the script.

3. Create record in PersonRegister table (Customer database)

Create record in the following format: DohMembersUpdate Table.

Configuration

The following settings are required to be made for DoH Members Update via 'Table in Customer Database':

1. Go to Greenrain Automation Settings

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

Figure1.

2. Configure DoH Members Update 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. 'DatabaseTable' value should be selected from drop-down list.
   2. 1. 'Connection string to the database'. Click "Configure Database Connection..." button and set Database = Name of the Customer database (see Preconditions p.2). Click "OK" button (if you wish to test the connection string click the "Test Connection String" button.).
      2. 'Table name'. Specify the table from which you want to retrieve data (PersonRegister from Customer database, see Preconditions p.2).
5. Click "Save" button.

3. Check common configuration

DoH Members Update

refer to Excel File