I am wondering, how long does the FNMS-SAP staging database remains the collected SAP data? Is this configurable? It is an staging database so I would expect the data being removed after importing into FNMS tables.
Secondly how long does the collected SAP data then remains in FNMS and how can that be maintained?
Thanks and Regards
Sep 13, 2022 01:54 AM
I think the data remains in staging database in /LICMAN/* tables. Currently there is no utility to remove the data periodically from FNM-SAP Admin Module.
SAP data is loaded in SQL db on FNMS batch server and that data is being used when you use FNMS to maintain your licenses.
Sep 21, 2022 03:06 PM - edited Sep 21, 2022 03:11 PM
Thanks for your reply. That is weird than as the staging db would only grow over time, neither would it be an "staging db" in my opinion.
Thanks, I am aware of the data flow. What I mean is how long does it remain in FNMS db? Or is that also endless.
Sep 22, 2022 12:33 PM
If user related data grows, the staging db and FNMS db will also grow. Data will remain as long as the company uses FNMS.
Sep 22, 2022 01:02 PM