In my process, i need to get record from the SQL db in multiple places. So what is the best practice to get records from same DB multiple times? Either i need to use Connect activity in every place and pass the output of connect activity to the Execute Query activity?
Or shall i connect to DB in initSettings itself, and pass the Database connection to all the places i need? Which one is best practice?
If i follow the approach, connect to Bot DB in init Settings and pass the Database connection to ProcessTransaction, how long the Database connection should persist? Any possible to throw timeout issue??