Qlik Sense Connecting to MS Office 365 Sharepoint URL

[balajibc64]

Hello,

I need to establish a connection between Qlik Sense and the Office 365 SharePoint URL. I have tested this in my Qlik Sense Test environment, and it is functioning properly.

However, I have a few questions:

1. I need to create the Encryption key and executed the command

"C:\Program Files\Common Files\Qlik\Custom Data\QvWebStorageProviderConnectorPackage". QvWebStorageProviderConnectorPackage.exe /key {key}

During this process, a key is generated, but it was indicated that it would be stored at C:\Users\QvService\AppData\Roaming\Qlik\QwcKeys\, whereas the key is actually being stored at C:\Users\QvService\AppData\Roaming\Qlik\Keys\. 

So, In which folder the key needs to be store ? 

2. On my production server, I have checked both of the following folders, and the key folder is present: C:\Users\QvService\AppData\Roaming\Qlik\QwcKeys\                            C:\Users\QvService\AppData\Roaming\Qlik\Keys\ Is this the default location?

If I execute these commands, will it affect the existing setup in any way? 

3. After completing the above steps, should I restart any services?

Kindly suggest

[Eduardo_Monteiro]

Hi @balajibc64 

Having both QwcKeys\ and Keys\ folders present is normal. They probably came from different connector versions or previous installations.

If you're able to take a server snapshot/backup before any changes, it's always recommended to do it.

Answering your questions:

1. You need the generated key to be stored under QwcKeys\

2. The encryption key only affects data connections for connectors that require it. If you are running a multi-node environment, you will need the same key in every node. 

3. No services restart needed, refresh the browser(F5) and it will re-run the connector.

I hope that helps!

Regards,

[balajibc64]

@Eduardo_Monteiro Thanks. So if the key is stored in this path "You need the generated key to be stored under QwcKeys\" 

I need to create a key using this command QvWebStorageProviderConnectorPackage.exe /QwcKeys {key}. I'm right ? (earlier I mentioned /keys) 

If you're able to take a server snapshot/backup before any changes -- Will it fine if i take the respective folder back alone ? 

[Eduardo_Monteiro]

Hi @balajibc64 

I need to create a key using this command QvWebStorageProviderConnectorPackage.exe /QwcKeys {key}. I'm right ? (earlier I mentioned /keys) 

No, please use the following:

1. Open a command prompt and run:

   runas /user:{sense service user} cmd. For example:runas /user:MYCOMPANY\senseserver

2. Run the following two commands to switch to the directory containing the connectors and then set the key:

   1. cd C:\Program Files\Common Files\Qlik\Custom Data\QvWebStorageProviderConnectorPackage

   2. QvWebStorageProviderConnectorPackage.exe /key {key}

      Where {key} is the key you generated. For example, if you used the openssl command, your key might look like: QvWebStorageProviderConnectorPackage.exe /key <your pre generated key>

3. You should repeat this step, using the same key, on each node in the multinode environment where the Qlik Engine and the connectors are installed.

If you're able to take a server snapshot/backup before any changes -- Will it fine if i take the respective folder back alone? 

As it can affect the capability of loading the connectors, I'd recommend a server backup. Otherwise, you have to reinstall the connectors to fix the key.

[balajibc64]

@Eduardo_Monteiro Yes, I followed all the mentioned steps.

As per Step 2, I executed the following command:

QvWebStorageProviderConnectorPackage.exe /key "generated key"

After executing this command, the key file was updated in the below folder path: 

C:\Users\<qlikuser>\AppData\Roaming\Qlik\Keys

The modified date of the file reflects today’s date and the updated key file name is qseow_master_key.

Let me know if any additional validation or steps are required.

[Eduardo_Monteiro]

That's it. It should be working now.

Please let us know if it worked.

Regards,