General Question

jsk2370's avatar

How do I bulk load product data from SAP to an ecommerce system?

Asked by jsk2370 (3points) December 21st, 2007
Observing members: 0 Composing members: 0

3 Answers

drive_by_dev's avatar

Your question is a bit vague. What kind of ecommerce solution are you talking about? What fields from the product data tables do you want? Does it need to interact with the SAP when a sale is made (like to deduct the item from inventory or get an account #)? Most likely you want a database to database transfer, so the back-end database types need to be known.

jsk2370's avatar

Ok, let me elaborate;

ATG is used as content management/ecommerce platform
Fields needed are most likely product description and image
Here’s the thing; these fields may not exist in SAP

So par the equation is really first seeing if there are syndicated product content services out there and then determining whether SAP or ATG should be the “master” source of this information. Any advice on this is much appreciated

gsiener's avatar

SAP has extensive documentation and libraries related to integration. Bulk loading is basically a three step process known as ETL (extract, transform, load). You extract the files from SAP via a data connector, transform it to break fields or merge them, as the new format requires, and then load it in to your new system. Check out the SAP developer forums, they’re pretty helpful. (Just avoid the loud mouthed know it alls).

Answer this question

Login

or

Join

to answer.

This question is in the General Section. Responses must be helpful and on-topic.

Your answer will be saved while you login or join.

Have a question? Ask Fluther!

What do you know more about?
or
Knowledge Networking @ Fluther