How can we accomplish following using SOA/BPEL without using Oracle Beehive or any other third paty tools.
1. Emails contain a .csv file with 5 columns.
2. There is a table in Oracle EBS database with 5 columns.
3. We need to have real time integration to import these .csv file from incoming emails into Oracle table from #2 above.
How can SOA/BPEL detach the .csv file from emails, parse .csv fields and import these files in Oracle table in real time manner?
- vba script in outlook for save .*csv files to some directory
- composite for pooling directory and insert data from parsed .*csv files
all by vba