1 Reply Latest reply on Jul 8, 2016 1:15 AM by Dmitry Chirkov

    Can a Datasource be passed to the workbook as a parameter?

    Ibrahima Kaba

      Hi,

       

      Does anyone know if it's possible to use one Tableau workbook to access multiple databases.

       

            <connection class='mysql' dbname='DB1' odbc-native-protocol='yes' port='3306' server='XXX.XXX.XXX.XXX' source-charset='' username='dbuser' workgroup-auth-mode='prompt'>

       

      To explain in more detail -  we have a set of DBs having the same prefix and using the same engine:

      DB1

      DB2

      DB3

      ...

      DB20

       

      What we would like to achieve is instead of publishing 20 workbooks - one per DB:

            <connection class='mysql' dbname='DB1' odbc-native-protocol='yes' port='3306' server='XXX.XXX.XXX.XXX' source-charset='' username='dbuser' workgroup-auth-mode='prompt'>

            <connection class='mysql' dbname='DB2' odbc-native-protocol='yes' port='3306' server='XXX.XXX.XXX.XXX' source-charset='' username='dbuser' workgroup-auth-mode='prompt'>

      ....

       

      to have one workbook and refer to the datasource using  wildcard as an example:

            <connection class='mysql' dbname='DB*' odbc-native-protocol='yes' port='3306' server='XXX.XXX.XXX.XXX' source-charset='' username='dbuser' workgroup-auth-mode='prompt'>

      so a missing part of datasource can be passed to the workbook as parameter. We are assuming that same user has rights to access all DB* databases.

      Please advise if it's possible.

       

      If not is there any other solution, we can consider to use?

       

      Thanks