> I am new to teiid , We are using 9.1.3 version of Teiid and wanted to upgrade to latest version 10.2.1
teiid.jboss.org is pending a retirement. The latest release is now Teiid 12.0.0. However upgrading a major version at a time is a good idea. You would start with 10.3.5 10.x Downloads · Teiid, then move to Teiid 11.2.2 Teiid Wildfly Downloads | Teiid
> 1. Could you please help me with what new enhancements has been done in new version..
The major enhancements are called out in the release notes link that accompany every major / minor release. For example Teiid 10.3.0 Release Notes
> 2. We need to connect to cloud ,azure DBs which version so could you please suggect which version we should use?
Generally support is based upon db type, not whether it's running in the cloud. Are you referring to Azure SQL Database, Cosmos, etc.? There hasn't been specific support added for those. Generally you would just use the SQL Server driver for Azure SQL Database.
> 3. Does Teiid supports header Delimited Flat Files with true /header false and fixed length flat file?
If yes which translator we should use?
The TEXTTABLE sql construct is used to parse delimited files. The translator typically provides just the raw files. You can alternatively use something like hsql support to define text table. See the options supported by TEXTTALBE: TEXTTABLE · GitBook
> Can we select data from file with same SQL query syntax or syntax will be different to select/read data with condition.
Once a view is defined using TEXTTABLE or an hsql text table, it can be queried just like any other table.
> 4. Also if possible please suggest which version will be best to upgrade and its release notes.
See the migration guides in the admin doc: