Who's On?

	Membership:
	Latest: Rich Cowie
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5255

	People Online:
	Visitors: 620
	Members: 0
	Total: 620

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1375
Roger French	1315
mark.cook	1244

Field Encryption

2 Replies

0 Subscribed to this topic

45 Subscribed to this forum

Sort:

Author

Messages

Sameera

Advanced Member Send Private Message

Posts: 30

2/18/2014 5:26 AM

Is there a way to enable/ disable encryption for a selected field in ITM. Also how can we read the fields like EMPLOYEEIDENTIFICATIONNUMBER from DB (looks like its encrypted) Thanks Sameera

Woozy

Veteran Member Send Private Message

Posts: 709

2/18/2014 4:03 PM

Hi Sameera - that field is encrypted, and I don't believe there is a way to disable encryption or to read it using SQL. The same is true of the EmployeeAlternateIdentificationNumber business class (DB table "EmpAltIdentNbr") There are basically two options that I have found - either use IPA to look up the values, or use the command line "dataexport" utility to dump the data as xml and then parse the values as required (which is a pain in the rear). You would need a good understanding of xml, xslt, and xsd, as well as the appropriate toolsets to make this work. Good Luck.

Sameera

Advanced Member Send Private Message

Posts: 30

2/20/2014 11:45 AM

Hi Kelly Thanks a lot for the support. Thanks Sameera