Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Read about the latest Qlik Community enhancements on the Community News blog!
Showing results for 
Search instead for 
Did you mean: 
Not applicable


Hi ,

can any one explain what is UAT , SIT and PROD . And how they are used in real time ?

4 Replies
Creator III
Creator III


  These are terms related to database and schemas.


System Integration Testing. It is the environment where Internal testing will take place. Say your testing team's work area.


After SIT is over the app and its respective data are moved to UAT schema, where user Acceptance Testing will be done. Say your clients technical team will test that. Finally after every testing is passed the app is moved to PROD environment.


It is a production environment where live data will be there.

* For developers usually seperate schema called DEV is used for development purposes..

Hope it helps

Master II
Master II


Sequence of these 3 is SIT > UAT>PROD.

SIT: Actual development happens. We will test the applications with the test data.

UAT: User will test the development work with the data.

PROD: Once the user sign-off(agreed that everything is correct) we move to live environment.

Hope this will help you.


It also applies to every form of software release management and roll-outs, not just to databases. Enterprise QlikView set-ups usually involve multiple separate QlikView platforms as to not endanger the final applications and in order to perfectly measure and control the development and roll-out of new applications and their associated risks.

Another workflow diagram uses similar acronyms: DEV => ACC => PROD, where DEV = DEVelopment, ACC = ACCeptance and PROD = PRODuction.

See also Software testing - Wikipedia, the free encyclopedia (UAT) and System integration testing - Wikipedia, the free encyclopedia (SIT)

Creator III
Creator III

Hi Peter,

     I understood that. Thank you very much