4 Open Development Tool Capabilities
This topic describes the Open Development Tool capabilities for an extensible upload framework.
Open Development Tool supports an extensible upload framework. The upload framework components can be generated by the tool through configurations.
Configuration of Upload Table Details in RADXML
Upload Table - In the data source definition screen, specify
the upload table name for the data source.
- Avoid providing synonyms in the Upload Table field.
- Upload Tables should be mapped only to Normal Data Sources.
- Click on the button next to the Upload Table to view the standard set of columns for the upload table.
- SOURCE_CODE, SOURCE_REF, SOURCE_SEQ_NO, and BRANCH_CODE will be assumed as part of the primary key of any Upload Table. Make note of the guidelines explained in the previous section while providing the Upload Table Name.
Upload Table Standard Columns - Refer to the previous section
for the standard columns which are part of the upload table. Default column names
are provided on the screen. Source Operation would be not present in the table by
default. The developer can change the column names of the standard columns as
desired. This could be useful if existing upload tables are re-used. For example,
Name of the column for external reference number can be changed from
SOURCE_REF to EXT_REF_NO.
Figure 4-2 Table Standard Columns- Transaction Screen
Figure 4-3 Table Standard Columns- Maintenance Screen
Figure 4-4 Table Standard Columns- Detail Upload Table
Upload Where Clause - If all the records in an Upload Table
are not mapped to a particular data source, then the Upload Where Clause can be
specified to filter the records. This is applicable only when the data sources
involved are not directly related to each other.
Upload Table Where Clause would be applied on the upload table, hence upload
table columns should be used in the clause.
Figure 4-5 Upload Where Clause- Multiple Data sources
Upload Table Column - All the data source columns which are included in the RADXML would be assumed to be part of the upload table.
- By default, the name of the Upload Table Column would be assumed to be the same as that of the base table name.
- If the name of the upload table column has to be different from the base table
column, then the same has to be explicitly mentioned in Upload
Table Column field.
Figure 4-6 Data Source Field Details- Upload Table Column
- Check the Not Required in Upload Tables box to specify if any
of the columns included in the data source in RADXML is not required in the
upload table.
Figure 4-7 Data Source Field Details- Not Required in Upload Tables
Generated Units
- Upload Adapter Package - Naming convention as Modulepks_FunctionID_Ext_Upload
- Triggers on Upload Table
- Upload Table DDL
Note:
If existing upload tables are being used, DDL scripts can be ignored. Drop scripts for the table would be generated in a separate file.
Upgrade Capabilities
The normal Open Development Tool upgrade feature is supported in upload table configurations as well. The customizations can be done on the configuration maintained in Open Development Tool. the customization can be done to:
- Change the Upload Tables Mapped - Map new upload tables or remove existing table mapping
- Modify/Remove/Add Upload Table Column Names
- Configure upload tables for the entire screen if it is not provided by the engineering and if the bank needs the same.