Data loading with filter on user logged

[Sabrina Lo Bue]

Hi, 

We defined one dataTable that contains a 'user' column.

During the initial loading's phase, we want to get only rows in which the 'user' column matches with the current user logged (on webplayer).

Can you help me?

Thanks Sabrina.

[Kirsten Smith (she/her)]

If you are using the Information Designer you can set up Personalized Information Links:

https://docs.tibco.com/pub/sfire-analyst/12.0.1/doc/html/en-US/TIB_sfire-analyst_UsersGuide/index.htm#t=id%2Fid_personalized_information_links.htm

[Sabrina Lo Bue]

We can't use Information Designer because we have a Denodo datasource that doesn't appear in information link's types. Do you have any suggestions?

[Fredrik Rosell]

Hello,

>we have a Denodo datasource that doesn't appear in information link's types.

I'm not quite sure how to interpret that, but just so you are aware, please note that there is technically nothing preventing the use of Denodo in general for information links - it's simply not available out-of-the-box, so you need to add a custom data source, i.e. provide your own driver and data source template. There is e.g. an example data source template available here:

https://community.spotfire.com/s/article/tibco-spotfire-jdbc-data-access-connectivity-details#Denodo

If that works, personalized information links is definitely a good option. 

If not, an important factor in finding a solution is if you are trying to achieve row level security (strict need for users to only be able to access their own data) or simply making it convenient for the users to only see the data of relevance to them.

Best Regards

Fredrik