I'm performing sync from an MSSQL database into eDir using IDM3.

I'm trying to essentially perform a query to a lookup table for a
value.

For example, when a user record comes from MSSQL, I map a three
character identifier into the company attribute - say "ABC"

What I want to do is then do a lookup to a different database to get
the "full name" of the company - i.e. "select FULLNAME from
dbo.lookuptable where companyname = ABC"

I've also thought about syncing the company table to separate
"company" objects in eDir, so I'd query for an object instead of a
JDBC call.


Regardless, from what I've been able to figure out, I know I need to
do an input command transformation on the publisher channel, but I
can't figure out how to do a search for an LDAP object and retrieve
the full name attribute without messing up the user transaction that
is inflight.

I can't figure out how to do a JDBC lookup at all. There's a cursory
reference to it in the policy designer manual in the XSLT example, but
it assumes you already know what you are doing and doesn't actually
tell you how to do it.

can anyone help?

thanks

Eric