topic Re: Rest connection to RSA Archer in Connectivity & Data Prep

Rest connection to RSA Archer

fularirahul — Tue, 21 Dec 2021 14:01:50 GMT

Hi Team,I am trying to establish the connection to RSA Archer from qlikview to extract data , I am exploring the Rest connection , I got connection establish but its not supporting JSON. Please help on this to read data from RSA archer.

Below is my custom connection string :

CUSTOM CONNECT TO "Provider=QvRestConnector.exe;
url=http://Servername/apps/ArcherApp;
timeout=30;method=GET;
autoDetectResponseType=true;
keyGenerationStrategy=0;
authSchema=ntlm;
skipServerCertificateValidation=false;
useCertificate=No;
certificateStoreLocation=CurrentUser;
certificateStoreName=My;
queryParameters=Content-Type%2application/json;
queryHeaders=Authorization%2{%%3Authorization%%3:%%3Archer session-id%%2%%3 + $session_token,%%3X-Http-Method-Override%%3:%%3GET%%3,%%3Authorization%%3:%%3Archer session-id%%2%%3 + $session_token};
PaginationType=None;
allowResponseHeaders=false;
allowHttpsOnly=false;
XUserId=USERID;XPassword=PWD;";

Re: Rest connection to RSA Archer

Jay_Brown — Mon, 01 Apr 2019 13:42:21 GMT

Hello @fularirahul , thanks for posting your issue!

Are you getting a JSON response from any other rest clients such as Postman or ARC or some other client? Please test outside of Qlik, as the individual clients usually give debug information that could be helpful. Once you get the response you seek, you can usually use modify this for use in QlikView or Qlik Sense.

Re: Rest connection to RSA Archer

fularirahul — Mon, 01 Apr 2019 16:59:52 GMT

Thank you , Will check with ARC rest client and will let you know.

Re: Rest connection to RSA Archer

anchittiwari — Mon, 06 May 2019 06:16:08 GMT

Hi, I am trying to connect Qlik to RSA Archer as well. Where you able to pull this off?

Any update would be helpful.

Re: Rest connection to RSA Archer

donnadima — Sun, 15 Sep 2019 17:20:36 GMT

Were you able to get archer to connect to qlik sense?

please let me know

thank you,

donna

Re: Rest connection to RSA Archer

fularirahul — Mon, 16 Sep 2019 01:45:27 GMT

Yes . I will share the details tomorrow.

Re: Rest connection to RSA Archer

LazyBanker — Wed, 20 Nov 2019 21:33:12 GMT

Hi @fularirahul, I may need to use a similar connection. Can you post what you found out from your troubleshooting? And how you were able to connect?

Thanks!

Re: Rest connection to RSA Archer

cnkrgz — Tue, 02 Jun 2020 16:24:43 GMT

I`m trying to connect QlikSense and Archer as well. I`d be glad if you guys who made it can share some information. Appreciate any input.

Re: Rest connection to RSA Archer

Marc_Fontana — Tue, 01 Sep 2020 13:36:21 GMT

Hello, were you able to get this to connect with Qlik Sense? Any new ideas on this one?

Thanks,

Marc

Re: Rest connection to RSA Archer

JohnSacco — Tue, 15 Mar 2022 21:50:15 GMT

Would be interested in the solution for how to connect as well if you can share