- This topic has 2 replies, 1 voice, and was last updated 9 years, 5 months ago by
.
-
Posts
-
-
Is there a way to extract the connection string from a config file for the database look up functoid?
Microsoft strongly suggest to use windows integrated security for database look up functoid. which user account it uses for the windows authenticaion? the account under which biztalk runtime runs?
Another option I have is to use a custom functoid to do the database lookup, and I can extract the connection string from config file in this case. But I am not sure performance wise this is a good option.
Really appreciate your sugestions
shan.
-
If you call your map from inside an Orchestration you can use a simple .net component to read the btsserv.exe.config file. Not real sure if that would work inside a pipeline – I think it would though.
As an alternative you could always use a .net component to read from a config file at a known location.
In any event, you’ll need to use a .net component inside a scripting function before the database functoid to read the value and pass it in.
Hope this helps.
-
I do agree with Stephen…but Is it safe working with Config files….or BTSNTSvcexe.config.
You are exposing your complete path to the database…or any sensitive username or password.
So its better to opt for SSODB ….where in data is encrypted.
Regards,
NISHIL
http://biztalkblogs.com/nishil/default.aspx
-
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.