Configuring Data Source for SWIFT MT940 Report

For the given sample SWIFT MT940 report, we need to create a data source. Let's assume that we need to create a data source to fetch data from the particular table (MT940 table). Let's create a data source, pointing to the mentioned table, so as to fetch the data for configuring the SWIFT MT940 report.

Perform the following steps to configure the data source to fetch the relevant data for creating the SWIFT MT940 report in Sigma Studio:

1. Right-click an existing connection and select the Create Data Source option.

   
   
   The Create Datasource screen appears.
   
   
   
   

2. Enter a unique name in the Data Source Name field, e.g. SWIFT STATEMENT DS.
   
   1. Select the relevant DB table from the Object Name lookup field, e.g. mt940.
   2. Enter the bundle key name associated with the property file in the Bundle Key field, e.g. common. By default, common appears as the Bundle Key.
   3. Select the data columns from the Column IDs drop-down list.

   4. Click Save to save the configured data source.

      When you try to exit the Create Datasource screen before saving the configured data source, a warning pop-up message appears as shown in the following screen shot:
      

      • Click Cancel, if you do not want to exit the Create Datasource screen.
      • Click Ok, if you want to exit the Create Datasource screen.

      For detailed information on the standard and query-based data sources, refer Create a DB Data Source and Applying parameters for SQL Data Sources respectively.

   
   
   A confirmation message appears, indicating a successful save of the configured data source.
   
   
   
   
   
3. Click Ok.

Refer the following page:

• Configuring the SWIFT MT940 Report with template