Data Exchange between OnBase and Esri

[Ami_Gandhi]

What specific data is exchanged between OnBase and Esri (and in what format) if utilizing the OnBase Widget with Esri's WebApp Builder?  Thanks.

[Jess_Vorobel]

Hi Ami! 

Thanks for reaching out on Community. 

The OnBase Widget for Esri's Web AppBuilder exposes what we refer to as "Feature Based Retrieval". The widget exposes a set of selection tools that can interact with features of any geometry on the map. When one or more features is selected, the attribute data of those feature(s) is used in a query against OnBase document types and a retrieval will occur based on those selected features. 

The relationship between OnBase  and Esri is based on a mapping of OnBase Document types (As Built Documents, for example) to Esri feature layers (Parcels, for example). Then, an OnBase keyword (Parcel ID) is mapped to an Esri attribute (Parcel_ID). 

In this scenario, when a Parcel feature is selected, the OnBase widget parses out the Parcel_ID Esri attribute value and then uses it as the Parcel ID OnBase Keyword value to query against the mapped document type(s), As Built Documents. Any As Built document type with a Parcel ID value that matches the Parcel_ID value of the feature selected will be returned. 

Let me know if you need more detail than that.

Thanks!

Jessica Vorobel, Product Owner

[Ami_Gandhi]

Hi, Jessica - Thanks much for those helpful details!  Yes, do have a couple follow-up questions, more so from a security perspective.  Hope to follow-up soon.  Thanks again!

[Ami_Gandhi]

Hi Jessica, thanks again for your response.  Could someone please assist with the following questions?

• the attribute data of those feature(s) is used in a query against OnBase document types
• a) Is attribute data passed as parameter values? Does GISWebAPI SOAP* service accept those as URL parameters?
• b) Is this query path for attribute data correct: Passed by the OnBase Widget to the OnBase GIS Service (GISWebAPI) which then relays it to the app. server? Does the app. SOAP service (asmx) accept those as URL parameters?
•  
• and a retrieval will occur based on those selected features
• c) Does the app. server return the results for display by the OnBase Widget via the OnBase GIS Service (GISWebAPI)? Is the data returned in a JSON format? 
• d) How does the (OnBase) document display itself occur?

* Per MRG: Under Communication Method, select Remoting if the OnBase GIS Service and the Application Server are hosted on the same machine. If the OnBase GIS Service and Application Server are hosted on different machines, select SOAP.

The latter applies to us, so we will be selecting SOAP.  Our Application Service does not have TLS enabled, and the OnBase GIS Service will be hosted on a server on the DMZ.  Is it correct that we would need to open up port 80 in the firewall?

Thanks!

[Thomas_Reu]

Another option is public access.  Then from the map you just click on the geometry feature and it will kick off the public access url - returning the appropriate pdf.  You just have to keep the data in sync between the GIS system and onbase.  To help with this, we use external autofill from the GIS system into OnBase.  This also means we don't have to worry about versioning between the systems, since this is a simple URL call.  For example: if you have an as-built line feature, it could work like this:

https://pimamaps.pima.gov/Html5Viewer/index.html?configBase=https://pimamaps.pima.gov/Geocortex/Esse...

1. Show the layer list
2. Open the Development Layer
3. Turn on: Construction Plans - Pima County DOT
4. Zoom in and click on a line feature
5. Note: there can be overlaps see the upper-right corner of the popup for something like 1 of 4
5a. You can use the arrows to switch to the other plans
6. Click on the Document link when you have what you want
7. Voila - note: if the plan is big you may have to wait a bit and even download