I've been evaluating Analysis Services, and have a issue
with regards to using Oracle 8i as a datasource. When
specifying the OLE DB provider information, if the "save
password" option is checked, then the database username
and password are saved unencrypted in the Analysis Manager
Repository. This could pose as a problem!
I would just like to know a couple of things. Firstly,
would I be right in assuming that the Analysis Manager
Repository is in fact the same as the server repository
(which I have migrated from the Access database to Meta
Data Services Format in the recommended 'msdb' database)?
Secondly, is there any way around this issue? I.e. a way
to encrypt the data, or any other way? Thirdly, does
anybody else see this as an issue, or am I merely being
Any information about the subject will be greatfully
recieved, as the info currently available seems to be
rather sparse! Any information pertaining to the
Repository, and the issue raised.
Thank you for reading, and thanks for any help you may be
able to give.