Hello @Praveen Yakkala
Thanks for the question and also for using the forum .
Since we do not have the environment to test this , but i could like you to point to the document https://www.oracle.com/a/ocom/docs/database/adw-creatingodp-net-sqlserver.pdf . I think it can be helpful .
Also we can use the unattended account for the impersonation setting, have you gone through the doc . https://zcusa.951200.xyz/en-us/analysis-services/tabular-models/impersonation-ssas-tabular?view=asallproducts-allversions
Please do let me know how it goes .
Thanks
Himanshu