Skip to Content
avatar image
Former Member

Validations in Data manager

Hi,

Can we use the validations created in Data manager while atomatic file import.

I have created a validation: IS_NULL(email, effective date email) OR IS_NOT_NULL(email, effective date email). i need to use this validation when file import automatically happens via MDIS. is it possible?

regards

Vinoth

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Dec 06, 2012 at 01:07 PM

    Hi Vinoth,

    Unlike Data Manager, Import Manager does not give you the option of writing validation or expressions for automatic file import vis MDIS..But you can try  configuration options for the import map that you have created. Please check configurations options under Import manager and try options that suits your requirement. I dont think you can write expression while importing file.

    Regards,

    Ali

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 06, 2012 at 01:31 PM

    Vinoth,

    Unfortunately, SAP MDM does not provide any functionality to execute validations/assignment during import process either via Import Manager or MDIS.

    Possible Workarounds:

    1. You can execute such kind of validation in PI/XI, if you have PI/XI in your landscape.

    2. You can run such kind of validation on any MDM field using MDM Java API, if you are importing your file via portal.

    3. You could try to validate the data before exporting from the source system.

    4. You can configure a workflow, which will execute the required validation, if you have limited records, as mentioned in above reply.

    Hope, it will help you..!!

    Thx/ -Tarun.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 06, 2012 at 01:04 PM

    Hi,

    You will have to use a workflow if you want to trigger the validation after importing via Import server, because the validations are not triggered during Import.

    Create a workflow in data manager and then refer that workflow in your Import map's configuration option. Assign this map to the automatic port.

    Now, when the import happens through MDIS, the workflow wil be triggered and the validations will be checked.

    regards,

    Prasad

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 07, 2012 at 06:11 AM

    Hi Vinoth,

    As correctly suggested in above posts, you need to create a workflow with trigger action as "Record Import" and execute validation or assignment through this workflow.

    This workflow will be triggered automatically on record import, only if you do the following configuration settings in Import Map:

    In Import Map, Configuration --> Options - for option Record Checkout/Workflows select the workflow you have designed. Then this workflow will be triggered whenever data is imported using this map(either by MDIS or manually) and which in turn will trigger the validation/assignment on the records imported.

    And yes, it might decrease the performance if there are too many records being imported frequently.

    Thanks and Regards,

    Ankush Bhardwaj

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 07, 2012 at 11:05 AM

    Hi experts,

    thanks for your reply. I will try it out and update soon.

    i have one more question, daily i'm importing minimum of 100 records to MDM. if i include validations in workflow, how will the system be affected?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Vinoth,

      As you are importing the data using XML file then it depends on the structure of your object schema. As much deep structured schema you will use, the more time MDIS will take to import.

      Let say, if you are importing two records of material master via one import map so technically, MDM will import X number of records.

      Here X is multiply of all nested segments records like MAKTM, MARCM, MBEW, MVKE etc.

      So, in your case if you are importing 100 records of material master per day via one import map then technically the triggered workflow count will be = 100 * number of records in all segments.

      Thx/ -Tarun