Will this be a one-time dump of data? Will it be a one-way or two-way update between Kentico and SAP? What should happen if the process fails?
You have a few options you can go with. If a one-time dump, use the Kentico Import Toolkit (KIT)
. Pretty easy and powerful tool.
If you need a simple solution with some general error handling use a custom Scheduled Task
. Scheduled tasks can be very robust and work great for data transfers and other actions on your Kentico installation.
If you need some real-time synchronization (one or two way) with robust error handling, look into using the Integration Bus
. While it is a bit more time consuming to get this implemented, it offers many options a simple scheduled task does not.
There is always the option of doing something outside of Kentico as well and using the Kentico API.