Spectrum Technology Platform

 View Only
  • 1.  How do I add constraints to Data Models?

    Posted 03-22-2019 10:05
    Hello to all Spectrum enthusiasts.

    Is it possible to add property existence constraints for entities and relations in the Relationship Analysis Client?

    BR
    Max

    ------------------------------
    Maximilian Zurek
    ADWEKO Consulting GmbH
    Walldorf/Baden
    ------------------------------


  • 2.  RE: How do I add constraints to Data Models?

    Employee
    Posted 03-25-2019 09:00
    Hi Max,

    Can you give a couple examples of what type of constraints you are looking for?

    ------------------------------
    Jason Brown
    PITNEY BOWES SOFTWARE, INC
    Maitland FL
    ------------------------------



  • 3.  RE: How do I add constraints to Data Models?

    Posted 03-25-2019 09:48
    Hi Jason.

    E.g. I modelled a entity "Person" in the Relation Ship Analysis Client with the following properties: "first name" (string), "last name" (string) and "birthday" (date). The first name should be a required property for the entity. The Persons and relationships between the Persons will be created in data flowes. If the first name of a Person is not provided in the Input, the entity should not be created. 
    If I write a Neo4j data model in Cypher, I can simply add the constrains to the code.
    But how do I manage that in Spectrum? 
    I do not want to check the existence of required fields the data flows.
    Except there is no other option.

    BR
    Max

    ------------------------------
    Maximilian Zurek
    ADWEKO Consulting GmbH
    Walldorf/Baden
    ------------------------------



  • 4.  RE: How do I add constraints to Data Models?

    Employee
    Posted 03-28-2019 11:43
    Hi Max,

    We do not currently support adding these constraints per property in the Data Hub module, so the logic would need to be built into the dataflow. I can add an enhancement request for this feature.

    ------------------------------
    Luke Daugherty
    Knowledge Community Shared Account
    Shelton CT
    ------------------------------



  • 5.  RE: How do I add constraints to Data Models?

    Posted 04-01-2019 04:19
    Hi Luke.
    That would be great!

    ------------------------------
    Maximilian Zurek
    ADWEKO Consulting GmbH
    Walldorf/Baden
    ------------------------------