Databases Reference
In-Depth Information
TABLE 17.1
DataSource
Properties
Name
Description
The connection string to be passed to the client library. The
value of the
Provider
property of the connection string speci-
fies the name of the provider. The specification of the OLE DB or
managed provider defines the remaining connection string prop-
erties.
ConnectionString
The name of the .NET managed provider used to establish the
connection. Analysis Services 2008 supports only SQL Server
(
System.Data.SqlClient
) and Oracle (
System.Data.Oracle
Client
) providers.
ManagedProvider
The time after which the attempt to establish a connection will
be aborted. If the timeout defined in the server configuration
property
DatabaseConnectionPoolConnectTimeout
is smaller
than the timeout defined in the
DataSource
object, the timeout
defined in the server configuration will be used. If the value of
the
Timeout
property is
0
(default value), or not defined,
Analysis Services uses the value of the
DatabaseConnection
PoolConnectTimeout
property.
Timeout
The maximum number of active connections that can be estab-
lished to a current data source. The default value is
10
. If
Analysis Services needs to create more connections, additional
requests will wait for existing connections to complete their
work. This property is provided to prevent Analysis Services from
generating huge simultaneous load on a relational database,
which can cause performance degradation during data load. Use
a negative value to specify that there is no limit to the number
of connections.
MaxActiveConnections
The locking mode used when establishing a connection to the
relational database. The default value for this property is
ReadCommitted
. If you specify
Snapshot
, you can achieve higher
transaction concurrency in a relational database, but you pay a
price in performance. To decide on the best value for the
Isolation
property, it is best to check the documentation for
the relational database.
Isolation
Search WWH ::
Custom Search