Skip to content

source-data-query-openrowset.md

Latest commit

 

History

History
67 lines (54 loc) · 2.17 KB

source-data-query-openrowset.md

File metadata and controls

67 lines (54 loc) · 2.17 KB
title OPENROWSET (DMX) | Microsoft Docs
ms.custom
ms.date 03/02/2016
ms.prod sql-server-2016
ms.reviewer
ms.suite
ms.technology
analysis-services
analysis-services/data-mining
ms.tgt_pltfrm
ms.topic language-reference
f1_keywords
OPENROWSET
dev_langs
DMX
helpviewer_keywords
OPENROWSET statement
ms.assetid 8c8b61b4-2bf6-46c7-8976-51484004dc22
caps.latest.revision 34
author Minewiskan
ms.author owend
manager erikre

<source data query> - OPENROWSET

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]

Replaces the source data query with a query to an external provider. The INSERT, SELECT FROM PREDICTION JOIN, and SELECT FROM NATURAL PREDICTION JOIN statements support OPENROWSET.

Syntax

  
OPENROWSET(provider_name,provider_string,query_syntax)

Arguments

provider_name
An OLE DB provider name.

provider_string
The OLE DB connection string for the specified provider.

query_syntax
A query syntax that returns a rowset.

Remarks

The data mining provider will establish a connection to the data source object by using provider_name and provider_string, and will execute the query specified in query_syntax to retrieve the rowset from the source data.

Examples

The following example can be used within a PREDICTION JOIN statement to retrieve data from the [!INCLUDEssSampleDBDWobject] database by using a [!INCLUDEtsql] SELECT statement.

OPENROWSET  
(  
'SQLOLEDB.1',  
'Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security     Info=False;Initial Catalog=AdventureWorksDW2012;Data Source=localhost',  
'SELECT TOP 1000 * FROM vTargetMail'  
)

See Also

<source data query>
Data Mining Extensions (DMX) Data Manipulation Statements
Data Mining Extensions (DMX) Statement Reference