Get the most out of Sitecore’s data and analytics beyond out-of-the box dashboard with Sitecore 8.X and MongoDB BI Connector

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.

To help marketers ans BI specialists I used  two tools: MongoDB Connector for BI and Tableau .

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

systemLog:
logAppend: true
logRotate: “rename”
path: D:\mongodb\log\mongoBi.log
net:
bindIp: 127.0.0.1, 172.27.X.X
port: 3307

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

 

-BI Connector.png

 

 

BI Connector

Enjoy!

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s