Automate Credentials for DSS Export to Folder (Tableau Server Publish)

Hi,

I think the best way to do this is via user secrets, scenarios, and a python API script (as a scenario step) to update the tableau export recipe with the user's credentials.

Each user can add secrets for their tableau username and password. Make sure the name of each secret (tableau_username, tableau_password) is consistent. (see first screenshot)

In each export to tableau recipe, you can find the recipe name in the URL or top banner. (see second screenshot)

In a scenario, add a python step, and paste the following code (the indentations in the for loop/if statements may not come through this message correctly - please check those). Make sure to update the project key with your project key, and the tableau export recipe name with your tableau export recipe name. (see third screenshot)

## start of code ##

import dataiku
from dataiku import pandasutils as pdu
import pandas as pd

client = dataiku.api_client()

auth_info = client.get_auth_info(with_secrets=True)

# retrieve the tableau username and password secrets
tableau_username = None
tableau_password = None

for secret in auth_info["secrets"]:
if secret["key"] == "tableau_username":
tableau_username = secret["value"]
elif secret["key"] == "tableau_password":
tableau_password = secret["value"]

# replace this project key with your project key
proj = client.get_project("LOANDEFAULTSMS")

# replace this recipe name with your recipe name
tableau_recipe = proj.get_recipe("compute_6va2HSi1")

recipe_sett = tableau_recipe.get_settings()

# set the tableau export recipe params with the user credentials
recipe_sett.get_recipe_params()['exportParams']['config']['username'] = tableau_username
recipe_sett.get_recipe_params()['exportParams']['config']['password'] = tableau_password

recipe_sett.save()

## end of code ##

Let me know if that works!

Best,

Pat