I'm currently working on integrating data from an Oracle database (containing CLOB fields) with Salesforce using SnapLogic. The CLOB fields are causing difficulties in retrieving and processing the actual text content within SnapLogic pipelines.
Currently, the values for CLOB fields are being returned as object references rather than the actual data. I understand that this is due to the way CLOBs are handled, but I'm hoping to find a solution that allows me to access and work with the text within SnapLogic.
I'd greatly appreciate any guidance, suggestions, or best practices from the community on how to overcome this CLOB data integration challenge. If you have experience with similar scenarios, please share your insights on the best approach to take.
Thank you in advance for your help!
