| title | Analysis Services Connection Manager | |||
|---|---|---|---|---|
| description | Analysis Services Connection Manager | |||
| author | chugugrace | |||
| ms.author | chugu | |||
| ms.date | 03/29/2024 | |||
| ms.service | sql | |||
| ms.subservice | integration-services | |||
| ms.topic | concept-article | |||
| f1_keywords |
|
|||
| helpviewer_keywords |
|
[!INCLUDEsqlserver-ssis]
An [!INCLUDEssNoVersion] [!INCLUDEssASnoversion] connection manager enables a package to connect to a server that runs an [!INCLUDEssASnoversion] database or to an [!INCLUDEssASnoversion] project that provides access to cube and dimension data. You can only connect to an [!INCLUDEssASnoversion] project while developing packages in [!INCLUDEssBIDevStudioFull]. At run time, packages connect to the server and the database to which you deployed the [!INCLUDEssASnoversion] project.
Both tasks, such as the [!INCLUDEssASnoversion] Execute DDL task and the [!INCLUDEssASnoversion] Processing task, and destinations, such as the Data Mining Model Training destination, use an [!INCLUDEssASnoversion] connection manager.
For more information about [!INCLUDEssASnoversion] databases, see Multidimensional Model Databases (SSAS).
When you add an [!INCLUDEssASnoversion] connection manager to a package, [!INCLUDEssNoVersion] [!INCLUDEssISnoversion] creates a connection manager that is resolved as an [!INCLUDEssASnoversion] connection at run time, sets the connection manager properties, and adds the connection manager to the Connections collection on the package. The ConnectionManagerType property of the connection manager is set to MSOLAP100.
You can configure the [!INCLUDEssASnoversion] connection manager in the following ways:
-
Provide a connection string configured to meet the requirements of the Microsoft OLE Provider for Analysis Services provider.
-
Specify the instance of [!INCLUDEssASnoversion] or the [!INCLUDEssASnoversion] project to connect to.
-
If you are connecting to an instance of [!INCLUDEssASnoversion], specify the authentication mode.
Note
If you use SSIS in Azure Data Factory (ADF) and want to connect to Azure Analysis Services (AAS) instance, you can not use an account with Multi-Factor Authentication (MFA) enabled, but must use an account that does not require any interactivity/MFA or a service principal instead. To use the latter, see Automation with service principals to create one and assign the server administrator role to it, then select Use a specific user name and password to log on to the server in your connection manager, and finally enter User name: app:YourApplicationID and Password: YourAuthorizationKey.
- Indicate whether the connection that is created from the connection manager is retained at run time.
You can set properties through [!INCLUDEssIS] Designer or programmatically.
Use the Add Analysis Services Connection Manager dialog box to create a connection to a server running [!INCLUDEssNoVersion] [!INCLUDEssASnoversion], or to edit connection properties.
Create a connection to a computer running Analysis Services
Use the default connection to a server that is running an instance of [!INCLUDEssASnoversion], or create a new connection by clicking Edit.
Edit
Use the Connection Manager dialog box to create a connection to a server that is running an instance of [!INCLUDEssASnoversion], and to edit connection properties.
Create a connection to an Analysis Services project in this solution
Specify that the connection will use an [!INCLUDEssASnoversion] project in the open solution.
Note
Analysis Services tabular model projects are not supported for this scenario.
Analysis Services project
Select an [!INCLUDEssASnoversion] project from the list.
For information about configuring a connection manager programmatically, see xref:Microsoft.SqlServer.Dts.Runtime.ConnectionManager and Adding Connections Programmatically.