Metadata Visualization and Discovery for SAP BW
Safyr® for SAP BW Metadata Visualization and Discovery – powerful exploration software to access, understand and exploit your metadata.
Safyr® for SAP BW is a powerful metadata visualization and exploration technology product that your data analysts and data scientists can use to gain insight into and exploit the data architecture in your own customized SAP BW systems. This is a critical task for accelerating effective delivery of a wide range of information led projects. You utilise it to speed up the source data discovery process for many projects such as data catalog, data governance, data warehouse, data analytics, master data, data integration, data migration and more.
Safyr can make metadata available from a range of BW versions, both BW ‘Classic’, BW on HANA and BW/4HANA.
You can use Safyr for SAP BW to find and understand the data structures representing a range of BW ‘objects’ .
|BW Objects extracted by Safyr||SAP BW Classic||SAP BW on HANA||SAP BW/4HANA|
|InfoCubes (& Multiproviders)||Yes||Yes||Not applicable|
|OpenODS Views||Not applicable||Yes||Yes|
|HANA Composite Providers||Not applicable||Yes||Yes|
You can identify the internal lineage between SAP Objects such as BW Queries and InfoCubes. These can be shared with other tools and technologies. Or, you can visualize the InfoCubes as Star Schemas or Snowflake models.
Safyr is particularly useful when you have added a significant number of your own Cubes to the standard content delivered by SAP and has a need to explain the capabilities of the available cubes to a wider corporate audience.
Where the BW system is undergoing rapid change, Safyr’s comparison feature helps to quickly identify the scope and nature of those changes, either between different versions of the same system or between different BW instances.
Whether you are looking for specific objects in SAP BW or trying to populate your enterprise data catalog solutions with thousands of objects, Safyr for SAP BW will be of value to you.
Customers use Safyr to solve the 3 challenges associated with SAP BW Metadata Discovery.
Discovery: Locating the source of the useful, business ready metadata in your applications. There is very little of any value in the data system catalog. The useful metadata is in a series of data dictionary tables in SAP.
Scoping and curation: Once the metadata has been located, the next challenge is to find the table or tables necessary for your task and save them for use in other tools and systems.
Delivery: The final hurdle is to provision the metadata into other tools and technical formats. These include data catalog and governance solutions such as Collibra, Informatica EDC, Alation, Infogix, ASG and Adaptive as well as data modeling tools such as SAP PowerDesigner, ER/Studio, erwin. Or you might want to use the information in Excel, CSV, XML or JSON formats.
Scroll down for more information on Safyr for SAP BW.
Safyr liberates accurate, understandable metadata from SAP BW systems and enables the discovery and curation of that metadata.
In addition to the ‘data at rest’ definitions of BW ‘objects’ like InfoCubes, ADSOs and Hana Composite Providers, Safyr shows the lineage between objects in a BW system. In the example screen opposite, a BW DataSource is shown with the hierarchy of other BW objects that consume the data from the DataSource. In this case, a Cube (0CCA_C20). This cube is in turn used by a MultiProvider (0CCA_M20) and that MultiProvider is used by four BW Queries.
And of course this lineage is a ‘two-way street’. For any BW Object, the ‘Based on’ tab will show the lineage flowing back to those objects that are the basis of the data.
But Safyr is not just a way to understand the complexities of metadata in a SAP BW system. The same level of information can be used to provision a range of Data Catalog and Governance tools.
Explore InfoProviders and how they relate to associated InfoObjects.
We can help with your Business Case for Safyr.
Safyr extracts detailed information on Characteristics from a BW instance and makes these available in the Safyr repository for exploration. See how Characteristics relate to other BW ‘objects’.
For more information on Safyr for SAP BW, please contact us, book a call or demo or get your free trial of Safyr.
See BW Queries and InfoProviders in the context of business areas like Sales & Distribution or Real Estate