ERP Schema Visualizer +

“Is there a schema map of Epicor?” I think we have all asked this question at some point. The typical answer is no. It’s just too sprawling.

That is changing. I present my ERP Schema Visualizer.

Visualize tables and relationships. Find connections between multiple tables.

A few caveats:

  1. The connections to Company arent shown because if they did, it would just be a gazillion lines pointing to that table.
  2. Not all joins are shown - only the ones defined withing the Epicor framework are shown (think about the ones that auto connect on a BAQ).

I am considering hosting this on my website for general consumption if there is interest - and it doesnt make me go broke hosting it.

Apologies for the audio quality, you will either have to turn up your volume or turn on the closed captioning.

Update: Added to my website under Utilities.

32 Likes

Awesome work @Chris_Conn hopefully you can find a place to host it.

1 Like

That is pretty awesome!!!
Thanks for sharing!

1 Like

Thanks for doing this Chris! I’m interested in giving it a try

1 Like

That’s slick!!!

1 Like

It’s going to be a game changer, when you publish. Kudos to your good work it looks amazing. this will help all newbies and starters, no more Dataset relationship Tracker ( not functioning in Kinetic :yawning_face: )

3 Likes

You know I never really got my head around how that worked. Even in classic

1 Like

Woah! That is awesome🔥!!!

1 Like

I have added it to my website. It is under utilities.

Let me know if you run into issues as I hastily converted it to a React component to push it onto the website.

I suppose it will remain there, at least until I see the first scary AWS bill. :face_with_thermometer:

11 Likes

Pushed of few of my latest features in:

  • Dark Mode
  • Node spacing adjustment
  • Multiselect\Pathing
  • Layout strategy selection (swap to Euler, it’s pretty neat)
  • Allow resize of flyout
  • A few aesthetic tweaks

Some layouts work better than others, but it mainly depends on how you want to view the data. I’d like some feedback on how the rendering performs. There’s a lot of nodes and its pretty heavy - I can hear my GPU spin up on certain layout changes. I tend to prefer Euler and Cose-Bilkent.

Obviously you can also rearrange nodes but that seems like a lot of work (and I dont current have a way to save\load custom layout).

Control+Click allows multiselect. This will get the path between the selected nodes.

6 Likes

Thank you for creating this Chris! This is incredible.

1 Like

Does someone have a similar view for Epicor P21?

I can’t say with any certainty, but I would highly doubt it. I could be commissioned to do so at my hourly rate if it was worth it to anyone though. </end shameless plug>.

2 Likes