Resolution:
Description:
===========
How to create n unique_identifier for TIBCO BusinessEvents Database Concepts (DBConcepts) on a SQL Server database.

Environment:
===========
TIBCO BusinessEvents 3.x
All Operating Systems

Resolution:
=========

1). Create a stored procedure to build a unique sequence.

Example.:
------------------------------------------------
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

Create PROCEDURE [dbo].[MySequence2] @Sequence uniqueidentifier=null OUT
AS
Set @Sequence=newid()
------------------------------------------------

2). Create an XML file with the extension  .sequences.xml  and configure it as shown below. Add a unique_identifier element for each database concept that will acquire a primary key value using this mechanism.

XML sample file:
------------------------------------------------
<?xml version = "1.0" encoding = "UTF-8"?>

&ltunique_identifiers>  
    &ltunique_identifier entity = "/Concepts/master/dbo/SequenceTest" property = "UserID" stored_proc = "exec MySequence2 ?" unique_identifier = "sequence-name"/>
</unique_identifiers>
------------------------------------------------

3). Add the XML file to the project as a shared resource.

Note: Example attached (filename  DBConcept SQLServer Sequence generate.zip ).