analytics/templates/ps/portal/specify_connection.xts

<?xml version="1.0" encoding="UTF-8"?>
<!--
    Licensed Materials - Property of IBM

    IBM Cognos Products: ps

    (C) Copyright IBM Corp. 2005, 2017

    US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
-->

<!--
   Copyright (C) 2008 Cognos ULC, an IBM Company. All rights reserved.
   Cognos (R) is a trademark of Cognos ULC, (formerly Cognos Incorporated).
-->
<xts:morphlet xmlns:xts="http://developer.cognos.com/schemas/xts/" xmlns:cml="http://developer.cognos.com/schemas/xts/logic-sheet/xslt/cml/1/" xmlns:cm="http://developer.cognos.com/schemas/xts-cm/1/" messageBase="messages/portal.xml, messages/portalRL.xml" includeConfig="true" requiredCapability="canUseAdministrationPortal">
	<!--
	===============================================================================================
	formlogic_init

	Standard form logic initialization
	===============================================================================================
	-->
	<xts:block id="formlogic_init" type="exec" mode="interpret" processor="XSLT" path="/logicsheets/formlogic_init.xslt" nodelist="env,credential,system,http"/>

	<!--
	===============================================================================================
	load_metadata
	===============================================================================================
	-->
	<xts:block id="load_metadata" processor="XSLT" type="exec" mode="interpret" nodelist="" dependency="formlogic_init">
		<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
			<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="no"/>
			<xsl:template match="/">
				<xts:sequence>
					<xts:append>
						<xts:transform src="transforms/portal/dataSource/extractDatasourceMetadata.xslt" processor="XSLT">
							<root>
								<getJDBCDatasource>true</getJDBCDatasource>
								<xts:queryNode select="/root/env"/>
								<xts:transform src="/transforms/portal/dataSource/generateDatasourceMetadata.xslt" processor="XSLT">
									<xts:param name="messageBase">/messages/portal.xml</xts:param>
									<root/>
								</xts:transform>
							</root>
						</xts:transform>
					</xts:append>
					<xts:append>
						<xts:function name="getConfiguration">	
							<xts:param name="aliasRoots"/>		
						</xts:function>
					</xts:append>
				</xts:sequence>
			</xsl:template>
		</xsl:stylesheet>
	</xts:block>
	<!--
	================================================================================
	get_content

	Retrieve the namespace information from CM
	================================================================================
	-->
	<xts:block id="get_content" mode="interpret" type="exec" processor="XSLT" dependency="formlogic_init load_metadata">
		<xts:logicsheet path="logicsheets/buslogic.xslt"/>
		<xsl:stylesheet version="1.0"
			xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
			xmlns:send="http://developer.cognos.com/schemas/xts/logic-sheet/xslt/brl/1/">
			<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="no"/>
			<xsl:template match="/">
				<xts:sequence>
					<xsl:if test="/root/datasources/datasource/authentication[type='namespace']">
						<xts:append>
							<namespaces>
								<xts:transform src="transforms/portal/dataSource/stripnamespace.xslt" processor="XSLT">
									<xts:transform src="transforms/CM/post-process.xslt" processor="XSLT">
										<send:request provider="cm">
											<xts:transform src="transforms/CM/pre-process.xslt" processor="XSLT">
												<query xmlns="http://developer.cognos.com/schemas/xts-cm/1/">
													<search>/directory/namespace</search>
													<properties>
														<cm:property name="defaultName"/>
														<cm:property name="searchPath"/>
														<cm:property name="active"/>
													</properties>
												</query>
											</xts:transform>
										</send:request>
									</xts:transform>
								</xts:transform>
							</namespaces>
						</xts:append>
					</xsl:if>	
					<!-- get a list of installed components -->
					<xts:append>
						<installedComponents>
							<xts:function name="getConfiguration">	
								<xts:param name="installedComponents"/>		
							</xts:function>
						</installedComponents>
					</xts:append>
					<!-- get a list of additional datasources -->
					<xts:append faultBlock="ignore">
						<xts:request protocol="FILEREAD" target="$CONFIG_ROOT$/datasources.xml" faultBlock="ignore" cache="false"/>
					</xts:append>
				</xts:sequence>
			</xsl:template>
		</xsl:stylesheet>
	</xts:block>
	
<!--
	================================================================================
	decrypt_credentials
	
	Decrypts the proxy credentials.
	================================================================================
	-->
	<xts:block id="decrypt_credentials" dependency="get_content" type="exec" mode="interpret" processor="XSLT" nodelist="env" mandatory="false" condition=".[/root/env/param[@name='m_proxy_credentials']]">
		<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:xtsext="xalan://com.cognos.xts.ext.XTSExt" xmlns:cm="http://developer.cognos.com/schemas/xts-cm/1/">
			<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="no"/>
			<xsl:variable name="xtscm" select="'http://developer.cognos.com/schemas/xts-cm/1/'"/>
			<xsl:template match="/">
				<xts:sequence>
					<xsl:if test="/root/env/param[@name='m_proxy_credentials']!=''"> 
						<xts:append>
							<decrypted-credentials xmlns="http://developer.cognos.com/schemas/xts-cm/1/">
					 			<xts:decrypt>
									<xts:param name="provider">cognos.cam</xts:param>
									<xts:param name="source"><xsl:value-of select="substring-before(substring-after(xtsext:xmldecode( string(/root/env/param[@name='m_proxy_credentials'])), '&lt;encryptedValue&gt;'), '&lt;/encryptedValue&gt;')"/></xts:param>
								</xts:decrypt>
							</decrypted-credentials>
						</xts:append>
					</xsl:if>	
				</xts:sequence>
			</xsl:template>
		</xsl:stylesheet>
	</xts:block>
	<!--
	================================================================================
	extract_user_info
	
	Extracts the userid from the decrypted credentials.
	================================================================================
	-->
	<xts:block id="extract_user_info" type="exec" mode="interpret" dependency="decrypt_credentials" processor="XSLT" mandatory="false" condition=".[/root/*[local-name()='decrypted-credentials']]">
		<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:xtsext="xalan://com.cognos.xts.ext.XTSExt" xmlns:cm="http://developer.cognos.com/schemas/xts-cm/1/">
			<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="no"/>
			<xsl:variable name="xtscm" select="'http://developer.cognos.com/schemas/xts-cm/1/'"/>
			<xsl:template match="/">
				<xts:sequence>
				<xsl:variable name="username" select="xtsext:xmldecode(string(/root/cm:decrypted-credentials/cm:credential/cm:username))"/>
				<xsl:variable name="password" select="xtsext:xmldecode(string(/root/cm:decrypted-credentials/cm:credential/cm:password))"/>
					<xts:delete select="/root/env/param[@name='m_connection_proxy_user' or @name='m_connection_proxy_password']"/>
					
					<xts:append select="/root/env">
						<param name="m_connection_proxy_user"><xsl:value-of select="$username"/></param>
						<param name="m_connection_proxy_password"><xsl:value-of select="$password"/></param>
					</xts:append>

					<xts:delete select="/root/*[local-name()='decrypted-credentials']"/>
				</xts:sequence>
			</xsl:template>
		</xsl:stylesheet>
	</xts:block>

	<!--
	================================================================================
	process_datasources

	================================================================================
	-->
	<xts:block id="process_datasources" type="exec" mode="interpret" dependency="get_content" processor="XSLT" nodelist="env,credential,system,http,datasources,additionalDatasources">
		<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
			<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="no"/>
			<xsl:template match="/">
				<xts:sequence>
					<xts:append select="root/datasources/datasource[value='jdbc-generic']/supportedDataSources">
						<xsl:for-each select="root/additionalDatasources/datasource[@type='jdbc-generic']">
							<!--  simple check for .xml extension -->
							<xsl:if test="substring(@filename, (string-length(@filename) - string-length('.xml')) + 1) = '.xml'">
								<xts:request protocol="FILEREAD" target="{concat('$CONFIG_ROOT$','/datasources/',@filename)}" faultBlock="ignore" cache='false' debug="false"/>
							</xsl:if>
						</xsl:for-each>
					</xts:append>
				</xts:sequence>
				
			</xsl:template>
		</xsl:stylesheet>
	</xts:block>
				

	<xts:block id="ignore" processor="XML" type="fault">
		<ignore/>
	</xts:block>

	
	<!--
	================================================================================
	parse_sap_connection

	Determines the server type for a SAP connection.
	================================================================================
	-->
	<xts:block id="parse_sap_connection" mode="interpret" type="exec" processor="XSLT" mandatory="false" dependency="formlogic_init" condition=".[/root/env/param[@name='m_connection_type']='sap' and not(/root/env/param[@name='m_connection_sap_type'])]">
		<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
			<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="no"/>
			<xsl:template match="/">
				<xsl:variable name="sap-server-type">
					<xsl:value-of select="substring-before(substring-after(/root/env/param[@name='m_p_connectionString'], 'serverType='), ';')"/>
				</xsl:variable>
				<xts:sequence>
					<xts:append select="/root/env">
						<param name="m_connection_sap_type">
							<xsl:value-of select="$sap-server-type"/>
						</param>
					</xts:append>
				</xts:sequence>
			</xsl:template>
		</xsl:stylesheet>
	</xts:block>

	<!--
	===============================================================================================
	render_page

	Render the page
	===============================================================================================
	-->
	<xts:block id="render_page" mode="output" processor="XSLT" type="exec" mimeType="text/html" dependency="extract_user_info parse_sap_connection process_datasources">
		<!-- get the presentation theme -->
		<xts:logicsheet path="logicsheets/portal.xsl"/>
		<xts:logicsheet path="logicsheets/presentation/dialog/connections.xslt"/>
		<xts:logicsheet path="logicsheets/presentation/dialog/templates.xsl"/>
		<xts:logicsheet path="logicsheets/presentation/dialog/framework.xsl"/>
		<xts:logicsheet path="logicsheets/presentation/layout.xsl"/>
		<xts:logicsheet path="logicsheets/presentation/dialog/presentation.xsl"/>
		<xts:logicsheet path="logicsheets/presentation/controls/framework.xsl"/>
		<xts:logicsheet path="logicsheets/presentation/controls/presentation.xsl"/>
		<xts:logicsheet path="logicsheets/presentation/dialog/confirm.xslt"/>
		<xts:logicsheet path="logicsheets/formlogic.xslt"/>
		<xts:logicsheet path="logicsheets/validation.xslt"/>
		<xts:logicsheet path="logicsheets/presentation/touch_up.xslt"/>
		<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
			xmlns:dcx="http://developer.cognos.com/schemas/xts/logicsheets/xslt/presentation/dialog/connections/1/"
			xmlns:dt="http://developer.cognos.com/schemas/xts/logicsheets/xslt/presentation/dialog/templates/"
			xmlns:lyt="http://developer.cognos.com/schemas/xts/logicsheets/xslt/presentation/layout/"
			xmlns:pf="http://developer.cognos.com/schemas/xts/pf"
			xmlns:dp="http://developer.cognos.com/schemas/xts/logicsheets/xslt/presentation/dialog/presentation/"
			xmlns:df="http://developer.cognos.com/schemas/xts/logicsheets/xslt/presentation/dialog/framework/"
			xmlns:dc="http://developer.cognos.com/schemas/xts/logicsheets/xslt/presentation/dialog/confirm/1/"
			xmlns:cf="http://developer.cognos.com/schemas/xts/logicsheets/xslt/presentation/controls/framework/"
			xmlns:cp="http://developer.cognos.com/schemas/xts/logicsheets/xslt/presentation/controls/presentation/"
			xmlns:utml="http://developer.cognos.com/schemas/xts/logicsheet/xslt/formlogic/"
			xmlns:xtsext="xalan://com.cognos.xts.ext.XTSExt"
			exclude-result-prefixes="xsl dcx dt pf cf cp df dp dc lyt utml">
			<xsl:output method="html" version="1.0" encoding="UTF-8" indent="no" omit-xml-declaration="yes"/>
			<!-- current file name -->
			<xsl:variable name="mname" select="'specify_connection.xts'"/>
			<!-- add any theme variables -->
			<pf:variables/>

			<!-- add the connection templates -->
			<dcx:connectionTemplates/>
			<xsl:variable name="connectionType" select="key('env-param','m_connection_type')"/>
			<xsl:variable name="connectionVariant" select="key('env-param','m_connection_variant')"/>
			<xsl:variable name="connectionTab" select="key('env-param','m_connection_tab')"/>
			<xsl:variable name="jdbcConnectionType" select="/root/datasources/datasource/queryServiceEquivalent"/>
			<xsl:variable name="queryServiceInstalled" select="count(/root/installedComponents/configuration/property/component[string(.)='queryService'])!=0"/>
			<xsl:key name="installedComponents" match="/root/installedComponents/cm:queryResponse/cm:installedComponent" use="cm:componentID/cm:value"/>
			
			<dcx:testConnection/>
			<!-- start the output -->
			<xsl:template match="/root">
				<!-- get passed in parameters -->
				<xsl:variable name="connection_typeName">
					<xsl:choose>
						<xsl:when test="/root/datasources/datasource/neutralName != ''">
							<xsl:value-of select="/root/datasources/datasource/neutralName"/>
						</xsl:when>
						<xsl:otherwise>
							<xsl:value-of select="/root/datasources/datasource/name"/>
						</xsl:otherwise>
					</xsl:choose> 
				</xsl:variable>
				<xsl:variable name="sap-server-type">
					<xsl:choose>
						<xsl:when test="key('env-param','m_connection_sap_type') != ''">
							<xsl:value-of select="key('env-param','m_connection_sap_type')"/>
						</xsl:when>
						<xsl:otherwise>
							<xsl:value-of select="/root/morphlet/variable[@name='sap-server-type']"/>
						</xsl:otherwise>
					</xsl:choose>
				</xsl:variable>
				<xsl:variable name="title">
					<xts:string id="IDS_PROP_CONN_STRING_TITLE">
						<xts:param name="connectionStringType">
							<xsl:value-of select="$connection_typeName"/>
						</xts:param>
					</xts:string>
				</xsl:variable>
				<xsl:variable name="validationConnectionType">
					<xsl:if test="$connectionTab='odbc'">
						<xsl:value-of select="$connectionType"/>
					</xsl:if>
					<xsl:if test="$connectionTab='jdbc'">
						<xsl:value-of select="$jdbcConnectionType"/>
					</xsl:if>
				</xsl:variable>
				<xsl:variable name="proxyEnabled">
					<xsl:value-of select="key('env-param','m_connection_proxy_enabled')='true'"/>
				</xsl:variable>
				<xsl:variable name="isDatasourceSignon">
					<xsl:call-template name="dcx-isDatasourceSignon">
						<xsl:with-param name="connectionString" select="key('env-param','m_p_connectionString')"/>
					</xsl:call-template>			
				</xsl:variable>

				<xsl:text disable-output-escaping='yes'>&lt;!DOCTYPE html></xsl:text><dp:page longTitle="$title">
					<dp:meta>
						<!-- Standard meta tags -->
						<pf:meta/>
					</dp:meta>
					<dp:script>
						<!-- Help system -->
						<pf:help context="HID_DATA_SOURCES"/>
						<pf:dojo/>
						<script language="javascript" src="{$webcontent}/{$app}/js/connections.js"/>
						<script language="javascript">
							<dt:checkMandatoryScript/>
							<dcx:checkReservedChar/>
var g_signon_authentication_warning_msg='<xts:string id="IDS_SELECT_CONNECT_CHANGE_AUTENTICATION_WARNING" encode="javascript"/>';
function validateConnection()
{
	var f = document.pform;
	<xsl:call-template name="get-validations">
		<xsl:with-param name="connection-type" select="$validationConnectionType"/>
		<xsl:with-param name="connection-variant" select="$connectionVariant"/>
	</xsl:call-template>
}

//whether you are in JDBC tab and JDBC section is disabled.
function isJdbcDisabled(){
	return (document.pform.m_connection_tab.value == 'jdbc') &amp;&amp; (document.pform.m_connection_enable_JDBC.value == 'false');
}

function validate()
{
	var f = document.pform;
	var confirm = 'false';
		
	<xsl:if test="$isDatasourceSignon='true'">
		<!--  determine what authentication type is selected -->
		var signonSelected = 'false';
		/* not all connections types will have the f.authentications */
		if ((f.authentication !== undefined) &amp;&amp; (f.authentication !== null)){
	 		for (var i=0; i &lt; f.authentication.length; i++)
			{
	 			if (f.authentication[i].value == 'signon' &amp;&amp; f.authentication[i].checked) {
					signonSelected = 'true';
				}
		 	}
	 	}
		<!--  display confirmation window when removing datasourceSignons -->		
 	 	if (signonSelected=='false'){ 
			confirm = window.confirm(g_signon_authentication_warning_msg);
			<!--  return state of checkboxes if user cancels-->
			if (!confirm) {
				for (var i=0; i &lt; f.authentication.length; i++)
				{
					if (f.authentication[i].value == 'signon') {
						f.authentication[i].checked='true';
					}
				}
				onChangeAuthentication();	
				return false;
			} 
		}	
	</xsl:if>
	if (isJdbcDisabled() || validateConnection())
	{
		var f = document.pform;
		<xsl:choose>
			<xsl:when test="($queryServiceInstalled)">
				if (f.m_connection_enable_JDBC.value=='true') {
					buildConnectString('<xsl:value-of select="$connectionType"/>,<xsl:value-of select="$jdbcConnectionType"/>','<xsl:value-of select="xtsext:javascriptencode($connectionVariant)"/>');
				}	
				if (f.m_connection_enable_JDBC.value=='false') {
					buildConnectString('<xsl:value-of select="$connectionType"/>','<xsl:value-of select="xtsext:javascriptencode($connectionVariant)"/>');
				}
			</xsl:when>
			<xsl:otherwise>
				buildConnectString('<xsl:value-of select="$connectionType"/>','<xsl:value-of select="xtsext:javascriptencode($connectionVariant)"/>');
			</xsl:otherwise>
		</xsl:choose>			
		return true;
	}
	return false;
}

function doTest()
{
	if(isJdbcDisabled() || validateBeforeTest())
	{
		f=document.pform;
		<xsl:if test="$connectionTab='odbc'">
			buildConnectString('<xsl:value-of select="$connectionType"/>','<xsl:value-of select="$connectionVariant"/>');
		</xsl:if>
		<xsl:if test="$connectionTab='jdbc'">
			buildConnectString('<xsl:value-of select="$jdbcConnectionType"/>','<xsl:value-of select="$connectionVariant"/>');
		</xsl:if>
		f.ps_nav_op.value = 'push';
		f.m.value = '<xsl:value-of select="concat($app,'/test_connection.xts')"/>';
		f.submit();
	}
	return;
}

function validateBeforeTest()
{
	var f = document.pform;
	<xsl:call-template name="get-validations">
		<xsl:with-param name="connection-type" select="$validationConnectionType"/>
		<xsl:with-param name="connection-variant" select="$connectionVariant"/>
		<xsl:with-param name="test" select="true()"/>
	</xsl:call-template>
}
function changeTab(tab) {
	if(isJdbcDisabled() || validateBeforeTest()) {
		document.pform.ps_nav_op.value = 'maintain';
		document.pform.m_connection_tab.value = tab;
		document.pform.submit();
	}
	return;
}		

<![CDATA[
/*
     
	 summary: generate an iframe to cover the div,  to prevent any event (against div) from happening. Basically it's another approach to "disable" the div.
	 @param div: an existing element in DOM
	 
*/
function coverDiv(div) {
	this.origDiv = document.getElementById(div);
	this.backingID = this.origDiv.id + "_backing";
	this.backing = document.getElementById(this.backingID);
	
	if (this.backing == null) {
		this.backing = document.createElement("iframe");
		this.backing.id = this.backingID;
		this.backing.name = this.backingID;

		this.backing.src = "about:blank";
		this.backing.style.backgroundColor="#dddddd";
		this.backing.setAttribute('frameBorder', "0"); 
		this.backing.style.display= "none";
		this.backing.style.position="absolute";
		dojo.style(this.backing,"opacity",0.5);
		document.body.appendChild(this.backing);
		dojo.connect(window,"resize",this,"caliberate");
	}
}

coverDiv.prototype = {
	coverUp: function(cover){
		if (cover) {
			this.caliberate();
			this.backing.style.display = "";
		} else {
			this.backing.style.display = "none";
		}
		this.disableTabbing(cover);
	},
	caliberate: function(){
		var position = dojo.coords(this.origDiv);
		//-1 mean to remove the horizental scroll bar in browser.
		dojo.style(this.backing,"width",position.w-1);
		dojo.style(this.backing,"height",position.h);
		dojo.style(this.backing,"top",position.t);
		dojo.style(this.backing,"left",position.l);
	},
	disableTabbing: function(cover){
		var getElems = function(elem) {            
			var targetTags = ["input","select","a"];
			var elems = [];  
			if (elem.nodeType == 1 /*Node.ELEMENT_NODE*/) {                      
				if (dojo.indexOf(targetTags,elem.tagName.toLowerCase()) > -1){
					elems.push(elem);
				}
				var children = elem.childNodes;                
				for(var i=0; i < children.length; i++) {    
					elems = elems.concat(getElems(children[i]));     
				}	
			}     
			return elems;
		};
		
		var targetElems = getElems(this.origDiv);
		for(var j=0; j<targetElems.length; j++) {
			targetElems[j].tabIndex = cover ? -1 : 0;
		}
	}
}
]]>


function enableJDBCClicked() {
	var chkBoxChecked = document.getElementById("enableJDBC").checked;
	document.pform.m_connection_enable_JDBC.value=chkBoxChecked ? 'true' : 'false';
	(new coverDiv('connection_body')).coverUp(!chkBoxChecked);
    document.getElementById("connection_body").setAttribute("aria-hidden", !chkBoxChecked);
}	

function init()
{
	var f = document.pform;
	// the first time we hit the ODBC tab
	<xsl:choose>
		<xsl:when test="not(key('env-param','visited_specify_connection_odbc_tab'))">
			// set the initial state of the Enable JDBC checkbox
	
			f.m_connection_enable_JDBC.value=isDualStackConnectString(f.m_p_connectionString.value) ? 'true' : 'false';
	
			// Parse the string if we have it, but only the first time the page is loaded
			if (f.m_p_connectionString.value != '')
			{
				parseConnectString('<xsl:value-of select="$connectionType"/>,<xsl:value-of select="$jdbcConnectionType"/>', '<xsl:value-of select="xtsext:javascriptencode(key('env-param','m_p_credentialNamespaces')) != '' "/>','<xsl:value-of select="xtsext:javascriptencode(string($connectionVariant))"/>');
			}
		</xsl:when>
		<!--  update the proxy host controls -->
		<xsl:when test="$connectionType='sfdc'">
			<xsl:choose>
				<xsl:when test="key('env-param','m_connection_proxy_enabled') and $proxyEnabled='true'">
					f.m_connection_proxy_enabled.value='true';
					f.m_connection_proxy_enabled.checked='true';
					disableProxyControls(false);
				</xsl:when>
				<xsl:otherwise>
					disableProxyControls(true);
				</xsl:otherwise>
			</xsl:choose>
		</xsl:when>		
	</xsl:choose>
	<!-- this will update the signon controls so the appropriate ones are disabled -->
	<xsl:choose>
		<xsl:when test="contains(' dbtwoolap tm1R tm1 odata sql jdbc-sql sql2005 sql2008 sql2012-2014 sqlodbc composite virtualviewmanager msanalysis2017 msanalysis2016 msanalysis2014 msanalysis2012 msanalysis2008 msanalysis2005 sap powercube teradata jdbc-teradata db2 jdbc-db2 odbc netezza jdbc-netezza jdbc-generic lob-jdbc oracle ', concat(' ',$connectionType,' '))">
			onChangeAuthentication();
		</xsl:when>
		<xsl:when test="$connectionType!='other'">
			if (f.m_connection_use_userid)
			{
				f.m_connection_use_pword.disabled = !f.m_connection_use_userid.checked;
			}
			if (f.m_connection_default_signon &amp;&amp; f.m_connection_use_userid)
			{
				f.m_connection_default_signon.disabled=!f.m_connection_use_userid.checked;
			}
		</xsl:when>
	</xsl:choose>
	<xsl:if test="$connectionType='contributorSeries7'">
		checkPADIDValue();
	</xsl:if>

	<xsl:if test="$connectionType = 'filenet'">
		initRepositoryConnectionPage();
	</xsl:if>

	<xsl:if test="$connectionType = 'db2'">
    	updateTrustedContext();
	</xsl:if>
	
	updateJdbcOracle();
	updateJdbcSortOptions();

  <!--
    Setting the href for the cancel button and the close icon
    There is a cancel form which contains only the necessary hidden fields
    This is to avoid submitting invalid values when clicking cancel or closing the window
  -->
  var idsCancel = document.getElementById("IDS_CANCEL");
  var idsClose = document.getElementById("IDS_CLOSE_REF");
  var idsHiddenCancel = document.getElementById("IDS_HIDDEN_CANCEL");
  if (idsCancel != null &amp;&amp; idsClose != null &amp;&amp; idsHiddenCancel != null) {
    idsCancel.href = idsHiddenCancel.href;
    idsClose.href = idsHiddenCancel.href;
  }
  
  // every time we hit the JDBC tab
	if (document.pform.m_connection_tab.value=='jdbc'){
        var bCoverUp = document.pform.m_connection_enable_JDBC.value == 'false';
		(new coverDiv('connection_body')).coverUp(bCoverUp);
        document.getElementById("connection_body").setAttribute("aria-hidden", bCoverUp);
	}

} // end of init()

						</script>
						<script language="javascript" src="{$webcontent}/{$app}/js/utilities.js"/>
						<dc:confirm-cancel/>
					</dp:script>
					<xsl:variable name="connTypeDescription">
						<xsl:choose>
							<xsl:when test="$connectionTab='odbc'">
								<xsl:value-of select="/root/datasources/datasource/editDescription"/>
							</xsl:when>
							<xsl:otherwise>
								<xsl:value-of select="/root/jdbcdatasources/datasource/editDescription"/>
							</xsl:otherwise>
						</xsl:choose>
					</xsl:variable>
					<!-- hidden cancel form used when clicking on cancel or on the close button; see the init() method -->
					<div style="display:none">
						<utml:form name="cancelForm" method="post" action="{$gateway}" >
						<df:button df:id="IDS_HIDDEN_CANCEL" df:style="stack-down" />
					</utml:form>
					  </div>
					<utml:form name="pform" method="post" action="{$gateway}">
						<dp:header>
							<!-- header titles-->
							<dp:title>
								<xsl:value-of select="$title"/>
							</dp:title>
							<dp:close>
								<utml:a utml:op="stack-down" id="IDS_CLOSE_REF">
									<dp:closeMarker/>
								</utml:a>
							</dp:close>
						</dp:header>
						<xsl:variable name="JDBCconnectionTypeToUse">
							<xsl:choose>
								<xsl:when test="$jdbcConnectionType!=''">
									<xsl:value-of select="$jdbcConnectionType"/>
								</xsl:when>
								<xsl:otherwise>
									<xsl:value-of select="$connectionType"/>
								</xsl:otherwise>
							</xsl:choose>
						</xsl:variable>
						
						<!-- tab section -->	
						<xsl:if test="$queryServiceInstalled and $jdbcConnectionType!=''" >
							<cp:tabset>	
								<cp:select><xsl:value-of select="$connectionTab"/></cp:select>
								<cp:tab name="odbc" position="start">
									<a href="javascript:changeTab('odbc');">
										<cp:label>
											<xsl:choose>
												<xsl:when test="/root/datasources/datasource/tabLabel != ''">
													<xsl:value-of select="/root/datasources/datasource/tabLabel"/>
												</xsl:when>
												<xsl:otherwise>
													<xts:string id="IDS_SELECT_CONNECT_COMPATIBLE_TAB_LABEL"/>
												</xsl:otherwise>
											</xsl:choose>
										</cp:label>
									</a>
								</cp:tab>	
								<cp:tab name="jdbc" position="end">
									<a href="javascript:changeTab('jdbc');">
										<cp:label><xts:string id="IDS_SELECT_CONNECT_JDBC_TAB_LABEL"/></cp:label>
									</a>
								</cp:tab>	
							</cp:tabset>
						</xsl:if>
						
						<dp:description>
							<xsl:choose>
								<xsl:when test="$connectionType = 'contributor'">
									<xsl:text><xts:string id="IDS_NEW_INTRO_CONNECT_NEWCONTRIBUTOR"/></xsl:text>
								</xsl:when>
								<xsl:otherwise>
									<xts:string id="IDS_NEW_INTRO_CONNECT">
										<xts:param name="connectionType">
											<xsl:value-of select="$connTypeDescription"/>
										</xts:param>
									</xts:string>
								</xsl:otherwise>
							</xsl:choose>
						</dp:description>

						<xsl:if test="$connectionTab='jdbc'">	
							<lyt:layout style="1">
								<lyt:section>
									<dp:group>
										<dp:groupItem>
											<dp:choice noSpace="true">
												<dp:section1>
													<utml:input type="checkbox" name="enableJDBC" id="enableJDBC" value="false">
														<xsl:if test="key('env-param','m_connection_enable_JDBC')='true'">
															<xsl:attribute name="checked"/>
														</xsl:if>	
														<xsl:attribute name="onclick">enableJDBCClicked();</xsl:attribute>
													</utml:input>		
												</dp:section1>
												<dp:section2 for="enableJDBC">
													<xts:string id="IDS_SELECT_CONNECT_ENABLE_JDBC"/>
												</dp:section2>
											</dp:choice>
										</dp:groupItem>
									</dp:group>
								</lyt:section>
							</lyt:layout>
						</xsl:if>

						<utml:input type="hidden" name="m_p_connectionString"/>
						<utml:input type="hidden" name="visited_specify_connection_odbc_tab" value="true" utml:update="false"/>
						<div id="connection_body">
							<xsl:if test="$connectionTab='jdbc'">	
								<xsl:attribute name="style">
									<xsl:value-of select="'padding-left: 2em;'"/>
								</xsl:attribute>
							</xsl:if>
							<div id="odbc">
								<xsl:if test="$connectionTab='jdbc'">	
									<xsl:attribute name="style">
										<xsl:value-of select="'display:none'"/>
									</xsl:attribute>
								</xsl:if>
								<xsl:choose>
									<xsl:when test="$connectionType = 'composite' or $connectionType = 'virtualviewmanager' or $connectionType = 'db2' or $connectionType = 'odbc' or $connectionType = 'openEdge' or $connectionType = 'redbrick' or $connectionType = 'teradata' or $connectionType = 'sqlodbc' or $connectionType = 'sybaseIQ' or $connectionType = 'netezza' or $connectionType = 'jdbc-teradata' or $connectionType = 'jdbc-db2' or $connectionType = 'jdbc-netezza' or $connectionType = 'jdbc-sql'">
										<!--
										=========================================================================
											D B 2 / O D B C
										=========================================================================
										-->
										<xsl:call-template name="dcx-db2-odbc-template">
											<xsl:with-param name="form-read-only" select="$form-read-only"/>
											<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
										</xsl:call-template>
									</xsl:when>
									<xsl:when test="$connectionType = 'msas_xmla'">
										<!--
										=========================================================================
											Microsoft Analysis Services (via XMLA)
										=========================================================================
										-->
										<xsl:call-template name="dcx-msas_xmla-template">
											<xsl:with-param name="form-read-only" select="$form-read-only"/>
											<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
										</xsl:call-template>
									</xsl:when>
									<xsl:when test="$connectionType = 'consolidation'">
										<!--
										=========================================================================
											Cognos Consolidation
										=========================================================================
										-->
										<xsl:call-template name="dcx-consolidation-template">
											<xsl:with-param name="form-read-only" select="$form-read-only"/>
											<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
										</xsl:call-template>
									</xsl:when>
									<!--
										The contributor connection does not have any parameters (except the namespace).
										The contributor series 7 has parameters (server, padid, port and namespace).
									-->
									<xsl:when test="$connectionType = 'contributorSeries7'">
										<!--
										=========================================================================
											Cognos Contributor Series 7
										=========================================================================
										-->
										<xsl:call-template name="dcx-contributorSeries7-template">
											<xsl:with-param name="form-read-only" select="$form-read-only"/>
											<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
										</xsl:call-template>
									</xsl:when>
									<xsl:when test="$connectionType = 'powercube'">
										<!--
										=========================================================================
											Cognos PowerCube
										=========================================================================
										-->
										<xsl:call-template name="dcx-powercube-template">
											<xsl:with-param name="form-read-only" select="$form-read-only"/>
											<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
										</xsl:call-template>
									</xsl:when>
									<xsl:when test="$connectionType = 'dbtwoolap'">
										<!--
										=========================================================================
											IBM DB2/Hyperion ESSBase OLAP Server
										=========================================================================
										-->
										<xsl:call-template name="dcx-db2olap-template">
											<xsl:with-param name="form-read-only" select="$form-read-only"/>
											<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
										</xsl:call-template>
									</xsl:when>
									<xsl:when test="$connectionType = 'tm1'">
										<!--
										=========================================================================
											TM1
										=========================================================================
										-->
										<xsl:call-template name="dcx-tm1-template">
											<xsl:with-param name="form-read-only" select="$form-read-only"/>
											<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
										</xsl:call-template>
									</xsl:when>
									<xsl:when test="$connectionType = 'tm1R'">
										<!--
										=========================================================================
											Planning Analytics
										=========================================================================
										-->
										<xsl:call-template name="dcx-tm1R-template">
											<xsl:with-param name="form-read-only" select="$form-read-only"/>
											<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
										</xsl:call-template>
									</xsl:when>
									<xsl:when test="$connectionType = 'odata'">
										<!--
										=========================================================================
											OData
										=========================================================================
										-->
										<xsl:call-template name="dcx-odata-template">
											<xsl:with-param name="form-read-only" select="$form-read-only"/>
											<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
										</xsl:call-template>
									</xsl:when>
									<xsl:when test="$connectionType = 'json'">
										<!--
										=========================================================================
											JSON
										=========================================================================
										-->
										<xsl:call-template name="dcx-json-template">
											<xsl:with-param name="form-read-only" select="$form-read-only"/>
											<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
										</xsl:call-template>
									</xsl:when>
									<xsl:when test="$connectionType = 'cognosnow'">
										<!--
										=========================================================================
											COGNOSNOW
										=========================================================================
										-->
										<xsl:call-template name="dcx-cognosnow-template">
											<xsl:with-param name="form-read-only" select="$form-read-only"/>
											<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
										</xsl:call-template>
									</xsl:when>
									<xsl:when test="contains(' msanalysis2005 msanalysis2008 msanalysis2012 msanalysis2014 msanalysis2016 msanalysis2017', concat(' ',$connectionType,' '))">
										<!--
										=========================================================================
											Microsoft Analysis Services 2005 or 2008 or 2012 or 2014
										=========================================================================
										-->
										<xsl:call-template name="dcx-msanalysis2005-template">
											<xsl:with-param name="form-read-only" select="$form-read-only"/>
											<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
										</xsl:call-template>
									</xsl:when>					
									<xsl:when test="contains(' sql sql2005 sql2008 sql2012-2014 jdbc-sql ', concat(' ',$connectionType,' '))"> 	
										<!--
										=========================================================================
											M S   S Q L   S e r v e r (OLEDB or 2005 or 2008 or 2012 or 2014)
										=========================================================================
										-->
										<xsl:call-template name="dcx-sql-template">
											<xsl:with-param name="form-read-only" select="$form-read-only"/>
											<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
										</xsl:call-template>
									</xsl:when>
									<xsl:when test="$connectionType = 'oracle' or $connectionType = 'jdbc-oracle'">
										<!--
										=========================================================================
											O R A C L E
										=========================================================================
										-->
										<xsl:call-template name="dcx-oracle-template">
											<xsl:with-param name="form-read-only" select="$form-read-only"/>
											<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
										</xsl:call-template>
									</xsl:when>
									<xsl:when test="$connectionType = 'sybase' or $connectionType = 'sybase_ct15'">
										<!--
										=========================================================================
											S Y B A S E 			CT-Lib	 or	 CT-15
										=========================================================================
										-->
										<xsl:call-template name="dcx-sybase-template">
											<xsl:with-param name="form-read-only" select="$form-read-only"/>
											<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
											<xsl:with-param name="connection-type" select="$connectionType"/>
										</xsl:call-template>
									</xsl:when>
									<xsl:when test="$connectionType = 'informix'">
										<!--
										=========================================================================
											I N F O R M I X
										=========================================================================
										-->
										<xsl:call-template name="dcx-informix-template">
											<xsl:with-param name="form-read-only" select="$form-read-only"/>
											<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
										</xsl:call-template>
									</xsl:when>
									<!--
										=========================================================================
											S A P   B W
										=========================================================================
										-->
									<xsl:when test="$connectionType = 'sap'">
										<xsl:call-template name="dcx-sap-template">
											<xsl:with-param name="form-read-only" select="$form-read-only"/>
											<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
										</xsl:call-template>
									</xsl:when>
									<!--
										=========================================================================
											S A P   R 3 or SAP BW ECC
										=========================================================================
										-->
									<xsl:when test="$connectionType = 'sapR3' or $connectionType = 'sapECC'">
										<xsl:call-template name="dcx-sapR3-template">
											<xsl:with-param name="form-read-only" select="$form-read-only"/>
											<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
										</xsl:call-template>
									</xsl:when>
									<xsl:when test="$connectionType = 'xml'">
										<!--
										=========================================================================
											X M L
										=========================================================================
										-->
										<xsl:call-template name="dcx-xml-template">
											<xsl:with-param name="form-read-only" select="$form-read-only"/>
											<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
										</xsl:call-template>
									</xsl:when>
									<xsl:when test="$connectionType = 'jdbc-generic' or $connectionType = 'lob-jdbc'">
										<!--
										=========================================================================
											 JDBC Generic
										=========================================================================
										-->
										<xsl:call-template name="dcx-jdbc-generic">
											<xsl:with-param name="form-read-only" select="$form-read-only"/>
											<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
										</xsl:call-template>
									</xsl:when>
									<xsl:when test="$connectionType = 'filenet'">
										<!--
										=========================================================================
											 FileNet
										=========================================================================
										-->
										<xsl:call-template name="dcx-filenet">
											<xsl:with-param name="form-read-only" select="$form-read-only"/>
											<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
										</xsl:call-template>
									</xsl:when>
									<xsl:when test="$connectionType = 'sr3'">
										<!--
										=========================================================================
														S A P R 3
										=========================================================================
										-->
										<xsl:call-template name="dcx-sapr3-template">
											<xsl:with-param name="form-read-only" select="$form-read-only"/>
											<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
										</xsl:call-template>
									</xsl:when>

									<xsl:when test="$connectionType = 'sfdc'">
										<!--
										=========================================================================
														S F D C
										=========================================================================
										-->
										<xsl:call-template name="dcx-sfdc-template">
											<xsl:with-param name="form-read-only" select="$form-read-only"/>
											<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
										</xsl:call-template>
									</xsl:when>
							
									<xsl:when test="$connectionType = 'siebel'">
										<!--
										=========================================================================
														S I E B E L
										=========================================================================
										-->
										<xsl:call-template name="dcx-siebel-template">
											<xsl:with-param name="form-read-only" select="$form-read-only"/>
											<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
										</xsl:call-template>
									</xsl:when>
								</xsl:choose>
							</div>
							<div id="jdbc">
								<xsl:if test="$connectionTab='odbc'">	
									<xsl:attribute name="style">
										<xsl:value-of select="'display:none'"/>
									</xsl:attribute>
								</xsl:if>
								<xsl:choose>
									<xsl:when test="contains('jdbc-sql sql sql2005 sql2008 sql2012-2014 sqlodbc ', concat(' ',$connectionType,' '))"> 		
										<!--
										=========================================================================
											 SQL Server (JDBC)
										=========================================================================
										-->
										<xsl:call-template name="dcx-jdbc-sql">
											<xsl:with-param name="form-read-only" select="$form-read-only"/>
											<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
										</xsl:call-template>
									</xsl:when>
									<xsl:when test="$connectionType = 'jdbc-db2' or $connectionType = 'db2'">
										<!--
										=========================================================================
											 IBM DB2 (JDBC)
										=========================================================================
										-->
										<xsl:call-template name="dcx-jdbc-db2">
											<xsl:with-param name="form-read-only" select="$form-read-only"/>
											<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
										</xsl:call-template>
									</xsl:when>
									<xsl:when test="$connectionType = 'jdbc-teradata' or $connectionType = 'teradata'">
										<!--
										=========================================================================
											 Teradata (JDBC)
										=========================================================================
										-->
										<xsl:call-template name="dcx-jdbc-teradata">
											<xsl:with-param name="form-read-only" select="$form-read-only"/>
											<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
										</xsl:call-template>
									</xsl:when>
									<xsl:when test="$connectionType = 'jdbc-netezza' or $connectionType = 'netezza'">
										<!--
										=========================================================================
											 Netezza (JDBC)
										=========================================================================
										-->
										<xsl:call-template name="dcx-jdbc-netezza">
											<xsl:with-param name="form-read-only" select="$form-read-only"/>
											<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
										</xsl:call-template>
									</xsl:when>
									<xsl:when test="$connectionType = 'jdbc-oracle' or $connectionType = 'oracle'">
										<!--
										=========================================================================
											 Oracle (JDBC)
										=========================================================================
										-->
										<xsl:call-template name="dcx-jdbc-oracle">
											<xsl:with-param name="form-read-only" select="$form-read-only"/>
											<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
										</xsl:call-template>
									</xsl:when>
								</xsl:choose>
							</div>
							<xsl:if test="contains(' composite virtualviewmanager sap consolidation powercube dbtwoolap tm1R tm1 odata json msanalysis2017 msanalysis2016 msanalysis2014 msanalysis2012 msanalysis2008 msanalysis2005 msas_xmla sqlodbc redbrick teradata jdbc-teradata db2 jdbc-db2 odbc openEdge sql sql2005 sql2008 sql2012-2014 jdbc-sql oracle jdbc-oracle jdbc-generic lob-jdbc filenet netezza jdbc-netezza sybase sybase_ct15 sybaseIQ informix sr3 sfdc siebel', $connectionType)">
								<xsl:variable name="divDisplayValue">
									<xsl:choose>
										<xsl:when test="/root/env/param[@name='m_connection_tab'] = 'odbc'">
											<xsl:value-of select="'block'"/>
										</xsl:when>
										<xsl:otherwise>
											<xsl:value-of select="'none'"/>
										</xsl:otherwise>
									</xsl:choose>
								</xsl:variable>
		
								<div id="gen-signon-section" style="display: {$divDisplayValue}">
									<xsl:call-template name="gen-signon-section">
										<xsl:with-param name="form-read-only" select="$form-read-only"/>
										<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
										<xsl:with-param name="uid-pwd-checkboxes">true</xsl:with-param>
										<xsl:with-param name="connectionType" select="$connectionType"/> 
										<xsl:with-param name="wizard" select="'false'"/>
									</xsl:call-template>
								</div>
							</xsl:if>

							<xsl:if test="$connectionType = 'contributor' or $connectionType = 'contributorSeries7'">
								<xsl:call-template name="gen-contributor-section">
									<xsl:with-param name="form-read-only" select="$form-read-only"/>
										<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
											<xsl:with-param name="uid-pwd-checkboxes"><xsl:value-of select="'true'"/></xsl:with-param>
										<xsl:with-param name="connectionType" select="$connectionType"/>
									<xsl:with-param name="wizard" select="'true'"/>
								</xsl:call-template>
							</xsl:if>

							<xsl:if test="$connectionType = 'powercube'">
								<dcx:cubePassword specifyConnection="true"/>
							</xsl:if>

							<!-- test the connection section -->
							<div id="test_connection">	
								<lyt:layout title="IDS_PROP_CONN_TESTING" style="1" border="yes">
									<lyt:section>
										<dp:choice>
											<dp:section1>
												<a id="test_connection_link" href="javascript:doTest();">
													<xsl:text><xts:string id="IDS_PROP_CONN_TEST_CONNECTION"/></xsl:text>
												</a>
											</dp:section1>
										</dp:choice>
									</lyt:section>
								</lyt:layout>
							</div>
						</div>
						<dp:footer>
							<df:button df:id="IDS_OK" df:style="stack-down-save" utml:validate="true"/>
							<df:button df:id="IDS_CANCEL" df:style="stack-down" onclick="{$dc-confirm-cancel}"/>
						</dp:footer>
					</utml:form>

					<!-- if we're building a Cognos Finance connection and there aren't any namesapces defined, then show
					a warning dialog -->
					<xsl:if test="$connectionType = 'consolidation' and not(/root/namespaces/cm:queryResponse/cm:namespace)">
						<script language="javascript">
							alert('<xts:string id="IDS_PROP_CONN_FINANCE_NO_NAMESPACE_WARNING" encode="javascript"/>');
						</script>
					</xsl:if>
				</dp:page>
			</xsl:template>
			<dcx:isDatasourceSignon/>
		</xsl:stylesheet>
	</xts:block>
	<!--
	===============================================================================================
	 - display debug information
	===============================================================================================
	-->
	<xts:block id="debug" dependency="render_page" condition=".[/root/session/param[@name='debug']='1']" type="exec" mode="output" processor="XSLT" mandatory="false" mimeType="text/html">
		<!-- get the debug logic sheet -->
		<xts:logicsheet path="logicsheets/debuglogic.xslt"/>
		<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:dbg="http://developer.cognos.com/schemas/xts/logicsheets/xslt/debug/" exclude-result-prefixes="dbg">
			<xsl:output method="html" version="1.0" encoding="UTF-8" indent="no"/>
			<xsl:template match="/">
				<dbg:dumpxml select="/root"/>
			</xsl:template>
		</xsl:stylesheet>
	</xts:block>
</xts:morphlet>