We need to perform some task through Oracle Integration Cloud (OIC) below is the detail:
[login to view URL] FTP Connection
[login to view URL] the files from FTP incoming folder, and archive the read file into Archive folder
[login to view URL] XSLT mapping and generate the CSV file as per spec
[login to view URL] the CSV file to either through SFTP or email.
[login to view URL] the CSV file in SFTP archive folder
[login to view URL] a connection to SQL server Data base.
[login to view URL] the logs into database table. Source file name, target file name, transmission date, status, error
8. Re transmission mechanism
[login to view URL] Alert for any exceptions or error during the process.
Hi I have a standard iar file which should work by making few modification for your requirements. I have experience in working with integrations with the same requirement as mentioned by you. Regards