Skip to Content
author's profile photo Former Member
Former Member

Data Integration between SBO and legacy application

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?

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 10, 2005 at 03:43 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 10, 2005 at 08:46 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.