Currency table update: General procedure
Importing the add-on Integration-Process
The FEX installation package includes an add-on Integration-Process that you can use to update the SWIFTNet Portal Currency table. To import the add-on:
After you import the Integration-Process, in Composer you require the following objects:
These objects operate as a set with the IP_SWIFTNET_UPDATE_CURRENCY Integration-Process. Together these objects enable you to update the Currency table in SWIFTNet Portal.
In most cases, you will already have created an Axway Server object in Composer to represent the Integrator Server instance where the SWIFT tables reside. If this is the case, you reuse the same object for SWIFTNet Portal Table updating procedures.
If for any reason you need to create a new Integrator Axway Server object, refer to the topic that describes the Axway Server creation procedure.
If you have already created a JDBC CommAdapter that you want to use, this procedure is not necessary.
When you imported the Currency tables to Integrator, you created an FTP Partner. You can reuse the same object for SWIFTNet Portal Table updating procedures.
View FTP Partner creation topic
Before you create the Partner object, you must create:
Field | Description |
---|---|
Driver type |
Enter name database type. For example: Oracle |
Driver class |
Enter the name of the Java class to be used by Integrator for the database connection. . For example: oracle.jdbc.driver.OracleDriver |
URL template |
Enter the URL structure for access to the database type. For example: |
Database |
Enter the name of the database. Integrator uses this name in the <databaseName> attribute of the URL template, above. |
Port |
Enter the access port number for the database. To connect to the database, Integrator uses this port number in the <databasePort> attribute of the URL template, above. |
Field | Description |
---|---|
User |
Enter the user name for connecting to the database. This information corresponds to the information found in the Schema of the database in which the Currency, Country and BIC tables are stored. |
Password |
Enter the password for connecting to the database. This information corresponds to the information found in the Schema of the database in which the Currency, Country and BIC tables are stored. |
Field | Contents |
---|---|
Name | Enter a name for the Channel. For example, IN_CURRENCY |
Label | Optionally enter a description. |
Status | You cannot directly change the status in this field. |
Endpoints | |
Terminus1 | 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. |
Terminus2 | 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) |
Field | Contents |
---|---|
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 | |
Terminus1 | From the drop-down list, select Partner. Then from the Instance field drop-down list, select the Partner object that represents the JDBC Database. |
Terminus2 | 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 / Oracle (or other database type) |
Connection point 1 | Select the FTP CommAdapter |
Connection point 2 | Select the JDBC CommAdapter |
The Integration-Task object contains the technical information that is necessary to execute your Integration-Process on an Integrator Server.
For SWIFT table integration you use the Integration-Task to link the Receive and Send Activities to the appropriate Channels.
Field | Contents |
---|---|
Name | Enter a name for the Integration-Task. For example: IT_SWIFTNET_UPDATE_CURRENCY |
Integration-Process | From the drop-down list, select the Integration-Process you imported for Currency table updates: IP_SWIFTNET_UPDATE_CURRENCY |
Integrator Server | Select the name of the Integrator Server instance on which you want to run the integration. |
Field | Contents |
---|---|
In Activity | Associate this Activity with the FTP input Channel |
TRANSFER_CURRENCY_FILE | Associate this Activity with a Hierarchical processor Task |
Out Activity | Associate this Activity with the JDBC output Channel |
If you are a subscriber to the appropriate SWIFT services, SWIFT periodically supplies you with data file for Currency table updating: CU.dat
To use the CU.dat file to update the content of the SWIFTNet Portal Currency table:
About updating SWIFT tables in SWIFTNet Portal