Connection Manager

BI xPress ›› Features ›› Auditing ›› Workbench ››
Parent Previous Next

Connection Manager


The Connection Manager section allows users the ability to configure whether to create a new, or use an existing, connection manager. The scope of the connection manager (whether package or project level) changes depending on the deployment model selected on the Select Packages page.


1.   Package Deployment Model: If the user selected SSIS 2005, 2008, or 2008 R2 Packages, or they selected My Computer, SQL Server, SSIS Package Store, or Visual Studio Solution as the selected location on the Select Packages page, then the Auditing Framework will us package connection managers


o   Create new connection: Allows users to create a new connection manager within each package with the specified connection manager name


o   Use existing connection: Allows the users to select an existing connection manager from the first package selected.


Important Note:

Users should ensure that the selected connection manager exists in all other packages, otherwise the Auditing Framework will not be applied.


Additionally, if using an existing connection manager, the selected connection manager should point to a database that contains the BI xPress Framework Architecture.


2.   Project Deployment Model: If the user selected SSIS 2012 and above SSIS Packages and they selected SSIS Project as the selected location on the Select Packages page, then the Auditing Framework will us project connection managers.


o   Create new project connection: Allows users to create a new connection manager at the project level with the specified connection manager name


o   Use existing project connection: Allows the users to select an existing project connection manager.


Once done configuring the connection manager, users can continue to any of the following sections:

  Database Connection

  Package Grouping

  Configuration Options

  Logging Option


Users may also immediately begin applying or removing the auditing framework.