How to join between diffrent schema types in ECMA RRS feed

  • Question

  • Hello,

    I created MA for export data to SQL database using ECMA 2

    after creating two schema types one for getting all system accounts and one for getting permissions for each account (have attribute for account id)

    I need to make join between these two schema types to get row with complete data to insert in SQL

    for example :

    AccountID ,AccountName,AccountBankCode,PermissionID,PermissionName,UserName

    any idea how to make it


    Monday, November 6, 2017 10:29 AM

All replies

  • Hi!

    You cannot reach other connector space objects in the export. Only the ones that are getting exported.

    You could make a call to the mms_metaverse table to search for the values, but that is not best practice.


    Tuesday, November 7, 2017 10:13 PM