Home Java Transformations Generating Base64 with given code page

Generating Base64 with given code page Featured

Written by 
Rate this item
(0 votes)

It is common to use the shell command redirection in PowerCenter. The feature allows one to use the ldapmodify command to load data to LDAP. To achieve this it is necessary to create an LDIF flat file. Some data in the file must be in UTF-8 code page and Base64 encoded.

This can be achieved only with Data Movement set to ASCII. In Unicode Data Movement the built in Enc_base64 function encodes the string to be Base64, but the string is always in the Unicode code page. For Windows it is the UTF-16LE code page.

With this in mind, Java Transformations EncBase64eX and DecBase64eX were developed. Java is just used for code page conversion. Built-in PowerCenter functions are used for Base64 encoding and decoding.

Manual download

Whole solution with Java Transformations and sample Workflows:

Read 5143 times