CN102419841A - Enterprise knowledge platform (EKP) system-based report center - Google Patents
Enterprise knowledge platform (EKP) system-based report center Download PDFInfo
- Publication number
- CN102419841A CN102419841A CN2011104329349A CN201110432934A CN102419841A CN 102419841 A CN102419841 A CN 102419841A CN 2011104329349 A CN2011104329349 A CN 2011104329349A CN 201110432934 A CN201110432934 A CN 201110432934A CN 102419841 A CN102419841 A CN 102419841A
- Authority
- CN
- China
- Prior art keywords
- data
- report
- sap
- interface module
- center
- 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.)
- Granted
Links
- 238000013461 design Methods 0.000 claims description 25
- 238000005516 engineering process Methods 0.000 description 5
- 241001269238 Data Species 0.000 description 4
- 230000006870 function Effects 0.000 description 4
- 238000010586 diagram Methods 0.000 description 2
- 238000013459 approach Methods 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 238000005314 correlation function Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000000034 method Methods 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
Images
Abstract
The embodiment of the invention discloses an enterprise knowledge platform (EKP) system-based report center, which comprises a service access point (SAP) connection pool connected with an SAP system, a data connecting interface module connected with at least one relational database, and a report engine respectively connected with the SAP connection pool and the data connecting interface module and used for acquiring data from the SAP system and the relational database through the SAP connection pool and the data connecting interface module. Therefore, the report center provides interfaces for acquiring various report data, and can meet the personalized requirements of users on reports.
Description
Technical field
The present invention relates to the management system field, relate in particular to a kind of form center based on the EKP system.
Background technology
Form is the basic measures and the approach of business administration, is the basic service requirement of enterprise, also is the basis of implementing business intelligence (BI, Business Intelligence) strategy.Form can help accessed enterprise, formatted data, and presents to the user to data message with reliable and safe mode.
At present; In the product industry of software report forms instrument; Main flow " solution of form " center " is put forward based on self tools production by all kinds of BI manufacturer mostly; its essence is based on the form exploitation on the existing function of self product, and the correlation function that provides through the BI instrument is realized the exploitation of all kinds of forms.
Yet; More and more enterprises or individual progressively carve the demand of form and dissolve increasing individual demand in the reality; Especially design the demand of different forms to the existing Various types of data of enterprise; It is thus clear that, based on develop on the existing function of self product " the form " center " can't satisfy user's demand.
Summary of the invention
The embodiment of the invention provides a kind of form center based on the EKP system, is used to provide the interface that obtains all kinds of report datas, satisfies the individual demand of user to form.
For solving the problems of the technologies described above, the embodiment of the invention provides following technical scheme:
A kind of form center based on enterprise knowledge door (EKP, Enterprise Knowledge Portal) system comprises:
The SAP connection pool that is connected with the SAP system;
The data connection interface module that is connected with at least one relevant database;
Be connected with above-mentioned data connection interface module with above-mentioned SAP connection pool respectively, be used for obtaining from above-mentioned SAP system and above-mentioned relation type database respectively the Report Engine of data through above-mentioned SAP connection pool and above-mentioned data connection interface module.
Further, above-mentioned Report Engine specifically is used for: obtain the Report Form Design template; From the EKP system database, obtain the preset parameter collection of above-mentioned Report Form Design module, wherein, above-mentioned preset parameter collection comprises the parameter value of at least one parameter item in the above-mentioned Report Form Design module; According to parameter item value of establishing of the above-mentioned Report Form Design template of above-mentioned preset parameter set pair, obtain the report data template; According to above-mentioned report data template, through in above-mentioned SAP connection pool and the above-mentioned data connection interface module at least one, at least one from above-mentioned SAP system and above-mentioned relation type database obtained report data; Export above-mentioned report data.
Further, above-mentioned Report Engine also is used for carrying out data-switching from least one data that get access to of above-mentioned SAP system and above-mentioned relation type database; Above-mentioned Report Engine is exported above-mentioned report data and is specially: Report Engine is exported the report data after the above-mentioned data-switching.
Further, above-mentioned form center also comprises: the application system interface that at least one is connected with outer application system; Above-mentioned Report Engine also is used for communicating through above-mentioned application system interface and said external application system.
Further, the data from above-mentioned SAP system, obtained of above-mentioned Report Engine comprise: the data acquisition of business application DLL BAPI function.
Further, above-mentioned SAP connection pool also is used for the data of the above-mentioned SAP of timing acquiring system.
Further, above-mentioned data connection interface module also is used for the data of above-mentioned at least one relevant database of timing acquiring.
Therefore; Integrated in the heart SAP connection pool and the data connection interface module that is connected with relevant database with the SAP system in the form in the embodiment of the invention; Through this SAP connection pool and this data connection interface module; Can realize from SAP system and relevant database, obtaining all kinds of report datas, thereby realize that all kinds of forms combine with the technology at form center, can satisfy the individual demand of user to form.
Description of drawings
In order to be illustrated more clearly in the embodiment of the invention or technical scheme of the prior art; To do to introduce simply to the accompanying drawing of required use in embodiment or the description of the Prior Art below; Obviously, the accompanying drawing in describing below only is some embodiments of the present invention, for those of ordinary skills; Under the prerequisite of not paying creative work property, can also obtain other accompanying drawing according to these accompanying drawings.
Fig. 1 is a kind of example structure synoptic diagram in form center based on the EKP system provided by the invention;
Fig. 2 is a kind of another example structure synoptic diagram of form center based on the EKP system provided by the invention.
Embodiment
The embodiment of the invention provides a kind of form center based on the EKP system.
For make goal of the invention of the present invention, characteristic, advantage can be more obvious and understandable; To combine the accompanying drawing in the embodiment of the invention below; Technical scheme in the embodiment of the invention is carried out clear, intactly description; Obviously, described embodiment only is the present invention's part embodiment, but not whole embodiment.Based on the embodiment among the present invention, those of ordinary skills are not making the every other embodiment that is obtained under the creative work prerequisite, all belong to the scope of the present invention's protection.
Describe in the face of a kind of form center based on the EKP system in the embodiment of the invention down, see also Fig. 1, a kind of form center 100 based on the EKP system comprises in the embodiment of the invention:
The SAP connection pool 101 that is connected with the A1 of SAP system;
The data connection interface module 102 that is connected with at least one relevant database A2;
Be connected with data connection interface module 102 with SAP connection pool 101 respectively, be used for obtaining from SAP system and relevant database respectively the Report Engine 103 of data through SAP connection pool 101 and data connection interface module 102.
In embodiments of the present invention; SAP connection pool 101 is realized by JAVA development interface class (like the JCO class); SAP connection pool 101 is incorporated in the form center 100, and form center 100 is connected to the SAP system through SAP connection pool 101, thereby realizes the data acquisition to the SAP system.
SAP is a Business Name; Be again that its product is the dbase of enterprise management solution; The SAP system has accumulated the service management flow of a large amount of advanced enterprises, in order to accomplish some special business task, as uploads transaction data etc.; Built-in business application DLL (BAPI in the SAP R/3 system; Business Application Programming Interface), BAPI is the batch processing interface in the Design Methods of Object Oriented Program, and it allows the programmer that third party software is integrated into the proprietary product of R/3.Therefore, in a kind of application scenarios, Report Engine 103 also can be obtained the data acquisition of BAPI function through SAP connection pool 101 from the SAP system.In a kind of application scenarios; Also can realize the timing acquiring of the data in 101 pairs of SAP systems of SAP connection pool through timer is set; Further; Can also be in SAP connection pool 101 the initialize data acquisition parameter, data acquisition parameters can comprise the data type, image data amount etc. that will gather, SAP connection pool 101 is regularly gathered corresponding data according to the data acquisition parameters that presets from the SAP system.
In embodiments of the present invention; Form center 100 is connected with at least one relevant database through data connection interface module 102; The data connection interface module can be realized by one or more JNDI interfaces; Wherein, the JNDI interface is one group of API (API, Application Programming Interface) of in JAVA uses, visiting name service and directory service.Report Engine 103 can realize from different relevant databases, obtaining data (like report data) through data connection interface module 102.In a kind of application scenarios; Also can realize the timing acquiring of data in 102 pairs of relevant databases of data connection interface module through timer is set; Further; Can also the initialize data acquisition parameter, data acquisition parameters can comprise data type that institute will gather, image data amount etc., and data connection interface module 102 is according to the data acquisition parameters that presets corresponding data of collection from relevant database regularly.
Therefore; Integrated in the heart SAP connection pool and the data connection interface module that is connected with relevant database with the SAP system in the form in the embodiment of the invention; Through this SAP connection pool and this data connection interface module; Can realize from SAP system and relevant database, obtaining all kinds of report datas, thereby realize that all kinds of forms combine with the technology at form center, can satisfy the individual demand of user to form.
Further describe in the face of form of the present invention center down.
In embodiments of the present invention, the Report Engine at form center specifically is used for: obtain the Report Form Design template; From the EKP system database, obtain the preset parameter collection of Report Form Design module, wherein, this preset parameter collection comprises the parameter value of at least one parameter item in the above-mentioned Report Form Design module; According to parameter item value of establishing of the above-mentioned Report Form Design template of this preset parameter set pair, obtain the report data template; According to above-mentioned report data template, through the SAP connection pool at this form center and at least one in the data connection interface module, at least one from SAP system and relevant database obtained report data; Output comprises the report data template of the report data that obtains.
In embodiments of the present invention; Can design form through report tool (like fast ease report tool); Obtain the Report Form Design template, the Report Form Design template is imported in the form in the heart, Report Engine is obtained the Report Form Design template of importing; And from the EKP system database of this locality, obtain the preset parameter collection of this Report Form Design module; In practical application, in the EKP system database, be provided for one or more parameter set in advance to the Report Form Design module value of establishing, this parameter set comprises the parameter value of at least one parameter item (as being parameter items such as data source parameter, statistical graph type parameter and form conditional parameter) in this Report Form Design module; Each Report Form Design module is corresponding to a parameter set, and configures the corresponding relation of Report Form Design template and parameter set.Report Engine to relevant parameter item value of establishing of this Report Form Design template, obtains the report data template according to the preset parameter collection of this Report Form Design template of obtaining; According to this report data template; Data source address (like SAP system address, relevant database) like this report data template indication; Report Engine is obtained required report data from respective data sources; In embodiments of the present invention, Report Engine can be passed through at least one in SAP connection pool and the data connection interface module, and at least one from corresponding SAP system and relevant database obtained report data; Simultaneously, Report Engine will comprise the report data template output of the report data that obtains, so that the user checks or other system applies.
Because the otherness of EKP system and SAP system, relevant database system; Make that the data layout of the data that Report Engine need be obtained is different with the data layout of the actual data that from SAP system and relevant database, get access to; Therefore; In a kind of application scenarios; Report Engine also is used at least one data that get access to from SAP system and relevant database are carried out data-switching, so that be the data layout of Report Engine actual needs with the Data Format Transform of the data that get access to.Illustrate; Report Engine can be according to above-mentioned report data template; From respective data sources, obtain required report data, and the data layout that requires according to reality is to carrying out data-switching with report data, final output comprises the report data template of the report data after the data-switching.
Further, the form center in the embodiment of the invention also comprises the application system interface module that at least one is connected with outer application system; As shown in Figure 2, the Report Engine 203 at form center 200 also is used for communicating by letter with the outer application system DOMINO B1 of system through application system interface module 204.In practical application, Report Engine 203 comprises the report data template of report data through application system interface module 204 to the B1 of DOMINO system transmission.Form SAP connection pool 201 in the embodiment of the invention can be connected with at least one relevant database A2 with the A1 of SAP system respectively like form SAP connection pool among Fig. 1 101 and data connection interface module 102 with data connection interface module 202.
Therefore; Integrated in the heart SAP connection pool and the data connection interface module that is connected with relevant database with the SAP system in the form in the embodiment of the invention; Through this SAP connection pool and this data connection interface module; Can realize from SAP system and relevant database, obtaining all kinds of report datas, thereby realize that all kinds of forms combine with the technology at form center, can satisfy the individual demand of user to form.And, application system interface module that the form center in the embodiment of the invention is integrated, thus can realize communicating with outer application system such as DOMINO system.
One of ordinary skill in the art will appreciate that all or part of action that realizes in the foregoing description is to instruct relevant hardware to accomplish through program; Described program can be stored in a kind of computer-readable recording medium; The above-mentioned storage medium of mentioning can be a ROM (read-only memory), random access memory, disk or CD etc.
More than detailed introduction has been carried out at a kind of form center based on the EKP system provided by the present invention; For one of ordinary skill in the art; Thought according to the embodiment of the invention; The part that on embodiment and range of application, all can change, to sum up, this description should not be construed as limitation of the present invention.
Claims (7)
1. the form center based on enterprise knowledge door EKP system is characterized in that, comprising:
The SAP connection pool that is connected with the SAP system;
The data connection interface module that is connected with at least one relevant database;
Be connected with said data connection interface module with said SAP connection pool respectively, be used for obtaining from said SAP system and said relevant database respectively the Report Engine of data through said SAP connection pool and said data connection interface module.
2. form according to claim 1 center is characterized in that,
Said Report Engine specifically is used for: obtain the Report Form Design template; From the EKP system database, obtain the preset parameter collection of said Report Form Design module, wherein, said preset parameter collection comprises the parameter value of at least one parameter item in the said Report Form Design module; According to parameter item value of establishing of the said Report Form Design template of said preset parameter set pair, obtain the report data template; According to said report data template, through in said SAP connection pool and the said data connection interface module at least one, at least one from said SAP system and said relevant database obtained report data; Output comprises the report data template of said report data.
3. form according to claim 2 center is characterized in that,
Said Report Engine also is used at least one data that get access to from said SAP system and said relevant database are carried out data-switching;
The said report data of said output is specially: output comprises the report data template of the report data after the said data-switching.
4. according to each described form center of claim 1 to 3, it is characterized in that,
Said form center also comprises: the application system interface module that at least one is connected with outer application system;
Said Report Engine also is used for communicating through said application system interface module and said outer application system.
5. according to each described form center of claim 1 to 3, it is characterized in that,
The data that said Report Engine is obtained from said SAP system comprise: the data acquisition of business application DLL BAPI function.
6. according to each described form center of claim 1 to 3, it is characterized in that,
Said SAP connection pool also is used for the data of the said SAP of timing acquiring system.
7. according to each described form center of claim 1 to 3, it is characterized in that,
Said data connection interface module also is used for the data of said at least one relevant database of timing acquiring.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201110432934.9A CN102419841B (en) | 2011-12-21 | 2011-12-21 | A kind of form center based on EKP system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201110432934.9A CN102419841B (en) | 2011-12-21 | 2011-12-21 | A kind of form center based on EKP system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102419841A true CN102419841A (en) | 2012-04-18 |
| CN102419841B CN102419841B (en) | 2016-04-27 |
Family
ID=45944242
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201110432934.9A Active CN102419841B (en) | 2011-12-21 | 2011-12-21 | A kind of form center based on EKP system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102419841B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106156339A (en) * | 2016-07-12 | 2016-11-23 | 泰康保险集团股份有限公司 | Declaration form the management access method of system, Apparatus and system |
| CN107122961A (en) * | 2017-05-16 | 2017-09-01 | 上海斐晟企业管理有限公司 | Excel nested report data processing methods based on SAP system |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1704936A (en) * | 2004-05-31 | 2005-12-07 | 深圳宇龙计算机通信科技（深圳）有限公司 | Data conversion or synchronization method between data bases |
| US7580915B2 (en) * | 2004-12-14 | 2009-08-25 | Sap Ag | Socket-like communication API for C |
| CN102156736A (en) * | 2011-04-12 | 2011-08-17 | 上海电通信息服务有限公司 | Method for transmitting data between SAP (Systems Application) system and SQL (Structured Query Language) database |
-
2011
- 2011-12-21 CN CN201110432934.9A patent/CN102419841B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1704936A (en) * | 2004-05-31 | 2005-12-07 | 深圳宇龙计算机通信科技（深圳）有限公司 | Data conversion or synchronization method between data bases |
| US7580915B2 (en) * | 2004-12-14 | 2009-08-25 | Sap Ag | Socket-like communication API for C |
| CN102156736A (en) * | 2011-04-12 | 2011-08-17 | 上海电通信息服务有限公司 | Method for transmitting data between SAP (Systems Application) system and SQL (Structured Query Language) database |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106156339A (en) * | 2016-07-12 | 2016-11-23 | 泰康保险集团股份有限公司 | Declaration form the management access method of system, Apparatus and system |
| CN107122961A (en) * | 2017-05-16 | 2017-09-01 | 上海斐晟企业管理有限公司 | Excel nested report data processing methods based on SAP system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102419841B (en) | 2016-04-27 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| TWI698108B (en) | Blockchain-based data processing method and device | |
| CN102859548B (en) | Product synthesis from multiple sources | |
| CN102682059B (en) | Method and system for distributing users to clusters | |
| Phaneendra et al. | Big Data-solutions for RDBMS problems-A survey | |
| CN102377790B (en) | A kind of method and apparatus of propelling data | |
| WO2008018080A3 (en) | Smart integration engine and metadata-oriented architecture for automatic eii and business integration | |
| CN104572895A (en) | MPP (Massively Parallel Processor) database and Hadoop cluster data intercommunication method, tool and realization method | |
| CN101593111A (en) | A kind of Service Component reaches the applied software development method and system based on Service Component | |
| CN102567408A (en) | Method and device for recommending search keyword | |
| CN105446991A (en) | Data storage method, query method and device | |
| CN103559619A (en) | Response method and system for garment size information | |
| CN109471718A (en) | Computing resource configuration method, device, equipment and medium based on recognition of face | |
| CN107783850B (en) | Method, device, server and system for analyzing node tree checking record | |
| CA3017606A1 (en) | Rule based hierarchical configuration | |
| CN102419841A (en) | Enterprise knowledge platform (EKP) system-based report center | |
| AU2014203425A1 (en) | Social workflow engine | |
| CN103617298A (en) | Data connecting method and data connector | |
| CN105677427A (en) | Module upgrading method and device | |
| WO2005022424A8 (en) | A data processing method, system and computer program | |
| CN101458628A (en) | Program edition management method | |
| US11204762B2 (en) | Systems and methods for tracking features in a development environment | |
| CN101778110B (en) | Service protocol mining method and device | |
| CN1963860A (en) | System and method for selecting excellence of finance product based on requirement of client | |
| CN102375825A (en) | Process integration server and method for realizing system integration by utilizing same | |
| IOVAN et al. | ENTERPRISE SERVICES ARCHITECTURE IN THE WORLD OF INFORMATION TECHNOLOGY. |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| PE01 | Entry into force of the registration of the contract for pledge of patent right | ||
| PE01 | Entry into force of the registration of the contract for pledge of patent right |
Denomination of invention: A Report Center Based on EKP System Effective date of registration: 20231212 Granted publication date: 20160427 Pledgee: Shenzhen hi tech investment small loan Co.,Ltd. Pledgor: SHENZHEN LANDRAY SOFTWARE Co.,Ltd. Registration number: Y2023980071066 |