5 Replies Latest reply on Oct 22, 2012 10:19 AM by Dave Stannard

    Adding SOURCE_NAME to metadata for multi-source dynamic VDBs

    Dave Stannard Newbie

      Is there any way to add the SOURCE_NAME virtual column to the table metadata for multi-source dynamic VDBs?

       

      We are trying to use Crystal Reports over a set of horizontally-sharded databases and it does not present the SOURCE_NAME column for selection.  Preseumably this is because Teiid does not report it in the table metadata.

       

      When using the Designer we can edit each of the (160) tables in the model, manually adding the column and that will work; however, the new dynamic VDB style is so much easier to create and maintain, we would much rather use that.

       

      Regards

       

      Dave