Relational Database Templates¶
Egeria's content packs for relational databases share one design for their catalog templates. The PostgreSQL Templates page describes that design in detail, with diagrams of the elements each template creates and of the way the templates, processes and connectors work together. This page summarizes the shared design and then describes what is different for each of the other databases:
- Microsoft SQL Server - Microsoft SQL Server Content Pack
- Oracle Database - Oracle Content Pack
- Db2 for Linux, UNIX and Windows - Db2 for Linux, UNIX and Windows Content Pack
- DuckDB - DuckDB Content Pack
The shared design¶
Each server-based database pack (PostgreSQL, Microsoft SQL Server, Oracle and Db2) supplies six templates, one per technology type:
| Level | Template creates | Qualified name pattern |
|---|---|---|
| Server | SoftwareServer with a DatabaseManager capability, an endpoint and a connection | <Server technology type>::~{serverName}~ |
| Database | RelationalDatabase with an endpoint and a connection | <Database technology type>::~{serverName}~::~{databaseName}~ |
| Schema | DeployedDatabaseSchema with an endpoint and a connection | <Schema technology type>::~{serverName}~::~{databaseName}~.~{schemaName}~ |
| Schema as tabular data | TabularDataSetCollection | <technology type>::~{serverName}~::~{databaseName}~.~{schemaName}~ |
| Table as tabular data | TabularDataSet | <technology type>::~{serverName}~::~{databaseName}~.~{schemaName}~.~{tableName}~ |
| Table in lineage | DataSet with no connection | <Table technology type>::~{namespacePath}~::~{resourceName}~ |
The connections of the first five templates are virtual connections that name the shared Relational Database JDBC Connector and embed a connection to the YAML File Secrets Store Connector, so the credentials are supplied through the secretsStorePathName and secretsCollectionName placeholders rather than stored in open metadata. The two tabular data set templates wrap that JDBC connection in a further connection to the product's own tabular data set connector, which presents a schema or table as tabular data. The lineage-style table template is named the way OpenLineage names the product's tables.
Every server, database and schema technology type has a CreateAsCatalogTarget and a DeleteAsset governance action process, and servers and databases also have CreateAndSurvey. Cataloguing a server attaches it to the pack's server cataloguer, which creates each database it finds from the database template and passes it to the Core Content Pack's JDBCDatabaseCataloguer to catalog its schemas, tables and columns.
The differences between the packs are in the JDBC addresses and in the placeholders each level needs.
Microsoft SQL Server¶
| Template | Endpoint network address | Extra placeholders |
|---|---|---|
| Microsoft SQL Server | jdbc:sqlserver://~{hostIdentifier}~:~{portNumber}~ |
|
| Microsoft SQL Server Relational Database | jdbc:sqlserver://~{hostIdentifier}~:~{portNumber}~;databaseName=~{databaseName}~ |
databaseName, databaseDescription |
| Microsoft SQL Server Relational Database Schema, Tabular Data Set Collection and Tabular Data Set | jdbc:sqlserver://~{hostIdentifier}~:~{portNumber}~;databaseName=~{databaseName}~ |
schemaName, schemaDescription (and tableName, tableDescription for a table) |
SQL Server's JDBC URL has no schema parameter, so the schema is passed to the connector in the connection's databaseSchema configuration property. The tabular data set templates use the Microsoft SQL Server Tabular Data Set Connector and Microsoft SQL Server Tabular Data Set Collection Connector. The lineage-style Microsoft SQL Server Table template uses the OpenLineage namespace mssql://{host}:{port} and name {database}.{schema}.{table}.
The processes are MSSQLServer::CreateAsCatalogTarget, MSSQLServer:CreateAndSurvey and MSSQLServer:DeleteAsset, with matching MSSQLDatabase and MSSQLDatabaseSchema processes (no CreateAndSurvey for schemas). The server cataloguer runs as MSSQLServerCataloguer.
Technology type report for Microsoft SQL Server
---
title: Technology Report for - Microsoft SQL Server [bc5b08f7-14ec-4de7-87cb-902865898642]
---
flowchart LR
%%{init: {"flowchart": {"htmlLabels": false}} }%%
1@{ shape: hex, label: "*Technology Type*
**Microsoft SQL Server**"}
2@{ shape: hex, label: "*Technology Type*
**Catalog Templates**"}
1==>2
3@{ shape: card, label: "*Software Server*
**Microsoft SQL Server template**"}
2==>|"catalog templates"|3
4@{ shape: hex, label: "*Property Type*
**placeholderProperty**"}
3==>|"SpecificationPropertyAssignment"|4
5@{ shape: hex, label: "*placeholder Property*
**description**"}
4==>|"SpecificationPropertyAssignment"|5
6@{ shape: hex, label: "*placeholder Property*
**resourceName**"}
4==>|"SpecificationPropertyAssignment"|6
7@{ shape: hex, label: "*placeholder Property*
**serverName**"}
4==>|"SpecificationPropertyAssignment"|7
8@{ shape: hex, label: "*placeholder Property*
**secretsCollectionName**"}
4==>|"SpecificationPropertyAssignment"|8
9@{ shape: hex, label: "*placeholder Property*
**portNumber**"}
4==>|"SpecificationPropertyAssignment"|9
10@{ shape: hex, label: "*placeholder Property*
**secretsStorePathName**"}
4==>|"SpecificationPropertyAssignment"|10
11@{ shape: hex, label: "*placeholder Property*
**versionIdentifier**"}
4==>|"SpecificationPropertyAssignment"|11
12@{ shape: hex, label: "*placeholder Property*
**hostIdentifier**"}
4==>|"SpecificationPropertyAssignment"|12
13@{ shape: hex, label: "*Technology Type*
**Governance Action Processes**"}
1==>13
14@{ shape: processes, label: "*Surveying Action Process*
**Survey Resource**"}
13==>|"governance action process [Survey Resource]"|14
15@{ shape: hex, label: "*Property Type*
**producedAnnotationType**"}
14==>|"SpecificationPropertyAssignment"|15
16@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Measurements**"}
15==>|"SpecificationPropertyAssignment"|16
17@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
14==>|"SpecificationPropertyAssignment"|17
18@{ shape: hex, label: "*supported Request Parameter*
**finalAnalysisStep**"}
17==>|"SpecificationPropertyAssignment"|18
19@{ shape: hex, label: "*supported Request Parameter*
**hostIdentifier**"}
17==>|"SpecificationPropertyAssignment"|19
20@{ shape: hex, label: "*supported Request Parameter*
**versionIdentifier**"}
17==>|"SpecificationPropertyAssignment"|20
21@{ shape: hex, label: "*supported Request Parameter*
**secretsCollectionName**"}
17==>|"SpecificationPropertyAssignment"|21
22@{ shape: hex, label: "*supported Request Parameter*
**portNumber**"}
17==>|"SpecificationPropertyAssignment"|22
23@{ shape: hex, label: "*supported Request Parameter*
**description**"}
17==>|"SpecificationPropertyAssignment"|23
24@{ shape: hex, label: "*supported Request Parameter*
**serverName**"}
17==>|"SpecificationPropertyAssignment"|24
25@{ shape: hex, label: "*supported Request Parameter*
**resourceName**"}
17==>|"SpecificationPropertyAssignment"|25
26@{ shape: hex, label: "*supported Request Parameter*
**secretsStorePathName**"}
17==>|"SpecificationPropertyAssignment"|26
27@{ shape: hex, label: "*Property Type*
**supportedAnalysisStep**"}
14==>|"SpecificationPropertyAssignment"|27
28@{ shape: hex, label: "*supported Analysis Step*
**Check Asset**"}
27==>|"SpecificationPropertyAssignment"|28
29@{ shape: hex, label: "*supported Analysis Step*
**Produce Inventory**"}
27==>|"SpecificationPropertyAssignment"|29
30@{ shape: hex, label: "*supported Analysis Step*
**Profiling Associated Resources**"}
27==>|"SpecificationPropertyAssignment"|30
31@{ shape: processes, label: "*Deleting Action Process*
**Catalog Resource**"}
13==>|"governance action process [Catalog Resource]"|31
32@{ shape: processes, label: "*Cataloguing Action Process*
**Catalog Resource**"}
13==>|"governance action process [Catalog Resource]"|32
33@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
32==>|"SpecificationPropertyAssignment"|33
34@{ shape: hex, label: "*supported Request Parameter*
**versionIdentifier**"}
33==>|"SpecificationPropertyAssignment"|34
35@{ shape: hex, label: "*supported Request Parameter*
**resourceName**"}
33==>|"SpecificationPropertyAssignment"|35
36@{ shape: hex, label: "*supported Request Parameter*
**description**"}
33==>|"SpecificationPropertyAssignment"|36
37@{ shape: hex, label: "*supported Request Parameter*
**hostIdentifier**"}
33==>|"SpecificationPropertyAssignment"|37
38@{ shape: hex, label: "*supported Request Parameter*
**secretsCollectionName**"}
33==>|"SpecificationPropertyAssignment"|38
39@{ shape: hex, label: "*supported Request Parameter*
**portNumber**"}
33==>|"SpecificationPropertyAssignment"|39
40@{ shape: hex, label: "*supported Request Parameter*
**serverName**"}
33==>|"SpecificationPropertyAssignment"|40
41@{ shape: hex, label: "*supported Request Parameter*
**secretsStorePathName**"}
33==>|"SpecificationPropertyAssignment"|41
42@{ shape: hex, label: "*Technology Type*
**Resource List**"}
1==>42
43@{ shape: stadium, label: "*Integration Connector*
**Catalog Resource**"}
42==>|"resource [Catalog Resource]"|43
44@{ shape: hex, label: "*Property Type*
**supportedConfigurationProperty**"}
43==>|"SpecificationPropertyAssignment"|44
45@{ shape: hex, label: "*supported Configuration Property*
**MSSQLFriendshipGUID**"}
44==>|"SpecificationPropertyAssignment"|45
46@{ shape: hex, label: "*supported Configuration Property*
**serverName**"}
44==>|"SpecificationPropertyAssignment"|46
47@{ shape: hex, label: "*supported Configuration Property*
**hostIdentifier**"}
44==>|"SpecificationPropertyAssignment"|47
48@{ shape: hex, label: "*supported Configuration Property*
**excludeDatabaseList**"}
44==>|"SpecificationPropertyAssignment"|48
49@{ shape: hex, label: "*supported Configuration Property*
**includeDatabaseList**"}
44==>|"SpecificationPropertyAssignment"|49
50@{ shape: hex, label: "*supported Configuration Property*
**databasePassword**"}
44==>|"SpecificationPropertyAssignment"|50
51@{ shape: hex, label: "*supported Configuration Property*
**portNumber**"}
44==>|"SpecificationPropertyAssignment"|51
52@{ shape: hex, label: "*supported Configuration Property*
**databaseUserId**"}
44==>|"SpecificationPropertyAssignment"|52
53@{ shape: tag-rect, label: "*Governance Action Type*
**Catalog Resource**"}
42==>|"resource [Catalog Resource]"|53
54@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
53==>|"SpecificationPropertyAssignment"|54
55@{ shape: hex, label: "*supported Request Parameter*
**templateGUID**"}
54==>|"SpecificationPropertyAssignment"|55
56@{ shape: hex, label: "*Property Type*
**producedGuard**"}
53==>|"SpecificationPropertyAssignment"|56
57@{ shape: hex, label: "*produced Guard*
**missing-template**"}
56==>|"SpecificationPropertyAssignment"|57
58@{ shape: hex, label: "*produced Guard*
**delete-complete**"}
56==>|"SpecificationPropertyAssignment"|58
59@{ shape: hex, label: "*produced Guard*
**service-failed**"}
56==>|"SpecificationPropertyAssignment"|59
60@{ shape: hex, label: "*produced Guard*
**set-up-complete**"}
56==>|"SpecificationPropertyAssignment"|60
61@{ shape: hex, label: "*Property Type*
**producedActionTarget**"}
53==>|"SpecificationPropertyAssignment"|61
62@{ shape: hex, label: "*produced Action Target*
**newAsset**"}
61==>|"SpecificationPropertyAssignment"|62
63@{ shape: tag-rect, label: "*Governance Action Type*
**Catalog Resource**"}
42==>|"resource [Catalog Resource]"|63
64@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
63==>|"SpecificationPropertyAssignment"|64
65@{ shape: hex, label: "*supported Request Parameter*
**templateGUID**"}
64==>|"SpecificationPropertyAssignment"|65
66@{ shape: hex, label: "*Property Type*
**producedGuard**"}
63==>|"SpecificationPropertyAssignment"|66
67@{ shape: hex, label: "*produced Guard*
**missing-asset**"}
66==>|"SpecificationPropertyAssignment"|67
68@{ shape: hex, label: "*produced Guard*
**set-up-complete**"}
66==>|"SpecificationPropertyAssignment"|68
69@{ shape: hex, label: "*produced Guard*
**missing-connector**"}
66==>|"SpecificationPropertyAssignment"|69
70@{ shape: hex, label: "*produced Guard*
**service-failed**"}
66==>|"SpecificationPropertyAssignment"|70
71@{ shape: hex, label: "*Property Type*
**supportedActionTarget**"}
63==>|"SpecificationPropertyAssignment"|71
72@{ shape: hex, label: "*supported Action Target*
**integrationConnector**"}
71==>|"SpecificationPropertyAssignment"|72
73@{ shape: hex, label: "*Property Type*
**producedActionTarget**"}
63==>|"SpecificationPropertyAssignment"|73
74@{ shape: hex, label: "*produced Action Target*
**newAsset**"}
73==>|"SpecificationPropertyAssignment"|74
75@{ shape: tag-rect, label: "*Governance Action Type*
**Uncatalog Resource**"}
42==>|"resource [Uncatalog Resource]"|75
76@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
75==>|"SpecificationPropertyAssignment"|76
77@{ shape: hex, label: "*supported Request Parameter*
**templateGUID**"}
76==>|"SpecificationPropertyAssignment"|77
78@{ shape: hex, label: "*Property Type*
**producedGuard**"}
75==>|"SpecificationPropertyAssignment"|78
79@{ shape: hex, label: "*produced Guard*
**delete-complete**"}
78==>|"SpecificationPropertyAssignment"|79
80@{ shape: hex, label: "*produced Guard*
**service-failed**"}
78==>|"SpecificationPropertyAssignment"|80
81@{ shape: hex, label: "*produced Guard*
**set-up-complete**"}
78==>|"SpecificationPropertyAssignment"|81
82@{ shape: hex, label: "*produced Guard*
**missing-template**"}
78==>|"SpecificationPropertyAssignment"|82
83@{ shape: hex, label: "*Property Type*
**producedActionTarget**"}
75==>|"SpecificationPropertyAssignment"|83
84@{ shape: hex, label: "*produced Action Target*
**deletedAsset**"}
83==>|"SpecificationPropertyAssignment"|84
85@{ shape: tag-rect, label: "*Governance Action Type*
**Survey Resource**"}
42==>|"resource [Survey Resource]"|85
86@{ shape: hex, label: "*Property Type*
**producedAnnotationType**"}
85==>|"SpecificationPropertyAssignment"|86
87@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Measurements**"}
86==>|"SpecificationPropertyAssignment"|87
88@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
85==>|"SpecificationPropertyAssignment"|88
89@{ shape: hex, label: "*supported Request Parameter*
**excludeSchemaNames**"}
88==>|"SpecificationPropertyAssignment"|89
90@{ shape: hex, label: "*supported Request Parameter*
**includeSchemaNames**"}
88==>|"SpecificationPropertyAssignment"|90
91@{ shape: hex, label: "*supported Request Parameter*
**finalAnalysisStep**"}
88==>|"SpecificationPropertyAssignment"|91
92@{ shape: hex, label: "*Property Type*
**producedGuard**"}
85==>|"SpecificationPropertyAssignment"|92
93@{ shape: hex, label: "*produced Guard*
**survey-completed**"}
92==>|"SpecificationPropertyAssignment"|93
94@{ shape: hex, label: "*produced Guard*
**survey-invalid**"}
92==>|"SpecificationPropertyAssignment"|94
95@{ shape: hex, label: "*produced Guard*
**survey-failed**"}
92==>|"SpecificationPropertyAssignment"|95
96@{ shape: hex, label: "*Property Type*
**supportedAnalysisStep**"}
85==>|"SpecificationPropertyAssignment"|96
97@{ shape: hex, label: "*supported Analysis Step*
**Produce Inventory**"}
96==>|"SpecificationPropertyAssignment"|97
98@{ shape: hex, label: "*supported Analysis Step*
**Check Asset**"}
96==>|"SpecificationPropertyAssignment"|98
99@{ shape: hex, label: "*supported Analysis Step*
**Profiling Associated Resources**"}
96==>|"SpecificationPropertyAssignment"|99
100@{ shape: hex, label: "*Property Type*
**producedActionTarget**"}
85==>|"SpecificationPropertyAssignment"|100
101@{ shape: hex, label: "*produced Action Target*
**stewardAction**"}
100==>|"SpecificationPropertyAssignment"|101
102@{ shape: hex, label: "*produced Action Target*
**steward**"}
100==>|"SpecificationPropertyAssignment"|102
103@{ shape: hex, label: "*produced Action Target*
**surveyReport**"}
100==>|"SpecificationPropertyAssignment"|103
104@{ shape: hex, label: "*Property Type*
**supportedActionTarget**"}
85==>|"SpecificationPropertyAssignment"|104
105@{ shape: hex, label: "*supported Action Target*
**mssqlServer**"}
104==>|"SpecificationPropertyAssignment"|105
style 88 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 89 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 90 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 91 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 92 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 93 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 94 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 95 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 96 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 97 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 10 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 98 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 11 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 99 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 12 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 13 color:#f2d9e7, fill:#732650, stroke:#f2d9e7
style 14 color:#000000, fill:#40E0D0, stroke:#000000
style 15 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 16 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 17 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 18 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 19 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 1 color:#f2d9e7, fill:#732650, stroke:#f2d9e7
style 2 color:#f2d9e7, fill:#732650, stroke:#f2d9e7
style 3 color:#004563, fill:#b0e0e6, stroke:#004563
style 4 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 5 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 6 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 7 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 8 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 9 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 20 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 21 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 22 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 23 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 24 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 25 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 26 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 27 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 28 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 29 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 30 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 31 color:#000000, fill:#40E0D0, stroke:#000000
style 32 color:#000000, fill:#40E0D0, stroke:#000000
style 33 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 34 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 35 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 36 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 37 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 38 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 39 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 40 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 41 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 42 color:#f2d9e7, fill:#732650, stroke:#f2d9e7
style 43 color:#000000, fill:#BDB76B, stroke:#004563
style 44 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 45 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 46 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 47 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 48 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 49 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 50 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 51 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 52 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 53 color:#000000, fill:#40E0D0, stroke:#000000
style 54 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 55 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 56 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 57 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 58 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 59 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 60 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 61 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 62 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 63 color:#000000, fill:#40E0D0, stroke:#000000
style 64 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 65 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 66 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 67 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 68 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 69 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 70 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 71 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 72 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 73 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 74 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 75 color:#000000, fill:#40E0D0, stroke:#000000
style 76 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 77 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 78 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 79 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 100 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 101 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 102 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 103 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 104 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 105 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 80 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 81 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 82 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 83 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 84 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 85 color:#000000, fill:#40E0D0, stroke:#000000
style 86 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 87 color:#260d1b, fill:#d98cb6, stroke:#260d1bTechnology type report for Microsoft SQL Server Relational Database
---
title: Technology Report for - Microsoft SQL Server Relational Database [1852931a-0118-4c30-867a-49e7c31fbcab]
---
flowchart LR
%%{init: {"flowchart": {"htmlLabels": false}} }%%
1@{ shape: hex, label: "*Technology Type*
**Microsoft SQL Server Relational Database**"}
2@{ shape: hex, label: "*Technology Type*
**Catalog Templates**"}
1==>2
3@{ shape: card, label: "*Relational Database*
**Microsoft SQL Server Relational Database template**"}
2==>|"catalog templates"|3
4@{ shape: hex, label: "*Property Type*
**placeholderProperty**"}
3==>|"SpecificationPropertyAssignment"|4
5@{ shape: hex, label: "*placeholder Property*
**hostIdentifier**"}
4==>|"SpecificationPropertyAssignment"|5
6@{ shape: hex, label: "*placeholder Property*
**secretsStorePathName**"}
4==>|"SpecificationPropertyAssignment"|6
7@{ shape: hex, label: "*placeholder Property*
**databaseDescription**"}
4==>|"SpecificationPropertyAssignment"|7
8@{ shape: hex, label: "*placeholder Property*
**portNumber**"}
4==>|"SpecificationPropertyAssignment"|8
9@{ shape: hex, label: "*placeholder Property*
**serverName**"}
4==>|"SpecificationPropertyAssignment"|9
10@{ shape: hex, label: "*placeholder Property*
**databaseName**"}
4==>|"SpecificationPropertyAssignment"|10
11@{ shape: hex, label: "*placeholder Property*
**versionIdentifier**"}
4==>|"SpecificationPropertyAssignment"|11
12@{ shape: hex, label: "*placeholder Property*
**secretsCollectionName**"}
4==>|"SpecificationPropertyAssignment"|12
13@{ shape: hex, label: "*Technology Type*
**Governance Action Processes**"}
1==>13
14@{ shape: processes, label: "*Deleting Action Process*
**Catalog Resource**"}
13==>|"governance action process [Catalog Resource]"|14
15@{ shape: processes, label: "*Surveying Action Process*
**Survey Resource**"}
13==>|"governance action process [Survey Resource]"|15
16@{ shape: hex, label: "*Property Type*
**producedAnnotationType**"}
15==>|"SpecificationPropertyAssignment"|16
17@{ shape: hex, label: "*produced Annotation Type*
**Capture Frequent Values for Column**"}
16==>|"SpecificationPropertyAssignment"|17
18@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Table Measurements**"}
16==>|"SpecificationPropertyAssignment"|18
19@{ shape: hex, label: "*produced Annotation Type*
**Capture List of Table Columns**"}
16==>|"SpecificationPropertyAssignment"|19
20@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Column Measurements**"}
16==>|"SpecificationPropertyAssignment"|20
21@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Table Sizes**"}
16==>|"SpecificationPropertyAssignment"|21
22@{ shape: hex, label: "*produced Annotation Type*
**Capture List of Tables**"}
16==>|"SpecificationPropertyAssignment"|22
23@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Measurements**"}
16==>|"SpecificationPropertyAssignment"|23
24@{ shape: hex, label: "*produced Annotation Type*
**Capture Table Sizes for a Database Schema**"}
16==>|"SpecificationPropertyAssignment"|24
25@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Schema Measurements**"}
16==>|"SpecificationPropertyAssignment"|25
26@{ shape: hex, label: "*produced Annotation Type*
**Capture List of Schemas**"}
16==>|"SpecificationPropertyAssignment"|26
27@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
15==>|"SpecificationPropertyAssignment"|27
28@{ shape: hex, label: "*supported Request Parameter*
**databaseName**"}
27==>|"SpecificationPropertyAssignment"|28
29@{ shape: hex, label: "*supported Request Parameter*
**versionIdentifier**"}
27==>|"SpecificationPropertyAssignment"|29
30@{ shape: hex, label: "*supported Request Parameter*
**hostIdentifier**"}
27==>|"SpecificationPropertyAssignment"|30
31@{ shape: hex, label: "*supported Request Parameter*
**secretsCollectionName**"}
27==>|"SpecificationPropertyAssignment"|31
32@{ shape: hex, label: "*supported Request Parameter*
**secretsStorePathName**"}
27==>|"SpecificationPropertyAssignment"|32
33@{ shape: hex, label: "*supported Request Parameter*
**finalAnalysisStep**"}
27==>|"SpecificationPropertyAssignment"|33
34@{ shape: hex, label: "*supported Request Parameter*
**portNumber**"}
27==>|"SpecificationPropertyAssignment"|34
35@{ shape: hex, label: "*supported Request Parameter*
**databaseDescription**"}
27==>|"SpecificationPropertyAssignment"|35
36@{ shape: hex, label: "*supported Request Parameter*
**serverName**"}
27==>|"SpecificationPropertyAssignment"|36
37@{ shape: hex, label: "*Property Type*
**supportedAnalysisStep**"}
15==>|"SpecificationPropertyAssignment"|37
38@{ shape: hex, label: "*supported Analysis Step*
**Profiling Associated Resources**"}
37==>|"SpecificationPropertyAssignment"|38
39@{ shape: hex, label: "*supported Analysis Step*
**Check Asset**"}
37==>|"SpecificationPropertyAssignment"|39
40@{ shape: hex, label: "*supported Analysis Step*
**Measure Resource**"}
37==>|"SpecificationPropertyAssignment"|40
41@{ shape: processes, label: "*Cataloguing Action Process*
**Catalog Resource**"}
13==>|"governance action process [Catalog Resource]"|41
42@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
41==>|"SpecificationPropertyAssignment"|42
43@{ shape: hex, label: "*supported Request Parameter*
**portNumber**"}
42==>|"SpecificationPropertyAssignment"|43
44@{ shape: hex, label: "*supported Request Parameter*
**versionIdentifier**"}
42==>|"SpecificationPropertyAssignment"|44
45@{ shape: hex, label: "*supported Request Parameter*
**secretsStorePathName**"}
42==>|"SpecificationPropertyAssignment"|45
46@{ shape: hex, label: "*supported Request Parameter*
**secretsCollectionName**"}
42==>|"SpecificationPropertyAssignment"|46
47@{ shape: hex, label: "*supported Request Parameter*
**databaseDescription**"}
42==>|"SpecificationPropertyAssignment"|47
48@{ shape: hex, label: "*supported Request Parameter*
**serverName**"}
42==>|"SpecificationPropertyAssignment"|48
49@{ shape: hex, label: "*supported Request Parameter*
**hostIdentifier**"}
42==>|"SpecificationPropertyAssignment"|49
50@{ shape: hex, label: "*supported Request Parameter*
**databaseName**"}
42==>|"SpecificationPropertyAssignment"|50
51@{ shape: hex, label: "*Technology Type*
**Resource List**"}
1==>51
52@{ shape: tag-rect, label: "*Governance Action Type*
**Catalog Resource**"}
51==>|"resource [Catalog Resource]"|52
53@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
52==>|"SpecificationPropertyAssignment"|53
54@{ shape: hex, label: "*supported Request Parameter*
**templateGUID**"}
53==>|"SpecificationPropertyAssignment"|54
55@{ shape: hex, label: "*Property Type*
**producedGuard**"}
52==>|"SpecificationPropertyAssignment"|55
56@{ shape: hex, label: "*produced Guard*
**set-up-complete**"}
55==>|"SpecificationPropertyAssignment"|56
57@{ shape: hex, label: "*produced Guard*
**missing-asset**"}
55==>|"SpecificationPropertyAssignment"|57
58@{ shape: hex, label: "*produced Guard*
**missing-connector**"}
55==>|"SpecificationPropertyAssignment"|58
59@{ shape: hex, label: "*produced Guard*
**service-failed**"}
55==>|"SpecificationPropertyAssignment"|59
60@{ shape: hex, label: "*Property Type*
**supportedActionTarget**"}
52==>|"SpecificationPropertyAssignment"|60
61@{ shape: hex, label: "*supported Action Target*
**integrationConnector**"}
60==>|"SpecificationPropertyAssignment"|61
62@{ shape: hex, label: "*Property Type*
**producedActionTarget**"}
52==>|"SpecificationPropertyAssignment"|62
63@{ shape: hex, label: "*produced Action Target*
**newAsset**"}
62==>|"SpecificationPropertyAssignment"|63
64@{ shape: tag-rect, label: "*Governance Action Type*
**Uncatalog Resource**"}
51==>|"resource [Uncatalog Resource]"|64
65@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
64==>|"SpecificationPropertyAssignment"|65
66@{ shape: hex, label: "*supported Request Parameter*
**templateGUID**"}
65==>|"SpecificationPropertyAssignment"|66
67@{ shape: hex, label: "*Property Type*
**producedGuard**"}
64==>|"SpecificationPropertyAssignment"|67
68@{ shape: hex, label: "*produced Guard*
**delete-complete**"}
67==>|"SpecificationPropertyAssignment"|68
69@{ shape: hex, label: "*produced Guard*
**service-failed**"}
67==>|"SpecificationPropertyAssignment"|69
70@{ shape: hex, label: "*produced Guard*
**missing-template**"}
67==>|"SpecificationPropertyAssignment"|70
71@{ shape: hex, label: "*produced Guard*
**set-up-complete**"}
67==>|"SpecificationPropertyAssignment"|71
72@{ shape: hex, label: "*Property Type*
**producedActionTarget**"}
64==>|"SpecificationPropertyAssignment"|72
73@{ shape: hex, label: "*produced Action Target*
**deletedAsset**"}
72==>|"SpecificationPropertyAssignment"|73
74@{ shape: tag-rect, label: "*Governance Action Type*
**Catalog Resource**"}
51==>|"resource [Catalog Resource]"|74
75@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
74==>|"SpecificationPropertyAssignment"|75
76@{ shape: hex, label: "*supported Request Parameter*
**templateGUID**"}
75==>|"SpecificationPropertyAssignment"|76
77@{ shape: hex, label: "*Property Type*
**producedGuard**"}
74==>|"SpecificationPropertyAssignment"|77
78@{ shape: hex, label: "*produced Guard*
**set-up-complete**"}
77==>|"SpecificationPropertyAssignment"|78
79@{ shape: hex, label: "*produced Guard*
**missing-template**"}
77==>|"SpecificationPropertyAssignment"|79
80@{ shape: hex, label: "*produced Guard*
**delete-complete**"}
77==>|"SpecificationPropertyAssignment"|80
81@{ shape: hex, label: "*produced Guard*
**service-failed**"}
77==>|"SpecificationPropertyAssignment"|81
82@{ shape: hex, label: "*Property Type*
**producedActionTarget**"}
74==>|"SpecificationPropertyAssignment"|82
83@{ shape: hex, label: "*produced Action Target*
**newAsset**"}
82==>|"SpecificationPropertyAssignment"|83
84@{ shape: tag-rect, label: "*Governance Action Type*
**Survey Resource**"}
51==>|"resource [Survey Resource]"|84
85@{ shape: hex, label: "*Property Type*
**producedAnnotationType**"}
84==>|"SpecificationPropertyAssignment"|85
86@{ shape: hex, label: "*produced Annotation Type*
**Capture List of Table Columns**"}
85==>|"SpecificationPropertyAssignment"|86
87@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Measurements**"}
85==>|"SpecificationPropertyAssignment"|87
88@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Schema Measurements**"}
85==>|"SpecificationPropertyAssignment"|88
89@{ shape: hex, label: "*produced Annotation Type*
**Capture List of Schemas**"}
85==>|"SpecificationPropertyAssignment"|89
90@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Table Measurements**"}
85==>|"SpecificationPropertyAssignment"|90
91@{ shape: hex, label: "*produced Annotation Type*
**Capture List of Tables**"}
85==>|"SpecificationPropertyAssignment"|91
92@{ shape: hex, label: "*produced Annotation Type*
**Capture Frequent Values for Column**"}
85==>|"SpecificationPropertyAssignment"|92
93@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Column Measurements**"}
85==>|"SpecificationPropertyAssignment"|93
94@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Table Sizes**"}
85==>|"SpecificationPropertyAssignment"|94
95@{ shape: hex, label: "*produced Annotation Type*
**Capture Table Sizes for a Database Schema**"}
85==>|"SpecificationPropertyAssignment"|95
96@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
84==>|"SpecificationPropertyAssignment"|96
97@{ shape: hex, label: "*supported Request Parameter*
**finalAnalysisStep**"}
96==>|"SpecificationPropertyAssignment"|97
98@{ shape: hex, label: "*supported Request Parameter*
**includeSchemaNames**"}
96==>|"SpecificationPropertyAssignment"|98
99@{ shape: hex, label: "*supported Request Parameter*
**excludeSchemaNames**"}
96==>|"SpecificationPropertyAssignment"|99
100@{ shape: hex, label: "*Property Type*
**producedGuard**"}
84==>|"SpecificationPropertyAssignment"|100
101@{ shape: hex, label: "*produced Guard*
**survey-invalid**"}
100==>|"SpecificationPropertyAssignment"|101
102@{ shape: hex, label: "*produced Guard*
**survey-failed**"}
100==>|"SpecificationPropertyAssignment"|102
103@{ shape: hex, label: "*produced Guard*
**survey-completed**"}
100==>|"SpecificationPropertyAssignment"|103
104@{ shape: hex, label: "*Property Type*
**supportedAnalysisStep**"}
84==>|"SpecificationPropertyAssignment"|104
105@{ shape: hex, label: "*supported Analysis Step*
**Check Asset**"}
104==>|"SpecificationPropertyAssignment"|105
106@{ shape: hex, label: "*supported Analysis Step*
**Profiling Associated Resources**"}
104==>|"SpecificationPropertyAssignment"|106
107@{ shape: hex, label: "*supported Analysis Step*
**Measure Resource**"}
104==>|"SpecificationPropertyAssignment"|107
108@{ shape: hex, label: "*Property Type*
**producedActionTarget**"}
84==>|"SpecificationPropertyAssignment"|108
109@{ shape: hex, label: "*produced Action Target*
**stewardAction**"}
108==>|"SpecificationPropertyAssignment"|109
110@{ shape: hex, label: "*produced Action Target*
**steward**"}
108==>|"SpecificationPropertyAssignment"|110
111@{ shape: hex, label: "*produced Action Target*
**surveyReport**"}
108==>|"SpecificationPropertyAssignment"|111
112@{ shape: hex, label: "*Property Type*
**supportedActionTarget**"}
84==>|"SpecificationPropertyAssignment"|112
113@{ shape: hex, label: "*supported Action Target*
**mssqlDatabase**"}
112==>|"SpecificationPropertyAssignment"|113
style 88 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 89 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 110 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 111 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 112 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 113 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 90 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 91 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 92 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 93 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 94 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 95 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 96 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 97 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 10 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 98 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 11 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 99 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 12 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 13 color:#f2d9e7, fill:#732650, stroke:#f2d9e7
style 14 color:#000000, fill:#40E0D0, stroke:#000000
style 15 color:#000000, fill:#40E0D0, stroke:#000000
style 16 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 17 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 18 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 19 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 1 color:#f2d9e7, fill:#732650, stroke:#f2d9e7
style 2 color:#f2d9e7, fill:#732650, stroke:#f2d9e7
style 3 color:#004563, fill:#b0e0e6, stroke:#004563
style 4 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 5 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 6 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 7 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 8 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 9 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 20 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 21 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 22 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 23 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 24 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 25 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 26 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 27 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 28 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 29 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 30 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 31 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 32 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 33 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 34 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 35 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 36 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 37 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 38 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 39 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 40 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 41 color:#000000, fill:#40E0D0, stroke:#000000
style 42 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 43 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 44 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 45 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 46 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 47 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 48 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 49 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 50 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 51 color:#f2d9e7, fill:#732650, stroke:#f2d9e7
style 52 color:#000000, fill:#40E0D0, stroke:#000000
style 53 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 54 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 55 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 56 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 57 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 58 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 59 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 60 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 61 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 62 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 63 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 64 color:#000000, fill:#40E0D0, stroke:#000000
style 65 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 66 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 67 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 68 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 69 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 70 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 71 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 72 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 73 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 74 color:#000000, fill:#40E0D0, stroke:#000000
style 75 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 76 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 77 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 78 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 79 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 100 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 101 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 102 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 103 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 104 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 105 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 106 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 80 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 107 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 81 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 108 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 82 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 109 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 83 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 84 color:#000000, fill:#40E0D0, stroke:#000000
style 85 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 86 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 87 color:#260d1b, fill:#d98cb6, stroke:#260d1bOracle Database¶
In Oracle, the unit that is catalogued as a RelationalDatabase is a pluggable database (PDB), and databaseName is the PDB's service name. An Oracle JDBC connection always names a service, so the server template takes databaseName too - for the server, supply the service name of the container database (CDB) root, which is where the cataloguer and survey find the pluggable databases the server hosts.
| Template | Endpoint network address | Extra placeholders |
|---|---|---|
| Oracle Database Server | jdbc:oracle:thin:@//~{hostIdentifier}~:~{portNumber}~/~{databaseName}~ |
databaseName |
| Oracle Relational Database | jdbc:oracle:thin:@//~{hostIdentifier}~:~{portNumber}~/~{databaseName}~ |
databaseName, databaseDescription |
| Oracle Relational Database Schema, Tabular Data Set Collection and Tabular Data Set | jdbc:oracle:thin:@//~{hostIdentifier}~:~{portNumber}~/~{databaseName}~ |
schemaName, schemaDescription (and tableName, tableDescription for a table) |
Every Oracle JDBC connection in the templates sets two driver properties in its additionalConnectionProperties configuration property: oracle.jdbc.timezoneAsRegion=false and remarksReporting=true (so that table and column comments are returned with the metadata). The tabular data set templates use the Oracle Tabular Data Set Connector and Oracle Tabular Data Set Collection Connector. The lineage-style Oracle Table template uses the OpenLineage namespace oracle://{host}:{port} and name {serviceName or sid}.{schema}.{table}.
The processes are OracleServer::CreateAsCatalogTarget, OracleServer:CreateAndSurvey and OracleServer:DeleteAsset, with matching OracleDatabase and OracleDatabaseSchema processes. The server cataloguer runs as OracleServerCataloguer.
Technology type report for Oracle Database Server
---
title: Technology Report for - Oracle Database Server [f98b41b9-9c37-4913-a17f-35935034505f]
---
flowchart LR
%%{init: {"flowchart": {"htmlLabels": false}} }%%
1@{ shape: hex, label: "*Technology Type*
**Oracle Database Server**"}
2@{ shape: hex, label: "*Technology Type*
**Catalog Templates**"}
1==>2
3@{ shape: card, label: "*Software Server*
**Oracle Database Server template**"}
2==>|"catalog templates"|3
4@{ shape: hex, label: "*Property Type*
**placeholderProperty**"}
3==>|"SpecificationPropertyAssignment"|4
5@{ shape: hex, label: "*placeholder Property*
**versionIdentifier**"}
4==>|"SpecificationPropertyAssignment"|5
6@{ shape: hex, label: "*placeholder Property*
**secretsStorePathName**"}
4==>|"SpecificationPropertyAssignment"|6
7@{ shape: hex, label: "*placeholder Property*
**serverName**"}
4==>|"SpecificationPropertyAssignment"|7
8@{ shape: hex, label: "*placeholder Property*
**secretsCollectionName**"}
4==>|"SpecificationPropertyAssignment"|8
9@{ shape: hex, label: "*placeholder Property*
**resourceName**"}
4==>|"SpecificationPropertyAssignment"|9
10@{ shape: hex, label: "*placeholder Property*
**databaseName**"}
4==>|"SpecificationPropertyAssignment"|10
11@{ shape: hex, label: "*placeholder Property*
**hostIdentifier**"}
4==>|"SpecificationPropertyAssignment"|11
12@{ shape: hex, label: "*placeholder Property*
**description**"}
4==>|"SpecificationPropertyAssignment"|12
13@{ shape: hex, label: "*placeholder Property*
**portNumber**"}
4==>|"SpecificationPropertyAssignment"|13
14@{ shape: hex, label: "*Technology Type*
**Governance Action Processes**"}
1==>14
15@{ shape: processes, label: "*Cataloguing Action Process*
**Catalog Resource**"}
14==>|"governance action process [Catalog Resource]"|15
16@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
15==>|"SpecificationPropertyAssignment"|16
17@{ shape: hex, label: "*supported Request Parameter*
**resourceName**"}
16==>|"SpecificationPropertyAssignment"|17
18@{ shape: hex, label: "*supported Request Parameter*
**serverName**"}
16==>|"SpecificationPropertyAssignment"|18
19@{ shape: hex, label: "*supported Request Parameter*
**versionIdentifier**"}
16==>|"SpecificationPropertyAssignment"|19
20@{ shape: hex, label: "*supported Request Parameter*
**databaseName**"}
16==>|"SpecificationPropertyAssignment"|20
21@{ shape: hex, label: "*supported Request Parameter*
**portNumber**"}
16==>|"SpecificationPropertyAssignment"|21
22@{ shape: hex, label: "*supported Request Parameter*
**secretsStorePathName**"}
16==>|"SpecificationPropertyAssignment"|22
23@{ shape: hex, label: "*supported Request Parameter*
**description**"}
16==>|"SpecificationPropertyAssignment"|23
24@{ shape: hex, label: "*supported Request Parameter*
**secretsCollectionName**"}
16==>|"SpecificationPropertyAssignment"|24
25@{ shape: hex, label: "*supported Request Parameter*
**hostIdentifier**"}
16==>|"SpecificationPropertyAssignment"|25
26@{ shape: processes, label: "*Deleting Action Process*
**Catalog Resource**"}
14==>|"governance action process [Catalog Resource]"|26
27@{ shape: processes, label: "*Surveying Action Process*
**Survey Resource**"}
14==>|"governance action process [Survey Resource]"|27
28@{ shape: hex, label: "*Property Type*
**producedAnnotationType**"}
27==>|"SpecificationPropertyAssignment"|28
29@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Measurements**"}
28==>|"SpecificationPropertyAssignment"|29
30@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
27==>|"SpecificationPropertyAssignment"|30
31@{ shape: hex, label: "*supported Request Parameter*
**finalAnalysisStep**"}
30==>|"SpecificationPropertyAssignment"|31
32@{ shape: hex, label: "*supported Request Parameter*
**secretsStorePathName**"}
30==>|"SpecificationPropertyAssignment"|32
33@{ shape: hex, label: "*supported Request Parameter*
**secretsCollectionName**"}
30==>|"SpecificationPropertyAssignment"|33
34@{ shape: hex, label: "*supported Request Parameter*
**description**"}
30==>|"SpecificationPropertyAssignment"|34
35@{ shape: hex, label: "*supported Request Parameter*
**databaseName**"}
30==>|"SpecificationPropertyAssignment"|35
36@{ shape: hex, label: "*supported Request Parameter*
**resourceName**"}
30==>|"SpecificationPropertyAssignment"|36
37@{ shape: hex, label: "*supported Request Parameter*
**versionIdentifier**"}
30==>|"SpecificationPropertyAssignment"|37
38@{ shape: hex, label: "*supported Request Parameter*
**portNumber**"}
30==>|"SpecificationPropertyAssignment"|38
39@{ shape: hex, label: "*supported Request Parameter*
**hostIdentifier**"}
30==>|"SpecificationPropertyAssignment"|39
40@{ shape: hex, label: "*supported Request Parameter*
**serverName**"}
30==>|"SpecificationPropertyAssignment"|40
41@{ shape: hex, label: "*Property Type*
**supportedAnalysisStep**"}
27==>|"SpecificationPropertyAssignment"|41
42@{ shape: hex, label: "*supported Analysis Step*
**Profiling Associated Resources**"}
41==>|"SpecificationPropertyAssignment"|42
43@{ shape: hex, label: "*supported Analysis Step*
**Check Asset**"}
41==>|"SpecificationPropertyAssignment"|43
44@{ shape: hex, label: "*supported Analysis Step*
**Produce Inventory**"}
41==>|"SpecificationPropertyAssignment"|44
45@{ shape: hex, label: "*Technology Type*
**Resource List**"}
1==>45
46@{ shape: stadium, label: "*Integration Connector*
**Catalog Resource**"}
45==>|"resource [Catalog Resource]"|46
47@{ shape: hex, label: "*Property Type*
**supportedConfigurationProperty**"}
46==>|"SpecificationPropertyAssignment"|47
48@{ shape: hex, label: "*supported Configuration Property*
**hostIdentifier**"}
47==>|"SpecificationPropertyAssignment"|48
49@{ shape: hex, label: "*supported Configuration Property*
**includeDatabaseList**"}
47==>|"SpecificationPropertyAssignment"|49
50@{ shape: hex, label: "*supported Configuration Property*
**databasePassword**"}
47==>|"SpecificationPropertyAssignment"|50
51@{ shape: hex, label: "*supported Configuration Property*
**portNumber**"}
47==>|"SpecificationPropertyAssignment"|51
52@{ shape: hex, label: "*supported Configuration Property*
**OracleFriendshipGUID**"}
47==>|"SpecificationPropertyAssignment"|52
53@{ shape: hex, label: "*supported Configuration Property*
**databaseUserId**"}
47==>|"SpecificationPropertyAssignment"|53
54@{ shape: hex, label: "*supported Configuration Property*
**excludeDatabaseList**"}
47==>|"SpecificationPropertyAssignment"|54
55@{ shape: hex, label: "*supported Configuration Property*
**additionalConnectionProperties**"}
47==>|"SpecificationPropertyAssignment"|55
56@{ shape: hex, label: "*supported Configuration Property*
**serverName**"}
47==>|"SpecificationPropertyAssignment"|56
57@{ shape: tag-rect, label: "*Governance Action Type*
**Uncatalog Resource**"}
45==>|"resource [Uncatalog Resource]"|57
58@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
57==>|"SpecificationPropertyAssignment"|58
59@{ shape: hex, label: "*supported Request Parameter*
**templateGUID**"}
58==>|"SpecificationPropertyAssignment"|59
60@{ shape: hex, label: "*Property Type*
**producedGuard**"}
57==>|"SpecificationPropertyAssignment"|60
61@{ shape: hex, label: "*produced Guard*
**missing-template**"}
60==>|"SpecificationPropertyAssignment"|61
62@{ shape: hex, label: "*produced Guard*
**delete-complete**"}
60==>|"SpecificationPropertyAssignment"|62
63@{ shape: hex, label: "*produced Guard*
**set-up-complete**"}
60==>|"SpecificationPropertyAssignment"|63
64@{ shape: hex, label: "*produced Guard*
**service-failed**"}
60==>|"SpecificationPropertyAssignment"|64
65@{ shape: hex, label: "*Property Type*
**producedActionTarget**"}
57==>|"SpecificationPropertyAssignment"|65
66@{ shape: hex, label: "*produced Action Target*
**deletedAsset**"}
65==>|"SpecificationPropertyAssignment"|66
67@{ shape: tag-rect, label: "*Governance Action Type*
**Catalog Resource**"}
45==>|"resource [Catalog Resource]"|67
68@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
67==>|"SpecificationPropertyAssignment"|68
69@{ shape: hex, label: "*supported Request Parameter*
**templateGUID**"}
68==>|"SpecificationPropertyAssignment"|69
70@{ shape: hex, label: "*Property Type*
**producedGuard**"}
67==>|"SpecificationPropertyAssignment"|70
71@{ shape: hex, label: "*produced Guard*
**missing-asset**"}
70==>|"SpecificationPropertyAssignment"|71
72@{ shape: hex, label: "*produced Guard*
**set-up-complete**"}
70==>|"SpecificationPropertyAssignment"|72
73@{ shape: hex, label: "*produced Guard*
**service-failed**"}
70==>|"SpecificationPropertyAssignment"|73
74@{ shape: hex, label: "*produced Guard*
**missing-connector**"}
70==>|"SpecificationPropertyAssignment"|74
75@{ shape: hex, label: "*Property Type*
**supportedActionTarget**"}
67==>|"SpecificationPropertyAssignment"|75
76@{ shape: hex, label: "*supported Action Target*
**integrationConnector**"}
75==>|"SpecificationPropertyAssignment"|76
77@{ shape: hex, label: "*Property Type*
**producedActionTarget**"}
67==>|"SpecificationPropertyAssignment"|77
78@{ shape: hex, label: "*produced Action Target*
**newAsset**"}
77==>|"SpecificationPropertyAssignment"|78
79@{ shape: tag-rect, label: "*Governance Action Type*
**Survey Resource**"}
45==>|"resource [Survey Resource]"|79
80@{ shape: hex, label: "*Property Type*
**producedAnnotationType**"}
79==>|"SpecificationPropertyAssignment"|80
81@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Measurements**"}
80==>|"SpecificationPropertyAssignment"|81
82@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
79==>|"SpecificationPropertyAssignment"|82
83@{ shape: hex, label: "*supported Request Parameter*
**includeSchemaNames**"}
82==>|"SpecificationPropertyAssignment"|83
84@{ shape: hex, label: "*supported Request Parameter*
**finalAnalysisStep**"}
82==>|"SpecificationPropertyAssignment"|84
85@{ shape: hex, label: "*supported Request Parameter*
**excludeSchemaNames**"}
82==>|"SpecificationPropertyAssignment"|85
86@{ shape: hex, label: "*Property Type*
**producedGuard**"}
79==>|"SpecificationPropertyAssignment"|86
87@{ shape: hex, label: "*produced Guard*
**survey-invalid**"}
86==>|"SpecificationPropertyAssignment"|87
88@{ shape: hex, label: "*produced Guard*
**survey-completed**"}
86==>|"SpecificationPropertyAssignment"|88
89@{ shape: hex, label: "*produced Guard*
**survey-failed**"}
86==>|"SpecificationPropertyAssignment"|89
90@{ shape: hex, label: "*Property Type*
**supportedAnalysisStep**"}
79==>|"SpecificationPropertyAssignment"|90
91@{ shape: hex, label: "*supported Analysis Step*
**Produce Inventory**"}
90==>|"SpecificationPropertyAssignment"|91
92@{ shape: hex, label: "*supported Analysis Step*
**Profiling Associated Resources**"}
90==>|"SpecificationPropertyAssignment"|92
93@{ shape: hex, label: "*supported Analysis Step*
**Check Asset**"}
90==>|"SpecificationPropertyAssignment"|93
94@{ shape: hex, label: "*Property Type*
**producedActionTarget**"}
79==>|"SpecificationPropertyAssignment"|94
95@{ shape: hex, label: "*produced Action Target*
**steward**"}
94==>|"SpecificationPropertyAssignment"|95
96@{ shape: hex, label: "*produced Action Target*
**stewardAction**"}
94==>|"SpecificationPropertyAssignment"|96
97@{ shape: hex, label: "*produced Action Target*
**surveyReport**"}
94==>|"SpecificationPropertyAssignment"|97
98@{ shape: hex, label: "*Property Type*
**supportedActionTarget**"}
79==>|"SpecificationPropertyAssignment"|98
99@{ shape: hex, label: "*supported Action Target*
**oracleServer**"}
98==>|"SpecificationPropertyAssignment"|99
100@{ shape: tag-rect, label: "*Governance Action Type*
**Catalog Resource**"}
45==>|"resource [Catalog Resource]"|100
101@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
100==>|"SpecificationPropertyAssignment"|101
102@{ shape: hex, label: "*supported Request Parameter*
**templateGUID**"}
101==>|"SpecificationPropertyAssignment"|102
103@{ shape: hex, label: "*Property Type*
**producedGuard**"}
100==>|"SpecificationPropertyAssignment"|103
104@{ shape: hex, label: "*produced Guard*
**missing-template**"}
103==>|"SpecificationPropertyAssignment"|104
105@{ shape: hex, label: "*produced Guard*
**delete-complete**"}
103==>|"SpecificationPropertyAssignment"|105
106@{ shape: hex, label: "*produced Guard*
**service-failed**"}
103==>|"SpecificationPropertyAssignment"|106
107@{ shape: hex, label: "*produced Guard*
**set-up-complete**"}
103==>|"SpecificationPropertyAssignment"|107
108@{ shape: hex, label: "*Property Type*
**producedActionTarget**"}
100==>|"SpecificationPropertyAssignment"|108
109@{ shape: hex, label: "*produced Action Target*
**newAsset**"}
108==>|"SpecificationPropertyAssignment"|109
style 88 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 89 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 90 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 91 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 92 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 93 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 94 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 95 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 96 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 97 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 10 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 98 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 11 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 99 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 12 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 13 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 14 color:#f2d9e7, fill:#732650, stroke:#f2d9e7
style 15 color:#000000, fill:#40E0D0, stroke:#000000
style 16 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 17 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 18 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 19 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 1 color:#f2d9e7, fill:#732650, stroke:#f2d9e7
style 2 color:#f2d9e7, fill:#732650, stroke:#f2d9e7
style 3 color:#004563, fill:#b0e0e6, stroke:#004563
style 4 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 5 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 6 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 7 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 8 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 9 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 20 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 21 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 22 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 23 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 24 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 25 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 26 color:#000000, fill:#40E0D0, stroke:#000000
style 27 color:#000000, fill:#40E0D0, stroke:#000000
style 28 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 29 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 30 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 31 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 32 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 33 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 34 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 35 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 36 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 37 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 38 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 39 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 40 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 41 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 42 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 43 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 44 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 45 color:#f2d9e7, fill:#732650, stroke:#f2d9e7
style 46 color:#000000, fill:#BDB76B, stroke:#004563
style 47 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 48 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 49 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 50 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 51 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 52 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 53 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 54 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 55 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 56 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 57 color:#000000, fill:#40E0D0, stroke:#000000
style 58 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 59 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 60 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 61 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 62 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 63 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 64 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 65 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 66 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 67 color:#000000, fill:#40E0D0, stroke:#000000
style 68 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 69 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 70 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 71 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 72 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 73 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 74 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 75 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 76 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 77 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 78 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 79 color:#000000, fill:#40E0D0, stroke:#000000
style 100 color:#000000, fill:#40E0D0, stroke:#000000
style 101 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 102 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 103 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 104 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 105 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 106 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 80 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 107 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 81 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 108 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 82 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 109 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 83 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 84 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 85 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 86 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 87 color:#260d1b, fill:#d98cb6, stroke:#260d1bTechnology type report for Oracle Relational Database
---
title: Technology Report for - Oracle Relational Database [301bd39f-8b41-46d5-a769-25162145c235]
---
flowchart LR
%%{init: {"flowchart": {"htmlLabels": false}} }%%
1@{ shape: hex, label: "*Technology Type*
**Oracle Relational Database**"}
2@{ shape: hex, label: "*Technology Type*
**Catalog Templates**"}
1==>2
3@{ shape: card, label: "*Relational Database*
**Oracle Relational Database template**"}
2==>|"catalog templates"|3
4@{ shape: hex, label: "*Property Type*
**placeholderProperty**"}
3==>|"SpecificationPropertyAssignment"|4
5@{ shape: hex, label: "*placeholder Property*
**hostIdentifier**"}
4==>|"SpecificationPropertyAssignment"|5
6@{ shape: hex, label: "*placeholder Property*
**databaseDescription**"}
4==>|"SpecificationPropertyAssignment"|6
7@{ shape: hex, label: "*placeholder Property*
**secretsStorePathName**"}
4==>|"SpecificationPropertyAssignment"|7
8@{ shape: hex, label: "*placeholder Property*
**versionIdentifier**"}
4==>|"SpecificationPropertyAssignment"|8
9@{ shape: hex, label: "*placeholder Property*
**portNumber**"}
4==>|"SpecificationPropertyAssignment"|9
10@{ shape: hex, label: "*placeholder Property*
**databaseName**"}
4==>|"SpecificationPropertyAssignment"|10
11@{ shape: hex, label: "*placeholder Property*
**secretsCollectionName**"}
4==>|"SpecificationPropertyAssignment"|11
12@{ shape: hex, label: "*placeholder Property*
**serverName**"}
4==>|"SpecificationPropertyAssignment"|12
13@{ shape: hex, label: "*Technology Type*
**Governance Action Processes**"}
1==>13
14@{ shape: processes, label: "*Deleting Action Process*
**Catalog Resource**"}
13==>|"governance action process [Catalog Resource]"|14
15@{ shape: processes, label: "*Cataloguing Action Process*
**Catalog Resource**"}
13==>|"governance action process [Catalog Resource]"|15
16@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
15==>|"SpecificationPropertyAssignment"|16
17@{ shape: hex, label: "*supported Request Parameter*
**portNumber**"}
16==>|"SpecificationPropertyAssignment"|17
18@{ shape: hex, label: "*supported Request Parameter*
**serverName**"}
16==>|"SpecificationPropertyAssignment"|18
19@{ shape: hex, label: "*supported Request Parameter*
**secretsCollectionName**"}
16==>|"SpecificationPropertyAssignment"|19
20@{ shape: hex, label: "*supported Request Parameter*
**databaseDescription**"}
16==>|"SpecificationPropertyAssignment"|20
21@{ shape: hex, label: "*supported Request Parameter*
**databaseName**"}
16==>|"SpecificationPropertyAssignment"|21
22@{ shape: hex, label: "*supported Request Parameter*
**versionIdentifier**"}
16==>|"SpecificationPropertyAssignment"|22
23@{ shape: hex, label: "*supported Request Parameter*
**secretsStorePathName**"}
16==>|"SpecificationPropertyAssignment"|23
24@{ shape: hex, label: "*supported Request Parameter*
**hostIdentifier**"}
16==>|"SpecificationPropertyAssignment"|24
25@{ shape: processes, label: "*Surveying Action Process*
**Survey Resource**"}
13==>|"governance action process [Survey Resource]"|25
26@{ shape: hex, label: "*Property Type*
**producedAnnotationType**"}
25==>|"SpecificationPropertyAssignment"|26
27@{ shape: hex, label: "*produced Annotation Type*
**Capture Table Sizes for a Database Schema**"}
26==>|"SpecificationPropertyAssignment"|27
28@{ shape: hex, label: "*produced Annotation Type*
**Capture List of Tables**"}
26==>|"SpecificationPropertyAssignment"|28
29@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Measurements**"}
26==>|"SpecificationPropertyAssignment"|29
30@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Schema Measurements**"}
26==>|"SpecificationPropertyAssignment"|30
31@{ shape: hex, label: "*produced Annotation Type*
**Capture List of Table Columns**"}
26==>|"SpecificationPropertyAssignment"|31
32@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Column Measurements**"}
26==>|"SpecificationPropertyAssignment"|32
33@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Table Sizes**"}
26==>|"SpecificationPropertyAssignment"|33
34@{ shape: hex, label: "*produced Annotation Type*
**Capture List of Schemas**"}
26==>|"SpecificationPropertyAssignment"|34
35@{ shape: hex, label: "*produced Annotation Type*
**Capture Frequent Values for Column**"}
26==>|"SpecificationPropertyAssignment"|35
36@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Table Measurements**"}
26==>|"SpecificationPropertyAssignment"|36
37@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
25==>|"SpecificationPropertyAssignment"|37
38@{ shape: hex, label: "*supported Request Parameter*
**secretsStorePathName**"}
37==>|"SpecificationPropertyAssignment"|38
39@{ shape: hex, label: "*supported Request Parameter*
**versionIdentifier**"}
37==>|"SpecificationPropertyAssignment"|39
40@{ shape: hex, label: "*supported Request Parameter*
**serverName**"}
37==>|"SpecificationPropertyAssignment"|40
41@{ shape: hex, label: "*supported Request Parameter*
**secretsCollectionName**"}
37==>|"SpecificationPropertyAssignment"|41
42@{ shape: hex, label: "*supported Request Parameter*
**finalAnalysisStep**"}
37==>|"SpecificationPropertyAssignment"|42
43@{ shape: hex, label: "*supported Request Parameter*
**databaseDescription**"}
37==>|"SpecificationPropertyAssignment"|43
44@{ shape: hex, label: "*supported Request Parameter*
**portNumber**"}
37==>|"SpecificationPropertyAssignment"|44
45@{ shape: hex, label: "*supported Request Parameter*
**databaseName**"}
37==>|"SpecificationPropertyAssignment"|45
46@{ shape: hex, label: "*supported Request Parameter*
**hostIdentifier**"}
37==>|"SpecificationPropertyAssignment"|46
47@{ shape: hex, label: "*Property Type*
**supportedAnalysisStep**"}
25==>|"SpecificationPropertyAssignment"|47
48@{ shape: hex, label: "*supported Analysis Step*
**Check Asset**"}
47==>|"SpecificationPropertyAssignment"|48
49@{ shape: hex, label: "*supported Analysis Step*
**Measure Resource**"}
47==>|"SpecificationPropertyAssignment"|49
50@{ shape: hex, label: "*supported Analysis Step*
**Profiling Associated Resources**"}
47==>|"SpecificationPropertyAssignment"|50
51@{ shape: hex, label: "*Technology Type*
**Resource List**"}
1==>51
52@{ shape: tag-rect, label: "*Governance Action Type*
**Survey Resource**"}
51==>|"resource [Survey Resource]"|52
53@{ shape: hex, label: "*Property Type*
**producedAnnotationType**"}
52==>|"SpecificationPropertyAssignment"|53
54@{ shape: hex, label: "*produced Annotation Type*
**Capture List of Tables**"}
53==>|"SpecificationPropertyAssignment"|54
55@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Table Measurements**"}
53==>|"SpecificationPropertyAssignment"|55
56@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Measurements**"}
53==>|"SpecificationPropertyAssignment"|56
57@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Column Measurements**"}
53==>|"SpecificationPropertyAssignment"|57
58@{ shape: hex, label: "*produced Annotation Type*
**Capture Table Sizes for a Database Schema**"}
53==>|"SpecificationPropertyAssignment"|58
59@{ shape: hex, label: "*produced Annotation Type*
**Capture List of Table Columns**"}
53==>|"SpecificationPropertyAssignment"|59
60@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Schema Measurements**"}
53==>|"SpecificationPropertyAssignment"|60
61@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Table Sizes**"}
53==>|"SpecificationPropertyAssignment"|61
62@{ shape: hex, label: "*produced Annotation Type*
**Capture Frequent Values for Column**"}
53==>|"SpecificationPropertyAssignment"|62
63@{ shape: hex, label: "*produced Annotation Type*
**Capture List of Schemas**"}
53==>|"SpecificationPropertyAssignment"|63
64@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
52==>|"SpecificationPropertyAssignment"|64
65@{ shape: hex, label: "*supported Request Parameter*
**includeSchemaNames**"}
64==>|"SpecificationPropertyAssignment"|65
66@{ shape: hex, label: "*supported Request Parameter*
**excludeSchemaNames**"}
64==>|"SpecificationPropertyAssignment"|66
67@{ shape: hex, label: "*supported Request Parameter*
**finalAnalysisStep**"}
64==>|"SpecificationPropertyAssignment"|67
68@{ shape: hex, label: "*Property Type*
**producedGuard**"}
52==>|"SpecificationPropertyAssignment"|68
69@{ shape: hex, label: "*produced Guard*
**survey-completed**"}
68==>|"SpecificationPropertyAssignment"|69
70@{ shape: hex, label: "*produced Guard*
**survey-invalid**"}
68==>|"SpecificationPropertyAssignment"|70
71@{ shape: hex, label: "*produced Guard*
**survey-failed**"}
68==>|"SpecificationPropertyAssignment"|71
72@{ shape: hex, label: "*Property Type*
**supportedAnalysisStep**"}
52==>|"SpecificationPropertyAssignment"|72
73@{ shape: hex, label: "*supported Analysis Step*
**Check Asset**"}
72==>|"SpecificationPropertyAssignment"|73
74@{ shape: hex, label: "*supported Analysis Step*
**Profiling Associated Resources**"}
72==>|"SpecificationPropertyAssignment"|74
75@{ shape: hex, label: "*supported Analysis Step*
**Measure Resource**"}
72==>|"SpecificationPropertyAssignment"|75
76@{ shape: hex, label: "*Property Type*
**supportedActionTarget**"}
52==>|"SpecificationPropertyAssignment"|76
77@{ shape: hex, label: "*supported Action Target*
**oracleDatabase**"}
76==>|"SpecificationPropertyAssignment"|77
78@{ shape: hex, label: "*Property Type*
**producedActionTarget**"}
52==>|"SpecificationPropertyAssignment"|78
79@{ shape: hex, label: "*produced Action Target*
**surveyReport**"}
78==>|"SpecificationPropertyAssignment"|79
80@{ shape: hex, label: "*produced Action Target*
**steward**"}
78==>|"SpecificationPropertyAssignment"|80
81@{ shape: hex, label: "*produced Action Target*
**stewardAction**"}
78==>|"SpecificationPropertyAssignment"|81
82@{ shape: tag-rect, label: "*Governance Action Type*
**Catalog Resource**"}
51==>|"resource [Catalog Resource]"|82
83@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
82==>|"SpecificationPropertyAssignment"|83
84@{ shape: hex, label: "*supported Request Parameter*
**templateGUID**"}
83==>|"SpecificationPropertyAssignment"|84
85@{ shape: hex, label: "*Property Type*
**producedGuard**"}
82==>|"SpecificationPropertyAssignment"|85
86@{ shape: hex, label: "*produced Guard*
**service-failed**"}
85==>|"SpecificationPropertyAssignment"|86
87@{ shape: hex, label: "*produced Guard*
**set-up-complete**"}
85==>|"SpecificationPropertyAssignment"|87
88@{ shape: hex, label: "*produced Guard*
**missing-connector**"}
85==>|"SpecificationPropertyAssignment"|88
89@{ shape: hex, label: "*produced Guard*
**missing-asset**"}
85==>|"SpecificationPropertyAssignment"|89
90@{ shape: hex, label: "*Property Type*
**supportedActionTarget**"}
82==>|"SpecificationPropertyAssignment"|90
91@{ shape: hex, label: "*supported Action Target*
**integrationConnector**"}
90==>|"SpecificationPropertyAssignment"|91
92@{ shape: hex, label: "*Property Type*
**producedActionTarget**"}
82==>|"SpecificationPropertyAssignment"|92
93@{ shape: hex, label: "*produced Action Target*
**newAsset**"}
92==>|"SpecificationPropertyAssignment"|93
94@{ shape: tag-rect, label: "*Governance Action Type*
**Uncatalog Resource**"}
51==>|"resource [Uncatalog Resource]"|94
95@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
94==>|"SpecificationPropertyAssignment"|95
96@{ shape: hex, label: "*supported Request Parameter*
**templateGUID**"}
95==>|"SpecificationPropertyAssignment"|96
97@{ shape: hex, label: "*Property Type*
**producedGuard**"}
94==>|"SpecificationPropertyAssignment"|97
98@{ shape: hex, label: "*produced Guard*
**service-failed**"}
97==>|"SpecificationPropertyAssignment"|98
99@{ shape: hex, label: "*produced Guard*
**missing-template**"}
97==>|"SpecificationPropertyAssignment"|99
100@{ shape: hex, label: "*produced Guard*
**delete-complete**"}
97==>|"SpecificationPropertyAssignment"|100
101@{ shape: hex, label: "*produced Guard*
**set-up-complete**"}
97==>|"SpecificationPropertyAssignment"|101
102@{ shape: hex, label: "*Property Type*
**producedActionTarget**"}
94==>|"SpecificationPropertyAssignment"|102
103@{ shape: hex, label: "*produced Action Target*
**deletedAsset**"}
102==>|"SpecificationPropertyAssignment"|103
104@{ shape: tag-rect, label: "*Governance Action Type*
**Catalog Resource**"}
51==>|"resource [Catalog Resource]"|104
105@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
104==>|"SpecificationPropertyAssignment"|105
106@{ shape: hex, label: "*supported Request Parameter*
**templateGUID**"}
105==>|"SpecificationPropertyAssignment"|106
107@{ shape: hex, label: "*Property Type*
**producedGuard**"}
104==>|"SpecificationPropertyAssignment"|107
108@{ shape: hex, label: "*produced Guard*
**missing-template**"}
107==>|"SpecificationPropertyAssignment"|108
109@{ shape: hex, label: "*produced Guard*
**service-failed**"}
107==>|"SpecificationPropertyAssignment"|109
110@{ shape: hex, label: "*produced Guard*
**delete-complete**"}
107==>|"SpecificationPropertyAssignment"|110
111@{ shape: hex, label: "*produced Guard*
**set-up-complete**"}
107==>|"SpecificationPropertyAssignment"|111
112@{ shape: hex, label: "*Property Type*
**producedActionTarget**"}
104==>|"SpecificationPropertyAssignment"|112
113@{ shape: hex, label: "*produced Action Target*
**newAsset**"}
112==>|"SpecificationPropertyAssignment"|113
style 88 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 89 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 110 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 111 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 112 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 113 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 90 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 91 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 92 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 93 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 94 color:#000000, fill:#40E0D0, stroke:#000000
style 95 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 96 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 97 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 10 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 98 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 11 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 99 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 12 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 13 color:#f2d9e7, fill:#732650, stroke:#f2d9e7
style 14 color:#000000, fill:#40E0D0, stroke:#000000
style 15 color:#000000, fill:#40E0D0, stroke:#000000
style 16 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 17 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 18 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 19 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 1 color:#f2d9e7, fill:#732650, stroke:#f2d9e7
style 2 color:#f2d9e7, fill:#732650, stroke:#f2d9e7
style 3 color:#004563, fill:#b0e0e6, stroke:#004563
style 4 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 5 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 6 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 7 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 8 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 9 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 20 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 21 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 22 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 23 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 24 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 25 color:#000000, fill:#40E0D0, stroke:#000000
style 26 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 27 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 28 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 29 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 30 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 31 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 32 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 33 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 34 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 35 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 36 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 37 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 38 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 39 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 40 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 41 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 42 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 43 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 44 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 45 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 46 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 47 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 48 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 49 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 50 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 51 color:#f2d9e7, fill:#732650, stroke:#f2d9e7
style 52 color:#000000, fill:#40E0D0, stroke:#000000
style 53 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 54 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 55 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 56 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 57 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 58 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 59 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 60 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 61 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 62 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 63 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 64 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 65 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 66 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 67 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 68 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 69 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 70 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 71 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 72 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 73 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 74 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 75 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 76 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 77 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 78 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 79 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 100 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 101 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 102 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 103 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 104 color:#000000, fill:#40E0D0, stroke:#000000
style 105 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 106 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 80 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 107 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 81 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 108 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 82 color:#000000, fill:#40E0D0, stroke:#000000
style 109 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 83 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 84 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 85 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 86 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 87 color:#260d1b, fill:#d98cb6, stroke:#260d1bDb2 for Linux, UNIX and Windows¶
A Db2 JDBC connection is made to a database, so, as with Oracle, the server template takes databaseName and also passes it to the connector in the connection's databaseName configuration property.
| Template | Endpoint network address | Extra placeholders |
|---|---|---|
| Db2 for Linux, UNIX and Windows Database Server | jdbc:db2://~{hostIdentifier}~:~{portNumber}~/~{databaseName}~ |
databaseName |
| Db2 for Linux, UNIX and Windows Relational Database | jdbc:db2://~{hostIdentifier}~:~{portNumber}~/~{databaseName}~ |
databaseName, databaseDescription |
| Db2 for Linux, UNIX and Windows Relational Database Schema, Tabular Data Set Collection and Tabular Data Set | jdbc:db2://~{hostIdentifier}~:~{portNumber}~/~{databaseName}~ |
schemaName, schemaDescription (and tableName, tableDescription for a table) |
The tabular data set templates use the Db2 for Linux, UNIX and Windows Tabular Data Set Connector and Db2 for Linux, UNIX and Windows Tabular Data Set Collection Connector. The lineage-style template is for the Db2 Table technology type, with the OpenLineage namespace db2://{host}:{port} and name {database}.{schema}.{table}.
The processes are DB2LUWServer::CreateAsCatalogTarget, DB2LUWServer:CreateAndSurvey and DB2LUWServer:DeleteAsset, with matching DB2LUWDatabase and DB2LUWDatabaseSchema processes. The server cataloguer runs as DB2LUWServerCataloguer.
Technology type report for Db2 for Linux, UNIX and Windows Database Server
---
title: Technology Report for - Db2 for Linux, UNIX and Windows Database Server [74ade7ad-a333-41ea-8af0-3da43a41c4ab]
---
flowchart LR
%%{init: {"flowchart": {"htmlLabels": false}} }%%
1@{ shape: hex, label: "*Technology Type*
**Db2 for Linux, UNIX and Windows Database Server**"}
2@{ shape: hex, label: "*Technology Type*
**Catalog Templates**"}
1==>2
3@{ shape: card, label: "*Software Server*
**Db2 for Linux, UNIX and Windows Database Server template**"}
2==>|"catalog templates"|3
4@{ shape: hex, label: "*Property Type*
**placeholderProperty**"}
3==>|"SpecificationPropertyAssignment"|4
5@{ shape: hex, label: "*placeholder Property*
**secretsStorePathName**"}
4==>|"SpecificationPropertyAssignment"|5
6@{ shape: hex, label: "*placeholder Property*
**resourceName**"}
4==>|"SpecificationPropertyAssignment"|6
7@{ shape: hex, label: "*placeholder Property*
**hostIdentifier**"}
4==>|"SpecificationPropertyAssignment"|7
8@{ shape: hex, label: "*placeholder Property*
**databaseName**"}
4==>|"SpecificationPropertyAssignment"|8
9@{ shape: hex, label: "*placeholder Property*
**secretsCollectionName**"}
4==>|"SpecificationPropertyAssignment"|9
10@{ shape: hex, label: "*placeholder Property*
**serverName**"}
4==>|"SpecificationPropertyAssignment"|10
11@{ shape: hex, label: "*placeholder Property*
**description**"}
4==>|"SpecificationPropertyAssignment"|11
12@{ shape: hex, label: "*placeholder Property*
**portNumber**"}
4==>|"SpecificationPropertyAssignment"|12
13@{ shape: hex, label: "*placeholder Property*
**versionIdentifier**"}
4==>|"SpecificationPropertyAssignment"|13
14@{ shape: hex, label: "*Technology Type*
**Governance Action Processes**"}
1==>14
15@{ shape: processes, label: "*Deleting Action Process*
**Catalog Resource**"}
14==>|"governance action process [Catalog Resource]"|15
16@{ shape: processes, label: "*Cataloguing Action Process*
**Catalog Resource**"}
14==>|"governance action process [Catalog Resource]"|16
17@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
16==>|"SpecificationPropertyAssignment"|17
18@{ shape: hex, label: "*supported Request Parameter*
**serverName**"}
17==>|"SpecificationPropertyAssignment"|18
19@{ shape: hex, label: "*supported Request Parameter*
**description**"}
17==>|"SpecificationPropertyAssignment"|19
20@{ shape: hex, label: "*supported Request Parameter*
**databaseName**"}
17==>|"SpecificationPropertyAssignment"|20
21@{ shape: hex, label: "*supported Request Parameter*
**secretsCollectionName**"}
17==>|"SpecificationPropertyAssignment"|21
22@{ shape: hex, label: "*supported Request Parameter*
**hostIdentifier**"}
17==>|"SpecificationPropertyAssignment"|22
23@{ shape: hex, label: "*supported Request Parameter*
**resourceName**"}
17==>|"SpecificationPropertyAssignment"|23
24@{ shape: hex, label: "*supported Request Parameter*
**secretsStorePathName**"}
17==>|"SpecificationPropertyAssignment"|24
25@{ shape: hex, label: "*supported Request Parameter*
**versionIdentifier**"}
17==>|"SpecificationPropertyAssignment"|25
26@{ shape: hex, label: "*supported Request Parameter*
**portNumber**"}
17==>|"SpecificationPropertyAssignment"|26
27@{ shape: processes, label: "*Surveying Action Process*
**Survey Resource**"}
14==>|"governance action process [Survey Resource]"|27
28@{ shape: hex, label: "*Property Type*
**producedAnnotationType**"}
27==>|"SpecificationPropertyAssignment"|28
29@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Measurements**"}
28==>|"SpecificationPropertyAssignment"|29
30@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
27==>|"SpecificationPropertyAssignment"|30
31@{ shape: hex, label: "*supported Request Parameter*
**resourceName**"}
30==>|"SpecificationPropertyAssignment"|31
32@{ shape: hex, label: "*supported Request Parameter*
**hostIdentifier**"}
30==>|"SpecificationPropertyAssignment"|32
33@{ shape: hex, label: "*supported Request Parameter*
**serverName**"}
30==>|"SpecificationPropertyAssignment"|33
34@{ shape: hex, label: "*supported Request Parameter*
**portNumber**"}
30==>|"SpecificationPropertyAssignment"|34
35@{ shape: hex, label: "*supported Request Parameter*
**secretsCollectionName**"}
30==>|"SpecificationPropertyAssignment"|35
36@{ shape: hex, label: "*supported Request Parameter*
**secretsStorePathName**"}
30==>|"SpecificationPropertyAssignment"|36
37@{ shape: hex, label: "*supported Request Parameter*
**finalAnalysisStep**"}
30==>|"SpecificationPropertyAssignment"|37
38@{ shape: hex, label: "*supported Request Parameter*
**versionIdentifier**"}
30==>|"SpecificationPropertyAssignment"|38
39@{ shape: hex, label: "*supported Request Parameter*
**databaseName**"}
30==>|"SpecificationPropertyAssignment"|39
40@{ shape: hex, label: "*supported Request Parameter*
**description**"}
30==>|"SpecificationPropertyAssignment"|40
41@{ shape: hex, label: "*Property Type*
**supportedAnalysisStep**"}
27==>|"SpecificationPropertyAssignment"|41
42@{ shape: hex, label: "*supported Analysis Step*
**Produce Inventory**"}
41==>|"SpecificationPropertyAssignment"|42
43@{ shape: hex, label: "*supported Analysis Step*
**Profiling Associated Resources**"}
41==>|"SpecificationPropertyAssignment"|43
44@{ shape: hex, label: "*supported Analysis Step*
**Check Asset**"}
41==>|"SpecificationPropertyAssignment"|44
45@{ shape: hex, label: "*Technology Type*
**Resource List**"}
1==>45
46@{ shape: tag-rect, label: "*Governance Action Type*
**Survey Resource**"}
45==>|"resource [Survey Resource]"|46
47@{ shape: hex, label: "*Property Type*
**producedAnnotationType**"}
46==>|"SpecificationPropertyAssignment"|47
48@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Measurements**"}
47==>|"SpecificationPropertyAssignment"|48
49@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
46==>|"SpecificationPropertyAssignment"|49
50@{ shape: hex, label: "*supported Request Parameter*
**includeSchemaNames**"}
49==>|"SpecificationPropertyAssignment"|50
51@{ shape: hex, label: "*supported Request Parameter*
**finalAnalysisStep**"}
49==>|"SpecificationPropertyAssignment"|51
52@{ shape: hex, label: "*supported Request Parameter*
**excludeSchemaNames**"}
49==>|"SpecificationPropertyAssignment"|52
53@{ shape: hex, label: "*Property Type*
**producedGuard**"}
46==>|"SpecificationPropertyAssignment"|53
54@{ shape: hex, label: "*produced Guard*
**survey-invalid**"}
53==>|"SpecificationPropertyAssignment"|54
55@{ shape: hex, label: "*produced Guard*
**survey-completed**"}
53==>|"SpecificationPropertyAssignment"|55
56@{ shape: hex, label: "*produced Guard*
**survey-failed**"}
53==>|"SpecificationPropertyAssignment"|56
57@{ shape: hex, label: "*Property Type*
**supportedAnalysisStep**"}
46==>|"SpecificationPropertyAssignment"|57
58@{ shape: hex, label: "*supported Analysis Step*
**Produce Inventory**"}
57==>|"SpecificationPropertyAssignment"|58
59@{ shape: hex, label: "*supported Analysis Step*
**Profiling Associated Resources**"}
57==>|"SpecificationPropertyAssignment"|59
60@{ shape: hex, label: "*supported Analysis Step*
**Check Asset**"}
57==>|"SpecificationPropertyAssignment"|60
61@{ shape: hex, label: "*Property Type*
**producedActionTarget**"}
46==>|"SpecificationPropertyAssignment"|61
62@{ shape: hex, label: "*produced Action Target*
**stewardAction**"}
61==>|"SpecificationPropertyAssignment"|62
63@{ shape: hex, label: "*produced Action Target*
**surveyReport**"}
61==>|"SpecificationPropertyAssignment"|63
64@{ shape: hex, label: "*produced Action Target*
**steward**"}
61==>|"SpecificationPropertyAssignment"|64
65@{ shape: hex, label: "*Property Type*
**supportedActionTarget**"}
46==>|"SpecificationPropertyAssignment"|65
66@{ shape: hex, label: "*supported Action Target*
**db2luwServer**"}
65==>|"SpecificationPropertyAssignment"|66
67@{ shape: tag-rect, label: "*Governance Action Type*
**Catalog Resource**"}
45==>|"resource [Catalog Resource]"|67
68@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
67==>|"SpecificationPropertyAssignment"|68
69@{ shape: hex, label: "*supported Request Parameter*
**templateGUID**"}
68==>|"SpecificationPropertyAssignment"|69
70@{ shape: hex, label: "*Property Type*
**producedGuard**"}
67==>|"SpecificationPropertyAssignment"|70
71@{ shape: hex, label: "*produced Guard*
**missing-asset**"}
70==>|"SpecificationPropertyAssignment"|71
72@{ shape: hex, label: "*produced Guard*
**service-failed**"}
70==>|"SpecificationPropertyAssignment"|72
73@{ shape: hex, label: "*produced Guard*
**set-up-complete**"}
70==>|"SpecificationPropertyAssignment"|73
74@{ shape: hex, label: "*produced Guard*
**missing-connector**"}
70==>|"SpecificationPropertyAssignment"|74
75@{ shape: hex, label: "*Property Type*
**supportedActionTarget**"}
67==>|"SpecificationPropertyAssignment"|75
76@{ shape: hex, label: "*supported Action Target*
**integrationConnector**"}
75==>|"SpecificationPropertyAssignment"|76
77@{ shape: hex, label: "*Property Type*
**producedActionTarget**"}
67==>|"SpecificationPropertyAssignment"|77
78@{ shape: hex, label: "*produced Action Target*
**newAsset**"}
77==>|"SpecificationPropertyAssignment"|78
79@{ shape: tag-rect, label: "*Governance Action Type*
**Catalog Resource**"}
45==>|"resource [Catalog Resource]"|79
80@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
79==>|"SpecificationPropertyAssignment"|80
81@{ shape: hex, label: "*supported Request Parameter*
**templateGUID**"}
80==>|"SpecificationPropertyAssignment"|81
82@{ shape: hex, label: "*Property Type*
**producedGuard**"}
79==>|"SpecificationPropertyAssignment"|82
83@{ shape: hex, label: "*produced Guard*
**missing-template**"}
82==>|"SpecificationPropertyAssignment"|83
84@{ shape: hex, label: "*produced Guard*
**service-failed**"}
82==>|"SpecificationPropertyAssignment"|84
85@{ shape: hex, label: "*produced Guard*
**delete-complete**"}
82==>|"SpecificationPropertyAssignment"|85
86@{ shape: hex, label: "*produced Guard*
**set-up-complete**"}
82==>|"SpecificationPropertyAssignment"|86
87@{ shape: hex, label: "*Property Type*
**producedActionTarget**"}
79==>|"SpecificationPropertyAssignment"|87
88@{ shape: hex, label: "*produced Action Target*
**newAsset**"}
87==>|"SpecificationPropertyAssignment"|88
89@{ shape: stadium, label: "*Integration Connector*
**Catalog Resource**"}
45==>|"resource [Catalog Resource]"|89
90@{ shape: hex, label: "*Property Type*
**supportedConfigurationProperty**"}
89==>|"SpecificationPropertyAssignment"|90
91@{ shape: hex, label: "*supported Configuration Property*
**hostIdentifier**"}
90==>|"SpecificationPropertyAssignment"|91
92@{ shape: hex, label: "*supported Configuration Property*
**serverName**"}
90==>|"SpecificationPropertyAssignment"|92
93@{ shape: hex, label: "*supported Configuration Property*
**excludeDatabaseList**"}
90==>|"SpecificationPropertyAssignment"|93
94@{ shape: hex, label: "*supported Configuration Property*
**databasePassword**"}
90==>|"SpecificationPropertyAssignment"|94
95@{ shape: hex, label: "*supported Configuration Property*
**portNumber**"}
90==>|"SpecificationPropertyAssignment"|95
96@{ shape: hex, label: "*supported Configuration Property*
**includeDatabaseList**"}
90==>|"SpecificationPropertyAssignment"|96
97@{ shape: hex, label: "*supported Configuration Property*
**DB2LUWFriendshipGUID**"}
90==>|"SpecificationPropertyAssignment"|97
98@{ shape: hex, label: "*supported Configuration Property*
**databaseUserId**"}
90==>|"SpecificationPropertyAssignment"|98
99@{ shape: tag-rect, label: "*Governance Action Type*
**Uncatalog Resource**"}
45==>|"resource [Uncatalog Resource]"|99
100@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
99==>|"SpecificationPropertyAssignment"|100
101@{ shape: hex, label: "*supported Request Parameter*
**templateGUID**"}
100==>|"SpecificationPropertyAssignment"|101
102@{ shape: hex, label: "*Property Type*
**producedGuard**"}
99==>|"SpecificationPropertyAssignment"|102
103@{ shape: hex, label: "*produced Guard*
**set-up-complete**"}
102==>|"SpecificationPropertyAssignment"|103
104@{ shape: hex, label: "*produced Guard*
**missing-template**"}
102==>|"SpecificationPropertyAssignment"|104
105@{ shape: hex, label: "*produced Guard*
**delete-complete**"}
102==>|"SpecificationPropertyAssignment"|105
106@{ shape: hex, label: "*produced Guard*
**service-failed**"}
102==>|"SpecificationPropertyAssignment"|106
107@{ shape: hex, label: "*Property Type*
**producedActionTarget**"}
99==>|"SpecificationPropertyAssignment"|107
108@{ shape: hex, label: "*produced Action Target*
**deletedAsset**"}
107==>|"SpecificationPropertyAssignment"|108
style 88 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 89 color:#000000, fill:#BDB76B, stroke:#004563
style 90 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 91 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 92 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 93 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 94 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 95 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 96 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 97 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 10 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 98 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 11 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 99 color:#000000, fill:#40E0D0, stroke:#000000
style 12 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 13 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 14 color:#f2d9e7, fill:#732650, stroke:#f2d9e7
style 15 color:#000000, fill:#40E0D0, stroke:#000000
style 16 color:#000000, fill:#40E0D0, stroke:#000000
style 17 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 18 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 19 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 1 color:#f2d9e7, fill:#732650, stroke:#f2d9e7
style 2 color:#f2d9e7, fill:#732650, stroke:#f2d9e7
style 3 color:#004563, fill:#b0e0e6, stroke:#004563
style 4 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 5 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 6 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 7 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 8 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 9 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 20 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 21 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 22 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 23 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 24 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 25 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 26 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 27 color:#000000, fill:#40E0D0, stroke:#000000
style 28 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 29 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 30 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 31 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 32 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 33 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 34 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 35 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 36 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 37 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 38 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 39 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 40 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 41 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 42 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 43 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 44 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 45 color:#f2d9e7, fill:#732650, stroke:#f2d9e7
style 46 color:#000000, fill:#40E0D0, stroke:#000000
style 47 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 48 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 49 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 50 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 51 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 52 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 53 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 54 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 55 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 56 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 57 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 58 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 59 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 60 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 61 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 62 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 63 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 64 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 65 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 66 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 67 color:#000000, fill:#40E0D0, stroke:#000000
style 68 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 69 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 70 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 71 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 72 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 73 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 74 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 75 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 76 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 77 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 78 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 79 color:#000000, fill:#40E0D0, stroke:#000000
style 100 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 101 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 102 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 103 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 104 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 105 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 106 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 80 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 107 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 81 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 108 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 82 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 83 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 84 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 85 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 86 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 87 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7Technology type report for Db2 for Linux, UNIX and Windows Relational Database
---
title: Technology Report for - Db2 for Linux, UNIX and Windows Relational Database [5c664f10-5c6e-4787-b140-19b9a192596c]
---
flowchart LR
%%{init: {"flowchart": {"htmlLabels": false}} }%%
1@{ shape: hex, label: "*Technology Type*
**Db2 for Linux, UNIX and Windows Relational Database**"}
2@{ shape: hex, label: "*Technology Type*
**Catalog Templates**"}
1==>2
3@{ shape: card, label: "*Relational Database*
**Db2 for Linux, UNIX and Windows Relational Database template**"}
2==>|"catalog templates"|3
4@{ shape: hex, label: "*Property Type*
**placeholderProperty**"}
3==>|"SpecificationPropertyAssignment"|4
5@{ shape: hex, label: "*placeholder Property*
**databaseName**"}
4==>|"SpecificationPropertyAssignment"|5
6@{ shape: hex, label: "*placeholder Property*
**portNumber**"}
4==>|"SpecificationPropertyAssignment"|6
7@{ shape: hex, label: "*placeholder Property*
**versionIdentifier**"}
4==>|"SpecificationPropertyAssignment"|7
8@{ shape: hex, label: "*placeholder Property*
**secretsCollectionName**"}
4==>|"SpecificationPropertyAssignment"|8
9@{ shape: hex, label: "*placeholder Property*
**hostIdentifier**"}
4==>|"SpecificationPropertyAssignment"|9
10@{ shape: hex, label: "*placeholder Property*
**secretsStorePathName**"}
4==>|"SpecificationPropertyAssignment"|10
11@{ shape: hex, label: "*placeholder Property*
**serverName**"}
4==>|"SpecificationPropertyAssignment"|11
12@{ shape: hex, label: "*placeholder Property*
**databaseDescription**"}
4==>|"SpecificationPropertyAssignment"|12
13@{ shape: hex, label: "*Technology Type*
**Governance Action Processes**"}
1==>13
14@{ shape: processes, label: "*Surveying Action Process*
**Survey Resource**"}
13==>|"governance action process [Survey Resource]"|14
15@{ shape: hex, label: "*Property Type*
**producedAnnotationType**"}
14==>|"SpecificationPropertyAssignment"|15
16@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Measurements**"}
15==>|"SpecificationPropertyAssignment"|16
17@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Schema Measurements**"}
15==>|"SpecificationPropertyAssignment"|17
18@{ shape: hex, label: "*produced Annotation Type*
**Capture List of Schemas**"}
15==>|"SpecificationPropertyAssignment"|18
19@{ shape: hex, label: "*produced Annotation Type*
**Capture List of Table Columns**"}
15==>|"SpecificationPropertyAssignment"|19
20@{ shape: hex, label: "*produced Annotation Type*
**Capture List of Tables**"}
15==>|"SpecificationPropertyAssignment"|20
21@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Table Sizes**"}
15==>|"SpecificationPropertyAssignment"|21
22@{ shape: hex, label: "*produced Annotation Type*
**Capture Table Sizes for a Database Schema**"}
15==>|"SpecificationPropertyAssignment"|22
23@{ shape: hex, label: "*produced Annotation Type*
**Capture Frequent Values for Column**"}
15==>|"SpecificationPropertyAssignment"|23
24@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Table Measurements**"}
15==>|"SpecificationPropertyAssignment"|24
25@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Column Measurements**"}
15==>|"SpecificationPropertyAssignment"|25
26@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
14==>|"SpecificationPropertyAssignment"|26
27@{ shape: hex, label: "*supported Request Parameter*
**secretsCollectionName**"}
26==>|"SpecificationPropertyAssignment"|27
28@{ shape: hex, label: "*supported Request Parameter*
**versionIdentifier**"}
26==>|"SpecificationPropertyAssignment"|28
29@{ shape: hex, label: "*supported Request Parameter*
**databaseName**"}
26==>|"SpecificationPropertyAssignment"|29
30@{ shape: hex, label: "*supported Request Parameter*
**hostIdentifier**"}
26==>|"SpecificationPropertyAssignment"|30
31@{ shape: hex, label: "*supported Request Parameter*
**portNumber**"}
26==>|"SpecificationPropertyAssignment"|31
32@{ shape: hex, label: "*supported Request Parameter*
**secretsStorePathName**"}
26==>|"SpecificationPropertyAssignment"|32
33@{ shape: hex, label: "*supported Request Parameter*
**databaseDescription**"}
26==>|"SpecificationPropertyAssignment"|33
34@{ shape: hex, label: "*supported Request Parameter*
**finalAnalysisStep**"}
26==>|"SpecificationPropertyAssignment"|34
35@{ shape: hex, label: "*supported Request Parameter*
**serverName**"}
26==>|"SpecificationPropertyAssignment"|35
36@{ shape: hex, label: "*Property Type*
**supportedAnalysisStep**"}
14==>|"SpecificationPropertyAssignment"|36
37@{ shape: hex, label: "*supported Analysis Step*
**Measure Resource**"}
36==>|"SpecificationPropertyAssignment"|37
38@{ shape: hex, label: "*supported Analysis Step*
**Profiling Associated Resources**"}
36==>|"SpecificationPropertyAssignment"|38
39@{ shape: hex, label: "*supported Analysis Step*
**Check Asset**"}
36==>|"SpecificationPropertyAssignment"|39
40@{ shape: processes, label: "*Cataloguing Action Process*
**Catalog Resource**"}
13==>|"governance action process [Catalog Resource]"|40
41@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
40==>|"SpecificationPropertyAssignment"|41
42@{ shape: hex, label: "*supported Request Parameter*
**secretsStorePathName**"}
41==>|"SpecificationPropertyAssignment"|42
43@{ shape: hex, label: "*supported Request Parameter*
**hostIdentifier**"}
41==>|"SpecificationPropertyAssignment"|43
44@{ shape: hex, label: "*supported Request Parameter*
**databaseName**"}
41==>|"SpecificationPropertyAssignment"|44
45@{ shape: hex, label: "*supported Request Parameter*
**secretsCollectionName**"}
41==>|"SpecificationPropertyAssignment"|45
46@{ shape: hex, label: "*supported Request Parameter*
**versionIdentifier**"}
41==>|"SpecificationPropertyAssignment"|46
47@{ shape: hex, label: "*supported Request Parameter*
**serverName**"}
41==>|"SpecificationPropertyAssignment"|47
48@{ shape: hex, label: "*supported Request Parameter*
**databaseDescription**"}
41==>|"SpecificationPropertyAssignment"|48
49@{ shape: hex, label: "*supported Request Parameter*
**portNumber**"}
41==>|"SpecificationPropertyAssignment"|49
50@{ shape: processes, label: "*Deleting Action Process*
**Catalog Resource**"}
13==>|"governance action process [Catalog Resource]"|50
51@{ shape: hex, label: "*Technology Type*
**Resource List**"}
1==>51
52@{ shape: tag-rect, label: "*Governance Action Type*
**Catalog Resource**"}
51==>|"resource [Catalog Resource]"|52
53@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
52==>|"SpecificationPropertyAssignment"|53
54@{ shape: hex, label: "*supported Request Parameter*
**templateGUID**"}
53==>|"SpecificationPropertyAssignment"|54
55@{ shape: hex, label: "*Property Type*
**producedGuard**"}
52==>|"SpecificationPropertyAssignment"|55
56@{ shape: hex, label: "*produced Guard*
**service-failed**"}
55==>|"SpecificationPropertyAssignment"|56
57@{ shape: hex, label: "*produced Guard*
**missing-connector**"}
55==>|"SpecificationPropertyAssignment"|57
58@{ shape: hex, label: "*produced Guard*
**set-up-complete**"}
55==>|"SpecificationPropertyAssignment"|58
59@{ shape: hex, label: "*produced Guard*
**missing-asset**"}
55==>|"SpecificationPropertyAssignment"|59
60@{ shape: hex, label: "*Property Type*
**producedActionTarget**"}
52==>|"SpecificationPropertyAssignment"|60
61@{ shape: hex, label: "*produced Action Target*
**newAsset**"}
60==>|"SpecificationPropertyAssignment"|61
62@{ shape: hex, label: "*Property Type*
**supportedActionTarget**"}
52==>|"SpecificationPropertyAssignment"|62
63@{ shape: hex, label: "*supported Action Target*
**integrationConnector**"}
62==>|"SpecificationPropertyAssignment"|63
64@{ shape: tag-rect, label: "*Governance Action Type*
**Uncatalog Resource**"}
51==>|"resource [Uncatalog Resource]"|64
65@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
64==>|"SpecificationPropertyAssignment"|65
66@{ shape: hex, label: "*supported Request Parameter*
**templateGUID**"}
65==>|"SpecificationPropertyAssignment"|66
67@{ shape: hex, label: "*Property Type*
**producedGuard**"}
64==>|"SpecificationPropertyAssignment"|67
68@{ shape: hex, label: "*produced Guard*
**service-failed**"}
67==>|"SpecificationPropertyAssignment"|68
69@{ shape: hex, label: "*produced Guard*
**set-up-complete**"}
67==>|"SpecificationPropertyAssignment"|69
70@{ shape: hex, label: "*produced Guard*
**delete-complete**"}
67==>|"SpecificationPropertyAssignment"|70
71@{ shape: hex, label: "*produced Guard*
**missing-template**"}
67==>|"SpecificationPropertyAssignment"|71
72@{ shape: hex, label: "*Property Type*
**producedActionTarget**"}
64==>|"SpecificationPropertyAssignment"|72
73@{ shape: hex, label: "*produced Action Target*
**deletedAsset**"}
72==>|"SpecificationPropertyAssignment"|73
74@{ shape: tag-rect, label: "*Governance Action Type*
**Catalog Resource**"}
51==>|"resource [Catalog Resource]"|74
75@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
74==>|"SpecificationPropertyAssignment"|75
76@{ shape: hex, label: "*supported Request Parameter*
**templateGUID**"}
75==>|"SpecificationPropertyAssignment"|76
77@{ shape: hex, label: "*Property Type*
**producedGuard**"}
74==>|"SpecificationPropertyAssignment"|77
78@{ shape: hex, label: "*produced Guard*
**missing-template**"}
77==>|"SpecificationPropertyAssignment"|78
79@{ shape: hex, label: "*produced Guard*
**set-up-complete**"}
77==>|"SpecificationPropertyAssignment"|79
80@{ shape: hex, label: "*produced Guard*
**service-failed**"}
77==>|"SpecificationPropertyAssignment"|80
81@{ shape: hex, label: "*produced Guard*
**delete-complete**"}
77==>|"SpecificationPropertyAssignment"|81
82@{ shape: hex, label: "*Property Type*
**producedActionTarget**"}
74==>|"SpecificationPropertyAssignment"|82
83@{ shape: hex, label: "*produced Action Target*
**newAsset**"}
82==>|"SpecificationPropertyAssignment"|83
84@{ shape: tag-rect, label: "*Governance Action Type*
**Survey Resource**"}
51==>|"resource [Survey Resource]"|84
85@{ shape: hex, label: "*Property Type*
**producedAnnotationType**"}
84==>|"SpecificationPropertyAssignment"|85
86@{ shape: hex, label: "*produced Annotation Type*
**Capture Table Sizes for a Database Schema**"}
85==>|"SpecificationPropertyAssignment"|86
87@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Column Measurements**"}
85==>|"SpecificationPropertyAssignment"|87
88@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Table Measurements**"}
85==>|"SpecificationPropertyAssignment"|88
89@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Measurements**"}
85==>|"SpecificationPropertyAssignment"|89
90@{ shape: hex, label: "*produced Annotation Type*
**Capture List of Table Columns**"}
85==>|"SpecificationPropertyAssignment"|90
91@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Table Sizes**"}
85==>|"SpecificationPropertyAssignment"|91
92@{ shape: hex, label: "*produced Annotation Type*
**Capture List of Schemas**"}
85==>|"SpecificationPropertyAssignment"|92
93@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Schema Measurements**"}
85==>|"SpecificationPropertyAssignment"|93
94@{ shape: hex, label: "*produced Annotation Type*
**Capture List of Tables**"}
85==>|"SpecificationPropertyAssignment"|94
95@{ shape: hex, label: "*produced Annotation Type*
**Capture Frequent Values for Column**"}
85==>|"SpecificationPropertyAssignment"|95
96@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
84==>|"SpecificationPropertyAssignment"|96
97@{ shape: hex, label: "*supported Request Parameter*
**finalAnalysisStep**"}
96==>|"SpecificationPropertyAssignment"|97
98@{ shape: hex, label: "*supported Request Parameter*
**excludeSchemaNames**"}
96==>|"SpecificationPropertyAssignment"|98
99@{ shape: hex, label: "*supported Request Parameter*
**includeSchemaNames**"}
96==>|"SpecificationPropertyAssignment"|99
100@{ shape: hex, label: "*Property Type*
**producedGuard**"}
84==>|"SpecificationPropertyAssignment"|100
101@{ shape: hex, label: "*produced Guard*
**survey-invalid**"}
100==>|"SpecificationPropertyAssignment"|101
102@{ shape: hex, label: "*produced Guard*
**survey-completed**"}
100==>|"SpecificationPropertyAssignment"|102
103@{ shape: hex, label: "*produced Guard*
**survey-failed**"}
100==>|"SpecificationPropertyAssignment"|103
104@{ shape: hex, label: "*Property Type*
**supportedAnalysisStep**"}
84==>|"SpecificationPropertyAssignment"|104
105@{ shape: hex, label: "*supported Analysis Step*
**Check Asset**"}
104==>|"SpecificationPropertyAssignment"|105
106@{ shape: hex, label: "*supported Analysis Step*
**Measure Resource**"}
104==>|"SpecificationPropertyAssignment"|106
107@{ shape: hex, label: "*supported Analysis Step*
**Profiling Associated Resources**"}
104==>|"SpecificationPropertyAssignment"|107
108@{ shape: hex, label: "*Property Type*
**producedActionTarget**"}
84==>|"SpecificationPropertyAssignment"|108
109@{ shape: hex, label: "*produced Action Target*
**steward**"}
108==>|"SpecificationPropertyAssignment"|109
110@{ shape: hex, label: "*produced Action Target*
**stewardAction**"}
108==>|"SpecificationPropertyAssignment"|110
111@{ shape: hex, label: "*produced Action Target*
**surveyReport**"}
108==>|"SpecificationPropertyAssignment"|111
112@{ shape: hex, label: "*Property Type*
**supportedActionTarget**"}
84==>|"SpecificationPropertyAssignment"|112
113@{ shape: hex, label: "*supported Action Target*
**db2luwDatabase**"}
112==>|"SpecificationPropertyAssignment"|113
style 88 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 89 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 110 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 111 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 112 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 113 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 90 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 91 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 92 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 93 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 94 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 95 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 96 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 97 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 10 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 98 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 11 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 99 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 12 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 13 color:#f2d9e7, fill:#732650, stroke:#f2d9e7
style 14 color:#000000, fill:#40E0D0, stroke:#000000
style 15 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 16 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 17 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 18 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 19 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 1 color:#f2d9e7, fill:#732650, stroke:#f2d9e7
style 2 color:#f2d9e7, fill:#732650, stroke:#f2d9e7
style 3 color:#004563, fill:#b0e0e6, stroke:#004563
style 4 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 5 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 6 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 7 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 8 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 9 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 20 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 21 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 22 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 23 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 24 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 25 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 26 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 27 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 28 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 29 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 30 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 31 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 32 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 33 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 34 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 35 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 36 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 37 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 38 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 39 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 40 color:#000000, fill:#40E0D0, stroke:#000000
style 41 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 42 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 43 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 44 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 45 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 46 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 47 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 48 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 49 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 50 color:#000000, fill:#40E0D0, stroke:#000000
style 51 color:#f2d9e7, fill:#732650, stroke:#f2d9e7
style 52 color:#000000, fill:#40E0D0, stroke:#000000
style 53 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 54 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 55 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 56 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 57 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 58 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 59 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 60 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 61 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 62 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 63 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 64 color:#000000, fill:#40E0D0, stroke:#000000
style 65 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 66 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 67 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 68 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 69 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 70 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 71 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 72 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 73 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 74 color:#000000, fill:#40E0D0, stroke:#000000
style 75 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 76 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 77 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 78 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 79 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 100 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 101 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 102 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 103 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 104 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 105 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 106 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 80 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 107 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 81 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 108 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 82 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 109 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 83 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 84 color:#000000, fill:#40E0D0, stroke:#000000
style 85 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 86 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 87 color:#260d1b, fill:#d98cb6, stroke:#260d1bDuckDB¶
DuckDB is an embedded database: it runs inside the process that opens it, and a database is a file (or an in-memory session). So the DuckDB Content Pack has no server template, and only two templates in all.
| Technology type | Template creates | Qualified name pattern | Endpoint network address |
|---|---|---|---|
| DuckDB Relational Database | RelationalDatabase with an endpoint and a connection | DuckDB Relational Database::~{databasePath}~ |
jdbc:duckdb:~{databasePath}~ |
| DuckDB Relational Database Schema | DeployedDatabaseSchema with an endpoint and a connection | DuckDB Relational Database Schema::~{databasePath}~::~{schemaName}~ |
jdbc:duckdb:~{databasePath}~ |
databasePath is the path of the DuckDB database file, or the literal value :memory: for an in-memory session; it takes the place of serverName in the qualified names. databaseName is still used for the display names and the connection's configuration properties. The connections name the same JDBC connector and embed a secrets store connection, like the other packs. There are no tabular data set or lineage-style templates for DuckDB.
The processes are DuckDBDatabase::CreateAsCatalogTarget, DuckDBDatabase:CreateAndSurvey and DuckDBDatabase:DeleteAsset, with DuckDBDatabaseSchema::CreateAsCatalogTarget and DuckDBDatabaseSchema:DeleteAsset for schemas. The database cataloguer runs as DuckDBDatabaseCataloguer.
Technology type report for DuckDB Relational Database
---
title: Technology Report for - DuckDB Relational Database [07e91e40-adce-4c66-b34d-9d00cba1c783]
---
flowchart LR
%%{init: {"flowchart": {"htmlLabels": false}} }%%
1@{ shape: hex, label: "*Technology Type*
**DuckDB Relational Database**"}
2@{ shape: hex, label: "*Technology Type*
**Catalog Templates**"}
1==>2
3@{ shape: card, label: "*Relational Database*
**DuckDB Relational Database template**"}
2==>|"catalog templates"|3
4@{ shape: hex, label: "*Property Type*
**placeholderProperty**"}
3==>|"SpecificationPropertyAssignment"|4
5@{ shape: hex, label: "*placeholder Property*
**databaseName**"}
4==>|"SpecificationPropertyAssignment"|5
6@{ shape: hex, label: "*placeholder Property*
**versionIdentifier**"}
4==>|"SpecificationPropertyAssignment"|6
7@{ shape: hex, label: "*placeholder Property*
**secretsStorePathName**"}
4==>|"SpecificationPropertyAssignment"|7
8@{ shape: hex, label: "*placeholder Property*
**databaseDescription**"}
4==>|"SpecificationPropertyAssignment"|8
9@{ shape: hex, label: "*placeholder Property*
**secretsCollectionName**"}
4==>|"SpecificationPropertyAssignment"|9
10@{ shape: hex, label: "*placeholder Property*
**databasePath**"}
4==>|"SpecificationPropertyAssignment"|10
11@{ shape: hex, label: "*Technology Type*
**Governance Action Processes**"}
1==>11
12@{ shape: processes, label: "*Surveying Action Process*
**Survey Resource**"}
11==>|"governance action process [Survey Resource]"|12
13@{ shape: hex, label: "*Property Type*
**producedAnnotationType**"}
12==>|"SpecificationPropertyAssignment"|13
14@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Table Sizes**"}
13==>|"SpecificationPropertyAssignment"|14
15@{ shape: hex, label: "*produced Annotation Type*
**Capture Frequent Values for Column**"}
13==>|"SpecificationPropertyAssignment"|15
16@{ shape: hex, label: "*produced Annotation Type*
**Capture List of Tables**"}
13==>|"SpecificationPropertyAssignment"|16
17@{ shape: hex, label: "*produced Annotation Type*
**Capture Table Sizes for a Database Schema**"}
13==>|"SpecificationPropertyAssignment"|17
18@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Schema Measurements**"}
13==>|"SpecificationPropertyAssignment"|18
19@{ shape: hex, label: "*produced Annotation Type*
**Capture External File Data Source**"}
13==>|"SpecificationPropertyAssignment"|19
20@{ shape: hex, label: "*produced Annotation Type*
**Capture Attached Data Source**"}
13==>|"SpecificationPropertyAssignment"|20
21@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Column Measurements**"}
13==>|"SpecificationPropertyAssignment"|21
22@{ shape: hex, label: "*produced Annotation Type*
**Capture List of Schemas**"}
13==>|"SpecificationPropertyAssignment"|22
23@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Table Measurements**"}
13==>|"SpecificationPropertyAssignment"|23
24@{ shape: hex, label: "*produced Annotation Type*
**Capture List of Table Columns**"}
13==>|"SpecificationPropertyAssignment"|24
25@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Measurements**"}
13==>|"SpecificationPropertyAssignment"|25
26@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
12==>|"SpecificationPropertyAssignment"|26
27@{ shape: hex, label: "*supported Request Parameter*
**secretsCollectionName**"}
26==>|"SpecificationPropertyAssignment"|27
28@{ shape: hex, label: "*supported Request Parameter*
**versionIdentifier**"}
26==>|"SpecificationPropertyAssignment"|28
29@{ shape: hex, label: "*supported Request Parameter*
**databaseName**"}
26==>|"SpecificationPropertyAssignment"|29
30@{ shape: hex, label: "*supported Request Parameter*
**databasePath**"}
26==>|"SpecificationPropertyAssignment"|30
31@{ shape: hex, label: "*supported Request Parameter*
**databaseDescription**"}
26==>|"SpecificationPropertyAssignment"|31
32@{ shape: hex, label: "*supported Request Parameter*
**secretsStorePathName**"}
26==>|"SpecificationPropertyAssignment"|32
33@{ shape: hex, label: "*supported Request Parameter*
**finalAnalysisStep**"}
26==>|"SpecificationPropertyAssignment"|33
34@{ shape: hex, label: "*Property Type*
**supportedAnalysisStep**"}
12==>|"SpecificationPropertyAssignment"|34
35@{ shape: hex, label: "*supported Analysis Step*
**Measure Resource**"}
34==>|"SpecificationPropertyAssignment"|35
36@{ shape: hex, label: "*supported Analysis Step*
**Profiling Associated Resources**"}
34==>|"SpecificationPropertyAssignment"|36
37@{ shape: hex, label: "*supported Analysis Step*
**Check Asset**"}
34==>|"SpecificationPropertyAssignment"|37
38@{ shape: processes, label: "*Cataloguing Action Process*
**Catalog Resource**"}
11==>|"governance action process [Catalog Resource]"|38
39@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
38==>|"SpecificationPropertyAssignment"|39
40@{ shape: hex, label: "*supported Request Parameter*
**secretsStorePathName**"}
39==>|"SpecificationPropertyAssignment"|40
41@{ shape: hex, label: "*supported Request Parameter*
**databaseDescription**"}
39==>|"SpecificationPropertyAssignment"|41
42@{ shape: hex, label: "*supported Request Parameter*
**databaseName**"}
39==>|"SpecificationPropertyAssignment"|42
43@{ shape: hex, label: "*supported Request Parameter*
**databasePath**"}
39==>|"SpecificationPropertyAssignment"|43
44@{ shape: hex, label: "*supported Request Parameter*
**versionIdentifier**"}
39==>|"SpecificationPropertyAssignment"|44
45@{ shape: hex, label: "*supported Request Parameter*
**secretsCollectionName**"}
39==>|"SpecificationPropertyAssignment"|45
46@{ shape: processes, label: "*Deleting Action Process*
**Catalog Resource**"}
11==>|"governance action process [Catalog Resource]"|46
47@{ shape: hex, label: "*Technology Type*
**Resource List**"}
1==>47
48@{ shape: stadium, label: "*Integration Connector*
**Catalog Resource**"}
47==>|"resource [Catalog Resource]"|48
49@{ shape: hex, label: "*Property Type*
**supportedConfigurationProperty**"}
48==>|"SpecificationPropertyAssignment"|49
50@{ shape: hex, label: "*supported Configuration Property*
**canonicalMountPoint**"}
49==>|"SpecificationPropertyAssignment"|50
51@{ shape: hex, label: "*supported Configuration Property*
**fileSystemName**"}
49==>|"SpecificationPropertyAssignment"|51
52@{ shape: hex, label: "*supported Configuration Property*
**databaseUserId**"}
49==>|"SpecificationPropertyAssignment"|52
53@{ shape: hex, label: "*supported Configuration Property*
**DuckDBFriendshipGUID**"}
49==>|"SpecificationPropertyAssignment"|53
54@{ shape: hex, label: "*supported Configuration Property*
**databaseName**"}
49==>|"SpecificationPropertyAssignment"|54
55@{ shape: hex, label: "*supported Configuration Property*
**databasePath**"}
49==>|"SpecificationPropertyAssignment"|55
56@{ shape: hex, label: "*supported Configuration Property*
**localMountPoint**"}
49==>|"SpecificationPropertyAssignment"|56
57@{ shape: hex, label: "*supported Configuration Property*
**databasePassword**"}
49==>|"SpecificationPropertyAssignment"|57
58@{ shape: hex, label: "*supported Configuration Property*
**attachStatements**"}
49==>|"SpecificationPropertyAssignment"|58
59@{ shape: tag-rect, label: "*Governance Action Type*
**Catalog Resource**"}
47==>|"resource [Catalog Resource]"|59
60@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
59==>|"SpecificationPropertyAssignment"|60
61@{ shape: hex, label: "*supported Request Parameter*
**templateGUID**"}
60==>|"SpecificationPropertyAssignment"|61
62@{ shape: hex, label: "*Property Type*
**producedGuard**"}
59==>|"SpecificationPropertyAssignment"|62
63@{ shape: hex, label: "*produced Guard*
**service-failed**"}
62==>|"SpecificationPropertyAssignment"|63
64@{ shape: hex, label: "*produced Guard*
**missing-template**"}
62==>|"SpecificationPropertyAssignment"|64
65@{ shape: hex, label: "*produced Guard*
**delete-complete**"}
62==>|"SpecificationPropertyAssignment"|65
66@{ shape: hex, label: "*produced Guard*
**set-up-complete**"}
62==>|"SpecificationPropertyAssignment"|66
67@{ shape: hex, label: "*Property Type*
**producedActionTarget**"}
59==>|"SpecificationPropertyAssignment"|67
68@{ shape: hex, label: "*produced Action Target*
**newAsset**"}
67==>|"SpecificationPropertyAssignment"|68
69@{ shape: tag-rect, label: "*Governance Action Type*
**Survey Resource**"}
47==>|"resource [Survey Resource]"|69
70@{ shape: hex, label: "*Property Type*
**producedAnnotationType**"}
69==>|"SpecificationPropertyAssignment"|70
71@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Table Measurements**"}
70==>|"SpecificationPropertyAssignment"|71
72@{ shape: hex, label: "*produced Annotation Type*
**Capture List of Tables**"}
70==>|"SpecificationPropertyAssignment"|72
73@{ shape: hex, label: "*produced Annotation Type*
**Capture List of Table Columns**"}
70==>|"SpecificationPropertyAssignment"|73
74@{ shape: hex, label: "*produced Annotation Type*
**Capture Frequent Values for Column**"}
70==>|"SpecificationPropertyAssignment"|74
75@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Measurements**"}
70==>|"SpecificationPropertyAssignment"|75
76@{ shape: hex, label: "*produced Annotation Type*
**Capture Attached Data Source**"}
70==>|"SpecificationPropertyAssignment"|76
77@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Column Measurements**"}
70==>|"SpecificationPropertyAssignment"|77
78@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Table Sizes**"}
70==>|"SpecificationPropertyAssignment"|78
79@{ shape: hex, label: "*produced Annotation Type*
**Capture List of Schemas**"}
70==>|"SpecificationPropertyAssignment"|79
80@{ shape: hex, label: "*produced Annotation Type*
**Capture External File Data Source**"}
70==>|"SpecificationPropertyAssignment"|80
81@{ shape: hex, label: "*produced Annotation Type*
**Capture Table Sizes for a Database Schema**"}
70==>|"SpecificationPropertyAssignment"|81
82@{ shape: hex, label: "*produced Annotation Type*
**Capture Database Schema Measurements**"}
70==>|"SpecificationPropertyAssignment"|82
83@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
69==>|"SpecificationPropertyAssignment"|83
84@{ shape: hex, label: "*supported Request Parameter*
**includeSchemaNames**"}
83==>|"SpecificationPropertyAssignment"|84
85@{ shape: hex, label: "*supported Request Parameter*
**finalAnalysisStep**"}
83==>|"SpecificationPropertyAssignment"|85
86@{ shape: hex, label: "*supported Request Parameter*
**excludeSchemaNames**"}
83==>|"SpecificationPropertyAssignment"|86
87@{ shape: hex, label: "*Property Type*
**producedGuard**"}
69==>|"SpecificationPropertyAssignment"|87
88@{ shape: hex, label: "*produced Guard*
**survey-failed**"}
87==>|"SpecificationPropertyAssignment"|88
89@{ shape: hex, label: "*produced Guard*
**survey-completed**"}
87==>|"SpecificationPropertyAssignment"|89
90@{ shape: hex, label: "*produced Guard*
**survey-invalid**"}
87==>|"SpecificationPropertyAssignment"|90
91@{ shape: hex, label: "*Property Type*
**supportedAnalysisStep**"}
69==>|"SpecificationPropertyAssignment"|91
92@{ shape: hex, label: "*supported Analysis Step*
**Measure Resource**"}
91==>|"SpecificationPropertyAssignment"|92
93@{ shape: hex, label: "*supported Analysis Step*
**Check Asset**"}
91==>|"SpecificationPropertyAssignment"|93
94@{ shape: hex, label: "*supported Analysis Step*
**Profiling Associated Resources**"}
91==>|"SpecificationPropertyAssignment"|94
95@{ shape: hex, label: "*Property Type*
**supportedActionTarget**"}
69==>|"SpecificationPropertyAssignment"|95
96@{ shape: hex, label: "*supported Action Target*
**duckdbDatabase**"}
95==>|"SpecificationPropertyAssignment"|96
97@{ shape: hex, label: "*Property Type*
**producedActionTarget**"}
69==>|"SpecificationPropertyAssignment"|97
98@{ shape: hex, label: "*produced Action Target*
**surveyReport**"}
97==>|"SpecificationPropertyAssignment"|98
99@{ shape: hex, label: "*produced Action Target*
**steward**"}
97==>|"SpecificationPropertyAssignment"|99
100@{ shape: hex, label: "*produced Action Target*
**stewardAction**"}
97==>|"SpecificationPropertyAssignment"|100
101@{ shape: tag-rect, label: "*Governance Action Type*
**Uncatalog Resource**"}
47==>|"resource [Uncatalog Resource]"|101
102@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
101==>|"SpecificationPropertyAssignment"|102
103@{ shape: hex, label: "*supported Request Parameter*
**templateGUID**"}
102==>|"SpecificationPropertyAssignment"|103
104@{ shape: hex, label: "*Property Type*
**producedGuard**"}
101==>|"SpecificationPropertyAssignment"|104
105@{ shape: hex, label: "*produced Guard*
**set-up-complete**"}
104==>|"SpecificationPropertyAssignment"|105
106@{ shape: hex, label: "*produced Guard*
**missing-template**"}
104==>|"SpecificationPropertyAssignment"|106
107@{ shape: hex, label: "*produced Guard*
**delete-complete**"}
104==>|"SpecificationPropertyAssignment"|107
108@{ shape: hex, label: "*produced Guard*
**service-failed**"}
104==>|"SpecificationPropertyAssignment"|108
109@{ shape: hex, label: "*Property Type*
**producedActionTarget**"}
101==>|"SpecificationPropertyAssignment"|109
110@{ shape: hex, label: "*produced Action Target*
**deletedAsset**"}
109==>|"SpecificationPropertyAssignment"|110
111@{ shape: tag-rect, label: "*Governance Action Type*
**Catalog Resource**"}
47==>|"resource [Catalog Resource]"|111
112@{ shape: hex, label: "*Property Type*
**supportedRequestParameter**"}
111==>|"SpecificationPropertyAssignment"|112
113@{ shape: hex, label: "*supported Request Parameter*
**templateGUID**"}
112==>|"SpecificationPropertyAssignment"|113
114@{ shape: hex, label: "*Property Type*
**producedGuard**"}
111==>|"SpecificationPropertyAssignment"|114
115@{ shape: hex, label: "*produced Guard*
**missing-asset**"}
114==>|"SpecificationPropertyAssignment"|115
116@{ shape: hex, label: "*produced Guard*
**set-up-complete**"}
114==>|"SpecificationPropertyAssignment"|116
117@{ shape: hex, label: "*produced Guard*
**missing-connector**"}
114==>|"SpecificationPropertyAssignment"|117
118@{ shape: hex, label: "*produced Guard*
**service-failed**"}
114==>|"SpecificationPropertyAssignment"|118
119@{ shape: hex, label: "*Property Type*
**producedActionTarget**"}
111==>|"SpecificationPropertyAssignment"|119
120@{ shape: hex, label: "*produced Action Target*
**newAsset**"}
119==>|"SpecificationPropertyAssignment"|120
121@{ shape: hex, label: "*Property Type*
**supportedActionTarget**"}
111==>|"SpecificationPropertyAssignment"|121
122@{ shape: hex, label: "*supported Action Target*
**integrationConnector**"}
121==>|"SpecificationPropertyAssignment"|122
style 88 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 89 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 110 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 111 color:#000000, fill:#40E0D0, stroke:#000000
style 112 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 113 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 114 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 115 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 116 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 90 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 117 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 91 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 118 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 92 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 119 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 93 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 94 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 95 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 96 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 97 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 10 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 98 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 11 color:#f2d9e7, fill:#732650, stroke:#f2d9e7
style 99 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 12 color:#000000, fill:#40E0D0, stroke:#000000
style 13 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 14 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 15 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 16 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 17 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 18 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 19 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 120 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 121 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 1 color:#f2d9e7, fill:#732650, stroke:#f2d9e7
style 122 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 2 color:#f2d9e7, fill:#732650, stroke:#f2d9e7
style 3 color:#004563, fill:#b0e0e6, stroke:#004563
style 4 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 5 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 6 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 7 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 8 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 9 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 20 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 21 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 22 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 23 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 24 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 25 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 26 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 27 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 28 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 29 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 30 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 31 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 32 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 33 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 34 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 35 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 36 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 37 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 38 color:#000000, fill:#40E0D0, stroke:#000000
style 39 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 40 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 41 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 42 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 43 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 44 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 45 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 46 color:#000000, fill:#40E0D0, stroke:#000000
style 47 color:#f2d9e7, fill:#732650, stroke:#f2d9e7
style 48 color:#000000, fill:#BDB76B, stroke:#004563
style 49 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 50 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 51 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 52 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 53 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 54 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 55 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 56 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 57 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 58 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 59 color:#000000, fill:#40E0D0, stroke:#000000
style 60 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 61 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 62 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 63 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 64 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 65 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 66 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 67 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 68 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 69 color:#000000, fill:#40E0D0, stroke:#000000
style 70 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 71 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 72 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 73 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 74 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 75 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 76 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 77 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 78 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 79 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 100 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 101 color:#000000, fill:#40E0D0, stroke:#000000
style 102 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 103 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 104 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 105 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 106 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 80 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 107 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 81 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 108 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 82 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 109 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 83 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7
style 84 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 85 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 86 color:#260d1b, fill:#d98cb6, stroke:#260d1b
style 87 color:#f2d9e7, fill:#260d1b, stroke:#f2d9e7Usage
For each server, store its credentials in a YAML secrets store and run the server technology type's CreateAsCatalogTarget process with serverName, hostIdentifier, portNumber, the secrets store placeholders and, for Oracle and Db2, databaseName. For DuckDB, run DuckDBDatabase::CreateAsCatalogTarget with the database file's path.
The step-by-step guides are Leveraging Microsoft SQL Server, Leveraging Oracle, Leveraging Db2 for Linux, UNIX and Windows and Leveraging DuckDB.
Raise an issue or comment below