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

Database Connection: Override driver class for a dialect

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Severity: High
    • Resolution: Done
    • Affects Version/s: 5.4.0 GA, 6.0.0 GA
    • Fix Version/s: 8.1.0 GA, Backlog
    • Component/s: Database
    • Labels:
      None
    • Story Points:
      0
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.

      Description

      As an ETL developer, I would like to be able to select a custom JDBC driver to be used with a specific dialect. This allows flexibility in situations where I have multiple database driver options for a given database type (Impala, Redshift, MySQL/MariaDB, etc).

      The generic database dialect option does not work in all cases, as any database dialect-specific settings would not be used with the Generic option.

      This also helps when wanting to use the Log4JDBC driver, which provides a proxy class to do debug logging between Pentaho and a JDBC driver.

      UX Recommendation

      See the below link for our UX recommendation. Please feel free to reach out to Stephanie Bodendorfer if you have any questions. 
      http://ux.pentaho.com/pdi-dbc-driver-override/#g=1&p=concept

        PractiTest Integration




          Attachments

            Issue Links

              Activity

                People

                Assignee:
                Unassigned Unassigned
                Reporter:
                mtucker Matt Tucker
                Votes:
                2 Vote for this issue
                Watchers:
                10 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved: