OAC Analytics Maps can source metadata from ADW

Hui Wang-Oracle

OAC Mapviewer server can sources its map backgrounds, map layer metadata directly from tables in the ADW( Autonomous Data Warehouse) and then you can use map visualization in OAC Classic (Answers).

Below steps can be used to access ADW mapviewer data

1 Try to login OAC mapviewer administration console through similar URL below

"https://xxx-xxx-xx.analytics.ocp.oraclecloud.com/ui/mv/console/configuration.jsp"

2 Under "Configuration" -> "MapViewer", below section can be added for map data source

<map_data_source name="adb_url"

                 wallet_zip_file="xxxx"

         user="xxxx"         

         password="xxxxx"

         service="hwangpublicadw_low"

         number_of_mappers="5"

         allow_jdbc_theme_based_foi="false"

/>

Parameters:

map_data_source_name: it can be any name which you can easy identify source

wallet_zip_file: Currently it's not possible to use walletless ADW connection in mapviewer, so you can upload ADW wallet to object storage bucket and then "Create Pre-Authenticated Request" for wallet file and then use URL for this parameter

user: this user should be owner for all these mapviewer table and views

password: It should be encrypted by using "!" at the beginning, i.e password is "Welcome1" and then you can provide password as "!Welcome1" after save and restart, password will be encrypted

service: you can found it in the tnsnames.ora file and this file is obtained by unzipping the wallet zip file. and The tnsnames.ora file contains three service names, for example, <service_name>_high, <service_name>_medium, <service_name>_low. You can choose one of them according to your preference.

3, click Save and Restart, if it works ok, under Admin-> Data sources, you should be able to see your map_data_source name under name list

If any problem during the configuration, you can navigate to Admin - > View logs, based on the error message to correct it. or user can verify from mapviewer side directly to check metadata or connection info correct or not (map viewer console: " http://machine.domain:port/mapviewer" )