Data Mining Query Transformation

Applies to: SQL Server SSIS Integration Runtime in Azure Data Factory

Important

Data mining was deprecated in SQL Server 2017 Analysis Services and now discontinued in SQL Server 2022 Analysis Services. Documentation is not updated for deprecated and discontinued features. To learn more, see Analysis Services backward compatibility.

The Data Mining Query transformation performs prediction queries against data mining models. This transformation contains a query builder for creating Data Mining Extensions (DMX) queries. The query builder lets you create custom statements for evaluating the transformation input data against an existing mining model using the DMX language. For more information, see Data Mining Extensions (DMX) Reference.

One transformation can execute multiple prediction queries if the models are built on the same data mining structure. For more information, see Data Mining Query Tools.

Configuration of the Data Mining Query Transformation

The Data Mining Query transformation uses an Analysis Services connection manager to connect to the Analysis Services project or the instance of Analysis Services that contains the mining structure and mining models. For more information, see Analysis Services Connection Manager.

This transformation has one input and one output. It does not support an error output.

You can set properties through SSIS Designer or programmatically.

The Advanced Editor dialog box reflects the properties that can be set programmatically. For more information about the properties that you can set in the Advanced Editor dialog box or programmatically, click one of the following topics:

For more information about how to set properties, see Set the Properties of a Data Flow Component.

Data Mining Query Transformation Editor (Mining Model Tab)

Use the Mining Model tab of the Data Mining Query Transformation Editor dialog box to select the data mining structure and its mining models.

Options

Connection
Select an existing Analysis Services connection by using the list box, or create a new connection by using the New button described as follows.

New
Create a new connection by using the Add Analysis Services Connection Manager dialog box.

Mining structure
Select from the list of available mining model structures.

Mining models
View the list of mining models associated with the selected data mining structure.

Data Mining Query Transformation Editor (Query Tab)

Use the Query tab of the Data Mining Query Transformation Editor dialog box to create a prediction query.

Options

Data mining query
Type a Data Mining Extensions (DMX) query directly into the text box.

Build New Query
Click Build New Query to create a Data Mining Extensions (DMX) query by using the graphical query builder.