Home > Uncategorized > SSAS encryption

SSAS encryption

Description: Customer asking if AS supports TDE like encryption we got in SQL Engine.

Solution:

SSAS doesn’t support any data encryption on disk, in simple words – SSAS doesn’t do any kind of encryption.

What it supports:

HTTPS –

You can use Analysis Services using PUMP and configure pump with HTTPS

Windows File System encryption  –

You can use Windows File System encryption (Windows Server 2003) or BitLocker (on Windows Server 2008 and Windows Server 2008 R2) to encrypt the drive used to store cubes. Be careful, though; encrypting MOLAP data can have a big impact on performance, especially during processing and schema modification of the cube. We have seen performance drops of up to 50 percent when processing dimensions on encrypted drives though less so for fact processing. Weigh the requirement to encrypt data carefully against the desired performance characteristics of the cube.

References:

Encrypting File System in Windows XP and Windows Server 2003

BitLocker Drive Encryption

Use ROLAP partitions –

Use ROLAP for very confidential data and store the data in a TDE encrypted Database.

Caveat – ROLAP comes with its Performance cost, so keep that in mind.

Advertisements
Categories: Uncategorized
  1. No comments yet.
  1. No trackbacks yet.

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

%d bloggers like this: