Data extraction method and device for SAP HANA
The invention discloses a data extraction method and device for SAP HANA. The method includes configuring source database information, target SAP database information and table information of data needing to be extracted in a configuration file of the SAP HANA; according to source database informati...
Gespeichert in:
| Hauptverfasser: | , , |
|---|---|
| Format: | Patent |
| Sprache: | chi ; eng |
| Schlagworte: | |
| Online-Zugang: | Volltext bestellen |
| Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
| Zusammenfassung: | The invention discloses a data extraction method and device for SAP HANA. The method includes configuring source database information, target SAP database information and table information of data needing to be extracted in a configuration file of the SAP HANA; according to source database information configured by the configuration file, obtaining table structure information of the table of whichthe data needs to be extracted in a source database, and splicing the table structure information into a table building statement executed in a target SAP database; connecting a target SAP database according to target SAP database information configured by the configuration file, and executing the table building statement to create an empty target SAP table in the target SAP database; reading andstoring data to be extracted from a source database according to source database information configured by the configuration file; and writing the stored data into the target SAP table created by thetarget database according |
|---|