2 Replies Latest reply on Mar 26, 2018 5:34 PM by Amy Sheu

    Edit datasource's database name & SQL on Tableau server?

    Jack Baker

      Is it possible to programmatically update a published data source's database name and other details not exposed in the server UI using one of the SDK/API’s?

       

      The scenario is that I have a very large datasource/extract(100 million rows) published that was built connecting to a test database. In order to even create this datasource/extract we had to create an “empty
      extract” by short circuiting the SQL in the test database, publish the datasource/empty extract from Desktop and then let the server refresh the extract with all of that data after updating the SQL view to return rows again.

       

      Our companies governance model will not allow us to do that trick in our production environment so I was wondering if there was a way to update that datasorces database name,SQL\stored procedure without using desktop.