External Definition from MS SQL Server View
I'm trying to create an external definition with category dbtab. The database i'd like to access is a Microsoft SQL Server 2005. After I provided the receiver communication channel and click on display, all tables are shown in the list. But there are some views I need to use in the jdbc lookup, which aren't shown. Is this in any way limited to real physical tables or is there a way to access views as well.
I'm running on SAP PI 7.11.