We are currently using the denodo stored procedure viewdependencies() to obtain the dependencies of a view.
However, our requirement is to obtain the list of views from database A, having direct dependencies in database B.
By "Direct" dependencies, I mean views that are not private, and only the "first level" of dependencies.
For example, let's say I have 3 base views *db1.bv1*, *db2.bv2* and *db2.bv3*. Each of them have a derived view in db3 : db3.dv1, db3.dv2, db3.dv3.
And in another database db4, I join them together : db4.finalview.
I want to obtain only the list of direct dependencies from all the views in db4, where I would find db3.dv1, db3.dv2 and db3.dv3 (but nothing from db1 and db2).
Any idea how to achieve that?