From a high level, what are possible workflows for linking a separate information system to our GIS?
Here's our situation:
We have an enterprise GIS for modeling our outside plant that allows us to simulate a signal through our network via a geometric network. We also have what I think of as a business information system (BIS) for managing things like billing, customer care, and operations. These two systems are running off of separate databases, but each has data that would enhance the other.
*System - ArcGIS Enterprise 10.5.1 & SDE runs on SQL Server 2014*
I've seen some BIS software that integrates the GIS into its user interface, but I'm not sure what's running under the hood.
So the question stands - what are some workflows to link the two systems?
I don't know the specifics, but in the City I work for we have many systems linked to our Enterprise Geodatabase in one way or another. Some access the data right from the Enterprise Geodatabase (SDE), while others access the back side of the Enterprise Geodatabase (SQL Server) through Views.
Examples of these systems linked to GIS include: New World (for Computer Aided Dispatch), Cayenta (for billing), and Maximo (utilities).
To help folks respond to your question, can you provide some more details?
Chris Donohue, GISP
As mentioned in the previous replies, the two most common ways I've seen are to use an ETL process to transfer the data into a traditional ArcGIS geodatabase, or if the other systems have an API, then leverage that to pull data into ArcGIS. The Data Interopability Extension can help with the ETL process, and the ArcGIS API for python can help at the API level.