1 / 14

DRAGON Project

DRAGON Project. DES explanation material. Index. What’s “DES” ? Necessary preparation in regional side 3. Coding rules for data transmission by DES (1) File naming rule (2) Control file creation (3) Data file creation 4. Data transmission procedure

avye-gentry
Download Presentation

DRAGON Project

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DRAGON Project DES explanation material

  2. Index • What’s “DES” ? • Necessary preparation in regional side • 3. Coding rules for data transmission by DES • (1) File naming rule • (2) Control file creation • (3) Data file creation • 4. Data transmission procedure • (1) Flow & Functions (Region->DRAGON DES server)

  3. 1. What’s DES ? (1) • DES(Data Exchange System) = ftp + usage rules of ftp. • DRAGON project requires data transmission from your system to DRAGON system by DES. • For this data transmission, NML prepare for the gateway server for data receiving from your system by ftp(=DES). • We can reduce additional cost/workload in each region by using ftp for this data transmission. And we also ensure operation of data transmission by DES, such as data arrival check and number of records etc.[Data reliability]. • Followings of a transfer file can be handled by DES; • (1) Character code • (ASCII, Hitachi EBICIDIC, IBM EBICIDIC, Unicode) • (2) Data compression format • (No compression, Zip, DCP, Compress format)

  4. 1. What’s DES ? (2) (A) Send Pattern Your system DRAGON DES-Gateway DRAGON BATCH DRAGON DES-Gateway server make data file and control file and compress them periodically. Put data file and control file to DRAGON by ftp. Receive the files from DRAGON DES Gateway server and take data into DRAGON DB by batch job Create data file and control file. １ ３ ４ Data file + Control file ２ Put file by ftp to the designated folder. Your responsibility NML responsibility * DES convert Character Code and Data compression format.

  5. 1. What’s DES ? (3) (B) Get Pattern Your system DRAGON DES-Gateway DRAGON BATCH DRAGON DES-Gateway server pools data file and control file for 1 week. Data files and control files remaining for more than 1 week will be erased automatically. Get file by ftp to your system. Please remove data file and control file from DRAGON DES-Gateway Server after you get them. DRAGON BATCH Server makes data file and control file and compress them periodically. １ ３ ４ ２ Transmit data file and control file to DRAGON DES-Gateway by DES. Your responsibility NML responsibility * DES convert Character Code and Data compression format.

  6. 2. Necessary Preparation in regional side • Determine the server to engage in data transmission by the DES • Prepare data transmission (depending on the type of the sender’s server) • Create sending JOB (Script) • Prepare sending data creation • Prepare control file creation • Apply to NML for GW set-up • We’ll apply for DES usage, instead of you, so please inform followings to us as soon as possible. • <Q1> Both "IP address" and "Host name" of the system which provides( = transfer) data for DRAGON system • <Q2> Character code of your data • Please chose one character code for DRAGON data transmission from following 4 candidates. • Only following 4 character types are acceptable for DES gateway server, • so please convert data character code to one of following 4 candidates, if you use another character. • (option 1) ASCII (option 2) Hitachi EBCDIC • (option 3) IBM EBCDIC (option 4) Unicode • Set ftp User ID/Password based on feedback from NML

  7. 3. Coding rules for data transmission by DES 3-(1) File naming rule (1/3) • Please set following name to your file for data transmission ; • <1 Interface, 1 data file, 1 control file.> • Title part(8 digits) + “.“ + Extension part(5) • [Sales volume data (system-to-system)] • “DRG” + Application code + Interface code ”.D” + Seq no • “DRG” + Application code + Interface code ”.C” + Seq no • <Title part> • (1) Project name : “DRG” • (2) Application Code : “1” (SPEC) / “2” (ORDER/PIPE LINE) / • “3” (EXPORT) / “4” (After Sales) • (3) Interface code : 4 digits. (It will be informed to you later.) • <Extension part> • (5) File type : D(Data file) or C(Control file) • (6) Seq.no : 4 digits (0000~9999). • e.g.) DRG3G502.C0001

  8. 3-(2) Control file creation 1/2 TOTAL LENGTH 128bites fixed To Be continued

  9. 3-(2) Control file creation 2/2

  10. 3-(2) Control file creation 2/2

  11. 3-(3) Data file creation Data Compression Please set compression type in the No.6(Compression Type) of control file. If you transmit data exceeds 100MB, you should compress data file. Type of infra and Compression type you can choose listed below.

  12. 3-(3) Data file creation Character Code : Code Based on your system infrastructure which create data file for DRAGON, please choose Character Code type. And as the result of above choice, the value for No.7 of control file (=Character Code(Code)) should be decided. Only following 4 character types are acceptable for DES, so please convert data character code to one of following 4 candidates, if you use another character.

  13. 4. Data transmission procedure (In case of sending pattern) (1) Flow & Functions (Region  DRAGON DES server) ・File transfer must be executed in the sequence ‘Data file’ ,’Control file’. ・The transferring mode should be binary. COMMAND open *1 user *2 *3 binary put *4 put *5 bye CONTENTS of * *1 IP Address *2 your USER-ID , *3 your PASSWORD *4 : Data File Name *5 : Control File Name EXPLANATION Connect ‘session to DES SERVER Log-in to DRAGON DES SERVER Designate the transmission method Data file transfer command Control file transfer command Cut off the current ‘session’ 1 2 3 4 5 6 * All of the above-mentioned file names should be written in full path

  14. 4. Data transmission procedure (In case of getting pattern) (1) Flow & Functions (DRAGON DES server  Region) ・File transfer must be executed in the sequence ‘Data file’ ,’Control file’. ・The transferring mode should be binary. COMMAND open *1 user *2 *3 binary get *4 get *5 bye CONTENTS of * *1 IP Address *2 your USER-ID , *3 your PASSWORD *4 : Data File Name *5 : Control File Name EXPLANATION Connect ‘session to DES SERVER Log-in to DRAGON DES SERVER Designate the transmission method Data file transfer command Control file transfer command Cut off the current ‘session’ 1 2 3 4 5 6 * All of the above-mentioned file names should be written in full path

More Related