Skip to content

Latest commit

 

History

History

sag-db-sqlserver-is-schemas

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
README.md
README.md
 
 
docker-compose.yml
docker-compose.yml
 
 
template.yaml
template.yaml
 
 
test.sh
test.sh
 
 

README.md

Creating webMethods database on Miscrosoft SQL Server

With this template you can create user, database, and Integration Server database schemas on Miscrosoft SQL Server.

Requirements

None.

Supported Software AG releases

  • Command Central 10.5 and higher
  • Database Component Configurator 10.5 and higher
  • webMethods database schemas for products version 9.8 and higher

Supported platforms

  • All supported Windows and UNIX platforms
  • All supported versions of Microsoft SQL Server database
  • Docker Engine 17.09 and higher

Running as a standalone Composite Template

To install Database Component Configurator 10.5 on the Command Central node with alias local, create a database named webm and a database user named webm with password webm, and create Integration Server database components schemas with user sa and password MaNaGe123:

sagcc exec templates composite apply sag-db-sqlserver-is-schemas \
  db.version=10.5 repo.product=products-10.5 repo.fix=fixes-10.5 nodes=local \
  db.host=sqlserver db.admin.username=sa db.admin.password=MaNaGe123 \
  db.name=webm db.username=webm db.password=webm \
  --sync-job --wait 360

Using for local development and testing on Docker platforms

  1. Launch the Command Central container from the root folder of the following project:
docker-compose up -d cc
  1. Launch the Miscrosoft SQL Server on Linux for Docker Engine container:
docker-compose -f templates/sag-db-sqlserver-is-schemas/docker-compose.yml up -d sqlserver
  1. Provision sag-db-sqlserver-is-schemas template and run tests:
CC_ENV=sqlserver ./provisionw sag-db-sqlserver-is-schemas

If the test is successful, the test output contains TEST SUCCESSFUL.

You can now use this database for creating instances of webMethods product Integration Server with the following database connection properties:

db.url=jdbc:wm:sqlserver://sqlserver:1433;databaseName=webm
db.username=webm
db.password=webm
db.type=sqlserver

The properties are pre-set in environments/sqlserver/env.properties file and you can use them by pointing to the environment name, for example:

CC_ENV=sqlserver ./provisionw sag-is-cluster