- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Importing data from Pgsql to SAP HANA database
Import and Export using a flat file is the easiest option. You can use CSV file if it is a onetime activity. However, If you think it is a repetitive activity then I would suggest you use HANA ETL options like HANA SLT replication, Smart Data access, etc.
SAP HANA Replication allows migration of data from source systems to SAP HANA database. Simple way to move data from existing SAP system to HANA is by using various data replication techniques.
System replication can be set up on the console via command line or by using HANA studio. The primary ECC or transaction systems can stay online during this process. We have three types of data replication methods in HANA system -
- SAP LT Replication method
- ETL tool SAP Business Object Data Service (BODS) method
- Direct Extractor connection method (DXC)
https://www.tutorialspoint.com/sap_hana/data_replication_overview.htm
For more details, you can refer to our site on SAP HANA Data Replication.
- Related Articles
- Table type while importing data from flat file in SAP HANA
- Extracting data from SAP HANA database and load to ORACLE database
- Different mapping options in SAP HANA while importing data from flat file
- Getting data in front-end tools from SAP HANA database
- Importing limited number of rows from CSV in SAP HANA
- Publishing data to SAP HANA database using Information Composer
- Table mapping while data replication from flat file in SAP HANA database
- Viewing data in a table in SAP HANA database
- SAP HANA database functions in HANA Cockpit
- Understanding a database view in SAP HANA database
- Finding a database view in SAP HANA database
- Removing a service from a tenant database in SAP HANA
- Using database view in SAP HANA
- Dropping a SAP HANA database view
- Unloading tables in SAP HANA database
