Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Micros RES 4.0

Status
Not open for further replies.

sky1980

Technical User
Oct 10, 2006
16
US
We're running Micros RES version 3.2 today and starting to explore ver. 4.0.
We have written some custom SQL code which interacts directly with the Sybase database.
I understand that due to PCI standards the CC info is now encrypted, but are the other data tables and fields still clear?
Specifically, if we upgrade to ver. 4.0 will we still be able to use our SQL code outside of Micros? Can we still log into Sybase Central and read the data tables?
I assume this must be the case as Crystal is external to Micros and they need to read clear data as well.

Can someone with ver. 4.0 experience help me understand what specifically 4.0 did?
 
You will be able to use most of your SQL code. However, some of the syntax will have to be modified since it upgrade the version of ASA from 6.x to 9.x. I had to do the same thing for some of my clients when going through this same upgrade. Nothing huge... join vs. outer join type of modifications.

Data can still be viewed in Sybase Central. You can create read only users and dba level users as needed to stay in PCI compliance.

4.x upgrades give you the ability to be PCI compliant is the major change. It upgraded the components it uses (ASA, Crytsal, OS, among a few others). It also has the stronger encryption requirements you mentioned earlier. Any field that does NOT have credit card data will remain clear.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top