Can we use teiid as a stand alone server without wildfly

[kulbhushanc]

I am using teiid run time along with wildfly. We need to reduce the overall size, so I was wondering that can I use teiid without wildfly. Or is there any other way to get version with minimal configuration?

Can we user teiid runtime with other web servers like tomcat, websphere? If yes how VDBs and will be manged/deployed on the severs?

also If somehow we are able to establish connection with the datasource created on other than WildFly server, but are we able to create datasource,VDB dynamically?

[shawkins]

In addition to the full WildFly distribution, you can choose to use Teiid with WildFly swarm - GitHub - teiid/wildfly-swarm-teiid-examples.  That unfortunately does little to reduce the footprint of wildfly in the uber jar, but can prune Teiid dependencies from unused translators/resource adapters.  You may also just roll your own environment using Teiid Embedded - GitHub - teiid/teiid-embedded-examples: Examples for Teiid(http://teiid.org)  - but that has some differing features and functionality compared to the full version - Embedded Guide · Teiid Documentation

> Can we user teiid runtime with other web servers like tomcat, websphere?

There is no pre-packaged solution for that at this time, just the options above deployed in a different container.

Do you have some specific requirements for what you need to reduce - WildFly itself or unused Teiid dependencies?

[kulbhushanc]

I was going through below mentioned url:

https://docs.jboss.org/author/display/TEIID/JBoss+AS+DataSource#JBossASDataSource-LocalJDBCConnection

It is mentioned that "Defining as data source is not limited to JBoss AS, you can also deploy as data source in Glassfish, Tomcat, Websphere, Weblogic etc servers, however their configuration files are different than JBoss AS".

We want to reduce the overall size as there is some space restriction on the server which I am going to use. If it can be done deleting unused jars or any other file in existing wildfly version 10.0.0 then also it will help otherwise if we can deploy teiid on tomcat then tomcats size is already less.

Could you please let me know that if tomcat cannot be used then what is the reason behind that? Because as per my understanding we configure datasource on wildfly and create jndi through which its reference is saved in vdb of teiid, so why i cannot configure datasource in tomcat and do the same thing as I am doing with wildfly?

[shawkins]

> It is mentioned that "Defining as data source is not limited to JBoss AS, you can also deploy as data source in Glassfish, Tomcat, Websphere, Weblogic etc servers, however their configuration files are different than JBoss AS".

Meaning that the Teiid Driver can be used in any application server to make connections to a Teiid Server.  That is not discussing how to deploy the Teiid Server.

> If it can be done deleting unused jars or any other file in existing wildfly version 10.0.0

WildFly provides a servlet only and a full distribution.  There is nothing that's supported in between, but that's not to say you couldn't do removals based upon your needs.  There should be support in swarm for trimming the WildFly footprint, but that isn't something that we've worked on yet.

> Could you please let me know that if tomcat cannot be used then what is the reason behind that?

I didn't say it could not be used, it would require rolling your own Teiid environment using swarm or Teiid Embedded.