Cloveretl queiries for data reading??

Support questions related to CloverETL Data Profiler, a data profiling application for the CloverETL family.

praveen543
Posts: 4
Joined: Wed Jul 18, 2012 7:20 am

Cloveretl queiries for data reading??

Postby praveen543 » Wed Jul 18, 2012 7:27 am

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.

kubosj
Posts: 372
Joined: Thu Jan 12, 2012 9:10 am

Re: Cloveretl queiries for data reading??

Postby kubosj » Wed Jul 18, 2012 8:53 am

Dear praveen543,

can you please be more specific about issues you have? What components do you use?
Jaroslav Kubos
CloverCARE Support
CloverETL | Rapid Data Integration

Visit us online at http://www.cloveretl.com

praveen543
Posts: 4
Joined: Wed Jul 18, 2012 7:20 am

Re: Cloveretl queiries for data reading??

Postby praveen543 » Wed Jul 18, 2012 12:46 pm

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.

Code: Select all

<?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>

kubosj
Posts: 372
Joined: Thu Jan 12, 2012 9:10 am

Re: Cloveretl queiries for data reading??

Postby kubosj » Thu Jul 19, 2012 1:16 pm

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"
Jaroslav Kubos
CloverCARE Support
CloverETL | Rapid Data Integration

Visit us online at http://www.cloveretl.com


cron