Configuration

This section explains each of the properties in the configuration blade.

Fig 1: Erbessd Connector configuration blade.

General

Property	Description
Name	The name that will be visible when selecting a data source.

Settings

Property	Description
Use Connection Variables	Tick to use variables for the Base URL, Username, and Password settings, or enter them manually.
Base URL	The base URL provided by Erbessd (ends in .svc).
Username	The username/email used to authenticate to Erbessd.
Password	The password used to authenticate to Erbessd.

Access Control

Access Control ensures that App users view data they are authorized to see.

The App user is the input parameter to a stored procedure, which returns the values in the access column that the user is authorized to view. In this case, the Erbessd Area names.

The data source is filtered by these values to generate the Connector output, i.e. what the user sees. The access column name provided in the stored procedure output must match that of the data source.

In the example below, the user can view sites A and B - other sites are excluded from the Connector output. The access column in this instance is "Site".

Fig 2: Access Control example.

Please contact XMPro for assistance in setting up Access Control on this Connector.

Please note that the Access Control properties can only be configured with System Variables.

Property	Description
Apply Access Control	Tick to restrict the Connector output based on the App user.
Access Control SQL Server	The address, either URL or the IP address, where the Access Control SQL database is hosted.
Access Control SQL User Name	The username used to authenticate to SQL.
Access Control SQL Password	The Password used to authenticate to SQL.
Access Control Database	The database from which Access Control data is retrieved.
Access Control SQL Stored Procedure	A stored procedure that takes the user as an input and outputs the authorized values.
Stored Procedure Input Mapping	The input mapping grid for passing the stored procedure's input parameter. Possible options are: UserName UserId
Access Column	The column name, present in both the stored procedure and data source, is used to filter what the user sees.