CN102156736A - Method for transmitting data between SAP (Systems Application) system and SQL (Structured Query Language) database - Google Patents
Method for transmitting data between SAP (Systems Application) system and SQL (Structured Query Language) database Download PDFInfo
- Publication number
- CN102156736A CN102156736A CN 201110090696 CN201110090696A CN102156736A CN 102156736 A CN102156736 A CN 102156736A CN 201110090696 CN201110090696 CN 201110090696 CN 201110090696 A CN201110090696 A CN 201110090696A CN 102156736 A CN102156736 A CN 102156736A
- Authority
- CN
- China
- Prior art keywords
- data
- sap
- sql database
- data transmission
- information set
- 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
- 238000000034 method Methods 0.000 title claims abstract description 39
- 230000005540 biological transmission Effects 0.000 claims abstract description 99
- 230000006870 function Effects 0.000 claims abstract description 13
- 238000012545 processing Methods 0.000 claims description 25
- 238000006243 chemical reaction Methods 0.000 claims description 22
- 239000000284 extract Substances 0.000 claims description 12
- 230000008859 change Effects 0.000 claims description 10
- 230000008569 process Effects 0.000 claims description 10
- 238000012216 screening Methods 0.000 claims description 5
- 230000009466 transformation Effects 0.000 claims description 3
- 230000001131 transforming effect Effects 0.000 claims description 3
- 238000012423 maintenance Methods 0.000 abstract description 6
- 238000011161 development Methods 0.000 abstract description 5
- 230000010354 integration Effects 0.000 abstract description 3
- 238000013075 data extraction Methods 0.000 abstract 1
- 238000010586 diagram Methods 0.000 description 13
- 238000004458 analytical method Methods 0.000 description 5
- 238000007726 management method Methods 0.000 description 4
- 238000010276 construction Methods 0.000 description 3
- 238000011835 investigation Methods 0.000 description 3
- 238000007405 data analysis Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 230000008901 benefit Effects 0.000 description 1
- 230000001364 causal effect Effects 0.000 description 1
- 238000012937 correction Methods 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000000605 extraction Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012552 review Methods 0.000 description 1
- 238000000060 site-specific infrared dichroism spectroscopy Methods 0.000 description 1
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
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
The present invention relates to field of data transmission, relate to a kind of specifically at Enterprise Resources Plan (Enterprise Resource Planning, be called for short ERP) soft SA P(Systems, Applications, and Products in Data Processing is hereinafter to be referred as SAP) and SQL database between data transmission method.
Background technology
Along with the development of e-commerce technology, enterprise application software reaches its maturity SAP(Systems, Applications, and Products in Data Processing) utilization of system is also more and more universal; Also as the giant of ERP industry, its versatility has almost contained the business of industry-by-industry to SAP software.And the SAP system is when being used for data analyses such as management, operation in enterprise, because the special and complicacy of SAP data store organisation, the requirement of construction schedule length and professional knowledge, this will make the performance analysis data of a large amount of preciousnesses of storing among the SAP be utilized effectively.
Show have 23.9% user SAP online implementing purpose to be to improve speed of decision in the investigation result in November, 2005 according to the IT market professional investigation Norkresearch of company; Problem after meanwhile Gartner company (IT survey of demands chamber) reaches the standard grade to SAP user has been carried out relevant survey, and the result shows has 23.9% user that the SAP system is represented to be discontented with for the solution in operation information management and the decision support equally.
And at present, at the problems referred to above of SAP data analysis, existing common scheme mainly is:
1. pass through the ABAP(Advanced Business Application Programming of SAP system, hereinafter to be referred as ABAP) special program language customization data analytical statement, but aforesaid way is subjected to the data quantitative limitation, is not suitable for the statistics of large-scale data.And be subjected to the professional restriction of programming tool, programming personnel's labour cost is higher relatively, has significantly promoted development cost, in case the professional form content that changes, certainly will produce the operation and maintenance expenses of revising once more etc. when object information changes and use.
2. by other machine words make peace business applications interface (Business Application Process Interface is hereinafter to be referred as BAPI) and (Remote Function Call is hereinafter to be referred as RFC) remote function calls interface of environment calls SAP system, but this solution relates to development technique equally and requires and the cost height, and the construction cycle is long.When changing, business also caused follow-up operation and maintenance expenses such as correction once more to use.
3. use SAP BW(Business informationWarehouse) performance realize the transmission of data, but this mode since professional, cost, follow-up operation and maintenance expenses with too high and can't be adopted by most of enterprise.
Summary of the invention
At the problems referred to above, the purpose of this invention is to provide the method for data transmission between a kind of SAP system and the SQL database, call SSIS(SQL Server Integration Service cheaply; Hereinafter to be referred as SSIS) high-performance data integrated solution platform, avoid data volume excessive, professional, cost, follow-up operation and maintenance expenses are with too high problem, the transmission that realized not having programming, simple setting can realize data.
In order to achieve the above object, technical scheme of the present invention is as follows.
The method of data transmission between SAP system and the SQL database may further comprise the steps:
(1) in the SAP system, makes up the SAP information set inquiry of extracting the SAP system data;
(2) in SQL database, set the parameter that receives the SAP system data from the inquiry of SAP information set;
(3) set up the SSIS that contains data transmission event and carry out bag, operation SSIS carries out bag the SAP system data is transferred in the SQL database.
Further, above-mentioned steps (1) specifically may further comprise the steps:
(1.1) the SAP system data that extracts in the tables of data of definition SAP information set inquiry from the SAP system, view, the logical data base;
(1.2) definition SAP information set extracts the mode of SAP system data, and it comprises the screening conditions and the output form of data.
Described step (2) specifically may further comprise the steps:
(2.1) connection attribute of setting SQL database and SAP system;
(2.2) create the query note file, and define the SAP information set inquiry that this query note file calls, and the SQL database table that receives SAP information set inquiry output data;
(2.3) definition according to the query note file generates the SQL database table, and described SQL database table comprises middle table and full mirror list, and defines the major key field of full mirror list.
Described step (3) specifically may further comprise the steps:
(3.1) create SSIS and carry out bag;
(3.2) definition SSIS carries out interior data transmission event of bag and the variable in each incident, and described data transmission event comprises middle table data transmission, full mirror list data transmission;
(3.3) operation SSIS carries out bag, and the SAP system data is transferred in the SQL database table.
Further, in the described step (3.3), the step that operation SSIS carries out bag comprises: (3.3.1) the SAP system data that will extract from the inquiry of SAP information set writes in the middle table; (3.3.2) with the data transmission in the middle table in full mirror list; (3.3.3) operation result is write daily record, SSIS carries out the bag normal termination or carries out error handling processing.
Preferably, in the described step (3.3.1), the data type in the middle table is a Unicode type text.
Preferably, in the described step (3.3.1), comprise also that before writing middle table according to predefined Structure Conversion function the data of SAP information set inquiry output being carried out the list structure change handles.
Preferably, in the described step (3.3.2), the data type in the full mirror list converts to consistent with data type in the inquiry of SAP information set by predefined transforming function transformation function.
Preferably, the variable that is provided with in step (3.2) comprises data pick-up key assignments variable, then after the full mirror list data of step (3.3.2) transmit successfully, comprises that also carrying out variable update according to the data pick-up that is provided with the key assignments variable handles.
In the described step (3.3.2), the middle table data transmission adopts complete transmission or incremental transmission to the mode in the full mirror list.
Described incremental transmission is according to the major key field that defines in the full mirror list middle table data to be mated, and can adopt according to matching result and add the data that full mirror list does not have, and upgrade the variance data that has existed in the full mirror list.After also can deleting the data that existed in the full mirror list, add the variance data in the middle table again according to matching result.
Described step (1.2) also comprises before, and packetization process is carried out in the SAP information set inquiry of definition.
Again, also comprise definitional language conversion view and corresponding language conversion dictionary thereof in the described step (2.3), comprise also in the described step (3.3.2) that language conversion view and the language conversion dictionary according to definition carries out the language conversion processing to the field in the full mirror list.
Major advantage of the present invention is as follows.
As above-mentioned data transmission method of the present invention,, removed the operation of the professional development language report customization of the ABAP of SAP system from owing to the data pick-up mode that has adopted based on SAP set of system information query function; Carry out data transmission and adopt ripe at present SSIS to carry out bag (SSIS Package), can realize data transmission immediately, realize the data transmission between SAP and the SQL database easily by simple event argument definition.Therefore, the present invention has significantly shortened the ABAP construction cycle of SAP system, and is simultaneously easy and simple to handle, greatly the minimizing of degree the requirement of professional knowledge, can effectively reduce the huge expense expenditure of exploitation and follow-up O﹠M.
In addition, the present invention sets up middle table and full mirror list respectively in the data receiver SQL database, adopt SSIS to carry out and wrap the data transmission of finishing step by step middle table and full mirror list.Full mirror list carries out increment to the data of the data of middle table transmission and transmission in the past and merges, thereby has realized the incremental transmission management of advanced science, can remove from huge data volume repeat obtain, reduced system loading, reduced data transmission period.
Description of drawings
Fig. 1 is the schematic flow sheet of data transmission method between SAP system of the present invention and the SQL database.
Fig. 2 is the detailed process synoptic diagram of data transmission method one embodiment of the present invention.
Fig. 3 is that SSID carries out the capable schematic flow sheet of contracted affreightment in the data transmission method of the present invention.
Fig. 4 is the exemplary plot of the special data form of SAP information set inquiry output in the data transmission method of the present invention.
Fig. 5, Fig. 6 are the interface synoptic diagram that data are extracted in the inquiry of definition SAP information set among the present invention.
Fig. 7, Fig. 8 are to SAP information set inquiry packets processing interface synoptic diagram among the present invention.
Fig. 9 is the interface synoptic diagram that data mode is extracted in the inquiry of definition SAP information set among the present invention.
Figure 10 is the interface synoptic diagram that SAP system and SQL database connection attribute are set among the present invention.
Figure 11 is an interface synoptic diagram of creating the query note file among the present invention.
Figure 12 is an interface synoptic diagram of creating the SQL database table among the present invention.
Figure 13 is the interface synoptic diagram of the main mirror list major key field of definition among the present invention.
Figure 14 ~ Figure 16 is that the present invention adopts SSIS to carry out the interface synoptic diagram that bag carries out data transmission.
Figure 17 is that the present invention inquires about the interface synoptic diagram that SSIS carries out the bag result in daily record.
Figure 18 be the present invention primary mirror as file in the interface synoptic diagram of data after the query transmission.
Embodiment
Further specify transmission data procedures of the present invention below in conjunction with drawings and Examples.
Referring to Fig. 1, shown in Figure 2, the method for data transmission between SAP system of the present invention and the SQL database may further comprise the steps:
Step 1: make up the SAP information set inquiry of extracting the SAP system data in the SAP system, it comprises:
Step 101: the SAP system data that extracts in the tables of data of definition SAP information set inquiry from the SAP system, view, the logical data base;
Step 102: packetization process is carried out in the SAP information set inquiry to definition;
Step 103: definition SAP information set extracts the mode of SAP system data, and it comprises the screening conditions and the output form of data.
Step 2: set the parameter that receives the SAP system data from the inquiry of SAP information set in SQL database, it comprises:
Step 201: the connection attribute of setting SQL database and SAP system;
Step 202: create the query note file, and define the SAP information set inquiry that this query note file calls, and the SQL database table that receives SAP information set inquiry output data;
Step 203: the definition according to the query note file generates the SQL database table, and described SQL database table comprises middle table and full mirror list, and definitional language is changed view and corresponding language conversion dictionary thereof, and defines the major key field of full mirror list.
Step 3: set up the SSIS that contains data transmission event and carry out bag, operation SSIS carries out bag the SAP system data is transferred in the SQL database, and it comprises:
Step 301: create SSIS and carry out bag;
Step 302: definition SSIS carries out interior data transmission event of bag and the variable in each incident, and described data transmission event comprises middle table data transmission, full mirror list data transmission;
Step 303: operation SSIS carries out bag, and the SAP system data is transferred in the SQL database table.
Referring to shown in Figure 3, described step 303 specifically comprises:
Step 3031: the SAP system data that will extract from the inquiry of SAP information set writes in the middle table;
Step 3032: with the data transmission in the middle table in full mirror list;
Step 3033: operation result is write daily record, and SSIS carries out the bag normal termination or carries out error handling processing.
In the present embodiment, the concrete operations in the capable process of above-mentioned SSIS execution contracted affreightment are as follows.
1, the data that extract from the SAP system write the processing of middle table.
The data type of each field of middle table is the text of Unicode type.Can change the data lack of standardization of output from the inquiry of the information set of SAP (data mode lack of standardization can referring to the sample that provides among Fig. 4) by such processing.
For example, the inside of outbound time data is defined as 40000 of numeric type, and output form is 4:00:00.If carry out strict dtd for these data, may cause data to write and make mistakes, and be difficult to review error reason afterwards.Therefore be that the data that are defined as the corresponding SQL database of text are preserved basically.If in the processing procedure of back, make a mistake, so also can be because of the middle table data there being, making the easier of causal investigation change of makeing mistakes.
Can realize writing middle table by the mode of calling objPslETLWrapper.extractIMTable (＜＜PROFILENAME〉〉) and handle, wherein＜＜PROFILENAME〉the middle table title pointed to of representative.After the operation, carry out following the processing: according to the SAP information set inquiry of setting among the middle table PROFILENAME, carry out SAP user and organize corresponding information set inquiry, and the result that the inquiry of SAP information set is carried out deposits in the middle table PROFILENAME of the SQL database of appointment in the SQL data.
2, full mirror list transmission process.
Full mirror list transmission process is that execution is carried out the processing that increment merges to the data of middle table and the data of transmission in the past, uses defined full mirror list major key field information, and data waiting for transmission are mated and increment merging processing.
Full mirror list is with the database table after the data increment merging of middle table and transmission in the past.In the present embodiment, be different from above-mentioned middle table transmission, the definition that the conventional data of the data type of full mirror list and the inquiry of SAP information set is consistent, therefore carrying out intermediate list when full mirror list transmits data processing, need carry out the conversion process of data type by the transforming function transformation function that sets in advance.
It is for when analysis project is set in follow-up operation information analysis etc. that full mirror list data type is carried out strict the setting, correct Identification Date, and data types such as numerical value, and help setting matters such as cube.And if data type can not be identified, the processing such as total such as measured value can't automatically perform so.
When full mirror list transmits, adopt the mode of incremental transmission only the variance data of storing in the middle table to be transferred to the efficient that can improve data transmission in the full mirror list greatly.The mode of incremental transmission is to be provided with by the variable in the data transmission event, and it is as follows to carry out the processing detailed process.
By issuing orders, the data of the middle table IMTABLENAME in the DBPROFILE are transmitted to full mirror list FLTABLENAME:
objPslETLWrapper.transferFLTable(<<IMTABLENAME>>,?_?<<FLTABLENAME>>,?_?<<DBPROFILE>>,?_?<<TRANSFERMODE>>)
Wherein, variable＜＜IMTABLENAME〉be the title that will transmit the middle table of data,＜＜FLTABLENAME〉〉 be the title that is used to receive the full mirror list of middle table data,＜＜TRANSFERMODE〉〉 be the transmission mode of data, variable TRANSFERMODE can be set to complete transmission mode TI, the perhaps UI of incremental transmission mode or DI as required.
When TRANSFERMODE is set to TI, delete all records in the full mirror list when carrying out transmission earlier, carry out the transmission of middle table again, a promptly full transmission.
As preferably, can adopt the mode of following incremental transmission.
When TRANSFERMODE is set to UI, according to the major key field that is provided with in the full mirror list middle table data are mated when carrying out transmission, add the data that full mirror list does not have, upgrade the data that full mirror list has existed.
When TRANSFERMODE is set to DI, according to the major key field that is provided with in the full mirror list middle table data are mated when carrying out transmission, delete the data that existed in the full mirror list after, add the middle table data again.Because this pattern can be added the deletion earlier of renewable data again, thus the information of appending row in the full mirror list can not be kept, but on the other hand, the treatment effeciency of this pattern is than UI height.
3, the Schema change is handled.
It is that the change of execution list structure is handled that Schema change is handled, if when normalized SAP table structure is difficult to analyze, can change the structure that Schema preserves in the middle table of SQL database.Therefore, before data write middle table, can carry out the list structure change according to predefined Structure Conversion function to the data of SAP information set inquiry output earlier handles, for example: the change process of ranks, append not enough field etc., thereby make middle table preserve data, make things convenient for subsequent analysis processing in the most appropriate mode.
4, variable update is handled.
If when definition of data transmission events variable, used data pick-up key assignments variable, need after transmitting successfully, full mirror image data, upgrade processing so to the variable that transmits according to the data pick-up key assignments variable of setting.Performance variable upgrades again after full mirror image data transmits successfully, is for when full mirror image data transmits failure, prevents that data from unconformable situation taking place.
5, language conversion is handled.
So-called language conversion view, it is the expression view that the field in the full mirror list is carried out language conversion according to the definition of language conversion dictionary, the present invention shows according to the language storage that language conversion view and language conversion dictionary can convert the field name in the full mirror list to needs automatically when full mirror list transmission, is convenient to check and follow-up Treatment Analysis.
6, aftertreatment.
The information of SSIS normal termination is write in the daily record, carry out the normal termination of bag and handle.
7, error handling processing
If make a mistake in the above-mentioned processing, will carry out error handling processing, error message is write in the daily record, carry out end-of-packet and handle.
Below with reference to Fig. 5 ~ operation interface synoptic diagram shown in Figure 17, describe the implementation procedure of data transmission method of the present invention in detail.
Fig. 5 is the synoptic diagram that the tables of data of data is extracted in the inquiry of definition SAP information set.As shown in Figure 5, the system data that the SAP information set inquiry that defines in the present embodiment is extracted from the SAP system is tables of data VBAP(PSL_SDT_VBAP).
Enter interface shown in Figure 6 behind the selected data Table V BAP.In Fig. 6, the interface left column is the total data field that is comprised among the tables of data VBAP, and the user can select as required need call data, and display field then is the field of screening back output in the forms of the right.
Management for the ease of the SAP system, information set to definition in the present embodiment is inquired about the packetization process of carrying out based on user's group, as shown in Figure 7, create user's group that name is called " selling the relevant inquiring group ", and the tables of data VBAP that in interface shown in Figure 8 needs is called is assigned to this user group, can define, add, calls the inquiry of SAP information set and realize that the extraction of data transmits in user's group of being created.
After setting up grouping, enter interface shown in Figure 9 and can define screening conditions and the output form that data are extracted in the inquiry of SAP information set, the field (in the present embodiment) that can choose out the field that will inquire about in the tables of data and will export in the forms of left side among Fig. 9, then be that the condition that data are screened is defined in the forms of right side, extract qualified data as required, the content of output below show in the forms.
Finish to the SAP information set of data transmit leg SAP system query-defined after, need make relevant parameters to data take over party SQL database and set, to receive the SAP system data that the inquiry of SAP information set is extracted.
At first, be created to the connection of SAP system as shown in figure 10, SQL database and SAP system connection attribute are defined, comprise necessary attributes such as IP address, system's numbering, access username, password.
After creating connection, also need to create the query note file and define the concrete parameter that receives the SAP system data.As shown in figure 11, the parameter of definition comprises the SAP information set inquiry " PSL_SDM_VBAP " that will call, the user organizes " PSL_SD_TRNS ", and the SQL database table name that is used to receive data that definition will be created claims, in the present embodiment, the SQL database table of definition is middle table (IM table) " PSL_SDM_IM_VBAP " and full mirror list (FL table) " PSL_SDM_FL_VBAP ".
Behind the definition database table, can create corresponding data list file according to definition.As Figure 12 the title and the attribute (middle table/full mirror list) of the data list file that will generate are defined, and definitional language conversion view, click " executions " create corresponding middle table and full mirror list enter interface shown in Figure 13.Open full mirror list PSL_SDM_FL_VBAP among Figure 13, the major key field (PRIMARY_KEY) of selected full mirror list in the field that the right side shows, this major key field will be used to mate incremental data when transmission.
After finishing setting to data transmit leg SAP system and data receiver's SQL database, can be by the processing of SSIS Platform Implementation data transmission, Figure 14 ~ Figure 16 is that the present invention adopts SSIS to carry out the embodiment that bag carries out data transmission, wherein SSIS carries out design, the execution of wrapping and all adopts patterned display mode, and is convenient directly perceived.
Be that the SSIS that creates carries out bag among Figure 14, what middle forms showed is that patterned SSIS carries out the bag control flow, on behalf of SSIS, each square frame carry out the data transmission event of definition in the bag among the figure, and the variable in the incident shows in the forms in the upper right corner, interface and sets, be the event setup of underway table data transmission among the figure, need in the variable window parameters such as SAP information set Query Name that will extract data are set.
Same, to set the variable of full mirror list data transmission among Figure 15, need to middle table name claim, parameters such as full mirror list title, transmission mode set.
After finishing the setting of data transmission event and each event variable, can move SSIS and carry out bag, carry out data transmission and processing.Confirm execution result after the execution as shown in figure 16, all shown in green being runs succeeded, and object information will be recorded in the daily record.
The SSIS execution bag processing result information that is recorded in the daily record can be inquired about in interface shown in Figure 17.
Interface shown in Figure 180 can be after finishing data transmission primary mirror as the data after inquiry is upgraded in the file.
It is to be noted; the above only is a preferred embodiment of the present invention, does not constitute the restriction to technical solution of the present invention, and is within the spirit and principles in the present invention every; the modification of being done, be equal to replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (12)
1.SAP the method for data transmission is characterized in that between system and the SQL database, may further comprise the steps:
(1) in the SAP system, makes up the SAP information set inquiry of extracting the SAP system data;
(2) in SQL database, set the parameter that receives the SAP system data from the inquiry of SAP information set;
(3) set up the SSIS that contains data transmission event and carry out bag, operation SSIS carries out bag the SAP system data is transferred in the SQL database.
2. the method for data transmission is characterized in that between SAP system as claimed in claim 1 and the SQL database, and described step (1) may further comprise the steps:
(1.1) the SAP system data that extracts in the tables of data of definition SAP information set inquiry from the SAP system, view, the logical data base;
(1.2) definition SAP information set extracts the mode of SAP system data, and it comprises the screening conditions and the output form of data;
Described step (2) may further comprise the steps:
(2.1) connection attribute of setting SQL database and SAP system;
(2.2) create the query note file, and define the SAP information set inquiry that this query note file calls, and the SQL database table that receives SAP information set inquiry output data;
(2.3) definition according to the query note file generates the SQL database table, and described SQL database table comprises middle table and full mirror list, and defines the major key field of full mirror list;
Described step (3) may further comprise the steps:
(3.1) create SSIS and carry out bag;
(3.2) definition SSIS carries out interior data transmission event of bag and the variable in each incident, and described data transmission event comprises middle table data transmission, full mirror list data transmission;
(3.3) operation SSIS carries out bag, and the SAP system data is transferred in the SQL database table.
3. the method for data transmission between SAP system as claimed in claim 2 and the SQL database, it is characterized in that, in the described step (3.3), the step that operation SSIS carries out bag comprises: (3.3.1) the SAP system data that will extract from the inquiry of SAP information set writes in the middle table; (3.3.2) with the data transmission in the middle table in full mirror list; (3.3.3) operation result is write daily record, SSIS carries out the bag normal termination or carries out error handling processing.
4. the method for data transmission is characterized in that between SAP system as claimed in claim 3 and the SQL database, and in the described step (3.3.1), the data type in the middle table is a Unicode type text.
5. the method for data transmission between SAP system as claimed in claim 3 and the SQL database, it is characterized in that, in the described step (3.3.1), comprise also that before writing middle table according to predefined Structure Conversion function the data of SAP information set inquiry output being carried out the list structure change handles.
6. as the method for data transmission between claim 3 or 4 or 5 described SAP systems and the SQL database, it is characterized in that, in the described step (3.3.2), the data type in the full mirror list converts to consistent with data type in the inquiry of SAP information set by predefined transforming function transformation function.
7. the method for data transmission between SAP system as claimed in claim 3 and the SQL database, it is characterized in that, the variable that is provided with in step (3.2) comprises data pick-up key assignments variable, then after the full mirror list data of step (3.3.2) transmit successfully, comprise that also carrying out variable update according to the data pick-up that is provided with the key assignments variable handles.
8. the method for data transmission is characterized in that between SAP system as claimed in claim 3 and the SQL database, and in the described step (3.3.2), the middle table data transmission adopts complete transmission or incremental transmission to the mode in the full mirror list.
9. the method for data transmission between SAP system as claimed in claim 8 and the SQL database, it is characterized in that, described incremental transmission is according to the major key field that defines in the full mirror list middle table data to be mated, add the data that full mirror list does not have according to matching result, and upgrade the variance data that has existed in the full mirror list.
10. the method for data transmission between SAP system as claimed in claim 8 and the SQL database, it is characterized in that, described incremental transmission is according to the major key field that defines in the full mirror list middle table data to be mated, after deleting the data that existed in the full mirror list according to matching result, add the variance data in the middle table again.
11. the method for data transmission is characterized in that between SAP system as claimed in claim 2 and the SQL database, described step (1.2) also comprises before, and packetization process is carried out in the SAP information set inquiry of definition.
12. the method for data transmission between SAP system as claimed in claim 3 and the SQL database, it is characterized in that, also comprise definitional language conversion view and corresponding language conversion dictionary thereof in the described step (2.3), comprise also in the described step (3.3.2) that language conversion view and the language conversion dictionary according to definition carries out the language conversion processing to the field in the full mirror list.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 201110090696 CN102156736A (en) | 2011-04-12 | 2011-04-12 | Method for transmitting data between SAP (Systems Application) system and SQL (Structured Query Language) database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 201110090696 CN102156736A (en) | 2011-04-12 | 2011-04-12 | Method for transmitting data between SAP (Systems Application) system and SQL (Structured Query Language) database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102156736A true CN102156736A (en) | 2011-08-17 |
Family
ID=44438235
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 201110090696 Pending CN102156736A (en) | 2011-04-12 | 2011-04-12 | Method for transmitting data between SAP (Systems Application) system and SQL (Structured Query Language) database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102156736A (en) |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102419841A (en) * | 2011-12-21 | 2012-04-18 | 深圳市蓝凌软件股份有限公司 | Report center based on EKP system |
| CN102938105A (en) * | 2012-11-17 | 2013-02-20 | 武钢集团昆明钢铁股份有限公司 | System and method for automatically reporting quality judgment result between steel quality and system application products in data processing (sap) system |
| CN103744991A (en) * | 2014-01-21 | 2014-04-23 | 国家电网公司 | Method for XML-based data transmission between SAP systems |
| CN103870532A (en) * | 2012-12-12 | 2014-06-18 | Sap股份公司 | Advanced Business Query Language |
| US8898121B2 (en) | 2012-05-29 | 2014-11-25 | International Business Machines Corporation | Merging entries in a deduplication index |
| CN104317820A (en) * | 2014-09-28 | 2015-01-28 | 网神信息技术（北京）股份有限公司 | Statistical method and device of report |
| US9177028B2 (en) | 2012-04-30 | 2015-11-03 | International Business Machines Corporation | Deduplicating storage with enhanced frequent-block detection |
| US9659060B2 (en) | 2012-04-30 | 2017-05-23 | International Business Machines Corporation | Enhancing performance-cost ratio of a primary storage adaptive data reduction system |
| CN111858668A (en) * | 2020-06-30 | 2020-10-30 | 浙江物产信息技术有限公司 | Data extraction method and device for SAP HANA |
Citations (2)
| 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 |
-
2011
- 2011-04-12 CN CN 201110090696 patent/CN102156736A/en active Pending
Patent Citations (2)
| 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 |
Non-Patent Citations (1)
| Title |
|---|
| 《博客园》 20080718 西煞魄工人 《使用SSIS整合SAP数据》 全文 1-12 , * |
Cited By (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102419841B (en) * | 2011-12-21 | 2016-04-27 | 深圳市蓝凌软件股份有限公司 | A kind of form center based on EKP system |
| CN102419841A (en) * | 2011-12-21 | 2012-04-18 | 深圳市蓝凌软件股份有限公司 | Report center based on EKP system |
| US9177028B2 (en) | 2012-04-30 | 2015-11-03 | International Business Machines Corporation | Deduplicating storage with enhanced frequent-block detection |
| US9767140B2 (en) | 2012-04-30 | 2017-09-19 | International Business Machines Corporation | Deduplicating storage with enhanced frequent-block detection |
| US9659060B2 (en) | 2012-04-30 | 2017-05-23 | International Business Machines Corporation | Enhancing performance-cost ratio of a primary storage adaptive data reduction system |
| US8898121B2 (en) | 2012-05-29 | 2014-11-25 | International Business Machines Corporation | Merging entries in a deduplication index |
| US9305005B2 (en) | 2012-05-29 | 2016-04-05 | Interational Business Machines Corporation | Merging entries in a deduplication index |
| CN102938105A (en) * | 2012-11-17 | 2013-02-20 | 武钢集团昆明钢铁股份有限公司 | System and method for automatically reporting quality judgment result between steel quality and system application products in data processing (sap) system |
| CN103870532A (en) * | 2012-12-12 | 2014-06-18 | Sap股份公司 | Advanced Business Query Language |
| CN103870532B (en) * | 2012-12-12 | 2019-04-05 | Sap欧洲公司 | Higher level service query language |
| CN103744991A (en) * | 2014-01-21 | 2014-04-23 | 国家电网公司 | Method for XML-based data transmission between SAP systems |
| CN103744991B (en) * | 2014-01-21 | 2017-07-07 | 国家电网公司 | A kind of method of data transfer between SAP system based on XML |
| CN104317820A (en) * | 2014-09-28 | 2015-01-28 | 网神信息技术（北京）股份有限公司 | Statistical method and device of report |
| CN104317820B (en) * | 2014-09-28 | 2021-03-16 | 网神信息技术（北京）股份有限公司 | Statistical method and device for report forms |
| CN111858668A (en) * | 2020-06-30 | 2020-10-30 | 浙江物产信息技术有限公司 | Data extraction method and device for SAP HANA |
| CN111858668B (en) * | 2020-06-30 | 2021-05-18 | 物产中大数字科技有限公司 | Data extraction method and device for SAP HANA |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102156736A (en) | Method for transmitting data between SAP (Systems Application) system and SQL (Structured Query Language) database | |
| US8307109B2 (en) | Methods and systems for real time integration services | |
| US8554805B2 (en) | Methods and systems for importing source data | |
| US8429527B1 (en) | Complex data merging, such as in a workflow application | |
| CN105426394B (en) | Based on cross-platform mobile report form generation method and system | |
| CN100375047C (en) | Management method for computer log | |
| US7774434B2 (en) | Support program for web application server and server | |
| US9342573B2 (en) | Universal delta data load | |
| US20080162622A1 (en) | Systems and methods to implement extensibility of tenant content in a provider-tenant environment | |
| US20080162536A1 (en) | Systems and methods for extending shared data structures with tenant content in a provider-tenant environment | |
| CN111460019A (en) | Data conversion method and middleware of heterogeneous data source | |
| CN109241384A (en) | Scientific research information visualization method and device | |
| US20150326664A1 (en) | System and method for managing data transactions between applications | |
| US20150127409A1 (en) | Project data management server and project data management program | |
| US9330140B1 (en) | Transient virtual single tenant queries in a multi-tenant shared database system | |
| He et al. | ISA-95 tool for enterprise modeling | |
| CN105159997B (en) | Report processing method and report processing system | |
| CN104081381B (en) | Method and apparatus for implementing concept service | |
| CN112214236B (en) | Method for building management system of application architecture of software rapid development platform | |
| US20070282722A1 (en) | Retrieving data to automatically populate a timesheet dataset | |
| CN103569421A (en) | Data collection and analysis device for cigarette packing machine | |
| CN101458628A (en) | Program edition management method | |
| KR100974621B1 (en) | ＲＦＩＤ Business Awareness Framework | |
| CN202765320U (en) | Data collecting and analyzing device used for cigarette packing machine | |
| CN105808742A (en) | Image pool system and method for using the image pool |
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: 20110817 |