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

Enhanced support for the native query procedure

    Details

    • Type: Feature Request
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 8.6
    • Component/s: Teiid Integration
    • Labels:
      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)

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                blafond Barry LaFond
                Reporter:
                shawkins Steven Hawkins
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: