A database connection is described in a <das:database-connection> element. All database connections are grouped in a <das:database-connections> element which is a child of <das:job> element.

 

Bellow are sampled an Acces connection, a SQL Server connection and a Oracle connection:

 

 

<das:database-connection id="conn1" connection-string="data source=C:\Program Files\Ecrion\Data Aggregation Server 2010\Database Samples\emp.mdb;provider=Microsoft.Jet.OLEDB.4.0;" data-driver-type="DotNet" provider-name="System.Data.OleDb" description="MSACCESS:C:\Program Files\Ecrion\Data Aggregation Server 2010\Database Samples\emp.mdb"/>

 

<das:database-connection id="conn2" connection-string="MultipleActiveResultSets=True;data source=ROECRSRV03;initial catalog=AdventureWorks;password=test;user id=test;" data-driver-type="DotNet" provider-name="System.Data.SqlClient" description="conn1"/>

 

<das:database-connection id="conn3" connection-string="data source=testconn.roecrsrv03.roecr.ecrion.com;password=test;persist security info=True;unicode=True;user id=test;" data-driver-type="DotNet" provider-name="System.Data.OracleClient" description="ORACLE:ROECRSRV03"/>

 

 

Attributes:

id - unique identifier of this resource in the current processing job.

connection-string - A string that specifies information about a data source and the means of connecting to it. This attribute is mandatory.

data-driver-type - A identifier for the driver used to collect data in this connection. For now the only valid value is DotNet. Mandatory.

provider-name - .NET Framework Data Provider for this connection. Mandatory.

description - A short description for this connection. Optional.