"in the report, i have to show info from both gateway and isoft database"

As I mentioned earlier, create two different Universes pointing to two different databases gateway and isoft. Then extract the tables in the Universe from the database you just pointed to. You just have to do it seperately for two universes since you can only have one connection per universe. Then from those tables create objects by pulling all the column/attributes you want. Export the two universe after you are done with creating them. Then go to the Infoview and pull whatever you want. If you want it from multiple Universes, then create another query and add the objects. Then you merge the two common objects, in your case it looks like origfilename and isoftfilename, which will then link the two queries. Then you can create a table using all the attributes from the first one, or second one or both.