How to map user profile to ECT field

Last week I encountered a problem related to External Content Type (ECT). I had a SQL table that contains article information: title, content and author. I wanted to search in that table using SharePoint 2016 search (on-prem). In order to do that I’ve created an External Content Type with above data, create content source and crawl it. Then I’ve mapped all crawled props to managed props in search. I was able to see articles data from SQL in my search results. 

Perfect? Not really…

Continue reading “How to map user profile to ECT field”