Servicenow – encrypt a field using encryption context

I wanted to encrypt a field by using encryption context and de-encrypt it. Below are the setups and scripts to test it. I am using 'admin' rights. UI Macro: Plugin: At Table structure: At the form, I can view field (cipher) as string, showing encryption context table sys_id. This can update and sys_id over there. …

Continue reading Servicenow – encrypt a field using encryption context

Sending email through store procedure

Database email setup Double click 'Databse Mail' to start setup Create mail configuration select as below key in the profile name and click 'Add' key in email address and the server ip address add the SMTP email address and server ip address click 'Next' click 'Finish'   Store Procedure Parse in the profile to be …

Continue reading Sending email through store procedure

Selecting data from MySql in MSSQL

Setup Link Server right click to add new linked server. Fill in all the appropriate details accordingly. Follow the database name in mysql to be use as data source over here. Provider string: DRIVER={MySQL ODBC 5.3 ANSI Driver};SERVER=ip address;PORT=port number;DATABASE=mt4_demo;USER=username;PASSWORD=password;Option=3 test connection and save it.   after setup To query the data from the table …

Continue reading Selecting data from MySql in MSSQL