The Reporting layer which consists of components like Power BI, Data Zen, SQL Server Reporting Services, PowerPivot\View on Excel can directly read from the source systems.
When do I get what and how will I get charged for is a question which comes to our mind. There are two main components to be bought.
- SQL Server
SQL Server has a core based licensing and let us say we buy 16 Cores of SQL License. I can install this on a single box with all the SQL components which are mentioned above.
i. SQL Database Relational Engine.
ii. SQL Server Integration Services
iii. SQL Server Analysis Services.
iv. SQL Server Reporting Services
v. Datazen for SQL 2014 and below (It is integrated into SQL Server Reporting Services from 2016 onwards )There is no additional licensing for each component, when you buy SQL Server License, you have the entire stack at your disposal.Another alternative to it could be to deploy couple of components on one server with 8 crores. Let us say the relational database engine, Integration Services are on Server A, SQL Server Analysis Services and Reporting Services on another server, let us call it Server B which has 8 cores which is typically called the scale out architecture in case of intensive ETL and Reporting requirements.