Wijmo OLAP: connect to SSAS using windows authentication

Wijmo OLAP: connect to SSAS using windows authentication

Posted by: kuzmina_olga on 13 November 2019, 6:01 pm EST

• 

  kuzmina_olga

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 13 November 2019, 6:01 pm EST

  Is it possible to use windows authentication to connect to SSAS cube? I have http access to olap cube (with windows authentication)
  
  I can connect to it with Excel or SQL Server Management studio (and it’s working ok).
  
  Now I try to create Angular 8 application to do the same.
  
  I managed to connect you sample cube (anonymous access), but I can’t do it with mine (401 - not authorized). Is it possible to use windows authentication in such scenario?

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 14 November 2019, 10:29 pm EST

  Hi Olga,

  You can use the fs-jwt-xhr-hook library to send the username and password with the XHR request:

  var hook = new TokenHook();
  hook.installHook(url, function(xhr) {
    if (xhr.readyState == 1) {
        xhr.setRequestHeader('Authorization', 'token');
    }
  });
  // initialize wijmo's OLAP
  

  Please refer to the link below for more information:

  https://www.npmjs.com/package/fs-jwt-xhr-hook

  Regards,
  
  Ashwin

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 26 January 2020, 7:39 pm EST

  Hi Olga,

  The itemsSource accepts another 2 properties, user and password along with the url and cube. These properties can be used to provide the username and password for windows authentication:

  itemsSource: {
      url: 'http://url//msmdpump.dll',
      cube: 'Cube',
      user: 'username',
      password: 'password'
  }
  
  

  Let me know if this works for you.

  ~regards