Skip to main content
Solved

Load data in ERP Systems

  • October 23, 2024
  • 2 replies
  • 41 views

Forum|alt.badge.img+1

How to load result data from Ataccama ONE MDM to ERP systems like SAP?

Best answer by oliver

Hi @FionaF,

For this purpose we usually use batch Export operation. There are 2 types of the export operation:

  • FULL - exports all data from MDM repository
  • DELTA - exports only changed data since last execution of the export

You can also specify the list of the entities and columns which will be exported.

Result is usually written to DB table you need to specify and then it can be loaded from that table to SAP or any other system.

You can find example of such export operations in our CDI example - see on the picture below:

 

Oliver

View original
Did this topic help you find an answer to your question?

Forum|alt.badge.img+3
  • Ataccamer
  • October 23, 2024

Hi @FionaF,

For this purpose we usually use batch Export operation. There are 2 types of the export operation:

  • FULL - exports all data from MDM repository
  • DELTA - exports only changed data since last execution of the export

You can also specify the list of the entities and columns which will be exported.

Result is usually written to DB table you need to specify and then it can be loaded from that table to SAP or any other system.

You can find example of such export operations in our CDI example - see on the picture below:

 

Oliver


Ales
Ataccamer
Forum|alt.badge.img+2
  • Ataccamer
  • October 23, 2024

@FionaF I would just add that the specific connection to ERP typically depends on the target system. In case of SAP, Ataccama can connect through SAP RFC however just to read or execute on the RFC server.

There is no way how to write directly to SAP unless you use some standard SAP API or batch format to ingest the data in.

The export table @oliver mentioned above can be the source for SAP to ingest the data as well.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings