Central configuration of JDBC connection

Comments

7 comments

  • Avatar
    Adrian Williams

    Hi Holger,

    The data flow properties and run properties are typically configured to satisfy this type of requirement for a common location for the definition of a value to be used by multiple nodes within a data flow.

     

    The use of these properties is described in the 'Advanced' -> 'Defining properties' section of the Dataverse help and can also be accessed online here:

    https://d3sa-preview.infogixsaas.com/docs/dist/help/Default.htm#d-advanced-topics/defining-properties.htm%3FTocPath%3DAdvanced%2520topics%7C_____3

    [Edit: ^ Updated URL]

     

    Run properties would probably be appropriate for your dev/prod environment use case.

    Regards,

    Adrian

    0
    Comment actions Permalink
  • Avatar
    Holger Schimanski

    That sounds perfect! Thank you very much for the hint.

    Maybe you can add a screenshot to the documentation, how run properties are exposed to consumers of the data workflow.

     

    Best regards
    Holger

    0
    Comment actions Permalink
  • Avatar
    Rocco Pigneri

    Dear Holger,

    We have taken your feedback and tightened up the language a bit since it seemed that the language was the weakest part of the documentation.  You will see the changes in a week or two here, or you can also find the changes in the 3.1.2 release which will be available in the next week.

    Hope that helps,

    Rocco

    0
    Comment actions Permalink
  • Avatar
    Holger Schimanski

    I am using now data flow properties to centrally configure by several JDBC nodes as suggested. In general it works, but I would like to get one little improvement to make this much more convenient to use.

    JDBC connection is a set of 4 parameters: driver, URL, user and password.

    I would be great to have them as a standard group in the data flow properties as a kind of new type.

    And then use this JDCB connection ("Sales DB JDBC Conn" in the above example) as a group of properties to configure my JDBC node. And not all 4 parameters individually.

    What do you think?

    Best regards
    Holger

    0
    Comment actions Permalink
  • Avatar
    Adrian Williams

    Hi Holger,

    Thanks for your suggestion. We have been discussing some designs for enhancements that would allow a user to define a database connection object that could then be referenced from multiple nodes within a data flow, and also from multiple data flows. This would provide centralised configuration of JDBC connections. It would also permit database connections to be created by, say, an admin user and then (securely) shared with end users.

     

    Regards,

    Adrian

    0
    Comment actions Permalink
  • Avatar
    Holger Schimanski

    Hello Adrian!

    Has there anything implemented or changed in Dataverse regarding centralized configuration of JDBC connections since your last post?

    Best regards
    Holger

    0
    Comment actions Permalink
  • Avatar
    Adrian Williams

    Hi Holger, unfortunately this enhancement has not yet been included in the product. It is still a roadmap candidate.

    Regards,

    Adrian

    0
    Comment actions Permalink

Please sign in to leave a comment.



Powered by Zendesk