Can we have individual databases to hold individual tenants' data inside a single Orchestrator?
In short, no. The same would not be possible, as the Orchestrator is hard coded and configured to speak to only one database at a given time. This would mean that tenants cannot be split into different databases and make one single Orchestrator access the same. Even if the tenant data can be split into different databases, a single Orchestrator cannot technically communicate with different databases.
The workaround for this scenario would be to have different installations of Orchestrator to handle the individual databases. The downside to the same will be using individual application servers and having different licenses as per the tenants desired.