Hi @krishna_garikapati
Yes, It's Possible to Integrate WF with AEM.
Also, for storing metadata in AEM with a datatype of varchar when the source datatype in Workfront is Boolean, you would perform a data type conversion during the integration process.
When data is extracted from Workfront and passed to AEM, you would convert the Boolean data to a string/varchar. For example, true/false could be converted to "true"/"false" or any other relevant varchar value.
In AEM, a datatype conversion would typically be handled in your backend code. If you're using Java (JCR or Sling Model), you can simply use String.valueOf(boolean) to convert the boolean to a string. Remember, this would need to be done before saving the data into the AEM repository.
Thanks,
Venkat