0 out of 2 rated this helpful - Rate this topic

OPENQUERY (DMX)

SQL Server 2005

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

Syntax


OPENQUERY(<named datasource>, <query syntax>)

Arguments

named datasource: A data source that exists on the Microsoft SQL Server 2005 Analysis Services (SSAS) database.

query syntax: A query syntax that returns a rowset.

Remarks

You can get a list of the data sources available on the server by querying the MDSCHEMA_INPUT_DATASOURCES schema rowset. For more information about using MDSCHEMA_INPUT_DATASOURCES, see MDSCHEMA_INPUT_DATASOURCES Rowset.

OPENQUERY provides a more secure way to access external data by supporting data source permissions. Because the connection string is pulled directly from the data source, administrators can use the properties of the data source to manage access to the data. For more information about data sources, see Working with Data Sources (Analysis Services).

Examples

The following example uses the MyDS data source already defined on the Analysis Services database to create a connection to the AdventureWorksDW database and query the vTargetMail view.

OPENQUERY (MyDS,'SELECT TOP 1000 * FROM vTargetMail')

Reference

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

Help and Information

Getting SQL Server 2005 Assistance

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD