Oracle Identity Analytics ETL Reference

This section includes reference information on the DelimitedDataReader, the DelimitedDataWriter, and the ExcelDataReader.

DelimitedDataReader and DelimitedDataWriter

CloverETL already has a .csv reader, but using the Oracle Identity Analytics version is recommended. If different delimiters are in use, however, use the CloverETL version.

Provide the file URL for the DelimitedDataReader.

<Node id="INPUT" type="com.vaau.rbacx.etl.clover.components.DelimitedDataReader"
fileURL="${inputFile}"/>

Provide the file URL for the DelimitedDataWriter.

<Node id="OUTPUT" type=" com.vaau.rbacx.etl.clover.domain.DelimitedDataWriter"
fileURL="${outputFile}"/>

ExcelDataReader

This Oracle Identity Analytics node reads Excel files.

Attributes:

fileURL - This attribute is Mandatory.

Row_From - Number of the initial Row. (Optional, Default value = 1)

Row_To - Number of the final Row. (Optional, Default value= -1 (All))

Col_From - Number of the initial Column. (Optional, Default value = 1)

There is no Col_To because the reader uses the metadata to know how many columns it has to read.

<Node id="INPUT1" type="com.vaau.rbacx.etl.clover.components.ExcelDataReader"
fileURL="${inputFile}" Row_From="1" />