How do you query LDAP outside of the ProcessFlow environment?

 6 Replies
 0 Subscribed to this topic
 12 Subscribed to this forum
Sort:
Author
Messages
Paul Gallucci
Basic Member
Posts: 15
Basic Member

    How do you query LDAP outside of the ProcessFlow environment?

    Is there a way to retreive data from the Resource Manager, (LDAP), outside of the ProcessFlow environment.  

    Since ProcessFlow provides a node to get at LDAP data we’re ok in that environment.  Outside of ProcessFlow, (i.e. Design Studio, 4GL, SQL, etc), there isn’t a way to access LDAP data directly.  At least we don’t how to do that yet.  

    We know a possible work around is to use ProcessFlow to query LDAP and update a table, (or tables), in the application product line.  Then get this information via DME, AGS, etc.
    BUT we'd prefer to make a direct call to LDAP.  

    Is there a way to do that?

    thanef
    Veteran Member
    Posts: 47
    Veteran Member

      Which field do you need from RM?  I've used the userenv LAW_WEB_USR.employee from the default field selection in Design Studio to populate an employee field.  Does that help you any?

      Paul Gallucci
      Basic Member
      Posts: 15
      Basic Member

        Yes that solves the problem for Design Studio but I still need to know if there's a way to query the Resource Manager LDAP repository outside of ProcessFlow or the Resource Manager.

        Gary Davies
        Veteran Member
        Posts: 248
        Veteran Member

          Are you asking how to do it outside of Design Studio or within.  Depending on what your LDAP server is (Tivoli or ADAM) there are utilitiies each have for "dumping" data, not user friendly.  If you are just trying to get information for the user who is signed on, pretty much all the "my data" that use to be on the RD30 record are stored as variables on the portal page such as the web user id.  (if you do a servlet/Profile? you can see what you have access to).  If you are trying to get information on a different user that is more difficult.

          What are you trying to accomplish, there may be an alternative solution.

          Gary Davies

          www.automated-workflow.com

          Paul Gallucci
          Basic Member
          Posts: 15
          Basic Member

            An example would be accessing this data in a crystal report.

            John Henley
            Posts: 3353
              I don't think Crystal can access Tivoli Directory server; it can access AD as a data source but it's pretty limited, and I don't know if you can access ADAM data. I would pursue on of these options:
              1) using PF Integrator with a scheduled flow that generates a database table on a scheduled basis, and use that as a data source (more on that next month in LawsonGuru Letter)
              2) there is a tool out there called a JDBC/LDAP bridge that would allow you to query LDAP via JDBC (which is supported by Crystal). I've not tried it, so I don't know if it works well or not.
              3) depending on what your requirements are, if you're familiar with Visual Studio, you can code up the LDAP queries that you need and dynamically populate a data source bound to a Crystal Report.
              Thanks for using the LawsonGuru.com forums!
              John
              Ben Coonfield
              Veteran Member
              Posts: 146
              Veteran Member
                To get certain data out of Tivoli Directory Server I am using the ldapsearch command in one of my scripts. It's not particularly convenient or easy to use, but it works without requiring me to install any additional tools.