Test Data Manager

  • Private Community

  • 1.  Masking Oracle RDS in AWS Cloud

    Posted Apr 17, 2018 07:44 AM

    Hi ,

     

    We are planing to mask a oracle Database using CA TDM which is hosted in Amazon Cloud .As masking  using GT subset (Scramble functions) requires Java support  But the Amazon RDS does not support Java ,how we can mask oracle database in AWS ? 

     

    Regards,

    Krushna

     

     



  • 2.  Re: Masking Oracle RDS in AWS Cloud

    Broadcom Employee
    Posted Apr 20, 2018 04:34 PM

    Hi Krushna,

    That's a great question.

    Allow me some time to ask some colleagues to see if we can up with a working suggestion for you.



  • 3.  Re: Masking Oracle RDS in AWS Cloud
    Best Answer

    Posted May 03, 2018 04:49 PM

    Krushna,

     

    Are you able to connect to the RDS DB remotely via JDBC?  In theory you should be able to per Amazon's documentation:

    Adding an Amazon RDS DB Instance to Your Java Application Environment - AWS Elastic Beanstalk 

     

    So you'd need to open Subset on your current TDM server and setup the connection profile to point to the RDS DB. Obviously your TDM server will need access to the RDS server which can be complicated if the TDM server in on your corporate network without any sort of link to RDS. Opening DB ports for RDS to the internet as a whole is a bad idea...

     

    If you were attempting to mask locally via FDM for example - that would require an AWS instance since RDS doesn't provide you with any local java access to the DB server.