USP_UDM_OLAPDATASOURCE_GETCONNECTIONINFO_BYID

CREATE procedure dbo.USP_UDM_OLAPDATASOURCE_GETCONNECTIONINFO_BYID

/* 
Used by the OLAP Report Deployment utility 
Retrieves information needed to connect to an OLAP data source.
SPWrap generated in SPWrapOLAP has been depreciated. Any changes should be updated in Blackbaud.AppFx.SpWrap
*/

@OLAPDATASOURCEID UNIQUEIDENTIFIER 

AS

SET NOCOUNT ON;

--open key to decrypt IMPERSONATEUSERPWD value

exec dbo.USP_GET_KEY_ACCESS;


SELECT 
SOURCENAME,
SOURCEDESCRIPTION,
CONNECTIONSTRING,
IMPERSONATE,
IMPERSONATEUSERACCOUNTSID,

CAST(DecryptByKey(IMPERSONATEUSERPWD) AS NVARCHAR(128)) as IMPERSONATEUSERPWD_DECRYPTED,

IMPERSONATELOCALUSERNAME,UDMDEPLOYMENTMANIFEST ,ETLSERVERNAME,ETLJOBNAME,ETLJOBSTEPNAME,MARTMANIFEST,ETLDATABASENAME,ISOLAP,

OLAPCLIENT_HTTP_DATASOURCE_URL

FROM DBO.OLAPDATASOURCE

WHERE ID=@OLAPDATASOURCEID;

close symmetric key sym_BBInfinity;

return 0;