Hi

Users of the SAP ERP in a merged company are to switch to our ERP without their existing data in SAP being converted.

We still need to access the data in SAP for historical reporting, but the expensive SAP contract needs to be terminated once users have converted to our ERP. Thus the wf SAP adapter is not an option.

Does anyone know which of these options would be better?

"DATA IN SITU OPTION".

We can leave the data in situ and use our oracle or odbc adapters to report against the source. There might be an additional level of complexity because as I understand the WF SAP adapter works directly against the SAP API which produces a much simplified view of the underlying data, but reporting would still be achievable.

"DATA EXTRACT BEFORE SAP SHUTDOWN OPTION".

Before we lose the SAP licence we need to export the data using the SAP import/export facility to an intermediate store (eg SQL server tables, flat files) where we may later report on it with our adapters.

If anyone has experience of similar their answer, as always, would be most appreciated.

This message has been edited. Last edited by: hammo1j,

John,

As you undoubtedly know, SAP has an abundance of tables.
So I think it is hardly doable to produce a download of *all* tables into an sql server instance.
Yet I do think it is the best way to go.
Of course you can limit the download to those tables that you really need.

Just my 2cts.

There is very little difference between the two options when going against SAP transparent tables
as these are standard SQL tables.
The issue arises when you need to access things such as cluster tables, views and
logical databases etc.
These things often require internal SAP abap routines for access and so cannot be read
using a standard relational adapter.
For that reason even though it’s going to be a pain doing the analysis of what you actually want to keep
go for the "DATA EXTRACT BEFORE SAP SHUTDOWN OPTION".

Thanks JG and GamP for your suggestions.

I have notified our PMs we need to use SAP routines to dump the tables we need for historic info before the SAP licence finishes.

Regards

John