Cloveretl queiries for data reading?

CloverDX Platform
1

Hello,

I am trying to get data from my local active drectory to oracle identity analytic(OIA) using etl process,but i have some errors.
can any one help me out how to get user from active directory to OIA using etl process with examples.

2

Dear praveen543,

can you please be more specific about issues you have? What components do you use?

3

Hello
i a quite new in clover etl,Actually my work is read the data from active directory to OIA using etl graf code.
it is execute successfully,but nothing will be display in output.
pls help me out if another method is there for using etl process.


<?xml version="1.0" encoding="UTF-8"?>
<Graph author="ldap" created="Mon Mar 03 16:42:44 CET 2008" guiVersion="2.8.0" id="1204560130853" licenseType="Evaluation evaluation" modified="Fri Nov 06 18:53:36 IST 2009" modifiedBy="ldapuser" name="Testing Simple Copy" revision="1.15">
<Global>
<Metadata id="InOutMetadata" previewAttachmentCharset="ISO-8859-1">
<Record fieldDelimiter=";" name="Employees" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\n" type="delimited">
<Field name="dn" type="string"/>
<Field name="cn" type="string"/>
<Field name="displayName" type="string"/>
<Field name="givenName" type="string"/>
<Field name="mail" type="string"/>
<Field name="o" type="string"/>
<Field name="ou" type="string"/>
<Field name="postalCode" type="string"/>
<Field name="sn" type="string"/>
<Field name="telephoneNumber" type="string"/>
<Field name="uid" type="string"/>
</Record>
</Metadata>
<Property fileURL="workspace.prm" id="GraphParameter0"/>
<Property fileURL="parameters.prm" id="ExternalizeGraphParametersActionId"/>
</Global>
<Phase number="0">
<Node enabled="enabled" guiHeight="25" guiName="BROADCAST" guiWidth="50" guiX="245" guiY="20" id="BROADCAST" type="SIMPLE_COPY"/>
<Node enabled="enabled" guiHeight="25" guiName="INPUT1" guiWidth="50" guiX="20" guiY="20" id="administrator" password="Password123" scope="subtree" type="LDAP_READER" user="GECOMFIN.COM">
<attr name="ldapUrl"><![CDATA[ldap://oreilly.com:389/]]></attr>
<attr name="filter"><![CDATA[uid=3643765,ou=People,o=ct.com,o=cp]]></attr>
<attr name="base"><![CDATA[o=cp]]></attr>
</Node>
<Node append="false" charset="UTF-8" enabled="enabled" fileURL="${DATAOUT_DIR}/ldapReader_Uninet" guiHeight="25" guiName="OUTPUT1" guiWidth="50" guiX="470" guiY="20" id="OUTPUT1" type="DATA_WRITER">
<attr name="DataPolicy"><![CDATA[controlled]]></attr>
</Node>
<Edge fromNode="BROADCAST:0" guiBendpoints="" id="INNEREDGE1" inPort="Port 0 (in)" metadata="InOutMetadata" outPort="Port 0 (out)" toNode="OUTPUT1:0"/>
<Edge fromNode="INPUT1:0" guiBendpoints="" id="INEDGE1" inPort="Port 0 (in)" metadata="InOutMetadata" outPort="Port 0 (out)" toNode="BROADCAST:0"/>
</Phase>
</Graph>
4

Dear praveen543,

Components selection you use is correct. Please use http://doc.cloveretl.com/documentation/ … edges.html to find out which component is the problematic one (=not producing outputs). My guess is that LDAP_READER does not read anything. Isn’t anything helpful in log? Does graph finish properly?

For checking parameters you used in LDAP_READER please use http://jxplorer.org/

Regarding LDAP_READER - I think proper setting will be:

Base DN = “ou=People,o=ct.com,o=cp”
Filter = “uid=3643765”