How to handle GUID/UUID or UID data type in SAP ESP?

[Former Member]

Hi All,

I am using SAP ESP 5.1 SP11. I am importing data from SQL using generic adapter, In my database in the table I have field with Uniquieidentifier/UUID/GUID datatype. So when I see data in ESP I see special characters and for humans they wont make any sense.

In the schema I only have string datatype available. I am not sure how to handle this issue. Can someone please help?

I have attached screenshot of what i see in output window.

Thanks in advance,

Happy

[Former Member · Accepted solution]

Hi Happy,

you can use cast function in input adepter.

select cast ( fielda as int) as field from tablea

Hope this helps