CN114626075A - Method and system for accessing ECC tool information in real time and readable storage medium - Google Patents

Abstract

The invention relates to a method, a system and a readable storage medium for accessing ECC tool information in real time, wherein the method comprises the following steps: synchronizing a plurality of tool information tables of the ECC system into the HANA system in real time through an SLT module; the HANA system associates and logically processes the multiple tool information tables according to the application requirements of the user to generate application data; and providing the application data for an external application system to access and display through an interface. By the technical scheme, the core service system is prevented from directly providing data for other service systems, the data processing efficiency is improved, and the data access efficiency of the application system is also improved.

Description

Method and system for accessing ECC tool information in real time and readable storage medium

Technical Field

The invention relates to the field of computers, in particular to a method and a system for accessing ECC tool information in real time and a readable storage medium.

Background

SAP ECC is currently used as a cluster-level ERP system, and covers main core services such as finance, cost control, human resources, material purchasing, factory maintenance and the like. And each power plant also builds respective service systems according to the requirements of the power plant, the systems are numerous (hundreds of sets), but all related ERP services have the requirement of acquiring data from ECC. However, as the core service system, ECC needs to face concurrent access and service data processing of a large number of users, and if a large number of data interfaces are provided externally, it is too burdensome to allow ECC to directly provide data for other external systems.

In practical applications, it is found that external application systems often have a need for accessing tool information, and tool data is stored in 17 database tables of the ECC system, and since the ECC system does not support direct access of the external application systems, how to efficiently acquire required data from the numerous database tables becomes a difficulty.

Disclosure of Invention

The invention provides a method, a system and a readable storage medium for accessing ECC tool information in real time, aiming at the defect that the tool data stored in an ECC system can not be directly accessed in the prior art.

The technical scheme adopted by the invention for solving the technical problem is as follows: a method of constructing real-time access to ECC tool information, comprising:

s10, synchronizing a plurality of tool information tables of the ECC system into the HANA system in real time through an SLT module;

s20, the HANA system associates and logically processes the multiple tool and instrument information tables according to the application requirements of the user to generate application data;

and S30, providing the application data for an external application system to access and display through an interface.

Preferably, the step S10 includes:

s11, an SLT module receives connection configuration information input by a user, and respectively establishes connection between the SLT module and the ECC system and connection between the SLT module and the HANA system according to the connection configuration information;

s12, the SLT module activates a corresponding trigger when a corresponding tool and instrument information table is updated according to a plurality of triggers and log tables which are created in an ECC system in advance and correspond to each tool and instrument information table respectively, and the corresponding log tables automatically copy updated data;

and S13, synchronizing the update data to the HANA system by the SLT module.

Preferably, after the step S12, the method further includes:

s14, cleaning and converting the updated data;

the step S13 includes:

and the SLT module synchronizes the processed update data to the HANA system.

Preferably, the step S20 includes:

the HANA system associates and logically processes the plurality of tool information tables according to a pre-created application model related to the application requirements of the user, to generate application data.

Preferably, the step S30 includes:

and the external application system accesses the application data through the micro-service and displays the application data at the front end.

Preferably, the step S30 includes:

receiving an access request sent by an external application system;

judging whether the user sending the access request has access authority or not;

and if the application data has the access authority, the application data is provided for an external application system to access and display through an interface.

The present invention also constitutes a readable storage medium storing a computer program which, when executed by a processor, implements the steps of the method of accessing ECC tool information in real time as described above.

The invention also constructs a system for accessing the ECC tool information in real time, which comprises a processor and a memory stored with a computer program, wherein the processor realizes the steps of the method for accessing the ECC tool information in real time when executing the computer program.

The invention also constructs a system for accessing the ECC tool information in real time, which comprises an SLT module and an HANA system, wherein,

the SLT module is used for synchronizing a plurality of tool information tables of the ECC system into the HANA system in real time;

the HANA system is used for associating and logically processing the multiple tool information tables according to application requirements of users to generate application data, and providing the application data for an external application system to access and display through an interface.

Preferably, the SLT module is provided in an ECC system.

In the technical scheme provided by the invention, firstly, the tool data of the ECC system is synchronized to the HANA platform in real time through the SLT module, so that the core service system (SAP ECC system) is prevented from directly providing data for other service systems. Secondly, the business logic processing which is originally needed to be realized in the application system is transferred to the HANA data platform, and by utilizing the high-efficiency memory calculation and parallel processing characteristics, the data processing efficiency which is 10-100 times higher than that of the traditional mode can be obtained.

Drawings

In order to illustrate the embodiments of the invention more clearly, the drawings that are needed in the description of the embodiments will be briefly described below, it being apparent that the drawings in the following description are only some embodiments of the invention, and that other drawings may be derived from those drawings by a person skilled in the art without inventive effort. In the drawings:

FIG. 1 is a flow chart of a first embodiment of a method for accessing ECC tool information in real time according to the present invention;

FIG. 2 is a block diagram of an architecture for obtaining ECC tool information according to the present invention;

FIG. 3 is a data logic diagram of an ECC tool information table according to the present invention.

Detailed Description

The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be obtained by a person skilled in the art without making any creative effort based on the embodiments in the present invention, belong to the protection scope of the present invention.

In order to solve the following technical problems: the method has the advantages that data can not be directly acquired from an ECC system, and data scattered in 17 tables can not be efficiently calculated and processed, the SLT module is used as a data extraction tool, the ECC data are synchronized to an HANA data platform in real time, complex processing is carried out by using the memory calculation characteristics of the HANA platform, association and complex business logic processing of a plurality of tool information tables can be efficiently realized, and processing results are accessed to a WEB system through an interface in real time, so that an external application system can directly access the processing result data, and real-time access and display of the ECC data are realized.

Fig. 1 is a flowchart of a first method for accessing ECC tool information in real time according to an embodiment of the present invention, and the following describes steps of the method for accessing ECC tool information in real time according to the embodiment with reference to fig. 1 and fig. 2:

s10, synchronizing a plurality of tool information tables of the ECC system into the HANA system in real time through an SLT module;

in this step, it should be noted that the SLT is called an SAP LT Replication Server, and is software for synchronizing data among different systems in real time, and is used for performing accurate data Replication among SAP systems. The 17 tool information tables are database tables stored in the ECC system, as shown in table 1. In the step, an SLT module is used as a data extraction tool, and the 17 database tables in the ECC system can be synchronized to the HANA system in real time.

TABLE 1

S20, the HANA system associates and logically processes the multiple tool and instrument information tables according to the application requirements of the user to generate application data;

in this step, it should be noted that the HANA is a database platform that is based on row-by-row storage, object-oriented, and memory calculation (memory calculation refers to directly loading and calculating a large amount of data into a memory), and that is called High Performance analytical application (High Performance data analysis platform), and the data storage space is greatly compressed, so that the data can be loaded into the memory database in a full amount, and the analysis and query in a large amount are guaranteed.

And S30, providing the application data for an external application system to access and display through an interface.

According to the technical scheme of the embodiment, firstly, the tool data of the ECC system is synchronized to the HANA platform in real time through the SLT module, and the core service system (SAP ECC system) is prevented from directly providing data for other service systems. Secondly, the business logic processing which is originally needed to be realized in the application system is transferred to the HANA data platform, the data processing efficiency which is 10-100 times higher than that of the traditional mode can be obtained by utilizing the high-efficiency memory calculation and parallel processing characteristics of the HANA data platform, and in addition, the final result is only needed to be provided for an external application system (WEB end), so that the data volume which needs to be accessed by the application system is reduced, and the data accessing efficiency of the application system is improved.

Further, in an alternative embodiment, step S10 includes:

s11, an SLT module receives connection configuration information input by a user, and establishes connection between the SLT module and the ECC system and connection between the SLT module and the HANA system respectively according to the connection configuration information;

in this step, because the ECC, the HANA, and the SLT are all SAP products, based on an internal unified processing mechanism, the connection between the SLT module and the ECC system (RFC connection) and the connection between the SLT module and the HANA system (DB connection) can be established with only a simple configuration, so as to implement real-time seamless docking of data.

S12, the SLT module activates a corresponding trigger when the corresponding tool information table is updated according to a plurality of triggers and log recorders which are created in an ECC system in advance and correspond to each tool information table respectively, and the corresponding log recorders automatically copy updated data;

in this step, after the related configuration start synchronization is completed, the SLT module creates a corresponding trigger and a log recorder in a database table of the ECC system (source system), and when the ECC data is updated, the corresponding trigger is activated to trigger the log recorder to record the updated data in the source system.

And S13, synchronizing the update data to the HANA system by the SLT module, for example, synchronizing the update data to the HANA database specified SCHEMA, and creating a physical table.

In the embodiment, the SLT modules are synchronized in an incremental mode, so that the pressure of an ECC system, the SLT modules and an HANA system is reduced, and the data synchronization efficiency is improved.

Further, with reference to fig. 2, after step S12, the method further includes: s14, cleaning and converting the updated data; further, step S13 includes: and the SLT module synchronizes the processed update data to the HANA system. In this embodiment, the SLT module not only copies the update data, but also performs cleaning and conversion processing on the copied data, so as to further improve the logic processing efficiency of the HANA system.

Further, in an alternative embodiment, step S20 includes: the HANA system associates and logically processes the plurality of tool information tables according to a pre-created application model related to the application requirements of the user, to generate application data. In this embodiment, it should be noted that, an application model (HANA model) may be created based on a data logic diagram (as shown in fig. 3) according to the customized requirements of the user in advance, and the model may be verified and activated. When a user of the application system has access requirements, the synchronized tool data are associated and logically processed according to the model, and the performance is greatly improved.

In an alternative embodiment, step S30 includes: and the external application system accesses the application data through the micro-service and displays the application data at the front end.

Further, step S30 includes: receiving an access request sent by an external application system; judging whether the user sending the access request has access authority or not; and if the application data has the access authority, the application data is provided for an external application system to access and display through an interface. In the embodiment, the HANA system also has an authority control function, and in the embodiment, data access is only opened to users with access authority, so that isolation and security of externally provided data are guaranteed. It should be noted that there are 5 types of rights objects in the HANA system, which are: SQL authority, analysis authority, system authority, development kit authority and application authority. All operations need to have corresponding authority, and users can access the resources only after being granted with the corresponding authority, for example, fine-grained authority such as database table addition/deletion/modification/check, model package import/export and the like can realize authority control.

The present invention also constitutes a readable storage medium storing a computer program which, when executed by a processor, implements the steps of the method for accessing ECC tool information in real time as described above.

The present invention also provides a system for accessing ECC tool information in real time, the system including a processor and a memory storing a computer program, wherein the processor implements the steps of the method for accessing ECC tool information in real time when executing the computer program.

The invention also constructs a system for accessing the ECC tool information in real time, which comprises an SLT module 10 and an HANA system 20, wherein the SLT module 10 is used for synchronizing a plurality of tool information tables of the ECC system into the HANA system 20 in real time; the HANA system 20 is configured to perform association and logic processing on the plurality of tool information tables according to an application requirement of a user to generate application data, and provide the application data to an external application system through an interface for access and presentation.

Further, in an alternative embodiment, the SLT module is provided in the ECC system, i.e. the SLT module is installed on the ECC system, although in other embodiments it may be installed in a separate system.

The above description is only a preferred embodiment of the present invention and is not intended to limit the present invention, and various modifications and changes may be made by those skilled in the art. Any modification, equivalent replacement, or improvement made within the spirit and principle of the present invention should be included in the scope of the claims of the present invention.

Claims (10)

1. A method of accessing ECC tool information in real time, comprising:

s10, synchronizing a plurality of tool information tables of the ECC system into the HANA system in real time through an SLT module;

s20, the HANA system associates and logically processes the multiple tool and instrument information tables according to the application requirements of the user to generate application data;

and S30, providing the application data for an external application system to access and display through an interface.

2. The method for accessing ECC tool information in real time according to claim 1, wherein the step S10 includes:

s11, an SLT module receives connection configuration information input by a user, and establishes connection between the SLT module and the ECC system and connection between the SLT module and the HANA system respectively according to the connection configuration information;

s12, the SLT module activates a corresponding trigger when a corresponding tool and instrument information table is updated according to a plurality of triggers and log tables which are created in an ECC system in advance and correspond to each tool and instrument information table respectively, and the corresponding log tables automatically copy updated data;

and S13, synchronizing the updating data to the HANA system by the SLT module.

3. The method for accessing ECC tool information in real time according to claim 1, further comprising, after the step S12:

s14, cleaning and converting the updated data;

the step S13 includes:

and the SLT module synchronizes the processed update data to the HANA system.

4. The method for accessing ECC tool information in real time as claimed in claim 1, wherein the step S20 comprises:

the HANA system associates and logically processes the plurality of tool information tables according to a pre-created application model related to the application requirements of the user, to generate application data.

5. The method for accessing ECC tool information in real time according to claim 1, wherein the step S30 includes:

and the external application system accesses the application data through the micro-service and displays the application data at the front end.

6. The method for accessing ECC tool information in real time as claimed in claim 1, wherein the step S30 comprises:

receiving an access request sent by an external application system;

judging whether the user sending the access request has access authority or not;

and if the application data has the access authority, the application data is provided for an external application system to access and display through an interface.

7. A readable storage medium storing a computer program, wherein the computer program, when executed by a processor, implements the steps of the method of accessing ECC tool information in real time as claimed in any of claims 1-6.

8. A system for real-time access to ECC tool information, comprising a processor and a memory having a computer program stored thereon, wherein the processor, when executing the computer program, implements the steps of the method for real-time access to ECC tool information of any of claims 1-6.

9. A system for accessing ECC tool information in real time, which comprises an SLT module and an HANA system, wherein,

the SLT module is used for synchronizing a plurality of tool information tables of the ECC system into the HANA system in real time;

the HANA system is used for associating and logically processing the multiple tool information tables according to application requirements of users to generate application data, and providing the application data for an external application system to access and display through an interface.

10. The system for accessing ECC tool information in real time as claimed in claim 9, wherein the SLT module is provided in an ECC system.

Images