Hi,
I am trying to trigger QlikView task once our Informatica workflow finishes but having issues getting that work. To give you a background on what my team has tried.
1. Both the servers are in different domains and hence we are not able to trigger the QV task. To solve the domain issue we created a local user within QV server and added that as part of Informatica post command processing job (within a batch file which resides in the F: drive of Informatica). This batch file then triggers the QlikView EDX batch file which is located on the QV server.
2. I have added the service account (qlikview and informatica) and users into the QlikView EDX local group.
I am now getting NTLM issue and the QV task doesn't get triggered.
Failed to create a client to the specified Uri.
The HTTP request is unauthorized with client authentication scheme 'Ntlm'. The a
uthentication header received from the server was 'NTLM'.
Unhandled Exception: System.ServiceModel.Security.MessageSecurityException: The
HTTP request is unauthorized with client authentication scheme 'Ntlm'. The authe
ntication header received from the server was 'NTLM'. ---> System.Net.WebExcepti
on: The remote server returned an error: (401) Unauthorized.
at System.Net.HttpWebRequest.GetResponse()
at System.ServiceModel.Channels.HttpChannelFactory`1.HttpRequestChannel.HttpC
hannelRequest.WaitForReply(TimeSpan timeout)
— End of inner exception stack trace —
Is this something to do with the IIS settings on QliKView server. Also now we are trying to use ICS secure agent. Below are the steps for that:
PowerCenter (PC) modification:
Modify Dummy PC worklet by adding
1- Command task to write a dummy flat file to the F:\infa_shared\TgtFiles directory.
ICS:
1- Create an ICS DSS task that reads the dummy flat file
2- Add a Preprocessing Commands to call the qlikview server EDX batch job.
3- Add a Postprocessing Commands to delete the file that was copied from step#2 (PC modification).
4- Schedule the job to run every 5 minutes.
Appreciate any sort of help.
