Appronto

Requestor

• Customer: Meijer Potato
• Requestor: Arco Simonse

Required Approvals

Appronto will deploy the solution towards production as soon as all required approvals have been received from

• Customer: Sander Vermeer/Arco Simonse
• Appronto: Carlo Bloem

Screenshots of customer approvals:

Release type

This is a Major release.

Description of the changes

Meijer Potato wanted to integrate several IT systems and business processes. The integration processes are implemented with Boomi iPaaS. The systems includes Valence ERP ( replaces Agrio ), 3BM and Mendix. 

Deployment notes

Pre-requisites

• web services are created and accessible in Valence
• web services are created and accessible in Mendix

  
  

Pre-install steps

• None 

Undeployed processes

• None  

Deployed processes

Process versions before deployment

nvt

ProcessRoute versions before deployment

nvt

CustomerLibrary versions before deployment

nvt

Process versions after deployment

QI App related integration processes

Error Handler processes

CustomerLibrary versions before deployment

Solace Queues

Create/configure Queue/DMQ in Solace 

• #L-BaggingAssignment-MX_QI_APP-Valence-Process event
• L-BaggingAssignment-MX_QI_APP-Valence-Process event 
• #L-BaggingInstruction-Valence-MX_QI_APP-Process event  
• L-BaggingInstruction-Valence-MX_QI_APP-Process event 
• #L-Contact-MDH-MX_QI_APP-Process channel update 
• L-Contact-MDH-MX_QI_APP-Process channel update 
• #L-Contact-Valence-MDH-Process event 
• L-Contact-Valence-MDH-Process event 
• #L-Field-Valence-MX_QI_APP-Process event 
• L-Field-Valence-MX_QI_APP-Process event 
• #L-InspectionResult-MX_QI_APP-Valence-Process event 
• L-InspectionResult-MX_QI_APP-Valence-Process event 
• #L-Lot-Valence-MX_QI_APP-Process event 
• L-Lot-Valence-MX_QI_APP-Process event 
• #L-Variety-3BM-MDH-Process event 
• L-Variety-3BM-MDH-Process event
• #L-Variety-MDH-MX_QI_APP-Process channel update 
• L-Variety-MDH-MX_QI_APP-Process channel update 
• #L-Variety-MDH-VALENCE-Process channel update 
• L-Variety-MDH-VALENCE-Process channel update 
• #L-Variety-Valence-MDH-Process event 
• L-Variety-Valence-MDH-Process event 
• L-Solace-Retry-Send To Original Queue 

Post-install steps

1. Extensions:

     Connections:

• Valence
  • Connection URL --> https://valence.meijerpotato.com:11100/prd/service/boomi
  • Username --> boomisvc
  • Password --> <Stored in Lastpass>
• Solace PubSub+
  • Username --> boomi
  • Password --> <Stored in Lastpass>
  • Message VPN --> meijerpotato-prod
  • SMF Host --> tcps://meijerpotato-prod.messaging.solace.cloud:55443
• Mendix
  • Connection URL --> https://qi-app-prod.mendixcloud.com/rest/masterdata/v1
  • Username --> BoomiSA
  • Password --> <Stored in Lastpass>
  • Class Name --> com.microsoft.sqlserver.jdbc.SQLServerDriver
• 3BM
  • Connection URL --> jdbc:sqlserver://3bmsqlexternal.meijerpotato.com:1433;databaseName=DB_3002MEIJER
  • Username --> BoomiSA
  • Password --> <Stored in Lastpass>
  • Class Name --> com.microsoft.sqlserver.jdbc.SQLServerDriver
• 
  
• Master Data Management Hub
  • Connection URL --> https://c01-deu.hub.boomi.com/mdm/
  • Username --> meijerpotato-MRA6X2.UN8AZU
  • Password --> <Stored in MDH>

    Process Properties:

• 3BM
  • Boomi_Varieties View LastModifiedDate
    
    
• MDM
  • Use staging area
    
    
  • Force golden record update

    Scheduling:

MDH