BizTalk 2004

Welcome to my site! Please explore and learn about me and my pursuits!

Would you like to be on my E-mail list? Learn More!

BizTalk 2004 Hints

Links:

Here are some hints on using custom security in HAT (Health and Activity Tracking)

STEP 1: Create a new Windows User (call it 'test')

STEP 2: Create a new Windows Group (call it 'BizTalkTest')

STEP 3: Add the Windows User to the new Windows Group

STEP 4: Add the new Windows Group to SQL Logins

STEP 5: Create a role in the following Databases BTS_LACKEY_USERS (query)

BizTalkDTADb
BTS

STEP 6: Add the BizTalkTest group to the BTS_LACKEY_USERS role

STEP 7: Add the BizTalkTest group as a user to the above databases in STEP 5

STEP 8: Set the role permissions per the following table:

(You can learn each of these by using SQL Profiler and using a newly created user that has no permissions).

REPORTING:		Database	SQL Object Type	SQL Object Name	Permission
query	Find Message:	BizTalkDTADb	SP	adm_Query_BizTalkDBVersion	exec
		BizTalkMgmtDb	SP	trk_HatGetConfig	exec
		BizTalkMgmtDb	SP	trk_HatGetHostList	exec
query	Find Message (selecting a schema):	BizTalkDTADb	SP	dtasp_GetSchemaNames	exec
		BizTalkDTADb	SP	dtasp_GetMessageFieldNamesBySchemaName	exec
		BizTalkDTADb	SP	dtasp_GetPartyNamesBySchemaName	exec
query	Find Message (Running the query):	BizTalkDTADb	TB	dta_MessageInOutEvents	select
query	Query Builder:	BizTalkDTADb	SP	adm_Query_BizTalkDbVersion	exec
		BizTalkMgmtDb	SP	trk_HatGetConfig	exec
		BizTalkMgmtDb	SP	trk_HatGetHostList	exec
		BizTalkDTADb	SP	dtasp_GetCubeNames	exec
		BizTalkDTADb	TB	dta_Items	select
		BizTalkDTADb	V	dtav_ServiceFacts	select
	Service Metrics:
	Message Metrics:
query	EDI Reports:	BizTalkEDIDb	TB	audin	select
OPERATIONS:
query	Service Instances:	BizTalkDTADb	SP	adm_Query_BizTalkDbVersion	exec
		BizTalkDTADb	SP	trk_HatGetConfig	exec
		BizTalkDTADb	SP	trk_HatGetHostList	exec
		BizTalkDTADb	SP	MBOM_GetOrchestrationTypes	exec
		BizTalkDTADb	SP	MBOM_GetSendPortTransports	exec
		BizTalkDTADb	SP	MBOM_GetReceiveTransports	exec
query	Messages:	BizTalkDTADb	SP	adm_Query_BizTalkVersion	exec
		BizTalkDTADb	SP	trk_HatGetConfig	exec
		BizTalkDTADb	SP	trk_HatGetHostList	exec
		BizTalkDTADb	SP	MBOM_GetOrchestrationTypes	exec
		BizTalkDTADb	SP	MBOM_GetSendPortTransports	exec
		BizTalkDTADb	SP	MBOM_GetReceiveTransports	exec
CONFIGURATION:
query	Pipelines:	BizTalkDTADb	SP	adm_Query_BizTalkDbVersion	exec
		BizTalkDTADb	SP	trk_HatGetConfig	exec
		BizTalkDTADb	SP	trk_HatGetHostList	exec
		BizTalkMgmtDb	SP	admdta_GetServices	exec
query	Pipelines (Updating):	BizTalkMgmtDb	SP	bts_GetStaticTrackingInfo	exec
		BizTalkMgmtDb	SP	bts_InsertStaticTrackingInfo	exec
	Orchestrations:
query	Orchestrations (Updating):	BizTalkMgmtDb	SP	bt_LoadPropertyInfoByNamespace	exec
		BizTalkMsgBoxDb	SP	bts_InsertProperty	exec
		BizTalkMsgBoxDb	SP	bts_FindSubscriptions	exec
		BizTalkMsgBoxDb	SP	bts_InsertMessage	exec
query	Policies:	BizTalkRuleEngineDb	SP	re_getrulesetsdeploymentconfig	exec
query	Policies (Updating):	BizTalkRuleEngineDb	SP	re_updaterulesettc	exec
query	Message Properties:	BizTalkMgmtDb	SP	admdta_GetSchemaRoots	exec
		BizTalkMgmtDb	SP	admdta_GetSchemaRootsProperties	exec
query	Message Properites( Updating ):	BizTalkMgmtDb	SP	admdta_GetSchemaRootProperties	exec
		BizTalkMgmtDb	SP	admdta_SetSchemaRootTrackAllProperty	exec
		BizTalkMgmtDb	SP	admdta_SetSchemaTrackIndividualProperies	exec
QUERIES:
	You can customize the queries that show on this tab by adding/editing the files located in C:\Program Files\Microsoft BizTalk Server 2004\Tracking\Queries. Example of one of these files is shown to the right:	Copy one of the files, then change the /ArrayOfAnyType/anyType[1] node value to a different name.	Reopen HAT and you will see your new query.	Obviously the queries will pull from tables in the various BizTalk databases. You will need to assign select permissions to those databases.	select