analytics/templates/ps/portal/new_connection3.xts

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

    IBM Cognos Products: ps

    (C) Copyright IBM Corp. 2005, 2017

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

<!--
   Copyright (C) 2008 Cognos ULC, an IBM Company. All rights reserved.
   Cognos (R) is a trademark of Cognos ULC, (formerly Cognos Incorporated).
-->

<!--
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.
-->

<xts:morphlet xmlns:xts="http://developer.cognos.com/schemas/xts/" xmlns:cml="http://developer.cognos.com/schemas/xts/logic-sheet/xslt/cml/1/" xmlns:cm="http://developer.cognos.com/schemas/xts-cm/1/" messageBase="messages/portal.xml, messages/portalRL.xml" includeConfig="true" requiredCapability="canUseDataSourcesTool">
	<!--
	===============================================================================================
	formlogic_init - standard form logic initialization
	===============================================================================================
	-->
	<xts:block id="formlogic_init" type="exec" mode="interpret" processor="XSLT" path="/logicsheets/formlogic_init.xslt" nodelist="env,credential,system,http"/>

	<!--
	================================================================================
	encrypt the password
	================================================================================
	-->
	<xts:block id="encrypt_password" path="/portal/encryptConnectionPasswords.xslt" dependency="formlogic_init" type="exec" mode="interpret" processor="XSLT" mandatory="false" condition=".[/root/env/param[@name='m_cube_password' or @name='test_cube_password' or @name='m_connection_password' or @name='m_connection_proxy_password' or @name='proxyPasswordEncrypted' or @name='test_password'] != '']"/>

	<!--
	===============================================================================================
	load_metadata
	===============================================================================================
	-->
	<xts:block id="load_metadata" processor="XSLT" type="exec" mode="interpret" nodelist="" dependency="formlogic_init">
		<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
			<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="no"/>
			<xsl:template match="/">
				<xts:sequence>
					<xts:append>
						<xts:transform src="transforms/portal/dataSource/extractDatasourceMetadata.xslt" processor="XSLT">
							<root>
								<xts:queryNode select="/root/env"/>
								<xts:transform src="/transforms/portal/dataSource/generateDatasourceMetadata.xslt" processor="XSLT">
									<xts:param name="messageBase">/messages/portal.xml</xts:param>
									<root/>
								</xts:transform>
							</root>
						</xts:transform>
					</xts:append>
					<xts:append>
						<xts:function name="getConfiguration">	
							<xts:param name="aliasRoots"/>		
						</xts:function>
					</xts:append>
				</xts:sequence>
			</xsl:template>
		</xsl:stylesheet>
	</xts:block>
	<!--
	===============================================================================================
	get_content
	===============================================================================================
	-->
	<xts:block id="get_content" processor="XSLT" type="exec" mode="interpret" condition="/root/datasources/datasource/authentication[type='namespace']" mandatory="false" dependency="load_metadata">
		<xts:logicsheet path="logicsheets/cm-logic.xsl"/>
		<xts:logicsheet path="logicsheets/buslogic.xslt"/>
		<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0" xmlns:cml="http://developer.cognos.com/schemas/xts/logic-sheet/xslt/cml/1/" xmlns:send="http://developer.cognos.com/schemas/xts/logic-sheet/xslt/brl/1/" xmlns:xtsext="xalan://com.cognos.xts.ext.XTSExt">
			<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="no"/>
			<xsl:key name="env-param" match="/root/env/param" use="@name"/>
			<xsl:template match="/">
				<xts:sequence>
					<xts:append>
						<namespaces>
							<xts:transform src="transforms/portal/dataSource/stripnamespace.xslt" processor="XSLT">
								<xts:transform src="transforms/CM/post-process.xslt" processor="XSLT">
									<send:request provider="cm">
										<xts:transform src="transforms/CM/pre-process.xslt" processor="XSLT">
											<query xmlns="http://developer.cognos.com/schemas/xts-cm/1/">
												<search>/directory/namespace<xsl:value-of select="/root/system/param[@name='namespace_filter']"/></search>
												<properties>
													<cm:property name="defaultName"/>
													<cm:property name="searchPath"/>
													<cm:property name="active"/>
												</properties>
											</query>
										</xts:transform>
									</send:request>
								</xts:transform>
							</xts:transform>
						</namespaces>
					</xts:append>
					<!-- get a list of additional datasources -->
					<xts:append faultBlock="ignore">
						<xts:request protocol="FILEREAD" target="$CONFIG_ROOT$/datasources.xml" faultBlock="ignore" cache="false"/>
					</xts:append>
				</xts:sequence>
			</xsl:template>
		</xsl:stylesheet>
	</xts:block>

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

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

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

	<!--
	===============================================================================================
	renderPage - render the page
	===============================================================================================
	-->
	<xts:block id="render_page" mode="output" processor="XSLT" type="exec" mimeType="text/html" dependency="encrypt_password get_content process_datasources">
		<!-- get the presentation theme -->
		<xts:logicsheet path="logicsheets/portal.xsl"/>
		<xts:logicsheet path="logicsheets/presentation/dialog/connections.xslt"/>
		<xts:logicsheet path="logicsheets/presentation/dialog/templates.xsl"/>
		<xts:logicsheet path="logicsheets/presentation/dialog/framework.xsl"/>
		<xts:logicsheet path="logicsheets/presentation/layout.xsl"/>
		<xts:logicsheet path="logicsheets/presentation/dialog/presentation.xsl"/>
		<xts:logicsheet path="logicsheets/presentation/controls/framework.xsl"/>
		<xts:logicsheet path="logicsheets/presentation/controls/presentation.xsl"/>
		<!-- apply the form logic -->
		<xts:logicsheet path="logicsheets/formlogic.xslt"/>
		<xts:logicsheet path="logicsheets/validation.xslt"/>
    <xts:logicsheet path="logicsheets/presentation/touch_up.xslt"/>
		<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
			xmlns:dcx="http://developer.cognos.com/schemas/xts/logicsheets/xslt/presentation/dialog/connections/1/"
			xmlns:dt="http://developer.cognos.com/schemas/xts/logicsheets/xslt/presentation/dialog/templates/"
			xmlns:lyt="http://developer.cognos.com/schemas/xts/logicsheets/xslt/presentation/layout/"
			xmlns:pf="http://developer.cognos.com/schemas/xts/pf"
			xmlns:dp="http://developer.cognos.com/schemas/xts/logicsheets/xslt/presentation/dialog/presentation/"
			xmlns:df="http://developer.cognos.com/schemas/xts/logicsheets/xslt/presentation/dialog/framework/"
			xmlns: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:cm="http://developer.cognos.com/schemas/xts-cm/1/"
			xmlns:xtsext="xalan://com.cognos.xts.ext.XTSExt"
			xmlns:utml="http://developer.cognos.com/schemas/xts/logicsheet/xslt/formlogic/"
			exclude-result-prefixes="xsl dcx cf cp cm pf df dp dt lyt utml">

			<xsl:output method="html" version="1.0" encoding="UTF-8" indent="no"/>
			<!-- current file name -->
			<xsl:variable name="mname" select="'new_connection3.xts'"/>
			<!-- add any theme variables -->
			<pf:variables/>
			<xsl:variable name="fromCMM" select="key('env-param', 'fromCMM')"/>
			<xsl:variable name="fromTransformer" select="key('env-param', 'from_transf')"/>
			<!-- connection templates for the controls -->
			<dcx:connectionTemplates/>

			<xsl:variable name="connectionType" select="key('env-param','m_connection_type')"/>
			
			<xsl:variable name="exclusionList" select="' m_connection_password m_connection_confirm_password '"/>

			<!-- start the output -->
			<xsl:template match="/root">
				<xsl:variable name="backURL" select="key('env-param','backURL')"/>
				<!-- get passed in parameters -->
				<xsl:variable name="connection_typeName" select="/root/datasources/datasource/name"/>
				<xsl:variable name="wizardTitle">
					<xsl:choose>
						<xsl:when test="key('env-param','m_new_class')='dataSource'">
							<xts:string id="IDS_NEW_DATA_SOURCE_TITLE"/>
						</xsl:when>
						<xsl:otherwise>
							<xts:string id="IDS_NEW_CONNECTION_TITLE"/>
						</xsl:otherwise>
					</xsl:choose>
				</xsl:variable>
				<xsl:variable name="browserTitle">
					<xsl:choose>
						<xsl:when test="$connectionType='xml'">
							<xsl:text/><xts:string id="IDS_NEW_TITLE_CONNECT_STRING_ENTER">
								<xts:param name="connectType"><xsl:value-of select="$connection_typeName"/></xts:param>
								<xts:param name="wizardTitle"><xsl:value-of select="$wizardTitle"/></xts:param>
							</xts:string><xsl:text/>
						</xsl:when>
						<xsl:when test="$connectionType!='other'">
							<xsl:text/><xts:string id="IDS_NEW_TITLE_CONNECT_STRING">
								<xts:param name="connectType"><xsl:value-of select="$connection_typeName"/></xts:param>
								<xts:param name="wizardTitle"><xsl:value-of select="$wizardTitle"/></xts:param>
							</xts:string><xsl:text/>
						</xsl:when>
						<xsl:otherwise>
							<xsl:text/><xts:string id="IDS_NEW_TITLE_OTHER_CONNECT_STRING">
								<xts:param name="wizardTitle"><xsl:value-of select="$wizardTitle"/></xts:param>
							</xts:string><xsl:text/>
						</xsl:otherwise>
					</xsl:choose>
				</xsl:variable>
				<xsl:variable name="connTypeDescription" select="/root/datasources/datasource/editDescription"/>
				<xsl:variable name="pageDescription">
					<xsl:text/><xts:string id="IDS_NEW_INTRO_CONNECT"><xts:param name="connectionType"><xsl:value-of select="$connTypeDescription"/></xts:param></xts:string><xsl:text/>
				</xsl:variable>
				<xsl:text disable-output-escaping='yes'>&lt;!DOCTYPE html></xsl:text><dp:page longTitle="$browserTitle">
				<dp:meta>
					<!-- Standard meta tags -->
					<pf:meta/>
				</dp:meta>
					<dp:script>
						<!-- Help system -->
						<pf:help context="HID_ADD_MODIFY_DATA_SOURCE"/>
						<pf:dojo/>
						<script language="javascript" src="{$webcontent}/{$app}/js/connections.js"/>
						<script language="javascript" src="{$webcontent}/{$app}/js/utilities.js"/>
						<script language="javascript">
							<dt:checkMandatoryScript/>
							<dcx:checkReservedChar/>
<xsl:if test="$fromCMM">
	function doCMMCancel()
	{
		document.cmmform.submit();
	}
</xsl:if>

function init()
{
	var f = document.pform;
	f.m.value = '<xsl:value-of select="concat($app,'/new_connection3.xts')"/>';

	<xsl:if test="key('env-param', 'm_connection_proxy_enabled')='true'">
		f.m_connection_proxy_enabled.checked="true";
	</xsl:if>

<xsl:variable name="connectionTypesWithAuthentication">
	<hasAuth connType="sql"/>
	<hasAuth connType="sql2005"/>
	<hasAuth connType="sql2008"/>
	<hasAuth connType="sql2012-2014"/>
	<hasAuth connType="sqlodbc"/>
	<hasAuth connType="jdbc-sql"/>
	<hasAuth connType="composite"/>
	<hasAuth connType="virtualviewmanager"/>
	<hasAuth connType="msanalysis2017"/>
	<hasAuth connType="msanalysis2016"/>
	<hasAuth connType="msanalysis2014"/>
	<hasAuth connType="msanalysis2012"/>
	<hasAuth connType="msanalysis2008"/>
	<hasAuth connType="msanalysis2005"/>
	<hasAuth connType="dbtwoolap"/>
	<hasAuth connType="tm1"/>
	<hasAuth connType="tm1R"/>
	<hasAuth connType="odata"/>
	<hasAuth connType="teradata"/>
	<hasAuth connType="jdbc-teradata"/>
	<hasAuth connType="sap"/>
	<hasAuth connType="powercube"/>
	<hasAuth connType="db2"/>
	<hasAuth connType="jdbc-db2"/>
	<hasAuth connType="odbc"/>
	<hasAuth connType="netezza"/>
	<hasAuth connType="jdbc-netezza"/>
	<hasAuth connType="sr3"/>
	<hasAuth connType="siebel"/>
	<hasAuth connType="sfdc"/>
	<hasAuth connType="jdbc-generic"/>
	<hasAuth connType="lob-jdbc"/>
	<hasAuth connType="oracle"/>
	<hasAuth connType="jdbc-oracle"/>
</xsl:variable>
<xsl:choose>
	<xsl:when test="count($connectionTypesWithAuthentication/hasAuth[@connType=$connectionType]) > 0">
		<xsl:if test="$connectionType='powercube'">
			toggleCubePassword();
			<xsl:if test="$fromTransformer and string(key('env-param', 'm_authentication'))='namespace' and string(key('env-param', 'changed_m_p_credentialNamespaces'))!='1' and count(/root/namespaces/cm:queryResponse/cm:namespace/*) > 0">
				<xsl:variable name="transf_namespace" select="string(key('env-param', 'm_transformer_namespace'))"/>
				if (f.authentication[1] &amp;&amp; f.m_p_credentialNamespaces)
				{
					f.authentication[1].checked=true;
					<xsl:if test="$transf_namespace!=''">
						var namespace = '<xsl:value-of select="xtsext:javascriptencode($transf_namespace)"/>';
						if (f.m_p_credentialNamespaces)
						{
							for (var i=0; i&lt;f.m_p_credentialNamespaces.length;i++) {
								if (namespace == f.m_p_credentialNamespaces.options[i].value)
								{
									f.m_p_credentialNamespaces.options[i].selected= true;
								}
							}
						}
					</xsl:if>
				}
			</xsl:if>
		</xsl:if>

		onChangeAuthentication();

	</xsl:when>
	<xsl:otherwise>
		if (f.m_connection_use_userid)
		{
			updateSignonSection(f.m_connection_use_userid.checked);
		}
		<!--
			'Other' connection doesn't have m_connection_use_userid, but it does have m_connection_default_signon and
			the userid and password fields. Use m_connection_default_signon to enable/disable the userid and password fields
		-->
		else if (f.m_connection_default_signon)
		{
			disableUserIDField(!f.m_connection_default_signon.checked);
			disablePasswordFields(!f.m_connection_default_signon.checked);
		}
	</xsl:otherwise>
</xsl:choose>
<xsl:if test="not($connectionType='json')">
	if (f.m_connection_default_signon &amp;&amp; f.m_connection_userid)
	{
		if (f.m_connection_default_signon.checked == true &amp;&amp; f.m_connection_default_signon.disabled == false)
		{
			f.m_connection_userid.disabled = false;
		}
		else
		{
			f.m_connection_userid.disabled = true;
		}
	}
</xsl:if>
<xsl:if test="$connectionType='powercube' and key('env-param','cube_password_checkbox')">
	<!-- we should do this only if it is the first time...-->
	<xsl:if test="key('env-param','from_transf') and not(/root/env/param[@name='changed_m_connection_default_signon'])">
		<xsl:choose>
			<!-- If the cube_password_checkbox is true then we need to make it checked and enable the default_signon-->
			<xsl:when test="key('env-param','cube_password_checkbox')='true'">
				f.cube_password_checkbox.checked = true;
				f.m_connection_default_signon.disabled = false;
				f.m_connection_default_signon.checked = false;<!-- set this checkbox as un-checked -->
				<xsl:if test="key('env-param','m_connection_default_signon') and key('env-param','m_connection_default_signon')='true'">
					f.m_connection_default_signon.checked = true;<!-- set this checkbox as checked -->
				</xsl:if>
				f.changed_m_connection_default_signon.value = 1;
			</xsl:when>
			<xsl:otherwise>
				<!-- if cube_password_checkbox is not true then make
					the m_connection_default_signon_signon as disabled.
				-->
				f.cube_password_checkbox.checked = false;
				f.m_connection_default_signon.disabled = true;
				f.m_connection_default_signon.checked = false;
				f.changed_m_connection_default_signon.value = 1;
			</xsl:otherwise>
		</xsl:choose>
	</xsl:if>
		if (f.m_connection_default_signon &amp;&amp; f.m_connection_default_signon.checked)
		{
			f.m_cube_password.disabled = !f.m_connection_default_signon.checked;
			f.m_cube_confirm_password.disabled = !f.m_connection_default_signon.checked;
		}
</xsl:if>

<xsl:if test="$connectionType='contributorSeries7'">
    checkPADIDValue();
</xsl:if>

<xsl:if test="$connectionType='sfdc'">
    setProxyControls();
</xsl:if>

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

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

updateJdbcOracle();
updateJdbcSortOptions();
}

function validate()
{
	var f = document.pform;
	<xsl:call-template name="get-validations">
		<xsl:with-param name="connection-type" select="$connectionType"/>
		<xsl:with-param name="connection-variant" select="'new'"/>
	</xsl:call-template>
}


function validateBeforeTest()
{
	var f = document.pform;
	<xsl:call-template name="get-validations">
		<xsl:with-param name="connection-type" select="$connectionType"/>
		<xsl:with-param name="connection-variant" select="'new'"/>
		<xsl:with-param name="test" select="true()"/>
	</xsl:call-template>
}


<xsl:if test="key('env-param','from_bmt')!=''">
<!-- Called only when canceling back to BMT environment.
	from_bmt is not exclusive to BMT. It is added to the environment by the new_connection.xts
	Therefore any external application that calls this morphlet will be defining this from_bmt
	(Transformer, BMT	...).
-->
function doCancel()
{
	window.external.OnClose(1);
}
</xsl:if>


function doTest()
{
	if(!validateBeforeTest())
	{
		return;
	}
	else
	{
		f=document.pform;
		buildConnectString('<xsl:value-of select="xtsext:javascriptencode(string(/root/env/param[@name='m_connection_type']))"/>','<xsl:value-of select="xtsext:javascriptencode(string(/root/env/param[@name='m_connection_variant']))"/>');

		f.ps_nav_op.value = 'push';
		f.m.value = '<xsl:value-of select="concat($app,'/test_connection.xts')"/>';

		f.submit();
	}
}
						</script>
						<script language="javascript" src="{$webcontent}/{$app}/js/utilities.js"/>
					</dp:script>
					<utml:form name="pform" method="post" action="{$gateway}">
						<utml:exclusion-list><xsl:value-of select="$exclusionList"/></utml:exclusion-list>
						<dp:header>
							<!-- header titles-->
							<dp:title><xsl:value-of select="normalize-space($browserTitle)"/></dp:title>
							<dp:description>
								<xsl:choose>
									<xsl:when test="$connectionType = 'contributor'">
										<xsl:text><xts:string id="IDS_NEW_INTRO_CONNECT_NEWCONTRIBUTOR"/></xsl:text>
									</xsl:when>
									<xsl:when test="$connTypeDescription != ''">
										<xsl:value-of select="$pageDescription"/>
									</xsl:when>
								</xsl:choose>
							</dp:description>
							<dp:close>
								<xsl:choose>
									<xsl:when test="key('env-param','from_bmt')">
										<a href="javascript:doCancel()">
											<dp:closeMarker/>
										</a>
									</xsl:when>
									<xsl:when test="$fromCMM">
										<a href="javascript:doCMMCancel()">
											<dp:closeMarker/>
										</a>
									</xsl:when>
									<xsl:otherwise>
										<a href="{$backURL}">
											<dp:closeMarker/>
										</a>
									</xsl:otherwise>
								</xsl:choose>
							</dp:close>
						</dp:header>
						<xsl:choose>
							<xsl:when test="$connectionType = 'composite' or $connectionType = 'virtualviewmanager' or $connectionType = 'db2' or $connectionType = 'openEdge' or $connectionType = 'odbc' or $connectionType = 'redbrick' or $connectionType = 'teradata' or $connectionType = 'sqlodbc' or $connectionType = 'sybaseIQ' or $connectionType = 'netezza'">
								<!--
								=========================================================================
									D B 2 / O D B C
								=========================================================================
								-->
								<xsl:call-template name="dcx-db2-odbc-template">
									<xsl:with-param name="form-read-only" select="$form-read-only"/>
									<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
								</xsl:call-template>
							</xsl:when>
							<xsl:when test="$connectionType = 'msas_xmla'">
								<!--
								=========================================================================
									Microsoft Analysis Services (via XMLA)
								=========================================================================
								-->
								<xsl:call-template name="dcx-msas_xmla-template">
									<xsl:with-param name="form-read-only" select="$form-read-only"/>
									<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
								</xsl:call-template>
							</xsl:when>
							<xsl:when test="contains(' sql sql2005 sql2008 sql2012-2014 ', concat(' ',$connectionType,' '))"> 
								<!--
								=========================================================================
									M S   S Q L   S e r v e r (OLE DB and 2005 and 2008 and 2012 and 2014)
								=========================================================================
								-->
								<xsl:call-template name="dcx-sql-template">
									<xsl:with-param name="form-read-only" select="$form-read-only"/>
									<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
								</xsl:call-template>
							</xsl:when>
							<xsl:when test="$connectionType = 'oracle'">
								<!--
								=========================================================================
									O R A C L E
								=========================================================================
								-->
								<xsl:call-template name="dcx-oracle-template">
									<xsl:with-param name="form-read-only" select="$form-read-only"/>
									<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
								</xsl:call-template>
							</xsl:when>
							<xsl:when test="$connectionType = 'sybase' or $connectionType = 'sybase_ct15'">
								<!--
								=========================================================================
									S Y B A S E
								=========================================================================
								-->
								<xsl:call-template name="dcx-sybase-template">
									<xsl:with-param name="form-read-only" select="$form-read-only"/>
									<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
									<xsl:with-param name="connection-type" select="$connectionType"/>
								</xsl:call-template>
							</xsl:when>
							<xsl:when test="$connectionType = 'informix'">
								<!--
								=========================================================================
									I N F O R M I X
								=========================================================================
								-->
								<xsl:call-template name="dcx-informix-template">
									<xsl:with-param name="form-read-only" select="$form-read-only"/>
									<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
								</xsl:call-template>
							</xsl:when>
							<xsl:when test="$connectionType = 'sr3'">
							<!--
							=========================================================================
											S A P R 3
							=========================================================================
							-->
							<xsl:call-template name="dcx-sapr3-template">
							<xsl:with-param name="form-read-only" select="$form-read-only"/>
									<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
							</xsl:call-template>
							</xsl:when>

							<xsl:when test="$connectionType = 'sfdc'">
							<!--
							=========================================================================
											S F D C
							=========================================================================
							-->
							<xsl:call-template name="dcx-sfdc-template">
							<xsl:with-param name="form-read-only" select="$form-read-only"/>
									<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
							</xsl:call-template>
							</xsl:when>
							
							<xsl:when test="$connectionType = 'siebel'">
							<!--
							=========================================================================
											S I E B E L
							=========================================================================
							-->
							<xsl:call-template name="dcx-siebel-template">
							<xsl:with-param name="form-read-only" select="$form-read-only"/>
									<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
							</xsl:call-template>
							</xsl:when>
							<xsl:when test="$connectionType = 'sap'">
								<!--
								=========================================================================
									S A P   B W
								=========================================================================
								-->
								<xsl:call-template name="dcx-sap-template">
									<xsl:with-param name="form-read-only" select="$form-read-only"/>
									<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
								</xsl:call-template>
							</xsl:when>
							<xsl:when test="$connectionType = 'sapR3' or $connectionType = 'sapECC'">
								<!--
								=========================================================================
									S A P   R 3 or SAP BW ECC
								=========================================================================
								-->
								<xsl:call-template name="dcx-sapR3-template">
									<xsl:with-param name="form-read-only" select="$form-read-only"/>
									<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
								</xsl:call-template>
							</xsl:when>
							<xsl:when test="$connectionType = 'consolidation'">
								<!--
								=========================================================================
									Cognos Consolidation
								=========================================================================
								-->
								<xsl:call-template name="dcx-consolidation-template">
									<xsl:with-param name="form-read-only" select="$form-read-only"/>
									<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
								</xsl:call-template>
							</xsl:when>
							<!--
								The contributor type does not have parameters therefore we don't need to call its template.
								Only contributor Series 7 has parameters.
							-->
							<xsl:when test="$connectionType = 'contributorSeries7'">
								<!--
								=========================================================================
									Cognos Contributor Series 7
								=========================================================================
								-->
								<xsl:call-template name="dcx-contributorSeries7-template">
									<xsl:with-param name="form-read-only" select="$form-read-only"/>
									<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
								</xsl:call-template>
							</xsl:when>
							<xsl:when test="$connectionType = 'powercube'">
								<!--
								=========================================================================
									Cognos PowerCube
								=========================================================================
								-->
								<xsl:call-template name="dcx-powercube-template">
									<xsl:with-param name="form-read-only" select="$form-read-only"/>
									<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
								</xsl:call-template>
							</xsl:when>
							<xsl:when test="$connectionType = 'dbtwoolap'">
								<!--
								=========================================================================
									IBM DB2 OLAP Server
								=========================================================================
								-->
								<xsl:call-template name="dcx-db2olap-template">
									<xsl:with-param name="form-read-only" select="$form-read-only"/>
									<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
								</xsl:call-template>
							</xsl:when>
							<xsl:when test="$connectionType = 'tm1'">
								<!--
								=========================================================================
									TM1
								=========================================================================
								-->
								<xsl:call-template name="dcx-tm1-template">
									<xsl:with-param name="form-read-only" select="$form-read-only"/>
									<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
								</xsl:call-template>
							</xsl:when>
							<xsl:when test="$connectionType = 'tm1R'">
								<!--
								=========================================================================
									Planning Analytics
								=========================================================================
								-->
								<xsl:call-template name="dcx-tm1R-template">
									<xsl:with-param name="form-read-only" select="$form-read-only"/>
									<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
								</xsl:call-template>
							</xsl:when>
							<xsl:when test="$connectionType = 'odata'">
								<!--
								=========================================================================
									Open Data Protocol (OData)
								=========================================================================
								-->
								<xsl:call-template name="dcx-odata-template">
									<xsl:with-param name="form-read-only" select="$form-read-only"/>
									<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
								</xsl:call-template>
							</xsl:when>
							<xsl:when test="$connectionType = 'json'">
								<!--
								=========================================================================
									JavaScript Object Notation (JSON)
								=========================================================================
								-->
								<xsl:call-template name="dcx-json-template">
									<xsl:with-param name="form-read-only" select="$form-read-only"/>
									<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
								</xsl:call-template>
							</xsl:when>
							<xsl:when test="$connectionType = 'cognosnow'">
								<!--
								=========================================================================
									COGNOS NOW! Cube
								=========================================================================
								-->
								<xsl:call-template name="dcx-cognosnow-template">
									<xsl:with-param name="form-read-only" select="$form-read-only"/>
									<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
								</xsl:call-template>
							</xsl:when>
							<xsl:when test="contains(' msanalysis2005 msanalysis2008 msanalysis2012 msanalysis2014 msanalysis2016 msanalysis2017 ', concat(' ',$connectionType,' '))"> 
								<!--
								=========================================================================
									Microsoft Analysis Services 2005, 2008, 2012, 2014, 2016 and 2017
								=========================================================================
								-->
								<xsl:call-template name="dcx-msanalysis2005-template">
									<xsl:with-param name="form-read-only" select="$form-read-only"/>
									<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
								</xsl:call-template>
							</xsl:when>
							<xsl:when test="$connectionType = 'xml'">
								<!--
								=========================================================================
									X M L
								=========================================================================
								-->
								<xsl:call-template name="dcx-xml-template">
									<xsl:with-param name="form-read-only" select="$form-read-only"/>
									<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
								</xsl:call-template>
							</xsl:when>
							<xsl:when test="$connectionType = 'other'">
								<!--
								=========================================================================
									 O t h e r
								=========================================================================
								-->
								<xsl:call-template name="dcx-other-template">
									<xsl:with-param name="form-read-only" select="$form-read-only"/>
									<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
								</xsl:call-template>
							</xsl:when>
							<xsl:when test="$connectionType = 'jdbc-generic' or $connectionType = 'lob-jdbc'">
								<!--
								=========================================================================
									 JDBC Generic
								=========================================================================
								-->
								<xsl:call-template name="dcx-jdbc-generic">
									<xsl:with-param name="form-read-only" select="$form-read-only"/>
									<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
								</xsl:call-template>
							</xsl:when>
							<xsl:when test="$connectionType = 'filenet'">
								<!--
								=========================================================================
									 FileNet
								=========================================================================
								-->
								<xsl:call-template name="dcx-filenet">
									<xsl:with-param name="form-read-only" select="$form-read-only"/>
									<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
								</xsl:call-template>
							</xsl:when>
							<xsl:when test="$connectionType = 'jdbc-oracle'">
								<!--
								=========================================================================
									 Oracle (JDBC)
								=========================================================================
								-->
								<xsl:call-template name="dcx-jdbc-oracle">
									<xsl:with-param name="form-read-only" select="$form-read-only"/>
									<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
								</xsl:call-template>
							</xsl:when>
							<xsl:when test="$connectionType = 'jdbc-sql'">
								<!--
								=========================================================================
									 SQL Server (JDBC)
								=========================================================================
								-->
								<xsl:call-template name="dcx-jdbc-sql">
									<xsl:with-param name="form-read-only" select="$form-read-only"/>
									<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
								</xsl:call-template>
							</xsl:when>
							<xsl:when test="$connectionType = 'jdbc-db2'">
								<!--
								=========================================================================
									 IBM DB2 (JDBC)
								=========================================================================
								-->
								<xsl:call-template name="dcx-jdbc-db2">
									<xsl:with-param name="form-read-only" select="$form-read-only"/>
									<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
								</xsl:call-template>
							</xsl:when>
							<xsl:when test="$connectionType = 'jdbc-teradata'">
								<!--
								=========================================================================
									 Teradata (JDBC)
								=========================================================================
								-->
								<xsl:call-template name="dcx-jdbc-teradata">
									<xsl:with-param name="form-read-only" select="$form-read-only"/>
									<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
								</xsl:call-template>
							</xsl:when>
							<xsl:when test="$connectionType = 'jdbc-netezza'">
								<!--
								=========================================================================
									 Netezza (JDBC)
								=========================================================================
								-->
								<xsl:call-template name="dcx-jdbc-netezza">
									<xsl:with-param name="form-read-only" select="$form-read-only"/>
									<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
								</xsl:call-template>
							</xsl:when>
						</xsl:choose>
						<xsl:if test="$connectionType != 'xml' and $connectionType != 'contributor' and $connectionType != 'contributorSeries7' and $connectionType != 'cognosnow'">
							<xsl:variable name="divDisplayValue">
								<xsl:choose>
									<xsl:when test="/root/env/param[@name='m_connection_type_history'] = ''">
										<xsl:value-of select="'block'"/>
									</xsl:when>
									<xsl:otherwise>
										<xsl:value-of select="'none'"/>
									</xsl:otherwise>
								</xsl:choose>
							</xsl:variable>
							<div id="gen-signon-section" style="display: {$divDisplayValue}">
								<xsl:call-template name="gen-signon-section">
									<xsl:with-param name="form-read-only" select="$form-read-only"/>
									<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
									<xsl:with-param name="uid-pwd-checkboxes">
										<xsl:choose>
											<xsl:when test="contains('composite virtualviewmanager tm1 odata dbtwoolap powercube msanalysis2005 msanalysis2008 msanalysis2012 msanalysis2014 msanalysis2016 msanalysis2017 redbrick teradata netezza jdbc-teradata sqlodbc db2 jdbc-db2 msas_xmla odbc openEdge sql sql2005 sql2008 sql2012-2014 jdbc-sql oracle jdbc-oracle jdbc-generic lob-jdbc filenet netezza jdbc-netezza sybase sybase_ct15 informix sybaseIQ', $connectionType)">
												<xsl:value-of select="'true'"/>
											</xsl:when>
											<xsl:otherwise>
												<xsl:value-of select="'false'"/>
											</xsl:otherwise>
										</xsl:choose>
									</xsl:with-param>
									<xsl:with-param name="connectionType">
										<xsl:value-of select="$connectionType"/>
									</xsl:with-param>
									<xsl:with-param name="wizard" select="'true'"/>
								</xsl:call-template>
							</div>
						</xsl:if>
						<!-- Special division for contributor -->
						<xsl:if test="$connectionType = 'contributor' or $connectionType = 'contributorSeries7'">
							<xsl:call-template name="gen-contributor-section">
								<xsl:with-param name="form-read-only" select="$form-read-only"/>
								<xsl:with-param name="utml-form-name" select="$utml-form-name"/>
								<xsl:with-param name="uid-pwd-checkboxes" select="'false'"/>
								<xsl:with-param name="connectionType" select="$connectionType"/>
								<xsl:with-param name="wizard" select="'true'"/>
							</xsl:call-template>
						</xsl:if>

						<utml:input type="hidden" name="m_p_connectionString"/>

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

						<!-- test the connection section -->
						<lyt:layout title="IDS_PROP_CONN_TESTING" style="1" border="yes">
							<lyt:section>
								<dp:choice>
									<dp:section1>
										<a href="javascript:doTest();">
											<xsl:text><xts:string id="IDS_PROP_CONN_TEST_CONNECTION"/></xsl:text>
										</a>
									</dp:section1>
								</dp:choice>
							</lyt:section>
						</lyt:layout>


						<!-- Drop the "Wait" dialog here so it gets rendered in the correct spot on the page -->
						<xsl:if test="key('env-param','from_bmt')">
							<cp:genericDialog id="wait" width="200" height="100">
								<cp:param name="title"></cp:param>
								<cp:param name="message">
									<img src="{$brand_images}progress.gif" align="absmiddle"/><xsl:value-of select="'&#160;&#160;&#160;&#160;&#160;&#160;'"/><xts:string id="IDS_WAIT"/>
								</cp:param>
							</cp:genericDialog>
						</xsl:if>
						<dp:footer>
							<!-- Cancel button -->
							<xsl:choose>
								<xsl:when test="key('env-param','from_bmt')!=''">
									<df:button df:id="IDS_CANCEL" df:style="href" df:href="javascript:doCancel()"/>
								</xsl:when>
								<xsl:when test="$fromCMM">
									<df:button df:id="IDS_CANCEL" df:style="href" df:href="javascript:doCMMCancel()"/>
								</xsl:when>
								<xsl:otherwise>
									<df:button df:id="IDS_CANCEL" df:style="back-url"/>
								</xsl:otherwise>
							</xsl:choose>

							<!-- Back button -->
							<xsl:choose>
								<xsl:when test="key('env-param','from_transf')!=''">
									<df:button df:id="IDS_BACK" df:style="maintain" df:label="IDS_BACK_LABEL" >
										<df:target>
											<xsl:value-of select="concat($app, '/new_general.xts')"/>
										</df:target>
									</df:button>
								</xsl:when>
								<xsl:otherwise>
									<df:button df:id="IDS_BACK" df:style="href" df:label="IDS_BACK_LABEL" df:href="javascript:back()"/>
								</xsl:otherwise>
							</xsl:choose>
							<utml:input type="hidden" name="m_return" value=""/>

							<!-- Next button -->
							<xsl:choose>
								<xsl:when test="/root/datasources/datasource/supportsCommandBlocks = 'true'">
									<xsl:variable name="queryServiceEquivalent">
										<xsl:if test="count(/root/env/param[@name='m_create_jdbc'])!=0">
											<xsl:value-of select="concat('&amp;quot;',/root/datasources/datasource/queryServiceEquivalent,'&amp;quot;')"/>
										</xsl:if>
									</xsl:variable>
									<df:button df:id="IDS_NEXT"  df:style="href" df:label="IDS_NEXT_LABEL" df:href="javascript:next({$queryServiceEquivalent})"/>
								</xsl:when>
								<xsl:otherwise>
									<df:button df:id="IDS_NEXT"/>
								</xsl:otherwise>
							</xsl:choose>
							
							<!-- Finish button -->
							<xsl:choose>
								<xsl:when test="count(/root/env/param[@name='m_create_jdbc'])!=0 and /root/env/param[@name='m_connection_type_history']=''">
									<df:button df:id="IDS_FINISH"/>
								</xsl:when>
								<xsl:otherwise>
									<df:button df:id="IDS_FINISH" df:style="href" df:href="javascript:finish()"/>
								</xsl:otherwise>
							</xsl:choose>
							
						</dp:footer>
				
						<script language="javascript">
							var bCommandSent = false;
							
							function getEncodedConnectionTypes() {
								var types = document.pform.m_connection_type_history.value;
								if (types != '') {
									types+=',';
								}
								types+=document.pform.m_connection_type.value;
								return types;
							}
							
							function finish() {
								if (validate()) {
									if(getEncodedConnectionTypes() == 'json'){
										var f = document.pform;
										var authString = 'http://<xsl:value-of select="/root/http/param[contains(@name,'SERVER_NAME')]"/>' + '<xsl:value-of select="/root/http/param[contains(@name,'SCRIPT_NAME')]"/>';
										if (f.m_connection_authentication_type.value == 'OAuth1.0') {
											authString += '/oauth1?';												
											authString += '&amp;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_p_defaultName.value;
											window.open(authString);
										}
										if (f.m_connection_authentication_type.value == 'OAuth2.0') {
											authString += '/oauth2?';
											authString += '&amp;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_p_defaultName.value;
											window.open(authString);
										}
									}
									
									document.pform.ps_nav_op.value = "maintain";
									buildConnectString(getEncodedConnectionTypes(),'new');
									<xsl:if test="key('env-param', 'm_new_class')='dataSource' and (key('env-param', 'from_transf')!='' or (not($fromCMM) and not(key('env-param', 'from_bmt')!='')))">
										<!-- we don't have to set the m_return when the wizard is called by CMM, FM and PW1.
											This is already taken care by new_connection.xts.
											The new_connection_finish.xts will present the option to create a package
											when permitted.
											Exception is for the Transformer which provides from_bmt and from_transf (BUG# 539911)
										-->
										document.pform.m_return.value = '<xsl:value-of select="$app"/>/new_connection_finish.xts';
									</xsl:if>
									document.pform.m.value = "<xsl:value-of select="$app"/>/submit.xts";
									<xsl:choose>
										<xsl:when test="key('env-param','from_bmt')">
											if (!bCommandSent) {
												document.pform.submit();
												bCommandSent = true;
												<xsl:if test="$browser='ie'">
													wait.show();
													document.body.style.cursor = "wait";
												</xsl:if>
											} else {
												bCommandSent = false;
												<xsl:if test="$browser='ie'">
													document.body.style.cursor = "default";
													wait.hide();
												</xsl:if>
											}
										</xsl:when>

										<xsl:otherwise>
											document.pform.submit();
										</xsl:otherwise>
									</xsl:choose>
								}
							}
							
							function back() {
							
								document.pform.ps_nav_op.value = "maintain";
								var connectionTypeHistory = document.pform.m_connection_type_history.value.split(',');
								
								if (connectionTypeHistory.length > 0 &amp;&amp; (connectionTypeHistory[0] != '')) {
									document.pform.m_connection_type.value = connectionTypeHistory.pop();
									document.pform.m_connection_type_history.value = connectionTypeHistory;
									document.pform.m.value = "<xsl:value-of select="$app"/>/new_connection3.xts";
								} else {
									document.pform.m.value = "<xsl:value-of select="$app"/>/new_connection2.xts";
								}
								
								document.pform.submit();
							}

							function next(nextConnectionType) {
								if (validate()) {
									document.pform.ps_nav_op.value = "maintain";
									var encodedConnectionTypes = getEncodedConnectionTypes();
									buildConnectString(encodedConnectionTypes,'new');
									if (nextConnectionType) {
										document.pform.m_connection_type_history.value = encodedConnectionTypes;
										document.pform.m_connection_type.value = nextConnectionType;
										document.pform.m.value = "<xsl:value-of select="$app"/>/new_connection3.xts";
									} else {
										document.pform.m.value = "<xsl:value-of select="$app"/>/new_connection4.xts";
									}
									document.pform.submit();
								}
							}
						</script>

						<!-- if we're building a Cognos Finance or Planning connection and there aren't any namesapces defined, then show
						a warning dialog -->
						<xsl:if test="$connectionType = 'consolidation' and not(/root/namespaces/cm:queryResponse/cm:namespace)">
							<script language="javascript">
								alert('<xts:string id="IDS_PROP_CONN_FINANCE_NO_NAMESPACE_WARNING" encode="javascript"/>');
							</script>
						</xsl:if>
					</utml:form>
					<xsl:if test="$fromCMM">
						<dt:cmmPostBackForm/>
					</xsl:if>
					<script>
					//overcome issues with UTML causing previous connection3.xts hidden form attrs to be missing
					var formParams = {
						<xsl:for-each select="/root/env/param[not(contains(@name,$exclusionList))]">
							'<xsl:value-of select="xtsext:javascriptencode(@name)"/>':'<xsl:value-of select="xtsext:javascriptencode(text())"/>'<xsl:if test="position()!=last()">,</xsl:if>
						</xsl:for-each>	
					}
					for (var name in formParams) {
						var value = formParams[name];
						if (!document.pform[name]) {
							var f = document.createElement('input');
							f.setAttribute('name', name);
							f.setAttribute('id', name);
							f.setAttribute('value',value);
							f.setAttribute('type', 'hidden');
							document.pform.appendChild(f);
						}
					}
					
				</script>
					
				</dp:page>
			</xsl:template>
			<xsl:template match="*[local-name()='messageString']">
					<xsl:value-of select="xtsext:javascriptencode(string(.))"/><xsl:if test="string-length(normalize-space(.)) > 0">\n</xsl:if>
			</xsl:template>
		</xsl:stylesheet>
	</xts:block>
	<!--
	===============================================================================================
	debug - display debug information
	===============================================================================================
	-->
	<xts:block id="debug" dependency="render_page" condition=".[/root/session/param[@name='debug']='1']" type="exec" mode="output" processor="XSLT" mandatory="false" mimeType="text/html">
		<!-- get the debug logic sheet -->
		<xts:logicsheet path="logicsheets/debuglogic.xslt"/>
		<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:dbg="http://developer.cognos.com/schemas/xts/logicsheets/xslt/debug/" exclude-result-prefixes="dbg">
			<xsl:output method="html" version="1.0" encoding="UTF-8" indent="no"/>
			<xsl:template match="/">
				<dbg:dumpxml select="/root"/>
			</xsl:template>
		</xsl:stylesheet>
	</xts:block>
</xts:morphlet>