2 Replies Latest reply on Oct 16, 2013 11:54 PM by Chandra Narayana

    Bulk swap data connection

    Joe Ennever

      We're migrating our analytics database from Vertica to Redshift. Is there is a way to easily swap out all the Vertica data connections in the Tableau Server to be Redshift? I see that you can edit the connection details (host, port, user, etc.) for multiple data connections, but no option to change the connection type. All the tables will have the same name, columns, and data types.

        • 1. Re: Bulk swap data connection
          Michel Caissie

          One thing you can do is to make a second connection to Redshift then go in Data - Replace Data Source,  select Vertica as Current  and Redshift as Replacement. After that you can close the Vertica connection.

           

          I only done it once and i still had to do some manual adjustments on the calculated field wich were still referencing to Measures from the first connection, but at least the Dimensions were correctly replaced and i didn't have to rebuild the Visual.

           

          I don't know if there is a better way to make the transfer more transparent...

           

          Michel

          1 of 1 people found this helpful
          • 2. Re: Bulk swap data connection
            Chandra Narayana

            even I tried this method when i had to change the data source and was able to do that.

             

            Chandra Narayana

            9972669055