cancel
Showing results for 
Search instead for 
Did you mean: 

Data Integration between SBO and legacy application

Former Member
0 Kudos

Hi All,

I'm new to SBO and this community, we are going implement SBO in our client place, which inclusive of integrating with their legacy applications(which they don't want to discard),

suggest me what are best way of doing data integration between these applications, it should be bi-directional data flow(SBO to legacy apps & vice versa)

1. should it be possible to use triggers & procedures directly at SQL Server database?

2. is it advised to touch SBO database tables, will it affect or crop any problems?

3. is UI API the only way of doing data interface?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Why don't you check the One-Stop Shop for SBO SDK Help files that can be accessed at:

https://www.sdn.sap.com/sdn/developerareas/businessone.sdn?node=linkDnode10

There is a tool called Data Transfer Workbench for batch uploads.

Also, it might be possible to use MS SQL Server DTS for a bit faster updates.

Last but not least, there is a course TB1300 on SDK, attending that or reviewing the class materials may be useful.

HTH

Juha

Answers (1)

Answers (1)

Former Member
0 Kudos

you can make a bi-directional system.. we are with our product now.

1. you are not allowed to touch the SBO database, DI-API objects only.

2. again do not go directly to the database, yes it will cause problems, most definately with the inserts and updates, you will break the SBO internal keys and rules.

3. no you could do a web or windows app using the DI-API

Former Member
0 Kudos

Thanks Juha Lassila & Shawn Lee, We would like to attend TB1300 SAP Business One - Software Development Kit course but its not available with in next 1 month, If you or anybody has training material for this course, plz. send it across, which will helpful to go through try ourselves.

for our scenario we may not be able use data transfer workbench since its not one time data porting, instead its going to be regular or seemless integration with sbo & legacy apps, so suggest what method would be desirable.

Message was edited by: Srinivasan Varadan