Binding the Trigger with SQL Query Action to Log the Incoming Messages in Adeptia Log Database

AS2 message information is needed to record in Adeptia log database for further integration and processing. You need to insert the data in the SQL table.

1. Access Adeptia log database and ensure it has the table name “AU_AS2Logs”. Please create the table if it is not available.
2. Login to the JSCAPE MFT Server web interface.
3. Go to the Domains tab, select the domain, and click Edit.
4. Select Triggers from the left menu.
5. In the Triggers tab, select the same trigger that was created for Run Process Action and click Edit. 
   
   
   
   The Edit Trigger window appears.
6. Click Next and go to Trigger Action window.
7. On the Trigger Action window, click Add.
   The Add Action window appears.
8. Select SQL Query from the Action drop-down list.
9. Click OK to define the SQL credentials.
   
   
   
   The SQL Query Action window appears.
10. Provide the jdbc credentials in the respective fields and type your SQL query that you want to execute through the trigger. Click Add Variable to insert AS2 message data into the table dynamically with the help of prebuilt variables provided by JSCAPE Server.
11. Click OK.
    

     

    You need to put the jdbc driver jar respective to the Database server in use, in the libs directory of the default installation directory of the JSCAPE server.
    Also, you need to make an entry of the JDBC class in the Server > Settings > JDBC Drivers before using SQL Query Action.

    
    
    
    

12. Click OK to apply the new changes.