2 Replies Latest reply on Dec 11, 2018 3:14 AM by Luca Vercelli

    [newbie] expose tables through OData

    Luca Vercelli Newbie


      I am completely newbie to Teiid framework, and also to Wildfly.

      My goal is to expose a (large) number of tables  of my database via OData protocol. (Tables are not and must not be mapped to any JPA class). Is Teiid the right tool to do this? If so, can somebody trace me the roadmap to achieve the goal?


      In particular, I already have a Weblogic WAS running, can I expose the OData webservice through that WAS?


      Thank you.

        • 1. Re: [newbie] expose tables through OData
          Ramesh Reddy Master



          Welcome to Teiid Community, we thank you for considering using Teiid.


          Yes, Teiid can be used to solve your usecase. There are few different ways this can be done.


          1) If you looking for a standalone server based on WildFly you can use Teiid WildFly instance and design and deploy a vdb into it. There is WAR file for OData but that requires the VDB be installed in same server where a Teiid Server is also installed. So this may not right if you want to make it work in the Weblogic.


          2) You can also Thorntail port of it, which is kind of based on WildFly and microprofile, best tuned for container workloads. An example can be found here just needs to add an extra dependency in pom.xml to enable the odata  support. There may be a way to wrap this into a WAR file that can be deployed in weblogic, but I have no idea.


          3) The last is Teiid based on Spring Boot, which is also better for container workloads, but this can be right choice IMO. Here is an example here.  Here if you are just exposing a single database there is no need to create JPA objects to be created. I am also updating this library to accept a plain VDB file and expose odata on it (still in works, week or so before available). Here if you can find ways to deploy a spring boot app into Weblogic that may work. Something like Spring Boot on Oracle WebLogic Server 12 - virtual7 Blog