I haven't taken a close look at the CX9's, but most modern day cars now have a molex connector from the cabin to the door Video (start at about 2:40 into the video). Actually, this video gives you a pretty good overview of what's required these days; it's quite involved.
It used to be so simple...