All I need to do is move a Uniqueidentifier data element from Source to Target. NO translation is necessary. How do I do that?
What kind of error do you get?
Normally you would just need a Map Shape to get data from a source field to a destination field.
This is the error I get:
I have a map shape that defines the source and target fields but I still get the error above. The Id field in the map is the only field that is not a string. It’s a uniqueidentifier in source and target.
A unique identifier can be treated as character. Use a standard map to map source to target.
It is being treated as character…and I am using a standard map for the mapping.
Is the ID in the destination profile the same type as the source?
Is the ID in the destination profile an automatically created unique identifier by the destination data store?
Yes, the Id is a uniqueidentifier in both the source and target. No, it is not automatically created. It should simply be moved from source to target with no translation.
Looks to me like uniqueidentifier is a special type on destination that is not compatible with character. What database is it? You may need to use a conversion function in the SQL statement
The source and target are both SQLServer databases.
I haven't used SQL Server unique identifier in Boomi but I think you need to make the type binary. It's not char type
Ok, binary is a datatype not support by Boomi…
Which brings me back to my question at the title of this thread.
Try Blob .... that's a binary type ... if that doesn't work convert to char in query and convert back to uiniqueindentifier in insert
Just curious. If there are no data transforms and it's just SQL Server to SQL Server, why are you using Boomi vs SSIS, or linked databases and transact SQL? You're consuming two connectors without any benefit of using Boomi.
Retrieving data ...