Root element that contains all the provider listings. Contains the name and the class name of the data provider XQE should instantiate. The name of the data provider instance. This must be unique within the list of instances. The fully qualified class name of the data provider. This must be an implementation of either OLAPDataProvider or RelationalDataProvider. "true" or "false". Contextual connection pooling allows a connection to be used for more than one database query, in a given context. If not specified, contextual connection pooling is enabled. connectionContextualPoolingDisabled and connectionPoolingDisabled are independent. "true" or "false". If not specified, connection pooling is enabled. connectionContextualPoolingDisabled and connectionPoolingDisabled are independent. Number of milliseconds since creation that a connection may exist before is removed from the pool. If not applicable, omit this parameter or use "-1". Number of milliseconds before an idle connection is removed from the pool. If not applicable, omit this parameter or use "-1". Number of milliseconds before an idle connection is removed from the pool if it has not been used to satisfy at least one request. If not applicable, omit this parameter or use a value less than 1. Currently only supported by TM1. Period at which the connections are checked for expiration, in milliseconds. This parameter is ignored if connectionExpirationThreshold is not specified. If not applicable, omit this parameter or use "-1" Maximum number of connections in the pool for this provider. If not applicable, omit this parameter or use "-1". If not specified, the number of connections is not limited. Maximum number of concurent uses of a given connection. "1", if concurrency is not supported. If not applicable, omit this parameter or use "-1". If not specified, connections are not reused from concurrent threads. Initializes COM in multi-threaded mode. "true" to enable, "false" to disable. If not specified, the default is "false". Enables provider result set caching. If not applicable, omit this parameter. If not specified, the default is "false". Defines a hard limit on the number of result set objects that may be stored for a provider. A value greater than 0 will enable this constraint. If not specifcied, the default value is some reasonably large number. Defines a soft limit on the amount of retained memory (in bytes) used by all cached results sets for a provider. A value greater than 0 will enable this constraint. If not applicable, omit this parameter or use "-1". The maximum amount of time (in milliseconds) that a cached result set may live from the time it was created. A value greater than 0 will enable this constraint. If not specified, the default is 30 minutes. The maximum amount of time (in milliseconds) that a cached result set may remain idle before expiring. A value greater than 0 will enable this constraint. If not specified, the default is 5 minutes. The period of time (in milliseconds) at which the cached result sets are checked for expiration. This parameter is ignored if resultSetCacheMaxIdleTime is not specified. If not specified, the default is 5 seconds. The number of rows to be pre-loaded for the result set cache. Positive number specifies number of rows to be loaded. Zero means do not re-load any rows. And negative number means pre-load entire result set. The maximum amount of time (in milliseconds) that a connection can attempt to establish a connection before timeout issues are logged. This parameter is ignored if connectionAttemptTimeout is not specified. If not specified, no timeout will occur. The period of time (in milliseconds) where connections that are currently attempting to establish a connection are checked to see if they have timed out. This parameter is ignored if connectionAttemptTimeout is not specified. If not specified, polling will occur. Default is 1 minute (60000 milliseconds) The maximum amount of time (in milliseconds) the connection pool will wait for a thread to select a pooled connection. If it timed out, the thread will mark the this connection as unusable and continue to select another connection from the pool. The default value is 0 which means there's no timeout. The period of time (in milliseconds) at which the cached result set will check for Cube update timestamp and validate the cached data. A regex string indicating the driver versions that are black listed - not supported. A regex string indicating the server versions that are black listed - not supported. A regex string indicating the driver versions that are grey listed - marked for deprecation. A regex string indicating the server versions that are grey listed - marked for deprecation. Contains all the information for a particular provider. This defines all connection string properties understood by the provider. Defines a single connection string property. Defines union of one or more conditions that determine if the property is required. A condition that requires the specified target property to be defined and non-empty. A condition that requires the specified target property to be undefined or empty. A condition that requires the specified target property to be equal to the some value. Defines an intersection of one or more constraints on the value of the property. Defines a Java regular expression string that must match the property value string. Defines a set of legal values to choose from. The name of the connection property as it appears in a connection string. This is case sensitive. The expected data-type of the parameter. This is used to validate user-input in a UI field editor. The default is "string". Defines if the property is optional, requied or conditional. The subType of the data source. For example, a JDBC provider would need to know the actual data source it is connecting to. e.g. "MS" for MSSQL server This is the driver class the provider must use. For example, a MSSQL provider would need its JDBC driver class. The name of the provider. This is used to set the dataProviderType for MDDS. For example, "MSAnalsyisODP". This is the connection type. It is a two character indentification that is part of a data source's connection string. For example, "MO". This is a reference to a particular instance of a data provider. This implies queries to this provider type would be satisfied by the matching instance. The instance name must match one of the instance names already declared in the providerInstances section.