Multiple datasource for report

I wanted to make a report but the data is stored in different databases, so is it possible to make report using multiple datasorces in HI. If yes, then how?
Thanks in advance

Yes, at the time of doing database connection please use “Inmemory datasource” option. With this you can connect to more than one datasource in order to do data analysis.