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

Two database interaction

Hello Experts,

I need a help regarding the below requirement.

Suppose i have a database like ABCD and there are fours tables belongs to it like sales,emp, region, quarters.

My requirement is that once a new record is being added in the EMP table (with the employee name and employee code )of ABCD database, HR master should be added in the SAP Business One.

How can i achieve this. Please let me know the coding how to get this.

Thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Nov 12, 2012 at 07:24 AM

    Hi Ramu,

    A few possible solution :

    1. If you have control of the Application that is adding the records to you ABCD database, you can add some code in this app to create the records in SBO.
    2. Make use of database level trigger to execute a program to create the record in SBO.
    3. Create a windows service that runs a checking every specific interval on Database ABCD and sync to SBO as necessary.

    You have two options of Creating records in SBO :

    1. Through DI API.
    2. Through DI Server /B1WS.

    Regards

    Edy

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 12, 2012 at 12:11 PM

    Hi,

    As said by Edy, it depends mainly on if you can (will) modify the application adding records to the ABCD database or not.

    Since I'm finishing a big project a bit similar, I'm biaised in my judgement 🤣

    Basically, what I'll do would be to:

    • Log in the ABCD database what to transfer to SBO (database trigger at best, table trigger at least),
    • Thru a planed-task in the SQL-Server call a web-service with the needed informations,
    • In the web-service, thru B1WS, add the record in SBO.

    Seams tricky, but not so much and from all possible advantages a really important one: the only coupling point between both product is the web-service, so you won't be "stucked" with either application.

    Regards,

    Eric

    Add a comment
    10|10000 characters needed characters exceeded

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.