Skip to Content
author's profile photo Former Member
Former Member

Schedule Integration w/o Adapter

I need to start a daily update by reading users from a group in active directory, then looking up those users in a SQL database. I think I have worked out the JAVA LDAP code to read the list of users. I plan to put that code in some form of UDF but I don't see how I can kick off this UDF unless I just set up some dummy file reader adapter etc. Am I wrong about how to do this, ie using a UDF for reading the users from AD? And, if I do put this code in a UDF, how will I kick it off once a day?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Jul 10, 2016 at 02:11 AM

    Hi Carlton!

    As one of the possible decisions you might consider developing standalone java application which queries LDAP data and send it to PI using one of java's ws client libraries. Then you can schedule it to run as desired using OS level functionality.

    Regards, Evgeniy.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 11, 2016 at 02:06 PM

    My client isn't expecting any other program to be used, it's not out of the question but I have a c# library I use in other integrations that can do the entire integration w/o PI. So, I really prefer not having to justify yet another piece of IT to do this. Thanks Raghuraman, the dummy file adapter idea was the only way I could think of doing this and is probably what I will use. Honestly, I'm very surprised there isn't an LDAP adapter with at least some basic functionality available. And, not being experienced in writing custom adapters I wasn't going to take that on.

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Carlton!

      In case of file adapter scenario you could use adapter module which reads the LDAP contents and builds xml document of desired structure. And your "dummy" file in Test mode (without deleting after processing) would act as marker for sender adapter to start processing in given time interval.

      Regards, Evgeniy.

  • author's profile photo Former Member
    Former Member
    Posted on Jul 22, 2016 at 05:12 PM

    I've used a file adapter to kick the first map off inside that map I have a UDF that reads AD for what I need. This seems to work though a little less than elegant.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.