topic Re: Decrypt data load from SQL Server 2008. in QlikView https://community.qlik.com/t5/QlikView/Decrypt-data-load-from-SQL-Server-2008/m-p/641391#M677380 <HTML><HEAD></HEAD><BODY><P>Was the data encrypted using T-SQL? Then you can decrypt it in your SQL statements (T-SQL supports AES encryption/decryption using symmetric keys or certificates).</P><P></P><P>If you want to do this in QlikView, you'll have to write a macro function which won't be terribly efficient...</P></BODY></HTML> Thu, 05 Jun 2014 19:26:40 GMT Peter_Cammaert 2014-06-05T19:26:40Z Decrypt data load from SQL Server 2008. https://community.qlik.com/t5/QlikView/Decrypt-data-load-from-SQL-Server-2008/m-p/641390#M677379 <HTML><HEAD></HEAD><BODY><P>I have data load from SQL Server 2008 and encrypted previously with AES 256. I have key and certificate. Could someone help me with a AES 256 decrypt function.?. Exist something like that?. It isn't a Qlikview Expressor environment.</P></BODY></HTML> Thu, 05 Jun 2014 18:28:48 GMT https://community.qlik.com/t5/QlikView/Decrypt-data-load-from-SQL-Server-2008/m-p/641390#M677379 2014-06-05T18:28:48Z Re: Decrypt data load from SQL Server 2008. https://community.qlik.com/t5/QlikView/Decrypt-data-load-from-SQL-Server-2008/m-p/641391#M677380 <HTML><HEAD></HEAD><BODY><P>Was the data encrypted using T-SQL? Then you can decrypt it in your SQL statements (T-SQL supports AES encryption/decryption using symmetric keys or certificates).</P><P></P><P>If you want to do this in QlikView, you'll have to write a macro function which won't be terribly efficient...</P></BODY></HTML> Thu, 05 Jun 2014 19:26:40 GMT https://community.qlik.com/t5/QlikView/Decrypt-data-load-from-SQL-Server-2008/m-p/641391#M677380 Peter_Cammaert 2014-06-05T19:26:40Z Re: Decrypt data load from SQL Server 2008. https://community.qlik.com/t5/QlikView/Decrypt-data-load-from-SQL-Server-2008/m-p/641392#M677381 <HTML><HEAD></HEAD><BODY><P>They are using EncryptByKey. I don't have idea about how to do decrypting. If someone have a macro or documentation about how to do that pleas appreciate.your help.</P></BODY></HTML> Thu, 05 Jun 2014 20:13:12 GMT https://community.qlik.com/t5/QlikView/Decrypt-data-load-from-SQL-Server-2008/m-p/641392#M677381 2014-06-05T20:13:12Z Re: Decrypt data load from SQL Server 2008. https://community.qlik.com/t5/QlikView/Decrypt-data-load-from-SQL-Server-2008/m-p/641393#M677383 <HTML><HEAD></HEAD><BODY><P>There is a corresponding T-SQL function called DecryptByKey.</P><P></P><P>But I think you're asking this in the wrong forum. Better post your question in one of the many SQL Server forums.</P></BODY></HTML> Thu, 05 Jun 2014 20:43:07 GMT https://community.qlik.com/t5/QlikView/Decrypt-data-load-from-SQL-Server-2008/m-p/641393#M677383 Peter_Cammaert 2014-06-05T20:43:07Z Re: Decrypt data load from SQL Server 2008. https://community.qlik.com/t5/QlikView/Decrypt-data-load-from-SQL-Server-2008/m-p/641394#M677387 <HTML><HEAD></HEAD><BODY><P>More info on DecryptByKey: <A href="http://msdn.microsoft.com/en-us/library/ms181860.aspx">http://msdn.microsoft.com/en-us/library/ms181860.aspx</A></P><P></P><P>Can we send a "<EM>Open</EM> (...)" command to the SQL Server, before the "<EM>Select</EM>" statement?</P></BODY></HTML> Mon, 23 Jun 2014 17:55:23 GMT https://community.qlik.com/t5/QlikView/Decrypt-data-load-from-SQL-Server-2008/m-p/641394#M677387 2014-06-23T17:55:23Z Re: Decrypt data load from SQL Server 2008. https://community.qlik.com/t5/QlikView/Decrypt-data-load-from-SQL-Server-2008/m-p/641395#M677388 <HTML><HEAD></HEAD><BODY><P>Yes, you can send a OPEN command to the SQL server before SELECT statement. You'll need to add CLOSE command after the SELECT statement.</P></BODY></HTML> Thu, 17 Jul 2014 22:23:45 GMT https://community.qlik.com/t5/QlikView/Decrypt-data-load-from-SQL-Server-2008/m-p/641395#M677388 marychen 2014-07-17T22:23:45Z