Configuration

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

Fig 1: Data Streams Connector configuration blade.

General

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

Cache

This connector must maintain a cache of records received from the Data Stream Designer. If the App Designer server is shut down, this cache of records may be deleted.

Property	Description
Cache Size	The maximum number of records cached on the server. If the Connector receives more records than this, the oldest records are deleted from the cache to make room. If the Cache by Entity setting is enabled in the Data Stream Agent, this maximum number is applied per entity.
Sliding Expiry (Days)	The number of days that cached records are stored before deletion. This period is refreshed if the record is accessed, i.e. read by the application or data received from the Data Stream.

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 Data Stream values in the access column that the user is authorized to view.

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.