Encrypted Fields in FE and RE

Sean Potter
Sean Potter
Third Anniversary
in Blackbaud CRM Developer Discussions

Is there a standard Stored Procedure or Function that will decrypt fields in RE and/or FE? We have several web tie-ins that query the FE database directly, and some of these fields are now encrypted since the last update we ran.

Comments

  • Steven Finnell
    Steven Finnell
    Sixth Anniversary Kudos 1 Name Dropper Facilitator 1

    Hey Sean,

    So I'm not too familiar with FE and RE as we use BBCRM ourselves but I'm hoping that the encryption/decryption methodology is similar between the three.

    So CRM uses a stored procedure to retrieve a unique key associated with your database:

    USP_GET_KEY_ACCESS

    Once you execute that you have to call the following:

    CONVERT(nvarchar(4000), DECRYPTBYKEY(TABLE.COLUMN))

    Above, TABLE.COLUMN represents the column you're attempting to decrypt.

    After that you just include the following line to get rid of the key when you're done:

    CLOSE SYMMETRIC KEY SYM_BBINFINITY

    Again, this is in reference to CRM but maybe it will give you at least something to work off of. Sorry I can't be of more help.

Categories