For a direct connection that can withstand some slight misalignment, what about speedometer cable or power seat cable with aluminum collars with set screws at both ends for attaching to the motor and cable? Speedometer cable may be harder to come by than the power seat part since it's been quite a while actually seeing one of those on a car.