Using Database Views in XI

[Former Member]

Hi Guys,

We have come across requirement where we have to use Views rather then Database Tables...

Kindly share your knowledge and views..:

1. Is there any difference in handling the views as compred to Tables....?

2. Like Tables do we have to create the similar type of source and target message types for views also...?

3. From XI point ...where we can expect the difference views/ tables..in terms of developing design and configuration objects..?

Regards,

[Former Member · Accepted solution]

HI Santosh,

There is no any difference in XI between handling tables and views. You do exactly the same to handle the views as tables.

From database side, there maybe some difference, e.g. you cannot insert records into a view, you need develop some triggers for the views.

Regards,

Hui

[Former Member]

Hi

Views are windows to the tables.When you create views in the DB, technically there is not much difference between them.

Therefore just like tables we have to create similar type of source and target messages for views also.

Moreover while developing design and configuration objects also no difference will be observed.

Thanks

[Former Member]

Hi Santosh,

the easiest way is to set up you sender agreement including communication channel with the select statement. The XI start to >poll< on the table/vies. Than goto SXMB_MONI and you will see how your message type has to lok like .

Regards Mario