MES Connection - NTLM authentication

This procedure explains how to use its own account to get data from MES server (using API) with Dataiku.

To illustrate the process, the MES server is : estorms01-sv01 (IP21)

In case of any configuration trouble, send a Freshdesk ticket to SBS Analytic team.

Step-by-step guide

Pre-requisites :

Have read access to estorms01-sv01 with your own Windows account
Have a datascientist role in Dataiku in order to be able to update a Notebook
Have your own notebook python code such as this one http://dss.solvay.com/projects/TORRELAVEGA_REPRODUCTION/notebooks/jupyter/notebook%20editor%20for%20recipe%20from%20notebook%20FCOMOLET's%20Python%20notebook_2/ (if necessary, copy past this notebook to create yours)
Check that your Notebook is using Kernel 3.6 environment

If it's not the case, you can change by selecting from your notebook : Kernel (1) → Change kernel (2) → Python (env Python3_6) (3)

In dataiku plateform, go to User Center (1) -> Profile & Settings (2) :
Go to My Account (1) -> add (2)
Then add your credential (login (1) and windows password (2)) Don't forget to tick the "secret" box. Then Click on "OK" button (3) and save your settings
In your notebook, define the same user as mentioned in step 3 int the following code (example from the notebook : http://dss.solvay.com/projects/TORRELAVEGA_REPRODUCTION/notebooks/jupyter/notebook%20editor%20for%20recipe%20from%20notebook%20FCOMOLET's%20Python%20notebook_2/)
You can now create a NTLM authentication and give the ntlm_auth parameter to the post request API call (1)

# Example call for nltm authentication from requests_ntlm import HttpNtlmAuth ntlm_auth = HttpNtlmAuth('EUA\\'+usr, pwd)