Capgemini Oracle Blog

Capgemini Oracle Blog

Expanding the Oracle Enterprise Repository with functional documentation

Categories : How-toService Offering


Have you ever experienced the challenge to map both your functional and technical assets in one software package? Finding a software package that is able to describe the metadata about these assets and their mutual relationships? And if you found the correct software package, was it maintainable?

The Oracle Enterprise Repository (OER) is a powerful SOA repository. Its core task is to map and visualize the interaction between technical assets generated by the SOA Suite and OSB. However, OER can be configured to not only contain these technical assets, but also to contain functional assets, i.e.: functional designs, use cases and a logical data model. Now that’s interesting! OER is able to show all the assets in your system and, if necessary, zoom in on one of the assets and their mutual relationships (Figure 1). This opens a set of doors to powerful features, e.g.:

  • Impact analsysis If a functional design is adjusted, which other functional designs and use cases do I need to adjust?
  • Traceability If a web service generates an error, in which functional and technical designs is the web service described
This sounds great, but how do we get all the functional and technical documents in OER, and how are we going to keep this repository up-to-date?

“Automate to the max”

In the figure below the steps to automate the loading of assets in OER is depicted.

The objective is to make the knowledge in the documents understandable for a machine. To achieve this, an XML layer is spread out over the functional documents (e.g. Microsoft Office documents).

In this figure you see an example of a Word document in which these layer of XML elements is shown. This is done by a standard add-on that comes with the Microsoft Office pack. The pink blocks are called tags and are based on a predefined XML schema.

The third step is to build a tool that retrieves the documents from the file repository Subversion, parse the XML elements and eventually update the Oracle Enterprise Repository.  A Java application is built to achieve this tasks. This application relies on two important API’s. On the one hand the API that enables one to connect to Subversion. On the other hand, the API that enables you to do CRUD actions on the Oracle Enterprise Repository.

The two API’s can be found at:


The Oracle Enterprise Repository is a powerful tool to map the metadata of both functional and technical assets. OER is able to do an impact analysis, can function as a traceability tool. Furthermore it saves time and reduce risks.

The proposed solution in this blog is to make the knowledge in functional documents interpretable by machines. Furthermore, you’ll need an application that reads out the file repository, e.g. Subversion, parses these knowledge in the documents and finally upload them to the Oracle Enterprise Repository.

If you want to have more information about this subject or if you are interested in a working demo, please do not hesitate to contact me.  In my next blog I will dive into the Java program and will show you in more detail how to work with these API’s.

Note:  special thanks goes to Sjoerd Aalbers for his valuable advice regarding this solution.

About the author

3 Comments Leave a comment
Hi Ares, I am studying about OER for implementing it in my project. So far I have learned harvesting the assets,some functionalities in console but I am not able to find out the overall functionality of it and what is the purpose of its use like unsubmitted,submitted, registered assets,design view etc. Can you please help me in understnading atleast one whole use case of Asset. If u have any documentation related to it, can u please share it with me. Thanks for your description in above blog and thanks in advance for your help.
1. What all are the assets that we can store in OER. 2. Can we store common xslt's file we can import this files in OSB in message flow. Thanks in advanse.
Hi, Can you please provide a complete use case of using OER? Can I create documents from OER registered assets? Thanks

Leave a comment

Your email address will not be published. Required fields are marked *.