Custom tables in H2 or external database

Hi All, I have to build a reporting functionality in camunda, the data for which has to be stored in a custom table created specifically for those report. If there a way we can create custom tables in camunda H2 database and interact with it using insert/update/select statements. If it’s not possible how can we connect camunda application to external database?