Can we retrieve webservice Metadata and DDL view creation at run time

[klmurty]

I have a requirement where i choose one of the data sources is web service  and is there any way to create database table creation according to web service SOAP response     ?

As of now I can see that all DDL definitions either you can do it in vdb.xml or you can define through ModelMetaData.

I really appreciate if you can provide any pointers on this issue.

[rareddy]

The native soap response going to be always XML, so there is no table definition there. In Teiid user writes a transformation, that converts the XML into a relational table. So, that is a user activity. You can use the Teiid Designer and its wizard to do this, use the XML functions in Teiid to define the transformation in the dynamic VDB. There are examples in the documentation for this.

Ramesh..

[klmurty]

Thanks for update Ramesh.

yes I understood that soap response is in XML and I find it in example where XML function is used to parse the XML and converted into table. But this is at design time(Before running).

I need to do this at run time dynamically.

Is there any way to create schema definition dynamically depend on SOAP response XML ?

[rareddy]

> Is there any way to create schema definition dynamically depend on SOAP response XML ?

Unfortunately, there is no way to define a new View at runtime, at most you can do is at deployment time by developing a new translator. But let's say you have View defined, you can change the transformation of the View. Note that does not change  view layout like column definitions, just underlying transformation.

[klmurty]

Thanks for reply Ramesh.