You can find this in Indian shops, sold partly dried as a sticky mass of broken pods with fibres and seeds. Macerated in hot water these produce a sour, dark brown juice. Used with sugar it gives a pleasant sweet and sour taste.
A commercial paste and tamarind balls are easier to use and a reasonably good substitute.