locked
Decrypt File from Blob Storage and put the data into Azure SQL DB RRS feed

  • Question

  • Hi All,

    I am trying to achieve a data flow with Azure Data Factory can somebody <g class="gr_ gr_8 gr-alert gr_gramm gr_inline_cards gr_run_anim Style multiReplace" data-gr-id="8" id="8">help ?</g>

    I have encrypted files with PGP and have public and private keys. I would like to use Azure Data Factory to read <g class="gr_ gr_13 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar only-ins doubleReplace replaceWithoutSep" data-gr-id="13" id="13">file</g> from Blob Storage, get <g class="gr_ gr_18 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar only-ins doubleReplace replaceWithoutSep" data-gr-id="18" id="18">key</g> from Vault and then decrypt the file and load the data into SQL DB. 

    Has someone achieved something like that?  Would that we possible with current Azure <g class="gr_ gr_33 gr-alert gr_gramm gr_inline_cards gr_run_anim Style multiReplace" data-gr-id="33" id="33">capabilities ?</g>

    Thanks,

    Tanmay


    Thursday, November 23, 2017 11:26 AM

All replies

  • sounds like you need a custom C# activity 

    basically C# codes that runs on a Azure Batch Node and does the steps you described

    there is no native way to do this at the moment

    -gerhard


    Gerhard Brueckl
    blogging @ http://blog.gbrueckl.at
    working @ http://www.pmOne.com

    Friday, November 24, 2017 4:08 PM