4.6 SQL Server Licensing Considerations

There are a number of different licensing options you can use for your SQL Server environment. For example: per CPU, per user, or per device. You must choose an option based on your business requirements. The following table summarizes the connections to SQL Server components to help you decide the licensing type that suits your requirement.

This Analysis Center Component

Connects to this SQL Server Component

Data Warehouse SQL Server Agent

  • Each Data Mart SQL Server

  • The Data Warehouse SQL Server

  • Analysis Services

Analysis Services

  • The Data Warehouse SQL Server

  • Each Data Mart SQL Server

Data Mart SQL Server Agent

  • The associated source database SQL Server

  • The associated Data Mart SQL Server

  • The Data Warehouse SQL Server

Web Service

  • The Data Warehouse SQL Server

  • Analysis Services

Data Extension

  • The database via the Web Service

Console

  • The database via the Web Service

  • Reporting Services