Efficient Application Management of JD Edwards with Tableau

JD Edwards is one of the most important systems within your organization. It forms the backbone of your business processes and is essential for the continuity and efficiency of your company. This requires careful monitoring to ensure everything continues to function as expected and security remains intact. JD Edwards contains a wealth of valuable data, but making this data clear and understandable can often be challenging. Tableau offers a powerful solution for this.

In this blog, we will discuss how Tableau can assist you with some key aspects of managing JD Edwards.

Submitted Jobs

Processing large amounts of data requires clarity and insight. Many organizations have questions such as:

• How do these processes perform during peak times, such as at the end of the month?
• How much time passes between submitting and executing a job?
• Where are bottlenecks occurring, such as queue buildups?
• Which processes are slowing down over time?

Although the answers are often stored in the database, this information is not easily accessible. Tableau helps make this data visible and provides valuable tools for process analysis.

Here is an example of a Tableau dashboard that provides insights into job processing performance.

• Data from JD Edwards is prepared and made available using Tableau Prep.
• Tableau dashboards allow you to see how jobs are processed, where delays occur, and how performance trends evolve over time.
• Filters enable you to examine specific processes or time periods.
• Graphs display trends, such as peak moments or changes in processing times.
• With these insights, you can resolve bottlenecks and improve efficiency.

1. These attributes allow us to derive various metrics.
2. We can create an analysis using filters based on these attributes.
3. We can generate visualizations that display metrics per dimension.
4. With Tableau, business analysts can easily create insightful reports.

Met Tableau wordt het voor een bedrijfsanalist eenvoudig om een goede rapportage te maken.

Object Management Workbench

BiWhen organizations undergo change, we often see that, despite JD Edwards being a highly comprehensive system, there is still a need for customization or extensions. Managing these modifications is done through the Object Management Workbench.

Common questions regarding this topic include:

• How many projects are there?
• How many modifications or components are associated with them?
• What is the status of the projects?
• How long does it take:
  • To initiate a modification?
  • To develop a modification?
  • To test a modification?
  • From request to production?

Although your database contains the answers to these questions, extracting this information from the standard application can be challenging.

We use Tableau Prep to unlock this data from the database.

With this data, we can create an Object Management Dashboard.

1. 1. Filters allow us to refine the data by specific projects, statuses, systems, and users.
   2. Clear summary figures provide immediate insight into key data points.
   3. Selecting a project status instantly shows the related projects.
   4. When selecting a project, you get an overview of its components and the people working on them.
   5. Object details are displayed clearly.
   6. You can calculate how long a project has been in a certain status or environment, helping you better understand lead times.

The characteristics of the data are displayed in an organized way, making it easier to derive valuable insights. These insights can then be visualized in a clear Object Management Dashboard.

With Tableau, you can consolidate data from JD Edwards into a single, easy-to-read dashboard that provides the insights you need at a glance.

User Activities

Everything users do in JD Edwards can be recorded. With this data, Tableau makes it easy to answer questions such as:

• What actions are my users performing in the system?
• Who logs in the most frequently?
• Who stays logged in the longest?
• When do users log in and out?
• Who has modified security settings?

Access Management

JD Edwards offers extensive capabilities for managing user rights and access settings. However, due to the many options—such as user groups, roles, and user-defined settings (e.g., custom pages or saved searches)—it can become complex to determine who has access to what. Tableau helps you quickly gain an overview and answers questions such as:

Who has access to specific information?

Which roles are linked to specific environments?

How are users assigned to roles?

Conclusion

With Tableau, managing JD Edwards becomes a clear and transparent process. Whether it involves user activities, access management, or other aspects, Tableau helps you quickly obtain the information you need. This is a powerful tool to better understand your organization and optimize your processes. Let this be the first step toward more valuable insights!