Transparent materials can be easily found in the MTL file. It starts with a "d" letter followed by a number between 0 (fully transparent) and 1 (fully opaque).
If these lines seem correct and you can correctly reimport the OBJ+MTL files in Sweet Home 3D, it probably means that there's a bug in Octane or that it doesn't support this feature yet.