Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Encryption of data while data migration

  1. #1

    Default Encryption of data while data migration

    Hi all

    I have to migrate data from SQL server to Oracle in encrypted format.

    I know how to migrate data from sql server to oracle but i dont know how to encrypt the data and migrate.

    Please Suggest

    Best Regards
    Majid

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    Depends on which encrypted format.

    1) - Do you want encryption through the transfer
    2) - Encrypted data in Oracle
    - ...

    If you're talking about 1) that's BS as you would have to have processing components on both sides. 2) would be almost BS as you need some kind of reversible encryption.

    Use an SSL connection to reach your target and you will automatic point-to-point encryption.

    Regards,
    Sven
    Last edited by sboden; 09-20-2007 at 04:13 AM.

  3. #3

    Default Encryption of data while data migration

    Hi sboden

    Thanks for UR reply.

    I need Encrypted data in Oracle.

    Please Suggest how to achieve this.

    Best Regards
    Majid

  4. #4
    Join Date
    May 2006
    Posts
    4,882

    Default

    You can only obfuscate, not encrypt probably. I don't see an easy:
    - Oracle supports encryption via some PL-SQL package, but that's not duplicated in Kettle
    - You could encrypt using Kettle (via Javascript e.g.) but then you can't access it in Oracle (unless you write the same encryption/decrypt there as well).

    So you're kind of stuck between a rock and a hard place, no easy way out.

    Regards,
    Sven

  5. #5
    Join Date
    Mar 2006
    Posts
    170

    Default Thoughts on a good way to Decrypt Data that is Held in Encrypted State?

    Hi All,

    I have encrypted data in my db I need to decrypt it on the fly and create a flat file with it.

    Thoughts on a good way to do this?

    I'll have access to the keys.

    PDI 2.5.2

    Thanks

    Kent

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.