Can anybody give me some tips on what to look inside houdini to get this effect?


Thanks!
blackpixel
You could actually achieve both looks in a shader with a worley noise and some fitting. The second image looks like the holes are transparent / refractive.
But that won't help you with octane + c4d so you'd have to get your hands dirty with mantra