If I understand what you're proposing you only need 1 connection so you need only wire up one core of a multi-core cable, however I'd do at least 2 for resilience. In this situation I'd use a cable that fits the cable restraints in the connector for mechanical stability. I only suggested CY if you had some left over from wiring up steppers or vfd, I wouldn't buy it specifically for this.