1 2 Previous Next 18 Replies Latest reply on Sep 10, 2018 3:31 PM by Rune Brodersen

    command-line prep refresh fails - two connections to same server

    Rune Brodersen

      I have made a flow in Tableau Prep to make a union of same query to different databases on same ms sql server and published as a data source to Tableau Online.

      That works very well.

       

      I tried then the command-line for update by task scheduler according to the guide, but it fails to update the data.

      Error message: we don't have credentials of all connections in tfl/tflx file?

      How do I add connection for the second connection?

       

       

      I tried just duplicating first block (separated by comma),  but then I get following error message:

      Exception in thread "main" java.lang.AssertionErro:Could not find match for ip at xxx

       

      credentials.json looks like (and connections are named by ip)

       

      {

      "inputConnections":[

        {

          "username": "sqluser",

          "hostname":"ip",

          "port":1433,

          "password": "sqlpass" }

      ],

      "outputConnections":[

        {

          "serverUrl":"https://online.tableau.com",

          "contentUrl":"",

          "username":"email",

          "password":"tableaupass!"  }

      ]

      }

       

      Any ideas?

        1 2 Previous Next