Saturday, December 29, 2012

Database configuration on OBIEE11G Mapviewer


Login to http://localhost:9704/mapviewer/   –>; Click on Manage Mapviewer and Configuration..

Here copy the entire config file and add the following entry just above  tag : </MapperConfig>
<map_data_source name=”MYMAP”
jdbc_host=”localhost”
jdbc_sid=”ORCL”
jdbc_port=”1522″
jdbc_user=”WORLDMAP”
jdbc_password=”!MYPASSWORD”
jdbc_mode=”thin”
number_of_mappers=”3″
allow_jdbc_theme_based_foi=”false”
/>
Note :
jdbc_password=”!MYPASSWORD” –>; here your database password should starts with the symbol “!”
Click on Save & Restart ..
Your entry should looks like below screen shot