Task: Running Trading Networks

OS: WindowsOS

Platform: webMethods 6.1

To Run Trading Networks. We need to run Queries in SQL Query analyzer. For this open the SQL Query analyzer. Click on Open( Load SQL Script) . Go to webMethods61/ common/db/scripts/create

 

 

Click on create_archive_iscoreaudit_6-1_SQLServer and click on open.

 

After opening it. Click on Parse Query and execute query and save it.

 

 

Similarly Run other queries like

• create_archive_processaudit_6-1_SQLServer
• create_archive_TN_6-1_SQLServer
•  create_idr_6-1_SQLServer
• create_iscoreaudit_6-1_SQLServer
•  create_processaudit_6-1_SQLServer
• create_prt_6-1_SQLServer
•  create_TN_6-1_SQLServer
•  create_xref_6-1_SQLServer

 

and run them in SQL Query Analyzer as shown before. 

 

Step 2 :

                Now we should run JDBC pools. For this open the IS Admin console page. Click on JDBC pools  in settings tab

Click on new pool alias definition and give the data as follows:

 

Alias Name  : Document History 

Associated Driver Alias : DataDirect Connect JDBC SQL Server Driver 

Database URL:  jdbc:wm:sqlserver://sqlsrv:1433;databaseName=webmethods7;SelectMethod=cursor

 

Give User name , password , Minimum & Maximum Connections and Idle time out. Click on save settings.

 

Similary create new pool alias definition for

·          ISCoreAudit

·         ProcessAudit

·         Reporting

·         Staging

·         TN

·         Xref.

 

Now click on Edit to 

Now Associate the pool alias to Function Name. And the click on save settings

Similarly Associate other pool alias to Function Names like

·         ISCoreAudit

·         ProcessAudit

·         Reporting

·         Staging

·         TN

·         Xref. 

 

   After Associating all pool alias to function names. Click on test.

If the Test is Successful. We get the following screen below.

Similarly  Test Run other Function Alias Definitions.