If there's a request of table data transfer from the source system, ISM inquires the data in rule defined query and transfer it to the target system. DB batch service is divided into DB-DB service and DB-file service.
Transaction is supported by transaction unit. The process per transaction isn't supported.
Transferable data by the DB batch method is as follows.
| Category | Description | Note |
|---|---|---|
| Data inquiry method | Data in able to inquiry in a single query | Unable to process when the data inquiry is required on multiple table but cannot join. |
| Processing Object Data Type | Processable Data Type Only ascii data is available | Cannot process the data including binary data |
| Processing object data size | No limit of processable number of data in one a single batch. | If the number is too great, the transaction is processed according to rule defined processing unit(the number of fetch). |
When the size of the processing object data is too great, the batch agent can have timeout. Therefore, the batch agent should have separated verification method of processing result without delaying.
Defines JDBC type on rule definition, and the approach method is limited to JDBC supported types. No need to manage the transaction because the transfer is used only on data inquiry.
In the case of XA transaction, approach it using the Adapter/Datasource which is provided by the platform.
(*) If it's not XA transaction, approach it in the same way of sending using ISM registered information
The database supporting target DB on ISM is as follows.
JDBC types supporting the approach to target DB are as follows.
| JDBC TYPE | Description | Oracle | MS-SQL | Infomix | DB2 | Others |
|---|---|---|---|---|---|---|
| 1 | JDBC-ODBC Bridge | O(Convert it to 4) | O(Convert it to 4) | O(Convert it to 4) | O(Convert it to 4) | O(Convert it to 4) |
| 2 | Native-API Driver specification | O(OCI) | O(app) | |||
| 3 | Network-Protocol Driver | |||||
| 4 | Native-Protocol Driver | O(Thin) | O | O | O(net) | O |
Register SQL query to be used on data inquiry on the source service. If the data verification object table must be modified by the condition of initialization of the serial number, defines the table name management class. Defines the unit of data processing(the fetch number). It means the unit of transaction. If the processing object data number is greater than the fetch number, divide and process into multiple times. If the data inquiry method cannot be handled by input verification query, defines the Custom Query Handler. Custom Query Handler is defined with DB Service Definition.
Follow the definition of target service of File-DB Batch service.
Structure definition of date type follow the rules of Data type processing rule of File-DB Batch
Structure definition Structure definition of date type follow the rules of Data type processing rule of File-DB Batch
Compose interface services to the source and target, and define routing rules, mapping rules when the request is sent from the source to the target. Define the service flow of the source service to the target system by service model. Set whether the service sequential processing or parallel processing on service flow definition. Parallel processing isn't used on batch service.
| Properties | Description |
|---|---|
| Pattern | >System interface pattern Configure ACK Transfer. |
| Property | Description | Allowable value |
|---|---|---|
| Routing Determining Protocol | Determines the way to find the target service. | All |
| Routing Input Field | Defines the input field when routing determining protocol doesn't correspond to All. | |
| Routing Pattern Value | Defines the value of assigned input field, pattern, the result of calculation. The same value transfer the request to the target system which has the same valued set. | |
| Service Mapping | Defines the conversion rules between the source and target service. | Mapping rule. |
| Error mapping | Defines the conversion rules when the error is returned from the target service. | |
| Target Service | Defines the target service to send the request by routing pattern value. | Target Service |
| Properties | Description |
|---|---|
| Pattern | System Interface Pattern Set ACK Transfer. |
Integration service defines the source and target systems to execute defined by model service, and defines the rules on other batch service execution.
Other information besides processing flow for Batch Integration Service is as follows.
Define the object system to perform the transmit-transfer interface service predefined on the service model, and the timeout value to be used on the interface with pertinent systems. Timeout value is used only on file interface.
Source DB service definition follows the source service definition( ISM:BatchDB#Source Service Definition) of DB-DB batch service
Target File Service Definition follows the definition of Target File Service Definition(ISM:BatchFile#Target File Service Definition) of File-File Batch Service.
If the number of the process target data is more than 1 time inquiry number unit, configure the duplication process option of the file service to overwriting or adding. Even if it is set to overwrite, adding mode is operated automatically in the condition of sending multiple files separated.
The Source Data Structure Definition follows the Transfer DB Data Structure Definition(ISM:BatchDB#Source DB Data Structure Definition) of DB-DB Batch Service.
For the target file data structure definition, follow the file data structure definition(ISM:BatchFile#File Data Structure Definition) of file-file batch service.
Defines routing rules, mapping rules when the interface services are composed of the source and target, and when the request is sent from the source to the target. The Service Model defines the service flow starting from the source to the target. Set whether the service flow definition is sequential processing or parallel processing. Parallel processing isn't used on Batch Service.
| Properties | Description |
|---|---|
| Pattern | System Interface Pattern Set ACK Transfer |
| Properties | Description | >Allowable Value |
|---|---|---|
| Routing Determining Protocol | Determines the way to find the target service. | All |
| Routing Input Field | When Routing Determining Protocol isn't All, assign the input field. | |
| Routing Pattern Value | Assigns the value of assigned input field, pattern, processed result value. The same value send the request to the target service. | |
| Service Mapping | Defines the conversion rules between the source service and the target service. | Mapping Rule. |
| Error Mapping | Defines the conversion rule when the error is returned from the target service. | |
| Target Service | Defines the target service to request per routing pattern value. | 수신 서비스 |
| Properties | Description |
|---|---|
| Pattern | System Interface Pattern Set ACK Transfer. |
Integration Service defines the source and target system on service model result, and the rules of other Batch Service on run.
Other information besides processing flow for Batch Integration Service is as follows.
Define the object system to perform the transmit-transfer interface service predefined on the service model, and the timeout value to be used on the interface with pertinent systems. Timeout value is used only on file interface.