Navigation: Build Your Own ERP > DTS >

Data Transfer Services (DTS) - Overview

 

 

 

DTS allows you to transfer data stored from the database into one or more destinations. There are two types of services:

1. Import Service - is used to retrieve data from the database and load them into the data grid.. This is useful for the ff requirements:

Retrieve data for viewing before printing the report. Ex; Generate TB for viewing before generating the FS

Import data from one app to another app. Example: Import VAT entries from GL System into the eBIRForms 2550M/Q app.

2. Export Service - is used to export data from the database into an external file. It is usually used in generating csv, dat or xml files needed by other applications.

Example: Generate DAT file for SLSP

 

The DTS interface is a combobox with a caption DTS just beneath the Preview combobox (see image below). The user may select from the dropdown list and double-clicking the mouse will execute the selected dts.

 

 

 

 


 


 

 

 

Copyright © 2021 Terasoft Corporation