Web URL based Tool Integration (Open in Tool)

EWP captures the metadata from numerous Business Intelligence (BI) and reporting tools and environments. One may then curate and govern this metadata. In this way, EWP often becomes a central BI Catalog for end-users who are interested in understanding what is available in the BI systems available, regardless of vendor or server. Direct integration between the BI environments and EWP is then critical to the success of such a metadata catalog.

Any object page (e.g. a Table column) offers a Related Reports tab listing any BI reports in any BI tool using that data through data flow lineage.

In particular, two major capabilities are explored:

• How to invoke the third-party BI tools directly from within EWP for reports harvested. This ability is detailed in managing metadata model.

• How to call back to EWP from those third-party BI tools for seamless use of the cataloging capabilities while user are looking at reports in the BI environment.

EWP provides a mechanism for opening harvested reports imported from business intelligence (BI) / reporting tools in the actual tool itself. Please see Open Reports in a Business Intelligence Tool.