multi tenancy

[srinivas.kunchala99]

Hi all,

Is there any way to add the functionality on a multi-tenanted service, where we have multiple customers using the  same databases(Oracle DB) with the similar schema.

 To be more precise , we have multiple customers who logs into Jasper Environment and they should acess their respecitve data.

Please let me know the possibility of this??

Thanks,

Srinivas k

[elizam]

You can use attributes with your data source.

 http://community.jaspersoft.com/documentation/tibco-jasperreports-server-administration-guide/v62/managing-attributes

[javier.ggi90]

If I understand correctly, what you need is to create a new role in the Jasper environment, asign that role to the respective user and lastly change the permissions of a specific piece of data, a report lest say, to the newly created role.

[hozawa]

Role is used to set permission of resources such as a report. Attribute can be used to set permission on which set of rows in a database to use. Unfortunately, this means all users will be using the same database table so it may be a security risk.

[elizam]

Hozawa's info is outdated. You can now set attributes at the tenant level and then include something in your data source definition that points which database to use, based on the attribute value. This was introduced around 6.0, I believe.

[hozawa]

My bad on this.

The following link provides more concrete example of using attributes in datasource.

 

http://community.jaspersoft.com/documentation/tibco-jasperreports-server-administration-guide/v62/attributes-data-source-definitions

 

Thanks elizam  for correcting me.http://community.jaspersoft.com/sites/all/libraries/ckeditor/plugins/smiley/images/regular_smile.gif