How to extract data for TEST database

How to extract/create the data you need to build the Test & QA Oracle databases?
Are people using 3rd party software, if so which ones?
Are people using in-house written procedures?
Are people using data generating software like Information Factory? Any other means?
Thanks.