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 : 

  1. Have read access to estorms01-sv01 with your own Windows account
  2. Have a datascientist role in Dataiku in order to be able to update a Notebook
  3. 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)
  4. 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)



  1. In dataiku plateform, go to User Center (1) -> Profile & Settings (2) :

  2. Go to My Account (1) -> add (2)
  3. 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


  4.  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/)



  5. 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)