Defining a special view on the MS SQL Server data source to use as a buffer for row results
This technique allows you to:
Define views within the foreign data source
Use the result set buffer configuration of the view to access the data returned by the stored procedure
Defining of a special view involves some administration on the foreign datasource and therefore is considered a result set option that is dependent on the foreign data source.