Task: Configuring Trading Networks

OS: WindowsOS

Step: RUN THE FOLLOWING SCRIPTS IN ORDER TO FORMATE TRADING PARTNER RELATED DATA BASE IN SQLSERVER

path: C:webMethods61commondbscriptscreate

1) Create_archive_iscoreaudit_6-1_SQLServer.sql

2) Create_archive_processaudit_6-1_SQLServer.sql

3) Create_archive_TN_6-1_SQLServer.sql

4) Create_idr_6-1_SQLServer.sql

5) Create_iscoreaudit_6-1_SQLServer.sql

6) Create_processaudit_6-1_SQLServer.sql

7) Create_prt_6-1_SQLServer.sql

8) Create_TN_6-1_SQLServer.sql

9) Create_xref_6-1_SQLServer.sql

Step2:  Go to admin console ->  JDBC Pools-> Create all pool alias definitions

  [Database url:(which is usered in trading network configuration)

jdbc:wm:sqlserver://sqlsrv:1433;databaseName=webmethods57;SelectMethod=cursor]

    & give the functional alias defination to its corrsponding pool alias definitions,   shut down & restart the server inorder to effect the chages in our webmethods environment.

Step 3: Logoff from the adminconsole and reenter into admin console ..so automaticaly you get the  Trading network option in the solutions tab.

jdbc:wm:sqlserver://sqlsrv:1433;databaseName=webmethods194;SelectMethod=cursor