Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-1884

Enhanced support for the native query procedure

    XMLWordPrintable

Details

    • Feature Request
    • Resolution: Done
    • Major
    • 8.6
    • None
    • Teiid Integration
    • None

    Description

      Teiid translators can expose a procedure to execute arbitrary source queries. When operating with a dynamic vdb the appropriate metadata is automatically made available to the engine, but in Designer the user must manually add a procedure definition. For many users this is a difficult process - see the forum link.

      The complications here are that the procedure is selectively enabled and is allowed to have different names based upon the translator properties.

      The general procedure form is:

      create foreign procedure native (query in string, params in object varidaic) returns table(row_value object)

      Attachments

        Activity

          People

            blafond Barry LaFond
            rhn-engineering-shawkins Steven Hawkins
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: