SSAS Data Connection and Impersonation Info


When we create a datasource in SSAS, we need two types of connection information

Data Connection:

As the name goes, this information is used to connect to data source. This can be a standard User ID / Password combination (can be used for SQL Server, Oracle or any DB). If you connect to SQL Server, you can use Windows Authentication also (preferred method due to better security) for this.

Impersonation Information:

This specifies a Windows account used for SSAS Server management such as cube processing (create aggregations, SSAS indexes and write those into SSAS internal files such as *.lstore, *.asstore found in D:\Program Files\Microsoft SQL Server\MSAS10.SQL2008\OLAP\Data\<ProjectName>\ ). This cannot be a SQL account since OS tasks need to be achieved using this authentication.

Regards

Jegan

Advertisements

About EasyBIJegan

Business Intelligence Developer
This entry was posted in BusinessIntelligence, SSAS and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s