Using Indirect Lookup relationship, we can relate Amazon DynamoDB External Object to Salesforce Object without using Salesforce Record Ids. We can relate the External Object to Salesforce Object using External Id field instead of Standard Id field.

In the following post, I have related Order(External Object) to Account(Standard Object) using Indirect Lookup relationship field with Account_Unique_Number__c custom field as the Target Field.

Steps:

1. Create a Custom External Id Field in Account Standard Object for Indirect Lookup Relationship.

2. Create Indirect Lookup Relationship field to Account object.

Sample Account Record with External Id Field Value:

Record in Amazon DynamoDB Table for Indirect Lookup:

Output: