Qlik Replicate supports rich built-in transformations, and we also supportUser-defined transformationsto extend calling tailor-made user modules, the UDTF should be written in C.
After the UDTF is compiled and setup done, the transformation can be seen in "User Defined" functions list, it take effect for each row in the replication task.
Hope this helps.
John.
Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
What is the datatype that the RAW16 shows up as in Replicate and/or on the MS SQL target? BYTE(16)?
It's just a large binary number akin to int16 - but that datatype does not exist.
When you print one it is often represented as a HEX string of 32 bytes, which Replicate can transform using the HEX function.
CHAR22 on the other hand is a BASE64 encryption of the same resulting in just 22 printable characters needed. However, there is no function for that build into Replicate.
As long as the raw16 does not show up as a blob, it should be possible to create a private function for this and integrate this with Replicate as "User defined" function. There are examples for UDF's provided with the Replicate distribution, and using those I have made some of those in the past for other purposes. Still, this is not a trivial exercise and likely requires the help of Qlik Processional services or other consultancy services.
