Home

BizTalk Configuration Reporting allows you to view and document the current configuration of BizTalk Server in terms of receive ports, send ports and orchestrations.

This tool consists of a database to be placed in the same database instance of BizTalkMgmtDb and a some reports to be installed in an instance of Microsoft SQL Server Reporting Services (SSRS).

The reports, being based on SSRS, display data in real time and allow export in different formats such as Microsoft Word, PDF, Microsoft Excel, TIFF, etc.

This allow to have documentation always up to date.

Setup

The setup procedure is very simple and consists of two steps:

1. Setup database
2. Setup Reports

To install the database, run the command SetupDb.cmd.

The procedure will ask you the server name and the instance name of SQL Server and then the credentials with which to access to the database. It is possible to specify a SQL Server user or use the Windows integrated security. Specify a user who has at least the rights of database creator.

It is important to specify the same SQL Server instance in which you have BizTalkMgmtDb database.

To install reports, run the command SetupReport.cmd.

You have to specify SQL Server Reporting Services web services URL and the path in which you have installed RS.EXE program.

You must have the rights of content managers to publish reports.

Once the setup is complete, you must configure the reports data source.

Run the report manager.

Navigate the "Data Sources" folder, select the data source "BizTalkReport" and edit the connection string.

Finally apply the configuration.