How to load data into standard BO by scheduling a job no manual load in C4C

[former_member188831]

I would like to upload data into standard BO by scheduling a job.

I guess there are the templates provided by C4C but i am looking going forward if we want schedule a job to load data how to do it ?

with templates is it possible to upload daily load by schedule job ?

Thanks,

Mahesh

[Former Member · Accepted solution]

The best solution for a batch based loading of data into C4C is to use an ETL such as as SAP Data Services or equivalent which can get data from different sources/formats (extract), clean/modify the data to C4C requirements (transform), and load it into C4C APIs. All ETLs have a scheduler and good admin tools when there are data loading problems so can be used for both initial and incremental loading data in an automated way.

[former_member188831 · Accepted solution]

Thanks Rei Kasai for your reply.

But here our biggest challenge is what API we have to use to go for mass data load for incremental data in C4C.

We are very much clear to extract data from legacy we can get the data into txt file etc..

Please advise how do we use the APIs .

for example we would like to upload price list and attachments to products and accounts.

Thanks,

Mahesh

[former_member188831 · Accepted solution]

I realized that we could do this as same like how we are doing for custom BO.

If any one want to load data like creating customers (it is a standard BO) follow below steps.

1. Create a new solution in SDK

2. Right click on it and add new item

3. select service Integration - > XML File input

4. Give a name

5. Select the Business object from the list for example like customer

6. Select the required fields.

finally you get an xsd file.

use this and populate the data in xml file.

copy that xml file into webdav path as given in File input manager work center.

then schedule a job by creating active runs in File input output manger.

good luck !!

Thanks,

Mahesh Gattu