Using Custom-Functions

Overview

Creating the database object

Creating the Integrator FTP input Channel

Creating the JDBC CommAdapter

Creating the JDBC Channel

Creating the Integration-Process

Creating an Integration-Task

Overview

This version of Axway Financial Exchange includes Java Custom-Functions for Integrator. These Custom-Functions are used inside the check constraints of each Business Document (SWIFT-FIN, SWIFT-XML, and so on).

This topic explains how to set up a link between a Java Custom-Function and the required database storage.

Only the following functions use such a database:

• iskeypresentbic
• swcheck_bic2
• update_bic_table
• getbicinbdf
• iskeypresentbicinbdf

Creating the database object

1. In the FEX installation package, navigate to the required directory:
2. Software\CF_IBAN\Database
3. Software\BDF\Database
4. This directory contains the database SQL scripts.
2. Run the SQL scripts inside your database schema.
3. These scripts create the following tables. These table are needed to support the financial repository used by the Custom-Functions.

Creating the Integrator FTP input Channel

In the Axway Composer Integration-Services workbench, Transport tab, Hierarchy sub-tab:

1. Right-click the Axway Server object that represents Integrator.
2. Select Channel from the context menu.
3. Composer displays the Channel properties window.
3. Complete the General tab:

View field descriptions

Field	Description
Name	Enter a name for the Channel. For example: In_BIC
Label	Optionally enter a description
Status	You cannot directly change the status in this field.
Endpoints
Terminus 1	From the drop-down list, select Partner. Then from the Instance field drop-down list, select the Partner object that represents the FTP server application.
Terminus 2	From the drop-down list, select Axway Server. Then from the Instance field drop-down list, select the Axway Server object that represents the Integrator Server.
Connection parameters
Connection type	Select TCP/FTP
Connection point 1	Select the FTP CommAdapter (this is for the connection on the Integrator side)
Connection point 2	Select the FTP CommAdapter (this is for the connection on the FTP Server side)

4. Select the Connection point 2 tab.
5. In the Receiver or Sender field select Receiver.
6. In the Receive script field, enter a receive script such as:

7. Check, save and close the object.
8. Send the Channel object to server.
9. Composer sets the object status to commit.

Creating the JDBC CommAdapter

If you have already created a JDBC CommAdapter that you want to use, this procedure is not necessary.

1. In Composer, open the Topography workbench.
2. In the Topography workbench open the Axway Server object that represents your Integrator Server instance.
3. Composer displays the Axway Server properties window
3. In the Axway Server properties window, select the Communication tab.
4. In the Communication tab, add a TCP-type CommNetwork.
5. Right-click the CommNetwork and, from the context menu, select Add a CommAdapter.
6. Composer adds a CommAdapter node to the tree structure in the left pane, and displays the CommAdapter configuration fields in the right pane.
6. In the right pane, complete the configuration fields:
   • CommAdapter type: Select JDBC from the drop-down list
   • Template: If you have created a template to configure this CommAdapter, you can optionally select the template from the drop-down box
7. Check, save and close the Axway Server object.

Creating the JDBC Channel

1. In the Composer Integration-Services workbench, Transport tab, Hierarchy sub-tab, right-click the Axway Server object that represents Integrator and then select Channel from the context menu.
2. Composer displays the Channel properties window.
2. Complete the General tab:

View field descriptions

Field	Description
Name	Enter a name for the Channel. For example: Update_BIC
Label	Optionally enter a description
Status	You cannot directly change the status in this field.
Endpoints
Terminus 1	From the drop-down list, select Partner. Then from the Instance field drop-down list, select the Partner object that represents the JDBC database.
Terminus 2	From the drop-down list, select Axway Server. Then from the Instance field drop-down list, select the Axway Server object that represents the Integrator Server.
Connection parameters
Connection type	Select FTP/Oracle (or other database type)
Connection point 1	Select the FTP CommAdapter
Connection point 2	Select the JDBC CommAdapter (this is for the connection on the database side)

3. Check, save and close the object.
4. Send the Channel object to server.

Creating the Integration-Process

This Integration-Process must make use of one of the following Java Custom-Functions:

• iskeypresentbic
• swcheck_bic2
• update_bic_table
• getbicinbdf
• iskeypresentbicinbdf

The Function Call may appear in any DML part of the Integration-Process:

• Business-Document CheckConstraints
• Steps of a DecisionPath of a Map-Broker
• Mapping Expression inside a Map-Broker

They are most often used and found inside CheckConstraints delivered as part of the FEX libraries delivery.

You can import the sample Integration-Process ip_update_bic_table.xml delivered in the FEX installation package in the Software\BICUpdate directory. This Integration-Process enables you to update the BIC Repository.

Creating an Integration-Task

1. Right-click the Integration-Task and click the Integration-Process.
2. Complete the General tab:

View field descriptions

Field	Description
Name	Give a name to the integration task
Label	Optionally enter a description
Status	You cannot directly change the status in this field.
Integration-Process	Select the IP created
Integrator Server	Select the Integrator Server
Sentinel	Log all events

3. Click the Configuration tab.
4. Select FTP channels for send and receive activity.
5. For Custom-Functions, select the JDBC.
6. Save the Integration-Task.
7. Send the Integration-Task to server.

Related topics

Integrator Server add-ons

Importing Custom-Functions to Composer

Migration: Updating the Custom-Functions

Using the Banque de France Custom-Functions