Documenting the integration flows is an activity very expensive in terms of time. If we think to the configuration of the receive ports, send ports and how they are linked to the orchestrations we become crazy.
In a context where they develop many BizTalk objects you end up having documents constantly obsolete.
For this reason, I decided to develop a small package of reports that allow having this part of the documentation always up to date. Simply run reports and export them in the required format such as Microsoft Word, PDF or Microsoft Excel.
You can download the installation package at https://github.com/pellitteris/BizTalkConfigReports.
The solution includes a package of reports developed with Microsoft SQL Server Reporting Services and a database to be installed on the same SQL Server instance where the database BizTalkMgmtDb resides. This database contains the views and stored procedures performed by the reports.
Once the installation is completed you have three reports:
- Orchestration Summary
- Receive Port with Port Subscription
The report “Summary Orchestration” displays at a high level the relationship between the orchestrations, the receive ports and the send ports.
Each report allows you to select the application, and optionally a search string to filter the objects you want to examine or document.
Following an example of this report.
The report “Orchestrations” adds more details to the previous report.
Finally the report “Receive Port having Send Send Port or Port Group Subscriptions” that displays all subscriptions to a specific port configured on the send port or on the send port group.
Now you have the source code of this solution and you can add features or simply customize reports to fit your needs.