xml as data source over ftp/sftp connection in teiid server

[kulbhushanc]

Hi,

I am using Teiid admin api 9.1.3, wildfly 10.0.0.

I am need to use xml as data source over ftp/sftp connection .

could  you please provide all step to configure this in teiid server.

Thanks,

Kulbhushan Chaskar.

[rareddy]

This no different than How to configure xml as a data-source in teiid? the difference is you read the data from ftp/sftp source then use the XMLTABLE construct to convert the data to table. In the example you may have used file, here you use FTP, so the source or connection-jndi-name is different.

[kulbhushanc]

Thanks Ramesh for quick response.

We are using teiid admin api ,not  teiid designer so we need help to create data source in standalone-teiid xml.

Thanks,

Kulbhushan.

[rareddy]

Ftp/Ftps Data Sources · Teiid Documentation