A good article to read on CDC is the whitepaper that was published a couple of years ago when the feature was released with 2008. IIRC, CDC does create a schema in the local database, but it gets the changes in data from the transaction logs (which has some side effects). SSIS also can extract the data for loading into a separate database, and you can do it through SQL as well.