I have SAP applications using Oracle. There is a need to migrate from Oracle to Open source DB (say PostgreSQL). Is there any way I can do the assessment of the complexity of the migration (feasibility analysis, i.e how much SAP applications are tied up with Oracle DB etc.?)
2
-
Are you sure SAP supports Postgres?user330315– user3303152016-04-28 09:53:14 +00:00Commented Apr 28, 2016 at 9:53
-
There are a number of applications in addition to SAP applications. I need to do a feasibility study. I am not sure if SAP supports PostgreSQL ? Please guide.sarfaraz– sarfaraz2016-05-06 09:29:23 +00:00Commented May 6, 2016 at 9:29
Add a comment
|
1 Answer
On the one hand:
The SAP server has a special abstraction layer called Database Interface which converts Open SQL Statements into Database specific Native SQL. Therefore, SAP software is Database Independent
Оn the other hand:
Look at Database and OS Platforms SAP Wiki topic
- DB2
- Sybase ASE
- Oracle
- Microsoft SQL Server
MaxDB
of course SAP HANA
Accordingly SAP on PostgreSQL is the terra incognita
