Oracle JD Edwards is the most important software system in your organization. It is therefore a critical application that is vital to the continuity and performance of your business. This requires constant and proactive monitoring by the IT department to ensure that the system always runs smoothly within your company’s security policy. The business data you want to analyze are fixed in JD Edwards. Unfortunately, it is not easy to get the correct data from JD Edwards clearly displayed. Tableau is the tool for system and application management in JD Edwards.
In this blog, we look at the following main aspects of system and application management and how we deal with them using Tableau.
Typical questions about batch processes:
Because the applications in JD Edwards cannot easily answer the questions above, batch monitoring is a challenging task. Nevertheless, the data for this is already in your database. Let’s see how we can use this data.
We use a Tableau Prep flow to make the data available in our Tableau Server.
We can then use it to create a dashboard in Tableau.
This is an example of a dashboard in Tableau that provides insight in the performance of the batch processes.
The available building blocks come directly from the tables.
Tableau makes it easy for a business analyst to create a good report.
Although JD Edwards is a very complete ERP system we often see that our customers need customization or extensions of the software. This change management is handled in the Object Management Workbench.
Typical questions regarding Object Management Workbench are:
Although your database has the answers to these questions, it is a challenge to get them out of the standard application.
We use Tableau Prep to access the data from the database.
With this data we can create an Object Management Dashboard.
The building blocks for the dashboards are also available for Object Management to make a meaningful analysis.
As you can see, Tableau allows you to combine data from JD Edwards into one clear Object Management Dashboard.
Everything a user does in JD Edwards can be registered. With this data in the database, Tableau can answer questions such as:
The JD Edwards Security Workbench is a very flexible and therefore extensive application. With the application you can control all kinds of security settings and permissions for users, groups, roles, applications, etc. With objects that the user defines himself, such as E1Pages, saved searches and much more, this becomes even more diverse. As a result, it is not always easy to determine who has access to what. Tableau can help you quickly understand this. Because of this, Tableau answers a number of important questions.
Who has access to which object?
Which role has access to which environment?
Which users are related to which roles?
With these examples, we hope to have inspired you to turn JD Edwards System and Application Management from a black box into a clear process, using Tableau’s powerful business intelligence. Let this be the beginning to help you create many more meaningful insights.
Rick is a Senior BI Consultant at Cadran Analytics. He spends his time on Tableau and Oracle BI.