
Hello,
I have a customer in the healthcare business that would like to upgrade to GP 2018. Due to being healthcare, they have strict requirements with their IT to protect PII/Confidential information. One of the questions they have asked is if the program leaves behind any temp files, or external files that would have that information when you close the application. I know that GP will create C-tree temp tables in %temp%, and that they stay after you close the application. Do you have documentation on what is stored in those files, or can you confirm if there is no confidential information in them?
Regards,
Kayla
*This post is locked for comments
I have the same question (0)Yes, Dynamics GP uses SQL, C-Tree and Memory temp tables with the C-Tree being the most common.
SQL Server cleans their temp tables and Dynamics GP does clean most, but not all of its temp tables, so you're correct in that you'll need to periodically remove them as they can eventually start causing issues with the GP application.
GP temp tables all begin with the 'TNT' prefix and have a .dat, .tmp or .idx extension.
As far as I'm aware, there isn't any documentation as to what is held in these temp files, though there shouldn't be any confidential information in them.
Looking at my temp tables while Dynamics GP is open, even the TNT..........config file only has basic information similar to what the Dex.ini holds, no user names, or other information like that.
Personal data security has been a huge topic and while a lot of changes have been made and planned to improve handling of personal information, I never have heard the temp tables for GP having been mentioned at all as anything that is involved in data of this type.
Thanks