Security and Authentication in FXLData - Revision history

Vmurrell: /* Fusion Registry Authentication */

2026-06-15T12:58:56Z

‎Fusion Registry Authentication

Vmurrell: Vmurrell moved page Security and Authentication in FXLData - Draft to Security and Authentication in FXLData

2024-07-24T11:37:36Z

Vmurrell moved page Security and Authentication in FXLData - Draft to Security and Authentication in FXLData

Vmurrell: Created page with "Category:Getting Started FXLData = Fusion Security Manager = In order to access data and use it in FXLData, Fusion Security Manager must be set up to ensure that the appro..."

2024-07-18T16:24:53Z

Created page with "Category:Getting Started FXLData = Fusion Security Manager = In order to access data and use it in FXLData, Fusion Security Manager must be set up to ensure that the appro..."

New page

[[Category:Getting Started FXLData]]
= Fusion Security Manager =
In order to access data and use it in FXLData, Fusion Security Manager must be set up to ensure that the appropriate users are able to access the relevant data. You can read all about Fusion Security Manager [[Fusion_Security_Manager_(FR_V11) |in this article.]]

=Fusion Registry Authentication=
Excel will automatically request the user to authenticate when executing and FXLData function where the Fusion Registry data source is operating in ''[[Server_Security#Server_Security|private mode]]''.

Points to note:
* Excel will remember authentication details provided for the remainder of the session. Close and reopen Excel if you need to re-authenticate as a different user.
* A spread sheet can contain multiple FXLData functions using different Fusion Registries. Excel will ask for separate authentication details for each Fusion Registry, thus it is possible to connect to Fusion Registry A as user X, and Fusion Registry B as user Y.
* No authentication will be requested if a Fusion Registry is operating in ''public mode''.

[[File:Sign.png|30px]] There is no way to force FXLData to authenticate as a particular user if the Fusion Registry is operating in ''[[Server_Security#Server_Security|public mode]]'' but also allows authenticated users with additional data access privileges. Fusion Registry administrators should consider switching to ''[[Server_Security#Server_Security|private mode]]'' as a work-around.

[[File:FXLData Excel Authentication.PNG|300px]]

===[username]@ URL prefix to force authentication as a specific user===
From Fusion Registry 11.1.1 (release 10 June 2022) and FXLData 1.1.1, [username]@ can be prefixed to the URL to force authentication as the user identified by [username].

Example:
=FXLData("johnwright@https://stats.mydomain.org/FusionRegistry","ABC,CPI,1.0","A..X00.M+Q._Z")

The Fusion Registry will ensure the user logs in with the given username. To force authentication without specifying a username, user the @ prefix with no username.

=FXLData("@https://stats.mydomain.org/FusionRegistry","ABC,CPI,1.0","A..X00.M+Q._Z")

← Older revision		Revision as of 12:58, 15 June 2026
Line 14:		Line 14:

	[[File:FXLData Excel Authentication.PNG\|300px]]		[[File:FXLData Excel Authentication.PNG\|300px]]
		+
		+	[[Category:How to and other features in FXLData]]
		+
		+
		+	==Extended Authentication Capabilities==
		+
		+	Introduced in R26.2.0.00 RSH-FS 28.05.26
		+
		+	This option allows a user to Login to FXLData before they are actually required to do so. In the past the Login box would appear as an when it was required which could interrupt the users workflow.
		+
		+	To use the feature, select Login from the FXLData Ribbon Bar.
		+
		+	[[File:Sel-login-options.png\|600px]]
		+
		+	First, select the registry that you wish to access as shown in the example below.
		+
		+	[[File:Login-8080.png\|600px]]
		+
		+	Click Login, the Excel login box will appear, enter your credentials in the usual way.
		+
		+	Successful authentication will be confirmed as shown in the image below.
		+
		+	[[File:Login-success.png\|600px]]
		+
		+	=== Troubleshooting ===
		+	* Scenario 1:
		+	You select a registry and click Login, but the feedback box says:“You are logged into {registryUrl} as {userId}.”
		+	This indicates that you are already authenticated with the selected registry.
		+	If you need to log in as a different user, you will have to restart Excel.
		+	Switching accounts within the same Excel session is not supported in the first phase of this feature.
		+
		+	* Scenario 2:
		+
		+	You click Login, but no login prompt appears and the feedback box says: “Login Failed.”
		+	In this case, the most likely cause is an authentication configuration issue within the registry.
		+	To resolve this, please contact your registry administrator or raise a ticket with Regnology for assistance

	===[username]@ URL prefix to force authentication as a specific user===		===[username]@ URL prefix to force authentication as a specific user===

← Older revision	Revision as of 11:37, 24 July 2024
(No difference)