OBIEE 12c and OSM. MapViewer setup.

The previous post in the OSM/Spatial series was finished on a simple map of Germany. And it's time to use this map in OBIEE. This post describes how to setup the MapViewer, and the next one how to tweak the map and setup OBIEE.

So, let's start. Login to the MapViewer Administration console. The address is http://yourhost:9502/mapviewer (9502 - default port).

The first thing we need to configure is a connection to a database which stores a spatial data. It is done by editing MapViewer config file. Select the Configuration tab and then Mapviewer.

Locate the Predefined Data Sources section. There is a template for a connection in the config file. It is commnted out by default.

You may either uncomment this template or copy and paste it and then edit. Most of the properties are self-explanatory. There are only two tricks. The first one is a password. You write it in clear text with an exclamation mark in front of it.

And the second one is for connection to a pluggable database, you write service name to the jdbc_sid property with two slashes in front.

After save and restart password is encripted.

Next edit needed to avoid warning message:

[] [host:] [nwaddr:] [tid: 125] [userId: ] [ecid: d2470e35-47d8-4eaf-a590-df9b77884e8c-000017c5,0] [APP: mapviewer] [partition-name: DOMAIN] [tenant-name: GLOBAL] Data server streaming request validation error. Root cause: MAPVIEWER-07001: MapViewer server does not allow streaming access. Contact server administrator to check MapViewer configuration file.
(Doc: Oracle® Fusion Middleware Error Messages). MapViewer won't show data layers without correct setup of this section.

Just like the previous section, copy and past it and make changes. The datasourcename property is exactly the same which was defined earlier.

Save config file and restart MapViewer. Navigate to Admin/Data sources tab. You should see new datasource listed here. In case you need to make some chnges, edit confguration file again.

Now I need to create a tile layer. The tile layer is a base map, something that is used to show data layers ontop of it. It is created by navigating to Admin/Create tile layer

The first step is a tile layer type. My tile layer type is "internal" (stored in a local database).

Next step is where most of the properties are defined. First three are self explanatory, and the most interesting is a "Template". I've created two tile layers to demonstrate the difference. My first layer uses WGS84 template (OpenStreetMap uses the WGS 84 coordinate system).

And the second one uses Mercator template.

I can see both of my tile layers on Admin/Manage tile layers tab. To view how a map looks like, I select it and press the View map/Manage tiles button.

Here you can see the difference. Mercator template looks more familiar, but for some countries WGS84 can give more convenient map. It's up to you to decide which one you like more. The good news is you may have both and make a decision based on a particular report needs.

Technically all is done. MapViewer setup is finised. But in fact one thing should be done yet. OpenStreetMap license requires that you use the credit “© OpenStreetMap contributors”. To add an attribution select a layer and hit Edit/View details button.

Fill in a Copyright text with “© OpenStreetMap contributors” string and press Submit button. Don't forget to attribute all layers.

Now MapViewer setup is done. It's time to configure OBIEE.

maps mapviewer OSM obiee obiee 12c

Andrew Fomin Profile Picture
Andrew Fomin

OBIEE specialist since 2007 and Oracle Discoverer before. DWH architect, BI enthusiast, blogger. Lazy cats owner. All opinions are my own and not the views of my employer.

Additional Posts
Share This Post
Twitter Google+ Pinterest Facebook
comments powered by HyperComments