Before You Begin

This 10-minute tutorial shows you how to add spatial data, available in your Oracle Database Cloud Service instance, as map data sources in your Oracle Analytics instance.

Background

You can add map data sources, such as background maps and map layers, by using Oracle MapViewer Administration Console 12c that is included with Oracle Analytics.

This tutorial uses the HERE Sample for Oracle Analytics available on Oracle Technology Network as an example map data source.

What Do You Need?

• HERE Sample Data for Oracle Analytics (12c DataPump export) deployed in your Oracle Database Cloud Service
• Connection details of the OA_HERE_Maps schema available in Oracle Database Cloud Service
• Access to Oracle MapViewer Administration Console 12c
• Access to Oracle Analytics

Add a Data Source

The configuration of the Oracle MapViewer Data Server determines how the data in each data source is streamed.

1. Sign in to Oracle MapViewer Administration Console 12c with your administrator credentials. Use a URL similar to https://<analytics-hostname>/mapviewer/.
2. On the Oracle MapViewer Administration Console 12c Home page, click the Configuration tab.
3. On the Oracle MapViewer Config page, scroll to the Predefined Data Sources section, and add an entry for the OA_HERE_Sample map data source. Use the connection details of the OA_HERE_Maps schema available in Oracle Database Cloud Service.

   In the map_data_source element, be sure to precede the jdbc_sid attribute with two forward slashes (//) and the jdbc_password attribute with an exclamation point (!). Your code should look similar to map-data-source-code.txt.

4. On the Oracle MapViewer Config page, scroll to the Map Data Server configs section. In the data_source element, enter "OA_HERE_Sample" in the name attribute.

   <data_source name="OA_HERE_Sample"/>
      <allow_predefined_themes>true</allow_predefined_themes>
      <allow_dynamic_themes>true</allow_dynamic_themes>  
   </data_source>

5. Click Save, and then click OK.
6. Click Restart. Click Continue to confirm the restart, and then click OK.

View the Map Data Source

1. On the Oracle MapViewer Home page, click the Admin tab.
2. In the Data sources table, verify that the OA_HERE_Sample data source is listed.
3. Click the Manage tile layers tab, and verify that the map tile layers from the OA_HERE_Sample map data source are listed in the Existing map tile layers table. If the map tile layers from the OA_HERE_Sample map data source aren't visible immediately, then click Refresh. If the map data source still doesn't show up, then verify connectivity to Oracle Database Cloud Service.

Verify the Map Data Source

Use the Oracle Analytics instance that you previously used to access Oracle MapViewer Administration Console 12c.

1. Sign in to Oracle Analytics with your administrator credentials.
2. On the Home page, click Page Menu , and then select Open Classic Home.
3. On the Classic Home page, click Administration.
4. On the Administration page, click Manage Map Data under Map Data Management.
5. On the Manage Map Data page, click Import Layers on the Layers tab.
6. In the Import Layers dialog box, verify that OA_HERE_Sample is available in the Look in drop-down list.

   

Want to Learn More?

• Defining Permanent Map Data Sources
• Data Sources
• Manage Map Information for Analyses
• Create a Revenue by Brand Map