Help required in making QV app SSO inside a Java web portal
Hi Experts,
I want help in setting SSO for Qlikview Application
I have qlikview application integrated to Java Web application
In this application i have created one tab as Qlikview Dashboard
I have just used hyperlink coding in java to call the qlikview application
Requirement:
When i login to my java application it ask for userid and password
I am using AD users in this application
When i navigate to Qlikview tab in this application it should not prompt me again for userid and password
At the same time it should apply row level security on Region field in my Qlikview Dashboard tab.
How do i achieve this
In stand alone qlikview application i have
Section Access
SECTION ACCESS; // Admins, users and their passwords and grants // The field for reduction is CONTINENT // All fields and values MUST be UPPERCASE // If you want ADMIN to see everythin, live blank the value under CONTINENT LOAD * INLINE [ ACCESS, USERID, PASSWORD, REGION ADMIN, ADMIN, ADMIN ADMIN,test2,$1234 ADMIN,test1,$123789 USER, EUROUSER, EUR, EME USER, AMERUSER, AME, AMERICA USER,ASIAUSER,Pass123,ASIA ];
SECTION APPLICATION; // Each user above has a correspondence in the CONTINENT field // So they will only see COUNTRY values corresponding to their value in CONTINENT Data:
LOAD * INLINE
[
REGION,COUNTRY
Africa, Algeria Africa, Angola Africa, Benin Africa, Botswana Africa, Burkina Faso Africa, Burundi Africa, Cameroon Africa, Cape Verde Africa, Central Africa,n Republic Africa, Chad Africa, Comoros Africa, Congo Africa, Cote d'Ivoire Africa, Democratic Republic of the Congo Africa, Djibouti Africa, Egypt Africa, Equatorial Guinea Africa, Eritrea Africa, Ethiopia Africa, Gabon Africa, Gambia Africa, Ghana Africa, Guinea Africa, Guinea-Bissau Africa, Kenya Africa, Lesotho Africa, Liberia Africa, Libya Africa, Madagascar Africa, Malawi Africa, Mali Africa, Mauritania Africa, Mauritius Africa, Morocco Africa, Mozambique Africa, Namibia Africa, Niger Africa, Nigeria Africa, Rwanda Africa, Sao Tome and Principe Africa, Senegal Africa, Seychelles Africa, Sierra Leone Africa, Somalia Africa, South Africa, Africa, South Sudan Africa, Sudan Africa, Swaziland Africa, Tanzania Africa, Togo Africa, Tunisia Africa, Uganda Africa, Zambia Africa, Zimbabwe AMERICA, Antigua and Barbuda AMERICA, Argentina AMERICA, Bahamas AMERICA, Barbados AMERICA, Belize AMERICA, Bolivia AMERICA, Brazil AMERICA, Canada AMERICA, Cayman Islands AMERICA, Chile AMERICA, Colombia AMERICA, Costa Rica AMERICA, Cuba AMERICA, Dominica AMERICA, Dominican Republic AMERICA, Ecuador AMERICA, El Salvador AMERICA, Grenada AMERICA, Guatemala AMERICA, Guyana AMERICA, Haiti AMERICA, Honduras AMERICA, Jamaica AMERICA, Mexico AMERICA, Nicaragua AMERICA, Panama AMERICA, Paraguay AMERICA, Peru AMERICA, Puerto Rico AMERICA, Saint Kitts and Nevis AMERICA, Saint Lucia AMERICA, Saint Vincent and the Grenadines AMERICA, Suriname AMERICA, Trinidad and Tobago AMERICA, Uruguay AMERICA, USA AMERICA, Venezuela ASIA, Australia ASIA, Bangladesh ASIA, Bhutan ASIA, Brunei Darussalam ASIA, Cambodia ASIA, China ASIA, Fiji ASIA, India ASIA, Indonesia ASIA, Japan ASIA, Kiribati ASIA, Laos ASIA, Malaysia ASIA, Maldives ASIA, Marshall Islands ASIA, Micronesia ASIA, Mongolia ASIA, Myanmar ASIA, Nauru ASIA, Nepal ASIA, New Zealand ASIA, North Korea ASIA, Other ASIA, Palau ASIA, Papua New Guinea ASIA, Philippines ASIA, Samoa ASIA, Singapore ASIA, Solomon Islands ASIA, South Korea ASIA, Sri Lanka ASIA, Taiwan ASIA, Thailand ASIA, Timor-Leste ASIA, Tonga ASIA, Tuvalu ASIA, Vanuatu ASIA, Viet Nam ASIA, Yemen EME, Afghanistan EME, Albania EME, Andorra EME, Armenia EME, Austria EME, Azerbaijan EME, Bahrain EME, Belarus EME, Belgium EME, Bosnia and Herzegovina EME, Bulgaria EME, Croatia EME, Cyprus EME, Czech Republic EME, Denmark EME, England EME, Estonia EME, Finland EME, France EME, Georgia EME, Germany EME, Gibraltar EME, Greece EME, Guernsey EME, Hungary EME, Iceland EME, Iran EME, Iraq EME, Ireland EME, Isle of Man EME, Israel EME, Italy EME, Jersey EME, Jordan EME, Kazakhstan EME, Kuwait EME, Kyrgyzstan EME, Latvia EME, Lebanon EME, Liechtenstein EME, Lietuva EME, Lithuania EME, Luxembourg EME, Macedonia EME, Malta EME, Moldova EME, Monaco EME, Montenegro EME, Netherlands EME, Norway EME, Oman EME, Pakistan EME, Poland EME, Portugal EME, Qatar EME, Romania EME, Russia EME, Russian Federation EME, San Marino EME, Saudi Arabia EME, Scotland EME, Serbia EME, Slovakia EME, Slovenia EME, Spain EME, Sweden EME, Switzerland EME, Syria EME, Tajikistan EME, Turkey EME, Turkmenistan EME, UAE EME, UK EME, Ukraine EME, United Arab Emirates EME, Uzbekistan EME, Wales
];
/******************************* Security Data Load********************************/
Through this i am able to achieve the field level security on Region Field for each of the users.
Please help me to achieve the same securityinside the java web application without asking me for userid aaaand password
