exporting data to a database - tibco software to a sql... · 4 exporting to a sql database tibco...

Exporting to a SQL Database

TM

Software Release 9.5.2October 2015

TIBCO Nimbus

Important Information

TIBCO Nimbus Exporting to a SQL Database

SOME TIBCO SOFTWARE EMBEDS OR BUNDLES OTHER TIBCO SOFTWARE. USE OF SUCH EMBEDDED OR BUNDLED TIBCO

SOFTWARE IS SOLELY TO ENABLE THE FUNCTIONALITY (OR PROVIDE LIMITED ADD-ON FUNCTIONALITY) OF THE LICENSED

TIBCO SOFTWARE. THE EMBEDDED OR BUNDLED SOFTWARE IS NOT LICENSED TO BE USED OR ACCESSED BY ANY OTHER

TIBCO SOFTWARE OR FOR ANY OTHER PURPOSE.

USE OF TIBCO SOFTWARE AND THIS DOCUMENT IS SUBJECT TO THE TERMS AND CONDITIONS OF A LICENSE AGREEMENT

FOUND IN EITHER A SEPARATELY EXECUTED SOFTWARE LICENSE AGREEMENT, OR, IF THERE IS NO SUCH SEPARATE

AGREEMENT, THE CLICKWRAP END USER LICENSE AGREEMENT WHICH IS DISPLAYED DURING DOWNLOAD OR INSTALLATION OF

THE SOFTWARE (AND WHICH IS DUPLICATED IN THE LICENSE FILE) OR IF THERE IS NO SUCH SOFTWARE LICENSE AGREEMENT

OR CLICKWRAP END USER LICENSE AGREEMENT, THE LICENSE(S) LOCATED IN THE LICENSE FILE(S) OF THE SOFTWARE. USE OF

THIS DOCUMENT IS SUBJECT TO THOSE TERMS AND CONDITIONS, AND YOUR USE HEREOF SHALL CONSTITUTE ACCEPTANCE OF

AND AN AGREEMENT TO BE BOUND BY THE SAME.

This document contains confidential information that is subject to U.S. and international copyright law s and treaties. No part of this

document may be reproduced in any form w ithout the w ritten authorization of TIBCO Softw are Inc.

TIBCO, Tw o-Second Advantage and TIBCO Nimbus are either registered trademarks or trademarks of TIBCO Softw are Inc. in the

United States and/or other countries.

All other product and company names and marks mentioned in this document are the property of their respective ow ners and are

mentioned for identif ication purposes only.

THIS SOFTWARE MAY BE AVAILABLE ON MULTIPLE OPERATING SYSTEMS. HOWEVER, NOT ALL OPERATING SYSTEM

PLATFORMS FOR A SPECIFIC SOFTWARE VERSION ARE RELEASED AT THE SAME TIME. SEE THE RELEASE NOTE FOR THE

AVAILABILITY OF THIS SOFTWARE VERSION ON A SPECIFIC OPERATING SYSTEM PLATFORM.

THIS DOCUMENT IS PROVIDED AS IS WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, BUT NOT

LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NON-INFRINGEMENT.

THIS DOCUMENT COULD INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS. CHANGES ARE PERIODICALLY

ADDED TO THE INFORMATION HEREIN; THESE CHANGES WILL BE INCORPORATED IN NEW EDITIONS OF THIS DOCUMENT. TIBCO

SOFTWARE INC. MAY MAKE IMPROVEMENTS AND/OR CHANGES IN THE PRODUCT(S) AND/OR THE PROGRAM(S) DESCRIBED IN

THIS DOCUMENT AT ANY TIME.

THE CONTENTS OF THIS DOCUMENT MAY BE MODIFIED AND/OR QUALIFIED, DIRECTLY OR INDIRECTLY, BY OTHER

DOCUMENTATION WHICH ACCOMPANIES THIS SOFTWARE, INCLUDING BUT NOT LIMITED TO ANY RELEASE NOTES AND "READ

ME" FILES.

Copyright © 1997-2015 TIBCO Softw are Inc. ALL RIGHTS RESERVED.

TIBCO Softw are Inc. Confidential Information

3Contents


Table of Contents

......................................................................................................................... 4Introduction

......................................................................................................................... 5Exporting Data to a Database

......................................................................................................................... 7Table Information

......................................................................................................................... 25Entity Relationships

4 Exporting to a SQL Database


Introduction

The data held within a Nimbus process repository can be exported via the Data Export Utility and representedin a SQL database. This facilitates advanced reporting and data analysis (via tools such as TIBCO Spotfire oreven Nimbus metric links). It also facilitates the sharing of data between other process tools. Informationflow is one-way, meaning that any changes made to the data in a SQL database will not be reflected in TIBCONimbus, and data will also be replaced in the SQL database whenever an export is run.

Note: This document is aimed at database administrators with a good working knowledge of databases.

Usage Guidelines

The data export operation will create a series of tables in the target SQL server database. These tables arecreated with temporary name prefixes and renamed once the operation has completed, therefore it is notadvisable to construct any SQL queries until the operation has finished. It is also advisable not to interactwith the database until the export has finished in order to prevent any table contention issues with the dataexport utility.

It is important to know that when the TIBCO Nimbus Data Export utility is run, it will make extensive readoperations against the process repository for the duration of the export operation. This will have a significantimpact on the performance of the Nimbus system. The operation can last from a few minutes to a number ofhours, depending on the scope and amount of data that is being exported and the hardware specifications ofthe servers hosting the process repository and the SQL database. It is therefore advised to schedule theoperation to be run at off-peak times or, preferably, against a backup of the repository to minimize the impacton a live process repository. See the TIBCO Nimbus Administration Guide for information on creating backups.

5Exporting to a SQL Database


Exporting Data to a Database

The utility can be run as a scheduled task or it can be run manually. It is advised that the utility is runovernight, or when few users are logged into the system.

To manually export data from a Process Repository

1. Run CtrlDataExport.exe (...\TIBCO Nimbus\Client\Utilities).2. Click Browse to select the Process Repository that you want to export from, then click Next.

Note: If you have previously saved a settings file click Load to select and open it.

3. Enter the user name and password of a TIBCO Nimbus administrator, then click Next.

Database4. In the Database tab specify the details of the database to export to.

Specify or select a SQL Server Instance - either choose a SQL Server from the list or manually enter theSQL Server that you are exporting to.

Note: Click Refresh to update the list of servers.

Choose one of the following options:Use Windows Integrated SecurityIf Windows Integrated Authentication (WIA) is enabled then select this option to allow authorizedusers to run the utility.

Use a specific user name and passwordSpecify a user name and password to user whenever the utility is run.

Note: Both options will require the user to have access to the SQL server. Click Test Connectionto test the credentials against the SQL server.

Specify a new or select an existing Database - either choose a SQL database to export to from the drop-down list (to populate the list from the selected server click Refresh), or manually enter the SQLdatabase.

Export Options5. In the Export Options tab, select what data to export from the following:

Process MapsAll Process Maps exports all process maps in the process repository, including masters, drafts andscenarios.Selected Maps Only allows you to select which maps to export (click Select Maps to select themaps that you want to export).

Statement Sets

Statement Sets Only will export statement set data (not including statement link data).Statement Sets and Links exports statement set data and statement link data.

Other Items

Export Documents exports document data.Export Storyboards exports storyboard data.Export Keywords exports keyword data.



Export Scorecards exports scorecard data.

Export Actions

Exports all action data. Note that actions may be related to process content, such as diagrams,statement sets, storyboards, etc. These items must also be selected for export if you want toexport actions related to these items.

Governance Data

Exports review, authorization, acknowledgement, change request and memo data. Note thatgovernance data will only be exported for the other options that are selected (for example, toexport governance data for documents, you must include also documents in the export options.

Advanced

The Advanced tab allows you to select external scripts and commands to run on the data after it has beenexported.

6. Specify any external scripts or commands to run:

External SQL ScriptsChoose a folder that contains any SQL scripts that you want to run on the exported data. SQLscripts will be run in alphabetical order.

External CommandRun an external command (.exe, .js, .vbs, .bat or .cmd) after any selected SQL scripts have beenrun. Either enter a command or executable (including the file path) in the Command to run field,

or click to select an executable. You can also specify arguments and set a timeout for theutility to terminate if the script fails to return a value or stops working (set the timeout to '0' for notimeout limit).

OptionsYou can also set the SQL Command Timeout to '0' for no timeout limit.

7. Click Export Now.

Note: You can save these settings so that they can be loaded in future sessions. Settings files will besaved as <filename>.CtrlDatExp. The settings file can also be used to run the utility from acommand-line prompt and when running an automated Windows Scheduled Task.

Scheduling

Exporting data to a database can be run from the command line, or as a Windows Scheduled Task. Run thefollowing command:

<Location of Database Export Utility> <Settings File> <Path to Process Repository>For example:

"C:\TIBCO Nimbus\Client\Utilities\CtrlDataExport.exe" "C:\TIBCONimbus\Client\Utilities\Settings.CtrlDatExp" "C:\TIBCO Nimbus\Process Repository"

A log file is generated in the same location as where the utility is run from.



Table Information

The information below describes the data that can be exported from a TIBCO Nimbus Process Repository to aSQL database and provides a brief description of the table data.

Column Data Type Description

AcknowledgementRequestSignOffsID INT Unique identifier of recordAcknowledgementRequestID

INT Associated acknowledgement request

UserID INT UserAcknowledged BIT If the record has been acknowledged or notSignOffDate DATETIME Date and time when the acknowledgement request was

signed off

AcknowledgementRequestsID INT Unique identifier of recordRequestedByID INT User that requested the acknowledgementRequestedDate DATETIME Date when acknowledgement was requestedDueDate DATETIME Date when acknowledgement request is dueCompletionDate DATETIME Date when acknowledgement request was completedContinuous BIT Continuous or single acknowledgement request

ActionAssigneeStatusesID INT Unique identifier of recordName CHAR Name of action statusDescription CHAR Description of action statusType CHAR Type of action status

ActionAssigneesID INT Unique identifier of recordActionID INT Associated action recordUserID INT User assigned as assignee to action

ActionAttachmentsID INT Unique identifier of recordActionID INT Associated action recordAttachmentID INT Associated action attachment record

ActionCategoriesID INT Unique identifier of recordName CHAR Name of action categoryDescription CHAR Description of action categoryAllowMultipleSignOff BIT Allow associated action records to be signed off in

multiple batch operation

ActionCommentsID INT Unique identifier of recordUserID INT User that made the commentsActionID INT Associated action recordDateTime DATETIME Date and time comment was madeComment CHAR Description of comment

ActionEditors




ID INT Unique identifier of recordActionID INT Unique identifier of action recordUserID INT Unique identifier of userGroupID INT Unique identifier of user

ActionOwnerStatusesID INT Unique identifier of recordName CHAR Name of action owner statusDescription CHAR Description of action owner statusType CHAR Type of action owner status

ActionViewersID INT Unique identifier of recordActionID INT Associated action recordUserID INT User assigned as action viewerGroupID INT User group assigned as action viewer

ActionsID INT Unique identifier of recordSubject CHAR Subject of action recordOwnerID INT Owner of action recordCreated DATETIME Date and time action record createdCategoryID INT Category of action recordHostType CHAR Type of action (general, statement set, diagram,

document, metric)ActionOwnerStatusID INT Status of action ownerDueDate DATETIME Due date of action recordTimezone CHAR Time zone of action recordStartDate DATETIME Start date of action recordFinished DATETIME Date and time when action was completedPriority CHAR Priority of action recordRequiresOneAssigneeToComplete

BIT Determines whether action record can be completed by oneassignee

HostInfo CHAR Description of action host

AssigneeActionsID INT Unique identifier of recordActionID INT Associated action recordActionAssigneeStatusID INT Status of assignee action recordUserID INT User assigned as action assignee

AttachmentAccessRightsID INT Unique identifier of recordAttachmentID INT Associated attachment recordUserID INT UserGroupID INT User groupAccessLevel CHAR Level of access rights for user or user group

AttachmentsID INT Unique identifier of recordAttachmentType CHAR Type of attachmentTitle CHAR Name of attachmentURL CHAR URL of attachment (if URL)DocumentID INT Document (if document)DefaultAccessRights CHAR Default access rights for user and user groups




AuthorizationRequestSignOffsID INT Unique identifier of recordAuthorizationRequestID INT Associated authorization requestUserID INT AuthorizerCompleted BIT Completed/Not CompletedAccepted BIT AcceptedSignOffDate DATETIME Date when authorization request signed offAuthorizationReason CHAR User reason for authorizationComments CHAR User-added commentsActiveState INT To-Do item exists or not.

AuthorizationRequestsID INT Unique identifier of recordRequestedDate DATETIME Date request sentRequestedByID INT User that requested authorizationRequestText CHAR Notes added to authorization requestDueDate DATETIME Date and time authorization request sign off due byCompletionDate DATETIME Date and time authorization request completed

BusinessControlsID INT Unique identifier of recordName CHAR Name of business controlBusinessControlType CHAR Business control type (field value in data table

attachment, statement link, field value in statementlink data table or field value in statement data table)

StatementSetName CHAR Statement set nameStatementName CHAR Statement nameDataTableName CHAR Data table nameDataTableField CHAR Data table field nameDataTableValue CHAR Data table value

CategoryApplicableAssigneeStatusesID INT Unique identifier of recordCategoryID INT Category assignee statusActionAssigneeStatusID INT Associated assignee status

CategoryApplicableOwnerStatusesID INT Unique identifier of recordCategoryID INT Associated categoryActionOwnerStatusID INT Associated action owner status

ChangeRequestAttachmentsID INT Unique identifier of recordChangeRequestID INT Associated change requestAttachmentID INT Associated attachment

ChangeRequestHistoryLogID INT Unique identifier of recordChangeRequestID INT Associated change requestUserID INT User associated with recordDate DATETIME Date log createdVersion CHAR Version of log recordStatus CHAR Status of log record

ChangeRequestNotes




ID INT Unique identifier of recordChangeRequestID INT Associated change requestAuthorID INT Associated authorParentNoteID INT Associated parent note recordCreated DATETIME Date and time notes createdRef CHAR User referenceTitle CHAR Title of change request notesComments CHAR Description of change request notes

ChangeRequestsID INT Unique identifier of recordAuthorID INT AuthorOwnerID INT OwnerRef CHAR ReferenceCreated DATETIME Date and time createdUserReference CHAR User referenceAuditReference CHAR Audit referenceNotesAboutLinks CHAR Link notesStatus CHAR Status of change request

DevicesID INT Unique identifier of recordUserID INT User associated with deviceRegisteredDate DATETIME Date and time device registeredDeviceType CHAR Type of deviceUniqueID CHAR Unique ID of deviceDeviceToken CHAR Token of deviceSubscribeDate DATETIME Date and time of subscription

DiagramAccessRightsID INT Unique identifier of recordDiagramID INT Associated diagramUserID INT Associated userGroupID INT Associated user groupAccessLevel CHAR Level of access rights

DiagramAcknowledgementLogID INT Unique identifier of recordDiagramID INT Associated diagramUserID INT Associated userDate DATETIME Date and time log createdVersion CHAR Version of log

DiagramAcknowledgementRequestsID INT Unique identifier of recordDiagramID INT Associated diagramAcknowledgementRequestID

INT Associated acknowledgement request record

DiagramAcknowledgersID INT Unique identifier of recordDiagramID INT Associated diagramUserID INT Associated userGroupID INT Associated user groupResourceID INT Associated resource

DiagramActionsID INT Unique identifier of recordActionID INT Associated action record




DiagramID INT Associated diagram

DiagramAuthorizationAuditHistoryLogID INT Unique identifier of recordDiagramID INT Associated diagramDate DATETIME Date and time log createdVersion CHAR Version of logUserName CHAR Associated userStatus CHAR Status of log recordAction CHAR Associated actionMapType CHAR Type of map (master, draft or scenario)Comments CHAR User-added comments

DiagramAuthorizationRequestsID INT Unique identifier of recordDiagramID INT Associated diagramAuthorizationRequestID INT Associated authorization record

DiagramAuthorizersID INT Unique identifier of recordDiagramID INT Associated diagramUserID INT Associated userGroupID INT Associated user groupResourceID INT Associated resourceSequence INT Sequence of authorizers

DiagramChangeLogID INT Unique identifier of recordDiagramID INT Associated diagramUserID INT Associated userVersion CHAR Version of change logDate DATETIME Date and time of change logChangeDescription CHAR Description of change

DiagramChangeRequestsID INT Unique identifier of recordDiagramID INT Associated diagramChangeRequestID INT Associated change request record

DiagramKeywordsID INT Unique identifier of recordDiagramID INT Associated diagramKeywordID INT Associated keyword

DiagramMemosID INT Unique identifier of recordDiagramID INT Associated diagramMemoID INT Associated memo

DiagramObjectAttachmentsID INT Unique identifier of recordDiagramObjectID INT Associated diagram objectAttachmentID INT Associated attachment record

DiagramObjectBusinessControlsID INT Unique identifier of recordDiagramObjectID INT Associated diagram objectBusinessControlID INT Associated business control record

DiagramObjectCostingValuesID INT Unique identifier of recordDiagramObjectID INT Associated diagram objectDuration FLOAT Duration of costing value




DurationUnits CHAR Units (Duration)Late FLOAT Late valueLateUnits CHAR Units (Late)Start DATETIME Start timeVolume FLOAT VolumeVolumeUnits CHAR Units (Volume)CustomVolumeCost FLOAT Custom cost of volumeOverrideCost FLOAT Override cost valueOverrideVolume BIT Override volume On or OffOverrideVolumeCost FLOAT Override volume cost valueOverrideVolumeDuration FLOAT Override volume duration valueOverrideFTE FLOAT Override FTE valueCompletionStatus CHAR Status of completion (Incomplete, complete or Ignore

Status)ActivityTimingInformation

CHAR Information about activity timing

FTE FLOAT FTE valueCost FLOAT Cost of activityVolumeCost FLOAT Volume costVolumeDuration FLOAT Volume duration

DiagramObjectMetricAttachmentsID INT Unique identifier of recordDiagramObjectID INT Associated diagram objectMetricAttachmentID INT Associated metric attachment

DiagramObjectResourcesID INT Unique identifier of recordDiagramObjectID INT Associated diagram objectResourceID INT Associated resourcePercent INT Percentage of resource allocation

DiagramObjectsID INT Unique identifier of recordDiagramID INT Associated diagramObjectGUID CHAR Unique GUID of diagram objectObjectType CHAR Type of object (free text, image, activity, flow line,

etc)ActivityID INT Associated activityText CHAR Object textHintText CHAR Object hint textCommentary CHAR Object commentaryLinkedDiagramID INT Linked diagramDiagramLinkHintText CHAR Hint text for linked diagramNotesBubbleText CHAR Object notes bubble textNotesBubbleHintText CHAR Object notes bubble hint textDrillDownHintText CHAR Hint text for drill down

DiagramObjectDrillDownsID INT Unique identifier of recordDiagramID INT Associated diagramDiagramObjectID INT Associated diagram object

DiagramPromotersID INT Unique identifier of recordDiagramID INT Associated diagramUserID INT User assigned as promoterGroupID INT User group assigned as promoter




DiagramReviewersID INT Unique identifier of recordDiagramID INT Associated diagramUserID INT User assigned as reviewerGroupID INT User group assigned as reviewer

DiagramReviewsID INT Unique identifier of recordDiagramID INT Associated diagramReviewID INT Associated review

DiagramsID INT Unique identifier of recordMapID INT Associated mapGUID CHAR Unique GUID of diagramParentID INT Parent diagramLevel CHAR Current diagram levelBPMN BIT If the diagram is a BPMN type diagramTitle CHAR Title of diagramOwnerID INT Owner of diagramAuthorID INT Author of diagramAuthorizationStatus CHAR Authorization statusVersion CHAR Version of diagramPreparationDate DATETIME Date and time diagram preparedPercentDone INT Percentage of diagram completedStatus CHAR Status of diagramModifiedDate DATETIME Date and time diagram last modifiedModifiedBy INT User that last modified diagramDiagramURL CHAR URL of diagram in the Web ServerDefaultAccessRights CHAR Default user diagram access rightsType CHAR Type of diagram (standard or variant)

DocumentAccessRightsID INT Unique identifier of recordDocumentID INT Associated documentUserID INT UserGroupID INT User groupAccessLevel CHAR Level of access for user or user group

DocumentAcknowledgementLogID INT Unique identifier of recordDocumentID INT Associated documentUserID INT UserDate DATETIME Date and time when user acknowledgedVersion CHAR

DocumentAcknowledgementRequestsID INT Unique identifier of recordDocumentID INT Associated documentAcknowledgementRequestID

INT Associated acknowledgement request record

DocumentAcknowledgersID INT Unique identifier of recordDocumentID INT Associated documentUserID INT UserGroupID INT User groupResourceID INT Resource

DocumentActions




ID INT Unique identifier of recordActionID INT Associated action recordDocumentID INT Associated document

DocumentAuthorizationAuditHistoryLogID INT Unique identifier of recordDocumentID INT Associated documentDate DATETIME Date and time audit history log createdVersion CHAR Version of audit history logUserName CHAR Name of userStatus CHAR Status of auditAction CHAR Associated actionDocType CHAR Type of documentComments CHAR User-added comments

DocumentAuthorizationRequestsID INT Unique identifier of recordDocumentID INT Associated documentAuthorizationRequestID INT Associated authorization record

DocumentAuthorizersID INT Unique identifier of record

DocumentID INT Associated documentUserID INT UserGroupID INT User groupResourceID INT ResourceSequence INT Sequence of authorizers

DocumentChangeLogID INT Unique identifier of recordDocumentID INT Associated documentUserID INT UserVersion CHAR Version of change logDate DATETIME Date and time of changeChangeDescription CHAR Description of change

DocumentChangeRequestsID INT Unique identifier of recordDocumentID INT Associated documentChangeRequestID INT Associated change request

DocumentControlledCopyHoldersID INT Unique identifier of recordDocumentID INT Associated documentUserName CHAR UserDateIssued DATETIME Date document issued to userDateReturned DATETIME Date document returned by user

DocumentKeywordsID INT Unique identifier of recordDocumentID INT Associated documentKeywordID INT Keyword

DocumentMemosID INT Unique identifier of recordDocumentID INT Associated documentMemoID INT Associated memo record

DocumentPromotersID INT Unique identifier of recordDocumentID INT Associated documentUserID INT User assigned as promoter




GroupID INT User group assigned as promoter

DocumentReviewersID INT Unique identifier of recordDocumentID INT Associated documentUserID INT User assigned as reviewerGroupID INT User group assigned as reviewer

DocumentReviewsID INT Unique identifier of recordDocumentID INT Associated documentReviewID INT Associated review record

DocumentsID INT Unique identifier of recordDocumentType CHAR Type of documentFileName CHAR Name of fileURL CHAR URL of document in Web ServerTitle CHAR Title of documentVersion CHAR Version of documentReleaseDate DATETIME Date document promoted and releasedDraftStatus CHAR Status of draft documentAuthorID INT Author of documentUserRef CHAR User referenceDate DATETIME Date document createdOwnerID INT Owner of documentLanguage CHAR Language of documentComment CHAR Document commentWithdrawn DATETIME Date document withdrawnAddedBy INT User that added document to Document RegistryAddedDate DATETIME Date document added to Document RegistryFilter1 CHAR Value of filter 1Filter2 CHAR Value of filter 2Filter3 CHAR Value of filter 3Filter4 CHAR Value of filter 4Filter5 CHAR Value of filter 5Filter6 CHAR Value of filter 6Filter7 CHAR Value of filter 7DefaultAccessRights CHAR Default user access rights for document

FavoriteDiagramsID INT Unique identifier of recordUserID INT UserGroupID INT User groupTitle CHAR Title of diagramDiagramID INT Associated diagram record

FavoriteDocumentsID INT Unique identifier of recordUserID INT UserGroupID INT User groupTitle CHAR Title of documentDocumentID INT Associated document recordDocumentPart CHAR Master or draft document version

FavoriteScorecardsID INT Unique identifier of recordUserID INT UserGroupID INT User groupTitle CHAR Title of scorecard




ScorecardID INT Associated scorecard record

FavoriteStoryboardsID INT Unique identifier of recordUserID INT UserGroupID INT User groupTitle CHAR Title of storyboardStoryboardID INT Associated storyboard recordStoryDetailsID INT Storyboard details

FlowlineAttachmentsID INT Unique identifier of recordFlowlineID INT Associated flow line recordAttachmentID INT Associated attachment record

FlowlineBusinessControlsID INT Unique identifier of recordFlowlineID INT Associated flow lineBusinessControlID INT Associated business control

FlowlineConnectionsID INT Unique identifier of recordSourceID INT Source object of flow line connectionDestID INT Destination object of flow line connection

FlowlineObjectMetricAttachmentsID INT Unique identifier of recordFlowlineID INT Associated flow line recordMetricAttachmentID INT Associated metric attachment record

FlowlinesID INT Unique identifier of recordDiagramID INT Associated diagram recordObjectGUID CHAR Associated object recordLineText CHAR Text of flow lineCommentaryText CHAR Commentary text of flow lineSourceObjectID INT Source object recordDestObjectID INT Destination object recordExternallyConnected BIT If the flow line is externally connectedCostingProbability REAL Costing probability valueCostingFeedbackIterations

INT Costing feedback iteration value

GroupRolesID INT Unique identifier of recordResourceID INT Resource associated with roleGroupID INT User group associated with role

GroupsGroupsID INT Unique identifier of recordParentGroupID INT Parent user groupChildGroupID INT Child user group

KeywordGroupsID INT Unique identifier of recordName CHAR Name of keyword group

KeywordsID INT Unique identifier of recordKeyword CHAR Name of keywordTibbrSubject CHAR tibbr subject text

KeywordsKeywordGroupsID INT Unique identifier of record




KeywordID INT Associated keywordKeywordGroupID INT Associated keyword group

MapAdministratorsID INT Unique identifier of recordMapID INT Associated mapUserID INT User assigned as map administratorGroupID INT User group assigned as map administrator

MapFolderAccessRightsID INT Unique identifier of recordMapFolderID INT Associated map folderUserID INT UserGroupID INT User groupAccessLevel CHAR Level of access rights for user or user group

MapFoldersID INT Unique identifier of recordName CHAR Name of map folderParentFolderID INT Name of parent folderDefaultAccessRights CHAR Default user access rights to map folder

MapPromotersID INT Unique identifier of recordMapID INT Associated mapUserID INT User assigned as map promoterGroupID INT User group assigned as map promoter

MapsID INT Unique identifier of recordName CHAR Name of mapMapPath CHAR Path to mapMapType CHAR Type of mapMapFolderID INT Associated map folder

MemosID INT Unique identifier of recordAuthorID INT User that created the feedbackDateTime DATETIME Date and time feedback createdTitle CHAR Subject of feedbackRef CHAR Reference of feedbackComments CHAR User commentsParentMemoID INT Parent feedback recordIsMaster BIT Whether the feedback is on the master recordVersion CHAR Version of diagram, document or storyboard

MetricActionsID INT Unique identifier of recordActionID INT Associated action recordMetricAttachmentID INT Associated metric attachment record

MetricAttachmentAccessRightsID INT Unique identifier of recordMetricAttachmentID INT Associated metric attachment recordUserID INT UserGroupID INT User groupAccessLevel CHAR Level of access for user or user group

MetricAttachmentsID INT Unique identifier of recordTitle CHAR Title of metric attachmentMetricType CHAR Type of metric link




Comments CHAR Comments about the metric attachmentOwnerID INT Owner of the metric attachmentMetricDefinition CHAR Definition of metric attachmentCurrentValue REAL Current value of metric attachmentDefaultAccessRights CHAR Default access rights of metric attachment

MetricHistoryID INT Unique identifier of recordMetricAttachmentID INT Associated metric attachment recordDateTime DATETIME Date and time metric attachment modifiedValue FLOAT Value of metric history log record

RelatedDocumentationID INT Unique identifier of recordDocumentID1 INT Related document 1DocumentID2 INT Related document 2

ResourceGroupMembersID INT Unique identifier of recordResourceGroupID INT Associated resource group recordResourceID INT Associated resource record

ResourceGroupsID INT Unique identifier of recordName CHAR Name of resource groupDescription CHAR Description of resource groupParentGroupID INT Parent resource group

ResourcesID INT Unique identifier of recordMapID INT Associated mapName CHAR Name of resourceDisplayName CHAR Display name of resourceInfo1 CHAR Information field 1Info2 CHAR Information field 2Cost FLOAT Cost of resourceCostUnit CHAR Unit of cost for resource

ReviewSignOffsID INT Unique identifier of recordReviewID INT Associated review recordUserID INT User assigned as reviewerSignOffDate DATETIME Date and time review signed offSignOffNotes CHAR Notes submitted by user when signing offReviewOutcome CHAR Outcome of the review

ReviewsID INT Unique identifier of recordRequestedDate DATETIME Date and time review requestedRequestedByUserID INT User that requested the reviewReviewRequestText CHAR Additional text entered by ownerDueDate DATETIME Time and date review is due to be completed byCompletionDate DATETIME Time and date review completed on

ScorecardAccessRightsID INT Unique identifier of recordScorecardID INT Associated scorecard recordUserID INT UserGroupID INT User groupAccessLevel CHAR Level of access for user or user group

ScorecardAttachments




ID INT Unique identifier of recordScorecardID INT Associated scorecard recordAttachmentID INT Associated attachment record

ScorecardFolderAccessRightsID INT Unique identifier of recordScorecardFolderID INT Associated scorecard folderUserID INT UserGroupID INT User groupAccessLevel CHAR Level of access for user or user group

ScorecardFoldersID INT Unique identifier of recordName CHAR Name of scorecard folderParentFolderID INT Parent scorecard folderDefaultAccessRights CHAR Default access rights on scorecard folder

ScorecardsID INT Unique identifier of recordScorecardFolderID INT Associated scorecard folderTitle CHAR Title of scorecardOwnerID INT Owner of scorecardDescription CHAR Description of scorecardURL CHAR URL of scorecard in Web ServerScorecardType CHAR Type of scorecardDefaultAccessRights CHAR Default access rights for scorecard

StatementActionsID INT Unique identifier of recordActionID INT Associated action recordStatementID INT Associated statement record

StatementAttachmentsID INT Unique identifier of recordStatementID INT Associated statement recordAttachmentID INT Associated attachment record

StatementAuditActionsID INT Unique identifier of recordActionID INT Associated action recordStatementAuditID INT Associated statement audit record

StatementAuditAttachmentsID INT Unique identifier of recordStatementAuditID INT Associated statement audit recordAttachmentID INT Associated attachment record

StatementAuditChangeLogID INT Unique identifier of recordStatementAuditID CHAR Associated statement audit recordUser INT UserDate DATETIME Date and time user modified scorecardChangeDescription CHAR Description of change made

StatementAuditManagersID INT Unique identifier of recordStatementSetID INT Associated statement set recordUserID INT User assigned as statement audit managerGroupID INT User group assigned as statement audit manager

StatementAuditsID INT Unique identifier of recordStatementID INT Associated statement




CreatedByID INT User that created the audit recordCreated DATETIME Date and time the audit record was createdStatus CHAR Status of the auditDescription CHAR Description of the audit

StatementChangeLogID INT Unique identifier of recordStatementID INT Associated statement recordUserID INT User that created the changeDate DATETIME Date and time the change was createdVersion CHAR Version of change logChangeDescription CHAR Description of change

StatementLinkActionsID INT Unique identifier of recordActionID INT Associated actionStatementLinkID INT Associated statement link

StatementLinkAuditActionsID INT Unique identifier of recordActionID INT Associated action recordStatementLinkAuditID INT Associated statement link audit record

StatementLinkAuditAttachmentsID INT Unique identifier of recordStatementLinkAuditID INT Associated statement link audit recordAttachmentID INT Associated attachment

StatementLinkAuditChangeLogID INT Unique identifier of recordStatementLinkAuditID INT Linked statement link audit recordUser CHAR User that created the change logDate DATETIME Date and time change madeChangeDescription CHAR Description of change

StatementLinkAuditsID INT Unique identifier of recordStatementLinkID INT Linked statement recordCreatedByID INT User that created the auditCreated DATETIME Time and date audit createdStatus CHAR Audit statusDescription CHAR Description of audit

StatementLinkChangeLogID INT Unique identifier of recordStatementLinkID INT Linked statementUser CHAR User associated with changeDate DATETIME Date and time change madeChangeDescription CHAR Description of change

StatementLinksID INT Unique identifier of recordDiagramObjectID INT Associated diagram objectStatementID INT Statement linked toHintText CHAR Hint text

StatementManagersID INT Unique identifier of recordStatementSetID INT Associated statement setUserID INT User assigned as statement managerGroupID INT User group assigned as statement manager

StatementSets




ID INT Unique identifier of recordName CHAR Name of statement setDescription CHAR Description of statement set

StatementTiesID INT Unique identifier of recordStatementID1 INT Statement 1 tieStatementID2 INT Statement 2 tie

StatementsID INT Unique identifier of recordStatementSetID INT Associated statement setNumber CHAR Number of statementName CHAR Name of statementDescription CHAR Description of statementStatus CHAR Status of statementStyle CHAR Style applied to statementParentStatementID INT Parent statement

StoryboardsID INT Unique identifier of recordOwnerID INT Owner of storyboardAuthorID INT Author of storyboardLastModified DATETIME Date when storyboard was last modifiedExpiryPeriod INT Date when storyboard expiresStoryboardFolderID INT Name of storyboard folder

StoryboardAccessRightsID INT Unique identifier of recordStoryDetailsID INT Details of storyboardUserID INT UserGroupID INT User groupAccessLevel CHAR Level of storyboard access for user or user group

StoryboardAcknowledgementRequestsID INT Unique identifier of recordStoryDetailsID INT Details of storyboardAcknowledgementRequestID

INT Associated acknowledgement request

StoryboardAcknowledgersID INT Unique identifier of recordStoryDetailsID INT Details of storyboardUserID INT User set as acknowledgerGroupID INT User group set as acknowledgerResourceID INT Resource

StoryboardActionsID INT Unique identifier of recordActionID INT Associated actionStoryboardID INT Associated storyboardStoryDetailsID INT Associated storyboard details

StoryboardAuthorizationHistoryLogID INT Unique identifier of recordStoryboardID INT Associated storyboardDate DATETIME Date when storyboard was authorizedVersion INT Version of storyboardUserName CHAR Associated userStatus CHAR Status of log recordAction CHAR Associated action




StoryType CHAR Type of storyboardComments CHAR User comments

StoryboardAuthorizationRequestsID INT Unique identifier of recordStoryboardID INT Associated storyboardAuthorizationRequestID INT Authorization request ID

StoryboardAuthorizersID INT Unique identifier of recordStoryboardID INT Associated storyboardUserID INT User IDGroupID INT User group IDResourceID INT Resource IDSequence INT Authorization sequence number of user

StoryboardChangeLogID INT Unique identifier of recordStoryboardID INT Associated storyboardDate DATETIME Date and time change madeUserID INT User that made the changeDescription CHAR Description of storyboard change log

StoryboardDetailsID INT Unique identifier of recordStoryID INT Storyboard IDTitle CHAR Title of storyboardStoryType CHAR Type of storyboard (master of draft)Version CHAR Version of storyboardURL CHAR URL of storyboard in Web ServerAcknowledgementText CHAR Default acknowledgement textDefaultAccessRights CHAR Default access rights of storyboard

StoryboardFolderAccessRightsID INT Unique identifier of recordStoryboardFolderID INT Name of storyboard folderUserID INT Associated userGroupID INT Associated user groupAccessLevel CHAR Level of access rights of user or user group

StoryboardFoldersID INT Unique identifier of recordName CHAR Name of storyboard folderParentFolderID INT Parent storyboard folderDefaultAccessRights CHAR Default access rights of storyboard folder

StoryboardKeywordsID INT Unique identifier of recordStoryboardID INT Associated storyboardKeywordID INT Associated keyword

StoryboardMemosID INT Unique identifier of recordStoryboardID Storyboard IDMemoID Memo ID

StoryboardPromotersID INT Unique identifier of recordStoryboardID INT Storyboard IDUserID INT User assigned as promoterGroupID INT User group assigned as promoter

StoryboardRoles




ID INT Unique identifier of recordStoryboardID INT Associated storyboardResourceID INT Associated resource

StoryboardStepsID INT Unique identifier of recordStoryboardID INT Associated storyboardStepIndex INT Index of storyboard stepStepTitle CHAR Title of storyboard stepDiagramID INT Associated diagramDiagramObjectID INT Associated diagram objectCommentary CHAR Commentary for storyboard stepKeyStep BIT If storyboard step is a key step

StoryboardsID INT Unique identifier of recordOwnerID INT Owner of storyboardAuthorID INT Author of storyboardLastModified DATETIME Date and time when record last modifiedExpiryPeriod INT Expiry time of storyboardStoryboardFolderID INT Storyboard folder record

UserGroupsID INT Unique identifier of recordName CHAR Name of user groupDescription CHAR Description of user group

UserGroupsKeywordGroupsID INT Unique identifier of recordUserGroupID INT User group associated with keyword groupKeywordGroupID INT Keyword group associated with user group

UserRolesID INT Unique identifier of recordUserID INT Associated userResourceID INT Associated resource

UsersID INT Unique identifier of recordAccountName CHAR Account name of userFirstName CHAR First name of userLastName CHAR Last name of userAccountType CHAR Account type (Administrator, Process Author, End User or

Unassigned).Deleted BIT If the user account has been deletedChangeModule BIT If the user has the change module (end users only)ActionModule BIT If the user has the action module (end users only)MobileModule BIT If the user has the mobile module (end users only)MobileNumber CHAR Mobile number of userEmail CHAR Email address of userReportsTo INT Manager that user reports toJobTitle CHAR Job title of userComment CHAR Comment about userPreferredServer CHAR Preferred server of userDescription CHAR Description of userCreatedBy INT User record created byCreatedDate DATETIME Date and time of record creation

UsersGroupsID INT Unique identifier of record




UserID INT UserGroupID INT User group



Entity Relationships

Table relationships can be represented in an entity relationship diagram. Entity relationship diagrams providea visual overview of table relationships within a database, allowing you to better understand a database. Youcan create customized entity relationship diagrams using SQL Server Management Studio. If you do notalready have SQL Server Management Studio then SQL Server Management Studio Express is freely availablefrom Microsoft.

To create entity relationship diagrams in SQL Server Management Studio (Express)

1. In SQL Server Management Studio (Express), expand the database node for the TIBCO Nimbus database.2. Right-click on the Database Diagrams node and choose New Database Diagram.3. In the Add Table window, hold Ctrl and select each table that you want to add to the diagram and then

click Add.

This will create an entity relationship diagram for the selected tables. You can save the diagram by pressing Ctrl + S. Entity relationship diagrams are saved under the Database Diagrams node for future reference.