cancel
Showing results for 
Search instead for 
Did you mean: 

Replicate SAP table into external database

Former Member
0 Kudos

Hello experts,

we are running a SAP ECC on SAP DB. We have a custom table called ZCUSTTABLE. Now we wan´t the system to replicate this table automaticaly to an external database (Oracle). Is it possible?

Accepted Solutions (0)

Answers (1)

Answers (1)

thomas_vogt
Advisor
Advisor
0 Kudos

Moved thread to SAPDB forum.

thorsten_zielke
Contributor
0 Kudos

Hello Benjamin,

it might be possible, but I know only the MaxDB side here...

Within MaxDB you can use the 'loadercli' tool to export tables to various file formats. Since you are going to import this into a non-MaxDB database, you will likely have to use 'csv' style for your data.

You could write a batch job for this on OS level to have the export done automatically.

I cannot comment on Oracle, but I would guess there are tools that can import 'csv' data.

Then it depends if the table field definitions are compatible from MaxDB to Oracle.

Hope this helps,

Thorsten