Read CSV File from FTP server and insert data into On Premise Database using OIC

 First create connection

REST CSV GET INTEGRATION

POST-INSERT DATA INTEGRATION LOOKUP AND FOR LOOP

{

  "UserData" : [ {

    "id" : "",

    "FirstName" : "",

    "LastName" : "",

    "Department" : ""

  }, {

    "id" : "",

    "FirstName" : "",

    "LastName" : "",

    "Department" : ""

  } ]

}

INSERT INTO XX_EMP_JOB_DESCRIPTION( ID,FIRST_NAME,LAST_NAME,DESGINATION) VALUES (#ID,#FIRSTNAME,#LASTNAME,#DESGINATION)