Uploaded image for project: 'Pentaho Data Integration - Kettle'
  1. Pentaho Data Integration - Kettle
  2. PDI-9805

As an ETL-developer, I want to have better SQL handling options to prevent special dialect issues

    XMLWordPrintable

    Details

    • Epic Name:
      PDI - SQL handling

      Description

      Use cases:

      • A couple of reported incidents about false parsing/modification of SQL queries is listed in the comments of PDI-7814.
      • The reason is, the following options are now done auto-magically for certain database and not for others depending on whether or not they need it:

      [ x ] Strip CR/LF
      [ x ] Perform Variable Substitution
      [ x ] Try to remove comments ( – and /* )

      Conditions of Satisfaction:

      • We have a couple of options to disable or influence the parsing/modification of SQLs in steps/job entries or another more central spot (TBD - working with UX)
      • We have an extra tab on suitable steps/job entries and allow specification of SQL statements in a data grid including separate comments

      Notes:

      • see PDI-13298 Refactor PDI code/API for parser provider(s)

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              jbleuel Jens Bleuel
              Votes:
              7 Vote for this issue
              Watchers:
              10 Start watching this issue

                Dates

                Created:
                Updated: