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

Get data from two databases?

Posted on Aug 02, 2006 at 11:41 AM 7 Views

Hello all,

Do anyone know if it's posible to get data from two databases while I'm running SBO in one of them? I need this because our client wants to be able to print reports with all the information stored in both companies. I searched this forum trying to find if this is possible but I did't find any information about this.

Can someone help me?

Thanks and regards,

Mariana Mazzero

SAP Business One Extensibility
Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 02, 2006 at 11:53 AM

    Hi Mariana,

    What you can do is use two company objects to retrieve the data. As far as I know you're not restricted to one company connection.

    You can also just use a standard read only connection (like ADO/ODBC) to retrieve the data for the reports.

    Hope it helps,

    Adele

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      Aug 02, 2006 at 12:00 PM

      Hello Adele,

      Thanks for your fast answer! So, I can create two company objets and get data from each of them right? I'll try this 😊

      Thank you again!

      Mariana Mazzero