Feature Settings

Parent Previous Next


Feature Settings


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



Auditing Properties

  Database

o   Server Instance: The name of the server the BI xPress database is located on

o   Database Name: The name of the database containing the BI xPress architecture

o   Is Windows Authentication: Controls whether the auditing framework uses Windows or SQL Server Authentication

o   Is 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

o   Is Continue Execution On Audit Db 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

o   Is Do Not Report Auditing Failure: Changes the behavior of the Auditing Framework to hide all errors that occur due to the Auditing Framework itself


  Connection

o   Is Remove Project Level Items: When removing the auditing framework, this property controls whether project level items will be removed or retained

o   Connection Manager Name: The name used for the auditing framework connection manager


  Configure

o   Project & Package Configuration

  Is Use Configuration: Specifies whether or not auditing framework will include configurations

  Is File Configuration Selected: Specifies whether to use configuration files or parameters

  Configuration Folder Path: If using configuration files, dictates the default directory where SSIS configuration files will be located


  Is Add Variable Enable Disable Auditing Framework: Includes a variable or parameter within the package that manually controls whether the auditing framework is enabled

  Is Add Variable Enable Disable Var Param Conn Logging: Includes a variable or parameter within the package that manually controls whether the auditing framework will log variable, parameters and connection managers

   Is Add Variable Enable Disable Data Flow Monitoring: Includes a variable or parameter within the package that manually controls whether the auditing framework monitors data flows within the package

  Is Add Variable Enable Disable Logging All Warnings: Includes a variable or parameter within the package that manually controls whether the auditing framework logs warnings

  Is Add Variable Variable Connection Filter: 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


o   Auditing Options

  Is C# Sharp Script Language: Controls whether the scripts the auditing framework includes will be either C# or VB

  Max Iterations To Log: 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

  Is Include Data Flow Monitoring: Controls whether or not the Auditing Framework will monitor data flows in real-time

  Is Log Row Count: Controls whether or not the Auditing Framework will capture row counts flowing inside data flows

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

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

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

  Is Log Connection Details For Source Destination: If Log Row Counts is enabled, Connection Detail Logging will log details for each source and destination component regarding the connections used


  Is Log Warnings: Controls whether or not a user wishes to have warnings that are encountered during execution to be logged within the BI xPress database

  Is Log Connections: Allows users to log every connection manager's connection string during run-time

  Is Log All Variables: Allows users to log the values of variables when package execution is started and when the package execution completes

  Is Enable Variable Change Tracking: Enabling variable change tracking allows users to maintain a historical record of all value changes to variables during execution

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

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

  Is Log Initial Value Of Params: If enable variable change is enabled, Initial Parameter Value Logging will also log the initial values of all non-sensitive parameters within SSIS packages 2012 and up


o   Custom Logging

  Is Custom Variable Logging Enabled: Allows the auditing framework the ability to explicitly log variables

  Numeric Variable One through Three: If custom logging is enabled, the three date variable properties allow users to log up to three custom date data types

  String Variable One through Three: If custom logging is enabled, the three date variable properties allow users to log up to three custom date data types

  Date Variable One through Three: If custom logging is enabled, the three date variable properties allow users to log up to three custom date data types


  Events to Log

  Is Custom Logging On Pre Execute: If custom logging is enabled, all custom variables will be logged at the start of the selected logging scope

  Is Custom Logging On Post Execute: If custom logging is enabled, all custom variables will be logged at the end of the selected logging scope

  Is Custom Logging On Error: If custom logging is enabled, all custom variables will be logged when an error occurs

  Is Custom Logging On Warning: If custom logging is enabled, all custom variables will be logged when an warning occurs


  Logging Scope

   Is 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 in the "Events to Log" section

  Is 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 in the "Events to Log" section


SSIS Monitoring Console

  SSIS Monitoring Console - BI xPress Database Server: The name of the server the BI xPress database is located on

  SSIS Monitoring Console - BI xPress Database 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.

  SSIS Monitoring Console - BI xPress Database 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.

  SSIS Monitoring Console - BI xPress Database Name: The name of the database containing the BI xPress architecture

  SSIS Monitoring Console - Polling Interval in Seconds: Details how often the monitoring console will reload package executions

  SSIS Monitoring Console - Number of seconds before an operation times out: The timeout length for the Monitoring Console

  SSIS Monitoring Console - Max 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.

  SSIS Monitoring Console - Package Execution Count: Details how many executions will be returned




SSRS Monitoring

  SSRS Monitoring Console - SSRS Database Server: The name of the server the ReportServer database is located on

  SSRS Monitoring Console - SSRS Database 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.

  SSRS Monitoring Console - SSRS Database 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.

  SSRS Monitoring Console - SSRS Database Name: The name of the ReportServer database. SSRS database naming defaults:

o   Native Mode: ReportServer or ReportServer_{{NamedInstance}}

o   SharePoint Mode: ReportingService_{{GUID}}

  SSRS Monitoring Console - Refresh Interval: Details how often the monitoring console will reload the reports

  SSRS Monitoring Console - Maximum Seconds to Retrieve Data: The timeout length for the Monitoring Console

   SSRS Monitoring Console - Longest Running Reports Count: Details how many reports to return for the Longest Running Reports dashboard

  SSRS Monitoring Console - Most Active Users Count: Details how many users to return for the Most Active Users dashboard

  SSRS Monitoring Console - Most Frequent Reports Count: Details how many reports to return for the Most Frequet Reports dashboard