AWSTemplateFormatVersion: 2010-09-09
Parameters:
    SourcePort:
      Type: Number
      Default: 1525
    Username:
      Type: String
      Default: dms_admin
    Password:
      Type: String
      Default: blank
      NoEcho: true
    OracleSourceServer:
      Type: String
      Default: 172.20.0.31
    OracleSourceDatabase:
      Type: String
      Default: DEV
Resources:
  DMSSourceEndpoint:
    Type: "AWS::DMS::Endpoint"
    Properties:
      EngineName: "ORACLE"
      EndpointType: "source"
      Username: !Ref Username
      Password: !Ref Password
      ServerName: !Ref OracleSourceServer
      Port: !Ref OracleSourcePort
      DatabaseName: !Ref OracleSourceDatabase
      ExtraConnectionAttributes: "addSupplementalLogging=Y"
  DMSTargetEndpoint:
    Type: "AWS::DMS::Endpoint"
    Properties:
      EngineName: "S3"
      EndpointType: "target"
      ExtraConnectionAttributes: "addColumnName=true"
      S3Settings:
        BucketName: !Ref S3Bucket
        ServiceAccessRoleArn: !GetAtt S3IAMRole.Arn
  S3Bucket:
    Type: "AWS::S3::Bucket"
  S3IAMRole:
    Type: "AWS::IAM::Role"
    Properties:
      AssumeRolePolicyDocument:
        Version: "2012-10-17"
        Statement:
          -
            Effect: "Allow"
            Principal:
              Service:
                - "dms.amazonaws.com"
            Action:
              - "sts:AssumeRole"
      Path: "/"
      Policies:
        -
          PolicyName: DMSPolicy
          PolicyDocument:
            Version: "2012-10-17"
            Statement:
              -
                Effect: Allow
                Action:
                  - s3:PutObject
                  - s3:DeleteObject
                  - s3:ListBucket
                Resource:
                  - !GetAtt S3Bucket.Arn
                  - !Sub "${S3Bucket.Arn}/*"
Outputs:
  DMSTargetEndPoint:
    Description: The DMS Target End Point
    Value: !Ref DMSTargetEndpoint
    Export:
        Name: sharedinf-DMSS3TargetEndpoint
  DMSS3Bucket:
    Description: S3Bucket to house the events from Oracle System
    Value:  !Ref S3Bucket
    Export:
        Name: sharedinf-DMSS3Bucket
  DMSSourceEndPoint:
    Description: The DMS Source End Point (ie Oracle System)
    Value: !Ref DMSSourceEndpoint
    Export:
        Name: sharedinf-DMSTargetEndPoint