Precisely Enterworks

 View Only

  • 1.  Export/Syndication to third party application

    Posted 05-28-2024 10:22

    We want to send data to a third party application.  In our repository the attribute Market can be "US,CA", "CA", or "US".  And same for our Brand attribute.  It could be "Chevy", "Ford", or "Both"

    So we could have a record like this:

    PartNumber: 1234   Market: US,CA    Brand: Both

    In the application we are syndicating to that one record in our system would be broken down into four records:

    PartNumber: 1234   Market: CA    Brand: Ford

    PartNumber: 1234   Market: CA    Brand: Chevy

    PartNumber: 1234   Market: US    Brand: Ford

    PartNumber: 1234   Market: US    Brand: Chevy

    How do we export in the format the other application needs converting our one record into four records?  What would be the best way to do this?

    Thank you



    ------------------------------
    Joseph McHugh
    MDM Solution Engineer
    Volvo IT North America
    NC
    ------------------------------


  • 2.  RE: Export/Syndication to third party application

    Employee
    Posted 06-04-2024 06:12

    Joseph,

    There are several options to addressing this in an export:

    1. Implement a Java Scheduled Export Post Processor to convert the data into multiple rows with the two repeating fields split in the possible combinations.
    2. Configure the SQL Publication Callout to perform the same kind of conversion on the publish table that is generated for the export and then used to create the file.  The SQL Stored procedure would insert rows and split the two repeating fields for all the defined combinations.
    3. Implement a View Scheduled Export that splits the data in the two attributes into separate rows.

    If you need more information on one or more of these options, please let me know.



    ------------------------------
    Brian Zupke
    Precisely Software Inc.
    ------------------------------

    Original Message