Forum Discussion

woutervolkeri's avatar
woutervolkeri
Icon for Advocate I rankAdvocate I
10 years ago

Which SQL 2016 license is requirement for using the Enterprise Gateway?

Dear all,   In order to use the Enterprise Gateway either the SQL Server BI - or Enterprise edition is required. However, MS SQL 2016 does not offer a BI edition anymore and a limited version of Ta...
Need Help
Anonymous's avatar
Anonymous
Not applicable
10 years ago

Sandy  chass Would it be possible to get an "official" PBI team answer to the above thread. Does the use of the EG gateway require Enterprise level SQL for SSAS or will Standard work for SQL 2016?

woutervolkeri's avatar
woutervolkeri
Icon for Advocate I rankAdvocate I
10 years ago

 

I got a response from Microsoft on my question.

 

Microsoft:

Enterprise Gateway gives you the benefit of using Analysis Services Tabular mode in DirectQuery mode and this is Enterprise Edition only feature. Other than that I think there is no specific requirement for the customer to use Enterprise Edition with Enterprise Gateway.

 

Wouter:

Just to confirm. My client only wants to use the live connection to Tabular Model – so not the DirectQuery mode. Can I tell him that the Standard Edition is sufficient?

 

Microsoft:

Yes, technically speaking Standard Edition is sufficient.