analytics/templates/ps/logicsheets/presentation/dialog/connections.xslt

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

    IBM Cognos Products: ps

    (C) Copyright IBM Corp. 2005, 2020

    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).
-->
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
	xmlns:lyt="http://developer.cognos.com/schemas/xts/logicsheets/xslt/presentation/layout/"
	xmlns:dcx="http://developer.cognos.com/schemas/xts/logicsheets/xslt/presentation/dialog/connections/1/"
	xmlns:dp="http://developer.cognos.com/schemas/xts/logicsheets/xslt/presentation/dialog/presentation/"
	xmlns:utml="http://developer.cognos.com/schemas/xts/logicsheet/xslt/formlogic/"
	xmlns:xts="http://developer.cognos.com/schemas/xts/"
	xmlns:out="dummy-uri" xmlns:xtsext="xalan://com.cognos.xts.ext.XTSExt"
	xmlns:dt="http://developer.cognos.com/schemas/xts/logicsheets/xslt/presentation/dialog/templates/"
	xmlns:cm="http://developer.cognos.com/schemas/xts-cm/1/"
	xmlns:cms="http://developer.cognos.com/schemas/xts/logic-sheet/xslt/cms/1/"
	xmlns:pf="http://developer.cognos.com/schemas/xts/pf"
	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:send="http://developer.cognos.com/schemas/xts/logic-sheet/xslt/brl/1/"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns:x="x"
	exclude-result-prefixes="lyt dt dp cm utml xts cms pf cf cp send x xsi">
	<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="no"/>
	<xsl:namespace-alias stylesheet-prefix="out" result-prefix="xsl"/>
	<!-- Variable containing this logicsheet's namespace uri. -->
	<xsl:variable name="dcx-namespace-uri" select="'http://developer.cognos.com/schemas/xts/logicsheets/xslt/presentation/dialog/connections/1/'"/>


<!--

The following parameter field should keep their names unchanged.
Transformer is using them to pass in their values.

	m_p_defaultName
	m_p_defaultDescription
	m_p_defaultScreenTip
	m_cube_password
	cube_password_checkbox
	m_connection_cache_size
	m_connection_windows_cube
	m_connection_unix_cube

	m_connection_type: type of the connection.

	m_authentication is used to get the authentication provided by Transformer. it can be none or namespace.
	m_transformer_namespace: provided by Transformer to set which namespace should be selected. It contains the namespace searchPath.
-->

<!-- 	Template that will generate a credential -->

	<xsl:template match="dcx:genCredentialTemplate">
		<out:template name="dcx:genCredentials">
			<out:param name="username"/>
			<out:param name="password"/>
			<out:param name="passwordEncrypted"/>
			<out:param name="cubePassword"/>
			<out:param name="cubePasswordEncrypted"/>
			<out:param name="namespace"/>

			<xts:encrypt>
				<xts:param name="provider">cognos.cam</xts:param>
				<xts:param name="source">&lt;credential&gt;<xsl:text/>
					<out:if test="$namespace != ''">
						<xsl:text/>&lt;namespace&gt;<out:value-of select="xtsext:xmlencode(string($namespace))"/>&lt;/namespace&gt;<xsl:text/>
					</out:if>
					<out:if test="$username!=''">
						<xsl:text/>&lt;username&gt;<out:value-of select="xtsext:xmlencode(string($username))"/>&lt;/username&gt;<xsl:text/>
					</out:if>
					<out:if test="$password!=''">
						<xsl:text/>&lt;password&gt;<xsl:text/>
						<xts:transform name="XMLEncode">
							<out:choose>
								<out:when test="$passwordEncrypted = 'true'">
									<xts:decrypt>
										<xts:param name="encode">xml</xts:param>
										<xts:param name="provider">cognos.cam</xts:param>
										<xts:param name="source"><out:value-of select="$password"/></xts:param>
									</xts:decrypt>
								</out:when>
								<out:otherwise><out:value-of select="$password"/></out:otherwise>
							</out:choose>
						</xts:transform>
						<xsl:text/>&lt;/password&gt;<xsl:text/>
					</out:if>
					<out:if test="$cubePassword!=''">
						<xsl:text/>&lt;cubePassword&gt;<xsl:text/>
						<xts:transform name="XMLEncode">
							<out:choose>
								<out:when test="$cubePasswordEncrypted = 'true'">
									<xts:decrypt>
										<xts:param name="encode">xml</xts:param>
										<xts:param name="provider">cognos.cam</xts:param>
										<xts:param name="source"><out:value-of select="$cubePassword"/></xts:param>
									</xts:decrypt>
								</out:when>
								<out:otherwise><out:value-of select="$cubePassword"/></out:otherwise>
							</out:choose>
						</xts:transform>
						<xsl:text/>&lt;/cubePassword&gt;<xsl:text/>
					</out:if>
				<xsl:text/>&lt;/credential&gt;</xts:param>
			</xts:encrypt>
		</out:template>
	</xsl:template>

	<!--
		Set of standard variables when saving a data source or connection
	-->
	<xsl:template match="dcx:savePasswordVars">
		<out:variable name="password">
			<!-- **** NOTE: Any change to the following conditions should also affect the 'passwordEncrypted' variable -->
			<out:choose>
				<!-- if the password checkbox isn't checked, then don't save a password -->
				<out:when test="not(key('env-param','m_connection_use_pword')) and key('env-param','m_connection_type')!='sap' and key('env-param','m_connection_type')!='json' and key('env-param','m_connection_type')!='sapR3' and key('env-param','m_connection_type')!='sapECC' and key('env-param','m_connection_type')!='other'"/>
				<out:when test="key('env-param', 'passwordEncrypted') != ''">
					<out:value-of select="key('env-param', 'passwordEncrypted')"/>
				</out:when>
				<out:otherwise>
					<out:value-of select="key('env-param', 'm_connection_password')"/>
				</out:otherwise>
			</out:choose>
		</out:variable>

		<out:variable name="passwordEncrypted" select="(key('env-param','m_connection_use_pword') or key('env-param','m_connection_type')='sap' or key('env-param','m_connection_type')='json' or key('env-param','m_connection_type')='sapR3' or key('env-param','m_connection_type')='sapECC' or key('env-param','m_connection_type')='other') and (key('env-param', 'passwordEncrypted') != '' or key('env-param', 'm_connection_password')[@format='encrypted'])"/>

		<out:variable name="cubePassword">
			<!-- **** NOTE: Any change to the following conditions should also affect the 'cubePasswordEncrypted' variable -->
			<out:choose>
				<!-- if the cube password checkbox isn't checked, then don't save a cube password -->
				<out:when test="not(key('env-param','cube_password_checkbox'))"/>
				<out:when test="key('env-param', 'cubePasswordEncrypted') != ''">
					<out:value-of select="key('env-param', 'cubePasswordEncrypted')"/>
				</out:when>
				<out:otherwise>
					<out:value-of select="key('env-param', 'm_cube_password')"/>
				</out:otherwise>
			</out:choose>
		</out:variable>

		<out:variable name="cubePasswordEncrypted" select="key('env-param','cube_password_checkbox') and (key('env-param', 'cubePasswordEncrypted') != '' or key('env-param', 'm_cube_password')[@format='encrypted'])"/>
		<out:variable name="proxyPasswordEncrypted" select="key('env-param', 'm_connection_proxy_password')[@format='encrypted']"/>
	</xsl:template>


	<!--
		Set of standard variables used when testing a connection
	-->
	<xsl:template match="dcx:testDataSourceVars">
		<out:variable name="useSignonInfo" select="/root/env/param[@name='pageitem'] and /root/env/param[@name='test_using']='signon'"/>
		<out:variable name="isPowerCube" select="contains(key('env-param','m_p_connectionString'),';LOCAL;PC;')"/>

		<out:variable name="usedNamespace">
			<out:choose>
				<out:when test="not($isPowerCube)"><out:value-of select="key('env-param', 'm_p_credentialNamespaces')"/></out:when>
				<out:otherwise>
					<out:choose>
						<out:when test="key('env-param', 'm_p_test_credentialNamespaces')!='' and key('env-param', 'm_p_test_credentialNamespaces')!='none'"><out:value-of select="key('env-param','m_p_test_credentialNamespaces')"/></out:when>
						<out:otherwise><out:value-of select="key('env-param','m_p_credentialNamespaces')"/></out:otherwise>
					</out:choose>
				</out:otherwise>
			</out:choose>
		</out:variable>

		<!-- username to use for the test -->
		<out:variable name="username">
			<out:choose>
				<!-- only get the username from the credential if we're not dealing with a powercube -->
				<out:when test="$useSignonInfo and not($isPowerCube)">
					<out:value-of select="/root/decryptedCredential/credential/username"/>
				</out:when>
				<out:otherwise>
					<out:value-of select="/root/env/param[@name='m_connection_userid']"/>
				</out:otherwise>
			</out:choose>
		</out:variable>

		<!-- password to use for the test -->
		<out:variable name="password">
			<!-- **** NOTE: Any change to the following conditions should also affect the 'passwordEncrypted' variable -->
			<out:choose>
				<!-- only get the password from the credential if we're not dealing with a powercube -->
				<out:when test="$useSignonInfo and not($isPowerCube)">
					<out:value-of select="/root/decryptedCredential/credential/password"/>
				</out:when>
				<out:when test="key('env-param', 'passwordEncrypted') != ''">
					<out:value-of select="key('env-param', 'passwordEncrypted')"/>
				</out:when>
			</out:choose>
		</out:variable>

		<!-- if we're not using the signon, or we're dealing with a powercube then the password we're using is already encrypted -->
		<out:variable name="passwordEncrypted" select="not($useSignonInfo and not($isPowerCube))"/>

		<!-- cubePassword to use for the test -->
		<out:variable name="cubePassword">
			<!-- **** NOTE: Any change to the following conditions should also affect the 'cubePasswordEncrypted' variable -->
			<out:choose>
				<out:when test="$useSignonInfo and $isPowerCube">
					<out:value-of select="/root/decryptedCredential/credential/cubePassword"/>
				</out:when>
				<out:when test="key('env-param','cubePasswordEncrypted')!=''">
					<out:value-of select="key('env-param','cubePasswordEncrypted')"/>
				</out:when>
			</out:choose>
		</out:variable>

		<!-- if we're not using the signon, then the password we're using is already encrypted -->
		<out:variable name="cubePasswordEncrypted" select="not($useSignonInfo and $isPowerCube)"/>
	</xsl:template>

	<!-- javascript function to check all the fields of connection for the reserved character ';' -->
	<xsl:template match="dcx:checkReservedChar">
		function checkReservedChar(obj, label)
		{
			obj.value = trim(obj.value);
			if (obj.value != '' &amp;&amp; obj.value.indexOf(';') != -1 )
			{
				<out:variable name="reservedErr">
					<xts:string id="IDS_ERR_RESERVED_CHAR" encode="javascript">
						<xts:param name="field">" + label + "</xts:param>
					</xts:string>
				</out:variable>
				window.alert("<out:value-of select="normalize-space($reservedErr)"/>");
				obj.focus();
				return false;
			}

			return true;
		}

		function checkInvalidChar(obj, label, str)
		{
			obj.value = trim(obj.value);
			if (obj.value != '' &amp;&amp; obj.value.indexOf(str) != -1 )
			{
				<out:variable name="invalidErr">
					<xts:string id="IDS_ERR_INVALID_CHAR" encode="javascript">
						<xts:param name="field">" + label + "</xts:param>
						<xts:param name="str">" + str + "</xts:param>
					</xts:string>
				</out:variable>
				window.alert("<out:value-of select="normalize-space($invalidErr)"/>");
				obj.focus();
				return false;
			}
			return true;
		}


		function checkMandatoryStartingChar(obj, label, str)
		{
			obj.value = trim(obj.value);
			if (obj.value != '' &amp;&amp; obj.value.indexOf(str) != 0 )
			{

				<out:variable name="missingErr">
					<xts:string id="IDS_ERR_MISSING_CHAR" encode="javascript">
						<xts:param name="field">" + label + "</xts:param>
						<xts:param name="str">" + str + "</xts:param>
					</xts:string>
				</out:variable>
				window.alert("<out:value-of select="normalize-space($missingErr)"/>");
				obj.focus();
				return false;
			}
			return true;
		}
	</xsl:template>

	<xsl:template match="dcx:connectionTemplates">

			<out:template name="dcx-gen-timeouts">
				<out:param name="form-read-only"/>
				<out:param name="utml-form-name"/>
				<lyt:layout style="1" title="IDS_SELECT_CONNECT_TIMEOUTS" border="yes" intro="IDS_SELECT_CONNECT_TIMEOUTS_HINT">
					<lyt:section>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_connect_time">
								<xts:string id="IDS_SELECT_CONNECT_TIME"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_connect_time" size="10" value="0" id="ctrl_m_connection_connect_time"/>
							</dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_reply_time">
								<xts:string id="IDS_SELECT_CONNECT_REPLY"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_reply_time" size="10" value="0" id="ctrl_m_connection_reply_time"/>
							</dp:section2>
						</dp:input>
					</lyt:section>
				</lyt:layout>
			</out:template>

			<out:template name="dcx-db2-odbc-template">
				<out:param name="form-read-only"/>
				<out:param name="utml-form-name"/>
				<lyt:layout style="1">
					<lyt:section>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_database">
								<out:choose>
									<out:when test="key('env-param','m_connection_type') = 'db2'">
										<xts:string id="IDS_SELECT_CONNECT_DB2_DATABASE"/>
									</out:when>
									<out:otherwise>
										<xts:string id="IDS_SELECT_CONNECT_ODBC_DATASOURCE"/>
									</out:otherwise>
								</out:choose>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_database" size="53" id="ctrl_m_connection_database"/>
                            </dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_string">
								<out:choose>
									<out:when test="key('env-param','m_connection_type') = 'db2'">
										<xts:string id="IDS_SELECT_CONNECT_DB2_CONNECTSTRING"/>
									</out:when>
									<out:otherwise>
										<xts:string id="IDS_SELECT_CONNECT_ODBC_CONNECTSTRING"/>
									</out:otherwise>
								</out:choose>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_string" size="53" id="ctrl_m_connection_string"/>
							</dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_colseq">
								<xts:string id="IDS_SELECT_CONNECT_COLSEQ"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_colseq" size="53" id="ctrl_m_connection_colseq"/>
							</dp:section2>
						</dp:input>
						<dp:choice>
							<dp:section1>
								<utml:input type="checkbox" name="m_connection_use_async" id="ctrl_m_connection_use_async"/>
							</dp:section1>
							<dp:section2 for="ctrl_m_connection_use_async">
								<xts:string id="IDS_SELECT_CONNECT_USE_ASYNC"/>
							</dp:section2>
						</dp:choice>
                        <out:if test="key('env-param','m_connection_type') = 'db2'">
							<dp:choice>
								<dp:section1>
									<utml:input type="checkbox" name="m_connection_trusted_context" id="ctrl_m_connection_trusted_context" onchange="updateTrustedContext()"/>
								</dp:section1>
								<dp:section2 for="ctrl_m_connection_trusted_context">
									<xts:string id="IDS_SELECT_CONNECT_TRUSTED_CONTEXT"/>
								</dp:section2>
								<dp:section3>
									<dp:input>
										<dp:section1 for="ctrl_m_connection_identity_propagation">
											<xts:string id="IDS_SELECT_CONNECT_IDENTITY_PROPAGATION"/>
										</dp:section1>
										<dp:section2>
											<utml:input type="text" name="m_connection_identity_propagation" size="45" id="ctrl_m_connection_identity_propagation"/>
										</dp:section2>
									</dp:input>
								</dp:section3>
							</dp:choice>
						</out:if>
						<out:if test="key('env-param','m_connection_type') = 'odbc' or key('env-param','m_connection_type') = 'composite' or key('env-param','m_connection_type') = 'virtualviewmanager' or key('env-param','m_connection_type') = 'openEdge' or key('env-param','m_connection_type') = 'sybaseIQ'">
							<dp:choice>
								<dp:section1>
									<utml:input type="checkbox" name="m_connection_odbc_access_mode" id="ctrl_m_connection_odbc_access_mode"/>
								</dp:section1>
								<dp:section2 for="ctrl_m_connection_odbc_access_mode">
									<xts:string id="IDS_SELECT_CONNECT_ACCESS_MODE"/>
								</dp:section2>
							</dp:choice>
						</out:if>
					</lyt:section>
				</lyt:layout>
				<out:call-template name="dcx-gen-timeouts">
					<out:with-param name="form-read-only" select="$form-read-only"/>
					<out:with-param name="utml-form-name" select="$utml-form-name"/>
				</out:call-template>
			</out:template>

			<out:template name="dcx-msas_xmla-template">
				<out:param name="form-read-only"/>
				<out:param name="utml-form-name"/>
				<lyt:layout style="1">
					<lyt:section>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_servername">
								<xts:string id="IDS_SELECT_CONNECT_SERVER_URL"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_servername" size="53" id="ctrl_m_connection_servername"/>
							</dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_locale">
								<xts:string id="IDS_PROP_RUN_LANGUAGE"/>
							</dp:section1>
							<dp:section2>
								<!-- get the default language -->
								<out:variable name="default_locale">
									<out:choose>
										<out:when test="key('env-param','m_connection_locale') != ''">
											<out:value-of select="key('env-param','m_connection_locale')"/>
										</out:when>
										<out:otherwise>
											<out:value-of select="translate( $contentLocale, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', 'abcdefghijklmnopqrstuvwxyz' )"/>
										</out:otherwise>
									</out:choose>
								</out:variable>

								<utml:select size="1" name="m_connection_locale" utml:track="true" id="ctrl_m_connection_locale">
									<out:for-each select="/root/config/param[@name='locale']/locale[@type='contentLocale']">
										<utml:option>
											<out:if test="string(id)=$default_locale">
												<out:attribute name="selected">selected</out:attribute>
											</out:if>
											<utml:value><out:value-of select="id"/></utml:value>
											<out:value-of select="displayName"/>
										</utml:option>
									</out:for-each>
								</utml:select>
							</dp:section2>
						</dp:input>
					</lyt:section>
				</lyt:layout>
			</out:template>
			
			<out:template name="dcx-sql-template">
				<out:param name="form-read-only"/>
				<out:param name="utml-form-name"/>
				<lyt:layout style="1">
					<lyt:section>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_database">
								<xts:string id="IDS_SELECT_CONNECT_DATASOURCE"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_database" size="53" id="ctrl_m_connection_database"/>
							</dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 id="DatabaseConnection_ID">
								<xts:string id="IDS_SELECT_CONNECT_DATABASE_NAME"/>
							</dp:section1>
							<dp:section2>
								<utml:radio-group name="m_connection_sql_database_choice" utml:default-value="specified">
									<dp:choice aria-labelledby="DatabaseConnection_ID">
										<dp:section1>
											<utml:input type="radio" value="master" id="ctrl_m_connection_sql_database_choice_master"/>
										</dp:section1>
										<dp:section2 for="ctrl_m_connection_sql_database_choice_master">
											<xts:string id="IDS_SELECT_CONNECT_MASTER_DATABASE"/>
										</dp:section2>
										<dp:section1>
											<utml:input type="radio" value="specified" id="ctrl_m_connection_sql_database_choice_specified" aria-labelledby="lbl_m_connection_sql_database_choice_specified"/>
										</dp:section1>
										<dp:section2 id="lbl_m_connection_sql_database_choice_specified">
											<utml:input type="text" name="m_connection_sql_database_name" size="49" aria-labelledby="DatabaseConnection_ID"/>
										</dp:section2>
									</dp:choice>
								</utml:radio-group>
							</dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_sql_application">
								<xts:string id="IDS_SELECT_CONNECT_APPLICATION_NAME"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_sql_application" size="53" id="ctrl_m_connection_sql_application"/>
							</dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_colseq">
								<xts:string id="IDS_SELECT_CONNECT_COLSEQ"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_colseq" size="53" id="ctrl_m_connection_colseq"/>
							</dp:section2>
						</dp:input>
						<out:if test="datasources/datasource/supportsOptionalConnectionParameters='true'">
							<dp:input>
								<dp:section1>
									<dp:list>
										<dp:section>
											<dp:label for="ctrl_m_connection_optional_parameters"><xts:string  id="IDS_SELECT_CONNECT_OPTIONAL_CONNECTION_PARAMETERS"/></dp:label>
										</dp:section>
										<dp:section>
											<dp:hint wrap="wrap"><xts:string id="IDS_SELECT_CONNECT_OPTIONAL_CONNECTION_PARAMETERS_INTRODUCTION"/></dp:hint>
										</dp:section>
									</dp:list>
								</dp:section1>
								<dp:section2>
									<utml:input type="text" name="m_connection_optional_parameters" size="100" id="ctrl_m_connection_optional_parameters"/>
								</dp:section2>
							</dp:input>
						</out:if>
						<out:if test="contains(' sql2005 sql2008 sql2012-2014 ', concat(' ',key('env-param','m_connection_type'),' '))"> 
							<dp:input>
								<dp:section1 for="ctrl_m_connection_sql_marsconnection">
									<xts:string id="IDS_SELECT_CONNECT_MARSCONNECTION"/>
								</dp:section1>
								<dp:section2>
									<utml:select name="m_connection_sql_marsconnection" size="1" id="ctrl_m_connection_sql_marsconnection">
										<utml:default-value>NO</utml:default-value>
										<utml:option value="YES"><xts:string id="IDS_SELECT_CONNECT_MARSCONNECTION_YES"/></utml:option>
										<utml:option value="NO"><xts:string id="IDS_SELECT_CONNECT_MARSCONNECTION_NO"/></utml:option>
									</utml:select>
								</dp:section2>
							</dp:input>
						</out:if>
					</lyt:section>
				</lyt:layout>
			</out:template>

			<out:template name="dcx-oracle-template">
				<out:param name="form-read-only"/>
				<out:param name="utml-form-name"/>
				<lyt:layout style="1">
					<lyt:section>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_database">
								<xts:string id="IDS_SELECT_CONNECT_SQLNET_CONNECTSTRING"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_database" size="53" id="ctrl_m_connection_database"/>
							</dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_colseq">
								<xts:string id="IDS_SELECT_CONNECT_COLSEQ"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_colseq" size="53" id="ctrl_m_connection_colseq"/>
							</dp:section2>
						</dp:input>
					</lyt:section>
				</lyt:layout>
			</out:template>

			<out:template name="dcx-sybase-template">
				<out:param name="form-read-only"/>
				<out:param name="utml-form-name"/>
				<out:param name="connection-type"/>
				<lyt:layout style="1">
					<lyt:section>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_database">
								<xts:string id="IDS_SELECT_CONNECT_SYBASE_SERVER"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_database" size="53" id="ctrl_m_connection_database"/>
							</dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 id="sybaseDatabaseName_ID">
								<xts:string id="IDS_SELECT_CONNECT_SYBASE_DATABASE_NAME"/>
							</dp:section1>
							<dp:section2>
								<utml:radio-group name="m_connection_sybase_database_choice" utml:default-value="specified">
									<dp:choice aria-labelledby="sybaseDatabaseName_ID">
										<dp:section1>
											<utml:input type="radio" value="master" id="ctrl_m_connection_sybase_database_choice_master"/>
										</dp:section1>
										<dp:section2 for="ctrl_m_connection_sybase_database_choice_master">
											<xts:string id="IDS_SELECT_CONNECT_SYBASE_MASTER_DATABASE"/>
										</dp:section2>
										<dp:section1>
											<utml:input type="radio" value="specified">
                                                <out:attribute name="aria-label">
                                                    <xts:string id="IDS_SELECT_CONNECT_SYBASE_SPECIFY_DATABASE_NAME"/>
                                                </out:attribute>
                                            </utml:input>
										</dp:section1>
										<dp:section2>
											<utml:input type="text" name="m_connection_sybase_database_name" size="49">
                                                <out:attribute name="aria-label">
                                                    <xts:string id="IDS_SELECT_CONNECT_SYBASE_DATABASE_NAME"/>
                                                </out:attribute>
                                            </utml:input>
										</dp:section2>
									</dp:choice>
								</utml:radio-group>
							</dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_sybase_application">
								<xts:string id="IDS_SELECT_CONNECT_SYBASE_APPLICATION"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_sybase_application" size="53" id="ctrl_m_connection_sybase_application"/>
							</dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_colseq">
								<xts:string id="IDS_SELECT_CONNECT_COLSEQ"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_colseq" size="53" id="ctrl_m_connection_colseq"/>
							</dp:section2>
						</dp:input>
						<out:choose>
							<out:when test="$connection-type = 'sybase'">
								<dp:input>
									<dp:section1 for="ctrl_m_connection_packet">
										<xts:string id="IDS_SELECT_CONNECT_SYBASE_PACKET"/>
									</dp:section1>
									<dp:section2>
										<utml:input type="text" name="m_connection_packet" size="10" value="512" id="ctrl_m_connection_packet"/>
									</dp:section2>
								</dp:input>
							</out:when>
							<out:when test="$connection-type = 'sybase_ct15'">
								<dp:input>
									<dp:section1 for="ctrl_m_connection_packet">
										<xts:string id="IDS_SELECT_CONNECT_SYBASE_PACKET"/>
									</dp:section1>
									<dp:section2>
										<utml:input type="text" name="m_connection_packet" size="10" value="2048" id="ctrl_m_connection_packet"/>
									</dp:section2>
								</dp:input>
							</out:when>
						</out:choose>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_sybase_async">
								<xts:string id="IDS_SELECT_CONNECT_SYBASE_ASYNC"/>
							</dp:section1>
							<dp:section2>
								<utml:select name="m_connection_sybase_async" size="1" id="ctrl_m_connection_sybase_async">
									<utml:default-value>1</utml:default-value>
									<utml:option value="0"><xts:string id="IDS_SELECT_CONNECT_SYBASE_ASYNC0"/></utml:option>
									<utml:option value="1"><xts:string id="IDS_SELECT_CONNECT_SYBASE_ASYNC1"/></utml:option>
									<utml:option value="2"><xts:string id="IDS_SELECT_CONNECT_SYBASE_ASYNC2"/></utml:option>
									<utml:option value="3"><xts:string id="IDS_SELECT_CONNECT_SYBASE_ASYNC3"/></utml:option>
								</utml:select>
							</dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_polling">
								<xts:string id="IDS_SELECT_CONNECT_SYBASE_POLLING"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_polling" size="10" value="100" id="ctrl_m_connection_polling"/>
							</dp:section2>
						</dp:input>
					</lyt:section>
				</lyt:layout>
				<out:call-template name="dcx-gen-timeouts">
					<out:with-param name="form-read-only" select="$form-read-only"/>
					<out:with-param name="utml-form-name" select="$utml-form-name"/>
				</out:call-template>
			</out:template>

			<out:template name="dcx-consolidation-template">
				<out:param name="form-read-only"/>
				<out:param name="utml-form-name"/>
				<lyt:layout style="1">
					<lyt:section>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_servername">
								<xts:string id="IDS_SELECT_CONNECT_DATASOURCE"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_servername" size="53" id="ctrl_m_connection_servername"/>
							</dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_port">
								<xts:string id="IDS_SELECT_CONNECT_PORTNUMBER"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_port" value="8800" size="10" id="ctrl_m_connection_port"/>
							</dp:section2>
						</dp:input>
					</lyt:section>
				</lyt:layout>
			</out:template>

			<out:template name="dcx-contributorSeries7-template">
				<out:param name="form-read-only"/>
				<out:param name="utml-form-name"/>
				<script language="javascript">
					function checkPADIDValue()
						{
							frm = document.pform;
							var val = frm.m_connection_padid.value ;
							val = trim(val);
							if (val.length > 0) {
								//Here enable the namespace.
								<out:if test="key('env-param','m_connection_type') = 'contributorSeries7' and not(/root/namespaces/cm:queryResponse/cm:namespace)">
									alert('<xts:string id="IDS_PROP_CONN_PLANNING_NO_NAMESPACE_WARNING" encode="javascript"/>');
									frm.m_p_credentialNamespaces.disabled = true;
									return false;
								</out:if>
								frm.m_p_credentialNamespaces.disabled = false;
							} else {
								//Here disable the namespace.
								frm.m_p_credentialNamespaces.disabled = true;
							}
						}
				</script>
				<lyt:layout style="1">
					<lyt:section>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_servername">
								<xts:string id="IDS_SELECT_CONNECT_DATASOURCE"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_servername" size="53" id="ctrl_m_connection_servername"/>
                            </dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_port">
								<xts:string id="IDS_SELECT_CONNECT_PORTNUMBER"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_port" value="8800" size="10" id="ctrl_m_connection_port"/>
							</dp:section2>
						</dp:input>
							<dp:list>
								<dp:section for="ctrl_m_connection_padid">
									<dp:label><xts:string  id="IDS_SELECT_CONNECT_CONTRIBUTOR_PADID"/></dp:label>
								</dp:section>
								<dp:section>
										<dp:hint wrap="wrap"><xts:string id="IDS_PROP_CONN_PLANNING_PADID_DESCRIPTION"/></dp:hint>
								</dp:section>
								<dp:section>
									<utml:input type="text" name="m_connection_padid" size="53" onkeyup="checkPADIDValue()" id="ctrl_m_connection_padid"/>
                                </dp:section>
							</dp:list>
					</lyt:section>
				</lyt:layout>
			</out:template>

			<out:template name="dcx-powercube-template">
				<out:param name="form-read-only"/>
				<out:param name="utml-form-name"/>
				<lyt:layout style="1">
					<lyt:section>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_cache_size">
								<xts:string id="IDS_SELECT_CONNECT_POWERCUBE_CACHE_SIZE"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_cache_size" size="53" value="" onblur="checkPositiveIntegerDefault(document.pform.m_connection_cache_size, '')" id="ctrl_m_connection_cache_size"/>
							</dp:section2>
						</dp:input>
					</lyt:section>
				</lyt:layout>
				<lyt:layout style="1" title="IDS_SELECT_CONNECT_POWERCUBE_LOCATION" border="yes" intro="IDS_SELECT_CONNECT_POWERCUBE_LOCATION_INTRO">
					<lyt:section>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_windows_cube">
								<xts:string id="IDS_SELECT_CONNECT_POWERCUBE_WIN_LOCATION"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_windows_cube" size="53" id="ctrl_m_connection_windows_cube"/>
							</dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_unix_cube">
								<xts:string id="IDS_SELECT_CONNECT_POWERCUBE_UNIX_LOCATION"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_unix_cube" size="53" id="ctrl_m_connection_unix_cube"/>
							</dp:section2>
						</dp:input>
					</lyt:section>
				</lyt:layout>
			</out:template>

			<out:template name="dcx-msanalysis2005-template">
				<out:param name="form-read-only"/>
				<out:param name="utml-form-name"/>
				<lyt:layout style="1">
					<lyt:section>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_servername">
								<xts:string id="IDS_SELECT_CONNECT_DATASOURCE"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_servername" size="53" id="ctrl_m_connection_servername"/>
							</dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_namedinstance">
								<xts:string id="IDS_SELECT_CONNECT_MSANALYSIS2005_NAMED_INSTANCE"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_namedinstance" size="53" id="ctrl_m_connection_namedinstance"/>
							</dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_locale">
								<xts:string id="IDS_PROP_RUN_LANGUAGE"/>
							</dp:section1>
							<dp:section2>
								<!-- get the default language -->
								<out:variable name="default_locale">
									<out:choose>
										<out:when test="key('env-param','m_connection_locale') != ''">
											<out:value-of select="key('env-param','m_connection_locale')"/>
										</out:when>
										<out:otherwise>
											<out:value-of select="translate( $contentLocale, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', 'abcdefghijklmnopqrstuvwxyz' )"/>
										</out:otherwise>
									</out:choose>
								</out:variable>

								<utml:select size="1" name="m_connection_locale" utml:track="true" id="ctrl_m_connection_locale">
									<out:for-each select="/root/config/param[@name='locale']/locale[@type='contentLocale']">
										<utml:option>
											<out:if test="string(id)=$default_locale">
												<out:attribute name="selected">selected</out:attribute>
											</out:if>
											<utml:value><out:value-of select="id"/></utml:value>
											<out:value-of select="displayName"/>
										</utml:option>
									</out:for-each>
								</utml:select>
							</dp:section2>
						</dp:input>
					</lyt:section>
				</lyt:layout>
			</out:template>

			<out:template name="dcx-db2olap-template">
				<out:param name="form-read-only"/>
				<out:param name="utml-form-name"/>
				<lyt:layout style="1">
					<lyt:section>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_servername">
								<xts:string id="IDS_SELECT_CONNECT_DATASOURCE"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_servername" size="53" id="ctrl_m_connection_servername"/>
							</dp:section2>
						</dp:input>
					</lyt:section>
				</lyt:layout>
			</out:template>

			<out:template name="dcx-tm1R-template">
				<out:param name="form-read-only"/>
				<out:param name="utml-form-name"/>
				<lyt:layout style="1">
					<lyt:section>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_hostname">
								<xts:string id="IDS_SELECT_CONNECT_HOST_TMR"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_hostname" size="53" id="ctrl_m_connection_hostname"/>
                            </dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_tm1port">
								<xts:string id="IDS_SELECT_CONNECT_PORT_TMR"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_tm1port" size="10" id="ctrl_m_connection_tm1port"/>
							</dp:section2>
						</dp:input>
						<dp:choice>
							<dp:section1>
								<utml:input type="checkbox" name="m_connection_use_ssl" id="ctrl_m_connection_use_ssl"/>
							</dp:section1>
							<dp:section2 for="ctrl_m_connection_use_ssl">
								<xts:string id="IDS_SELECT_CONNECT_PROTOCOL_TMR"/>
							</dp:section2>
						</dp:choice>
					</lyt:section>
				</lyt:layout>
			</out:template>

			<out:template name="dcx-tm1-template">
				<out:param name="form-read-only"/>
				<out:param name="utml-form-name"/>
				<lyt:layout style="1">
					<lyt:section>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_hostname">
								<xts:string id="IDS_SELECT_CONNECT_HOST_TM"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_hostname" size="53" id="ctrl_m_connection_hostname"/>
                            </dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_servername">
								<xts:string id="IDS_SELECT_CONNECT_SERVER_TM"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_servername" size="53" id="ctrl_m_connection_servername"/>
							</dp:section2>
						</dp:input>
					</lyt:section>
				</lyt:layout>
			</out:template>
			
			<out:template name="dcx-odata-template">
				<out:param name="form-read-only"/>
				<out:param name="utml-form-name"/>
				<lyt:layout style="1">
					<lyt:section>
						<dp:input>
							<dp:section1 for="m_connection_service_root_URI">
								<xts:string id="IDS_SELECT_CONNECT_SERVICE_ROOT_URI"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_service_root_URI" size="53" id="ctrl_m_connection_service_root_URI"/>
                            </dp:section2>
						</dp:input>
					</lyt:section>
				</lyt:layout>
			</out:template>

			<out:template name="dcx-json-template">
				<out:param name="form-read-only"/>
				<out:param name="utml-form-name"/>
				<out:variable name="dcx-http-method">
					<out:choose>
						<out:when test="key('env-param','m_connection_http_method') != ''">
							<out:value-of select="string(key('env-param','m_connection_http_method'))"/>
						</out:when>
						<out:when test="key('env-param','m_p_connectionString') != ''">	
							<out:value-of select="substring-before(substring-after(string(key('env-param','m_p_connectionString')), ';METHOD='), ';')"/>
						</out:when>
						<out:otherwise>
							<out:value-of select="'GET'"/>
						</out:otherwise>
					</out:choose>
				</out:variable>
                                <script language="javascript">
					var dataSourceList = new Array();
					var dataSource;

					var oldOnload = window.onload;
					window.onload = function() {
						if (oldOnload) {
							oldOnload();
						}
						initJSONDialog();
                                        }
                                    
					function initJSONDialog() 
					{	
						var f = document.pform;
						if (f) {
								// Initialize the default property list for supported JSON data sources.
								initJSONDataSources();
								var i = 0;
								var connSubType = f.m_connection_subType;
								var connTypeSelectBox = f.m_json_connection_type;
								var connectionString = f.m_p_connectionString.value;
								// debugger;
							if (connectionString == '') {
								// This indicates we are creating a new data source. Initialize all the values to default.
								i = 1;
								populateJSONDialogDefaultValues();
							} else if (connSubType != undefined &amp;&amp; connSubType != ''){
								// This is the case where we opened a saved connection. We will set the connection type based on
									// its code and leave the rest of the property untouched. They were set in connections.js.
									i = 2;
									populateJSONDialogFromConnString(connectionString);
							} else if (connSubType == undefined) {
									// This is the case when we are updating the authentication type select box  
									// or the JSON connection type select box.
									i = 3;
									updateJSONDialogAuthentication();
							}
						}
					}

					function initJSONDataSources()
					{
						<out:for-each select="/root/datasources/datasource/supportedDataSources/supportedDataSource">
                                                        var dataSource = getDataSource('<out:value-of select="name"/>', '<out:value-of select="subType"/>');
							<out:for-each select="authenticationTypes/authenticationType">
								dataSource.authenticationTypes[<out:value-of select="(position() - 1)"/>] =
									getAuthenticationType(
										'<out:value-of select="type"/>',
										'<out:value-of select="temporaryTokenEndpoint"/>',
										'<out:value-of select="authorizationEndpoint"/>',
										'<out:value-of select="tokenEndpoint"/>',
										'<out:value-of select="scope"/>'
									);
										// Also keep track of the default auth type id (starts from 0).
										var isDefault = '<out:value-of select="./@isDefault"/>';
										if (isDefault == "true") {
												dataSource.defaultAuthTypeID = <out:value-of select="(position() - 1)"/>;
										}
							</out:for-each>
							dataSourceList[<out:value-of select="(position() - 1)"/>] = dataSource;
						</out:for-each>
					}

					function populateJSONDialogDefaultValues() {
						var f = document.pform;
						if (f) {
							var dataSource = dataSourceList[0];
							populateAuthenticationTypes(dataSource);
							setDefaultAuthType(dataSource);
							// setAuthEndpointsDefaultValues(f, dataSource);
							f.m_json_connection_type.value = dataSource.name;
								f.m_connection_subType = dataSource.subType;
								f.m_p_connectionString.value = ' '; // Modify connection string so as not to be stuck in an eternal loop.
								changeAuthenticationType();
						}
					}

					function populateJSONDialogFromConnString(connectionString) {
							var f = document.pform;
							if (f) {
									for (var i = 0; i &lt; dataSourceList.length; i++) {
											var dataSource = dataSourceList[i];
											if (f.m_connection_subType == dataSource.subType) {
													// set the value of JSON Type select box to the supported dataSource name (eg. Cloudant, CouchDB, Twitter etc...)
													f.m_json_connection_type.value = dataSource.name;
													// populate the auth select box with the appropriate authentication types ("None", "Basic", "Auth1.0" etc..)
													// for the specific JSON subtype (i.e. Cloudant, CouchDB, Twitter etc...)
													populateAuthenticationTypes(dataSource);
													// We need to reset the value of "m_connection_authentication_type" select box again,
													// because we have populated it dynamically.
													f.m_connection_authentication_type.value = getField(connectionString, ';AUTHENTICATION_TYPE=');                                 
											}
									}
							}
							// Repopulate the list and set the appropriate values once again so
							// as the "gen-create-signon" to be updated. The first time it was created first and then
							// we were able to modify dynamically the contents of the authList + textboxs without being
							// able to erase them in the first place from the generated html code.
							changeAuthenticationType();
							setPredifinedAuthEndpointsDefaultValues(f, dataSource, connectionString);
					}

					function updateJSONDialogAuthentication() {
						var f = document.pform;
						if (f) {
							for (var i = 0; i &lt; dataSourceList.length; i++) {
									var dataSource = dataSourceList[i];
									if (f.m_json_connection_type.value == dataSource.name) {
											f.m_connection_subType = dataSource.subType;
											populateAuthenticationTypes(dataSource);
											// The "m_connection_auth_type_keep_state" hidden input element is used in order to cache "authentication_type" value.
											// This is value is cached either by changing the value of the authentication type select box,
											// or by updating the value of the JSON connection type select box. For the later case, this hidden input element has
											// been already initialized with the default authentication value for the new type of JSON connection.
											document.getElementById("ctrl_m_connection_authentication_type").value = document.pform.m_connection_auth_type_keep_state.value
											if (f.m_trace_subtype_change.value == "true") {
													// Force a second update so as to update the signon
													// and authentication forms.
													changeAuthenticationType();
											}
											setAuthEndpointsDefaultValues(f, dataSource);
											break;
								}
							}
						}
					}
                                        
					function updateJSONType() {
						// This function is triggered whenever the user changes the type of the JSON connection through
						// the corresponding select box.
						var f = document.pform;
						if (f) {								
							for (var i = 0; i &lt; dataSourceList.length; i = i + 1) {
								dataSource = dataSourceList[i];
								if (f.m_json_connection_type.value == dataSource.name) {
									f.m_connection_subType = dataSource.subType;
									f.m_connection_assembly.checked = false;
									// set auth select box value to the default authentication type we recommend to the users 
									// [e.g. Auth Types: {ApiKey, OAuth2} -> set value to OAuth2 because it is the default according to generateDatasourceMetadata.xslt]
									setDefaultAuthType(dataSource);
									// Keep state of the default auth type in a hidden input html element.
									f.m_connection_auth_type_keep_state.value = dataSource.authenticationTypes[dataSource.defaultAuthTypeID].type;
									f.m_trace_subtype_change.value = "true";
									break;
								}
							}
							
							f.submit();
						}
					}

                                        /////////////////////////////// UTILS FUNCTIONS /////////////////////////////////////////////
                                        
					function getDataSource(name, subType) {
						var dataSource = {};

						dataSource.name = name;
						dataSource.subType = subType;
						dataSource.authenticationTypes = new Array();
						// Also keep track of the default auth type id (starts from 0).
						dataSource.defaultAuthTypeID = -1;

						return dataSource;
					}
                                        
					function getAuthenticationType(type, temporaryTokenEndpoint, authorizationEndpoint, tokeEndpoint, scope) {
						var authenticationType = {};

						authenticationType.type = type;
						authenticationType.temporaryTokenEndpoint = temporaryTokenEndpoint;
						authenticationType.authorizationEndpoint = authorizationEndpoint;
						authenticationType.tokenEndpoint = tokeEndpoint;
						authenticationType.scope = scope;
						
						return authenticationType;
					}

					function populateAuthenticationTypes(dataSource) {
						var selectBox = document.getElementById("ctrl_m_connection_authentication_type");

						for (var i = 0; i &lt; dataSource.authenticationTypes.length; i++) {
							var authenticationType = dataSource.authenticationTypes[i];
							var option = document.createElement("option");
							option.text = authenticationType.type;
							option.value = authenticationType.type;
							selectBox.options.add(option);
						}
					}

					function setAuthEndpointsDefaultValues(f, dataSource) {
							var authType = f.m_connection_authentication_type.value;
							var authenticationTypes = dataSource.authenticationTypes;
							for (var j = 0; j &lt; authenticationTypes.length; j++) {
									var authenticationType = authenticationTypes[j];
									if (authenticationType.type == authType) {
											if (authType == 'OAuth1.0' &amp;&amp; f.m_connection_temporary_token_endpoint != undefined) {
													f.m_connection_temporary_token_endpoint.value = authenticationType.temporaryTokenEndpoint;
											}
											if (authType == 'OAuth1.0' || authType == 'OAuth2.0') {
													if (f.m_connection_authorization_endpoint != undefined) {
															f.m_connection_authorization_endpoint.value = authenticationType.authorizationEndpoint;
													}
													if (f.m_connection_token_endpoint != undefined) {
															f.m_connection_token_endpoint.value = authenticationType.tokenEndpoint;
													}
											}
											if (authType == 'OAuth2.0' &amp;&amp; f.m_connection_scope != undefined) {
													f.m_connection_scope.value = authenticationType.scope;
											}
											break;
									}
							}
					}

					function setPredifinedAuthEndpointsDefaultValues(f, dataSource, connectionString) {
							var authType = f.m_connection_authentication_type.value;
							if (authType == 'OAuth1.0' &amp;&amp; f.m_connection_temporary_token_endpoint != undefined) {
									f.m_connection_temporary_token_endpoint.value = getField(connectionString, ';TEMPORARY_TOKEN_ENDPOINT=');
							}
							if (authType == 'OAuth1.0' || authType == 'OAuth2.0') {
									if (f.m_connection_authorization_endpoint != undefined) {
											f.m_connection_authorization_endpoint.value = getField(connectionString, ';AUTHORIZATION_ENDPOINT=');
									}
									if (f.m_connection_token_endpoint != undefined) {
											f.m_connection_token_endpoint.value = getField(connectionString, ';TOKEN_ENDPOINT=');
									}                 
							}
							if (authType == 'OAuth2.0' &amp;&amp; f.m_connection_scope != undefined) {
									f.m_connection_scope.value = getField(connectionString, ';SCOPE=');
							}
					}
                                        
					function setDefaultAuthType(dataSource) {
							var selectBox = document.getElementById("ctrl_m_connection_authentication_type");
							selectBox.value = dataSource.authenticationTypes[dataSource.defaultAuthTypeID].type;
					}

					function checkURLFormat(obj)
					{
						if(obj.value.length >= 7) 
						{
							
							if (obj.value.length >= 8) 
							{
								var str = obj.value.substring(0,8).toLowerCase();
								if (str == "https://" || str == "file:///")
								{
									return true;
								}
							}
							var str = obj.value.substring(0,7).toLowerCase();
							if (str == "http://" || str == "file://" )
							{
								return true;
							}
								
						}
						<out:variable name="endpointFormatErr">
							<xts:string id="IDS_ERR_URL_FORMAT" encode="javascript"/>
						</out:variable>
						window.alert("<out:value-of select="($endpointFormatErr)"/>");
						obj.focus();
						return false;
					}

					function checkEndpointFormat(obj)
					{
						if(obj.value.length >= 7) 
						{
							
							if (obj.value.length >= 8) 
							{
								var str = obj.value.substring(0,8).toLowerCase();
								if (str == "https://")
								{
									return true;
								}
							}
							var str = obj.value.substring(0,7).toLowerCase();
							if (str == "http://")
							{
								return true;
							}
								
						}
						<out:variable name="urlFormatErr">
							<xts:string id="IDS_ERR_ENDPOINT_FORMAT" encode="javascript"/>
						</out:variable>
						window.alert("<out:value-of select="($urlFormatErr)"/>");
						obj.focus();
						return false;
					}
				</script>
				<lyt:layout style="1">
					<lyt:section>
						<dp:input>
							<dp:section1 for="m_json_connection_type">
								<xts:string id="IDS_PROP_CONN_TYPE"/>
							</dp:section1>
							<dp:section2>
								<utml:select name="m_json_connection_type" size="1" onchange="updateJSONType()" id="ctrl_m_json_connection_type">
									<out:for-each select="/root/datasources/datasource/supportedDataSources/supportedDataSource">
										<utml:option>
											<utml:value><out:value-of select="name"/></utml:value>
											<out:value-of select="name"/>
										</utml:option>
									</out:for-each>
								</utml:select>
							</dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 for="m_connection_url">
								<xts:string id="IDS_SELECT_CONNECT_URL"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_url" size="53" id="ctrl_m_connection_url"/>
                            </dp:section2>
						</dp:input>
						<dp:choice>
							<dp:section1>
								<utml:input type="checkbox" name="m_connection_assembly"  onclick="toggleAssemblyCheckbox()" id="ctrl_m_connection_assembly"/>
							</dp:section1>
							<dp:section2 for="m_json_connection_assembly">
								<xts:string id="IDS_SELECT_CONNECT_ASSEMBLY"/>
							</dp:section2>
						</dp:choice>
						<dp:input>
							<dp:section1 for="m_connection_schema">
								<xts:string id="IDS_SELECT_CONNECT_SCHEMA"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_schema" size="53" id="ctrl_m_connection_schema"/>
                            </dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 for="m_json_connection_http_method">
								<xts:string id="IDS_SELECT_CONNECT_HTTP_METHOD"/>
							</dp:section1>
							<dp:section2>
								<utml:select name="m_connection_http_method" size="1" utml:update="true" onchange="changeHttpMethod()" id="ctrl_m_connection_http_method">
									<utml:option value="GET">
										<xts:string id="IDS_SELECT_CONNECT_HTTP_GET"/>
									</utml:option>
									<utml:option value="POST">
										<xts:string id="IDS_SELECT_CONNECT_HTTP_POST"/>
									</utml:option>
								</utml:select>
							</dp:section2>
						</dp:input>
						<out:if test="$dcx-http-method='POST'">
							<dp:input>
								<dp:section1 for="m_json_connection_http_mime_type">
									<xts:string id="IDS_SELECT_CONNECT_HTTP_CONTENT_TYPE"/>
								</dp:section1>
								<dp:section2>
									<utml:select name="m_connection_http_mime_type" size="1" id="ctrl_m_connection_http_mime_type">
										<out:for-each select="/root/datasources/datasource/supportedMimeTypes/supportedMimeType">
											<utml:option>
												<utml:value><out:value-of select="name"/></utml:value>
												<out:value-of select="name"/>
											</utml:option>
										</out:for-each>
									</utml:select>
								</dp:section2>
							</dp:input>
							<dp:input>
								<dp:section1 for="m_connection_http_message_body">
									<xts:string id="IDS_SELECT_CONNECT_HTTP_MESSAGE_BODY"/>
								</dp:section1>
								<dp:section2>
									<utml:textarea name="m_connection_http_message_body" class="pTextarea" rows="20" cols="60" id="ctrl_m_connection_http_message_body"/>
								</dp:section2>
							</dp:input>
						</out:if>
						<dp:input>
							<dp:section1 for="m_json_connection_json_path">
								<xts:string id="IDS_SELECT_CONNECT_JSON_PATH"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_json_path" size="53" id="ctrl_m_connection_json_path"/>
                            </dp:section2>
						</dp:input>
						<script language="javascript">
							function changeHttpMethod()
							{
								document.pform.submit();
							}
						</script>
					</lyt:section>
				</lyt:layout>
			</out:template>

			<out:variable name="filePathName">
				<out:choose>
					<out:when test="key('env-param', 'm_connection_file')">
						<out:value-of select="key('env-param', 'm_connection_file')"/>
					</out:when>
					<out:otherwise>
						<out:value-of select="key('system-param', 'cognosNowCubeFileSuffix')"/>
					</out:otherwise>
				</out:choose>
			</out:variable>
			<out:template name="dcx-cognosnow-template">
				<out:param name="form-read-only"/>
				<out:param name="utml-form-name"/>
				<lyt:layout style="1">
					<lyt:section>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_servername">
								<xts:string id="IDS_SELECT_CONNECT_DATASOURCE"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_servername" size="53" id="ctrl_m_connection_servername"/>
							</dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_port">
								<xts:string id="IDS_SELECT_CONNECT_PORTNUMBER"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_port" value="8800" size="10" id="ctrl_m_connection_port"/>
							</dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_file">
								<xts:string id="IDS_SELECT_CONNECT_FILE_NAME_PATH"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_file" size="53" id="ctrl_m_connection_file">
									<out:attribute name="value"><out:value-of select="$filePathName"/></out:attribute>
								</utml:input>
							</dp:section2>
						</dp:input>
					</lyt:section>
				</lyt:layout>
			</out:template>

			<out:template name="dcx-informix-template">
				<out:param name="form-read-only"/>
				<out:param name="utml-form-name"/>
				<lyt:layout style="1">
					<lyt:section>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_database">
								<xts:string id="IDS_SELECT_CONNECT_INFORMIX_DATABASE"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_database" size="53" id="ctrl_m_connection_database"/>
							</dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_hostname">
								<xts:string id="IDS_SELECT_CONNECT_INFORMIX_HOSTNAME"/>
							</dp:section1>
							<dp:section2>
                                <utml:input type="text" name="m_connection_hostname" size="53" id="ctrl_m_connection_hostname"/>
							</dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_servername">
								<xts:string id="IDS_SELECT_CONNECT_INFORMIX_SERVERNAME"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_servername" size="53" id="ctrl_m_connection_servername"/>
							</dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_colseq">
								<xts:string id="IDS_SELECT_CONNECT_COLSEQ"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_colseq" size="53" id="ctrl_m_connection_colseq"/>
							</dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 id="informixService_ID">
								<xts:string id="IDS_SELECT_CONNECT_INFORMIX_SERVICE"/>
							</dp:section1>
							<dp:section2>
								<utml:radio-group name="m_connection_service" utml:default-value="specified">
									<dp:choice aria-labelledby="informixService_ID">
										<dp:section1>
											<utml:input type="radio" value="sqlexec" id="ctrl_m_connection_service_sqlexec"/>
										</dp:section1>
										<dp:section2 for="ctrl_m_connection_service_sqlexec">
											<xts:string id="IDS_SELECT_CONNECT_INFORMIX_SQLEXEC"/>
										</dp:section2>
										<dp:section1>
											<utml:input type="radio" value="sqlturbo" id="ctrl_m_connection_service_sqlturbo"/>
										</dp:section1>
										<dp:section2 for="ctrl_m_connection_service_sqlturbo">
											<xts:string id="IDS_SELECT_CONNECT_INFORMIX_SQLTURBO"/>
										</dp:section2>
										<dp:section1>
											<utml:input type="radio" value="specified" id="ctrl_m_connection_service_specified">
                                                <out:attribute name="aria-label">
                                                    <xts:string id="IDS_SELECT_CONNECT_INFORMIX_SPECIFY"/>
                                                </out:attribute>
                                            </utml:input>
										</dp:section1>
										<dp:section2>
											<utml:input type="text" name="m_connection_service_name" size="49">
                                                <out:attribute name="aria-label">
                                                    <xts:string id="IDS_SELECT_CONNECT_INFORMIX_SERVICE"/>
                                                </out:attribute>
                                            </utml:input>
										</dp:section2>
									</dp:choice>
								</utml:radio-group>
							</dp:section2>
						</dp:input>
					</lyt:section>
				</lyt:layout>
			</out:template>

			<out:template name="dcx-sapr3-template">
				<out:param name="form-read-only"/>
				<out:param name="utml-form-name"/>
					<script language="javascript">
					function checkLoadBalancing()
						{
							frm = document.pform;
							var val = frm.m_connection_use_loadbalancing.checked ;
							if (val == true)
							{
								frm.m_connection_use_loadbalancing_hidden.value = "true";
							}
							else
							{
								frm.m_connection_use_loadbalancing_hidden.value = "false";
							}
						}
				</script>

					<lyt:layout style="1">
						<lyt:section>
							<dp:input>
								<dp:section1 for="ctrl_m_connection_application_server">
									<xts:string id="IDS_SELECT_CONNECT_SAPR3_APPLICATION_SERVER"/>
								</dp:section1>
								<dp:section2>
									<utml:input type="text" name="m_connection_application_server" size="53" id="ctrl_m_connection_application_server"/>
								</dp:section2>
							</dp:input>
							<dp:input>
								<dp:section1 for="ctrl_m_connection_router_string">
									<xts:string id="IDS_SELECT_CONNECT_SAPR3_ROUTER_STRING"/>
								</dp:section1>
								<dp:section2>
									<utml:input type="text" name="m_connection_router_string" size="53" id="ctrl_m_connection_router_string"/>
								</dp:section2>
							</dp:input>
							<dp:input>
								<dp:section1 for="ctrl_m_connection_system_number">
									<xts:string id="IDS_SELECT_CONNECT_SAPR3_SYSTEM_NUMBER"/>
								</dp:section1>
								<dp:section2>
									<utml:input type="text" name="m_connection_system_number" size="20" id="ctrl_m_connection_system_number"/>
								</dp:section2>
							</dp:input>
							<dp:input>
								<dp:section1 for="ctrl_m_connection_client">
									<xts:string id="IDS_SELECT_CONNECT_SAPR3_CLIENT"/>
								</dp:section1>
								<dp:section2>
									<utml:input type="text" name="m_connection_client" value="0" size="10" id="ctrl_m_connection_client"/>
								</dp:section2>
							</dp:input>
							<dp:input>
								<dp:section1 for="ctrl_m_connection_language">
									<xts:string id="IDS_SELECT_CONNECT_SAPR3_LANG"/>
								</dp:section1>
								<dp:section2>
									<utml:input type="text" name="m_connection_language" value="EN" size="10" id="ctrl_m_connection_language"/>
								</dp:section2>
							</dp:input>
							<dp:input>
								<dp:section1 for="ctrl_m_connection_max_conn_in_pool">
									<xts:string id="IDS_SELECT_CONNECT_SAPR3_MAX_CONN_IN_POOL"/>
								</dp:section1>
								<dp:section2>
									<utml:input type="text" name="m_connection_max_conn_in_pool" value="6" size="10" for="ctrl_m_connection_max_conn_in_pool"/>
								</dp:section2>
							</dp:input>
							<dp:input>
								<dp:section1 for="ctrl_m_connection_table_read_function">
									<xts:string id="IDS_SELECT_CONNECT_SAPR3_TABLE_READ_FUNCTION"/>
								</dp:section1>
								<dp:section2>
									<utml:input type="text" name="m_connection_table_read_function" value="RFC_READ_TABLE" size="20" id="ctrl_m_connection_table_read_function"/>
								</dp:section2>
							</dp:input>
							<dp:input>
								<dp:section1 for="ctrl_m_connection_table_row_count">
									<xts:string id="IDS_SELECT_CONNECT_SAPR3_TABLE_ROW_COUNT"/>
								</dp:section1>
								<dp:section2>
									<utml:input type="text" name="m_connection_table_row_count" value="50000" size="10" id="ctrl_m_connection_table_row_count"/>
								</dp:section2>
							</dp:input>
							
							<dp:input>
								<dp:section1 for="ctrl_m_connection_abap_query_db_access_limit">
									<xts:string id="IDS_SELECT_CONNECT_SAPR3_ABAP_QUERY_DB_ACCESS_LIMIT"/>
								</dp:section1>
								<dp:section2>
									<utml:input type="text" name="m_connection_abap_query_db_access_limit" value="1000" size="10" id="ctrl_m_connection_abap_query_db_access_limit"/>
								</dp:section2>
							</dp:input>
							
							<dp:choice>
								<dp:section1>
									<utml:input type="checkbox" id="m_connection_use_loadbalancing" name="m_connection_use_loadbalancing" onclick="checkLoadBalancing();"/>
								</dp:section1>
								<dp:section2 for="m_connection_use_loadbalancing">
									<xts:string id="IDS_SELECT_CONNECT_SAPR3_USE_LOAD_BALANCING"/>
								</dp:section2>
							</dp:choice>
							
							<dp:input>
								<dp:section1>
									<utml:input type="hidden" name="m_connection_use_loadbalancing_hidden" size="10"/>
								</dp:section1>
							</dp:input>

							<dp:input>
								<dp:section1 for="ctrl_m_connection_message_server">
									<xts:string id="IDS_SELECT_CONNECT_SAPR3_MESSAGE_SERVER"/>
								</dp:section1>
								<dp:section2>
									<utml:input type="text" name="m_connection_message_server" size="53" id="ctrl_m_connection_message_server"/>
								</dp:section2>
							</dp:input>
							<dp:input>
								<dp:section1 for="ctrl_m_connection_system_id">
									<xts:string id="IDS_SELECT_CONNECT_SAPR3_SYSTEM_ID"/>
								</dp:section1>
								<dp:section2>
									<utml:input type="text" name="m_connection_system_id" size="20" id="ctrl_m_connection_system_id"/>
								</dp:section2>
							</dp:input>
							<dp:input>
								<dp:section1 for="ctrl_m_connection_logon_group">
									<xts:string id="IDS_SELECT_CONNECT_SAPR3_LOGON_GROUP"/>
								</dp:section1>
								<dp:section2>
									<utml:input type="text" name="m_connection_logon_group" size="20" id="ctrl_m_connection_logon_group"/>
								</dp:section2>
							</dp:input>

						</lyt:section>
				</lyt:layout>
			</out:template>

			<out:template name="dcx-sfdc-template">
				<out:param name="form-read-only"/>
				<out:param name="utml-form-name"/>

				<script language="javascript">
				
					function clearEncryptedProxyPassword()
					{
						document.pform.m_password_changed.value='1';
						if (document.pform.proxyPasswordEncrypted)
							document.pform.proxyPasswordEncrypted.value = '';
					}
				</script>
				<utml:input type="hidden" name="m_username_changed" utml:update="false" value="0"/>
				<utml:input type="hidden" name="m_password_changed" utml:update="false" value="0"/>

				<lyt:layout style="1">
					<lyt:section>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_url">
								<xts:string id="IDS_SELECT_CONNECT_SFDC_URL"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_url" value="https://login.salesforce.com/services/Soap/u/49.0" size="53" id="ctrl_m_connection_url"/>
                            </dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_conc_calls_limit">
								<xts:string id="IDS_SELECT_CONNECT_SFDC_CONCC_CALLS_LIMIT"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_conc_calls_limit" value="25" size="10" id="ctrl_m_connection_conc_calls_limit"/>
                            </dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_user_conc_calls_limit">
								<xts:string id="IDS_SELECT_CONNECT_SFDC_USER_CONCC_CALLS_LIMIT"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_user_conc_calls_limit" value="10" size="10" id="ctrl_m_connection_user_conc_calls_limit"/>
                            </dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_timeout">
								<xts:string id="IDS_SELECT_CONNECT_SFDC_CONN_TIMEOUT"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_timeout" value="60" size="10" id="ctrl_m_connection_timeout"/>
                             </dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_query_batch_size">
								<xts:string id="IDS_SELECT_CONNECT_SFDC_QUERY_BATCH_SIZE"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_query_batch_size" value="500" size="10" id="ctrl_m_connection_query_batch_size"/>
                            </dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_max_retries">
								<xts:string id="IDS_SELECT_CONNECT_SFDC_MAX_RETRIES"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_max_retries" value="1" size="10" id="ctrl_m_connection_max_retries"/>
                            </dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_wait_between_retries">
								<xts:string id="IDS_SELECT_CONNECT_SFDC_WAIT_BETWEEN_RETRIES"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_wait_between_retries" value="0" size="10" id="ctrl_m_connection_wait_between_retries"/>
                            </dp:section2>
						</dp:input>	
					</lyt:section>
				</lyt:layout>		

				<lyt:layout title="IDS_SELECT_CONNECT_PROXY_HOST_SIGNON" style="1" border="yes">
					<lyt:intro>
						<xts:string id="IDS_SELECT_CONNECT_PROXY_HOST_SIGNON_HINT"/>
					</lyt:intro>
					
					<lyt:section>	
						<dp:choice>
							<dp:section1>
								<utml:input type="checkbox" name="m_connection_proxy_enabled" onclick="setProxyControls();" id="ctrl_m_connection_proxy_enabled"/>
							</dp:section1>
							<dp:section2 for="ctrl_m_connection_proxy_enabled">
								<xts:string id="IDS_SELECT_CONNECT_SFDC_PROXY_ENABLED"/>
							</dp:section2>
							<dp:section3>
								<dp:input>
									<dp:section1 for="ctrl_m_connection_proxy_host">
										<xts:string id="IDS_SELECT_CONNECT_SFDC_PROXY_HOST"/>
									</dp:section1>
									<dp:section2>
										<utml:input type="text" name="m_connection_proxy_host" size="53" id="ctrl_m_connection_proxy_host"/>
                                    </dp:section2>
								</dp:input>
								<dp:input>
									<dp:section1 for="ctrl_m_connection_proxy_port">
										<xts:string id="IDS_SELECT_CONNECT_SFDC_PROXY_PORT"/>
									</dp:section1>
									<dp:section2>
										<utml:input type="text" name="m_connection_proxy_port" size="10" id="ctrl_m_connection_proxy_port"/>
									</dp:section2>
								</dp:input>
								<dp:input>
									<dp:section1 for="ctrl_m_connection_proxy_user">
										<xts:string id="IDS_SELECT_CONNECT_SFDC_PROXY_USER"/>
									</dp:section1>
									<dp:section2>
										<utml:input type="text" name="m_connection_proxy_user" size="53" onchange="document.pform.m_username_changed.value='1'" id="ctrl_m_connection_proxy_user"/>
									</dp:section2>
								</dp:input>
						
								<dp:input>
									<dp:section1 for="ctrl_m_connection_proxy_password">
										<xts:string id="IDS_SELECT_CONNECT_SFDC_PROXY_PWD"/>
									</dp:section1>
									<dp:section2>
										<utml:input type="password" name="m_connection_proxy_password" size="53" utml:update="false" onchange="clearEncryptedProxyPassword()" autocomplete="off" id="ctrl_m_connection_proxy_password">
											<utml:value>
												<!-- There is no need to localize this, it's simply a dummy value used to
												make *** appear in the password field. -->
												<xsl:text>###PASSWORD###</xsl:text>
											</utml:value>
										</utml:input>
									</dp:section2>								
								</dp:input>
							</dp:section3>
						</dp:choice>
					</lyt:section>
				</lyt:layout>
			</out:template>
			
			<out:template name="dcx-siebel-template">
				<out:param name="form-read-only"/>
				<out:param name="utml-form-name"/>
					<lyt:layout style="1">
						<lyt:section>
							<dp:input>
								<dp:section1 for="ctrl_m_connection_gatewayserver">
									<xts:string id="IDS_SELECT_CONNECT_SIEBEL_GATEWAYNAMESERVER"/>
								</dp:section1>
								<dp:section2>
									<utml:input type="text" name="m_connection_gatewayserver" size="53" id="ctrl_m_connection_gatewayserver"/>
								</dp:section2>
							</dp:input>
							<dp:input>
								<dp:section1 for="ctrl_m_connection_gatewayport">
									<xts:string id="IDS_SELECT_CONNECT_SIEBEL_GATEWAYPORT"/>
								</dp:section1>
								<dp:section2>
									<utml:input type="text" name="m_connection_gatewayport" value="2321" size="10" id="ctrl_m_connection_gatewayport"/>
								</dp:section2>
							</dp:input>
							<dp:input>
								<dp:section1 for="ctrl_m_connection_enterprise_name">
									<xts:string id="IDS_SELECT_CONNECT_SIEBEL_ENTERPRISENAME"/>
								</dp:section1>
								<dp:section2>
									<utml:input type="text" name="m_connection_enterprise_name" size="10" id="ctrl_m_connection_enterprise_name"/>
								</dp:section2>
							</dp:input>
							<dp:input>
								<dp:section1 for="ctrl_m_connection_aom">
									<xts:string id="IDS_SELECT_CONNECT_SIEBEL_AOM"/>
								</dp:section1>
								<dp:section2>
									<utml:input type="text" name="m_connection_aom" size="10" id="ctrl_m_connection_aom"/>
								</dp:section2>
							</dp:input>
							<dp:input>
								<dp:section1 for="ctrl_m_connection_language">
									<xts:string id="IDS_SELECT_CONNECT_SIEBEL_LANGUAGE"/>
								</dp:section1>
								<dp:section2>
									<utml:input type="text" name="m_connection_language" value="enu" size="10" id="ctrl_m_connection_language"/>
								</dp:section2>
							</dp:input>
						</lyt:section>
				</lyt:layout>

                <lyt:layout style="1" title="IDS_SELECT_CONNECT_SIEBEL_OPTIONAL_PARAMS" border="yes">
					<lyt:section>
							<dp:input>
								<dp:section1 for="ctrl_m_connection_siebel_repo">
									<xts:string id="IDS_SELECT_CONNECT_SIEBEL_REPOSITORY"/>
								</dp:section1>
								<dp:section2>
									<utml:input type="text" name="m_connection_siebel_repo" value="Siebel Repository" size="20" id="ctrl_m_connection_siebel_repo"/>
								</dp:section2>
							</dp:input>
							<dp:input>
								<dp:section1 for="ctrl_m_connection_transport">
									<xts:string id="IDS_SELECT_CONNECT_SIEBEL_TRANSPORT"/>
								</dp:section1>
								<dp:section2>
									<utml:input type="text" name="m_connection_transport" value="TCPIP" size="10" id="ctrl_m_connection_transport"/>
								</dp:section2>
							</dp:input>
							
							<dp:input>
								<dp:section1 for="ctrl_m_connection_compression">
									<xts:string id="IDS_SELECT_CONNECT_SIEBEL_COMPRESSION"/>
								</dp:section1>
								<dp:section2>
									<utml:input type="text" name="m_connection_compression" value="None" size="10" id="ctrl_m_connection_compression"/>
								</dp:section2>
							</dp:input>
							
							<dp:input>
								<dp:section1 for="ctrl_m_connection_encryption">
									<xts:string id="IDS_SELECT_CONNECT_SIEBEL_ENCRYPTION"/>
								</dp:section1>
								<dp:section2>
									<utml:input type="text" name="m_connection_encryption" value="None" size="10" id="ctrl_m_connection_encryption"/>
								</dp:section2>
							</dp:input>

							<dp:input>
								<dp:section1 for="ctrl_m_connection_login_retries">
									<xts:string id="IDS_SELECT_CONNECT_SIEBEL_LOGIN_RETRIES"/>
								</dp:section1>
								<dp:section2>
									<utml:input type="text" name="m_connection_login_retries" value="3" size="10" id="ctrl_m_connection_login_retries"/>
								</dp:section2>
							</dp:input>
							
							<dp:input>
								<dp:section1 for="ctrl_m_connection_login_retry_delay">
									<xts:string id="IDS_SELECT_CONNECT_SIEBEL_LOGIN_RETRY_DELAY"/>
								</dp:section1>
								<dp:section2>
									<utml:input type="text" name="m_connection_login_retry_delay" value="5" size="10" id="ctrl_m_connection_login_retry_delay"/>
								</dp:section2>
							</dp:input>
							
							<dp:input>
								<dp:section1 for="ctrl_m_connection_local_sort">
									<xts:string id="IDS_SELECT_CONNECT_SIEBEL_LOCAL_SORT"/>
								</dp:section1>
								<dp:section2>
									<utml:input type="text" name="m_connection_local_sort" value="" size="10" id="ctrl_m_connection_local_sort"/>
								</dp:section2>
							</dp:input>
							
							<dp:input>
								<dp:section1 for="ctrl_m_connection_level">
									<xts:string id="IDS_SELECT_CONNECT_SIEBEL_LEVEL"/>
								</dp:section1>
								<dp:section2>
									<utml:input type="text" name="m_connection_level" value="Primary" size="10" id="ctrl_m_connection_level"/>
								</dp:section2>
							</dp:input>
							
							<dp:input>
								<dp:section1 for="ctrl_m_connection_charset">
									<xts:string id="IDS_SELECT_CONNECT_SIEBEL_CHARSET"/>
								</dp:section1>
								<dp:section2>
									<utml:input type="text" name="m_connection_charset" value="" size="10" id="ctrl_m_connection_charset"/>
								</dp:section2>
							</dp:input>
							
							<dp:input>
								<dp:section1 for="ctrl_m_connection_adv_parameters">
									<xts:string id="IDS_SELECT_CONNECT_SIEBEL_ADV_PARAMETERS"/>
								</dp:section1>
								<dp:section2>
									<utml:input type="text" name="m_connection_adv_parameters" size="53" id="ctrl_m_connection_adv_parameters"/>
								</dp:section2>
							</dp:input>

						</lyt:section>
						
				</lyt:layout>
			</out:template>
			<out:template name="dcx-sap-template">
				<out:param name="form-read-only"/>
				<out:param name="utml-form-name"/>
				<out:variable name="dcx-sap-type">
					<out:choose>
						<out:when test="key('env-param','m_connection_sap_type') != ''">
							<out:value-of select="string(key('env-param','m_connection_sap_type'))"/>
						</out:when>
						<out:otherwise>
							<out:value-of select="'applicationServer'"/>
						</out:otherwise>
					</out:choose>
				</out:variable>
				<out:variable name="dcx-sap-codepage">
					<out:choose>
						<out:when test="contains(key('env-param','m_p_connectionString'), ';codePage=4102')">
							<out:value-of select="'4102'"/>
						</out:when>
						<out:when test="contains(key('env-param','m_p_connectionString'), ';codePage=4103')">
							<out:value-of select="'4103'"/>
						</out:when>
					</out:choose>
				</out:variable>
				<script language="javascript">
					function changeSAPType()
					{
						document.pform.submit();
					}
				</script>
				<lyt:layout style="1">
					<lyt:section>
						<out:variable name="server-name-label">
							<out:choose>
								<out:when test="$dcx-sap-type='messageServer'">
									<xts:string id="IDS_SELECT_CONNECT_SAP_MESSAGE_LABEL"/>
								</out:when>
								<out:when test="$dcx-sap-type='applicationServer'">
									<xts:string id="IDS_SELECT_CONNECT_SAP_APPLICATION_LABEL"/>
								</out:when>
								<out:when test="$dcx-sap-type='destination'">
									<xts:string id="IDS_SELECT_CONNECT_SAP_DESTINATION_LABEL"/>
								</out:when>
							</out:choose>
						</out:variable>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_sap_type">
								<xts:string id="IDS_SELECT_CONNECT_SAP_TYPE"/>
							</dp:section1>
							<dp:section2>
								<utml:select name="m_connection_sap_type" size="1" utml:update="true" onchange="changeSAPType();" id="ctrl_m_connection_sap_type">
									<utml:option value="applicationServer">
										<xts:string id="IDS_SELECT_CONNECT_SAP_APPLICATION"/>
									</utml:option>
									<utml:option value="destination">
										<xts:string id="IDS_SELECT_CONNECT_SAP_DESTINATION"/>
									</utml:option>
									<utml:option value="messageServer">
										<xts:string id="IDS_SELECT_CONNECT_SAP_MESSAGE"/>
									</utml:option>
								</utml:select>
							</dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_database">
								<out:text/><out:value-of select="$server-name-label"/><out:text/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_database" size="53" id="ctrl_m_connection_database"/>
							</dp:section2>
						</dp:input>
						<out:choose>
							<out:when test="$dcx-sap-type='messageServer'">
								<dp:input>
									<dp:section1 for="ctrl_m_connection_sys_id">
										<xts:string id="IDS_SELECT_CONNECT_SYSTEM_ID"/>
									</dp:section1>
									<dp:section2>
										<utml:input type="text" name="m_connection_sys_id" size="10" id="ctrl_m_connection_sys_id"/>
									</dp:section2>
								</dp:input>
								<dp:input>
									<dp:section1 for="ctrl_m_connection_logon">
										<xts:string id="IDS_SELECT_CONNECT_LOGON_GROUP"/>
									</dp:section1>
									<dp:section2>
										<utml:input type="text" name="m_connection_logon" size="10" id="ctrl_m_connection_logon"/>
									</dp:section2>
								</dp:input>
							</out:when>
							<out:when test="$dcx-sap-type='applicationServer'">
								<dp:input>
									<dp:section1 for="ctrl_m_connection_sys_no">
										<xts:string id="IDS_SELECT_CONNECT_SYSTEM_NUMBER"/>
									</dp:section1>
									<dp:section2>
										<utml:input type="text" name="m_connection_sys_no" value="0" size="10" id="ctrl_m_connection_sys_no"/>
									</dp:section2>
								</dp:input>
							</out:when>
						</out:choose>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_client_no">
								<xts:string id="IDS_SELECT_CONNECT_CLIENT_NUMBER"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_client_no" value="0" size="10" id="ctrl_m_connection_client_no"/>
							</dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_sap_codepage"><xts:string id="IDS_SELECT_CONNECT_SAP_SERVER_CODEPAGE"/></dp:section1>
							<dp:section2>
								<utml:select name="m_connection_sap_codepage" size="1" utml:update="true" id="ctrl_m_connection_sap_codepage">
									<utml:default-value>4102</utml:default-value>
									<utml:option value="1100"><xts:string id="IDS_SELECT_CONNECT_SAP_CP_1100"/></utml:option>
									<utml:option value="1160"><xts:string id="IDS_SELECT_CONNECT_SAP_CP_1160"/></utml:option>
									<utml:option value="1401"><xts:string id="IDS_SELECT_CONNECT_SAP_CP_1401"/></utml:option>
									<utml:option value="1404"><xts:string id="IDS_SELECT_CONNECT_SAP_CP_1404"/></utml:option>
									<utml:option value="1610"><xts:string id="IDS_SELECT_CONNECT_SAP_CP_1610"/></utml:option>
									<utml:option value="1614"><xts:string id="IDS_SELECT_CONNECT_SAP_CP_1614"/></utml:option>
									<utml:option value="1700"><xts:string id="IDS_SELECT_CONNECT_SAP_CP_1700"/></utml:option>
									<utml:option value="1704"><xts:string id="IDS_SELECT_CONNECT_SAP_CP_1704"/></utml:option>
									<utml:option value="1800"><xts:string id="IDS_SELECT_CONNECT_SAP_CP_1800"/></utml:option>
									<utml:option value="4102"><xts:string id="IDS_SELECT_CONNECT_SAP_CP_4102"/></utml:option>
									<utml:option value="4103"><xts:string id="IDS_SELECT_CONNECT_SAP_CP_4103"/></utml:option>
									<utml:option value="4110"><xts:string id="IDS_SELECT_CONNECT_SAP_CP_4110"/></utml:option>
									<utml:option value="8000"><xts:string id="IDS_SELECT_CONNECT_SAP_CP_8000"/></utml:option>
									<utml:option value="8300"><xts:string id="IDS_SELECT_CONNECT_SAP_CP_8300"/></utml:option>
									<utml:option value="8400"><xts:string id="IDS_SELECT_CONNECT_SAP_CP_8400"/></utml:option>
									<utml:option value="8500"><xts:string id="IDS_SELECT_CONNECT_SAP_CP_8500"/></utml:option>
									<utml:option value="8600"><xts:string id="IDS_SELECT_CONNECT_SAP_CP_8600"/></utml:option>
								</utml:select>
							</dp:section2>
						</dp:input>
						<out:if test="$dcx-sap-type='applicationServer' or $dcx-sap-type='messageServer'">
							<dp:input>
								<dp:section1 for="ctrl_m_connection_router_string">
									<xts:string id="IDS_SELECT_CONNECT_ROUTER_STRING"/>
								</dp:section1>
								<dp:section2>
									<utml:input type="text" name="m_connection_router_string" size="53" id="ctrl_m_connection_router_string"/>
								</dp:section2>
							</dp:input>
						</out:if>
					</lyt:section>
				</lyt:layout>
			</out:template>

			<out:template name="dcx-sapR3-template">
				<out:param name="form-read-only"/>
				<out:param name="utml-form-name"/>
				<lyt:layout style="1">
					<lyt:section>
						<dp:input>
							<dp:section1>
								<xts:string id="IDS_SELECT_CONNECT_SAPR3_HOSTNAME"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_hostname" size="53"/>
							</dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1>
								<xts:string id="IDS_SELECT_CONNECT_SAPR3_SYSTEMNUMBER"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_sys_no" size="53"/>
							</dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1>
								<xts:string id="IDS_SELECT_CONNECT_SAPR3_GATEWAY_HOST"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_gateway_host" size="53"/>
							</dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1>
								<xts:string id="IDS_SELECT_CONNECT_SAPR3_GATEWAY_SERVICE"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_gateway_service" size="53"/>
							</dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1>
								<xts:string id="IDS_SELECT_CONNECT_SAPR3_DESTINATION"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_destination" size="53"/>
							</dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1>
								<xts:string id="IDS_SELECT_CONNECT_SAPR3_CLIENT"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_client" size="53"/>
							</dp:section2>
						</dp:input>
						<!-- Content Locale  -->
						<dp:input>
							<dp:section1>
								<xts:string id="IDS_SELECT_CONNECT_SAPR3_LANGUAGE"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_sap_language" size="53"/>
							</dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1>
								<xts:string id="IDS_SELECT_CONNECT_SAPR3_COLLATION"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_colseq" size="53"/>
							</dp:section2>
						</dp:input>
						<out:if test="key('env-param','m_connection_type') = 'sapR3'">
							<dp:input>
								<dp:section1>
									<xts:string id="IDS_SELECT_CONNECT_SAPR3_COGUDAOUTERJOIN"/>
								</dp:section1>
								<dp:section2>
									<utml:select name="m_connection_cogudaouterjoin" size="1">
										<utml:default-value>OFF</utml:default-value>
										<utml:option value="OFF"><xts:string id="IDS_SELECT_CONNECT_SAPR3_COGUDAOUTERJOIN_OFF"/></utml:option>
										<utml:option value="ON"><xts:string id="IDS_SELECT_CONNECT_SAPR3_COGUDAOUTERJOIN_ON"/></utml:option>
									</utml:select>
								</dp:section2>
							</dp:input>
						</out:if>
						<dp:choice>
							<dp:section1>
								<utml:input type="checkbox" name="m_connection_background" utml:track="true"/>
							</dp:section1>
							<dp:section2>
								<out:text><xts:string id="IDS_SELECT_CONNECT_SAPR3_BACKGROUND"/></out:text>
							</dp:section2>
						</dp:choice>
					</lyt:section>
				</lyt:layout>
				<lyt:layout title="IDS_SELECT_CONNECT_SAPR3_DICTIONARY" style="1" border="yes">
					<lyt:intro>
						<xts:string id="IDS_SELECT_CONNECT_SAPR3_DICTIONARY_HINT"/>
					</lyt:intro>
					<lyt:section>
					<dp:input>
						<dp:section1>
							<xts:string id="IDS_SELECT_CONNECT_SAPR3_DICTIONARY_LOCATION"/>
						</dp:section1>
						<dp:section2>
							<utml:input type="text" name="m_connection_dictionary" size="53"/>
						</dp:section2>
					</dp:input>
					</lyt:section>
				</lyt:layout>
			</out:template>

			<out:template name="dcx-jdbc-generic">
				<out:param name="form-read-only"/>
				<out:param name="utml-form-name"/>
				<script language="javascript">
					var nameList = new Array();
					var codeList = new Array();
					var urlList = new Array();
					var propList = new Array();
					var driverList = new Array();
					
					// The oldOnload would be the init() function called by other xts files.
					// In order not to override the init() function, the JDBC init will be 
					// using a different name called initJDBCGeneric().
					var oldOnload = window.onload;
					window.onload = function() {
						if (oldOnload) {
							oldOnload();
						}
						initJDBCGeneric();
					}
								
					function initJDBCGeneric() 
					{	
						var frm = document.pform;
						if (frm) {
							// Initialize the default property list for supported JDBC data sources.
							initJDBCDataSources();
							if (frm.m_jdbc_connection_code == undefined &amp;&amp; frm.m_jdbc_connection_string.value == '') {
								// This indicates we are creating a new data source. Initialize all the values to default.
								initJDBCDefaultValues();
							} else if (frm.m_jdbc_connection_code != undefined &amp;&amp; frm.m_jdbc_connection_code != ''){
								// This is the case where we opened a saved connection. We will set the connection type based on
								// its code and leave the rest of the property untouched. They were set in connections.js.
								setJDBCTypeFromCode();
							} else if (frm.m_jdbc_connection_code == undefined) {
								setJDBCCodeFromType();
							}
							updateJDBCConnectionString();
						}
					}
					
					function initJDBCDataSources()
					{
						<out:for-each select="/root/datasources/datasource/supportedDataSources/supportedDataSource">
							nameList[<out:value-of select="(position() - 1)"/>] = '<out:value-of select="name"/>';
							codeList[<out:value-of select="(position() - 1)"/>] = '<out:value-of select="subprotocol"/>';
							urlList[<out:value-of select="(position() - 1)"/>] = '<out:value-of select="url"/>';
							propList[<out:value-of select="(position() - 1)"/>] = '<out:value-of select="properties"/>';
							driverList[<out:value-of select="(position() - 1)"/>] = '<out:value-of select="driver"/>';
						</out:for-each>
					}
					
					function setJDBCTypeFromCode()
					{
						var frm = document.pform;
						if (frm) {
							for (var i=0;i&lt;codeList.length;i=i+1) {
								if (frm.m_jdbc_connection_code == codeList[i]) {
									frm.m_jdbc_connection_type.value = nameList[i];
									break;
								}
							}
						}
					}
					
					function setJDBCCodeFromType()
					{
						var frm = document.pform;
						if (frm) {
							for (var i=0;i&lt;nameList.length;i=i+1) {
								if (frm.m_jdbc_connection_type.value == nameList[i]) {
									frm.m_jdbc_connection_code = codeList[i];
									break;
								}
							}
						}
					}
					
					function initJDBCDefaultValues() 
					{
						var frm = document.pform;
						if (frm) {
							frm.m_jdbc_connection_type.value =
								'<out:value-of select="/root/datasources/datasource/supportedDataSources/supportedDataSource[1]/name"/>';
							frm.m_jdbc_connection_code = 
								'<out:value-of select="/root/datasources/datasource/supportedDataSources/supportedDataSource[1]/subprotocol"/>';
							frm.m_jdbc_connection_url.value =
								'<out:value-of select="/root/datasources/datasource/supportedDataSources/supportedDataSource[1]/url"/>';
							frm.m_jdbc_connection_properties.value = 
								'<out:value-of select="/root/datasources/datasource/supportedDataSources/supportedDataSource[1]/properties"/>';
							frm.m_jdbc_driver_class.value = 
								'<out:value-of select="/root/datasources/datasource/supportedDataSources/supportedDataSource[1]/driver"/>';
							frm.m_jdbc_connection_string.readOnly = 'true';
							frm.m_connection_jdbc_sort_colseq.value = '';
						}
					}
				
					function updateJDBCType()
					{
						var frm = document.pform;
						if (frm) {								
							for (var i=0;i&lt;nameList.length;i=i+1) {
								if (frm.m_jdbc_connection_type.value == nameList[i]) {
									frm.m_jdbc_connection_code = codeList[i];
									frm.m_jdbc_connection_url.value = urlList[i];
									frm.m_jdbc_connection_properties.value = propList[i];
									frm.m_jdbc_driver_class.value = driverList[i];
									frm.m_connection_jdbc_sort_colseq.value = '';
									break;
								}
							}
							updateJDBCConnectionString();		
						}
					}
					
					function updateJDBCConnectionString() 
					{
						var f = document.pform;
						if (f) {
							var connectString = ';LOCAL;JDBC;URL=';							
							var url = f.m_jdbc_connection_url.value;
							connectString = connectString + url;
							connectString = connectString + ';DRIVER_NAME=' + f.m_jdbc_driver_class.value + ';';
							var properties = f.m_jdbc_connection_properties.value;
							connectString = connectString + properties;
							if (properties != '' &amp;&amp; properties.charAt(properties.length - 1) != ';')
							{
								connectString = connectString + ';';
							}
							if (f.m_connection_jdbc_sort_colseq.value != '') {
								connectString += 'LOCALSORT=' + f.m_connection_jdbc_sort_colseq.value + ';LEVEL=' + f.m_connection_jdbc_sort_level.value;
							}
							f.m_jdbc_connection_string.value = connectString;
						}
					}
				</script>
				<utml:input onload="startUp()"/>
				<lyt:layout style="1">
					<lyt:section>
						<dp:list>
							<dp:section>
								<dp:label for="ctrl_m_jdbc_connection_type"><xts:string id="IDS_PROP_CONN_TYPE"/></dp:label>
							</dp:section>
							<dp:section>
								<out:choose>
									<out:when test="count(/root/datasources/datasource/supportedDataSources/supportedDataSource) = 1">
										<out:value-of select="/root/datasources/datasource/supportedDataSources/supportedDataSource/name"/>
										<utml:input type="hidden" name="m_jdbc_connection_type">
											<utml:value><out:value-of select="/root/datasources/datasource/supportedDataSources/supportedDataSource/name"/></utml:value>
										</utml:input>
										<script language="javascript">updateJDBCType();</script>
									</out:when>
									<out:otherwise>
										<utml:select size="1" name="m_jdbc_connection_type" onchange="updateJDBCType()" id="ctrl_m_jdbc_connection_type">
											<out:for-each select="/root/datasources/datasource/supportedDataSources/supportedDataSource">
												<out:sort select="name"/>
												<utml:option>
													<utml:value><out:value-of select="name"/></utml:value>
													<out:value-of select="name"/>
												</utml:option>
											</out:for-each>
										</utml:select>
									</out:otherwise>
								</out:choose>
							</dp:section>
						</dp:list>
						<dp:input>
							<dp:section1 for="ctrl_m_jdbc_connection_url">
								<xts:string id="IDS_SELECT_CONNECT_JDBC_URL"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_jdbc_connection_url" size="53" onchange="updateJDBCConnectionString()" id="ctrl_m_jdbc_connection_url"/>
							</dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 for="ctrl_m_jdbc_connection_properties">
								<xts:string id="IDS_SELECT_CONNECT_JDBC_PROPERTY"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_jdbc_connection_properties" size="53" onchange="updateJDBCConnectionString()" id="ctrl_m_jdbc_connection_properties"/>
							</dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 for="ctrl_m_jdbc_driver_class">
								<xts:string id="IDS_SELECT_CONNECT_JDBC_DRIVER_CLASS"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_jdbc_driver_class" size="53" onchange="updateJDBCConnectionString()" id="ctrl_m_jdbc_driver_class"/>
							</dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 for="ctrl_m_jdbc_connection_string">
								<xts:string id="IDS_SELECT_CONNECT_JDBC_CONNECTION_STRING"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_jdbc_connection_string" size="200" style="border:none;background:transparent;" id="ctrl_m_jdbc_connection_string"/>
							</dp:section2>
						</dp:input>
					</lyt:section>
				</lyt:layout>
				<lyt:layout style="1" border="yes" title="IDS_SELECT_CONNECT_JDBC_SORT_OPTIONS_HINT">
					<lyt:section>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_jdbc_sort_colseq">
								<xts:string id="IDS_SELECT_CONNECT_JDBC_SORT_COLSEQ"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_jdbc_sort_colseq" size="53" onkeyup="updateJdbcSortOptions()" onchange="updateJDBCConnectionString()" id="ctrl_m_connection_jdbc_sort_colseq"/>
							</dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_jdbc_sort_level">
								<xts:string id="IDS_SELECT_CONNECT_JDBC_SORT_LEVEL"/>
							</dp:section1>
							<dp:section2>
								<utml:select name="m_connection_jdbc_sort_level" size="1" onchange="updateJDBCConnectionString()" id="ctrl_m_connection_jdbc_sort_level">
									<utml:default-value>PRIMARY</utml:default-value>
									<utml:option value="PRIMARY"><xts:string id="IDS_SELECT_CONNECT_JDBC_SORTLEVEL_PRIMARY"/></utml:option>
									<utml:option value="SECONDARY"><xts:string id="IDS_SELECT_CONNECT_JDBC_SORTLEVEL_SECONDARY"/></utml:option>
									<utml:option value="TERTIARY"><xts:string id="IDS_SELECT_CONNECT_JDBC_SORTLEVEL_TERTIARY"/></utml:option>
									<utml:option value="IDENTICAL"><xts:string id="IDS_SELECT_CONNECT_JDBC_SORTLEVEL_IDENTICAL"/></utml:option>
								</utml:select>
							</dp:section2>
						</dp:input>
					</lyt:section>
				</lyt:layout>
			</out:template>

			<out:template name="dcx-filenet">
				<out:param name="form-read-only"/>
				<out:param name="utml-form-name"/>
				<script language="javascript">
					var repo_wmsg='<xts:string id="IDS_WARN_CHANGE_REPOSITORY_TYPE" encode="javascript"/>';
					var repo_fs_none_msg='<xts:string id="IDS_PROP_CONN_REPOSITORY_FS_ROOT_NONE_NEW" encode="javascript"/>';
					var repoTypeSelectInd = 0;
				</script>
				<lyt:layout style="1">
					<lyt:section>
					  <dp:input>
					    <dp:section1 for="ctrl_m_connection_jdbc_driverclass"><xts:string id="IDS_PROP_CONN_REPOSITORY_TYPE"/></dp:section1>
					    <dp:section2>
					      <utml:select name="m_connection_jdbc_driverclass" size="1" onchange="updateRepositoryType()" id="ctrl_m_connection_jdbc_driverclass">
							  <out:choose>
								<out:when test="/root/datasources/datasource[value='filenet']/defaultPlugin != ''">
								  <utml:default-value>
									<out:value-of select="/root/datasources/datasource[value='filenet']/defaultPluginOption"/>
								  </utml:default-value>
								</out:when>
								<out:otherwise>
								  <utml:default-value>CMIS_FileNet</utml:default-value>
								</out:otherwise>
							  </out:choose>
							  <utml:option value="CMIS_FileNet"><xts:string id="IDS_PROP_CONN_FILENET"/></utml:option>
							  <utml:option value="CMIS_CM8"><xts:string id="IDS_PROP_CONN_CM"/></utml:option>
							  <utml:option value="FileSystem"><xts:string id="IDS_PROP_CONN_FILESYSTEM"/></utml:option>									
							</utml:select>
						</dp:section2>
					  </dp:input>
					</lyt:section>
				</lyt:layout>
				<lyt:layout style="1" title="IDS_PROP_CONN_REPOSITORY_DETAILS" border="yes">
					<lyt:section>
						<utml:input type="hidden" name="m_connection_jdbc_url" value=""/>
						<cf:dynamicDiv name="cmisDiv" style="display:none">
							<dp:input>
								<dp:section1>
									<dp:list>
										<dp:section>
											<dp:label for="ctrl_cmisURL_input"><xts:string id="IDS_SELECT_CONNECT_FILENET_URL"/></dp:label>
										</dp:section>
										<dp:section>
											<dp:hint wrap="wrap"><xts:string id="IDS_SELECT_CONNECT_FILENET_URL_HINT"/></dp:hint>
										</dp:section>
									</dp:list>
								</dp:section1>
								<dp:section2>
									<utml:input type="text" name="cmisURL_input" size="53" utml:update="false" onchange="cmisURL_input_changed()" id="ctrl_cmisURL_input"/>
								</dp:section2>
							</dp:input>
						</cf:dynamicDiv>
						<cf:dynamicDiv name="fileSystemDiv" style="display:none">
							<dp:input>
								<dp:section1>
									<dp:list>
										<dp:section>
											<dp:label for="ctrl_fsAliasRoot_select"><xts:string id="IDS_PROP_CONN_REPOSITORY_FS_ROOT"/></dp:label>
										</dp:section>
										<dp:section>
											<dp:hint wrap="wrap"><xts:string id="IDS_PROP_CONN_REPOSITORY_FS_ROOT_HINT"/></dp:hint>
										</dp:section>
									</dp:list>
								</dp:section1>
								<dp:section2>
									<utml:select name="fsAliasRoot_select" size="1" utml:update="false" onchange="fsAliasRoot_select_changed()" id="ctrl_fsAliasRoot_select">
										<out:for-each select="/root/configuration/property[@name='aliasRoots']/*[local-name()='value']/item">
											<utml:option>
												<out:attribute name="value"><out:value-of select="name"/></out:attribute>
												<utml:value><xsl:value-of select="name"/></utml:value>
												<out:value-of select="name"/>
											</utml:option>
										</out:for-each>
									</utml:select>
								</dp:section2>
							</dp:input>
						</cf:dynamicDiv>
						<dp:input>
							<dp:section1>
								<dp:list>
									<dp:section>
										<dp:label for="ctrl_m_connection_file"><xts:string id="IDS_SELECT_CONNECT_ROOT_PATH"/></dp:label>
									</dp:section>
									<dp:section>
										<dp:hint wrap="wrap"><xts:string id="IDS_SELECT_CONNECT_ROOT_PATH_HINT"/></dp:hint>
									</dp:section>
								</dp:list>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_file" size="53" id="ctrl_m_connection_file"/>
							</dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1>
								<dp:list>
									<dp:section>
										<dp:label for="m_connection_jdbc_parameters"><xts:string  id="IDS_SELECT_CONNECT_REPOSITORY_CONNECTION_PARAMETERS"/></dp:label>
									</dp:section>
									<dp:section>
										<dp:hint wrap="wrap"><xts:string id="IDS_SELECT_CONNECT_JDBC_CONNECTION_PARAMETERS_INTRODUCTION"/></dp:hint>
									</dp:section>
								</dp:list>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_jdbc_parameters" size="100" id="ctrl_m_connection_jdbc_parameters"/>
							</dp:section2>
						</dp:input>
					</lyt:section>
				</lyt:layout>
			</out:template>
			
			<out:template name="dcx-jdbc-oracle">
				<out:param name="form-read-only"/>
				<out:param name="utml-form-name"/>
				<lyt:layout style="1">
					<lyt:section>
						<dp:list>
							<dp:section>
								<dp:label id="ConnectionType_ID"><xts:string id="IDS_SELECT_CONNECT_JDBC_ORACLE_CONNECTION_TYPE"/></dp:label>
							</dp:section>
						</dp:list>
						<utml:radio-group name="m_connection_jdbc_oracle_style">
							<utml:default-value>serviceID</utml:default-value>
							<dp:choice aria-labelledby="ConnectionType_ID">
								<dp:section1>
									<utml:input type="radio" name="m_connection_jdbc_oracle_style" value="serviceID" utml:track="true" onclick="updateJdbcOracle()" id="ctrl_m_connection_jdbc_oracle_style_serviceID"/>
								</dp:section1>
								<dp:section2 for="ctrl_m_connection_jdbc_oracle_style_serviceID">
									<out:text><xts:string id="IDS_SELECT_CONNECT_JDBC_ORACLE_SERVICE_ID_PROPERTY_GROUP"/></out:text>
								</dp:section2>
								<dp:section1>
									<utml:input type="radio" name="m_connection_jdbc_oracle_style" value="tnsNamesAlias" utml:track="true" onclick="updateJdbcOracle()" id="ctrl_m_connection_jdbc_oracle_style_tnsNamesAlias"/>
								</dp:section1>
								<dp:section2 for="ctrl_m_connection_jdbc_oracle_style_tnsNamesAlias">
									<out:text><xts:string id="IDS_SELECT_CONNECT_JDBC_ORACLE_TNS_NAMES_ALIAS_PROPERTY_GROUP"/></out:text>
								</dp:section2>
								<dp:section1>
									<utml:input type="radio" name="m_connection_jdbc_oracle_style" value="oracleNetDescriptor" utml:track="true" onclick="updateJdbcOracle()" id="ctrl_m_connection_jdbc_oracle_style_oracleNetDescriptor"/>
								</dp:section1>
								<dp:section2 for="ctrl_m_connection_jdbc_oracle_style_oracleNetDescriptor">
									<out:text><xts:string id="IDS_SELECT_CONNECT_JDBC_ORACLE_NET_DESCRIPTOR_PROPERTY_GROUP"/></out:text>
								</dp:section2>
							</dp:choice>
						</utml:radio-group>
						<cf:dynamicDiv name="serviceID">
							<lyt:layout style="1">
								<lyt:section>
									<dp:input>
										<dp:section1>
											<xts:string id="IDS_SELECT_CONNECT_JDBC_ORACLE_DRIVER_TYPE"/>
										</dp:section1>
										<dp:section2>
											<xts:string id="IDS_SELECT_CONNECT_JDBC_ORACLE_THIN"/>
										</dp:section2>
									</dp:input>
									<out:call-template name="dcx-jdbc-server-port-parameters">
										<out:with-param name="form-read-only" select="$form-read-only"/>
										<out:with-param name="utml-form-name" select="$utml-form-name"/>
									</out:call-template>
									<dp:input>
										<dp:section1 for="ctrl_m_connection_oracle_service_id">
											<xts:string id="IDS_SELECT_CONNECT_ORACLE_SERVICE_ID"/>
										</dp:section1>
										<dp:section2>
											<utml:input type="text" name="m_connection_oracle_service_id" size="53" id="ctrl_m_connection_oracle_service_id">
												<utml:value>
													<out:value-of select="/root/*[local-name()='datasources' or local-name()='jdbcdatasources']/datasource[starts-with(value,'jdbc-')]/properties/property[value='m_connection_oracle_service_id']/default"/>
												</utml:value>
											</utml:input>											
										</dp:section2>
									</dp:input>
								</lyt:section>
							</lyt:layout>
						</cf:dynamicDiv>
						<cf:dynamicDiv name="oracleNetDescriptor">
							<lyt:layout style="1">
								<lyt:section>
									<dp:input>
										<dp:section1 id="DriverType_ID">
											<xts:string id="IDS_SELECT_CONNECT_JDBC_ORACLE_DRIVER_TYPE"/>
										</dp:section1>
										<dp:section2>
											<utml:radio-group name="m_connection_jdbc_oracle_driver_type">
												<utml:default-value>thin</utml:default-value>
												<dp:choice aria-labelledby="DriverType_ID">
													<dp:section1>
														<utml:input type="radio" name="m_connection_jdbc_oracle_driver_type" value="thin" utml:track="true" id="ctrl_m_connection_jdbc_oracle_driver_type_thin"/>
													</dp:section1>
													<dp:section2 for="ctrl_m_connection_jdbc_oracle_driver_type_thin">
														<out:text><xts:string id="IDS_SELECT_CONNECT_JDBC_ORACLE_THIN"/></out:text>
													</dp:section2>
													<dp:section1>
														<utml:input type="radio" name="m_connection_jdbc_oracle_driver_type" value="oci" utml:track="true" id="ctrl_m_connection_jdbc_oracle_driver_type_oci"/>
													</dp:section1>
													<dp:section2 for="ctrl_m_connection_jdbc_oracle_driver_type_oci">
														<out:text><xts:string id="IDS_SELECT_CONNECT_JDBC_ORACLE_OCI"/></out:text>
													</dp:section2>
												</dp:choice>
											</utml:radio-group>
										</dp:section2>
									</dp:input>
									<dp:input>
										<dp:section1 for="ctrl_m_connection_oracle_net_descriptor">
											<xts:string id="IDS_SELECT_CONNECT_JDBC_ORACLE_NET_DESCRIPTOR"/>
										</dp:section1>
										<dp:section2>
											<utml:textarea name="m_connection_oracle_net_descriptor" class="pTextarea" rows="5" cols="53" id="ctrl_m_connection_oracle_net_descriptor"/>
										</dp:section2>
									</dp:input>
								</lyt:section>
							</lyt:layout>
						</cf:dynamicDiv>	
						<cf:dynamicDiv name="tnsNamesAlias">
							<lyt:layout style="1">
								<lyt:section>
									<dp:input>
										<dp:section1>
											<xts:string id="IDS_SELECT_CONNECT_JDBC_ORACLE_DRIVER_TYPE"/>
										</dp:section1>
										<dp:section2>
											<xts:string id="IDS_SELECT_CONNECT_JDBC_ORACLE_OCI"/>
										</dp:section2>
									</dp:input>
									<dp:input>
										<dp:section1 for="ctrl_m_connection_oracle_tns_name">
											<xts:string id="IDS_SELECT_CONNECT_ORACLE_TNS_NAME"/>
										</dp:section1>
										<dp:section2>
											<utml:input type="text" name="m_connection_oracle_tns_name" size="53" id="ctrl_m_connection_oracle_tns_name"/>
										</dp:section2>
									</dp:input>
								</lyt:section>
							</lyt:layout>
						</cf:dynamicDiv>
						<out:call-template name="dcx-jdbc-connection-parameters">
							<out:with-param name="form-read-only" select="$form-read-only"/>
							<out:with-param name="utml-form-name" select="$utml-form-name"/>
						</out:call-template>
					</lyt:section>
				</lyt:layout>
				<out:call-template name="dcx-jdbc-cognos-properties">
					<out:with-param name="form-read-only" select="$form-read-only"/>
					<out:with-param name="utml-form-name" select="$utml-form-name"/>
				</out:call-template>
			</out:template>

			<out:template name="dcx-jdbc-sql">
				<out:param name="form-read-only"/>
				<out:param name="utml-form-name"/>
				<lyt:layout style="1">
					<lyt:section>
						<out:call-template name="dcx-jdbc-server-port-parameters">
							<out:with-param name="form-read-only" select="$form-read-only"/>
							<out:with-param name="utml-form-name" select="$utml-form-name"/>
						</out:call-template>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_sql_instance_name">
								<xts:string id="IDS_SELECT_CONNECT_SQL_INSTANCE_NAME"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_sql_instance_name" size="53" id="ctrl_m_connection_sql_instance_name"/>
							</dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_jdbc_database_name">
								<xts:string id="IDS_SELECT_CONNECT_DATABASE_NAME"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_jdbc_database_name" size="53" id="ctrl_m_connection_jdbc_database_name"/>
							</dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_jdbc_connect_time">
								<xts:string id="IDS_SELECT_CONNECT_LOGIN_TIMEOUT"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_jdbc_connect_time" size="10" value="0" id="ctrl_m_connection_jdbc_connect_time"/>
							</dp:section2>
						</dp:input>
						<out:call-template name="dcx-jdbc-connection-parameters">
							<out:with-param name="form-read-only" select="$form-read-only"/>
							<out:with-param name="utml-form-name" select="$utml-form-name"/>
						</out:call-template>
					</lyt:section>
				</lyt:layout>
				<out:call-template name="dcx-jdbc-cognos-properties">
					<out:with-param name="form-read-only" select="$form-read-only"/>
					<out:with-param name="utml-form-name" select="$utml-form-name"/>
				</out:call-template>
			</out:template>

			<out:template name="dcx-jdbc-db2">
				<out:param name="form-read-only"/>
				<out:param name="utml-form-name"/>
				<lyt:layout style="1">
					<lyt:section>
						<out:call-template name="dcx-jdbc-server-port-parameters">
							<out:with-param name="form-read-only" select="$form-read-only"/>
							<out:with-param name="utml-form-name" select="$utml-form-name"/>
						</out:call-template>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_jdbc_database_name">
								<xts:string id="IDS_SELECT_CONNECT_DATABASE_NAME"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_jdbc_database_name" size="53" id="ctrl_m_connection_jdbc_database_name"/>
							</dp:section2>
						</dp:input>
						<out:call-template name="dcx-jdbc-connection-parameters">
							<out:with-param name="form-read-only" select="$form-read-only"/>
							<out:with-param name="utml-form-name" select="$utml-form-name"/>
						</out:call-template>
					</lyt:section>
				</lyt:layout>
				<out:call-template name="dcx-jdbc-cognos-properties">
					<out:with-param name="form-read-only" select="$form-read-only"/>
					<out:with-param name="utml-form-name" select="$utml-form-name"/>
				</out:call-template>
			</out:template>

			<out:template name="dcx-jdbc-teradata">
				<out:param name="form-read-only"/>
				<out:param name="utml-form-name"/>
				<lyt:layout style="1">
					<lyt:section>
						<out:call-template name="dcx-jdbc-server-port-parameters">
							<out:with-param name="form-read-only" select="$form-read-only"/>
							<out:with-param name="utml-form-name" select="$utml-form-name"/>
						</out:call-template>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_jdbc_database_name">
								<xts:string id="IDS_SELECT_CONNECT_DATABASE_NAME"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_jdbc_database_name" size="53" id="ctrl_m_connection_jdbc_database_name"/>
							</dp:section2>
						</dp:input>						
						<out:call-template name="dcx-jdbc-connection-parameters">
							<out:with-param name="form-read-only" select="$form-read-only"/>
							<out:with-param name="utml-form-name" select="$utml-form-name"/>
						</out:call-template>
					</lyt:section>
				</lyt:layout>
				<out:call-template name="dcx-jdbc-cognos-properties">
					<out:with-param name="form-read-only" select="$form-read-only"/>
					<out:with-param name="utml-form-name" select="$utml-form-name"/>
				</out:call-template>
			</out:template>

			<out:template name="dcx-jdbc-netezza">
				<out:param name="form-read-only"/>
				<out:param name="utml-form-name"/>
				<lyt:layout style="1">
					<lyt:section>
						<out:call-template name="dcx-jdbc-server-port-parameters">
							<out:with-param name="form-read-only" select="$form-read-only"/>
							<out:with-param name="utml-form-name" select="$utml-form-name"/>
						</out:call-template>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_jdbc_database_name">
								<xts:string id="IDS_SELECT_CONNECT_DATABASE_NAME"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_jdbc_database_name" size="53" id="ctrl_m_connection_jdbc_database_name"/>
							</dp:section2>
						</dp:input>
						<out:call-template name="dcx-jdbc-connection-parameters">
							<out:with-param name="form-read-only" select="$form-read-only"/>
							<out:with-param name="utml-form-name" select="$utml-form-name"/>
						</out:call-template>
					</lyt:section>
				</lyt:layout>
				<out:call-template name="dcx-jdbc-cognos-properties">
					<out:with-param name="form-read-only" select="$form-read-only"/>
					<out:with-param name="utml-form-name" select="$utml-form-name"/>
				</out:call-template>
			</out:template>

			<out:template name="dcx-jdbc-server-port-parameters">
				<out:param name="form-read-only"/>
				<out:param name="utml-form-name"/>
				<dp:input>
					<dp:section1 for="ctrl_m_connection_servername">
						<xts:string id="IDS_SELECT_CONNECT_DATASOURCE"/>
					</dp:section1>
					<dp:section2>
						<utml:input type="text" name="m_connection_servername" size="53" id="ctrl_m_connection_servername"/>
					</dp:section2>
				</dp:input>
				<dp:input>
					<dp:section1 for="ctrl_m_connection_port">
						<xts:string id="IDS_SELECT_CONNECT_PORTNUMBER"/>
					</dp:section1>
					<dp:section2>
						<utml:input type="text" name="m_connection_port" size="10" id="ctrl_m_connection_port">
							<utml:value>
								<out:value-of select="/root/*[local-name()='datasources' or local-name()='jdbcdatasources']/datasource[starts-with(value,'jdbc-')]/properties/property[value='m_connection_port']/default"/>
							</utml:value>
						</utml:input>
					</dp:section2>
				</dp:input>
			</out:template>

			<out:template name="dcx-jdbc-connection-parameters">
				<out:param name="form-read-only"/>
				<out:param name="utml-form-name"/>
				<dp:list>
					<dp:section>
						<dp:label for="ctrl_m_connection_jdbc_parameters"><xts:string  id="IDS_SELECT_CONNECT_JDBC_CONNECTION_PARAMETERS"/></dp:label>
					</dp:section>
					<dp:section>
						<dp:hint wrap="wrap"><xts:string id="IDS_SELECT_CONNECT_JDBC_CONNECTION_PARAMETERS_INTRODUCTION"/></dp:hint>
					</dp:section>
					<dp:section>
						<utml:input type="text" name="m_connection_jdbc_parameters" size="100" id="ctrl_m_connection_jdbc_parameters"/>
					</dp:section>
				</dp:list>
			</out:template>

			<out:template name="dcx-jdbc-cognos-properties">
				<out:param name="form-read-only"/>
				<out:param name="utml-form-name"/>
				<lyt:layout style="1" border="yes" title="IDS_SELECT_CONNECT_JDBC_SORT_OPTIONS_HINT" >
					<lyt:section>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_jdbc_sort_colseq">
								<xts:string id="IDS_SELECT_CONNECT_JDBC_SORT_COLSEQ"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_jdbc_sort_colseq" size="53" onkeyup="updateJdbcSortOptions()" id="ctrl_m_connection_jdbc_sort_colseq"/>
							</dp:section2>
						</dp:input>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_jdbc_sort_level">
								<xts:string id="IDS_SELECT_CONNECT_JDBC_SORT_LEVEL"/>
							</dp:section1>
							<dp:section2>
								<utml:select name="m_connection_jdbc_sort_level" size="1" id="ctrl_m_connection_jdbc_sort_level">
									<utml:default-value>PRIMARY</utml:default-value>
									<utml:option value="PRIMARY"><xts:string id="IDS_SELECT_CONNECT_JDBC_SORTLEVEL_PRIMARY"/></utml:option>
									<utml:option value="SECONDARY"><xts:string id="IDS_SELECT_CONNECT_JDBC_SORTLEVEL_SECONDARY"/></utml:option>
									<utml:option value="TERTIARY"><xts:string id="IDS_SELECT_CONNECT_JDBC_SORTLEVEL_TERTIARY"/></utml:option>
									<utml:option value="IDENTICAL"><xts:string id="IDS_SELECT_CONNECT_JDBC_SORTLEVEL_IDENTICAL"/></utml:option>
								</utml:select>
							</dp:section2>
						</dp:input>
					</lyt:section>
				</lyt:layout>
			</out:template>

			<out:template name="dcx-xml-template">
				<out:param name="form-read-only"/>
				<out:param name="utml-form-name"/>
				<lyt:layout style="1">
					<lyt:section>
						<dp:input>
							<dp:section1 for="ctrl_m_connection_database">
								<xts:string id="IDS_SELECT_CONNECT_OTHER_CONNECTSTRING"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_connection_database" size="53" id="ctrl_m_connection_database"/>
							</dp:section2>
						</dp:input>
					</lyt:section>
				</lyt:layout>
			</out:template>

			<out:template name="dcx-other-template">
				<out:param name="form-read-only"/>
				<out:param name="utml-form-name"/>
				<lyt:layout style="1">
					<lyt:section>
						<dp:input>
							<dp:section1 for="ctrl_m_other_connectionString">
								<xts:string id="IDS_SELECT_CONNECT_OTHER_CONNECTSTRING"/>
							</dp:section1>
							<dp:section2>
								<utml:input type="text" name="m_other_connectionString" size="53" id="ctrl_m_other_connectionString"/>
							</dp:section2>
						</dp:input>
					</lyt:section>
				</lyt:layout>
			</out:template>


		<out:template name="gen-create-signon">
			<out:param name="form-read-only"/>
			<out:param name="utml-form-name"/>
			<out:param name="enable-all" select="'true'"/>
			<out:param name="connectionType" select="''"/>
			<out:param name="authenticationType" select="''"/>
			
			<script language="javascript">
				function clearEncryptedPassword()
				{
					if (document.pform.passwordEncrypted)
						document.pform.passwordEncrypted.value = '';
				}
			</script>

			<out:variable name="default_signon_checked">
				<out:choose>
					<out:when test="(not(/root/env/param[@name='changed_m_connection_default_signon']) or /root/env/param[@name='changed_m_connection_default_signon']='0') or /root/env/param[@name='m_connection_default_signon']">true</out:when>
					<out:otherwise>false</out:otherwise>
				</out:choose>
			</out:variable>

			<dp:choice>
				<dp:section1>
					<out:choose>
						<out:when test="$connectionType = 'json'">
							<utml:input type="checkbox" name="m_connection_default_signon" utml:track="true" id="ctrl_m_connection_default_signon">
								<out:attribute name="disabled">disabled</out:attribute>
								<out:if test="$default_signon_checked='true'">
									<out:attribute name="checked">checked</out:attribute>
								</out:if>
							</utml:input>
						</out:when>
						<out:otherwise>
							<utml:input type="checkbox" name="m_connection_default_signon" onclick="toggleCreateSignon();" utml:track="true" id="ctrl_m_connection_default_signon">
		                        <out:if test="(not(key('env-param','m_connection_use_userid')) and contains(' db2 jdbc-db2 sql jdbc-sql dbtwoolap tm1R tm1 sql2005 sql2008 sql2012-2014 sqlodbc oracle jdbc-oracle jdbc-generic lob-jdbc filenet netezza jdbc-netezza odbc openEdge sybase sybase_ct15 informix ', concat(' ',key('env-param','m_connection_type'),' '))) or $enable-all!='true'">
									<out:attribute name="disabled">disabled</out:attribute>
								</out:if>
								<out:if test="$default_signon_checked='true'">
									<out:attribute name="checked">checked</out:attribute>
								</out:if>
							</utml:input>
						</out:otherwise>	
					</out:choose>
				</dp:section1>
				<dp:section2 for="ctrl_m_connection_default_signon">
					<out:text><xts:string id="IDS_SELECT_CONNECT_DEFAULT_SIGNON_HINT"/></out:text>
				</dp:section2>
				<dp:section3>
					<dp:input>
						<dp:section1 for="ctrl_m_connection_userid">
							<out:choose>
								<out:when test="$connectionType='json'">
									<out:choose>
										<out:when test="$authenticationType='APIKey'">
											<xts:string id="IDS_SELECT_CONNECT_KEY"/>
										</out:when>
										<out:when test="$authenticationType='OAuth1.0'">
											<xts:string id="IDS_SELECT_CONNECT_CONSUMER_KEY"/>
										</out:when>
										<out:when test="$authenticationType='OAuth2.0'">
											<xts:string id="IDS_SELECT_CONNECT_CLIENT_ID"/>
										</out:when>	
										<out:otherwise>
											<xts:string id="IDS_SELECT_CONNECT_USERID"/>
										</out:otherwise>		
									</out:choose>
								</out:when>
								<out:otherwise>
									<xts:string id="IDS_SELECT_CONNECT_USERID"/>	
								</out:otherwise>
							</out:choose>
						</dp:section1>
						<dp:section2>
							<utml:input type="text" name="m_connection_userid" size="53" id="ctrl_m_connection_userid">
								<out:if test="$enable-all!='true'">
									<out:attribute name="disabled">disabled</out:attribute>
								</out:if>
							</utml:input>
						</dp:section2>
					</dp:input>
					<dp:input>
						<dp:section1 for="ctrl_m_connection_password">
							<out:choose>
								<out:when test="$connectionType='json'">
									<out:choose>
										<out:when test="$authenticationType='APIKey'">
											<xts:string id="IDS_SELECT_CONNECT_VALUE"/>
										</out:when>
										<out:when test="$authenticationType='OAuth1.0'">
											<xts:string id="IDS_SELECT_CONNECT_CONSUMER_SECRET"/>
										</out:when>
										<out:when test="$authenticationType='OAuth2.0'">
											<xts:string id="IDS_SELECT_CONNECT_CLIENT_SECRET"/>
										</out:when>	
										<out:otherwise>
											<xts:string id="IDS_SELECT_CONNECT_PASSWORD"/>
										</out:otherwise>		
									</out:choose>
								</out:when>
								<out:otherwise>
									<xts:string id="IDS_SELECT_CONNECT_PASSWORD"/>
								</out:otherwise>
							</out:choose>
						</dp:section1>
						<dp:section2>
							<utml:input type="password" name="m_connection_password" size="53" utml:update="false" onchange="clearEncryptedPassword()" autocomplete="off" id="ctrl_m_connection_password">
								<out:if test="$enable-all!='true'">
									<out:attribute name="disabled">disabled</out:attribute>
								</out:if>
								<out:attribute name="value">
									<out:choose>
										<out:when test="key('env-param','passwordEncrypted')!=''">********</out:when>
										<out:otherwise></out:otherwise>
									</out:choose>
								</out:attribute>
							</utml:input>
						</dp:section2>
					</dp:input>
					<dp:input>
						<dp:section1 for="ctrl_m_connection_confirm_password">
							<out:choose>
								<out:when test="$connectionType='json'">
									<out:choose>
										<out:when test="$authenticationType='APIKey'">
											<xts:string id="IDS_SELECT_CONNECT_CONFIRM_VALUE"/>
										</out:when>
										<out:when test="$authenticationType='OAuth1.0'">
											<xts:string id="IDS_SELECT_CONNECT_CONFIRM_CONSUMER_SECRET"/>
										</out:when>
										<out:when test="$authenticationType='OAuth2.0'">
											<xts:string id="IDS_SELECT_CONNECT_CONFIRM_CLIENT_SECRET"/>
										</out:when>	
										<out:otherwise>
											<xts:string id="IDS_SELECT_CONNECT_CONFIRMPASSWORD"/>
										</out:otherwise>		
									</out:choose>
								</out:when>
								<out:otherwise>
									<xts:string id="IDS_SELECT_CONNECT_CONFIRMPASSWORD"/>
								</out:otherwise>
							</out:choose>
						</dp:section1>
						<dp:section2>
							<utml:input type="password" name="m_connection_confirm_password" size="53" utml:update="false" onchange="clearEncryptedPassword()" autocomplete="off" id="ctrl_m_connection_confirm_password">
								<out:if test="$enable-all!='true'">
									<out:attribute name="disabled">disabled</out:attribute>
								</out:if>
								<out:attribute name="value">
									<out:choose>
										<out:when test="key('env-param','passwordEncrypted')!=''">********</out:when>
										<out:otherwise></out:otherwise>
									</out:choose>
								</out:attribute>
							</utml:input>
						</dp:section2>
					</dp:input>
				</dp:section3>
			</dp:choice>
		</out:template>

		<out:template name="get-validations">
			<out:param name="connection-type"/>
			<out:param name="connection-variant"/>
			<out:param name="test" select="false()"/>
				<out:variable name="ODBC_UI" select="contains(' composite virtualviewmanager odbc openEdge sqlodbc redbrick teradata netezza sybaseIQ ', concat(' ',$connection-type,' '))"/>
				<out:variable name="m1">
					<out:choose>
						<out:when test="$connection-type='db2'">
							<xts:string id="IDS_SELECT_CONNECT_DB2_DATABASE" encode="javascript"/>
						</out:when>
						<out:when test="$connection-type='msas_xmla'">
							<xts:string id="IDS_SELECT_CONNECT_SERVER_MSAS_XMLA" encode="javascript"/>
						</out:when>
						<out:when test="contains(' cognosnow consolidation contributor contributorSeries7 dbtwoolap msanalysis2017 msanalysis2016 msanalysis2014 msanalysis2012 msanalysis2008 msanalysis2005 sql sql2005 sql2008 sql2012-2014 ' , concat(' ',$connection-type,' '))">
							<xts:string id="IDS_SELECT_CONNECT_DATASOURCE" encode="javascript"/>
						</out:when>
						<out:when test="$connection-type = 'oracle'">
							<xts:string id="IDS_SELECT_CONNECT_SQLNET_CONNECTSTRING" encode="javascript"/>
						</out:when>
						<out:when test="$connection-type = 'powercube'">
							<xts:string id="IDS_SELECT_CONNECT_POWERCUBE_WIN_LOCATION" encode="javascript"/>
						</out:when>
						<out:when test="$ODBC_UI">
							<xts:string id="IDS_SELECT_CONNECT_ODBC_DATASOURCE" encode="javascript"/>
						</out:when>
						<out:when test="$connection-type = 'sybase' or $connection-type = 'sybase_ct15'">
							<xts:string id="IDS_SELECT_CONNECT_SYBASE_SERVER" encode="javascript"/>
						</out:when>
						<out:when test="$connection-type = 'sap' and key('env-param','m_connection_sap_type') = 'messageServer'">
							<xts:string id="IDS_SELECT_CONNECT_SAP_MESSAGE_LABEL" encode="javascript"/>
						</out:when>
						<out:when test="$connection-type = 'sap'  and key('env-param','m_connection_sap_type') = 'destination'">
							<xts:string id="IDS_SELECT_CONNECT_SAP_DESTINATION_LABEL" encode="javascript"/>
						</out:when>
						<out:when test="$connection-type = 'sap'">
							<xts:string id="IDS_SELECT_CONNECT_SAP_APPLICATION_LABEL" encode="javascript"/>
						</out:when>
						<out:when test="$connection-type = 'sapR3' or $connection-type = 'sapECC'">
							<xts:string id="IDS_SELECT_CONNECT_SAPR3_HOSTNAME" encode="javascript"/>
						</out:when>
						<out:when test="$connection-type = 'informix'">
							<xts:string id="IDS_SELECT_CONNECT_INFORMIX_DATABASE" encode="javascript"/>
						</out:when>
						<out:when test="$connection-type = 'tm1' or $connection-type = 'tm1R'">
							<xts:string id="IDS_SELECT_CONNECT_SERVER_TM" encode="javascript"/>
						</out:when>
						<out:when test="$connection-type = 'odata'">
							<xts:string id="IDS_SELECT_CONNECT_SERVICE_ROOT_URI" encode="javascript"/>
						</out:when>
					</out:choose>
				</out:variable>
				<out:variable  name="m11">
					<out:choose>
						<out:when test="$connection-type='dbtwoolap'">
							<xts:string id="IDS_SELECT_CONNECT_DB2OLAP_DBNAME" encode="javascript"/>
						</out:when>
					</out:choose>
				</out:variable>
				var m1 = "<out:value-of select="$m1"/>";
				var m2 = "<xts:string id="IDS_SELECT_CONNECT_DATABASE_NAME" encode="javascript"/>";
				var m3 = "<xts:string id="IDS_SELECT_CONNECT_SYSTEM_NUMBER" encode="javascript"/>";
				var m4 = "<xts:string id="IDS_SELECT_CONNECT_LOGON_GROUP" encode="javascript"/>";
				var m5 = "<xts:string id="IDS_SELECT_CONNECT_CLIENT_NUMBER" encode="javascript"/>";
				var m6 = "<xts:string id="IDS_SELECT_CONNECT_OTHER_CONNECTSTRING" encode="javascript"/>";
				var m7 = "<xts:string id="IDS_SELECT_CONNECT_USERID" encode="javascript"/>";
				var m8 = "<xts:string id="IDS_ERR_0003_PASSWORD_VERIF_FAILED" encode="javascript"/>";
				var m9 = "<xts:string id="IDS_SELECT_CONNECT_SYSTEM_ID" encode="javascript"/>";
				var m10 = "<xts:string id="IDS_SELECT_CONNECT_CONTRIBUTOR_PADID" encode="javascript"/>";
				var m11 = "<out:value-of select="$m11"/>";
				var m12 = "<xts:string id="IDS_SELECT_CONNECT_POWERCUBE_UNIX_LOCATION" encode="javascript"/>";
				var m13 = "<xts:string id="IDS_SELECT_CONNECT_HOST_TM" encode="javascript"/>";
				var m14 = "<xts:string id="IDS_SELECT_CONNECT_FILE_NAME_PATH" encode="javascript"/>";
				var m15 = "<xts:string id="IDS_SELECT_CONNECT_PORTNUMBER" encode="javascript"/>";
				var m16 = "<xts:string id="IDS_SELECT_CONNECT_PASSWORD" encode="javascript"/>"
				var m17 = "<xts:string id="IDS_SELECT_CONNECT_URL" encode="javascript"/>";
				var m18 = "<xts:string id="IDS_SELECT_CONNECT_SCHEMA" encode="javascript"/>";
				
				var m19 = "<xts:string id="IDS_SELECT_CONNECT_KEY" encode="javascript"/>";
				var m20 = "<xts:string id="IDS_SELECT_CONNECT_VALUE" encode="javascript"/>";
				var m21 = "<xts:string id="IDS_SELECT_CONNECT_SITE" encode="javascript"/>";
				var m22 = "<xts:string id="IDS_SELECT_CONNECT_CONSUMER_KEY" encode="javascript"/>";
				var m23 = "<xts:string id="IDS_SELECT_CONNECT_CONSUMER_SECRET" encode="javascript"/>";
				var m24 = "<xts:string id="IDS_SELECT_CONNECT_TEMPORARY_TOKEN_ENDPOINT" encode="javascript"/>";
				var m25 = "<xts:string id="IDS_SELECT_CONNECT_AUTHORIZATION_ENDPOINT" encode="javascript"/>";
				var m26 = "<xts:string id="IDS_SELECT_CONNECT_TOKEN_ENDPOINT" encode="javascript"/>";
				var m27 = "<xts:string id="IDS_SELECT_CONNECT_CLIENT_ID" encode="javascript"/>";
				var m28 = "<xts:string id="IDS_SELECT_CONNECT_CLIENT_SECRET" encode="javascript"/>";
				var m29 = "<xts:string id="IDS_SELECT_CONNECT_SCOPE" encode="javascript"/>"
				
				<out:if test="$connection-type = 'filenet'">
					var filenetMeta = [
						{fieldName: "m_connection_jdbc_url", warningMessage: "<xts:string id="IDS_SELECT_CONNECT_FILENET_URL" encode="javascript"/>"},
						{fieldName: "m_connection_jdbc_driverclass", warningMessage: "<xts:string id="IDS_SELECT_CONNECT_JDBC_DRIVER_CLASS" encode="javascript"/>"},
						{fieldName: "m_connection_file", warningMessage: "<xts:string id="IDS_SELECT_CONNECT_ROOT_PATH" encode="javascript"/>"}
					];
					if (f.m_connection_jdbc_driverclass.value == 'FileSystem') {
						filenetMeta[0].warningMessage="<xts:string id="IDS_PROP_CONN_REPOSITORY_FS_ROOT" encode="javascript"/>";
						if (f.fsAliasRoot_select.length==0) {
							window.alert("<xts:string id="IDS_PROP_CONN_REPOSITORY_FS_ROOT_NONE" encode="javascript"/>");
							f.fsAliasRoot_select.focus();
							return false;
						}
					}
					
					for (var i=0; i&lt;filenetMeta.length; i++){
						var item = filenetMeta[i];
						var field = f[item.fieldName];
						var message = item.warningMessage;
						if (field){
							if (item.fieldName == 'm_connection_file' &amp;&amp; f.m_connection_jdbc_driverclass.value == 'FileSystem') {
								if (!checkReservedChar(field, message)){
									return false;
								}
							} else {
								if (!checkMandatory(field, message) || !checkReservedChar(field, message)){
									return false;
								}
							}
						}
					}
				</out:if>
				<out:if test="$connection-type='odata'">
					if (f.m_connection_service_root_URI)
					{
						if (!checkMandatory(f.m_connection_service_root_URI, m1))
						{
							return false;
						}

						if (!checkReservedChar(f.m_connection_service_root_URI, m1))
						{
							return false;
						}
					}
				</out:if>
				<out:if test="$connection-type='json'">
					var id_label = '';
					var pwd_label = '';
					if (f.m_connection_url)
					{
						if (!checkMandatory(f.m_connection_url, m17))
						{
							return false;
						}
						
						if (!checkReservedChar(f.m_connection_url, m17))
						{
							return false;
						}
						
						if(!checkURLFormat(f.m_connection_url)) 
						{
						 	return false;
						}
					}
					if (f.m_connection_schema)
					{
						if (!checkReservedChar(f.m_connection_schema, m18))
						{
							return false;
						}
					}
					if (f.m_connection_authentication_type.value == 'Basic')
					{
						id_label = m7;
						pwd_label = m16;
					}
					if (f.m_connection_authentication_type.value == 'APIKey')
					{
						id_label = m19;
						pwd_label = m20;
					}
					if (f.m_connection_authentication_type.value == 'OAuth1.0')
					{
						id_label = m22;
						pwd_label = m23;
						if (f.m_connection_temporary_token_endpoint) {
							if(!checkEndpointFormat(f.m_connection_temporary_token_endpoint)) 
							{
							 	return false;
							}
							
							if (!checkMandatory(f.m_connection_temporary_token_endpoint, m24))
							{
								return false;
							}
							
							if (!checkReservedChar(f.m_connection_temporary_token_endpoint, m24))
							{
								return false;
							}
						}
					}
					
					if (f.m_connection_authentication_type.value == 'OAuth2.0')
					{
						id_label = m27;
						pwd_label = m28;
						if (f.m_connection_scope) {
							if (!checkReservedChar(f.m_connection_scope, m29))
							{
								return false;
							}
						}
					}
					
					if ( f.m_connection_authentication_type.value != 'None')
					{
						if(f.m_connection_userid) 
						{
							if (!checkMandatory(f.m_connection_userid, id_label))
							{
								return false;
							}
								
							if (!checkReservedChar(f.m_connection_userid, id_label))
							{
								return false;
							}
						}
						
						if(f.m_connection_password) 
						{
							if (!checkMandatory(f.m_connection_password, pwd_label))
							{
								return false;
							}
								
							if (!checkReservedChar(f.m_connection_password, pwd_label))
							{
								return false;
							}
						}
			
						if (f.m_connection_password.value != f.m_connection_confirm_password.value)
						{
							alert(m8);
							return false;
						}
					}
					
					if (f.m_connection_authentication_type.value.indexOf('OAuth') > -1)
					{
						if (f.m_connection_authorization_endpoint) {
							if(!checkEndpointFormat(f.m_connection_authorization_endpoint)) 
							{
							 	return false;
							}
							
							if (!checkMandatory(f.m_connection_authorization_endpoint, m25))
							{
								return false;
							}
							
							if (!checkReservedChar(f.m_connection_authorization_endpoint, m25))
							{
								return false;
							}
						}
						
						if (f.m_connection_token_endpoint) {
							if(!checkEndpointFormat(f.m_connection_token_endpoint)) 
							{
							 	return false;
							}
							
							if (!checkMandatory(f.m_connection_token_endpoint, m26))
							{
								return false;
							}
							
							if (!checkReservedChar(f.m_connection_token_endpoint, m26))
							{
								return false;
							}
						}
					}					 
				</out:if>
				<out:if test="contains(' consolidation contributorSeries7 tm1 tm1R dbtwoolap msanalysis2017 msanalysis2016 msanalysis2014 msanalysis2012 msanalysis2008 msanalysis2005 msas_xmla ' ,concat(' ',$connection-type,' '))">

					<out:if test="$connection-type='tm1' or $connection-type='tm1R'">
						if (f.m_connection_hostname)
						{
							if (!checkMandatory(f.m_connection_hostname, m13))
							{
								return false;
							}

							if (!checkReservedChar(f.m_connection_hostname, m13))
							{
								return false;
							}
						}
					</out:if>

					if (f.m_connection_servername)
					{
						if (!checkMandatory(f.m_connection_servername, m1))
						{
							return false;
						}

						if (!checkReservedChar(f.m_connection_servername, m1))
						{
							return false;
						}
						<out:if test="contains('msanalysis2017 msanalysis2016 msanalysis2014 msanalysis2012 msanalysis2008 msanalysis2005' ,$connection-type)">
						if (!checkInvalidChar(f.m_connection_servername, m1, '\\'))
						{
							return false;
						}
						</out:if>
					}

				</out:if>
				<out:if test="contains('cognosnow' ,$connection-type)">
					if (f.m_connection_servername)
					{
						if (!checkMandatory(f.m_connection_servername, m1))
						{
							return false;
						}

						if (!checkReservedChar(f.m_connection_servername, m1))
						{
							return false;
						}
					}
					if (f.m_connection_file)
					{
						if (!checkMandatory(f.m_connection_file, m14))
						{
							return false;
						}

						if (!checkReservedChar(f.m_connection_file, m14))
						{
							return false;
						}

						if (!checkMandatoryStartingChar(f.m_connection_file, m14, '/'))
						{
							return false;
						}
					}

				</out:if>

        <!-- javascript validation specific to the port number field shown for these 3 types of connection -->
        <out:if test="contains('consolidation contributorSeries7 cognosnow' ,$connection-type)">
          if (f.m_connection_port) {
            if (!checkMandatory(f.m_connection_port, m15)) {
              return false;
            }
            if (!isPortRangeValid(f.m_connection_port)) {
              //invalid port range
              alert('<xts:string id="IDS_PROP_CONN_PORT_NUMBER_ERROR" encode="javascript"/>');
              CAFSelectText(f.m_connection_port,f.m_connection_port.value);
              return false;
            }
          }
        </out:if>

				<out:if test="$connection-type='contributorSeries7'">
					if (f.m_connection_padid)
					{

						if (trim(f.m_connection_padid.value) != '' &amp;&amp; trim(f.m_p_credentialNamespaces.value) == '')
						{
							alert('<xts:string id="IDS_PROP_CONN_PLANNING_NO_NAMESPACE_WARNING" encode="javascript"/>');
							return false;
						}

						if (!checkReservedChar(f.m_connection_padid, m10))
						{
							return false;
						}
					}
				</out:if>

				<out:if test="$connection-type='powercube'">
					if (f.m_connection_windows_cube)
					{
						if (!checkMandatory(f.m_connection_windows_cube, m1))
						{
							return false;
						}

						if (!checkReservedChar(f.m_connection_windows_cube, m1))
						{
							return false;
						}
					}
					if (f.m_connection_unix_cube)
					{
						if (!checkReservedChar(f.m_connection_unix_cube, m12))
						{
							return false;
						}
						if (!checkInvalidChar(f.m_connection_unix_cube, m12, '\\'))
						{
							return false;
						}
					}
				</out:if>

				<out:if test="$ODBC_UI or contains(' db2 sql sql2005 sql2008 sql2012-2014 oracle sybase sybase_ct15 informix sap ', concat(' ',$connection-type,' '))">
					if (f.m_connection_database)
					{
						<out:if test= "count(/root/env/param[@name='m_create_jdbc']) = 0 and count(/root/env/param[@name='m_connection_enable_JDBC']) = 0">
							if (!checkMandatory(f.m_connection_database, m1))
							{
								return false;
							}
						</out:if>

						if (!checkReservedChar(f.m_connection_database, m1))
						{
							return false;
						}
						<out:if test="$connection-type='oracle'">
							if (!checkInvalidChar(f.m_connection_database, m1, '/'))
							{
								return false;
							}
						</out:if>
					}

					<out:if test="$connection-type='sap'">
						if (f.m_connection_sys_no &amp;&amp; (isNaN(f.m_connection_sys_no.value) || parseInt(f.m_connection_sys_no.value, 10) != f.m_connection_sys_no.value || f.m_connection_sys_no.value &lt; 0))
						{
							window.alert('<xts:string id="IDS_VAL_ERR_UNSIGNED_INTEGER" encode="javascript"/>');
							f.m_connection_sys_no.focus();
							return false;
						}
						if (f.m_connection_client_no &amp;&amp; (isNaN(f.m_connection_client_no.value) &amp;&amp; parseInt(f.m_connection_client_no.value, 10) != f.m_connection_client_no.value || f.m_connection_client_no.value &lt; 0))
						{
							window.alert('<xts:string id="IDS_VAL_ERR_UNSIGNED_INTEGER" encode="javascript"/>');
							f.m_connection_client_no.focus();
							return false;
						}
					</out:if>

				</out:if>
				<out:if test="$connection-type = 'sapR3' or $connection-type = 'sapECC'">
					var mR32 = "<xts:string id="IDS_SELECT_CONNECT_SAPR3_SYSTEMNUMBER" encode="javascript"/>";
					var mR33 = "<xts:string id="IDS_SELECT_CONNECT_SAPR3_GATEWAY_HOST" encode="javascript"/>";
					var mR34 = "<xts:string id="IDS_SELECT_CONNECT_SAPR3_GATEWAY_SERVICE" encode="javascript"/>";
					var mR35 = "<xts:string id="IDS_SELECT_CONNECT_SAPR3_DESTINATION" encode="javascript"/>";
					var mR36 = "<xts:string id="IDS_SELECT_CONNECT_SAPR3_CLIENT" encode="javascript"/>";
					var mR37 = "<xts:string id="IDS_SELECT_CONNECT_SAPR3_LANGUAGE" encode="javascript"/>";
					if (f.m_connection_hostname)
					{
						if (!checkMandatory(f.m_connection_hostname, m1))
						{
							return false;
						}

						if (!checkReservedChar(f.m_connection_hostname, m1))
						{
							return false;
						}
					}
					if (f.m_connection_sys_no)
					{
						if (!checkMandatory(f.m_connection_sys_no, mR32))
						{
							return false;
						}
						if (isNaN(f.m_connection_sys_no.value) &amp;&amp; parseInt(f.m_connection_sys_no.value, 10) != f.m_connection_sys_no.value || f.m_connection_sys_no.value &lt; 0)
						{
							window.alert('<xts:string id="IDS_VAL_ERR_UNSIGNED_INTEGER" encode="javascript"/>');
							f.m_connection_sys_no.focus();
							return false;
						}
					}
					if (f.m_connection_gateway_host)
					{
						if (!checkMandatory(f.m_connection_gateway_host, mR33))
						{
							return false;
						}

						if (!checkReservedChar(f.m_connection_gateway_host, mR33))
						{
							return false;
						}
					}
					if (f.m_connection_gateway_service)
					{
						if (!checkMandatory(f.m_connection_gateway_service, mR34))
						{
							return false;
						}
					}
					if (f.m_connection_destination)
					{
						if (!checkMandatory(f.m_connection_destination, mR35))
						{
							return false;
						}
					}
					if (f.m_connection_client)
					{
						if (!checkMandatory(f.m_connection_client, mR36))
						{
							return false;
						}
					}
					if (f.m_connection_language)
					{
						if (!checkMandatory(f.m_connection_sap_language, mR37))
						{
							return false;
						}
					}
				</out:if>

				<out:if test="$connection-type='sr3' and not($test)">				
					var sR31 = "<xts:string id="IDS_SELECT_CONNECT_SAPR3_APPLICATION_SERVER" encode="javascript"/>";
					var sR32 = "<xts:string id="IDS_SELECT_CONNECT_SAPR3_ROUTER_STRING" encode="javascript"/>";
					var sR33 = "<xts:string id="IDS_SELECT_CONNECT_SAPR3_SYSTEM_NUMBER" encode="javascript"/>";
					var sR34 = "<xts:string id="IDS_SELECT_CONNECT_SAPR3_CLIENT" encode="javascript"/>";
					var sR35 = "<xts:string id="IDS_SELECT_CONNECT_SAPR3_LANG" encode="javascript"/>";
					var sR36 = "<xts:string id="IDS_SELECT_CONNECT_SAPR3_MAX_CONN_IN_POOL" encode="javascript"/>";
					var sR37 = "<xts:string id="IDS_SELECT_CONNECT_SAPR3_TABLE_READ_FUNCTION" encode="javascript"/>";
					var sR38 = "<xts:string id="IDS_SELECT_CONNECT_SAPR3_TABLE_ROW_COUNT" encode="javascript"/>";
					var sR39 = "<xts:string id="IDS_SELECT_CONNECT_SAPR3_ABAP_QUERY_DB_ACCESS_LIMIT" encode="javascript"/>";
					var sR310 = "<xts:string id="IDS_SELECT_CONNECT_SAPR3_MESSAGE_SERVER" encode="javascript"/>";
					var sR311 = "<xts:string id="IDS_SELECT_CONNECT_SAPR3_SYSTEM_ID" encode="javascript"/>";
					var sR312 = "<xts:string id="IDS_SELECT_CONNECT_SAPR3_LOGON_GROUP" encode="javascript"/>";

					if (f.m_connection_use_loadbalancing_hidden)
					{
						if (f.m_connection_use_loadbalancing_hidden.value=="true")
						{
							if (f.m_connection_message_server)
							{
								if (!checkMandatory(f.m_connection_message_server, sR310))
								{
									return false;
								}
							}

							if (f.m_connection_system_id)
							{
								if (!checkMandatory(f.m_connection_system_id, sR311))
								{
									return false;
								}
							}

							if (f.m_connection_logon_group)
							{
								if (!checkMandatory(f.m_connection_logon_group, sR312))
								{
									return false;

								}
							}

						}
						else
						{

							if (f.m_connection_application_server)
							{
								if (!checkMandatory(f.m_connection_application_server, sR31))
								{
									return false;
								}
							}

							if (f.m_connection_system_number)
							{
								if (!checkMandatory(f.m_connection_system_number, sR33))
								{
									return false;

								}
							}
						
						}
					}

					if (f.m_connection_client)
					{
						if (!checkMandatory(f.m_connection_client, sR34))
						{
							return false;
						}
					}
					
					if (f.m_connection_language)
					{
						if (!checkMandatory(f.m_connection_language, sR35))
						{
							return false;
						}
					}

					
					if (f.m_connection_max_conn_in_pool)
					{
						if (!checkMandatory(f.m_connection_max_conn_in_pool, sR36) || isNaN(f.m_connection_max_conn_in_pool.value))
						{
							window.alert('<xts:string id="IDS_VAL_ERR_UNSIGNED_INTEGER" encode="javascript"/>');
							f.m_connection_max_conn_in_pool.focus();
							return false;
						}
					}

					
					if (f.m_connection_table_read_function)
					{
						if (!checkMandatory(f.m_connection_table_read_function, sR37))
						{
							return false;
						}
					}

					
					if (f.m_connection_table_row_count)
					{
						if (!checkMandatory(f.m_connection_table_row_count, sR38) || isNaN(f.m_connection_table_row_count.value))
						{
							window.alert('<xts:string id="IDS_VAL_ERR_UNSIGNED_INTEGER" encode="javascript"/>');
							f.m_connection_table_row_count.focus();
							return false;
						}
					}

					if (f.m_connection_abap_query_db_access_limit)
					{
						if (!checkMandatory(f.m_connection_abap_query_db_access_limit, sR39) || isNaN(f.m_connection_abap_query_db_access_limit.value))
						{
							window.alert('<xts:string id="IDS_VAL_ERR_UNSIGNED_INTEGER" encode="javascript"/>');
							f.m_connection_abap_query_db_access_limit.focus();
							return false;
						}
					}

				</out:if>

				
				<out:if test="$connection-type='siebel' and not($test)">				
					var sb1 = "<xts:string id="IDS_SELECT_CONNECT_SIEBEL_GATEWAYNAMESERVER" encode="javascript"/>";
					var sb2 = "<xts:string id="IDS_SELECT_CONNECT_SIEBEL_GATEWAYPORT" encode="javascript"/>";
					var sb3 = "<xts:string id="IDS_SELECT_CONNECT_SIEBEL_ENTERPRISENAME" encode="javascript"/>";
					var sb4 = "<xts:string id="IDS_SELECT_CONNECT_SIEBEL_AOM" encode="javascript"/>";
					var sb5 = "<xts:string id="IDS_SELECT_CONNECT_SIEBEL_LANGUAGE" encode="javascript"/>";
					var sb6 = "<xts:string id="IDS_SELECT_CONNECT_SIEBEL_REPOSITORY" encode="javascript"/>";
					var sb7 = "<xts:string id="IDS_SELECT_CONNECT_SIEBEL_LIBRARY" encode="javascript"/>";
					var sb8 = "<xts:string id="IDS_SELECT_CONNECT_SIEBEL_CODEPAGE" encode="javascript"/>";
					var sb9 = "<xts:string id="IDS_SELECT_CONNECT_SIEBEL_TRANSPORT" encode="javascript"/>";
					var sb10 = "<xts:string id="IDS_SELECT_CONNECT_SIEBEL_COMPRESSION" encode="javascript"/>";
					var sb11 = "<xts:string id="IDS_SELECT_CONNECT_SIEBEL_ENCRYPTION" encode="javascript"/>";
					var sb12 = "<xts:string id="IDS_SELECT_CONNECT_SIEBEL_LOGIN_RETRIES" encode="javascript"/>";
					var sb13 = "<xts:string id="IDS_SELECT_CONNECT_SIEBEL_LOGIN_RETRY_DELAY" encode="javascript"/>";
					var sb14 = "<xts:string id="IDS_SELECT_CONNECT_SIEBEL_MAX_RECORDS" encode="javascript"/>";
					var sb15 = "<xts:string id="IDS_SELECT_CONNECT_SIEBEL_VIEWMODE" encode="javascript"/>";
					var sb16 = "<xts:string id="IDS_SELECT_CONNECT_SIEBEL_SEARCHONLYWITHINPRIMARYRECORDS_FOR_MVF" encode="javascript"/>";
					var sb17 = "<xts:string id="IDS_SELECT_CONNECT_SIEBEL_ADV_PARAMETERS" encode="javascript"/>";


					if (f.m_connection_gatewayserver)
					{
						if (!checkMandatory(f.m_connection_gatewayserver, sb1))
						{
							return false;
						}
					}
					
					if (f.m_connection_gatewayport)
					{
						if (!checkMandatory(f.m_connection_gatewayport, sb2))
						{
							return false;
						}
					} 
					else if (isNaN(f.m_connection_gatewayport.value))
					{
						window.alert('<xts:string id="IDS_VAL_ERR_UNSIGNED_INTEGER" encode="javascript"/>');
						f.m_connection_gatewayport.focus();
						return false;
					}

					
					
					if (f.m_connection_enterprise_name)
					{
						if (!checkMandatory(f.m_connection_enterprise_name, sb3))
						{
							return false;
						}
					}

					
					if (f.m_connection_aom)
					{
						if (!checkMandatory(f.m_connection_aom, sb4))
						{
							return false;
						}
					}

					if (f.m_connection_language)
					{
						if (!checkMandatory(f.m_connection_language, sb5))
						{
							return false;
						}
					}
					
					
					
					if (f.m_connection_login_retries)
					{
					
						
					}
					else if (isNaN(f.m_connection_login_retries.value))
					{
						window.alert('<xts:string id="IDS_VAL_ERR_UNSIGNED_INTEGER" encode="javascript"/>');
						f.m_connection_login_retries.focus();
						return false;
					}
					
					if (f.m_connection_login_retry_delay)
					{
						
					
					}
					else if (isNaN(f.m_connection_login_retry_delay.value))
					{
						window.alert('<xts:string id="IDS_VAL_ERR_UNSIGNED_INTEGER" encode="javascript"/>');
						f.m_connection_login_retry_delay.focus();
						return false;
					}
					
				</out:if>

				<out:if test="$connection-type='sfdc' and not($test)">				
					var sfdc1 = "<xts:string id="IDS_SELECT_CONNECT_SFDC_URL" encode="javascript"/>";
					var sfdc2 = "<xts:string id="IDS_SELECT_CONNECT_SFDC_CONCC_CALLS_LIMIT" encode="javascript"/>";
					var sfdc3 = "<xts:string id="IDS_SELECT_CONNECT_SFDC_USER_CONCC_CALLS_LIMIT" encode="javascript"/>";
					var sfdc4 = "<xts:string id="IDS_SELECT_CONNECT_SFDC_CONN_TIMEOUT" encode="javascript"/>";
					var sfdc5 = "<xts:string id="IDS_SELECT_CONNECT_SFDC_QUERY_BATCH_SIZE" encode="javascript"/>";
					var sfdc6 = "<xts:string id="IDS_SELECT_CONNECT_SFDC_MAX_RETRIES" encode="javascript"/>";
					var sfdc7 = "<xts:string id="IDS_SELECT_CONNECT_SFDC_WAIT_BETWEEN_RETRIES" encode="javascript"/>";
					var sfdc8 = "<xts:string id="IDS_SELECT_CONNECT_SFDC_PROXY_ENABLED" encode="javascript"/>";
					var sfdc9 = "<xts:string id="IDS_SELECT_CONNECT_SFDC_PROXY_HOST" encode="javascript"/>";
					var sfdc10 = "<xts:string id="IDS_SELECT_CONNECT_SFDC_PROXY_PORT" encode="javascript"/>";
					var sfdc11 = "<xts:string id="IDS_SELECT_CONNECT_SFDC_PROXY_USER" encode="javascript"/>";
					var sfdc12 = "<xts:string id="IDS_SELECT_CONNECT_SFDC_PROXY_PWD" encode="javascript"/>";
					var sfdc13 = "<xts:string id="IDS_SELECT_CONNECT_SFDC_REST_ENABLED" encode="javascript"/>";
					var sfdc14 = "<xts:string id="IDS_SELECT_CONNECT_SFDC_REST_CLIENTID" encode="javascript"/>";
					var sfdc15 = "<xts:string id="IDS_SELECT_CONNECT_SFDC_REST_CLIENT_SECRET" encode="javascript"/>";

						
					if (f.m_connection_url)
					{
						if (!checkMandatory(f.m_connection_url, sfdc1))
						{
							return false;
						}
					}
					
					if (f.m_connection_conc_calls_limit)
					{
						if (!checkMandatory(f.m_connection_conc_calls_limit, sfdc2))
						{
							return false;
						}
						else if (isNaN(f.m_connection_conc_calls_limit.value))
						{
							window.alert('<xts:string id="IDS_VAL_ERR_UNSIGNED_INTEGER" encode="javascript"/>');
							f.m_connection_conc_calls_limit.focus();
							return false;
						}
					}

					
					if (f.m_connection_user_conc_calls_limit)
					{
						if (!checkMandatory(f.m_connection_user_conc_calls_limit, sfdc3))
						{
							return false;
						}
						else if (isNaN(f.m_connection_user_conc_calls_limit.value))
						{
							window.alert('<xts:string id="IDS_VAL_ERR_UNSIGNED_INTEGER" encode="javascript"/>');
							f.m_connection_user_conc_calls_limit.focus();
							return false;
						}
					}

					
					if (f.m_connection_timeout)
					{
						if (!checkMandatory(f.m_connection_timeout, sfdc4))
						{
							return false;
						}
						else if (isNaN(f.m_connection_timeout.value))
						{
							window.alert('<xts:string id="IDS_VAL_ERR_UNSIGNED_INTEGER" encode="javascript"/>');
							f.m_connection_timeout.focus();
							return false;
						}
					}

					
					if (f.m_connection_query_batch_size)
					{
						if (!checkMandatory(f.m_connection_query_batch_size, sfdc5))
						{
							return false;
						} 
						else if (isNaN(f.m_connection_query_batch_size.value))
						{
							window.alert('<xts:string id="IDS_VAL_ERR_UNSIGNED_INTEGER" encode="javascript"/>');
							f.m_connection_query_batch_size.focus();
							return false;
						}
					}

					if (f.m_connection_max_retries)
					{
						if (!checkMandatory(f.m_connection_max_retries, sfdc6))
						{
							return false;
						}
						else if (isNaN(f.m_connection_max_retries.value))
						{
							window.alert('<xts:string id="IDS_VAL_ERR_UNSIGNED_INTEGER" encode="javascript"/>');
							f.m_connection_max_retries.focus();
							return false;
						}
					}

					
					if (f.m_connection_wait_between_retries)
					{
						if (!checkMandatory(f.m_connection_wait_between_retries, sfdc7))
						{
							return false;
						}
						else if (isNaN(f.m_connection_wait_between_retries.value))
						{
							window.alert('<xts:string id="IDS_VAL_ERR_UNSIGNED_INTEGER" encode="javascript"/>');
							f.m_connection_wait_between_retries.focus();
							return false;
						}
					}

				</out:if>
				<out:if test="$connection-type='sap' and not($test)">
					<out:if test="key('env-param','m_connection_sap_type') = 'applicationServer'">
					if (f.m_connection_sys_no)
					{
						if (!checkMandatory(f.m_connection_sys_no, m3))
						{
							return false;
						}
					}
					</out:if>

					<out:if test="key('env-param','m_connection_sap_type') = 'messageServer'">
					if (f.m_connection_sys_id)
					{
						if (!checkMandatory(f.m_connection_sys_id, m9))
						{
							return false;
						}
					}

					if (f.m_connection_logon)
					{
						if (!checkMandatory(f.m_connection_logon, m4))
						{
							return false;
						}
					}
					</out:if>

					if (f.m_connection_client_no)
					{
						if (!checkMandatory(f.m_connection_client_no, m5))
						{
							return false;
						}
					}
				</out:if>

				<out:if test="contains('xml', $connection-type)">
					if (f.m_p_connectionString)
					{
						if (!checkMandatory(f.m_connection_database, m6))
						{
							return false;
						}
					}
				</out:if>

				<out:if test="contains('other', $connection-type)">
					if (f.m_other_connectionString)
					{
						if (!checkMandatory(f.m_other_connectionString, m6))
						{
							return false;
						}
					}
				</out:if>

				<out:choose>
					<out:when test="$connection-type='db2'">
						<!-- connection string -->
						if (!checkReservedChar(f.m_connection_string, '<xts:string id="IDS_SELECT_CONNECT_DB2_CONNECTSTRING" encode="javascript"/>'))
						{
							return false;
						}
						<!-- Collation sequence -->
						if (!checkReservedChar(f.m_connection_colseq, '<xts:string id="IDS_SELECT_CONNECT_COLSEQ" encode="javascript"/>'))
						{
							return false;
						}
					</out:when>
					<out:when test="contains(' sql sql2005 sql2008 sql2012-2014 ', concat(' ',$connection-type,' '))">
						<!-- database name -->
						if (!checkReservedChar(f.m_connection_sql_database_name, m2))
						{
							return false;
						}
						<!-- Application name -->
						if (!checkReservedChar(f.m_connection_sql_application, '<xts:string id="IDS_SELECT_CONNECT_SYBASE_APPLICATION" encode="javascript"/>'))
						{
							return false;
						}
						<!-- Collation sequence -->
						if (!checkReservedChar(f.m_connection_colseq, '<xts:string id="IDS_SELECT_CONNECT_COLSEQ" encode="javascript"/>'))
						{
							return false;
						}
					</out:when>
					<out:when test="$connection-type = 'oracle'">
						<!-- Collation sequence -->
						if (!checkReservedChar(f.m_connection_colseq, '<xts:string id="IDS_SELECT_CONNECT_COLSEQ" encode="javascript"/>'))
						{
							return false;
						}
					</out:when>
					<out:when test="$ODBC_UI">
						<!-- ODBC Connect string can contain semi-columns to allow users to enter more than one parameter
							In ODBC, parameter are separated by semi-columns.
						-->
						<!-- Collation sequence -->
						if (!checkReservedChar(f.m_connection_colseq, '<xts:string id="IDS_SELECT_CONNECT_COLSEQ" encode="javascript"/>'))
						{
							return false;
						}
					</out:when>
					<out:when test="$connection-type = 'sybase' or $connection-type = 'sybase_ct15'">
						<!-- Database name -->
						if (!checkReservedChar(f.m_connection_sybase_database_name, m2))
						{
							return false;
						}
						<!-- Application name -->
						if (!checkReservedChar(f.m_connection_sybase_application, '<xts:string id="IDS_SELECT_CONNECT_SYBASE_APPLICATION" encode="javascript"/>'))
						{
							return false;
						}
						<!-- Collation sequence -->
						if (!checkReservedChar(f.m_connection_colseq, '<xts:string id="IDS_SELECT_CONNECT_COLSEQ" encode="javascript"/>'))
						{
							return false;
						}
					</out:when>
					<out:when test="$connection-type = 'sap' and key('env-param','m_connection_sap_type') = 'messageServer'">
						<!-- system ID -->
						if (!checkReservedChar(f.m_connection_sys_id, '<xts:string id="IDS_SELECT_CONNECT_SYSTEM_ID" encode="javascript"/>'))
						{
							return false;
						}
						<!-- Logon group -->
						if (!checkReservedChar(f.m_connection_logon, '<xts:string id="IDS_SELECT_CONNECT_LOGON_GROUP" encode="javascript"/>'))
						{
							return false;
						}
						<!-- SAP router string -->
						if (!checkReservedChar(f.m_connection_router_string, '<xts:string id="IDS_SELECT_CONNECT_ROUTER_STRING" encode="javascript"/>'))
						{
							return false;
						}
					</out:when>
					<out:when test="$connection-type = 'sap'  and key('env-param','m_connection_sap_type') = 'applicationServer'">
						<!-- SAP router string -->
						if (!checkReservedChar(f.m_connection_router_string, '<xts:string id="IDS_SELECT_CONNECT_ROUTER_STRING" encode="javascript"/>'))
						{
							return false;
						}
					</out:when>
					<out:when test="$connection-type = 'informix'">
						<!-- Host name -->
						if (!checkReservedChar(f.m_connection_hostname, '<xts:string id="IDS_SELECT_CONNECT_INFORMIX_HOSTNAME" encode="javascript"/>'))
						{
							return false;
						}
						<!-- Server name -->
						if (!checkReservedChar(f.m_connection_servername, '<xts:string id="IDS_SELECT_CONNECT_INFORMIX_SERVERNAME" encode="javascript"/>'))
						{
							return false;
						}
						<!-- Collation sequence -->
						if (!checkReservedChar(f.m_connection_colseq, '<xts:string id="IDS_SELECT_CONNECT_COLSEQ" encode="javascript"/>'))
						{
							return false;
						}
						<!-- Service -->
						if (!checkReservedChar(f.m_connection_service_name, '<xts:string id="IDS_SELECT_CONNECT_INFORMIX_SERVICE" encode="javascript"/>'))
						{
							return false;
						}
					</out:when>
					
					<out:when test="starts-with($connection-type, 'jdbc-')">

						<out:for-each select="/root/*[local-name()='datasources' or local-name()='jdbcdatasources']/datasource[starts-with(value,'jdbc-')]/properties/property">

							// only should validate enabled fields
							if (f.<out:value-of select="value"/>.disabled == false) {
								//
								// general validation
								// 
								
								// check mandatory
								<out:if test="validationRules/mandatory = 'true'">
									if (!checkMandatory(f.<out:value-of select="value"/>, '<out:value-of select="normalize-space(name)"/>')) {
									  return false;
									}
								</out:if>

								if (!checkInvalidChar(f.m_connection_servername, '<out:value-of select="normalize-space(name)"/>', ':'))
								{
									return false;
								}
					
								
								// check reserved chars
								<out:if test="validationRules/reservedChar">
									if (!checkReservedChar(f.<out:value-of select="value"/>, '<out:value-of select="normalize-space(name)"/>')) {
										return false;
									}
								</out:if>							
								
								// maxLength
								<out:if test="validationRules/maxLength">
									if (f.<out:value-of select="value"/>.value.length &gt; <out:value-of select="validationRules/maxLength"/>) {
										alert('<xts:string id="IDS_VAL_ERR_MAXIMUM_LENGTH" encode="javascript"/>');
										f.<out:value-of select="value"/>.focus();
										return false;
									}
								</out:if>
								
								//
								// check type specific validation
								//
								
								<out:if test="validationRules/type = 'port'">
									if (!isPortRangeValid(f.<out:value-of select="value"/>) &amp;&amp; (<out:value-of select="validationRules/mandatory"/> || f.<out:value-of select="value"/>.value.length != 0)) {
										// invalid port range
										alert('<xts:string id="IDS_PROP_CONN_PORT_NUMBER_ERROR" encode="javascript"/>');
										CAFSelectText(f.<out:value-of select="value"/>,f.<out:value-of select="value"/>.value);
										return false;
									}
								</out:if>
								
								<out:if test="validationRules/type = 'positiveInteger'">
									if (isNaN(f.<out:value-of select="value"/>.value) || parseInt(f.<out:value-of select="value"/>.value, 10) != f.<out:value-of select="value"/>.value || f.<out:value-of select="value"/>.value &lt; 0) {
										alert('<xts:string id="IDS_VAL_ERR_UNSIGNED_INTEGER" encode="javascript"/>');
										f.<out:value-of select="value"/>.focus();
										return false;
									}
								</out:if>
								
								<out:if test="validationRules/type = 'nameValuePairList'">
									if (!isValidNameValuePairList(f.<out:value-of select="value"/>, '<out:value-of select="validationRules/separator"/>')) {
										<out:variable name="errMsg">
											<xts:string id="IDS_ERR_NAME_VALUE_LIST" encode="javascript">
												<xts:param name="field"><out:value-of select="validationRules/separator"/></xts:param>
											</xts:string>
										</out:variable>
										alert('<out:value-of select="normalize-space($errMsg)"/>');
										f.<out:value-of select="value"/>.focus();
										return false;	
									}
								</out:if>
								
							}
						</out:for-each>

					</out:when>				
					
				</out:choose>

				<out:if test="$connection-type != 'powercube' and $connection-type != 'xml' and $connection-type != 'consolidation' and $connection-type != 'contributor' and $connection-type != 'contributorSeries7'">
					if (f.m_connection_default_signon &amp;&amp; f.m_connection_default_signon.disabled == false &amp;&amp;
							f.m_connection_default_signon.checked == true)
					{
						<out:if test="not($test)">
						if (!checkMandatory(f.m_connection_userid, m7))
						{
							return false;
						}
						</out:if>

						if (f.m_connection_password.value != f.m_connection_confirm_password.value)
						{
							alert(m8);
							return false;
						}


						if (!checkReservedChar(f.m_connection_userid, '<xts:string id="IDS_USERID" encode="javascript"/>'))
						{
							return false;
						}

						if (!checkReservedChar(f.m_connection_password, '<xts:string id="IDS_PASSWORD" encode="javascript"/>'))
						{
							return false;
						}
					}
				</out:if>

				<!-- make sure the cube passwords are the same -->
				<out:if test="$connection-type = 'powercube'">
					if (f.cube_password_checkbox.checked &amp;&amp; f.m_cube_password &amp;&amp; f.m_cube_password.value != f.m_cube_confirm_password.value)
					{
						alert(m8);
						f.m_cube_password.focus();
						return false;
					}
				</out:if>

				<!-- make sure the user has a namesapce to select -->
				<out:if test="$connection-type = 'consolidation' and not(/root/namespaces/cm:queryResponse/cm:namespace)">
					alert('<xts:string id="IDS_PROP_CONN_FINANCE_NO_NAMESPACE_ERROR" encode="javascript"/>');
					return false;
				</out:if>
				return true;
		</out:template>

		<out:template name="gen-signon-section">
			<out:param name="form-read-only"/>
			<out:param name="utml-form-name"/>
			<out:param name="uid-pwd-checkboxes" select="'false'"/>
			<out:param name="connectionType"/>
			<out:param name="wizard" select="'false'"/>

			<out:if test="not($wizard = 'false' and $uid-pwd-checkboxes = 'false')">
				<lyt:layout title="IDS_SELECT_CONNECT_DEFAULT_SIGNON" style="1" border="yes" id="authentication_ID">
					<lyt:intro>
						<out:choose>
							<out:when test="contains(' sql sql2005 sql2008 sql2012-2014 dbtwoolap tm1 tm1R odata ',  concat(' ',$connectionType,' '))">	
								<xts:string id="IDS_SELECT_CONNECT_USER_PROMPTS_NONE_WIN_EXTERNAL_SIGNON_HINT"/>
							</out:when>
							<out:when test="$connectionType='sap'">
								<xts:string id="IDS_SELECT_CONNECT_USER_PROMPTS_SAP_HINT"/>
							</out:when>
							<out:when test="$connectionType='sr3'">
								<xts:string id="IDS_SELECT_CONNECT_USER_PROMPTS_SAPR3_HINT"/>
							</out:when>
							<out:when test="$connectionType='oracle'">
								<xts:string id="IDS_SELECT_CONNECT_USER_PROMPTS_NONE_WITH_EXTERNAL_SIGNON_HINT_AND_USERID"/>
							</out:when>
							<out:when test="$connectionType='sfdc'">
								<xts:string id="IDS_SELECT_CONNECT_USER_PROMPTS_SFDC_HINT"/>
							</out:when>

							<out:when test="$connectionType='siebel'">
								<xts:string id="IDS_SELECT_CONNECT_USER_PROMPTS_SIEBEL_HINT"/>
							</out:when>

							<out:when test="$connectionType='sqlodbc' or $connectionType='composite' or $connectionType='virtualviewmanager' or $connectionType='teradata' or $connectionType='db2' or $connectionType='odbc'">
								<xts:string id="IDS_SELECT_CONNECT_USER_PROMPTS_NONE_EXTERNAL_SIGNON_HINT"/>
							</out:when>
							<out:when test="contains(' msanalysis2005 msanalysis2008 msanalysis2012 msanalysis2014 msanalysis2016 msanalysis2017 ',  concat(' ',$connectionType,' '))">
								<xts:string id="IDS_SELECT_CONNECT_USER_PROMPTS_WIN_SIGNON_HINT"/>
							</out:when>
							<out:when test="$connectionType='powercube'">
								<xts:string id ="IDS_SELECT_CONNECT_USER_PROMPTS_NONE_EXTERNAL_HINT"/>
							</out:when>
							<out:when test="$connectionType='consolidation'">
								<xts:string id ="IDS_SELECT_CONNECT_EXTERNAL_NAMESPACE_HINT"/>
							</out:when>
							
							<out:when test="$connectionType='json'">
								<xts:string id ="IDS_SELECT_CONNECT_CREATE_AUTHENTICATION_HINT"/>
							</out:when>
							
							<!-- 1 choice - The signons of this connection -->
							<out:when test="$wizard != 'false'">
								<out:choose>
									<out:when test="$uid-pwd-checkboxes != 'false'">
										<!-- For connection types with the ability to specified if user id/password are required -->
										<xts:string id="IDS_SELECT_CONNECT_USER_PROMPTS_HINT"/>
									</out:when>
									<out:otherwise>
										<!-- For connection types with only the Create a signon controls -->
										<xts:string id="IDS_SELECT_CONNECT_CREATE_SIGNON_HINT"/>
									</out:otherwise>
								</out:choose>
							</out:when>
							<out:otherwise>
								<!-- When viewing the properties of an existing connection -->
								<xts:string id="IDS_SELECT_CONNECT_USER_PROMPTS_ONLY_HINT"/>
							</out:otherwise>
						</out:choose>
					</lyt:intro>
					<lyt:section>
						<out:choose>
							<out:when test="contains(' sql sql2005 sql2008 sql2012-2014 sqlodbc jdbc-sql composite virtualviewmanager consolidation msanalysis2005 msanalysis2008 msanalysis2012 msanalysis2016 msanalysis2017 msanalysis2014 sap sr3 sfdc siebel powercube dbtwoolap tm1R tm1 odata teradata jdbc-teradata db2 jdbc-db2 odbc netezza jdbc-netezza jdbc-generic oracle lob-jdbc ', concat(' ',$connectionType,' '))">
								<out:variable name="available_namespace">
									<out:choose>
										<out:when test="/root/namespaces/cm:queryResponse/cm:namespace/*">true</out:when>
										<out:otherwise>false</out:otherwise>
									</out:choose>
								</out:variable>
								<out:choose>
									<out:when test="$connectionType='consolidation' ">
										<dp:input>
											<dp:section1>
												<xts:string id="IDS_SELECT_CONNECT_FINANCE_EXTERNAL_NAMESPACE"/>
											</dp:section1>
											<dp:section2>
												<xsl:call-template name="dcx:externalNamespace"/>
											</dp:section2>
										</dp:input>
									</out:when>
									<out:otherwise>
										<utml:radio-group name="authentication">
											<utml:default-value>
												<out:choose>
													<out:when test="contains(' powercube odata ',concat(' ',$connectionType,' '))">none</out:when>
													<out:otherwise>signon</out:otherwise>
												</out:choose>
											</utml:default-value>
											<dp:choice aria-labelledby="authentication_ID">
												<!-- no authentication -->
												<out:if test="contains(' powercube sqlodbc composite virtualviewmanager sql sql2005 sql2008 sql2012-2014 jdbc-sql dbtwoolap tm1R tm1 odata teradata jdbc-teradata db2 jdbc-db2 odbc netezza jdbc-netezza jdbc-generic lob-jdbc ', concat(' ',$connectionType,' '))">
													<dp:section1>
                                                        <utml:input type="radio" name="authentication" value="none" onclick="onChangeAuthentication();" id="ctrl_authentication_none"/>
													</dp:section1>
													<dp:section2 for="ctrl_authentication_none">
													<out:choose>
														<out:when test="$connectionType='powercube'"><xts:string id="IDS_SELECT_CONNECT_POWERCUBE_NO_AUTHENTICATION"/></out:when>
														<out:otherwise>
															<out:choose>
																<out:when test="contains($connectionType, 'tm1')"><xts:string id="IDS_SELECT_CONNECT_INTEGRATED_SECURITY"/></out:when>
																<out:otherwise><xts:string id="IDS_SELECT_CONNECT_NO_AUTHENTICATION"/></out:otherwise>
															</out:choose>
														</out:otherwise>
													</out:choose>
													</dp:section2>
												</out:if>
												<!-- windows authentication -->
												<out:if test="contains(' msanalysis2005 msanalysis2008 msanalysis2012 msanalysis2016 msanalysis2017 msanalysis2014 sql sql2005 sql2008 sql2012-2014 jdbc-sql sqlodbc ', concat(' ',$connectionType,' '))">
													<dp:section1>
														<utml:input type="radio" name="authentication" value="windows" onclick="onChangeAuthentication();" id="ctrl_authentication_windows"/>
                                                    </dp:section1>
													<dp:section2 for="ctrl_authentication_windows">
														<xts:string id="IDS_SELECT_CONNECT_WINDOWS_AUTHENTICATION"/>
													</dp:section2>
												</out:if>
												<!-- external namespace -->
												<out:if test="contains(' sr3 sfdc siebel sap dbtwoolap tm1R tm1 msanalysis2005 msanalysis2008 msanalysis2012 msanalysis2016 msanalysis2017 msanalysis2014 powercube sqlodbc composite virtualviewmanager sql sql2005 sql2008 sql2012-2014 jdbc-sql dbtwoolap teradata jdbc-teradata db2 jdbc-db2 odbc netezza jdbc-netezza jdbc-generic oracle lob-jdbc ', concat(' ',$connectionType,' '))">
													<dp:section1>
														<utml:input type="radio" name="authentication" value="namespace" onclick="onChangeAuthentication();" id="ctrl_authentication_namespace">
                                                            <out:if test="$available_namespace='false'">
																<out:attribute name="disabled">true</out:attribute>
															</out:if>
														</utml:input>
													</dp:section1>
													<dp:section2 for="ctrl_authentication_namespace">
														<out:choose>
															<out:when test="$connectionType='powercube'">
																<xts:string id="IDS_SELECT_CONNECT_POWERCUBE_RESTRICTED"/>
															</out:when>
															<out:otherwise>
																<xts:string id="IDS_SELECT_CONNECT_SAP_EXTERNAL_NAMESPACE"/>
															</out:otherwise>
														</out:choose>
													</dp:section2>
													<dp:section3>
														<dp:section1>
															<xsl:call-template name="dcx:externalNamespace"/>
														</dp:section1>
													</dp:section3>
												</out:if>
												<!-- signon -->
												<out:if test="contains(' sr3 sfdc siebel sap msanalysis2005 msanalysis2008 msanalysis2012 msanalysis2016 msanalysis2017 msanalysis2014 sql sql2005 sql2008 sql2012-2014 jdbc-sql tm1R tm1 odata dbtwoolap sqlodbc composite virtualviewmanager dbtwoolap teradata jdbc-teradata db2 jdbc-db2 odbc netezza jdbc-netezza jdbc-generic lob-jdbc ', concat(' ',$connectionType,' '))">
													<dp:section1>
														<utml:input type="radio" name="authentication" value="signon" onclick="onChangeAuthentication();" id="ctrl_authentication_signon"/>
													</dp:section1>
													<dp:section2 for="ctrl_authentication_signon">
														<out:choose>
															<out:when test="$wizard='false'"><xts:string id="IDS_SELECT_CONNECT_SIGNON_PROPERTY_DIALOG"/></out:when>
															<out:otherwise><xts:string id="IDS_SELECT_CONNECT_SIGNONS"/></out:otherwise>
														</out:choose>
													</dp:section2>
													<dp:section3>
														<out:if test="$connectionType!='sap'">
															<dp:group>
																<dp:groupItem>
																	<dp:choice noSpace="true">
																		<dp:section1>
																			<utml:input type="checkbox" name="m_connection_use_pword" onclick="togglePasswordCheckbox()" id="ctrl_m_connection_use_pword"/>
																		</dp:section1>
																		<dp:section2 for="ctrl_m_connection_use_pword">
																			<xts:string id="IDS_SELECT_CONNECT_PASSWORD_PROMPT"/>
																		</dp:section2>
																	</dp:choice>
																</dp:groupItem>
															</dp:group>
														</out:if>
														<out:if test="$wizard = 'true'">
															<out:call-template name="gen-create-signon">
																<out:with-param name="form-read-only" select="$form-read-only"/>
																<out:with-param name="utml-form-name" select="$utml-form-name"/>
															</out:call-template>
														</out:if>
													</dp:section3>
												</out:if>
												<out:if test="contains(' oracle ', concat(' ',$connectionType,' '))">
													<dp:section1>
														<utml:input type="radio" name="authentication" value="signon" onclick="onChangeAuthentication();" id="ctrl_authentication_signon"/>
													</dp:section1>
													<dp:section2 for="ctrl_authentication_signon">
														<out:choose>
															<out:when test="$wizard='false'"><xts:string id="IDS_SELECT_CONNECT_SIGNON_PROPERTY_DIALOG"/></out:when>
																<out:otherwise><xts:string id="IDS_SELECT_CONNECT_SIGNONS"/></out:otherwise>
													 		</out:choose>
													</dp:section2>
													<dp:section3>
														<dp:group>
															<dp:groupItem>
																<dp:choice noSpace="true">
																	<dp:section1>
																		<utml:input type="checkbox" name="m_connection_use_userid" onclick="updateSignonSection(this.checked);" id="ctrl_m_connection_use_userid"/>
																	</dp:section1>
																	<dp:section2 for="ctrl_m_connection_use_userid">
																		<xts:string id="IDS_SELECT_CONNECT_USERID_PROMPT"/>
																	</dp:section2>
																</dp:choice>
															</dp:groupItem>
														</dp:group>	
														<dp:group>
															<dp:groupItem>
																<dp:choice noSpace="true">
																	<dp:section1>
																		<utml:input type="checkbox" name="m_connection_use_pword" onclick="togglePasswordCheckbox()" id="ctrl_m_connection_use_pword"/>
																	</dp:section1>
																	<dp:section2 for="ctrl_m_connection_use_pword">
																		<xts:string id="IDS_SELECT_CONNECT_PASSWORD_PROMPT"/>
																	</dp:section2>
																</dp:choice>
															</dp:groupItem>
														</dp:group>
														<out:if test="$wizard = 'true'">
															<out:call-template name="gen-create-signon">
																<out:with-param name="form-read-only" select="$form-read-only"/>
																<out:with-param name="utml-form-name" select="$utml-form-name"/>
															</out:call-template>
														</out:if>
													</dp:section3>
												</out:if>
											</dp:choice>
										</utml:radio-group>
									</out:otherwise>
								</out:choose>
							</out:when>
							
							<out:when test="$connectionType='json' ">
								<out:variable name="dcx-authentication-type">
									<out:choose>
										<out:when test="key('env-param','m_connection_authentication_type') != ''">
											<out:value-of select="string(key('env-param','m_connection_authentication_type'))"/>
										</out:when>
										<out:when test="key('env-param','m_p_connectionString') != ''">	
											<out:value-of select="substring-before(substring-after(string(key('env-param','m_p_connectionString')), ';AUTHENTICATION_TYPE='), ';')"/>
										</out:when>
										<out:otherwise>
											<out:value-of select="'None'"/>
										</out:otherwise>
									</out:choose>
								</out:variable>
								<dp:input>
									<dp:section1 for="ctrl_m_connection_authentication_type">
										<xts:string id="IDS_SELECT_CONNECT_AUTHENTICATION_TYPE"/>
									</dp:section1>
									<dp:section2>
										<utml:select id="ctrl_m_connection_authentication_type" name="m_connection_authentication_type" size="1" utml:update="true" onchange="changeAuthenticationType();">
											<!-- 
                                                                                        <utml:option value="None">
												<xts:string id="IDS_SELECT_CONNECT_NONE"/>
											</utml:option>
											<utml:option value="APIKey">
												<xts:string id="IDS_SELECT_CONNECT_API_KEY"/>
											</utml:option>
											<utml:option value="Basic">
												<xts:string id="IDS_SELECT_CONNECT_BASIC"/>
											</utml:option>
											<utml:option value="OAuth1.0">
												<xts:string id="IDS_SELECT_CONNECT_OAUTH1"/>
											</utml:option>
											<utml:option value="OAuth2.0">
												<xts:string id="IDS_SELECT_CONNECT_OAUTH2"/>
                                                                                        </utml:option>
											-->
											</utml:select>
											<utml:input id="input_m_connection_auth_type_keep_state" name="m_connection_auth_type_keep_state" type="hidden"/>
											<utml:input id="input_m_trace_subtype_change" name="m_trace_subtype_change" type="hidden"/>
									</dp:section2>
								</dp:input>
								<script language="javascript">
									function changeAuthenticationType()
                                                                        {
                                                                                document.pform.m_connection_auth_type_keep_state.value = document.pform.m_connection_authentication_type.value;
                                                                                document.pform.m_trace_subtype_change.value = "false";
										document.pform.submit();
									}
	
									function clearEncryptedPassword()
									{
										if (document.pform.passwordEncrypted)
											document.pform.passwordEncrypted.value = '';
									}
								
									function authenticate()
									{
										var f = document.pform;
										var authString = f.action;
										if (f.m_connection_authentication_type.value == 'OAuth1.0') {
											authString += '/oauth1?';												
											authString += 'temporary_token_endpoint=' + f.m_connection_temporary_token_endpoint.value;
											authString += '&amp;authorization_endpoint=' + f.m_connection_authorization_endpoint.value;
											authString += '&amp;token_endpoint=' + f.m_connection_token_endpoint.value;
											authString += '&amp;reponse_type=code';
											authString += '&amp;state=' + f.m_name.value;
											window.open(authString);
										}
										if (f.m_connection_authentication_type.value == 'OAuth2.0') {
											authString += '/oauth2?';
											authString += 'authorization_endpoint=' + f.m_connection_authorization_endpoint.value;
											authString += '&amp;token_endpoint=' + f.m_connection_token_endpoint.value;
											if (f.m_connection_scope.value)
											{
												authString += '&amp;scope=' + f.m_connection_scope.value;
											}
											authString += '&amp;state=' + f.m_name.value;
											window.open(authString);
										}
									}
								</script>
								<out:choose>
									<out:when test="$dcx-authentication-type='OAuth1.0'">
										<dp:input>
											<dp:section1 for="ctrl_m_connection_temporary_token_endpoint">
												<xts:string id="IDS_SELECT_CONNECT_TEMPORARY_TOKEN_ENDPOINT"/>
											</dp:section1>
											<dp:section2>
												<utml:input type="text" name="m_connection_temporary_token_endpoint" size="53" id="ctrl_m_connection_temporary_token_endpoint"/>
											</dp:section2>
										</dp:input>
										<dp:input>
											<dp:section1 for="ctrl_m_connection_authorization_endpoint">
												<xts:string id="IDS_SELECT_CONNECT_AUTHORIZATION_ENDPOINT"/>
											</dp:section1>
											<dp:section2>
												<utml:input type="text" name="m_connection_authorization_endpoint" size="53" id="ctrl_m_connection_authorization_endpoint"/>
											</dp:section2>
										</dp:input>
										<dp:input>
											<dp:section1 for="ctrl_m_connection_token_endpoint">
												<xts:string id="IDS_SELECT_CONNECT_TOKEN_ENDPOINT"/>
											</dp:section1>
											<dp:section2>
												<utml:input type="text" name="m_connection_token_endpoint" size="53" id="ctrl_m_connection_token_endpoint"/>
											</dp:section2>
										</dp:input>
									</out:when>
									<out:when test="$dcx-authentication-type='OAuth2.0'">
										<dp:input>
											<dp:section1 for="ctrl_m_connection_authorization_endpoint">
												<xts:string id="IDS_SELECT_CONNECT_AUTHORIZATION_ENDPOINT"/>
											</dp:section1>
											<dp:section2>
												<utml:input type="text" name="m_connection_authorization_endpoint" size="53" id="ctrl_m_connection_authorization_endpoint"/>
											</dp:section2>
										</dp:input>
										<dp:input>
											<dp:section1 for="ctrl_m_connection_token_endpoint">
												<xts:string id="IDS_SELECT_CONNECT_TOKEN_ENDPOINT"/>
											</dp:section1>
											<dp:section2>
												<utml:input type="text" name="m_connection_token_endpoint" size="53" id="ctrl_m_connection_token_endpoint"/>
											</dp:section2>
										</dp:input>
										<dp:input>
											<dp:section1 for="ctrl_m_connection_scope">
												<xts:string id="IDS_SELECT_CONNECT_SCOPE"/>
											</dp:section1>
											<dp:section2>
												<utml:input type="text" name="m_connection_scope" size="120" id="ctrl_m_connection_scope"/>
											</dp:section2>
										</dp:input>
									</out:when>
								</out:choose>
								<out:if test="$dcx-authentication-type != 'None'">
									<out:call-template name="gen-create-signon">
										<out:with-param name="form-read-only" select="$form-read-only"/>
										<out:with-param name="utml-form-name" select="$utml-form-name"/>
										<out:with-param name="connectionType" select="$connectionType"/>
										<out:with-param name="authenticationType" select="$dcx-authentication-type"/>
									</out:call-template>
								</out:if>
							</out:when>
							<!--
								1 choice
								- The signons of this connection
							-->
							<out:otherwise>
								<out:choose>
									<out:when test="$uid-pwd-checkboxes != 'false'">
										<dp:choice>
											<dp:section1>
												<utml:input type="checkbox" name="m_connection_use_userid" onclick="updateSignonSection(this.checked);" id="ctrl_m_connection_use_userid"/>
											</dp:section1>
											<dp:section2 for="ctrl_m_connection_use_userid">
												<xts:string id="IDS_SELECT_CONNECT_USERID_PROMPT"/>
											</dp:section2>
											<dp:section3>
												<dp:group>
													<dp:groupItem>
														<dp:choice noSpace="true">
															<dp:section1>
																<utml:input type="checkbox" name="m_connection_use_pword" onclick="togglePasswordCheckbox()" id="ctrl_m_connection_use_pword">
																	<out:if test="not(key('env-param','m_connection_use_userid'))">
																		<out:attribute name="disabled">disabled</out:attribute>
																	</out:if>
																</utml:input>
															</dp:section1>
															<dp:section2 for="ctrl_m_connection_use_pword">
																<xts:string id="IDS_SELECT_CONNECT_PASSWORD_PROMPT"/>
															</dp:section2>
														</dp:choice>
													</dp:groupItem>
												</dp:group>
												<out:if test="$wizard != 'false'">
													<dp:group>
														<dp:groupItem>
															<out:call-template name="gen-create-signon">
																<out:with-param name="form-read-only" select="$form-read-only"/>
																<out:with-param name="utml-form-name" select="$utml-form-name"/>
															</out:call-template>
														</dp:groupItem>
													</dp:group>
												</out:if>
											</dp:section3>
										</dp:choice>
									</out:when>
									<out:otherwise>
										<out:call-template name="gen-create-signon">
											<out:with-param name="form-read-only" select="$form-read-only"/>
											<out:with-param name="utml-form-name" select="$utml-form-name"/>
										</out:call-template>
									</out:otherwise>
								</out:choose>
							</out:otherwise>
						</out:choose>
					</lyt:section>
				</lyt:layout>
			</out:if>
		</out:template>

		<!-- This template is special for contributor -->
		<out:template name="gen-contributor-section">
			<out:param name="form-read-only"/>
			<out:param name="utml-form-name"/>
			<out:param name="uid-pwd-checkboxes" select="'false'"/>
			<out:param name="connectionType"/>
			<out:param name="wizard" select="'false'"/>

			<out:if test="not($wizard = 'false' and $uid-pwd-checkboxes = 'false')">
				<lyt:layout title="" style="1" border="no">
					<lyt:section>
						<out:variable name="available_namespace">
							<out:choose>
								<out:when test="/root/namespaces/cm:queryResponse/cm:namespace/*">true</out:when>
								<out:otherwise>false</out:otherwise>
							</out:choose>
						</out:variable>
							<dp:input>
								<dp:section1>
									<xts:string id="IDS_SELECT_CONNECT_FINANCE_EXTERNAL_NAMESPACE"/>
								</dp:section1>
								<dp:section2>
									<xsl:call-template name="dcx:externalNamespace"/>
								</dp:section2>
							</dp:input>
					</lyt:section>
				</lyt:layout>
			</out:if>
		</out:template>
	</xsl:template>


	<!--
		Template that generates the namespace dropdown list
	-->
	<xsl:template name="dcx:externalNamespace">

 		<out:variable name="showTransformUserIdentification">
			<out:value-of select="datasources/datasource/supportsUserIdentificationTransform"/>
		</out:variable>

       	<utml:select name="m_p_credentialNamespaces" utml:track="true" >
            <out:attribute name="aria-label">
                <xts:string id="IDS_SELECT_CONNECT_EXTERNAL_NAMESPACE"/>
            </out:attribute>
			<out:choose>
				<out:when test="$available_namespace='false'">
					<utml:option>
						<xsl:text/>&#160;&#160;&#160;&#160;&#160;&#160;&#160;<xsl:text/>
					</utml:option>
				</out:when>
				<out:otherwise>
					<out:for-each select="/root/namespaces/cm:queryResponse/cm:namespace">
						<out:variable name="aNamespace">
							<out:choose>
								<out:when test="cm:active='false'">
									<out:text/>
										<xts:string id="IDS_DIRECTORY_NAMESPACE_INACTIVE">
											<xts:param name="namespaceDefaultName"><out:value-of select="cm:defaultName"/></xts:param>
										</xts:string>
									<out:text/>
								</out:when>
								<out:otherwise>
										<out:text/>
											<xts:string id="IDS_DIRECTORY_NAMESPACE_ACTIVE">
												<xts:param name="namespaceDefaultName"><out:value-of select="cm:defaultName"/></xts:param>
											</xts:string>
										<out:text/>
								</out:otherwise>
							</out:choose>
						</out:variable>
						<utml:option>
							<utml:value>
								<out:value-of select="cm:searchPath"/>
							</utml:value>
							<out:value-of select="$aNamespace"/>
						</utml:option>
					</out:for-each>
				</out:otherwise>
			</out:choose>
		</utml:select>

		<out:if test="$showTransformUserIdentification = 'true'">
			<dp:choice>
				<dp:section1>
					<utml:input type="checkbox" name="m_transformUserIdentification" id="ctrl_m_transformUserIdentification"/>
				</dp:section1>
				<dp:section2 for="ctrl_m_transformUserIdentification">
					<xts:string id="IDS_SELECT_CONNECT_TRANSFORM_USER_IDENTIFIER"/>
				</dp:section2>
			</dp:choice>
		</out:if>
 	</xsl:template>

	<xsl:template match="dcx:commandTemplate">
		<out:template name="dcx-commandTemplate">
			<out:param name="form-read-only"/>
			<out:param name="utml-form-name" select="'pform'"/>
			<out:param name="canWrite" select="false()"/>
			<out:param name="dataSourceConnection" select="false()"/>
			<out:param name="inWizard" select="true()"/>

			<script language="javascript">
				function setCommand(command)
				{
					var frm = document.<out:value-of select="$utml-form-name"/>;
					frm.commandToEdit.value = command;
					frm.ps_nav_op.value = 'push';
					frm.m.value = '<out:value-of select="$app"/>/set_commands.xts';
					frm.submit();
				}

				function performAction(action)
				{
					var frm = document.<out:value-of select="$utml-form-name"/>;
					frm.actionOnCommands.value = action;
					frm.ps_nav_op.value = 'maintain';
					frm.m.value = '<out:value-of select="$app"/>/<out:value-of select="$mname"/>';
					frm.submit();
				}
			</script>

			<utml:input type="hidden" name="commandToEdit" value="" utml:update="false"/>
			<utml:input type="hidden" name="displayStringBeingEdited" value="" utml:uptdate="false"/>
			<utml:input type="hidden" name="actionOnCommands" value="" utml:update="false"/>


            <span id="lbl_selectAll_deselectAlllistpager_connections" style="position: absolute;margin-left: -9999px; margin-top: -9999px; "><xts:string id="IDS_SELECT_DESELECT_ALL" encode="html"/></span>
			<lyt:layout style="1">
				<lyt:section>
					<out:choose>
						<out:when test="not($inWizard) and $dataSourceConnection">
							<dp:choice>
								<dp:section1 wrap="true" type="hint"><xts:string id="IDS_NEW_INTRO_CONNECTION_COMMANDS"/></dp:section1>
							</dp:choice>
						</out:when>
						<out:when test="not($inWizard)">
							<dp:choice title="IDS_PROP_CONN_COMMAND_TITLE">
								<dp:section1 wrap="true" type="hint">
									<xts:string id="IDS_NEW_INTRO_DATASOURCE_COMMANDS"/>
								</dp:section1>
							</dp:choice>
						</out:when>
					</out:choose>
					<cf:main-pager-section name="listpager" form="pform" width="80%">
						<cf:param name="target">concat($app,'/',$mname)</cf:param>
						<cf:param name="item-path">/root/commandBlocks/command</cf:param>
						<cf:param name="lines-per-page">
							<out:value-of select="key('session-param', 'linesPerPage')"/>
						</cf:param>
						<cf:param name="actions">
							<!-- reset to parent value -->
							<cp:action>
								<out:if test="$canWrite and $dataSourceConnection">
									<a href="javascript:performAction('reset');">
										<xsl:text/><xts:string id="IDS_PROP_SETTINGS_RESET_TO_PARENT"/><xsl:text/>
									</a>
								</out:if>
							</cp:action>
							<!-- clear -->
							<cp:action>
								<out:if test="$canWrite and not($dataSourceConnection)">
									<a href="javascript:performAction('clear');">
										<xsl:text/><xts:string id="IDS_CLEAR"/><xsl:text/>
									</a>
								</out:if>
							</cp:action>
						</cf:param>
						<cf:param name="rows">
							<cp:tableHeader>
								<out:choose>
									<out:when test="$dataSourceConnection or (not($dataSourceConnection) and not($inWizard))">
										<cp:columnHeader width="16" toggleName="list_checkbox_" toggleLabel="lbl_selectAll_deselectAlllistpager_connection">
											<cp:columnHeaderForm><out:value-of select="$utml-form-name"/></cp:columnHeaderForm>
										</cp:columnHeader>
										<cp:columnHeader width="30%">
											<xts:string id="IDS_HEADING_REPORT_NAME"/>
										</cp:columnHeader>
										<cp:columnHeader width="50%">
											<xts:string id="IDS_PROP_SETTINGS_HEADING_VALUE"/>
										</cp:columnHeader>
										<cp:columnHeader width="20%">
											<out:choose>
												<out:when test="$dataSourceConnection">
													<xts:string id="IDS_PROP_SETTINGS_HEADING_ACQUIRED"/>
												</out:when>
												<out:otherwise>
													<xts:string id="IDS_PROP_DATASOURCE_DEL_CHILD"/>
												</out:otherwise>
											</out:choose>
										</cp:columnHeader>
									</out:when>
									<out:otherwise>
										<cp:columnHeader width="16" toggleName="list_checkbox_" toggleLabel="lbl_selectAll_deselectAlllistpager_connection">
											<cp:columnHeaderForm><out:value-of select="$utml-form-name"/></cp:columnHeaderForm>
										</cp:columnHeader>
										<cp:columnHeader width="30%">
											<xts:string id="IDS_HEADING_REPORT_NAME"/>
										</cp:columnHeader>
										<cp:columnHeader width="100%">
											<xts:string id="IDS_PROP_SETTINGS_HEADING_VALUE"/>
										</cp:columnHeader>
									</out:otherwise>
								</out:choose>
							</cp:tableHeader>
							<cp:tableContent>
								<out:variable name="currentCommand" select="propertyName"/>

								<utml:input type="hidden">
									<utml:name>
										<out:value-of select="concat('m_display_cbp_',$currentCommand)"/>
									</utml:name>
									<utml:value>
										<out:value-of select="displayString"/>
									</utml:value>
								</utml:input>

								<!-- Fix for bug 437219 - we can't use a utml control here since it'll add extra line spaces in the hidden input.
										Related to bug fix for 400901 in formlogic. -->
								<out:variable name="controlName" select="concat('m_cbp_',$currentCommand)"/>
								<input type="hidden" name="{'{$controlName}'}" value="{'{value}'}"/>

								<!-- keep track if the value has changed -->
								<utml:input type="hidden">
									<utml:name>
										<out:value-of select="concat('changed_m_cbp_',$currentCommand)"/>
									</utml:name>
									<utml:value>
										<out:choose>
											<out:when test="changed='1'">1</out:when>
											<out:otherwise>0</out:otherwise>
										</out:choose>
									</utml:value>
								</utml:input>

								<out:choose>
									<out:when test="$dataSourceConnection or (not($dataSourceConnection) and not($inWizard))">
										<cp:columnContent>
											<input type="checkbox">
												<out:attribute name="name">
													<out:value-of select="concat('list_checkbox_',position())"/>
												</out:attribute>
												<out:attribute name="value">
													<out:value-of select="propertyName"/>
												</out:attribute>
                                                <out:attribute name="aria-label">
                                                    <xts:string id="IDS_SELECTION_FOR_PAGER_ITEM"><xts:param name="pagerItemName"><out:value-of select="displayString"/></xts:param></xts:string>
                                                </out:attribute>
											</input>
										</cp:columnContent>
										<cp:columnContent scope="row">
											<out:value-of select="displayString"/>
										</cp:columnContent>
										<cp:columnContent valign="top">
											<dp:section1>
												<dp:list>
													<dp:section>
														<out:choose>
															<out:when test="value != ''">
													  			<out:choose>
													  				<out:when test="string-length(value) > 45">
													  					<out:variable name="ellipsis"><xts:string id="IDS_LIST_ELLIPSIS"/></out:variable>
													  					<out:value-of select="concat(substring(value,1,42),$ellipsis)"/>
													  				</out:when>
													  				<out:otherwise><out:value-of select="value"/></out:otherwise>
													  			</out:choose>

																<dp:text><out:value-of select="'   '"/></dp:text>
																<out:if test="$canWrite">
																	<a>
																		<out:attribute name="href">javascript:setCommand('<out:value-of select="xtsext:javascriptencode(string($currentCommand))"/>');</out:attribute>
                                                                        <out:attribute name="aria-label"><xts:string id="IDS_PROP_CONN_EDIT_COMMAND_ARIA"><xts:param name="commandName"><out:value-of select="displayString"/></xts:param></xts:string></out:attribute>
																		<out:text/><xts:string id="IDS_PROP_CONN_EDIT_COMMAND"/><out:text/>
																	</a>
																</out:if>
															</out:when>
															<out:otherwise>
																<xts:string id="IDS_PROP_CONN_COMMAND_NONE"/>
																<dp:text><out:value-of select="'   '"/></dp:text>
																<out:if test="$canWrite">
																	<a>
																		<out:attribute name="href">javascript:setCommand('<out:value-of select="xtsext:javascriptencode(string($currentCommand))"/>');</out:attribute>
                                                                        <out:attribute name="aria-label"><xts:string id="IDS_PROP_CONN_SET_COMMAND_ARIA"><xts:param name="commandName"><out:value-of select="displayString"/></xts:param></xts:string></out:attribute>
																		<out:text/><xts:string id="IDS_PROP_CONN_SET_COMMAND"/><out:text/>
																	</a>
																</out:if>
															</out:otherwise>
														</out:choose>
													</dp:section>
												</dp:list>
											</dp:section1>
										</cp:columnContent>
										<cp:columnContent>
											<out:choose>
												<out:when test="$dataSourceConnection">
													<out:choose>
														<out:when test="acquired = 'true'">
															<xts:string id="IDS_PROP_SETTINGS_ACQUIRED_YES"/>
														</out:when>
														<out:otherwise>
															<xts:string id="IDS_PROP_SETTINGS_ACQUIRED_NO"/>
														</out:otherwise>
													</out:choose>

													<!-- keep track if the value is acquired -->
													<utml:input type="hidden">
														<utml:name>
															<out:value-of select="concat('m_acquired_',$currentCommand)"/>
														</utml:name>
														<utml:value>
															<out:value-of select="acquired"/>
														</utml:value>
													</utml:input>
												</out:when>
												<out:otherwise>
													<utml:input type="checkbox">
                                                        <out:attribute name="aria-label"><xts:string id="IDS_PROP_DATASOURCE_DEL_CHILD_ARIA"><xts:param name="commandName"><out:value-of select="displayString"/></xts:param></xts:string></out:attribute>
														<utml:name>
															<out:value-of select="concat('m_cbd_',$currentCommand)"/>
														</utml:name>
														<utml:value>
															<out:value-of select="'true'"/>
														</utml:value>
													</utml:input>
												</out:otherwise>
											</out:choose>
										</cp:columnContent>
									</out:when>
									<out:otherwise>
										<cp:columnContent>
											<input type="checkbox">
												<out:attribute name="name">
													<out:value-of select="concat('list_checkbox_',position())"/>
												</out:attribute>
												<out:attribute name="value">
													<out:value-of select="propertyName"/>
												</out:attribute>
                                                <out:attribute name="aria-label">
                                                    <xts:string id="IDS_SELECTION_FOR_PAGER_ITEM"><xts:param name="pagerItemName"><out:value-of select="displayString"/></xts:param></xts:string>
                                                </out:attribute>
											</input>
										</cp:columnContent>
										<cp:columnContent scope="row">
											<out:value-of select="displayString"/>
										</cp:columnContent>
										<cp:columnContent valign="top">
											<dp:section1>
												<dp:list>
													<dp:section>
														<out:choose>
															<out:when test="value != ''">
													  			<out:choose>
													  				<out:when test="string-length(value) > 45">
													  					<out:variable name="ellipsis"><xts:string id="IDS_LIST_ELLIPSIS"/></out:variable>
													  					<out:value-of select="concat(substring(value,1,42),$ellipsis)"/>
													  				</out:when>
													  				<out:otherwise><out:value-of select="value"/></out:otherwise>
													  			</out:choose>

																<dp:text><out:value-of select="'   '"/></dp:text>
																<a>
																	<out:attribute name="href">javascript:setCommand('<out:value-of select="xtsext:javascriptencode(string($currentCommand))"/>','<out:value-of select="xtsext:javascriptencode(string(displayString))"/>');</out:attribute>
                                                                    <out:attribute name="aria-label"><xts:string id="IDS_PROP_CONN_EDIT_COMMAND_ARIA"><xts:param name="commandName"><out:value-of select="displayString"/></xts:param></xts:string></out:attribute>
																	<out:text/><xts:string id="IDS_PROP_CONN_EDIT_COMMAND"/><out:text/>
																</a>
															</out:when>
															<out:otherwise>
																<xts:string id="IDS_PROP_CONN_COMMAND_NONE"/>
																<dp:text><out:value-of select="'   '"/></dp:text>
																<a>
																	<out:attribute name="href">javascript:setCommand('<out:value-of select="xtsext:javascriptencode(string($currentCommand))"/>','<out:value-of select="xtsext:javascriptencode(string(displayString))"/>');</out:attribute>
                                                                    <out:attribute name="aria-label"><xts:string id="IDS_PROP_CONN_SET_COMMAND_ARIA"><xts:param name="commandName"><out:value-of select="displayString"/></xts:param></xts:string></out:attribute>
																	<out:text/><xts:string id="IDS_PROP_CONN_SET_COMMAND"/><out:text/>
																</a>
															</out:otherwise>
														</out:choose>
													</dp:section>
												</dp:list>
											</dp:section1>
										</cp:columnContent>
									</out:otherwise>
								</out:choose>
							</cp:tableContent>
						</cf:param>
					</cf:main-pager-section>
				</lyt:section>
			</lyt:layout>
		</out:template>
	</xsl:template>

	<xsl:template match="dcx:cubePassword">
		<script language="javascript">
			function toggleCubePassword()
			{
				frm = document.pform;

				<xsl:if test="not(@specifyConnection) or @specifyConnection='false'">
					frm.m_connection_default_signon.disabled = !frm.cube_password_checkbox.checked;
					toggleCreateCubeSignon();
				</xsl:if>
			}

			<xsl:if test="not(@specifyConnection) or @specifyConnection='false'">
				function clearCubePassword()
				{
					if (document.pform.cubePasswordEncrypted)
						document.pform.cubePasswordEncrypted.value = '';
				}

				function toggleCreateCubeSignon()
				{
					frm = document.pform;
					if (frm.cube_password_checkbox.checked)
					{
						frm.m_cube_password.disabled = !frm.m_connection_default_signon.checked;
						frm.m_cube_confirm_password.disabled = !frm.m_connection_default_signon.checked;
					}
					else
					{
						frm.m_cube_password.disabled = true;
						frm.m_cube_confirm_password.disabled = true;
					}
				}
			</xsl:if>
		</script>
		<lyt:layout style="1" intro="IDS_PROP_CONN_CUBE_PASSWORD_HINT">
			<lyt:section>
				<out:variable name="default_signon_checked">
					<out:choose>
						<out:when test="/root/env/param[@name='m_connection_default_signon'] and /root/env/param[@name='m_connection_default_signon']='true'">true</out:when>
						<out:otherwise>false</out:otherwise>
					</out:choose>
				</out:variable>

				<dp:choice>
					<dp:section1>
						<utml:input type="checkbox" name="cube_password_checkbox" value="true" onclick="toggleCubePassword()" id="ctrl_cube_password_checkbox"/>
                    </dp:section1>
					<dp:section2 for="ctrl_cube_password_checkbox">
						<xts:string id="IDS_PROP_CONN_CUBE_PASSWORD"/>
					</dp:section2>
					<xsl:if test="not(@specifyConnection) or @specifyConnection='false'">
						<dp:section3>
							<dp:choice>
								<dp:section1>
									<utml:input type="checkbox" name="m_connection_default_signon" onclick="toggleCreateCubeSignon();" utml:track="true" id="ctrl_m_connection_default_signon">
										<out:attribute name="disabled">disabled</out:attribute>
										<out:if test="$default_signon_checked='true'">
											<out:attribute name="checked">checked</out:attribute>
										</out:if>
									</utml:input>
								</dp:section1>
								<dp:section2 for="ctrl_m_connection_default_signon">
									<out:text><xts:string id="IDS_SELECT_CONNECT_DEFAULT_SIGNON_HINT"/></out:text>
								</dp:section2>
								<dp:section3>
									<dp:input>
										<dp:section1 for="ctrl_m_cube_password">
											<xts:string id="IDS_SELECT_CONNECT_PASSWORD"/>
										</dp:section1>
										<dp:section2>
											<utml:input type="password" name="m_cube_password" size="53" utml:update="false" onchange="clearCubePassword()" autocomplete="off" id="ctrl_m_cube_password">
												<out:if test="not(key('env-param','cube_password_checkbox'))">
													<out:attribute name="disabled">disabled</out:attribute>
												</out:if>
												<out:attribute name="value">
													<out:if test="key('env-param','cubePasswordEncrypted')!=''">********</out:if>
												</out:attribute>
											</utml:input>
										</dp:section2>
									</dp:input>
									<dp:input>
										<dp:section1 for="ctrl_m_cube_confirm_password">
											<xts:string id="IDS_SELECT_CONNECT_CONFIRMPASSWORD"/>
										</dp:section1>
										<dp:section2>
											<utml:input type="password" name="m_cube_confirm_password" size="53" utml:update="false" onchange="clearCubePassword()" autocomplete="off" id="ctrl_m_cube_confirm_password">
												<out:if test="not(key('env-param','cube_password_checkbox'))">
													<out:attribute name="disabled">disabled</out:attribute>
												</out:if>
												<out:attribute name="value">
													<out:if test="key('env-param','cubePasswordEncrypted')!=''">********</out:if>
												</out:attribute>
											</utml:input>
										</dp:section2>
									</dp:input>
								</dp:section3>
							</dp:choice>
						</dp:section3>
					</xsl:if>
				</dp:choice>
			</lyt:section>
		</lyt:layout>
	</xsl:template>

 	<xsl:template match="dcx:isDatasourceSignon">
		<out:template name="dcx-isDatasourceSignon">
			<out:param name="connectionString"/>
				<out:choose>
					<out:when test="key('env-param','m_p_credentialNamespaces') != ''">
						<out:value-of select="'false'"/>
					</out:when>
					<out:when test="contains($connectionString,'Trusted_Connection=yes') or contains($connectionString,'Integrated Security=SSPI')">
						<out:value-of select="'false'"/>
					</out:when>
					<out:when test="contains($connectionString, '^User ID:')">
						<out:value-of select="'true'"/>
					</out:when>
					<out:otherwise>
						<out:value-of select="'false'"/>
					</out:otherwise>
				</out:choose>	
			</out:template>		
	</xsl:template>

	<!-- the main engine -->
	<xsl:template match="*">
		<xsl:copy>
			<xsl:copy-of select="@*"/>
			<xsl:apply-templates/>
		</xsl:copy>
	</xsl:template>
</xsl:stylesheet>