1 Reply Latest reply on Mar 19, 2013 12:25 PM by Robert Morton

    sqlproxy

    hari.nalajala

      Hi,

      I am trying to create a Netezaa connection and upload it to Tableau server so that users can create reports from their tableau desktop using Tableau server connection, I am seeing following issues.

       

      1) Tableau is assing a table alias as "sqlproxy" while trying to view table name using Tableau server connection.

      2) Users are not able to edit the connection to add more tables even after giving "Data source editor" privileges, My plan is to create a connection with one table so that users can modify the connection to add as many tables as they want including removing the existing table.

       

      Please let me know if this is possible with Tableau server connections?

        • 1. Re: sqlproxy
          Robert Morton

          Hi Hari,

           

          When a data source is published to Tableau Server and used as a conduit for issuing queries through Tableau Server to the database, it is known as a Data Server data source. The underlying data connection may have multiple tables, but the data source itself presents a single, flat table structure under the internal name 'sqlproxy'. Since Tableau Server proxies the entire data source and not any of the specific elements of the underlying connection, it is not possible for users to manipulate the underlying connection in the fashion you have described. Instead they must download the data source from Tableau Server and modify the connection within Tableau Desktop. This is easy to do from Desktop -- simply click the download icon instead of the link for a given data source in the Tableau Server connection list.

           

          I encourage you to post a new Idea in our Ideas forum and explain the functionality you desire and how it would be used:  http://community.tableau.com/community/ideas

           

          I hope this helps,

          Robert

          1 of 1 people found this helpful