Thanks to Rita Zhang:
After searching and testing, the following steps were needed to enable FAST search to crawl SQL contents using BCS and secure store:
• Add the search crawl account as an admininistrator on the BCS service application
• Give the search crawl account execute permission on the BCS models you want to index from the BCS service application
• Add the search crawl account to the Secure store application used by the BCS model
Original post: http://blogs.msdn.com/b/ritazh/archive/2012/08/23/enable-fast-search-to-crawl-sql-contents-using-bcs-and-secure-store.aspx
After searching and testing, the following steps were needed to enable FAST search to crawl SQL contents using BCS and secure store:
• Add the search crawl account as an admininistrator on the BCS service application
• Give the search crawl account execute permission on the BCS models you want to index from the BCS service application
• Add the search crawl account to the Secure store application used by the BCS model
Original post: http://blogs.msdn.com/b/ritazh/archive/2012/08/23/enable-fast-search-to-crawl-sql-contents-using-bcs-and-secure-store.aspx