1 Reply Latest reply on Feb 15, 2018 9:35 AM by patrick.byrne.0

    Configuration YAML file for multiple MongoDB connections

    Alena Malaichuk

      Hi all!

       

      I'm now investigating MongoDB BI Connector 2.3 (Tableau Desktop 10.3, Windows Server 2012). I have already configured and installed mongosql service and successfully connected via Tableau. The content of config file is the following:

       

      systemLog:

        logAppend: true

        path: "D:\\logs\\mongosqld_log.log"

        verbosity: 5

      schema:

        path: "D:\\schemas\\schema.drdl"

      net:

        bindIp: 127.0.0.1

        port: 3307

        ssl:

          mode: allowSSL

          PEMKeyFile: "D:\\mongosqld-server.pem"

      security:

        enabled: true

      mongodb:

        net:

          uri: mongodb://mongohost.example.com:27018

       

      Now I want to be able to connect from one Tableau Server to several MongoDB servers with different databases and collections.

      What I tried to do:

      - 2 configs for install --config command did not work for me.
      - Also I tried to 'duplicate' keys in config file - there were 2 blocks of code like above for 2 db - but only second 'section' from config was working

      - uri like  uri: mongodb://mongohost1.example.com:27018,mongohost2.example.com:27016  also didn't work - only second host was available

      - tried to add in configuration file arrays and sequences but without any success - may be my syntax was wrong

       

      Can you please suggest something? May be someone can share an example of such config for several mongo servers?

      Appreciate your help.

       

      Thanks in advance!
      Alena