SAP staging database data retention
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
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.
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.
If user related data grows, the staging db and FNMS db will also grow. Data will remain as long as the company uses FNMS.