1 of 2 people found this helpful
You can access Oracle server from Tableau Desktop.
For that you have to give the Oracle server IP address and your username and password.
That is, if the Oracle server admin makes you an authenticated user, you will be given a username and password. Then you can connect to Oracle server by entering the needed credentials. Later you can work with only those database objects to which you are given permissions by the admin. You can access the tables you are permitted and work with them in Tableau.
You don't have to enable all the IP addresses of individual colleagues.
I need to explain better the context:
the Oracle server at stake allows the access only to a list of IP address (or ranges). This is the given firewall configuration and that is it.
So, who wants to access this Oracle database needs the Oracle credentials AND to be added in the list of enabled IP address .
Not knowing Tableau, my question is : can be sufficient to give such IP (and Oracle) access to the Tableau server, or is it necessary that each desktop client has it?