Skip Navigation Links | |
Exit Print View | |
Oracle Identity Analytics Business Administrator's Guide 11g Release 1 |
1. Oracle Identity Analytics Identity Warehouse
2. Oracle Identity Analytics Importing
3. Oracle Identity Analytics ETL Process
Oracle Identity Analytics CloverETL Extensions
Load and Unload Data From the Database
How CloverETL Works With Databases
Mapping JDBC Data Types to Clover Types
Executing SQL/DML/DDL Statements against DB
CloverETL DataRecord Reference
How Data is Represented Within CloverETL
Specification of Record Format
Field Formats and Other Features
Specifying Default Values for Fields
4. Oracle Identity Analytics Data Correlation
5. Oracle Identity Analytics Role Engineering and Management
6. Oracle Identity Analytics Workflows
7. Oracle Identity Analytics Identity Certifications
8. Oracle Identity Analytics Identity Audit
9. Oracle Identity Analytics Reports
10. Oracle Identity Analytics Scheduling
11. Oracle Identity Analytics Configuration
This section includes reference information on the DelimitedDataReader, the DelimitedDataWriter, and the ExcelDataReader.
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}"/>
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" />