Problem: Making an Oracle connection in Insights for ArcGIS results in an error
Connecting Insights for ArcGIS to databases requires the portal's hosting server site to have relational data store types registered for use. For each supported database, a vendor file containing Java Database Connectivity (JDBC) drivers must be downloaded from the vendor site, and added to the uploads page from the server admin endpoint. When the drivers are uploaded, the data store type is registered. Restarting ArcGIS Server windows service is required to update the changes.
In some instances, after completing the steps mentioned above, a connection to Oracle still is not successful, and returns the following error:
Something went wrong.
This error indicates issues with the installation of the drivers as opposed to an incorrect connection property, which gives a more specific description of the error.
The following are possible causes for this issue:
The downloaded vendor file, Oracle Spatial and Graph (Spatial Java Class API) contains an additional file called, sdotype, which is no longer recommended to be included with Insights for ArcGIS.
In some instances, when registering relational data store types, in addition to restarting ArcGIS Server after uploading and registering the drivers, the Portal for ArcGIS service must also be restarted to ensure successful connection.