Icon View Thread

The following is the text of the current message along with any replies.
Messages 11 to 12 of 12 total
Thread Create a view in DB1 that uses data from a table in DB2??
Sat, Apr 10 2021 6:36 PMPermanent Link

Ian Branch

Avatar

The limitation is the report engine, it can only work with one database.
Sun, Apr 11 2021 2:06 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Ian


If it can work with a query you can have the query active within the database you want (ie set database in the component) and the sql can reference the external database. eg select * from dbiworkflow.customers and from my quick test you get a sensitive result set.

Roy Lambert
« Previous PagePage 2 of 2
Jump to Page:  1 2
Image