Review User Activity in ODI 12.2.1

Review User Activity in ODI 12.2.1:

Today I am showing a new feature and probably something best for the admin guys. Its about the user statistics those are currently logged in to Odi Studio. Well in the earlier version we use to run queries against metadata tables to see their activity. Now its an inbuilt feature.

This screenshot is from ODI 12.1.3 missing this feature.



Below screenshot is from 12.2.1 where you can see the new option Review User Activity.



I did a quick test on two user to see what type of information it is going to show us. As usual the default user  SUPERVISOR  and one Bhabani Mahapatra created by Supervisor. After changing the date range, click on the filter icon. You will be seeing the login time, repository type, host name etc.

If the repository type is null that means it is connected to master repository. This could have been better by seeing on what object user has put a lock, last action performed.  But no doubt this can fetched with some queries and more like requirement specific.



For connection status there are three options available: All, Inactive and Active.



The user statistics is stored by introducing a new table SNP_USER_CONNECTED which was not present in 12.1.3.



Thats all for today. Keep visiting us for more tips and tricks.


About the author

Bhabani( - Currently Bhabani is working as Technical Lead Product Development at Harman International. He has good expertise on Oracle, ODI, Pervasive Data Integrator, MSBI, Talend, Cloud Integration (AWS, GCP, Azure) , Map-R and Apache Airflow. He is also contributing in ODI-OTN forum for last 7 years. He is from India. If you want to reach him then please visit contact us page. If you have any doubts or concerns on the above article, please put your question here. Dw Team will try to respond it as soon as possible. Also dont forget to provide your comments / suggestions / feedback for further improvement. Thanks for your time.

Similar Posts


Superb stuff Bhabani, keep it going and us informed 🙂

we are using two data servers in ODI.but both having different port and service name.

Can we use one data server tables as source and other data server tables as target in ODI interface in ODI12.1.3.
Please suggest on this as we are getting error while generating scenario in this case.

Leave a reply


Are you a human? *