Hey Carlo Bertolino:
Sorry you never received a response--there probably aren't too many users trying to do this type of thing.
I'm certainly not an expert on this, by any means--however, I am wondering if a Stored Procedure could be set up for this? In Tableau 8.1, you can connect to Stored Procedures (new feature). According to this article, if the databases are on the same server, you might be able to do this:
There's also mention of connecting two disparate databases from different servers, if they are linked in some way.
I'd suggest contacting Support@tableausoftware.com to inquire about this ability.
Thank you Matthew for your response. As you stated, my working environment is very different than a normal BI environment where all the data is in one place. Where my environment is not.
The use of stored procedures is a good one. However, the Tableau application will still not allow me to pass a list of values. Lets say 50 customer id's to be evaluated for activity.
I really like what I have seen with Tableau and it is a nice application software. However, I do not think that it is optimal for my needs and will have to continue to evaluate other applications.
I'm not sure what you mean--the connection to Stored Procedures supports passing parameters. Anyway, best of luck.