Is AD your authoritative source? Or do you have a HR system or something you’re bringing users from initially?
Generally if it’s from a HR source, you’d set something like the below
From there you can lookup the managers DN, map this to an identity profile attribute and then map that value in your creation profile for the AD Source to the AD attribute Manager.