Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qliklearnervir
Creator
Creator

how to load huge data from oracle with insert and update !!!

Hi,

 

I have over 150 millions rows daily to make insert or update scenario .

is there any best way to handle these things in qlik or similar to SQL , we can use Update syntax. 

 

 

2 Replies
Brett_Bleess
Former Employee
Former Employee

We do not recommend using QilkView for updating of backend data sources, we are primarily an analytics tool, not a database update tool, so not really sure what you are attempting to do, but I would believe it is likely best done using straight SQL in the DB side.  If you can provide further information regarding the full use case here, we may be able to provide a better answer, but this is the best I can do at the moment.  

It is possible to make SQL Execute and other calls from our script editor, but you must enable the setting in the attached screenshot in that case, but again, this is not something we recommend doing.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
ramasaisaksoft

Hi Vir,

As you know we (QlikView) will create Reports with the help of existing Data base /Tables and we have the capability inbuilt ETL (Extraction, Transformation, Loading)process in QV.

But we will support this a very little bit like Creating Incremental Load ,Simple Joins,Concatenation...etc.

So my recommendation to you is, Request either DB team/ETL team to finish the update things at DB level and get the data from that updated DB tables into QlikView script.

UPDATE Syntax

UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;
 

Note: Be careful when updating records in a table! Notice the WHERE clause in the UPDATE statement. The WHERE clause specifies which record(s) that should be updated. If you omit the WHERE clause, all records in the table will be updated!