Skip to content

Latest commit

 

History

History
 
 

sag-db-sqlserver

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 higher
  • Database Component Configurator 9.10 or higher
  • webMethods database schemas for products version 9.8 or higher

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
  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/docker-compose.yml up -d sqlserver

Provision sag-db-sqlserver template and run tests:

CC_ENV=sqlserver ./provisionw sag-db-sqlserver

Successful test output looks like this:

...
**********************************
* Executing action
*   Action            : catalog
*   Database          : SQL Server
*   URL               : jdbc:wm:sqlserver://sqlserver:1433;databaseName=webm
*   User              : webm
**********************************

**********************************
*      Installed Components      *
**********************************
*   BLZ 10 Blaze
*   RUL 20 BusinessRules
*   CCS 27 CentralConfiguration
*   XRF 11 CrossReference
*   DSL 20 DistributedLocking
*   IDR 10 DocumentHistory
*   DBO 25 DynamicBusinessOrchestrator
*   ISC 51 ISCoreAudit
*   ISI 75 ISInternal
*   MWS 65 My webMethods Server
*   OPM 30 Operation Management
*   PRA 90 ProcessAudit
*   PRE 95 ProcessEngine
**********************************

The expected values were successfully retrieved after 1 call within 4 seconds.
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:

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