If filename is the only way you can determine if the data is unique and you want to do this validation in XI only then one approach can be this:
As the filenames after each processing of the file are not available in XI for validation, we will have to store them in a external table in XI which will only store the filename. you can use a synchronous RFC/Proxy to insert the filename into the table and at the same time write the logic in this RFC/Proxy to return the status if the file has already been processed and the name is present in the table. you will have to use a BPM and once you receive a msg then you can map it this RFC data type and then call this RFC receiver. based on the response of the RFC/Proxy you can decide whether you want to proceed further or not.
if you want to do it in the adapter module then you can create a separate table on the same database on which XI is installed and then use the normal java JDBC connection code to connect to the table and insert the filename and check if the name is already present.
If you are comfortable with java then the 2nd approach will be better according to me as you are avoiding the BPM as well as you are figuring out at the 1st step itself if the file has to be processed or not and you can avoid creating the other data types..etc. But then in the module error handling and monitoring might be a little difficult.
Cheer's
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.