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.
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.