While waiting for Sitecore 9.X and xConnect we may want to get the most out of Sitecore MongoDB, to go beyond out-of-the-box dashboards and impress executives wit h deep insights. In some cases, Sitecore xDB Cloud may limit you what you can get from custom reports.
Fist we need to install and to configure MongoDB Connector for BI on the same server where MongoDB is running
I suggest to install it as Windows Services e.x
C:\Program Files\MongoDB\Connector for BI\2.3\bin\mongosqld.exe” –config=”C:\Program Files\MongoDB\Connector for BI\2.3\mongosqld.cfg”
Here is the content of config file
bindIp: 127.0.0.1, 172.27.X.X
Make sure that the folder for logs files exist and to list all IP that we want to bind the service.
Once the service is running, we can connect from remotely from Tableau. I used Tableau 10.4
1. Click on Connect – To a Server – More…
2. Select MongoDB BI Connector
3. Type is Server IP ( must be listed inmongosqld.cfg file)
4. Click Sign In