General purpose database within BizTalk

Question

In my BizTalk server, I would like to create custom orchestrations for fetching data from various sources such as REST APIs, SFTP folders, etc. I would like to store the parameters of the REST API requests or SFTP access requests in a DB and use them in the Orchestration when making the request. I am aware BizTalk has a built-in SQL Server. Does it have a DB that can be used for storing such parameters or reference data or metadata?

Answer 1

For this need, there are wo options

Option 1:

If you are dealing with only few values, you can add them to BTSNTSvc.exe.config and read your appSettings like a .Net config file

Option 2 :

Using SSO config. refer to Biztalk config in SSO