| title | Management of Data Mining Solutions and Objects | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 06/13/2017 | ||
| ms.prod | sql-server-2014 | ||
| ms.reviewer | |||
| ms.technology | analysis-services | ||
| ms.topic | conceptual | ||
| helpviewer_keywords |
|
||
| ms.assetid | 06fc61dd-925c-4347-8677-7046ee5d2f6f | ||
| author | minewiskan | ||
| ms.author | owend | ||
| manager | craigg |
[!INCLUDEssCurrent] provides client tools that you can use to manage existing mining structures and mining models. This section describes the management operations that you can perform using each environment.
In addition to these tools, you can manage data mining objects programmatically, by using AMO, or use other clients that connect to an [!INCLUDEssASnoversion] database, such as the Data Mining Add-ins for [!INCLUDEofprexcel] 2007.
Processing Requirements and Considerations (Data Mining)
Using SQL Server Profiler to Monitor Data Mining (Analysis Services - Data Mining)
Mining structures and models that have been processed are stored in an instance of [!INCLUDEssASnoversion].
If you create a connection to an [!INCLUDEssASnoversion] database in Immediate mode when developing your data mining objects, any objects that you create are immediately added to the server as you work. However, if you design data mining objects in Offline mode, which is the default when you work in [!INCLUDEssBIDevStudioFull], the mining objects that you create are only metadata containers until you deploy them to an instance of [!INCLUDEssASnoversion]. Therefore, any time that you make a change to an object, you must redeploy the object to the [!INCLUDEssASnoversion] server. For more information about data mining architecture, see Physical Architecture (Analysis Services - Data Mining).
Note
Some clients, such as the Data Mining Add-ins for [!INCLUDEofprexcel] 2007, also let you create session mining models and mining structures, which use a connection to an instance but store the mining structure and models on the server only for the duration of the session. You can still manage these models through the client, the same as you would structures and models stored in an [!INCLUDEssASnoversion] database, but the objects are not persisted after you disconnect from the instance of [!INCLUDEssASnoversion].
[!INCLUDEssBIDevStudioFull] offers features that make it easy to create, browse, and edit data mining objects.
The following links provide information on how you can modify data mining objects by using [!INCLUDEssBIDevStudioFull]:
Typically you will use [!INCLUDEssBIDevStudioFull] as a tool for developing new projects and adding to existing projects, and then manage projects and objects that have been deployed by using tools such as [!INCLUDEssManStudioFull].
However, you can directly modify objects that are already deployed to an instance of ssASnoversion by using the Immediate option and connecting to the server in Online mode. For more information, see Connect in Online Mode to an Analysis Services Database.
Warning
All changes to a mining structure or mining model, including changes to metadata such as a name or description, require that the structure or model be reprocessed.
If you do not have the solution file that was used to create the data mining project or objects, you can import the existing project from the server using the Analysis Services Import wizard, make modifications to the objects, and then redeploy using the Incremental option. For more information, see Import a Data Mining Project using the Analysis Services Import Wizard.
In [!INCLUDEssManStudioFull], you can script, process, or delete mining structures and mining models. You can view only a limited set of properties by using Object Explorer; however, you can view additional metadata about mining models by opening a DMX Query window and selecting a mining structure.
You can create, alter, process, and delete data mining objects by using the following programming languages. Each language is designed for different tasks and as a result, there might be restrictions on the type of operations that you can perform. For example, some properties of data mining objects cannot be changed by using Data Mining Extensions (DMX); you must use XMLA or AMO.
Analysis Management Objects (AMO) is an object model built on top of XMLA that gives you full control over data mining objects. By using AMO, you can create, deploy, and monitor mining structures and mining models
-
xref:Microsoft.AnalysisServices
Restrictions: None.
Data Mining Extensions (DMX) can be used with other command interfaces such as [!INCLUDEvstecado] or ADOMD.Net to create, delete, and query mining structures and mining models.
Restrictions: Some properties cannot be changed by using DMX.
XML for Analysis (XMLA) is the data definition language for all of Analysis Services. XMLA gives you control over most data mining objects and server operations. All management operations between the client and the server can be performed by using XMLA. For convenience, you can use the [!INCLUDEssASnoversion] Scripting Language (ASSL) to wrap the XML.
Restrictions: [!INCLUDEssBIDevStudioFull] generates some XMLA statements that are supported for internal use only, and cannot be used in XML DDL scripts.