BizTalkMgmtDB: All Table Details

BizTalkMgmtDB: All Table Details

Table of Contents

Introduction

BizTalk Management database (BizTalkMgmtDb) is also known as Configuration DB, which contains all related server and Application level configuration in single database.

This database is a central meta-information store for all instances of BizTalk Server. All the Administration, Performance based tunings will be happening in this Database.

Tables

Here is the List of 130 tables in BizTalkMgmtDb and brief note about those table:

S.No

Table Name

Details

1

adm_Adapter

List of All Adapters will be specified in Biztalk  administration Console.

2

adm_AdapterAlias

Alias of Adapters. Mode in which the alias communicates.

3

adm_BackupHistory

This table holds the most recent Back up history.Associated with the job 'Backup BizTalk Server’, which deletes the history.

4

adm_BackupSetId

Backup  set up ID which ll be used to delete the back up files.Settings defined for the backup jobs, databases etc.

5

adm_BackupSettings

This table holds the information about compression setting and to force a full backup.

6

adm_Group

Group table holds the list of databases which are associated with Biztalk Administration Group.

7

adm_GroupSetting

Here you can mention the cache refresh interval (PerfCounterCacheRefreshInterval) of biztalk. Default value is 60.

8

adm_Host

List of all hosts in biztalk.

9

adm_HostInstance

List of Host instances created per host will be available here.

10

adm_HostInstance_SubServices

Host instance can be said as a box which is hosting list of services like:

  • Caching-cache configuration for all the services
  • End Point Manager -End points are nothing but ports(pipeline + adapter) manager
  • Tracking- BAM/DTA
  • XLANG/s-Orchestration will be parsed by biztalk engine, in the form of XLANGS
  • MSMQT-MSMQ based transaction services

11

adm_HostInstanceSetting

Threads and Memory based property configuration will be set here for all the hostinstances.

12

adm_HostInstanceZombie

InFlight messages, which cannot be consumed after termination of  Orchestration is called zombies. The Zombies will be in the state of Suspended(Non-Resumable). These zombies will be present in this table.

13

adm_HostSetting

Throttling based setting for host will be lying in this configuration table.

14

adm_MessageBox

Messagebox DB's related to single Administration console will be configured here. Any number of Message box DB can be associated in this table with Master DB as 1.

15

adm_OtherBackupDatabases

As Name Indicates, all the other tracking/Message saving DB's will be accomodated in this table.

  • BAMAlertsApplication
  • BAMAlertsNSMain
  • BizTalkDTADb
  • BizTalkRuleEngineDb
  • SSODB

16

adm_OtherDatabases

This will also be holding same set of DB's as adm_OtherBackupDatabases by default.

  • BAMAlertsApplication
  • BAMAlertsNSMain
  • BizTalkDTADb
  • BizTalkRuleEngineDb
  • SSODB

17

adm_ReceiveHandler

In General, the adapter code runs in the Host of Biztalk. Handlers are instances of adapters. All the Receive handlers will be getting saved in this table.

18

adm_ReceiveLocation

All the receive location with Adapter ID and Handler will be associated in this table.

19

adm_SendHandler

In General, the adapter code runs in the Host of Biztalk. Handlers are instances of adapters. All the send handlers will be getting saved in this table.

20

adm_Server

The table adm_Server actually contains a list of all BizTalk Servers that are part of the BizTalk Group

21

adm_Server2HostMapping

Server mapped to host. Multi/Cluster server with associated hosts will be mapped in this table.



Creating multiple BizTalk hosts increases easiness the workload in your BizTalk group and is the primary means of distributing processing across the BizTalk Servers in a BizTalk group.

22

adm_ServiceClass

BizTalk Server uses a polling mechanism to receive messages from its host queues in the MessageBox. The MaxReceiveInterval value in the adm_ServiceClass table is the maximum value in milliseconds that each BizTalk host instance will wait until it polls the MessageBox. This table contains a record for the following service types:



  • Messaging InProcess
  • MSMQT
  • Messaging Isolated
  • XLANG/s

23

admv_BackupDatabases

List of Biztalk databases for back up will be listed.

  • BAMAlertsApplication
  • BAMAlertsNSMain
  • BAMPrimaryImport
  • BizTalkDTADb
  • BizTalkMgmtDb
  • BizTalkMsgBoxDb
  • BizTalkRuleEngineDb
  • SSODB

24

admv_LocalDate

This table has the updated Local date time.

25

admv_UTCDate

This table has the updated UTC date time.

26

adpl_sat

All the Biztalk Added Resource DLL's will be added to the CAB (Archive file format) and accommodated in this adpl_sat table. Whenever MSI file is being formed, it will pick up the assemblies from this table.

27

Agreement

EDI Transaction: Partner based Agreement details are present in this table.

28

AgreementAlias

Agreement with Protocol and key value details will be present in this table.

29

AS2ProtocolSettings

AS2 level details like encryption,certificate and others details are present in this table.

30

bam_ActivityToOrchestrationMapping

All the BAM-Orchestration related mapping will be registered in this table.Orchestration Service ID with Activity ID is saved in this table

31

bam_TrackingProfiles

.BTT Tracking Profile Configuration will be saved in this table. This will be pulled at the time of run time to track the data in the corresponding BAM Tracking tables

32

bam_TrackPoints

Defines the track points for TPE to track the data in BAM.

33

bas_Properties

This table is used for Business Activity Services (BAS).

34

BatchDescription

EDI batching details are being recorded in this table.

35

BizTalkDBVersion

This table holds the information about the Biztalk Management DB.

36

bt_DocumentSpec

This table holds all the schema details like Message Type, Assembly version, Promoted Properties, context properties..etc.,

37

bt_MapSpec

This holds all the map information like inbound schema name and outbound schema name.

38

bt_Properties

This Table holds the details of the Property schema with Message type and other property xpath details.

39

bt_SensitiveProperties

All the password information for the handlers will be specified here in this table.

40

bt_XMLShare

Full schema content will present in this table with message type and schema ID.

41

bt_XMLShareReferences

All the referenced target namespace of a schema is listed in this table. XMLShare and XMLShareReferences tables are inter related.

42

btf_message_receiver

To verify the acknowledgements received by the messages(Reliable messaging Framework based).

43

btf_message_sender

To verify the acknowledgements sent by the messages(Reliable messaging Framework based).

44

bts_application

All the application in BAC will be having an entry in this table.

45

bts_application_reference

Actual and Referred application relation will be handled in this table

46

bts_assembly

Biztalk Assembly details which is in the Resource section of BAC will be listed here

47

bts_component

All the pipeline components (located in


C:\Program Files (x86)\Microsoft BizTalk Server 2010\Pipeline Components\) will be listed in this table.

48

bts_dynamicport_subids

All the Dynamic send port details of an application is listed in this table.

49

bts_enlistedparty

All the only-enlisted parties listed in parties section of BAC is available.

50

bts_enlistedparty_operation_mapping

party and its operations are being listed here.

51

bts_enlistedparty_port_mapping

Table to list Port mapping with parties.

52

bts_item

All artifactsSchema,Maps,pipeline,etc) related to application is listed in this table

53

bts_itemreference

Referenced items like Biztalk class DLL's, data types are referred in this table.

54

bts_libreference

It holds the library reference for the Item reference table.

55

bts_messagetype

All the Message types irrespective of application in an Biztalk Administration console is listed here.

56

bts_messagetype_part

All Multipart Message type details will be listed in this table.

57

bts_operation_msgtype

MessageType, MessageType_Part,Opertation_msgtype tables are related to each other.

58

bts_orchestration

Contains all the Orchestration details in BAC.

59

bts_orchestration_invocation

List out the Invocation(order) details of an orchestration

60

bts_orchestration_port

All the port details associated with the Biztalk Orchestration is related in this table.

61

bts_orchestration_port_binding

Port binding related information available in this table

62

bts_party

All the only-enlisted parties listed in parties section of BAC is available.

63

bts_party_alias

Multiple party alias names for a party is available in this table.

64

bts_party_alias_old

Old party alias details will be listed in this table.

65

bts_party_old

Old party details will be listed in this table.

66

bts_party_sendport

party send port configured details will be listed in this table.

67

bts_party_sendport_old

unused/Old party send port configured details will be listed in this table.

68

bts_pipeline

All the pipeline details will be present in this table.

69

bts_pipeline_config

Pipeline relations with Stage and Sequence details are prescribed here.

70

bts_pipeline_stage

Stage Name(PreAssemble/Disassemble/Encode) details are provided for each pipeline in this table.

71

bts_port_activation_operation

Port Activation details.

72

bts_porttype

Orchestration based port specific types are listed here.

73

bts_porttype_operation

Operation of ports to which it is bounded.

74

bts_receiveport

List of Receive ports in Biztalk Console is listed here.

75

bts_receiveport_transform

Inbound maps applied at the receive ports will be available here.

76

bts_role

Roles which are associated with Role Links are referenced here.

77

bts_role_porttype

Send/Receive port type associated with Role link.

78

bts_rolelink

Role link created in biztalk Administration console is listed here.

79

bts_rolelink_type

Role link types created in orchestration is listed here.

80

bts_sendport

List of Send ports in Biztalk Console is listed here.

81

bts_sendport_transform

Outbound maps applied at the send ports will be available here.

82

bts_sendport_transport

holds the send port transport details(3-File 1-HTTP., etc) with address.

83

bts_sendportgroup

sendport group details are accomodated in this table.

84

bts_spg_sendport

Send ports associated with send port groups are listed in this table.

85

bts_stage_config

Lists common pipeline stage ID's for pre assemble,disassemble etc.

86

btsmon_Inconsistancies

This table is related biztalk monitoring data storage. After running btsmon_Inconsistancies job, it inturns invoke btsmon_GenerateErrorString and populate the error strings in BTSMon tables.

87

btsmon_Issues

It has the description of the issues that can be detected after running the job btsmon_Inconsistancies.

88  BusinessIdentity Qualifier Identifiers for EDI transactions are recorded in this table.
 89  BusinessProfile Business Profiles per partner will be defined in this table.
 90  Contact Contact details of agreement will be present in this table.

93

edi_DbConfig

Details of EDI specific DB details will be accommodated in this table.

94

EDIFACTEnvelopeOverrides

All EDIFACT related schema,message,protocol,validation details are present in these EDIFACT* tables

95

EDIFACTMessageFilterList

96

EDIFACTProtocolSettings

97

EDIFACTSchemaOverrides

98

EDIFACTValidationOverrides

99

EDIX12ST01GS01Mapping

A Transaction set for EDI X12 groups ST01 and GS01 is being listed in this table.

100

FallbackSettings

In EDIFACT/X12 transaction, When Biztalk doesn’t able to determine the agreement for the incoming message, Fallback settings, the properties in this table is getting applied to handle those messages.

101

MarkLog

This table is filled by the Backup BizTalk Server job,Mark is created across all DBs involved in backup so restores can be done in a transactionally consistent state. 

102

OnewayAgreement

Agreement details with Sender and Receiver ID and protocol settings value is mentioned in this table.

103

OnewayAgreementSendPortReference

Agreement which is referenced to send ports are mentioned in this table.

104

PAM_Batching_Log

EDI based PAM(Partner Agreement Manager) batching logs will be listed in this table.

105

PAM_Control

EDI based PAM message details will be tracked in this table.

106

Partner

All partner data will be recorded in this table.

107

Partnership

Partner details with PARTNER A and PARTNER B is mentioned in this table.

108

ProtocolSettings

Protocol Details for each partner/agreement is mentioned in this table.

109

SendPortReference

Party based send port reference details are recorded here.

110

StaticTrackingInfo

Static Tracking details for orchestration are listed in this table.

111

TDDS_CustomFormats

TDDS(Tracking Data Decode Service). This table holds the list of decoder classes which is responsible for tracking.

112

TDDS_Destinations

Holds the Destinations as BizTalkDTADB-Health Monitor and BAMPrimaryImport-Business Monitoring.

113

TDDS_Heartbeats

The coordination of tracking messages across the hosts are carried out with the help of this table.If any failover happens while tracking, it will manage the load to avoid loss of data.

114

TDDS_Services

Server  name hosted with TDDS service is listed here.

115

TDDS_Settings

TDDS settings such as refresh interval, command time out, retry count, etc are carried out in this table.

116

TDDS_Sources

The Data Source from which the data is migrated. BizTalkMsgBoxDB is configured as a source.

118

Trackinginterceptor

Tracking Interceptor dll's/Assembly info is present in this table.

119

TrackinginterceptorVersions

Versions of Tracking Interceptor DLL's are present in this table.

120

X12EnvelopesOverrides

All X12 related schema,message,protocol,validation details are present in these X12* tables.

121

X12MessageFilterList

122

X12ProtocolSettings

123

X12SchemaOverrides

124

X12ValidationOverrides

125

xref_AppInstance

Cross Referencing Tables


In order to dynamically cross reference identifiers between two different systems,The data will be loaded into cross reference table of biztalk.All 9 Xref_* tables are related to cross referenced tables. Importing data into these tables are BizTalk Server Cross Reference Import tool (btsxrefimport.exe) and retrieving the values of cross Reference messages are done through Cross-Referencing Functoids.


These tables will be used to retrieve the values of Format Message,ApplicationID,Application Value,Common ID, Common Value etc

126

xref_AppType

127

xref_IDXRef

128

xref_IDXRefData

129

xref_MessageArgument

130

xref_MessageDef

131

xref_MessageText

132

xref_ValueXRef

133

xref_ValueXRefData

Hope this helps...!

See Also

Read suggested related topics:

Another important place to find a huge amount of BizTalk related articles is the TechNet Wiki itself. The best entry point is BizTalk Server Resources on the TechNet Wiki