Feature Settings

Parent Previous Next


Feature Settings


The feature settings page allows the management of various properties for all of the BI xPress features.


Table of Contents

  Auditing Framework Settings

  Reporting Monitoring Console Settings

  SSIS Monitoring Console Settings



Setting Name

Description

Auditing Framework Settings

(Connection Manager)

Database Name

The name of the database containing the BI xPress architecture

(Connection Manager)

Name

The name used for the auditing framework connection manager

(Connection Manager)

Offline Mode

Automatically sets the newly created connection manager to "Work Offline". This allows users to browse and continue developing their packages when the BI xPress database is not yet accessible

(Connection Manager)

Server Instance

The name of the server the BI xPress database is located on

(Connection Manager)

Windows Authentication

Controls whether the auditing framework uses Windows or SQL Server Authentication

(Custom Logging)

Date Variable 1 - 3

If custom logging is enabled, allows users to log up to 3 custom date variables

(Custom Logging)

Enabled

Allows the auditing framework the ability to explicitly log variables

(Custom Logging)

Numeric Variable 1 - 3

If custom logging is enabled, allows users to log up to 3 custom numeric variables

(Custom Logging)

OnError

If custom logging is enabled, all custom variables will be logged when an error occurs

(Custom Logging)

OnPostExecute

If custom logging is enabled, all custom variables will be logged at the end of the selected logging scopes

(Custom Logging)

OnPreExecute

If custom logging is enabled, all custom variables will be logged at the start of the selected logging scopes

(Custom Logging)

OnWarning

If custom logging is enabled, all custom variables will be logged when a warning occurs

(Custom Logging)

Package Level

If custom logging is enabled, when package level is enabled the custom variables will be logged at the package level for the events specified

(Custom Logging)

String Variable 1 - 3

If custom logging is enabled, allows users to log up to 3 custom string variables

(Custom Logging)

Task Level

If custom logging is enabled, when task level is enabled the custom variables will be logged for every task for the events specified

Configuration Folder Path

If using a configuration file, dictates the default directory where SSIS configuration files will be located

Continue Execution on

Auditing Database Connection Failure

Changes the behavior of the Auditing Framework by allowing SSIS packages containing the Auditing Framework to continue executing in the rare occurrence that the Auditing Framework itself fails

Do Not Report Auditing Failure

Changes the behavior of the Auditing Framework to hide all errors that occur due to the Auditing Framework itself

Enable Data Flow Monitoring

Controls whether the Auditing Framework will monitor data flows in real-time

Enable Variable Change Tracking

Enabling variable change tracking allows users to maintain a historical record of all value changes to variables during execution

Include Variable for

Disabling Auditing Framework

Includes a variable or parameter within the package that manually controls whether the auditing framework is enabled

Include Variable for

Disabling Data Flow Monitoring

Includes a variable or parameter within the package that manually controls whether the auditing framework monitors data flows within the package

Include Variable for

Disabling Logging for All Warnings

Includes a variable or parameter within the package that manually controls whether the auditing framework logs warnings

Include Variable for

Disabling Variable, Parameter and Connection Logging

Includes a variable or parameter within the package that manually controls whether the auditing framework will log variable, parameters and connection managers

Include Variable for

Enabling Variable and Connection Filters

Includes a variable or parameter within the package that allows user to manually mask sensitive values contained within variables and connection managers when being viewed within the Monitoring Console

Log All Variables

Allows users to log the values of variables when package execution is started and when the package execution completes

Log Connection Details for

Source and Destination Components

If Log Row Counts is enabled, Connection Detail Logging will log details for each source and destination component regarding the connections used

Log Connections

Allows users to log every connection manager's connection string during run-time

Log Destination Row Counts

If Log Row Counts is enabled, Log Destination Row Count will track how many rows are going into destination components

Log Initial Parameter Values

If enable variable change is enabled, this will also log the initial values of all non-sensitive parameters within SSIS packages 2012 and up

Log Object Variables

If enable variable change is enabled, Object Variable Logging allows the logging of object variables

Log Row Counts

Controls whether the Auditing Framework will capture row counts flowing inside data flows

Log Source Row Counts

If Log Row Counts is enabled, Log Source Row Count will track how many rows are coming from source components

Log SQL Statements

If Log Row Counts is enabled, Log SQL Statement will log the SQL Statements used to extract data

Log Variables

If enable variable change is enabled, Log Variables allows the user to choose between tracking all variables, or only variables used within For Each Loops

Log Warnings

Controls whether a user wishes to have warnings that are encountered during execution to be logged within the BI xPress database

Maximum Iterations to Log for Loop Containers

Controls how many loops within a For or For Each Loop the auditing framework will keep track of. Setting this value to 0 means all iterations will be logged

Remove Project Items

When removing the auditing framework, this property controls whether project level items will be removed or retained

Use C# Script Language

Controls whether the scripts created are C# or Visual Basic

Use Configurations

Specifies whether auditing framework will include configurations

Use File Configuration

Specifies whether to use a configuration file or parameters

[Back To Top]


Setting Name

Description

Reporting Monitoring Console Settings

Active Users Count

Details how many users to return for the Most Active Users dashboard

Longest Running Reports Count

Details how many reports to return for the Longest Running Reports dashboard

Password

The password used for the SQL Authentication username to connect to the ReportServer database. Leave blank to connect using Windows Authentication using the BI xPress AppPool Identity

Refresh Interval

Details how often the monitoring console will reload the reports

Report Averages Count

Details how many reports to return for the Most Frequent Reports dashboard

Server Instance

The name of the server the ReportServer database is located on

SSRS Database Name

The name of the ReportServer database. SSRS database naming defaults:


Native Mode Syntax


ReportServer or ReportServer_{<NamedInstance>}



SharePoint Syntax


ReportingService_{<GUID>}



Timeout

The timeout length for the Reporting Monitoring Console

Username

The SQL Authentication username used to connect to the ReportServer database. Leave blank to connect using Windows Authentication using the BI xPress AppPool Identity

[Back To Top]


Setting Name

Description

SSIS Monitoring Console Settings

Database Name

The name of the database containing the BI xPress architecture

Maximum Variable Length

Used to set how much of the variable value to return before concatenation occurs. This property can increase performance by reducing the amount of data returned from the BI xPress repository.  Note that this does not affect the length of a variable value stored within the repository, only how much is retrieved from the repository

Package Execution Count

Details how many executions will be returned

Password

The password used for the SQL Authentication username to connect to the BI xPress database. Leave blank to connect using Windows Authentication using the BI xPress AppPool Identity

Polling Interval

(in seconds)

Details how often the monitoring console will reload package executions

Server Instance

The name of the server the BI xPress database is located on

Timeout

The timeout length for the Monitoring Console

Username

The SQL Authentication username used to connect to the BI xPress database. Leave blank to connect using Windows Authentication using the BI xPress AppPool Identity

[Back To Top]