[GENERAL] data transformation and replication

Hi

Here it is a scenario which I am faced with  and I am hoping to find a pointer/tip/help

db1 is the OLTP system
db2 is the Reporting system

The data from db1 needs to get to db2, but the database on those two have tables with different layout/structure and
hencedata will need to suffer some transformation in between in real time 

I was looking at something like

db1 -> db2 replicates the same set of tables and with the same structures using pglogical for example
db2.tbl1 -> db2.tbl2 data gets massages/transformed based on what replicates from db1.tbl1 using triggers and functions


Other than that I reckon db1 -> db2 would be trigger based using something like slonik maybe (?) and data
massage/transformationgets moved from db2 to db1 machine and then db1.tbl2 -> db2.tbl2 using pglogical  


Is this doable ? If so any pointers as to where to look about it ?


Many thanks
Armand