CN102340528A - Data transmission system and method - Google Patents
Data transmission system and method Download PDFInfo
- Publication number
- CN102340528A CN102340528A CN2010102352223A CN201010235222A CN102340528A CN 102340528 A CN102340528 A CN 102340528A CN 2010102352223 A CN2010102352223 A CN 2010102352223A CN 201010235222 A CN201010235222 A CN 201010235222A CN 102340528 A CN102340528 A CN 102340528A
- Authority
- CN
- China
- Prior art keywords
- goal systems
- data
- module
- target system
- format
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Computer And Data Communications (AREA)
- Information Transfer Between Computers (AREA)
Abstract
The invention discloses a data transmission system, which is run in data processing equipment. The system comprises an establishment module, a receiving module, an acquisition module, a connection module and a transmission module, wherein the establishment module is used for establishing and maintaining a target system information sheet; the receiving module is used for receiving data to be transmitted and transmission parameters from a source system and converting the received data into a unified data format; the acquisition module is used for acquiring the connection information of a corresponding target system from the target system information sheet according to the received transmission parameters; the connection module is used for connecting with the corresponding target system according to the acquired connection information of the target system and logging in the target system; and the transmission module is used for converting the received data from the unified data format into a specific data format of the corresponding target system and transmitting the data in the specific data format to the corresponding target system according to the acquired connection information of the target system. The invention also provides a data transmission method. By the system and the method, data transmission with a heterogeneous application system can be realized simply and highly-efficiently.
Description
Technical field
The present invention relates to a kind of data transmission technology, particularly carry out the system and method for transfer of data about a kind of and isomery application system.
Background technology
Along with the continuous propelling of IT application process, increasing application system has appearred in enterprises, for example goods entry, stock and sales system, purchasing system, accounting system, bonded system, logistics system and marketing system.Each application system has different data formats and adopts different data storage methods; For example according to FTP (file transfer protocol; FTP) storage data are perhaps utilized database (like SQL server or Visual Fox) storage data.When ERP (enterprise resource planning, Enterprise Resources Planning) system being introduced original application system, because the difference of data format and data storage method, it is difficult that the data interaction between ERP system and the original application system becomes.At present, implement very inconvenience and inefficiency, strengthened the integration difficulty of application system with the transfer of data of isomery application system.
Summary of the invention
In view of above content, be necessary to provide a kind of data transmission system, can carry out transfer of data with the isomery application system simply efficiently.
In addition, also be necessary to provide a kind of data transmission method, can carry out transfer of data with the isomery application system simply efficiently.
A kind of data transmission system runs in the data processing equipment, and this system comprises: set up module, be used for setting up and safeguarding the target system information table, said target system information table provides the link information of goal systems; Receiver module is used for receiving from origin system the data and the transmission parameter of needs transmission, and is uniform data format with the data transaction of reception; Acquisition module is used for obtaining from the target system information table according to the transmission parameter that receives the link information of corresponding goal systems; Link block is used for being connected to corresponding goal systems and logining this goal systems according to the link information of the goal systems of obtaining; And transport module, be used for converting the data that receive the specific data format of corresponding goal systems into by uniform data format, and give corresponding goal systems according to the transfer of data that the link information of the goal systems of obtaining will convert format into.
A kind of data transmission method is applied in the data processing equipment, and the method comprising the steps of: set up and safeguard the target system information table, said target system information table provides the link information of goal systems; Need the data and the transmission parameter of transmission from the origin system reception, and be uniform data format the data transaction that receives; Obtain the link information of corresponding goal systems from the target system information table according to the transmission parameter that receives; Link information according to the goal systems of obtaining is connected to corresponding goal systems and logins this goal systems; And convert the data that receive the specific data format of corresponding goal systems into by uniform data format, and give corresponding goal systems according to the transfer of data that the link information of the goal systems of obtaining will convert format into.
The present invention is transferred to goal systems with data with specific data format according to this link information according to the link information of target system information table acquisition goal systems, the transfer of data of simple realization efficiently and isomery application system.
Description of drawings
Fig. 1 is the running environment sketch map of data transmission system preferred embodiment of the present invention.
Fig. 2 is the functional block diagram of data transmission system among Fig. 1.
Fig. 3 is the flow chart of data transmission method preferred embodiment of the present invention.
The main element symbol description
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
Set up module | 200 |
Receiver module | 210 |
Acquisition module | 220 |
Link block | 230 |
Transport module | ?240 |
Embodiment
Consulting shown in Figure 1ly, is the applied environment sketch map of data transmission system preferred embodiment of the present invention.Said data transmission system 10 runs in the data processing equipment 11 (for example application server or work station).This data transmission system 10 is transferred to goal systems 14 with data from origin system 13 through network 12.In the present embodiment; Said origin system 13 is SAP ERP (enterprise resource planning; Enterprise Resources Planning) system, said goal systems 14 comprises goods entry, stock and sales system, purchasing system, accounting system, bonded system, logistics system and marketing system.Each goal systems 14 has different data formats and adopts different data storage methods; For example according to FTP (file transfer protocol; FTP) storage data are perhaps utilized database (like SQL server or Visual Fox) storage data.Said network 12 can be local area network (LAN) (a for example intranet), also can be wide area network (for example the Internet).
Consulting shown in Figure 2ly, is the functional block diagram of data transmission system 10 among Fig. 1.Said data transmission system 10 comprises sets up module 200, receiver module 210, acquisition module 220, link block 230 and transport module 240.
The said module 200 of setting up is used for setting up and safeguarding the target system information table.Said target system information table provides the link information of goal systems 14.The link information of said goal systems 14 comprises identifier, IP address, port numbers, user name and the password of goal systems 14.If goal systems 14 adopts data database storing, the link information of said goal systems 14 also comprises database-name.If goal systems 14 is according to FTP (file transfer protocol, FTP) storage data, the link information of said goal systems 14 also comprises the storage path.For example, for marketing system, identifier is POS, and the IP address is 10.1.2.99, and port numbers is 1433, and the user is called posuser, and password is 12345678, and database name is called POS030.In the present embodiment, set up module 200 and also set up goal systems group for goal systems 14.For example, set up group 1, this group 1 comprises goods entry, stock and sales system, purchasing system and marketing system.And for example, set up group 2, this group 2 comprises purchasing system and accounting system.
Said receiver module 210 is used for receiving from origin system 13 data and the transmission parameter of needs transmission, and is uniform data format with the data transaction of reception.The said data that need to transmit can be dissimilar files, for example txt file, mdb file, dbf file and xls file.Said transmission parameter can be the identifier (for example POS) of goal systems 14, can also be goal systems group (for example group 1).In the present embodiment, said uniform data format is the XML form.
Said acquisition module 220 is used for obtaining from the target system information table according to the transmission parameter that receives the link information of corresponding goal systems 14.If the transmission parameter that receives is the identifier of goal systems 14, then acquisition module 220 obtains IP address, port numbers, user name and the password of corresponding goal systems 14 from the target system information table according to this identifier.Acquisition module 220 also obtains the database-name or the storage path of corresponding goal systems 14 from the target system information table according to said identifier.Particularly, if goal systems 14 adopts data database storing, then acquisition module 220 also obtains the database-name of goal systems 14; If goal systems 14 is according to FTP storage data, then acquisition module 220 also obtains the storage path of goal systems 14.For example; If the transmission parameter that receives is the identifier POS (corresponding to marketing system) of goal systems 14, then acquisition module 220 obtains IP address (for example 10.1.2.99), port numbers (for example 1433), user name (for example posuser), password (for example 12345678) and the database-name (for example POS030) of marketing system from the target system information table.If the transmission parameter that receives is a goal systems group; Then acquisition module 220 is confirmed the goal systems 14 that these goal systems groups are comprised, and obtains IP address, port numbers, user name, password and the database-name/storage path of the goal systems 14 that this goal systems group comprised from the target system information table.
Said link block 230 is used for being connected to corresponding goal systems 14 and logining this goal systems 14 according to the link information of the goal systems of obtaining 14.For example; The IP address of the goal systems of supposing to obtain 14 is 10.1.2.99, and port numbers is 1433, and the user is called posuser; Password is 12341234; Link block 230 is connected to this goal systems 14 according to IP address 10.1.2.99 and port numbers 1433, and uses user name posuser, password 12341234 these goal systems 14 of login.
Said transport module 240 is used for converting the data that receive the specific data format (for example XLS form) of corresponding goal systems 14 into by uniform data format, and gives corresponding goal systems 14 according to the transfer of data that the link information of the goal systems of obtaining 14 will convert format into.If goal systems 14 adopts data database storings, then transport module 240 data that will convert format into according to the database-name that obtains write the database of goal systems 14.If goal systems 14 is according to FTP storage data, then transport module 240 imports goal systems 14 into according to the data that the storage path that obtains will convert format into.In the present embodiment, transport module 240 adopts the mode of synchronous communication to give goal systems 14 with the transfer of data that receives.Utilize synchronous communication, goal systems 14 can make transport module 240 can when bust this, transmit data again transfer of data result (transmission success or bust this) return data transmission system 10.
Consulting shown in Figure 3ly, is the flow chart of data transmission method preferred embodiment of the present invention.
Step S301 sets up module 200 and sets up and safeguard the target system information table.Said target system information table provides the link information of goal systems 14.In the present embodiment, said goal systems 14 comprises goods entry, stock and sales system, purchasing system, accounting system, bonded system, logistics system and marketing system.The link information of said goal systems 14 comprises identifier, IP address, port numbers, user name and the password of goal systems 14.If goal systems 14 adopts data database storing, the link information of said goal systems 14 also comprises database-name.If goal systems 14 is according to FTP storage data, the link information of said goal systems 14 also comprises the storage path.For example, for marketing system, identifier is POS, and the IP address is 10.1.2.99, and port numbers is 1433, and the user is called posuser, and password is 12345678, and database name is called POS030.In the present embodiment, set up module 200 and also set up goal systems group for goal systems 14.For example, set up group 1, this group 1 comprises goods entry, stock and sales system, purchasing system and marketing system.And for example, set up group 2, this group 2 comprises purchasing system and accounting system.
Step S302, receiver module 210 needs the data and the transmission parameter of transmission from origin system 13 receptions, and is uniform data format with the data transaction that receives.In the present embodiment, said origin system 13 is SAP ERP systems.The said data that need to transmit can be dissimilar files, for example txt file, mdb file, dbf file and xls file.Said transmission parameter can be the identifier (for example POS) of goal systems 14, can also be goal systems group (for example group 1).In the present embodiment, said uniform data format is the XML form.
Step S303, acquisition module 220 obtain the link information of corresponding goal systems 14 from the target system information table according to the transmission parameter that receives.If the transmission parameter that receives is the identifier of goal systems 14, then acquisition module 220 obtains IP address, port numbers, user name and password with the corresponding goal systems 14 of the transmission parameter of this reception according to this identifier from the target system information table.Acquisition module 220 also obtains the database-name or the storage path of corresponding goal systems 14 from the target system information table according to said identifier.Particularly, if goal systems 14 adopts data database storing, then acquisition module 220 also obtains the database-name of goal systems 14; If goal systems 14 is according to FTP storage data, then acquisition module 220 also obtains the storage path of goal systems 14.For example; If the transmission parameter that receives is the identifier POS (corresponding to marketing system) of goal systems 14, then acquisition module 220 obtains IP address (for example 10.1.2.99), port numbers (for example 1433), user name (for example posuser), password (for example 12345678) and the database-name (for example POS030) of marketing system from the target system information table.If the transmission parameter that receives is a goal systems group; Then acquisition module 220 is confirmed the goal systems 14 that these goal systems groups are comprised, and obtains IP address, port numbers, user name, password and the database-name/storage path of the goal systems 14 that this goal systems group comprised from the target system information table.
Step S304, link block 230 is connected to corresponding goal systems 14 and logins this goal systems 14 according to the link information of the goal systems of obtaining 14.For example; The IP address of the goal systems of supposing to obtain 14 is 10.1.2.99, and port numbers is 1433, and the user is called posuser; Password is 12341234; Link block 230 is connected to this goal systems 14 according to IP address 10.1.2.99 and port numbers 1433, and uses user name posuser, password 12341234 these goal systems 14 of login.
Step S304; Transport module 240 converts the data that receive the specific data format (for example XLS form) of corresponding goal systems 14 into by uniform data format, and gives corresponding goal systems 14 according to the transfer of data that the link information of the goal systems of obtaining 14 will convert format into.If goal systems 14 adopts data database storings, then transport module 240 data that will convert format into according to the database-name that obtains write the database of goal systems 14.If goal systems 14 is according to FTP storage data, then transport module 240 imports goal systems 14 into according to the data that the storage path that obtains will convert format into.In the present embodiment, transport module 240 adopts the mode of synchronous communication to give goal systems 14 with the transfer of data that receives.Utilize synchronous communication, goal systems 14 can make transport module 240 can when bust this, transmit data again transfer of data result (transmission success or bust this) return data transmission system 10.
Claims (8)
1. a data transmission system runs in the data processing equipment, it is characterized in that, this system comprises:
Set up module, be used for setting up and safeguarding the target system information table, said target system information table provides the link information of goal systems;
Receiver module is used for receiving from origin system the data and the transmission parameter of needs transmission, and is uniform data format with the data transaction of reception;
Acquisition module is used for obtaining from the target system information table according to the transmission parameter that receives the link information of corresponding goal systems;
Link block is used for being connected to corresponding goal systems and logining this goal systems according to the link information of the goal systems of obtaining; And
Transport module is used for converting the data that receive the specific data format of corresponding goal systems into by uniform data format, and gives corresponding goal systems according to the transfer of data that the link information of the goal systems of obtaining will convert format into.
2. data transmission system as claimed in claim 1 is characterized in that, the said module of setting up is also set up goal systems group for goal systems.
3. data transmission system as claimed in claim 1 is characterized in that, the link information of said goal systems comprises the identifier of goal systems, IP address, port numbers, user name, password and database-name/storage path.
4. data transmission system as claimed in claim 1 is characterized in that, said transport module is given corresponding goal systems with the transfer of data that the mode of synchronous communication will convert format into.
5. data transmission method is applied to it is characterized in that in the data processing equipment that the method comprising the steps of:
Set up and safeguard the target system information table, said target system information table provides the link information of goal systems;
Need the data and the transmission parameter of transmission from the origin system reception, and be uniform data format the data transaction that receives;
Obtain the link information of corresponding goal systems from the target system information table according to the transmission parameter that receives;
Link information according to the goal systems of obtaining is connected to corresponding goal systems and logins this goal systems; And
Convert the data that receive the specific data format of corresponding goal systems into by uniform data format, and give corresponding goal systems according to the transfer of data that the link information of the goal systems of obtaining will convert format into.
6. data transmission method as claimed in claim 5 is characterized in that, this method also comprises step:
For goal systems is set up goal systems group.
7. data transmission method as claimed in claim 5 is characterized in that, the link information of said goal systems comprises the identifier of goal systems, IP address, port numbers, user name, password.
8. data transmission method as claimed in claim 5 is characterized in that, the said data that convert format into are transferred to corresponding goal systems with the mode of synchronous communication.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN2010102352223A CN102340528A (en) | 2010-07-23 | 2010-07-23 | Data transmission system and method |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN2010102352223A CN102340528A (en) | 2010-07-23 | 2010-07-23 | Data transmission system and method |
Publications (1)
Publication Number | Publication Date |
---|---|
CN102340528A true CN102340528A (en) | 2012-02-01 |
Family
ID=45516026
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN2010102352223A Pending CN102340528A (en) | 2010-07-23 | 2010-07-23 | Data transmission system and method |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN102340528A (en) |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103916431A (en) * | 2013-01-04 | 2014-07-09 | 云联(北京)信息技术有限公司 | Man-machine interaction system and method |
CN104135581A (en) * | 2014-08-15 | 2014-11-05 | 国家电网公司 | Communication method and device |
CN104270455A (en) * | 2014-10-14 | 2015-01-07 | 税友软件集团股份有限公司 | Data transmission method, device and system |
CN105306442A (en) * | 2015-09-17 | 2016-02-03 | 物联智慧科技(深圳)有限公司 | Proxy server and command transmission methods |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1635520A (en) * | 2003-12-27 | 2005-07-06 | 鸿富锦精密工业(深圳)有限公司 | Data processing system and method |
CN101192936A (en) * | 2006-11-29 | 2008-06-04 | 阿里巴巴公司 | A method, system and user terminal for establishing access connection |
CN101198105A (en) * | 2007-12-25 | 2008-06-11 | 北京亿阳信通软件研究院有限公司 | Mobile communication service handling method and device |
CN101277307A (en) * | 2008-05-21 | 2008-10-01 | 天柏宽带网络科技(北京)有限公司 | System and method for processing data information |
CN101754221A (en) * | 2008-12-19 | 2010-06-23 | ***通信集团山东有限公司 | Data transmission method between heterogeneous systems and data transmission system |
-
2010
- 2010-07-23 CN CN2010102352223A patent/CN102340528A/en active Pending
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1635520A (en) * | 2003-12-27 | 2005-07-06 | 鸿富锦精密工业(深圳)有限公司 | Data processing system and method |
CN101192936A (en) * | 2006-11-29 | 2008-06-04 | 阿里巴巴公司 | A method, system and user terminal for establishing access connection |
CN101198105A (en) * | 2007-12-25 | 2008-06-11 | 北京亿阳信通软件研究院有限公司 | Mobile communication service handling method and device |
CN101277307A (en) * | 2008-05-21 | 2008-10-01 | 天柏宽带网络科技(北京)有限公司 | System and method for processing data information |
CN101754221A (en) * | 2008-12-19 | 2010-06-23 | ***通信集团山东有限公司 | Data transmission method between heterogeneous systems and data transmission system |
Cited By (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103916431A (en) * | 2013-01-04 | 2014-07-09 | 云联(北京)信息技术有限公司 | Man-machine interaction system and method |
CN104135581A (en) * | 2014-08-15 | 2014-11-05 | 国家电网公司 | Communication method and device |
CN104135581B (en) * | 2014-08-15 | 2016-05-04 | 国家电网公司 | A kind of communication means and device |
CN104270455A (en) * | 2014-10-14 | 2015-01-07 | 税友软件集团股份有限公司 | Data transmission method, device and system |
CN105306442A (en) * | 2015-09-17 | 2016-02-03 | 物联智慧科技(深圳)有限公司 | Proxy server and command transmission methods |
CN105306442B (en) * | 2015-09-17 | 2018-12-25 | 物联智慧科技(深圳)有限公司 | Proxy server and its instruction transmission method |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN102546800B (en) | Handshake and communication methods for gateway, gateway and Web communication system | |
CN101282314B (en) | Group communication method, equipment and system for instant communication | |
CN102571857B (en) | Method and system for realizing logging in XMPP (Xmlbased Messaging and Presence Protocol) server | |
CN101136943B (en) | System and method for implementing extended Diameter protocol application | |
CN102855571B (en) | A kind of resource information processing method and device | |
CN102655481A (en) | Webpape-based instant messaging chat content looking-up method and system | |
CN103916311A (en) | Information transmission control method, device and system | |
CN101147380A (en) | Method and apparatus for efficiently expanding a P2P network | |
CN107395653A (en) | A kind of enterprise instant communication system and method based on safety isolation network gate | |
US20180227199A1 (en) | Iot device fog networking operation | |
CN102340528A (en) | Data transmission system and method | |
CN102404195A (en) | Data transmission method, gateway and network system | |
CN103686696A (en) | Method for sending data, gateway and sensor node | |
CN105101370A (en) | Data connection method and device, and WIFI module | |
CN105337973A (en) | Message exchange method and system | |
CN104539510A (en) | Multi-protocol-based information pushing system and method | |
CN1487706B (en) | Method, system and control process for enterprise to communicate timely | |
CN101094202A (en) | Method and system for receiving events in management system through instant communication tool | |
CN105471742A (en) | Message processing method and message processing equipment | |
CN105225099A (en) | A kind of mobile multi-service mode office automation system | |
CN102377738A (en) | Process integration server and method for realizing system integration by utilizing process integration server | |
KR20180059385A (en) | Apparatus for generating common container connecting messages transmitted through a plurality of low power wide area interfaces to open cloud system | |
CN103118083A (en) | Method and device of transmitting service messages | |
CN104158877A (en) | Remote control method, and device and system | |
CN103312753A (en) | Communication method and device of Internet of things |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20120201 |