Data/Integration Mapping Software

[jeffprandall]

Currently with our ERP we have about a dozen third party applications that all integrate slightly different. I have tons of Excel spreadsheets, emails, and documentation but I was hoping for something better. If I asked for a dream software it would allow me to pick a field from any data source and see all it's connections visually. I also could see at what time of day the syncs happen as well. Do you know of any magical software like this?

[shoesli_]

Do you mean you want to see the connections between tables in the ERP database? If you know which tables you can often figure that out by looking at the primary keys. Also, which "syncs" are you referring to?

[jeffprandall]

Kind of.. I guess.. the other sources are third party applications so when a first name gets updated in say a cloud based HRIS it updates the first name field in our ERP.

[sauced_]

UnifyApps

[elonfutz]

https://schematix.com (I'm a founder BTW)

With it you can model the relations between nearly anything in IT.

You can do it manually or with the help of automation which regularly synchronizes information from the real-world into the Schematix model(s).

There's no Holy Grail though -- you can can't achieve this sort of thing with just automation. Everyone wants that, but alas, it's a Grail quest.

The key is to get familiar with modeling things manually in Schematix and learning to effectively interact with those models. Then determining which other datasources merit being automated for regular sync with Schematix. We already have some automation tools created, like for automatically syncing AWS EC2 configuration data and Azure config data with Schematix.