What is the best configuration storage

When you start a new project with BizTalk, a repetitive question appears : where can I store my configuration?

Three methods exist let’s analyze those :

In the btsntsvc.exe.config file

Advantages

  • it’s very easy to create.
  • No need of a new class
  • All windows administrator know how to modify it

Inconveniences

  • If you have a BizTalk farm, you must duplicate the key
  • it’s difficult too maintain in farm environment
  • When adding a new key, or changing a value, you need to restart the hosts
  • Risk of mal-formed config file

In a SQL DataBase

Advantages

  • In farm environment, you have only one configuration place to modify
  • It’s very customizable, you can have a key with a filter field

Inconveniences

  • For load problem, you need to implemente a singleton
  • You need to create your own backup solution
  • If the dataBase is down, your BizTalk server is down too

In a SSO Application

Advantages

  • In farm environment, you have only one configuration place to modify
  • When BizTalk is up, SSO is up too
  • You can crypt data like password
  • When updating data it’s not necessary to restart hosts
  • SSO ensures the security

Inconveniences

  • Not easy to start with
  • Need to be implemented in a singleton

Conclusion

All solutions are good solutions but depends on the case, on a little environment with only one server config file is good enough.

But in a larger environment you can implemente your own solution but implement a SSO application is better.

In a further article, I will explain how to implement it

Publicités

Laisser un commentaire

Choisissez une méthode de connexion pour poster votre commentaire:

Logo WordPress.com

Vous commentez à l'aide de votre compte WordPress.com. Déconnexion / Changer )

Image Twitter

Vous commentez à l'aide de votre compte Twitter. Déconnexion / Changer )

Photo Facebook

Vous commentez à l'aide de votre compte Facebook. Déconnexion / Changer )

Photo Google+

Vous commentez à l'aide de votre compte Google+. Déconnexion / Changer )

Connexion à %s