We want to get reports from the data from appian created tables .Can we get the hibernate configuration file location on the server

Appian does not recommend reading directly from the primary database. I have seen many posts here about this topic. Searching may give you some good ideas.
If you can't get what your looking from from the logs (via plugins), I would recommend replicating the db to another schema or creating views so that you are not directly accessing the tables that are being written to and updated by the core platform.

We intent to use the mapping to correlate the CDT names with columns names

Are you aware of the location of the file