We have a Business Intelligence Server on Amazon (EC2) hosting database of more than 100 customer. Each customer has a separate database because it has millions of records and in addition to being large databases would like to allow each customer to have access privilege to customize their own dashboards. In this context, I would like to use Zoho Analytics on premise installed on that single server on Amazon (EC2) and create a workspace for each customer. I will configure the profile of each workspace for each customer's database path and I can create an access privilege for each workspace. The problem with working with a workspace for each customer is that I'm going to create a default dashboard for all customers? I would like to have a template workspace and all changes or insertions in the objects (Charts, Pivot Tables, dashboards) would be replicated to all the workspaces of each customer. 

So my questions are:

1) I can create a default workspace and share objects with other workspaces automatically without having to configure more than 100 workspaces (more than 100 customers) individually

and make changes and insertions of objects?

2) Could I develop software in Java and access the Zoho Analytics on Premise API and change or include objects (Charts, Pivot Tables, dashboards) individually from a workspace?

3) What is the best way to have a single server and more than 100 customer on the same server allowing privileges to access dashboards individually on each database?