Skip to content

Latest commit

 

History

History

sag-db-sqlserver-103-and-lower

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 webMethods database schemas on a Microsoft SQL Server.

Requirements

Supported Software AG releases

  • Command Central 10.1 or 10.3
  • Database Component Configurator 9.10 to 10.3
  • webMethods database schemas for products version 9.8 to 10.3

Supported platforms

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

Running as a standalone Composite Template

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

sagcc exec templates composite apply sag-db-sqlserver-103-and-lower
  db.version=10.1.0.0 repo.product=products-10.1 repo.fix=fixes-10.1 nodes=local
  db.host=sqlserver db.admin.username=sa db.admin.password=MaNaGe123
  db.name=webm db.username=webm db.password=webm
  db.products=[IS,MWS]
  --sync-job --wait 360

Using for local development and testing on Docker platforms

Launch the Command Central container from the root folder of this project:

docker-compose up -d cc

Launch the Miscrosoft SQL Server on Linux for Docker Engine container:

docker-compose -f templates/sag-db-sqlserver-103-and-lower/docker-compose.yml up -d sqlserver

Provision sag-db-sqlserver template and run tests:

CC_ENV=sqlserver ./provisionw sag-db-sqlserver-103-and-lower

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


You can now use this database for creating instances of webMethods products (Integration Server, My webMethods Server) with the following database connection properties:

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

The properties are preset in environments/sqlserver/env.properties file and you can use them by poiting to the environment name. For example:

CC_ENV=sqlserver ./provisionw sag-optimize-analysis