Click here to Skip to main content
14,167,095 members
Click here to Skip to main content
Add your own
alternative version

Tagged as


Posted 19 Aug 2011
Licenced CPOL

How to Use Enterprise Single Sign-On (SSO) Database to Store BizTalk Configuration Settings

, 19 Aug 2011
Rate this:
Please Sign up or sign in to vote.
How to use Enterprise Single Sign-On (SSO) database to store BizTalk Configuration settings


Traditionally, I have noticed that we use BTSNTSvc.exe.config to store various BizTalk configuration settings. Storing configuration information in files is hard to maintain, manage and modify. In this article, I would like to present a new and easier method to store configuration settings.

What is Enterprise Single Sign-On (SSO) Database?

BizTalk uses single sign on database for various purposes and to store its internal configuration information. It essentially consists of a credential database, a master secret server, and one or more Single Sign-On servers. For more information, refer to MSDN Reference.

How Do I Use SSO DB to Store BizTalk Configuration?

The basic idea is to create an application record in the table [SSODB].[dbo].[SSOX_ApplicationInfo].

Step 1: Install BizTalk Control Center (BCC)

BizTalk Control Center (BCC)

Step 2: Use Speedcode '502' to Create a New SSO Configuration Application (Click 'SSOConfiguration' tab)


Carefully spend time to edit the XML and define your configuration fields. Note that you can always add new items later.

NOTE: If you add new fields to an existing SSO application, the BCC system always drops and creates a new application. Always leave the <flags /> at their default values.


Step 3: Use Speedcode '211' to Check the Values Created for Your New Application


Step 4: (Optional) For Other Users to View your Application in Speedcode '211', the User must Add the SSO Application Name to their Profile.

Use speedcode '603' to make those changes.

How Do I Use SSO DB Values Within my BizTalk Orchestration?

Step 1: Create an Expression Shape

Add the code in step 2.

Step 2: Invoke Using the Following Line of Code

// Orchestration expression shape - expression
carMake = SsoConfigHelper.Instance.Read("MySampleApplication","CAR_MAKE");

Step 3: Use the Class SSOConfigHelper.cs from the Zip File

Points of Interest

  1. BizTalk Control Center (BCC) can be used to create and update SSO config values.
  2. SSOConfig helper class has the methods to access the values in the orchestration.



  • 19th August, 2011: Initial post


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Naveen Karamchetti
Architect AT&T Wi-Fi Services
United States United States
Naveen has done his Masters (M.S.) in Computer science, has started his career programming the mainframes and now has more than a decade of programming, development and design experience. Naveen has a sharp eye and keen observation skills. Naveen has worked for several companies and strived hard to build large scale business applications and bringing better solutions to the table.
Quite recently Naveen has built a fairly complex integration platform for a large bank. His hobbies include training, mentoring and research. Naveen spends his free time visiting National Parks nationwide.

Naveen has developed the BizTalk Control Center (BCC)

You may also be interested in...


Comments and Discussions

QuestionWhy a custom application for SSO? Pin
hedidin25-Aug-11 15:53
professionalhedidin25-Aug-11 15:53 
AnswerRe: Why a custom application for SSO? Pin
Naveen Karamchetti26-Aug-11 6:11
professionalNaveen Karamchetti26-Aug-11 6:11 
Can you answer the following questions

1. Is it possible to create/update SSO Affiliate application remotely?

This is a web based solution and can be created/updated remotely.
Always be there....| MCSD.NET | Sun Certified...

GeneralRe: Why a custom application for SSO? Pin
hedidin26-Aug-11 13:55
professionalhedidin26-Aug-11 13:55 
GeneralRe: Why a custom application for SSO? Pin
Naveen Karamchetti27-Aug-11 16:43
professionalNaveen Karamchetti27-Aug-11 16:43 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Cookies | Terms of Use | Mobile
Web05 | 2.8.190518.1 | Last Updated 19 Aug 2011
Article Copyright 2011 by Naveen Karamchetti
Everything else Copyright © CodeProject, 1999-2019
Layout: fixed | fluid