<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=931099456970389&amp;ev=PageView&amp;noscript=1">

Pragmatic WorkbenchWith BI xPress Server edition, you get the monitoring and management features of BI xPress in a web-based server solution. It allows you to easily monitor SSRS reports and SSIS packages, dive into performance trends and notify users when packages succeed or fail. It also allows you to see how reports are being handled.

Let’s look at the features you’ll have available within BI xPress Server:

Auditing Framework – This will feel familiar if you’re already using the BI xPress tool and adding on your auditing framework. Here are the tabs you’ll see and what they do:

  • Upload – Here you can simply go in and select which packages or projects you want to attach the auditing framework to.
  • Action – Lets you choose whether you’re going to be adding or removing an auditing framework.
  • Database – In this tab, you’ll decide where you’ll be storing the results of your executions, such as warnings, errors, and other variables.
  • Connection – How are you connecting your packages to the repository?
  • Configure – This option allows you to configure where you want to deploy the configuration files, as well as some additional auditing options.
  • Progress – You can attach this and see how the implementation is going.
  • You can also go in and download any executions as well.

Notification Framework – The notification engine allow you to go through notifications and edit the format of those notifications that arrive in your inbox. You can also go in and test them before packages execute, as well as choose how you want people to be notified of completions, successes, errors and warnings (via email, text, REST calls, etc.).

SSIS Dashboards – Here’s where you can see load trends, load details and performance over time. This gives you an eagle eye view of your entire environment to see where packages are executing the best or where they are loading the most data, for instance, and going back as far as when you attached an auditing framework to that package or project.

SSIS and SSRS Monitoring Console – The SSIS Monitoring Console is where you can go through and create filters (by name or create groups) to filter through and see only the packages you want to see. You can color code your executions to quickly see if it’s actively executing, if it was a success or fail, or if a user stopped it prematurely.

You can also see connections, variable, errors and warnings, and even zoom in to see how many rows have been loaded or extracted; and you can switch between data and control flow.

The SSRS Monitoring Console will give you information about averages with your reports, such as which ones are being executed most often, what is the performance on these, even who is your most active user.

BI xPress Server lets you easily share information about your BI system with other departments and business users, without requiring a local desktop application. I hope this look into the BI xPress Server edition has been helpful and enticed you to visit our website to learn more or to download your free trial today.

Try Workbench

Join Our Blog

Join thousands of other SQL Server, BI and cloud pros by subscribing to our blog.

Leave a comment

Posts by Topic

see all

Recent Articles

Popular Articles

Related posts