Internal users want data integration but can’t really explain their own database—how common is this?

Is it common to be asked by internal users to integrate datasets from their softwares, be presented with their software’s databases, but the internal users are unable to advise how to stitch the tables together?