Qlik Connection to Workday

etrotter — Mon, 26 Jan 2026 18:19:17 GMT

Hello Experts,

I am struggling with a workday connection, I'm using a soap API and its incredibly slow, each time it runs its been taking over 24 hours. I haven't actually been able to finish a whole load, I'm using a loop to go through the data and it pulls 700 rows at a time. There is a total of around 53,000 rows but on the 27th loop it fails unexpectly, this is what it says in the script log:

2018-03-21 23:55:01 1036 [Personal_Data]:

2018-03-21 23:55:01 1037 LOAD [Birth_Date] AS [Birth_Date],

2018-03-21 23:55:01 1038 [Hispanic_or_Latino] AS [Hispanic_or_Latino],

2018-03-21 23:55:01 1039 [Tobacco_Use] AS [Tobacco_Use],

2018-03-21 23:55:01 1040 [__KEY_Personal_Data] AS [__KEY_Personal_Data],

2018-03-21 23:55:01 1041 [__FK_Personal_Data] AS [__KEY_Worker_Data]

2018-03-21 23:55:01 1042 RESIDENT RestConnectorMasterTable

2018-03-21 23:55:01 1043 WHERE NOT IsNull([__FK_Personal_Data])

2018-03-21 23:55:03 5 fields found: Birth_Date, Hispanic_or_Latino, Tobacco_Use, __KEY_Personal_Data, __KEY_Worker_Data,

2018-03-21 23:55:03 Execution Failed

2018-03-21 23:55:03 Execution finished.

When I try to debug it it has this error: Qvx file read error on line 1, too many columns

So my question is two fold, why is it so slow at pulling in data and is there a way to make it faster? Why is it failing on the 27th loop and how do I fix this?

If I do a limited load with 5 loops it finishes fine, the problem only occurs when i try to load the whole thing.

Thanks in advance!

Re: Qlik Connection to Workday

agni_gold — Fri, 16 Nov 2018 17:49:04 GMT

How you connected with workday , can you please explain me bit more with any example and any connector you used ?

Re: Qlik Connection to Workday

morenoju — Wed, 04 Mar 2020 17:12:11 GMT

I'm curious about this too. How did you connect Qlik to Workday?

Re: Qlik Connection to Workday

Deepika — Mon, 18 May 2020 13:59:19 GMT

Were you successful in connecting to Workday? Can you share your experience?

topic Re: Qlik Connection to Workday in QlikView

Qlik Connection to Workday

Re: Qlik Connection to Workday

Re: Qlik Connection to Workday

Re: Qlik Connection to Workday