CN102419841B - A kind of form center based on EKP system - Google Patents
A kind of form center based on EKP system Download PDFInfo
- Publication number
- CN102419841B CN102419841B CN201110432934.9A CN201110432934A CN102419841B CN 102419841 B CN102419841 B CN 102419841B CN 201110432934 A CN201110432934 A CN 201110432934A CN 102419841 B CN102419841 B CN 102419841B
- Authority
- CN
- China
- Prior art keywords
- data
- report
- sap
- interface module
- connection pool
- 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.)
- Active
Links
- 238000013461 design Methods 0.000 claims description 24
- 238000006243 chemical reaction Methods 0.000 claims description 7
- 230000006870 function Effects 0.000 description 4
- 238000000034 method Methods 0.000 description 4
- 238000010586 diagram Methods 0.000 description 2
- 238000005516 engineering process 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
- 238000012545 processing Methods 0.000 description 1
Abstract
The embodiment of the invention discloses a kind of form center based on Enterprise Knowledge Portal EKP system, comprising: the SAP connection pool be connected with SAP system; The Datalink Interface module be connected with at least one relevant database; Respectively with described SAP connection pool and described Datalink Interface model calling, for being obtained the Report Engine of data respectively from described SAP system and described relevant database by described SAP connection pool and described Datalink Interface module.Therefore the form center in the present invention provides the interface obtaining all kinds of report data, the individual demand of user to form can be met.
Description
Technical field
The present invention relates to management system field, particularly relate to a kind of form center based on EKP system.
Background technology
Form is basic measures and the approach of business administration, is the basic service requirement of enterprise, is also the basis of implementing business intelligence (BI, BusinessIntelligence) strategy.Form can help accessed enterprise, formatted data, and data message is presented to user in 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 has form exploitation on function based on self product, and the correlation function provided by BI instrument realizes the exploitation of all kinds of form.
But, in reality, increasing enterprise or individual progressively carve the demand of form and dissolve increasing individual demand, especially the demand of different form is designed for the existing Various types of data of enterprise, visible, based on self product have develop on function " form " center " cannot meet the demand of user.
Summary of the invention
Embodiments providing a kind of form center based on EKP system, for providing the interface obtaining all kinds of report data, meeting the individual demand of user to form.
For solving the problems of the technologies described above, the embodiment of the present invention provides following technical scheme:
A kind of form center based on Enterprise Knowledge Portal (EKP, EnterpriseKnowledgePortal) system, comprising:
The SAP connection pool be connected with SAP system;
The Datalink Interface module be connected with at least one relevant database;
Respectively with above-mentioned SAP connection pool and above-mentioned Datalink Interface model calling, for being obtained the Report Engine of data respectively from above-mentioned SAP system and above-mentioned relation type database by above-mentioned SAP connection pool and above-mentioned Datalink Interface module.
Further, above-mentioned Report Engine specifically for: obtain Report Form Design template; From 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 above-mentioned Report Form Design module; Parameter item according to the above-mentioned Report Form Design template of above-mentioned preset parameter set pair carries out establishing value, obtains report data template; According to above-mentioned report data template, by least one in above-mentioned SAP connection pool and above-mentioned Datalink Interface module, obtain report data from least one above-mentioned SAP system and above-mentioned relation type database; Export above-mentioned report data.
Further, above-mentioned Report Engine is also for carrying out data conversion to from least one data got in above-mentioned SAP system and above-mentioned relation type database; Above-mentioned Report Engine exports above-mentioned report data and is specially: Report Engine exports the report data after the conversion of above-mentioned data.
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 is also for communicating with said external application system by above-mentioned application system interface.
Further, the data that above-mentioned Report Engine obtains from above-mentioned SAP system comprise: the data acquisition of business application DLL (dynamic link library) BAPI function.
Further, above-mentioned SAP connection pool is also for the data in the above-mentioned SAP system of timing acquiring.
Further, above-mentioned Datalink Interface module is also for the data in timing acquiring at least one relevant database above-mentioned.
Therefore, the SAP connection pool and Datalink Interface module that are connected with SAP system and relevant database is integrated with in the heart in form in the embodiment of the present invention, by this SAP connection pool and this Datalink Interface module, can realize obtaining all kinds of report data from SAP system and relevant database, thus achieve the combine with technique at all kinds of form and form center, the individual demand of user to form can be met.
Accompanying drawing explanation
In order to be illustrated more clearly in the embodiment of the present invention or technical scheme of the prior art, be briefly described to the accompanying drawing used required in embodiment or description of the prior art below, apparently, accompanying drawing in the following describes is only some embodiments of the present invention, for those of ordinary skill in the art, under the prerequisite not paying creative work, other accompanying drawing can also be obtained according to these accompanying drawings.
Fig. 1 is a kind of one, form center example structure schematic diagram based on EKP system provided by the invention;
Fig. 2 is another example structure schematic diagram of a kind of form center based on EKP system provided by the invention.
Embodiment
Embodiments provide a kind of form center based on EKP system.
For making goal of the invention of the present invention, feature, advantage can be more obvious and understandable, below in conjunction with the accompanying drawing in the embodiment of the present invention, technical scheme in the embodiment of the present invention is clearly and completely described, obviously, described embodiment is only the present invention's part embodiment, and not all embodiments.Based on the embodiment in the present invention, those of ordinary skill in the art, not making the every other embodiment obtained under creative work prerequisite, belong to the scope of protection of the invention.
Be described the form center based on EKP system a kind of in the embodiment of the present invention below, refer to Fig. 1, in the embodiment of the present invention, a kind of form center 100 based on EKP system comprises:
The SAP connection pool 101 be connected with SAP system A1;
The Datalink Interface module 102 be connected with at least one relevant database A2;
Be connected with SAP connection pool 101 and Datalink Interface module 102 respectively, for being obtained the Report Engine 103 of data respectively from SAP system and relevant database by SAP connection pool 101 and Datalink Interface module 102.
In embodiments of the present invention, SAP connection pool 101 is realized by JAVA development interface class (as JCO class), SAP connection pool 101 is incorporated in form center 100, and form center 100 is connected to SAP system by SAP connection pool 101, thus realizes the data acquisition to SAP system.
SAP is Business Name, it is again the dbase of its product and enterprise management solution, SAP system have accumulated the service management flow of a large amount of advanced enterprises, in order to complete some special business task, as uploaded transaction data etc., built-in business application DLL (dynamic link library) (BAPI in SAPR/3 system, BusinessApplicationProgrammingInterface), BAPI is the batch processing interface in Design Methods of Object Oriented Program, and it allows programmer third party software to be integrated into the proprietary product of R/3.Therefore, in a kind of application scenarios, Report Engine 103 also obtains the data acquisition of BAPI function from SAP system by SAP connection pool 101.In a kind of application scenarios, also the timing acquiring of the data in SAP connection pool 101 pairs of SAP systems can be realized by arranging timer, further, can also in SAP connection pool 101 initialize data acquisition parameter, data acquisition parameters can comprise the data type, image data amount etc. that will gather, and SAP connection pool 101 gathers corresponding data according to the timing of preset data acquisition parameters from SAP system.
In embodiments of the present invention, form center 100 is connected with at least one relevant database by Datalink Interface module 102, Datalink Interface module can by one or more JNDI Interface realization, wherein, JNDI interface is one group of application programming interface (API, ApplicationProgrammingInterface) of accessing naming service and directory service in JAVA application.Report Engine 103, by Datalink Interface module 102, can realize from different relevant database, obtain data (as report data).In a kind of application scenarios, also the timing acquiring of data in Datalink Interface module 102 pairs of relevant databases can be realized by arranging timer, further, all right initialize data acquisition parameter, data acquisition parameters can comprise the data type, image data amount etc. that will gather, and Datalink Interface module 102 gathers corresponding data according to the timing of preset data acquisition parameters from relevant database.
Therefore, the SAP connection pool and Datalink Interface module that are connected with SAP system and relevant database is integrated with in the heart in form in the embodiment of the present invention, by this SAP connection pool and this Datalink Interface module, can realize obtaining all kinds of report data from SAP system and relevant database, thus achieve the combine with technique at all kinds of form and form center, the individual demand of user to form can be met.
Below form center of the present invention is described further.
In embodiments of the present invention, form center Report Engine specifically for: obtain Report Form Design template; From 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 above-mentioned Report Form Design module; Parameter item according to the above-mentioned Report Form Design template of this preset parameter set pair carries out establishing value, obtains report data template; According to above-mentioned report data template, by least one in the SAP connection pool at this form center and Datalink Interface module, obtain report data from least one SAP system and relevant database; Output packet is containing the report data template of the report data obtained.
In embodiments of the present invention, report tool (as the report tool that escapes soon) can be passed through design form, obtain Report Form Design template, Report Form Design template to be imported in form in the heart, Report Engine obtains the Report Form Design template imported, and from the EKP system database of this locality, obtain the preset parameter collection of this Report Form Design module, in actual applications, one or more parameter set for establishing value to Report Form Design module is pre-set in EKP system database, this parameter set comprises at least one parameter item in this Report Form Design module (as being data source parameter, the parameter items such as statistical graph type parameter and form conditional parameter) parameter value, each Report Form Design module corresponds to a parameter set, and set the corresponding relation of Report Form Design template and parameter set.Report Engine, according to the preset parameter collection of this Report Form Design template obtained, establishes value to the relevant parameter item of this Report Form Design template, obtains report data template; According to this report data template, as the data source address (as SAP system address, relevant database) of this report data template instruction, Report Engine obtains required report data from respective data sources, in embodiments of the present invention, Report Engine, by least one in SAP connection pool and Datalink Interface module, obtains report data from least one corresponding SAP system and relevant database; Meanwhile, the report data template comprising the report data of acquisition exports by Report Engine, so that user checks or the application of other system.
Due to the otherness of EKP system and SAP system, relevant database system, Report Engine is made to need the data layout of the data obtained different with the data layout of the actual data got from SAP system and relevant database, therefore, in a kind of application scenarios, Report Engine also for carrying out data conversion to from least one data got in SAP system and relevant database, to be the data layout of Report Engine actual needs by the Data Format Transform of the data got.Illustrate, Report Engine can according to above-mentioned report data template, from respective data sources, obtain required report data, and carry out data conversion according to the data layout of actual requirement to by report data, final output packet is containing the report data template of the report data after data conversion.
Further, the form center in the embodiment of the present invention also comprises at least one application system interface module be connected with outer application system; As shown in Figure 2, the Report Engine 203 at form center 200 is also for communicating with outer application system DOMINO system B1 by application system interface module 204.In actual applications, Report Engine 203, by application system interface module 204, contains the report data template of report data to DOMINO system B1 transmission package.Form SAP connection pool 201 in the embodiment of the present invention and Datalink Interface module 202 as the form SAP connection pool 101 in Fig. 1 and Datalink Interface module 102, can be connected with SAP system A1 and at least one relevant database A2 respectively.
Therefore, the SAP connection pool and Datalink Interface module that are connected with SAP system and relevant database is integrated with in the heart in form in the embodiment of the present invention, by this SAP connection pool and this Datalink Interface module, can realize obtaining all kinds of report data from SAP system and relevant database, thus achieve the combine with technique at all kinds of form and form center, the individual demand of user to form can be met.Further, the form center in the embodiment of the present invention is integrated with application system interface module, thus can realize with outer application system as DOMINO system communicates.
One of ordinary skill in the art will appreciate that all or part of action realized in above-described embodiment is that the hardware that can carry out instruction relevant by program completes, described program can be stored in a kind of computer-readable recording medium, the above-mentioned storage medium mentioned can be ROM (read-only memory), random access memory, disk or CD etc.
Above a kind of form center based on EKP system provided by the present invention is described in detail, for one of ordinary skill in the art, according to the thought of the embodiment of the present invention, all will change in specific embodiments and applications, to sum up, this description should not be construed as limitation of the present invention.
Claims (6)
1., based on a form center for Enterprise Knowledge Portal EKP system, it is characterized in that, comprising:
The SAP connection pool be connected with SAP system;
The Datalink Interface module be connected with at least one relevant database;
Respectively with described SAP connection pool and described Datalink Interface model calling, from described SAP system and described relevant database, obtained the Report Engine of data respectively by described SAP connection pool and described Datalink Interface module for the data source address that indicates according to report data template;
Described Report Engine specifically for: obtain Report Form Design template; From EKP system database, obtain the preset parameter collection of described Report Form Design module, wherein, described preset parameter collection comprises the parameter value of at least one parameter item in described Report Form Design module; According to described preset parameter set pair, the parameter item of Report Form Design template carries out establishing value, obtains described report data template; According to the data source address of described report data template instruction, by least one in described SAP connection pool and described Datalink Interface module, obtain report data from least one described SAP system and described relevant database; Output packet is containing the report data template of described report data.
2. form center according to claim 1, is characterized in that,
Described Report Engine is also for carrying out data conversion to from least one data got in described SAP system and described relevant database;
Described output described report data template is specially: output packet is containing the report data template of the report data after described data conversion.
3. form center according to claim 1 and 2, is characterized in that,
Described form center also comprises: the application system interface module that at least one is connected with outer application system;
Described Report Engine is also for communicating with described outer application system by described application system interface module.
4. form center according to claim 1 and 2, is characterized in that,
The data that described Report Engine obtains from described SAP system comprise: the data acquisition of business application DLL (dynamic link library) BAPI function.
5. form center according to claim 1 and 2, is characterized in that,
Described SAP connection pool is also for the data in SAP system described in timing acquiring.
6. form center according to claim 1 and 2, is characterized in that,
Described Datalink Interface module is also for the data at least one relevant database described in 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 CN102419841A (en) | 2012-04-18 |
| CN102419841B true 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) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106156339B (en) * | 2016-07-12 | 2019-08-16 | 泰康保险集团股份有限公司 | The access method of declaration form management 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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102419841A (en) | 2012-04-18 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| TWI698108B (en) | Blockchain-based data processing method and device | |
| CN103247003B (en) | Towards the distributed program transaction system of event handling | |
| CN109831478A (en) | Rule-based and model distributed processing intelligent decision system and method in real time | |
| CN101819529A (en) | System and method for realizing visual development of workflow task interface | |
| CN103646111A (en) | System and method for realizing real-time data association in big data environment | |
| CN102810057A (en) | Log recording method | |
| CN104572895A (en) | MPP (Massively Parallel Processor) database and Hadoop cluster data intercommunication method, tool and realization method | |
| CN104574242A (en) | Intelligent drug tracing system | |
| CN108520008A (en) | The construction method and construction device of data warehouse model | |
| CN104317970A (en) | Data flow type processing method based on data processing center | |
| CN105224289A (en) | A kind of action message matching process and equipment | |
| CN110750530B (en) | Service system and data checking method thereof | |
| CN109471718A (en) | Computing resource configuration method, device, equipment and medium based on recognition of face | |
| CN102419841B (en) | A kind of form center based on EKP system | |
| CN114254374B (en) | Data tracing method and system | |
| CN111464658A (en) | Tea leaf credible tracing system based on block chain and use method thereof | |
| CN203250312U (en) | Extensible common core processing daughter board with interferences | |
| CN109542863A (en) | Mine machine system is dug in artificial intelligence storage | |
| CN101894317A (en) | System and method for driving business logic through data changes | |
| CN111966739A (en) | Method and equipment for processing graph data | |
| CN106780039A (en) | The method and system of processing information | |
| CN204331731U (en) | A kind of product automatic assembly design system based on Pro/E | |
| DE102014114829A1 (en) | Intelligent mesh object list construction | |
| CN112417018B (en) | Data sharing method and device | |
| CN114328486A (en) | Data quality checking method and device based on model |
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 |