asked on SQL Server 2016 Business Intelligence tools and training
We are looking for an installation of SQL Server where it serves a data warehouse, runs ETL jobs on the data, and provides Business Intelligence information by using dashboards, reports, etc. From my research, it looks like SQL Server 2014 had a specific BI edition but for 2016 all BI tools are only offered in the Enterprise edition. Please correct me if I am wrong.
Is there a place to find specific SQL Server 2016 BI tools documentation and specific training?
Thank you for your help.
Is there a place to find specific SQL Server 2016 BI tools documentation and specific training?
Thank you for your help.
Microsoft SQL Server
Last Comment
Vitor Montalvão
If you are just referring to SSIS packages and the ability to design/develop them, then all you need is a compatible version of SQL Server Data Tools (SSDT) and an edition of SQL Server that is not Express.
I guess the "advanced" or "end to end" BI that the documentation is referring to are SSAS enhancements, support for the R language and mobile reporting enhancements.
I guess the "advanced" or "end to end" BI that the documentation is referring to are SSAS enhancements, support for the R language and mobile reporting enhancements.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you everyone for your answers.
It appears as though I would have to decide between Standard and Enterprise editions of 2016.
The few differences that I can see but not completely understand:
1. BI - Advanced tabular model
2. BI - Direct query
3. BI - In-memory analytics
4. BI - Advanced data mining
5. Advanced data integration (fuzzy grouping and look ups, change data capture)
6. Data warehousing (in-memory columnstore, partitioning)
Maybe the training courses 20767 and 20768 might be able to provide clarity on these limitations of the Standard version. If there is a better or easier way to get that information, please let me know.
It appears as though I would have to decide between Standard and Enterprise editions of 2016.
The few differences that I can see but not completely understand:
1. BI - Advanced tabular model
2. BI - Direct query
3. BI - In-memory analytics
4. BI - Advanced data mining
5. Advanced data integration (fuzzy grouping and look ups, change data capture)
6. Data warehousing (in-memory columnstore, partitioning)
Maybe the training courses 20767 and 20768 might be able to provide clarity on these limitations of the Standard version. If there is a better or easier way to get that information, please let me know.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Just a side note that your question was about BI in standard vs. enterprise edition and not about SQL 2016 "RDBMS Scalaibility and Performance" as described here https://msdn.microsoft.com/en-us/library/cc645993.aspx but as long as you got your answers is all it matters.
BTW - you can build your own data warehouse with SQL Standard edition because there is no "There's no Datawarehouse for Enterprise Edition" either.
As far as I'm aware Microsoft does not sells a "Datawarehouse" product and this is just a entity you build using various products.
Good luck and indeed Enterprise is better from any point of view VS Standard if you have lots of data AND it needs to be up 24/7 - just think ONLINE maintenance besides functionality.
BTW - you can build your own data warehouse with SQL Standard edition because there is no "There's no Datawarehouse for Enterprise Edition" either.
As far as I'm aware Microsoft does not sells a "Datawarehouse" product and this is just a entity you build using various products.
Good luck and indeed Enterprise is better from any point of view VS Standard if you have lots of data AND it needs to be up 24/7 - just think ONLINE maintenance besides functionality.
As far as I'm aware Microsoft does not sells a "Datawarehouse" product and this is just a entity you build using various products.They tried with SQL Server 2012 and it was called Parallel Data warehouse aka PDW but seems that they reverted and now it's included in SQL Server 2016 Enterprise Edition (Enterprise-scale data warehousing).
https://msdn.microsoft.com/en-us/library/hh231681.aspx
https://msdn.microsoft.com/en-us/library/hh231722.aspx
where it never says Enterprise SQL 2016 is a prerequisite.
https://msdn.microsoft.com/en-us/library/ms144275.aspx
Enterprise The premium offering, SQL Server 2016 Enterprise edition delivers comprehensive high-end datacenter capabilities with blazing-fast performance, unlimited virtualization, and end-to-end business intelligence — enabling high service levels for mission-critical workloads and end user access to data insights.
Standard SQL Server 2016 Standard edition delivers basic data management and business intelligence database for departments and small organizations to run their applications and supports common development tools for on-premise and cloud — enabling effective database management with minimal IT resources.