This is a custom SQL for Tableau Server Repository user management. Connect to the Tableau Server Repository from Tableau Desktop, and copy and paste the contents of "UserManagement.sql" into the ...

Tableau can now automatically recognize relationships between data stored in databases such as Oracle and SQL Server, something that previously required the ability to write custom SQL code.

Unfortunately, ability to access Rest API's in Tableau (Desktop or Server) cannot be done without writing custom Web connectors. Power Query in Excel or Power BI does not have this limitation.

Tableau is adding in-memory technology to its upcoming 10.5 release to speed up query times 5x and ingest large data sets faster.