Business User onboards a Partner data by creating a Transaction.
Steps to create a Transaction:
- Click on Transactions > Templates.
- Click on Data Integration > Use This.
Enter name of the Transaction and Description.
Click Continue.
Info Use your first and last name initials to name the Transaction. Select “Create Transaction to be used by your Partner”.
Select Network and the Partner.
Click Next.
No changes needed here, click Next.
Select File Upload.
Click Next.
Select Convert option.
Click Next.
Trigger option is preselected as “On File Upload”.Click Next.
Select Excel and then click on (+) to create a new layout.
Provide name of the Excel layout, check Header Present, and select Import Definition File to upload and create a new layout as shown here.
Verify the data types and then click Save in the layout screen and then click Next.
Skip this step and click Next. Source file is not encrypted.
Select File (LAN) and click Next.
Click (+) to configure a new LAN File location and enter the values as shown in this screen. Use your first and last name initials for the target name.
Click Save on this activity and then click Next.
Select XML from the data format list.
Click (+) and create a new XML layout, upload a sample XML file to create the schema. Use first and last name initials to give the XML format name.
Save the XML layout and then click Next. In the next screen, skip the Encryption step and click Next and proceed to the Mapping step.
Click (+) and this will open a Mapping interface in a new browser tab.
Provide a name to this Mapping and click Create.
Map the Source fields to the related Target fields. Use drag and drop to connect source fields to target fields. Or use Mapping Expressions.
Click on the disk icon to save the Mapping. Once the Save is done, go to the previous browser tab.
Info Instructor walks-through how to apply Mapping functions such as String, Conditional and Loops. Instructor also shows the use of AI to auto-map the fields, Data Viewer to test Mapping output. Your new mapping now shows up in the Select Mapping field. Now click Save & Exit.
Click on “Yes, turn On” the transaction.
Click on Run Now and Upload the sample source file.
Go to Dashboards or click on Run History (listed as one of the options in the Transaction’s More menu) to see the status of the transaction.
Next step:
Business user views the Dashboard
| Panel | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
|
| Panel | ||||
|---|---|---|---|---|
| ||||
Business user views the Dashboard |