2 Replies Latest reply on Feb 8, 2019 1:29 AM by Manoj Majumdar

    Need suggestions to upgrade Teiid version

    Manoj Majumdar Newbie

      I am new to teiid , We are using 9.1.3 version of Teiid and wanted to upgrade to latest version 10.2.1

       

       

      1. Could you please help me with what new enhancements has been done in new version..

       

      2. We need to connect to cloud ,azure DBs which version so could you please suggect which version we should use?

       

      3. Does Teiid supports header Delimited Flat Files with true /header false and fixed length  flat file?

      If yes which translator we should use?

      Can we select data from file with same  SQL query syntax or syntax will be different to select/read data with condition.

       

      4. Also if possible please suggest which version will be best to upgrade and its release notes.

       

      Thanks in advance,

      Pranita Gurav

        • 1. Re: Need suggestions to upgrade Teiid version
          Steven Hawkins Master

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

           

          Migration Guide From Teiid 9.x · GitBook

          Migration Guide From Teiid 10.x · GitBook

          Migration Guide From Teiid 11.x · GitBook