> How to make connection with remote XML file?
You need to use the Webservices resource adapter. Adding through the admin api could look like:
Properties p = new Properties(); p.setProperty("class-name", "org.teiid.resource.adapter.ws.WSManagedConnectionFactory"); p.setProperty("EndPoint", "http://..."); admin.createDataSource("myWebse:rviceDS", "webservice", p);
> Do we need to provide schema definition in VDB file or Teiid by default read XML file and provide schema structure?
You always need a VDB. You'll use the Webservices or WS translator with the resource adapter. How you expose the XML from there is up to your needs. If you want it as tabular data then you'll want a view or procedure that reads processes the xml - probably with the XMLTABLE table function.