Uploaded image for project: 'Talend Component Kit'
  1. Talend Component Kit
  2. TCOMP-1760

Support of studio schema DB name

Apply templateInsert Lucidchart Diagram
    XMLWordPrintable

Details

    • New Feature
    • Resolution: Duplicate
    • Major
    • None
    • None
    • None
    • All
    • GreenHopper Ranking:
      0|i1tv4r:
    • 9223372036854775807
    • Small

    Description

      Since 1.1.20 version, TCK connectors can support columns'name not compliant with Avro. The schema API has been improved :

      Currently, when an @Option is binded to studio schema with @structure, and has a dedicated service to retrieve schema by 'Guess schema' button, the tck schema columns'name are copied into studio schema 'Column' & 'DB Column'.

      We should now copy in 'DB Column' the name returned by TCK/Schema#getOriginalFieldName

      As a symmetry, when the studio set the columns from its schema in the connector configuration, we should set 'DB Column' names and not 'Column' names. So, the connector will get the real and sanitize it if necessary and then compute column name and raw column name.

      Example:

      • Currently:
        • Guess Schema => call a service => it retrieves "#COL-A", "#COL-B", "#COL-C" =sanitize=> ["COL_A", "COL_B", "COL_C"]
        • Studio schema is (Columns, DB Columns) => [("COL_A", "COL_A") , ("COL_B", "COL_B") , ("COL_C", "COL_C")] => Columns equals DB Columns equals sanitized name
        • Runtime : the connector List<String> option is set with sanitized names : ["COL_A", "COL_B", "COL_C"]

      Salesforce Properties

        Case
        Case Origin
        Case Type
        Case Age
        00191875 Web Feature Request 1

        Attachments

          Issue Links

            Activity

              People

                emmanuel_g emmanuel gallois
                ypiel Yves Piel
                Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved: