Hi all, as part of our PCI policy we are planning to delete any aged credit card data from the Transcend database periodically. Does any of you have any SQL script to for this purpose that you can share? We could not find any built-in report in Transcend client to do this job. So before start digging into the Transcend database to write a new script thought I would first check if any of you have anything like this which we can use.
Advanced thanks for any help. Any suggestion, comment will be highly appreciated.
Mo
Thanks Chris for the info. We checked with the Intrix and they sent us the updated procedure. We will see how it goes.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Chris Jensen Sent: Thursday, September 15, 2011 10:16 AM To: Mohiuddin Faruqe Subject: Re: [Tessitura Technical Forum] Deleting Aged Credit Card Data from Transcend Database
There actually is a standard sproc for that in the TPAU database, named P_ARCHIVE_TPAU_DATA. I'd recommend checking in with Intrix support before using it. Despite the name, you archiving the data is optional, simply purging is possible.
Also, note that it can run while CC processing is up and running, but at the expense of speed, i.e. it runs very slowly. All after noon the first time we ran it!
From: Mohiuddin Faruqe <bounce-mohiuddinfaruqe8297@tessituranetwork.com> Sent: 9/15/2011 7:45:42 AM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!