SSIS Full Requirement for BizTalk Production Installation

Question

As part of the BizTalk installation—specifically for BAM (Business Activity Monitoring)—it appears that SQL Server Integration Services (SSIS) components are required. However, it is currently unclear whether: Full SSIS installation is mandatory, or Only specific shared components are required during configuration, and

Whether SSIS is required to remain installed for ongoing BizTalk/BAM operations after setup.

       The SQL Server licensing requirements associated with installing SSIS for BizTalk.

Answer 1

For the installation of BizTalk Server, particularly for Business Activity Monitoring (BAM), the following requirements regarding SQL Server Integration Services (SSIS) apply:

1. Full SSIS Installation: A full installation of SQL Server Integration Services (SSIS) is required on the BizTalk Server to support BAM. This is necessary for the proper functioning of BAM features, especially when SQL Server is remote to BizTalk.
2. Ongoing Operations: SSIS must remain installed for ongoing BizTalk/BAM operations after the initial setup. It is essential for the continuous operation of BAM functionalities.
3. SQL Server Licensing: The licensing requirements for SQL Server, including SSIS, are not explicitly detailed in the provided context. However, it is important to ensure that the SQL Server edition used supports the required features for BizTalk Server, such as SQL Server Enterprise Edition for BAM real-time aggregation.

For specific licensing details, it is recommended to consult SQL Server licensing documentation or your Microsoft representative.

---

References:

• Install BizTalk Server in a Multi-Computer Environment
• Set up and install prerequisites for BizTalk Server 2020