From ICIHelp8.1
Jump to: navigation, search
 
(8 intermediate revisions by 2 users not shown)
Line 2: Line 2:
 
= Generic Integration Framework to Support ASB Interface =
 
= Generic Integration Framework to Support ASB Interface =
  
Azure Service Bus (ASB) is a fully managed enterprise integration message broker. Data is transferred between different applications and services using messages. The ICM-ASB adapter considers the approach based on REST and OData principles that exposes a uniform, stateless interface which communicates using HTTP(S) and JSON payloads.
+
Azure Service Bus (ASB) is a fully managed enterprise integration message broker. Data is transferred between different applications and services using messages. The ICI-ASB adapter considers the approach based on REST and OData principles that exposes a uniform, stateless interface which communicates using HTTP(S) and JSON payloads.
  
 
== Configuring ASB adapter to load Masterdata  ==
 
== Configuring ASB adapter to load Masterdata  ==
  
The ICM support for generic integration provides the ability to synchronize ICM Masterdata tables using the input from ASB. Through a technical configuration, you can specify the attributes to be used for this generic integration.
+
The ICI support for generic integration provides the ability to synchronize ICI Masterdata tables using the input from ASB. Through a technical configuration, you can specify the attributes to be used for this generic integration.
  
 
=== Create Masterdata Contract Type ===
 
=== Create Masterdata Contract Type ===
  
To enable synchronization between ICM and ASB, a Masterdata Contract Type should first be configured in ICM, with specific attributes for the integration. To create a Masterdata Contract Type:
+
To enable synchronization between ICI and ASB, a Masterdata Contract Type should first be configured in ICI, with specific attributes for the integration. To create a Masterdata Contract Type:
  
#'''Click '''''Create Contract Type'' sub menu from the ''Configuration ''tile. The ''Select Contract Type'' page opens.  
+
1. '''Click '''Contract Type  menu from the Configure tile. The Contract Type details page opens. '''Click '''the "Create" button.
<div class="image-green-border">[[File:Generic Integration Framework ASB 01.png|620px|Generic Integration Framework ASB 01.png]]</div> <ol start="2">
+
<div class="image-green-border">[[File:Configure Contract Types.png|720px]]</div>  
<li>'''Select''' ''Masterdata''.</li>
+
2.&nbsp;'''Select''' Masterdata radio button.
</ol>
+
<div class="image-green-border">[[File:Contract Type MasterData.png|720px]]</div>  
<div class="image-green-border">[[File:Generic Integration Framework ASB 02.png|420px|Generic Integration Framework ASB 02.png]]</div> <ol start="3">
+
3.&nbsp;The Create Contract Type page opens.&nbsp; The Create Contract Type page has the following sections:
<li>'''Click '''the ''Next ''button. The ''Create Contract Type Wizard'' page opens.</li>
+
</ol>
+
<div class="image-green-border">[[File:Generic Integration Framework SFTP 03.png|520px|Generic Integration Framework SFTP 03.png]]</div> <ol start="3">
+
<li>The ''Create Contract Type ''page has the following sections:</li>
+
</ol>
+
  
*Details: Enter the ''Contract Type Name''
+
*Details: Enter the Contract Type Name  
 
*Attributes: Select the Attributes for the Masterdata Contract Type  
 
*Attributes: Select the Attributes for the Masterdata Contract Type  
 
*Display Preference: Select Attributes to be displayed in the Agreement Tile View  
 
*Display Preference: Select Attributes to be displayed in the Agreement Tile View  
 
*Team: Select the Team  
 
*Team: Select the Team  
*Verify: Verify the details in preview mode and '''click&nbsp;'''''Create.''
+
*Verify: Verify the details in preview mode and '''click&nbsp;'''Create.  
 
+
<div class="image-green-border">[[File:Create MasterData Contract Type Details.png|600px]]</div> <div class="image-green-border">&nbsp;</div>
 
=== Client App Cross Reference ===
 
=== Client App Cross Reference ===
  
The Client App Cross Reference mapping maps ICM entities (for example, ICM attributes) to client app entities.
+
The Client App Cross Reference mapping maps ICI entities (for example, ICI attributes) to client app entities.
  
#Navigate to the ''Create Masterdata'' page in ICM. This page contains the following tabs:  
+
#Navigate to the Create Masterdata page in ICI. This page contains the following tabs:  
<div class="image-green-border">[[File:Generic Integration Framework ASB 04.png|520px|Generic Integration Framework ASB 04.png]]</div>  
+
<div class="image-green-border">[[File:GIF 4.png|600px|GIF 4.png]]</div> <div class="image-green-border">&nbsp;</div>  
 
==== Masterdata Details ====
 
==== Masterdata Details ====
  
1.&nbsp;&nbsp; &nbsp;Select the ''Category ''from the drop-down. For example, ''Default''.<br/> 2.&nbsp;&nbsp; &nbsp;Select the Masterdata Contract Type.
+
1.&nbsp;&nbsp; &nbsp;Select the Category from the drop-down. For example, Default.<br/> 2.&nbsp;&nbsp; &nbsp;Select the Masterdata Contract Type.
<div class="note-box">'''Note''': In order to map ICM entities with entities in the file uploaded through ASB, you must select ''Client App Cross Reference'' from the drop-down.</div>  
+
<div class="note-box">'''Note''': In order to map ICI entities with entities in the file uploaded through ASB, you must select Client App Cross Reference from the drop-down.</div>  
3.&nbsp;&nbsp; &nbsp;Click ''Next''. The ''Attributes ''page opens.
+
3.&nbsp;&nbsp; &nbsp;Click Next. The Attributes page opens.
  
 
==== Attributes ====
 
==== Attributes ====
  
#Enter the relevant attribute values. For example, enter ''ICM Entity Name'' as ''ICMSupplierMaster'' and ''Client Entity Name'' as ''SupplierMaster''. The ''Payload Type'' can be selected as ''JSON''.  
+
1. Enter the relevant attribute values. For example, enter ICI Entity Name as ICISupplierMaster and Client Entity Name as SupplierMaster. The Payload Type can be selected as JSON.
<div class="note-box">'''Note''': The ''Client Name'' ''GenericIntegration'' must be selected. To create mapping using ASB, select ''Messaging'' in the ''Integration Mode'' drop-down. You need to select a ''Task Category for Messaging'', either ''Scheduled'' or ''EventBased'' as required.</div> <ol start="2">
+
<div class="note-box">'''Note''': The Client Name GenerICIntegration must be selected. To create mapping using ASB, select Messaging in the Integration Mode drop-down. You need to select a Task Category for Messaging, either Scheduled or EventBased as required.</div>  
<li>'''Click '''''Save'' to save the entity mapping.</li>
+
2.&nbsp;'''Click '''Save to save the entity mapping.
</ol>
+
<div class="image-green-border">[[File:GIF 5.png|600px|GIF 5.png]]</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">[[File:GIF 6.png|600px|GIF 6.png]]</div> <div class="image-green-border">&nbsp;</div>  
<div class="image-green-border">[[File:Generic Integration Framework ASB 05.png|520px|Generic Integration Framework ASB 05.png]]</div>  
+
 
=== Client App Entity Mapping ===
 
=== Client App Entity Mapping ===
  
The Client App Entity Mapping maps ICM attributes (for example, attribute names used in Supplier Master) to attributes in the file uploaded through ASB.
+
The Client App Entity Mapping maps ICI attributes (for example, attribute names used in Supplier Master) to attributes in the file uploaded through ASB.
  
#Navigate to the''Create Masterdata'' page in ICM. This page contains the following tabs:  
+
1. Navigate to theCreate Masterdata page in ICI. This page contains the following tabs:
<div class="image-green-border">[[File:Generic Integration Framework ASB 06.png|520px|Generic Integration Framework ASB 06.png]]</div>  
+
<div class="image-green-border">[[File:GIF 7.png|600px|GIF 7.png]]</div> <div class="image-green-border">&nbsp;</div>  
 
==== Masterdata Details ====
 
==== Masterdata Details ====
  
#Select the ''Category ''from the drop-down. For example, ''Default''.  
+
1. Select the Category from the drop-down. For example, Default.
#Select the Masterdata Contract Type.  
+
 
<div class="note-box">'''Note''': In order to map ICM attributes with attributes uploaded through ASB, ''Client App Entity Mapping'' must be selected from the drop-down.</div> <ol start="3">
+
2. Select the Masterdata Contract Type.
<li>Click ''Next''. The ''Attributes'' page opens.</li>
+
<div class="note-box">'''Note''': In order to map ICI attributes with attributes uploaded through ASB, Client App Entity Mapping must be selected from the drop-down.</div>  
</ol>
+
3. Click Next. The Attributes page opens.
  
 
==== Attributes ====
 
==== Attributes ====
  
#'''Enter''' the relevant attribute values. For example, enter ''ICM Entity Name'' as ''ICMSupplierMaster'' and ''Client Entity Name'' as ''SupplierMaster''.&nbsp;  
+
1.&nbsp;'''Enter''' the relevant attribute values. For example, enter ICI&nbsp;Entity Name as ICISupplierMaster and Client Entity Name as SupplierMaster.&nbsp;
  
To create mapping using ASB, select ''Messaging'' in the ''Integration Mode'' drop-down. The ''Client Name'' selected must be ''GenericIntegration''.
+
To create mapping using ASB, select Messaging in the Integration Mode drop-down. The Client Name selected must be GenerICIntegration.
  
In case of lookup and non-lookup attributes: The ICM Relationship Key should be set for lookup attributes and kept blank for non-lookup attributes. The Relationship Key framing should be <''Master Contract Type Name''> Double Underscore<''ICM Attribute Name''>. For example, in case of Supplier Master the ICM attribute name will be ''ICMSupplierCountry'' and the Masterdata Contract Type for this attribute will be ''ICMCountryMaster''. Hence, relationship key will be ''ICMCountryMaster__ICMSupplierCountry.''
+
In case of lookup and non-lookup attributes: The ICI Relationship Key should be set for lookup attributes and kept blank for non-lookup attributes. The Relationship Key framing should be <Master Contract Type Name> Double Underscore<ICI Attribute Name>. For example, in case of Supplier Master the ICI attribute name will be ICISupplierCountry and the Masterdata Contract Type for this attribute will be ICICountryMaster. Hence, relationship key will be ICICountryMaster__ICISupplierCountry.
<ol start="2">
+
<li>'''Click '''''Save'' to save the entity mapping.</li>
+
</ol>
+
<div class="image-green-border">[[File:Generic Integration Framework ASB 07.png|720px|Generic Integration Framework ASB 07.png]]</div>
+
  
 +
2.&nbsp;'''Click&nbsp;&nbsp;'''CREATE&nbsp; to save the entity mapping.
 +
<div class="image-green-border">[[File:GIF 8.png|600px|GIF 8.png]]</div>
 
== Using ASB Adapter to load/publish Masterdata ==
 
== Using ASB Adapter to load/publish Masterdata ==
  
 
=== Download Payload ===
 
=== Download Payload ===
  
#Navigate to the Masterdata page in ICM.
+
1. Navigate to the Masterdata page in ICI.
#'''Click''' the ''View Record'' icon next to the ''Client App Cross Reference'' entity you have created. The ''Masterdata Details'' page opens.
+
<div class="image-green-border">[[File:Generic Integration Framework ASB 08.png|720px|Generic Integration Framework ASB 08.png]]</div> <ol start="3">
+
<li>Click the ''Download Payload'' button to download a template for the Masterdata.</li>
+
</ol>
+
  
'''Note''': The file format of the template will be according to the ''Payload Type'' selected in the attributes of the ''Client App Cross Reference'' entity.
+
2.&nbsp;'''Click''' the View Record icon next to the Client App Cross Reference entity you have created. The Masterdata Details page opens.
<div class="image-green-border">[[File:Generic Integration Framework ASB 09.png|720px|Generic Integration Framework ASB 09.png]]</div> <ol start="4">
+
<div class="image-green-border">[[File:GIF 9.png|600px|GIF 9.png]]</div> <div class="image-green-border">&nbsp;</div>
<li>Open the downloaded JSON file. This file will be used by third-party systems to push data to the ASB adapter.</li>
+
3. Click the DOWNLOAD PAYLOAD&nbsp; button to download a template for the Masterdata.
</ol>
+
<div class="note-box">'''Note''': The file format of the template will be according to the Payload Type selected in the attributes of the Client App Cross Reference entity.</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">[[File:GIF 10.png|600px|GIF 10.png]]</div>  
 +
4. Open the downloaded JSON file. This file will be used by third-party systems to push data to the ASB adapter.
  
 
For Scheduled updation:
 
For Scheduled updation:
 
<div class="image-green-border">[[File:Generic Integration Framework ASB 10.png|520px|Generic Integration Framework ASB 10.png]]</div>  
 
<div class="image-green-border">[[File:Generic Integration Framework ASB 10.png|520px|Generic Integration Framework ASB 10.png]]</div>  
<br/> For EventBased updation:
+
For EventBased updation:
 
<div class="image-green-border">[[File:Generic Integration Framework ASB 11.png|520px|Generic Integration Framework ASB 11.png]]</div>  
 
<div class="image-green-border">[[File:Generic Integration Framework ASB 11.png|520px|Generic Integration Framework ASB 11.png]]</div>  
 
=== Publish Payload ===
 
=== Publish Payload ===
<ol start="5">
+
 
<li>'''Click''' ''Publish Payload.'' The file will be published.</li>
+
5.&nbsp;'''Click'''&nbsp;PUBLISH&nbsp; PAYLOAD&nbsp;The file will be published.
</ol>
+
<div class="note-box">'''Note''': For any subsequent Masterdata changes, the user needs to click Publish Payload button again to update the empty payload.</div>  
<div class="note-box">'''Note''': For any subsequent ''Masterdata'' changes, the user needs to click ''Publish Payload'' button again to update the empty payload.</div>  
+
 
A notification is displayed once the Payload is published successfully.
 
A notification is displayed once the Payload is published successfully.
<div class="image-green-border">[[File:Generic Integration Framework ASB 12.png|720px|Generic Integration Framework ASB 12.png]]</div> <div class="image-green-border">&nbsp;</div> <div class="note-box">'''Note''': The user can create a subscription to the job status updates by using the standard in ''Notification Setting'' in the ''User Administration'' menu.</div>  
+
<div class="image-green-border">[[File:GIF 11.png|600px|GIF 11.png]]</div> <div class="image-green-border">&nbsp;</div> <div class="note-box">'''Note''': The user can create a subscription to the job status updates by using the standard in Notification Setting in the User Administration menu.</div>  
 
== Using ASB Adapter to load/publish Transaction Data&nbsp; ==
 
== Using ASB Adapter to load/publish Transaction Data&nbsp; ==
  
=== Updating Transaction Data – Outbound ===
+
=== Updating Transaction Data&nbsp; ===
  
To update transaction data from ICM using generic integration framework:
+
To update transaction data from ICI using generic integration framework:
  
#'''Edit''' the agreement in ICM with the desired values.
+
1.&nbsp;'''Edit''' the agreement in ICI with the desired values.
#'''Click''' ''Update''.
+
 
+
'''Note''': For transaction data outbound, it is mandatory to select ''Data Flow Type'' as ''ICM to Client'' in the Client App Entity Mapping. The workflow action selected in ''Publish Transaction Data'' in Client App Cross Reference Mapping is the event at which transaction data will be updated. For example, if the values selected in this field are ''Approved ''and ''Updated'', then the transaction data will be updated when these actions are taken on the agreement.
+
  
 +
2.&nbsp;'''Click''' Update.
 +
<div class="note-box">'''Note''': For transaction data outbound, it is mandatory to select Data Flow Type as ICI to Client in the Client App Entity Mapping. The workflow action selected in Publish Transaction Data in Client App Cross Reference Mapping is the event at which transaction data will be updated. For example, if the values selected in this field are Approved and Updated, then the transaction data will be updated when these actions are taken on the agreement.</div>
 
==== Checking Data in Service Bus Explorer ====
 
==== Checking Data in Service Bus Explorer ====
  
 
To validate the data in the Service Bus Explorer:
 
To validate the data in the Service Bus Explorer:
  
#'''Open''' Service Bus Explorer and go to the ''Service Bus Namespace''.  
+
1.&nbsp;'''Open''' Service Bus Explorer and go to the Service Bus Namespace.
#Go to the genericintegrationoutbound topic. Right-click and '''select '''''Refresh Subscription'' from the drop-down.  
+
 
#'''Click '''''Messages''. The ''Retrieve messages from subscription'' window opens.  
+
2. Go to the generICIntegrationoutbound topic. Right-click and '''select '''Refresh Subscription from the drop-down.
#'''Select '''''Peek ''radio button in the ''Receive Mode'' section.  
+
 
#'''Click '''''Ok''.  
+
3.&nbsp;'''Click '''Messages. The Retrieve messages from subscription window opens.
 +
 
 +
4.&nbsp;'''Select '''Peek radio button in the Receive Mode section.
 +
 
 +
5.&nbsp;'''Click '''Ok.
 +
<div class="image-green-border">[[File:7.12 ASB adapter.png|720px|7.12 ASB adapter.png]]</div>
 +
The updated values are displayed in the Message Text.
  
The updated values are displayed in the ''Message Text''.
+
6. Check the Notifications Dashboard in ICI to view the success, failure and update notifications for outbound transaction data.
<ol start="6">
+
<li>Check the ''Notifications Dashboard'' in ICM to view the success, failure and update notifications for outbound transaction data.</li>
+
</ol>
+
  
 
The same steps can be followed to create: &nbsp;
 
The same steps can be followed to create: &nbsp;
Line 132: Line 122:
 
*Amendments with Associations - Outbound  
 
*Amendments with Associations - Outbound  
  
&nbsp;
+
'''Related Topics:'''&nbsp;[[Agreement_Management|Agreement Management]]&nbsp;|&nbsp;[[Integrations|Integrations]]&nbsp;|&nbsp;[[Legal_and_Compliance|Salesforce]]&nbsp;| [[Using_Adobe_Sign|Using Adobe Sign]] | [[Using_DocuSign|Using DocuSign]] | [[Using_Namirial_eSignAnywhere|Using Namirial eSignAnyWhere]]&nbsp;| [[Generic_Integration_Framework_to_Support_SFTP_Interface|Generic Integration Framework to Support SFTP&nbsp;Interface]]&nbsp;|&nbsp;[[Release_Notes|Release_Notes]]&nbsp;|

Latest revision as of 14:11, 16 February 2022

Generic Integration Framework to Support ASB Interface

Azure Service Bus (ASB) is a fully managed enterprise integration message broker. Data is transferred between different applications and services using messages. The ICI-ASB adapter considers the approach based on REST and OData principles that exposes a uniform, stateless interface which communicates using HTTP(S) and JSON payloads.

Configuring ASB adapter to load Masterdata 

The ICI support for generic integration provides the ability to synchronize ICI Masterdata tables using the input from ASB. Through a technical configuration, you can specify the attributes to be used for this generic integration.

Create Masterdata Contract Type

To enable synchronization between ICI and ASB, a Masterdata Contract Type should first be configured in ICI, with specific attributes for the integration. To create a Masterdata Contract Type:

1. Click Contract Type  menu from the Configure tile. The Contract Type details page opens. Click the "Create" button.

Configure Contract Types.png

2. Select Masterdata radio button.

Contract Type MasterData.png

3. The Create Contract Type page opens.  The Create Contract Type page has the following sections:

  • Details: Enter the Contract Type Name
  • Attributes: Select the Attributes for the Masterdata Contract Type
  • Display Preference: Select Attributes to be displayed in the Agreement Tile View
  • Team: Select the Team
  • Verify: Verify the details in preview mode and click Create.
Create MasterData Contract Type Details.png
 

Client App Cross Reference

The Client App Cross Reference mapping maps ICI entities (for example, ICI attributes) to client app entities.

  1. Navigate to the Create Masterdata page in ICI. This page contains the following tabs:
GIF 4.png
 

Masterdata Details

1.    Select the Category from the drop-down. For example, Default.
2.    Select the Masterdata Contract Type.

Note: In order to map ICI entities with entities in the file uploaded through ASB, you must select Client App Cross Reference from the drop-down.

3.    Click Next. The Attributes page opens.

Attributes

1. Enter the relevant attribute values. For example, enter ICI Entity Name as ICISupplierMaster and Client Entity Name as SupplierMaster. The Payload Type can be selected as JSON.

Note: The Client Name GenerICIntegration must be selected. To create mapping using ASB, select Messaging in the Integration Mode drop-down. You need to select a Task Category for Messaging, either Scheduled or EventBased as required.

2. Click Save to save the entity mapping.

GIF 5.png
 
GIF 6.png
 

Client App Entity Mapping

The Client App Entity Mapping maps ICI attributes (for example, attribute names used in Supplier Master) to attributes in the file uploaded through ASB.

1. Navigate to theCreate Masterdata page in ICI. This page contains the following tabs:

GIF 7.png
 

Masterdata Details

1. Select the Category from the drop-down. For example, Default.

2. Select the Masterdata Contract Type.

Note: In order to map ICI attributes with attributes uploaded through ASB, Client App Entity Mapping must be selected from the drop-down.

3. Click Next. The Attributes page opens.

Attributes

1. Enter the relevant attribute values. For example, enter ICI Entity Name as ICISupplierMaster and Client Entity Name as SupplierMaster. 

To create mapping using ASB, select Messaging in the Integration Mode drop-down. The Client Name selected must be GenerICIntegration.

In case of lookup and non-lookup attributes: The ICI Relationship Key should be set for lookup attributes and kept blank for non-lookup attributes. The Relationship Key framing should be <Master Contract Type Name> Double Underscore<ICI Attribute Name>. For example, in case of Supplier Master the ICI attribute name will be ICISupplierCountry and the Masterdata Contract Type for this attribute will be ICICountryMaster. Hence, relationship key will be ICICountryMaster__ICISupplierCountry.

2. Click  CREATE  to save the entity mapping.

GIF 8.png

Using ASB Adapter to load/publish Masterdata

Download Payload

1. Navigate to the Masterdata page in ICI.

2. Click the View Record icon next to the Client App Cross Reference entity you have created. The Masterdata Details page opens.

GIF 9.png
 

3. Click the DOWNLOAD PAYLOAD  button to download a template for the Masterdata.

Note: The file format of the template will be according to the Payload Type selected in the attributes of the Client App Cross Reference entity.
 
GIF 10.png

4. Open the downloaded JSON file. This file will be used by third-party systems to push data to the ASB adapter.

For Scheduled updation:

Generic Integration Framework ASB 10.png

For EventBased updation:

Generic Integration Framework ASB 11.png

Publish Payload

5. Click PUBLISH  PAYLOAD The file will be published.

Note: For any subsequent Masterdata changes, the user needs to click Publish Payload button again to update the empty payload.

A notification is displayed once the Payload is published successfully.

GIF 11.png
 
Note: The user can create a subscription to the job status updates by using the standard in Notification Setting in the User Administration menu.

Using ASB Adapter to load/publish Transaction Data 

Updating Transaction Data 

To update transaction data from ICI using generic integration framework:

1. Edit the agreement in ICI with the desired values.

2. Click Update.

Note: For transaction data outbound, it is mandatory to select Data Flow Type as ICI to Client in the Client App Entity Mapping. The workflow action selected in Publish Transaction Data in Client App Cross Reference Mapping is the event at which transaction data will be updated. For example, if the values selected in this field are Approved and Updated, then the transaction data will be updated when these actions are taken on the agreement.

Checking Data in Service Bus Explorer

To validate the data in the Service Bus Explorer:

1. Open Service Bus Explorer and go to the Service Bus Namespace.

2. Go to the generICIntegrationoutbound topic. Right-click and select Refresh Subscription from the drop-down.

3. Click Messages. The Retrieve messages from subscription window opens.

4. Select Peek radio button in the Receive Mode section.

5. Click Ok.

7.12 ASB adapter.png

The updated values are displayed in the Message Text.

6. Check the Notifications Dashboard in ICI to view the success, failure and update notifications for outbound transaction data.

The same steps can be followed to create:  

  • Contract Requests with Associations - Inbound
  • Associations for Agreements - Inbound
  • Amendments with Associations - Outbound

Related Topics: Agreement Management | Integrations | Salesforce | Using Adobe Sign | Using DocuSign | Using Namirial eSignAnyWhere | Generic Integration Framework to Support SFTP Interface | Release_Notes |