When using the SDA tool for e.g., large equity portfolios, does every single company need to be entered individually or is there some other tool to do this on an automated basis?

You can set one SDA target on all companies in the same sector. The SBTi tool can be used to set targets and there are instructions in the guidance for target modelling.