4 Replies Latest reply on Jun 17, 2019 11:21 AM by Santhosh Sekar

    List the datasource name and the connection details

    Santhosh Sekar

      Hi,

      Im working on migrating the tableau server from one machine to other and due to which we need to modify the existing IP with new IP address. So I would like to figure it out the list of datasources and its connection info.

      Can you please help me on the query to grab those? I have tried executing the below query but finding hard to search those since everything looks embedded in the workbooks.

       

      select * from public.datasources where id in (select datasource_id  from public.data_connections where dbclass='postgres' and port=8060)

       

      Thank you