ArcGIS Velocity: New Feed - AGOL "feature layer could not be reached" (Secure Stand Alone Server Item)

[Teresa_Blader]

Trying to create a new feed from a secured service but getting an error. Something is stopping ArcGIS Velocity from accessing this layer in AGOL. 

Here is what I did:

1. I published SQL database layer to our ArcGIS Server (via Pro)
   1. https://servername.domain/administrator/admin/ 
   2. The database is registered to the Server.
   3. Published to Server Folder, with "Private, available only to selected users" selected.
      1. I am apart of the role selected (DOMAIN/A)
   4. Map and Feature Services
2. I add FeatureServer URL as item in AGOL.
   1. https://servername.domain/administrator/rest/services/..../FeatureServer/0
      1. REST vs SOAP?
   2. I am NOT prompted to add or store credentials
   3. There is NOT a "recognized as a secure service" message.
3. I am able to open in AGOL and view it in a map.
   1. I am prompted for DOMAIN/A credentials
   2. I get a message in Map Viewer Classic that arcgis.com cannot access so editing is disabled 
4. I move to ArcGIS Velocity > create a New Feed
   1. I find the item in the ArcGIS Online content list
   2. Click Next
   3. Error: The portal item ID [...] provided for feature layer could not be reached. Please ensure this item still exists and that your user account has access to it.

1. ArcGIS Velocity can connect to my other AGOL items from non-secured ArcGIS Server folders
2. ArcGIS Velocity can NOT connect to other AGOL items from secured ArcGIS Server folder
3. I am in a publisher role in ArcGIS Server Manager.
4. Our stand alone server is on the "Trusted Servers" list for our AGOL organization.
   1. https://gis.co.olmsted.mn.us/
      1. Do we need to add a trusted server URL for each web adaptor in AGOL?
5. ArcGIS Server is 10.7.1, as is the SQL database.
6. We use Windows Authentication Active Directory and SAML (IIS)

What am I missing to grant ArcGIS Velocity access to this item? Am I supposed to add custom parameters when adding as an item in AGOL? Is this even possible? Any other suggestions for connecting a feed to an SQL database (SDE)? 

Ultimate goal is to build a real-time analytic that runs any time a secure incident is added to a SQL database (may or may not be versioned, may or may not be on ArcGIS Server). 

Thank you!! Of course I'll submit a support ticket otherwise. 🙂 

[ArmstKP]

@Teresa_Blader We have been seeing this intermittent behavior for about three months now.  We have AGOL items that are secured services from a standalone ArcGIS Server.  Velocity isn't able to access the item/service.  I had first created a ticket/case# with the Velocity team.  It was determined that it was an AGOL issue, so now my ticket resided with that team.  

As well as AGOL items that are secured services from ArcGIS Server, we also have a few AGOL hosted feature layers that Velocity isn't able to access in AGOL, intermittently.

Here are the errors (many are the same as yours) we receive when ArcGIS Velocity can't access the AGOL items:

[Teresa_Blader]

Thanks for sharing your experience! That is insightful. 

[PeterNasuti]

@Teresa_Blader Thanks for posting this question. ArcGIS Velocity feature layer feeds and sources are able to connect to feature layer items stored in or referenced in ArcGIS Online, or unsecured services via URL.

In order to connect to secured feature layers, an item must be created in ArcGIS Online that references the service and stores credentials. I would suggest logging a support case to get assistance configuring ArcGIS Online items that store credentials to your services so that they can then be used by Velocity.

[JeffSilberberg]

Teresa, 

---

Ultimate goal is to build a real-time analytic that runs any time a secure incident is added to a SQL database (may or may not be versioned, may or may not be on ArcGIS Server). 

     You may have more success with your ultimate objective by putting a Trigger on your SQL database to
fire after an Add / Update action and have it POST to a Restful JSON transaction feed linked to your analytic(s). 

[Teresa_Blader]

Thank you!! I will explore that option!