9 Replies Latest reply on Jan 13, 2019 4:02 PM by Ramesh Reddy

    Teiid does not present view as EntityType

    Tamar Meron Newbie

      Hi,

       

      I am using Teiid in order to expose Postgres view inside Salesforce.

      Beside this view I have created few tables.

      When accessing the $metadata endpoint I can see all the tables as entity types but I can't see any view.

      After debugging the code I noticed that the problem is that my view doesn't define primary key/unique constraint,

      but as far as I know it is not possible to define primary key or unique constraint on Postgres views..

       

      Does anybody know how to handle it? I saw that Teiid supports both views and Postgres data source...