template.yaml

########################################################################################
# Copyright (c) 2011-2019 Software AG, Darmstadt, Germany and/or Software AG USA Inc.,
# Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
#
# SPDX-License-Identifier: Apache-2.0
#
#   Licensed under the Apache License, Version 2.0 (the "License");
#   you may not use this file except in compliance with the License.
#   You may obtain a copy of the License at
#
#       http://www.apache.org/licenses/LICENSE-2.0
#
#   Unless required by applicable law or agreed to in writing, software
#   distributed under the License is distributed on an "AS IS" BASIS,
#   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
#   See the License for the specific language governing permissions and
#   limitations under the License.
#
#########################################################################################

alias: sag-db-sqlserver
description: SQLServer database and sample product schemas for release 10.5 and higher 

environments:
  default:                 
    db.host:             ${}                # REQUIRED: Database server hostname
    db.version:          latest             # latest or exact version 10.5
    db.port:             1433               # Default port
    db.admin.username:   ${}                # Admin username for db and user creation
    db.admin.password:   ${}                # REQUIRED: sa password for webm db and user creation

    db.url:              "jdbc:wm:sqlserver://${db.host}:${db.port};databaseName=${db.name}"
    db.name:             webm               # webM database name
    db.username:         ${}                # webM database username
    db.password:         ${}                # webM database password

    db.STR.components:   STR
      
    db.MAT.components:
      - ActiveTransfer 
      #- ActiveTransferArchive
     
    db.OBE.components:
      - Analysis
      - ProcessTracker
      - DataPurge
      - DatabaseManagement
      - OperationManagement
      - ProcessAudit
      
    db.OBE.components:
      - Analysis
      - ProcessTracker
      - DataPurge
      - DatabaseManagement
      - OperationManagement
      - ProcessAudit
       
    db.WOK.components:       
      - BusinessRules
    
    db.TNS.components:   
      - TradingNetworks
      - TradingNetworksArchive
      
    db.MWS.components:  
      - MywebMethodsServer
    
    db.B2Bcloud.components:  []    
     # - B2BChannels

    db.ODE.components:      
      - OneDataMetadata
      - OneDataWorkArea
      - OneDataReleaseArea
     
    #Component list for creating DB schemas for Integration Server and Microservices Runtime    
    db.PIE.components: 
      - ISInternal
      - ISCoreAudit
      - CrossReference
      - DocumentHistory
      - DistributedLocking 
      
    db.PIEMobile.components: 
      - MobileSupport
      
    db.WMN.components:    
      - Archive
      - Staging
      - Reporting
      - OperationManagement
      
    db.WPE.components:   
      - ProcessEngine
      - ProcessAudit
    
    db.WST.components:   
      - CloudStreamsEvents
      
    db.YAI.components:  
      - APIGatewayEvents     
      
    db.product.scripts:         
      - DatabaseComponentConfigurator
      - OBEcdc      
      - WOKcdc
      - TNScdc
      - MWScdc
      - MATcdc
      - ODEcdc
      - PIEcdc
      - PIEEmbeddedCdc
      - PIEMobileCdc
      - WMNcdc
      - WPEcdc
      - WSTcdc
      - YAIcdc
       #- B2BCloudCdc
    db.fixes:            ALL                # Database component configurator and scripts fixes to install         
layers:
  db:
    productRepo: ${repo.product}            # install products from
    fixRepo:     ${repo.fix}                # install fixes from
    templates:   dbc
    databases:
      storage:
        components:  ${db.STR.components}
        version:     latest
        db.type:     sqlserver
        db.url:      "${db.url}"
        db.admin.username: "${db.admin.username}"
        db.admin.password: "${db.admin.password}"
        db.username: "${db.username}"
        db.password: "${db.password}"
        db.name:     ${db.name}
      
      schemas.MAT:
        components:  ${db.MAT.components}
        version:     ${db.version}
        db.type:     sqlserver
        db.url:      "${db.url}"
        db.username: "${db.username}"
        db.password: "${db.password}"
        db.name:     ${db.name}
      
      schemas.OBE:
        components:  ${db.OBE.components}
        version:     ${db.version}
        db.type:     sqlserver
        db.url:      "${db.url}"
        db.username: "${db.username}"
        db.password: "${db.password}"
        db.name:     ${db.name}
      
      schemas.WOK:
        components:  ${db.WOK.components}
        version:     ${db.version}
        db.type:     sqlserver
        db.url:      "${db.url}"
        db.username: "${db.username}"
        db.password: "${db.password}"
        db.name:     ${db.name}
      
      schemas.TNS:
        components:  ${db.TNS.components}
        version:     ${db.version}
        db.type:     sqlserver
        db.url:      "${db.url}"
        db.username: "${db.username}"
        db.password: "${db.password}"
        db.name:     ${db.name}
        
      schemas.MWS:
        components:  ${db.MWS.components}
        version:     ${db.version}
        db.type:     sqlserver
        db.url:      "${db.url}"
        db.username: "${db.username}"
        db.password: "${db.password}"
        db.name:     ${db.name}
  
      schemas.B2Bcloud:
        components:  ${db.B2Bcloud.components}
        version:     ${db.version}
        db.type:     sqlserver
        db.url:      "${db.url}"
        db.username: "${db.username}"
        db.password: "${db.password}"
        db.name:     ${db.name}
      
      schemas.ODE:
        components:  ${db.ODE.components}
        version:     ${db.version}
        db.type:     sqlserver
        db.url:      "${db.url}"
        db.username: "${db.username}"
        db.password: "${db.password}"
        db.name:     ${db.name}
      
      schemas.PIE:
        components:  ${db.PIE.components}
        version:     ${db.version}
        db.type:     sqlserver
        db.url:      "${db.url}"
        db.username: "${db.username}"
        db.password: "${db.password}"
        db.name:     ${db.name}
        
      schemas.PIEMobile:
        components:  ${db.PIEMobile.components}
        version:     ${db.version}
        db.type:     sqlserver
        db.url:      "${db.url}"
        db.username: "${db.username}"
        db.password: "${db.password}"
        db.name:     ${db.name}

      schemas.WMN:
        components:  ${db.WMN.components}
        version:     ${db.version}
        db.type:     sqlserver
        db.url:      "${db.url}"
        db.username: "${db.username}"
        db.password: "${db.password}"
        db.name:     ${db.name}
      
      schemas.WPE:
        components:  ${db.WPE.components}
        version:     ${db.version}
        db.type:     sqlserver
        db.url:      "${db.url}"
        db.username: "${db.username}"
        db.password: "${db.password}"
        db.name:     ${db.name}
      
      schemas.WST:
        components:  ${db.WST.components}
        version:     ${db.version}
        db.type:     sqlserver
        db.url:      "${db.url}"
        db.username: "${db.username}"
        db.password: "${db.password}"
        db.name:     ${db.name}
        
      schemas.YAI:
        components:  ${db.YAI.components}
        version:     ${db.version}
        db.type:     sqlserver
        db.url:      "${db.url}"
        db.username: "${db.username}"
        db.password: "${db.password}"
        db.name:     ${db.name}
templates:
  dbc:
    products: ${db.product.scripts}
    fixes:    ${db.fixes}
provision:
  default:
    db: ${nodes}