topic Re: How to retrieve user id from connection string in QlikView

How to retrieve user id from connection string

swati_rastogi27 — Mon, 10 Apr 2017 08:54:46 GMT

Can someone help me find the id from QlikView connection string?

We had been using this connection string from over a year and the password to the id suddenly got expired.

To get more details or to reset password , we need the id.

Can someone help?

Re: How to retrieve user id from connection string

vinieme12 — Mon, 10 Apr 2017 09:14:59 GMT

This isn't related to QV so I suggest you ask Google.

But if you had an ODBC/OLEDB connection, then you would also have a DSN in the ODBC admin

Hit windows key and search for ODBC

Re: How to retrieve user id from connection string

rahulpawarb — Mon, 10 Apr 2017 09:28:15 GMT

Hello Swati,

You can refer the User ID field from connection string to get user Id (sample connection string is given below):

OLEDB CONNECT32 TO [Provider=SQLOLEDB.1;Persist Security Info=True;User ID=sa;Initial Catalog=AdventureWorksDW2008R2;Data Source=RAHUL-PAWAR\SS2K8R2;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=RAHUL-PAWAR;Use Encryption for Data=False;Tag with column collation when possible=False] (XPassword is JABcBYFMTbcOXXJOETHB);

Hope this will help.

Regards!

Rahul

Re: How to retrieve user id from connection string

swati_rastogi27 — Mon, 10 Apr 2017 09:36:43 GMT

My connection string within the application is like :

ODBC CONNECT TO MYDATABASE (XUserId is BGAcALDCTbcOXXJOETHB, XPassword is JABcBYFMTbcOXXJOETHB);

Re: How to retrieve user id from connection string

rahulpawarb — Mon, 10 Apr 2017 10:06:10 GMT

Hello Swati,

It seems that you are using ODBC connection type using DSN with name MYDATABASE. You can find the the UserId in two ways:

1. Go to the ODBC Data Sources; locate the DSN with MYDATABASE and press configure button. On the next screen you can see the User Name field

2. In Edit Script, go to the Database section & select ODBC option. Post that press Connect. Select the ODBC with MYDATABASE name & Press OK. This will trigger a screen inquiring connection details; there you could find User Name.

Hope this will be of help.

Regards!

Rahul

Re: How to retrieve user id from connection string

swati_rastogi27 — Mon, 10 Apr 2017 10:58:02 GMT

Unfortunately I am trying to connect to DB2, using Adaptive Server Enterprise driver and I don't see the user Id there with the options you mentioned above.

For Oracle I am able to see.

Re: How to retrieve user id from connection string

Miguel_Angel_Baeyens — Mon, 10 Apr 2017 12:53:41 GMT

You must have a driver installed in the server where the QlikView Distribution Service reloads, so you will need to update that driver there. Note that DSNs may have the user and password in their definition, so you may need to change them there.

Finally, note also that there are two odbcad32.exe for 32-bit and 64-bit connections. Although the name of the file is the same, they are in different folders

C:\Windows\SysWOW64\odbcad32.exe (32-bit)
C:\Windows\System32\odbcad32.exe (64-bit)

Yes, "SysWOW64" contains the 32 bit version while "System32" contains the 64-bit version (the one you see by default - https://support.microsoft.com/en-us/help/942976/odbc-administrator-tool-displays-both-the-32-bit-and-the-64-bit-user-dsn…)

Re: How to retrieve user id from connection string

Anonymous — Wed, 20 Jun 2018 15:46:32 GMT

Hi Miguel,

Different topic, sorry.

Could you tell me if the user id in Qlik has a limited number of characters?

Why? I'm retrieving user mail truncated up to 20 characters and the mail is also the user id

Best Regards,

Gabriel

Re: How to retrieve user id from connection string

Miguel_Angel_Baeyens — Thu, 21 Jun 2018 06:59:18 GMT

I'm not aware of any limitation other than the operating system and driver, but that's way longer than 20 characters. I have some deployments with usernames of 19 to 23 characters long working just fine.

Re: How to retrieve user id from connection string

Anonymous — Mon, 25 Jun 2018 09:29:06 GMT

Thanks Miguel,

I also checked that within Qlik Repo DB, it's 500+ characters so it's not a Qlik Sense issue but from AD itself.

I verified within here SAM-Account-Name attribute (Windows) that AD syncs users with this atribute "SAM-Account-Name" that limits it to 20 characters because of older Windows versions. Is there a workaround so I can fetch the full lenght of the userid within AD?

Thank you

Re: How to retrieve user id from connection string

Miguel_Angel_Baeyens — Mon, 25 Jun 2018 11:04:46 GMT

I'm not aware of any workaround, probably Qlik Support can help you on that to retrieve another unique identifier for users instead of the SAMAccountName?

However, 500+ characters for any account or server name sounds to me a bit odd, only typing 500 characters can take you some time. Wouldn't it be a hash or something instead of the actual account name?

Re: How to retrieve user id from connection string

Anonymous — Tue, 31 Jul 2018 12:22:24 GMT

The UserID is the email address in AD (this one does not belong to me, so no changes possible).

My workaround was to user Generic LDAP, now I have users successfully authenticated with their email domain\address.

For the ones reading, you need to check AD properties for a successful configuration. After this done, it's not possible to have users authenticate with other credentials different from email address. Fix one side screws the other xD

Best Regards