How to get geometry data from external database dynamically

[EmrahAydemir]

Hi, i have a PostgreSQL database. Hundreds of geometry data are added to this database daily, independent of Arcgis. There is a geometry column with Postgis feature. Is there a way to dynamically pass the data here to Arcgis Server? I want to display the data (inserted from NodeJS server) in Arcgis Server Map Server.

Note: i added PostgreSQL Database to Arcgis Server as a data store .

[EmrahAydemir]

Unfortunately it didn't work. The steps in the link you posted are the same as I normally do. But every time new data is added I need to republish it via arcmap. I can connect to the database via arcmap. I have added the database manually before. I don't know how to connect it directly to the map server

[George_Thompson]

Another potential option would be to bulk publish from that datastore connection; https://enterprise.arcgis.com/en/portal/latest/use/bulk-publish-arcgis-server-feature-layers.htm

Now you must know that this may take a while and could crash the server machine depending on how many layers. It will create a map service and feature service (read-only but can be updated) for every layer in the database. This is the only way I could think of doing it without Pro, but you would not have some of the finer details for publishing.

[EmrahAydemir]

Just as I was about to go to sleep, this came to my mind: I am adding data to postgis database via nodejs. Is there a way to add layers to Arcgis Server via nodejs instead of trying to connect database directly to Arcgis Server? In this way, while adding a layer to the postgis server, it will also be added to the Arcgis Server.

[Scott_Tansley]

Cross-referencing to your other discussion for the solution.  https://community.esri.com/t5/arcgis-enterprise-questions/how-to-add-new-polygon-to-arcgis-server-fr...