Connection

BI xPress ›› Features ›› Auditing ›› Add-in ›› Options ››
Parent Previous Next

Connection


The Connection Information tab allows users the ability to configure the BI xPress database, connection manager, and configuration file / parameter options. The Connection Information tab is divided up into three sections, which behavior changes based on deployment location set on the Select Packages page.


Auditing Database Connection Information

The Auditing Database Connection Information section allows users the ability to configure the server information used by the Auditing Framework to connect to the BI xPress Database.



1.   Server: Provides the Auditing Framework with the name of the Server the BI xPress database is located on

2.   Windows Authentication: Controls whether the Auditing Framework will use Windows or SQL Server Authentication

1.   User ID: If the user does not select Windows Authentication, the User ID textbox will detail which SQL Server username to use to connect to the BI xPress database.

2.   Password: If the user does not select Windows Authentication, the Password textbox will detail the password to be used by the username in order to connect to the BI xPress database.

3.   Database: The Database textbox provides the Auditing Framework with the name of the database that contains the BI xPress Framework Architecture.

1.   If the Database selected does not contain the BI xPress Framework Architecture, users will be prompted to generate the Auditing Framework Architecture within the selected database


4.   Offline: The Offline checkbox will create the Auditing Framework Connect Manager and set it to "Work Offline", this allows users to browse and continue developing their package when the BI xPress database is not yet accessible

5.   Continue package execution on Auditing Framework database connection failure: This check box changes the behavior of the Auditing Framework by allowing SSIS packages that contain the Auditing Framework to continue executing in the rare occurrence that the Auditing Framework itself fails

6.   Do not report failure if Auditing Framework fails: This check box changes the behavior of the BI xPress Auditing Framework to hide all errors that occur due to the Auditing Framework itself

7.   Create New Database: This button provides the Auditing Framework the ability to create a new database if there is not already a database that contains the BI xPress Framework Architecture.

Package / Project Connection

The Package / Project Connection 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 File System, 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



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

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


Important Note:

Using an existing connection manager will automatically disable the Auditing Database Connection Information section. It is important to note that when this is set, 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 Project as the selected location on the Select Packages page and the selected packages are SSIS 2012 or above, then the Auditing Framework will us project connection managers.



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

2.   Use existing project connection: Allows the users to select an existing project connection manager. Additionally, since the connection information for the BI xPress database is stored within the existing connection manager, the Auditing Database Connection Information section will be disabled.


Important Note:

Using an existing connection manager will automatically disable the Auditing Database Connection Information section.


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


Configuration Options

The Configuration Options section allows users to specify whether or not they wish to add a configuration file or parameters to their packages in order to control the behavior of the Auditing Framework. The configuration options as well as the scope of the parameters (whether package or project level) change depending on the deployment model selected on the Select Packages page.



1.   Configuration Storage: Enables the usage of configurations as well as the scope of the configurations. If configurations are enabled, the user may select the scope of the configuration settings.

1.   Package Deployment Model

1.   Use Configuration File: When using a configuration file, the Auditing Framework will create a configuration file to store all of the configuration entries

1.   Overwrite if exists: Controls whether or not the configuration file will be overwritten if it already exists.

2.   Config Folder: Controls the location the configuration file will be saved in.


2.   Use Package Parameters: If the selected packages are SSIS 2012 or above, users will be able to select the option to use package parameters. When using package parameters, the Auditing Framework will create package parameters within each package to store all of the configuration entries

2.   Project Deployment Model:

1.   Use Package Parameters: If the user selected SSIS Project as the selected location on the Select Packages page and the selected packages are SSIS 2012 or above, the only option for configurations will project parameters. When using project parameters, the Auditing Framework will create project parameters to store all of the configuration entries

2.   Enable / Disable entire Auditing Framework: This configuration will allow users to manually turn off the Auditing Framework

3.   Enable / Disable variable, parameter, and connection logging: This configuration will allow users to manually turn off the logging of variable, parameter, and connection managers

4.   Enable / Disable real-time Data Flow monitoring: This configuration will allow users to manually turn off the Auditing Framework's real-time Data Flow monitoring.

5.   Enable / Disable logging for all warnings: This configuration will minimize the amount of logging that occurs by not logging warnings that occur during execution

6.   Variable and connection filtering: This configuration allows users to manually mask sensitive values contained within variables from being displayed when executions are viewed within the Monitoring Console.


Once done configuring the Connection tab with the desired settings, either click on the Logging Options, Advanced User Defined Logging, or Alert Filtering tab to continue configuring the Auditing Framework, or click the Next button to head to the Summary page to begin the process of adding / re-applying the Auditing Framework.