Skip to Content

How to automatically migrate all Business Partners from SAP Business One to SAP Cloud for Customer?

Hello Community,

Does anyone have any suggestions or recommendations to look massively at the business partners that exist in B1 to C4C?

I am clear that I can use the migration templates with migreation tools for accounts and individual clients. The detail of using these templates is that there is too much work to be copying and pasting, column by column, when there are more than 8,000 business partners, which are intended to migrate.

I appreciate your recommendations.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 23, 2018 at 04:02 PM

    Hi, community friends.

    I just want to inform you that a practical and useful way to migrate business partners from B1 to C4C was determined.

    We have followed the principle that the integration standard speaks of.
    If a Business Parnert is updated in B1 and it does not exist in C4C, it is created and permeated with its external ID as the Internal ID.

    In this principle we made use of the Data Transfer Workbench (DTW) tool of B1, where we updated the BP in lots of 1000 and thus they were replicating in C4C, with their respective ID's.

    Thanks to all for the help.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 16, 2018 at 07:21 AM

    Hi William,

    It depends. If you mean to migrate the data only once, you can use a simple SQL query. If you need to do it on a regular basis, the B1if data transfer tool is the way to go. It allows you to determine jobs, schedules, and all different kinds of input and output formats. There is a free SAP course about it here.



    Add comment
    10|10000 characters needed characters exceeded

    • Hi William,

      Fortunately MS SQL can write to XML very nicely.

      What you will have to do, is to write your query with aliases so the required fields will be written to the XML tags expected by C4C.

      Then you create an sql job to run this query regularly.

      See if C4C has automatic import job functionality, or otherwise load the XML files manually each time.

      Greetings from Finland,