With PolyBase, SQL Server offers that capability, exposing data in systems as though they were simply local SQL Server tables and letting you use the same set of T-SQL functionality you already know.