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.
    • Epic Link:

      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

            is duplicated by

            Improvement - An improvement or enhancement to an existing feature or task. PDI-15696 improve DB2DatabaseMeta to support type 2 drivers

            • Low - An issue with the general usage of Pentaho in a production environment with little to no impact on business operation.
            • Closed
            is related to

            Bug - A problem which impairs or prevents the functions of the product. PDI-15528 Sybase JTDS driver issue

            • Medium - An issue that impacts the ability to use Pentaho in a production environment but business operation is able to continue, although it may, to a certain extent, be hindered. A viable documented workaround exists for the issue and can be used in a production environment.
            • Open

            Bug - A problem which impairs or prevents the functions of the product. PDI-17692 Overriding the dialect on Generic Connection is not being called as expected

            • Urgent - An issue that causes severe impact in the ability to use Pentaho in a production environment. This issue halts normal business operations and a viable documented workaround is not available.
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. PDI-15578 Allow the creation of a JDBC URL per Oracle documentation

            • Medium - An issue that impacts the ability to use Pentaho in a production environment but business operation is able to continue, although it may, to a certain extent, be hindered. A viable documented workaround exists for the issue and can be used in a production environment.
            • Closed

            Improvement - An improvement or enhancement to an existing feature or task. PDI-13565 jconn4 driver support for Sybase IQ database (null)

            • Unknown - Priority Unknown or Unassigned
            • Open

            Improvement - An improvement or enhancement to an existing feature or task. BISERVER-8085 DAW - The MySQL JDBC connection must be defined (in datasources table) as org.gjt.mm.mysql.Driver for getDatabaseMeta to "know" it's mysql

            • High - An issue that impacts and reduces ability to use Pentaho in a production environment. Business operations are able to continue, however they may be highly impacted and a viable documented workaround is not available.
            • Closed

            Improvement - An improvement or enhancement to an existing feature or task. PDI-14925 Include Log4JDBC for easier debugging

            • High - An issue that impacts and reduces ability to use Pentaho in a production environment. Business operations are able to continue, however they may be highly impacted and a viable documented workaround is not available.
            • Closed
            relates to

            New Feature - A new feature of the product, which has yet to be developed. PDI-7640 As an ETL-Developer, I want to define new database dialects and change the behaviour of existing ones more easily without Java coding

            • High - An issue that impacts and reduces ability to use Pentaho in a production environment. Business operations are able to continue, however they may be highly impacted and a viable documented workaround is not available.
            • Open
            links to

            Web Link PDI-14462-reqs.docx

              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: