There is a continuing need for a SQL Function or equivalent to decrypt credit card information from iMIS.

Of course there is an overall security concern, but there still are frequent requirements by customers to have a method to decrypt credit card info, beyond the standard reporting in iMIS.

I have done a little research on this. There is just a little info on it in www.imiscommunity.com.

There is some discussion at this link about the changes as a result of iMIS15 and SQL2005.
http://www.imiscommunity.com/asiutil_ccrypto_and_clr_sql_server_2005

There are suggestions of a solution in this thread, but no code sample.
http://www.imiscommunity.com/encryption_decryption_dll_in_imis15

These discussions were nearly one year ago and I see no further details. My general sense is that it can be done using iBO.NET, but perhaps not iBO.COM anymore.

I am thinking that it might be done using a Coldfusion script, since the checkout in e-Series is working. The issue would still be how to do in either Crystal or MSReporting with a SQL function.

We have seen some reports back from individuals and service providers about applications available for a fee. It is understandable that when information is not immediately available that it be held as proprietary. However, it would really move the entire community forward to share the code samples for decryption with the entire community. The concept of this community is to leverage the knowledge of the community for the benefit of all. Happy iMIS customers ultimately become the greatest value for future business.

So if you have any specific methods for doing this, please share.