Linked Table vs Connecting to outside DB using JDBC and a Business Process (BPL)
I have a case where I need to look up the NPI provider against an External MS SQL database to retrieve our Provider Identifier to send to a downstream system. In the past I would use a Business Process (BPL) to connect to the outside MS SQL via JDBC and get that information for me. But I was thinking instead of creating a BPL process to do this, would it be better just to link to the outside MS SQL database table to retrieve the information in a SQL statement within a DTL?
So it is better to link to an outside database via a Linked Table wizard? or Use a BPL to retrieve the necessary data requirement?
What is the best practice to use?