Method for transmitting data between SAP (Systems Application) system and SQL (Structured Query Language) database

Abstract

The invention provides a method for transmitting data between an SAP (Systems Application) system and an SQL (Structured Query Language) database, which comprises the following steps of: (1) establishing an SAP information set query used for extracting SAP system data in the SAP system; (2) setting parameters of receiving the SAP system data from the SAP information set query in the SQL database; and (3) establishing an SSIS (SQL Server Integration Services) execution package including data transmission events, and operating the SSIS execution package to transmit the SAP system data to the SQL database. In the invention, as the data extraction means based on the function of the SAP system information set query is adopted, and a low-cost SSIS data integration solution platform is invoked, the problems of over large data quantity, over high professional requirements, and over high cost and follow-up operation and maintenance costs are solved, programming-free and simple setting is realized, and namely the transmission of the data can be realized; thus, the huge payment for the development and follow-up operation and maintenance is effectively reduced. Meanwhile, as scientific incremental transmission management is also adopted in the invention, the repeated acquisition of huge data quantity can be eliminated, the system load is reduced, and the data transmission time is reduced.

Description

technical field [0001] The present invention relates to the field of data transmission, and in particular relates to a data exchange between SAP (Systems, Applications, and Products in Data Processing, hereinafter referred to as SAP) and an SQL database for enterprise resource planning (Enterprise Resource Planning, referred to as ERP) software. transfer method. Background technique [0002] With the development of e-commerce technology and enterprise application software becoming more and more mature, the application of SAP (Systems, Applications, and Products in Data Processing) system is becoming more and more popular; SAP software is also a giant in the ERP industry, its versatility Almost covers the business scope of various industries. However, when the SAP system is used by enterprises for data analysis such as management and operation, due to the special and complex structure of SAP data storage, the long construction cycle and the requirements for professional know...

AI Technical Summary

Problems solved by technology

[0008] In view of the problems referred to above, the purpose of the present invention is to provide a method for data transmission between the SAP system and the SQL database, calling the low-cost SSIS (SQL Server Integration Service; hereinafter referred to as SSIS) high-performance data integration solution platform to avoid data volume Too large, professionalism, cost, and follow-up operation and maintenance costs are too high, and data transmission can be realized without programming and simple settings

Images