Skip to Content
avatar image
Former Member

External Definition from MS SQL Server View

Hi all,

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.

Best Regards

Sven

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 30, 2010 at 09:41 AM

    Hi Sven,

    You can operate with views as well using JDBC adapter.

    You can just give the view name in place of a table name and access them both alike.

    Regards

    Jai

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Raja Sekhar Reddy

      Hi all,

      does anybody have a hard piece of evidence (some statement from SAP, documentation)? Please point me to it.

      Why won't this feature work with Views, they can basically be treated in the same way as tables?

      Best Regards

      Sven

  • avatar image
    Former Member
    Aug 09, 2010 at 03:15 PM

    After tests against SQL Server and Oracle databases, I'm afraid, the external definitions are really not able to cope with views - for whatever reason. So I'm closing this thread.

    Best Regards

    Sven

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      It's an very old thread, but maybe my solution will be helpful to someone. I'm running SAP PI 7.11 and it can be tricked, by creating fake table with the same fields as in view. Configure JDBCLookup for the table as usual. Than just delete table (or change it's name) and set the same name to view.

      Than it works without problem. Probably PI calls jdbc function getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types) with types limited only to "TABLE". I hope it's fixed in PI 7.3.