2 Replies Latest reply on Feb 12, 2014 1:47 PM by Jason Caulk

    Is it possible to update an Embedded Password in multiple workbooks simultaneously?

    Jason Caulk

      Title says it all...  I've got multiple workbooks that are published with embedded credentials. 

       

      Our active directory forces a password reset every 90 days.

       

      It would be great to have a update function that would change the password for all of the selected workbooks - at the same time.

       

      Anyone know how to do this?

       

      Thanks

      Jason

        • 1. Re: Is it possible to update an Embedded Password in multiple workbooks simultaneously?
          Russell Christopher

          Hey Jason -

           

          Short answer is "no".

           

          There are a couple of approaches you could take, but none of them are probably as "auto-magic" as you'd like:

           

          • Don't embed passwords at all. Instead, use Tableau's Run As account to hit data sources (assuming they respect AD credentials - SQL Server, SSAS, etc). Advantage: Super-duper easy - This domain account will have to be updated anyway when your hit your expiration, but once you've done so, you're done. Disadvantage: You're giving one account access to an awful lot of data, and your biz policies may preclude same.
          • Use a limited number of Data Server Data Sources with embedded passwords and base all workbooks off these data sources.  Change PWs in the Tableau Portal
          • Write a script which uses TabCmd to: 1) Download the workbook 2) Republish with the new AD password
          • Hire a summer intern to change each data source in the portal for you
          • 2. Re: Is it possible to update an Embedded Password in multiple workbooks simultaneously?
            Jason Caulk

            Russell,

             

            Thanks for the detailed reply.  I had a feeling that was really the final answer....

            Your alternate suggestions are in deed helpful.

             

            Some pros and cons to each, as you call out.

             

            Thanks again for the quick / and thorough reply

             

            Jason

            .