Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Who am I? (PDI processes and Active Directory)

  1. #1
    Join Date
    Dec 2015
    Posts
    3

    Question Who am I? (PDI processes and Active Directory)

    Hi all,

    PDI Noob here with a question...

    Short Version: If a user runs a transformation on a Windows server, can it be made to run under that user's Active Directory account? (Please say "yes"). If not, how can a transformation tell who launched it?

    Long Version: Real Soon Now we will have a shiny new PDI server on Windows integrated with Active Directory.
    But I am not yet sure what "integrated" will turn out to mean. I am hoping it will mean:


    • Nobody has to explicitly provide any credentials when running a transformation on the server (or have them baked into a .ktr file / set in an environment variable etc);
    • The transformations will run under my account not some system account;
    • If my transformation connects to SQL Server using Integrated Security, my credentials will be used;


    Is that how things work?
    If it isn't, is there at least a way a transformation can tell who launched it so this information can be passed to a service?

    Ed

  2. #2
    Join Date
    Jul 2009
    Posts
    476

    Default

    If a user runs a PDI transformation interactively, then the process will run under that user's account. If you want to run a PDI transformation in a Windows job, or under a service, then you need to configure the Windows job or service to run under the account that you want.

    You will also need to configure your JDBC connection to use Windows authentication. I don't use SQL Server with PDI, so I don't have details for that.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.