Does compensation connect to payroll automatically?

Yes. An approved compensation cycle feeds directly into payroll runs, this is a genuine working connection, not just adjacent modules that happen to share a name.