Shibirg.41784 (Customer) asked a question.
Hi Team,
Need your suggestions here.
We have integrated okta with AWS Redshift application...Okta is integrated with AD( All user profiles are from AD)...Problem is username, first name, lastname and email addresses are in UPPER CASE.
I Changed in - Configure profile mapping to toLowerCase(string)....but still okta is sending UPPER CASE STRING TO AWS REDSHIFT......AWS Redshift is not accepting UPPER CASE STRING for dbusername...
Kinldy suggest on this....
Application : AWS-REDSHIFT
ERROR:
[Amazon](500356) Error retrieving IAM credentials. "DbUser parameter must be lowercase, begin with a letter, contain only alphanumeric characters, underscore ('_'), plus sign ('+'), dot ('.'), at ('@'), or hyphen ('-'), and be less than 128 characters. (Service: AmazonRedshift; Status Code: 400; Error Code: InvalidParameterValue;
Regards,
Shibir G R
Shibir,
Just to confirm, I hope you used String.toLowerCase(string).
Does Okta show the case update correctly in the Preview tab?
Hi Priti,
Thanks a lot for the reply.
Yes both String.toLowerCase(string). and toLowerCase(string)
Yes it is showing in the preview, i can see that it converted UPPER CASE TO LOWER CASE.
But data which is being sent to AWS REDSHIFT is UPPERCASE ( For Dbuser name is again upper case ).
Not sure what exactly i am missing ( even though mapping is changed not sure why it is sending again in upper case ).
Kindly guide me.
Regards,
Shibir G R
I have used this expression in many apps and it works perfectly fine.
Never seen any issues. Just to be very sure, I am hoping you saved and applied the mappings after previewing.
Other checks that can be done:
-Go to the user's profile -> Applications and check if the case looks correct there.
-Have you done a trace with a SAML tracer and checked what's getting actually passed.
If all this is already done and looks good, there may be some issue with the Prebuilt AWS REDSHIFT app.
Open a case to check further.
Hi Priti,
Good Day!
Thank you for your suggestion:)
I found the issue, if i do profile mapping from application it is not happening.
I did mapping in AD i am able to convert from UPPER Case to LOWER Case and Application is picking as well.
I am wondering why it is not picking from Application Profile Mapping...passing dbuser data like this...DB User Format (Redshift)
${user.email}.
Kindly suggest.
Thank you once again 🙂
Regards,
Shibir G R