Please enable JavaScript.
Coggle requires JavaScript to display documents.
Analysis - Extended Data (Publish workflow (Publishing Service (Call procs…
Analysis - Extended Data
Publish workflow
Excel Form
Fill form
Publish to ESB
Validate form data
Publish
#
Payload
Extended Data
Audience
#
Callback
Origin
Sender
Display confirmation msg
WebAPI
Create Publishing Request
Publishing Service
Read new Publishing Request
Call procs to create objects
Objects created
Views
Procs
Table
Procs called
ODS.Extended.up_GenerateServiceObjects
GatewayServices.Extended.up_GenerateServiceObjects
Add new service definition
INSERT INTO [SQLGatewayServices].[Services].[ServiceDefinition]
Copy xml contract
Send PVR
Security
Excel Form
Audience reference table
Display-friendly name
Security role
Passed through Payload
DB objects
#
#
IsMember of security role
#
SQL security
Login SQL
Linked to AD group
AD Group max 60 chars
Server level
Format
Prefix
"PSP\SecSQL-BusinessService-"
User name
User
#
#
DB level
Login
Role
Format
Prefix
"SecSQL-BusinessService-"
Role name
Role
#
DB level
Format
Prefix
"ViewAll"
Name
À valider avec...
DBA
ITOP
IAM?
Suffix
"ExtendedData"