This content has been marked as final. Show 4 replies
Download any OOTB Trusted recon connector ie. like ORCL_EBS_ER_126.96.36.199.0 and explore it. This will give you the better understanding.
Only change here... It will read from DB instead of Flat file.Use noraml java file handling method or CsvReader utility for reading from flat file.
While developing connector more focus should be on flexibility and that can provide using configuration lookup .
While developing Flat file connector, you can consider below
1. Lookup for column name
2. Lookup for order- column order in flat file( this will provide you flexibility to have file's column in any order. and that will be control by this lookup
3. Lookup for column validation- you can provide colum_name and type of data. So the user will configure what are the columns required validation