Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
It's taking more than 3 hrs to write back 60000 records from Qlikview (qvd) to SQL server DB using Oledb connection.
Please suggest if any faster process available.
Have you confirmed things are fast if you use say Excel to do the pull using the same data connection? That is what I would suggest you do in order to determine if it is potentially something on our side, or if it is in the DB/Connector side of things.
Regards,
Brett
Pulling data from excel to Qlikview document is not the actual solution. I was asking if there is any better way to save the data into SQL server using Qlikview.
We are not really meant for writing things back to SQL instances, that is not a good use case for the product by any means... You can do it, but it would have to be via Stored Procedure call or actually running SQL script in our script editor, but you have to be sure the DB Connector can handle everything you are looking to pass to it in that case which may or may not be the case... Best I can offer.
Regards,
Brett