waterlogged

Hi i'm looking at putting in some drainage, perforated pipe gravel and membrane as our garden sits on a lot of clay. I'm going to tap into the rainwater pipe, I'm hoping this is ok? Has anyone done this? Would it be best to use the flexible perforated pipe or just normal pipe and drill some...