Server data sources are data sources configured on the OpenAccess SDK Server. These data sources contain settings that affect how the OpenAccess SDK service operates and settings that affect how data is accessed by OpenAccess SDK Clients. Centralizing this information on the server, instead of distributing it among hundreds of OpenAccess SDK Clients, provides easier management of your entire data access infrastructure. When you install OpenAccess SDK Server, a default server data source, named Default, is automatically created on the server. If necessary, you can modify the definition of the default server data source. Server data sources apply to an OpenAccess SDK service. Each service can have multiple server data sources.
The data access functionality of a session is governed by a set of data source and service attributes for the data access service. These attributes are configured on the server.
If you do not specify a server data source for your connection, the attributes of the Default server data source govern the data access functionality of the connection. For example, if you configured two server data sources named DS1 and DS2 as shown in the following figure, and configured an OpenAccess SDK Client that did not specify a particular server data source, the data access functionality of the connection between the OpenAccess SDK Client and the OpenAccess SDK Server would be governed by the Default server data source.
Figure 2. OpenAccess SDK Clients Specifying Server Data Sources
Server data sources use configuration attributes to define functionality. For example, if you set DataSourceReadOnly=Select, the client application will only be able to perform Select statements when using that data source.
Note: Configuration attributes beginning with "DataSource", such as DataSourceReadOnly, are server data source attributes. Server data source attributes are always dynamic.
Note: OpenAccess SDK Agent services do not have server data source attributes.
Only commonly used service attributes are included in the default configuration of a service. To configure other attributes, you must add that attribute explicitly to your OpenAccess SDK configuration.
For instructions on configuring server data sources using the:
OpenAccess SDK Management Console, see Configuring Services Using the OpenAccess SDK Management Console.