I am presuming there's no option to return the drive and no one here can see exactly what you are seeing. If the connector body is broken but all the metal pins are intact, I suppose it's possible so attempt to secure it to the drive in some fashion and tie it to offer strain relief. Another option, if you are very good with a soldering iron might be to hard wire a cable to the drives interface. I've not cut one of these apart but I've been successful with remaking a USB-2 connector so I must think you can do it with SATA. You've got to be at a point with nothing to lose by trying. Good luck.
I am building my own case, and was (stupidly) trying to connect my hard drive's sata cable in a tight space, and broke the plastic piece that the cable connects to. Now that plastic piece is stuck in the cable. the metal contacts on the drive, however, still appear to be fine. is there a way to jerry-rig the cable to it and have it work, or is it something that a professional could replace, or am i out of luck and should start pricing new ones. if that last one were the case, i would be pretty burned up, since all the information on the drive is intact, just the flimsy plastic connector is gone.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic