65.9K
CodeProject is changing. Read more.
Home

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

starIconstarIconstarIconstarIconstarIcon

5.00/5 (1 vote)

Aug 19, 2011

CPOL

2 min read

viewsIcon

39131

downloadIcon

270

How to use Enterprise Single Sign-On (SSO) database to store BizTalk Configuration settings

Introduction

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)

BCC_502.JPG

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.

SSO_Config_XML.JPG

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

BCC_211.JPG

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.

Reference

History

  • 19th August, 2011: Initial post