Connection to MYOB

HCL Domino Domino Forum
1

Has anybody managed to pull data from MYOB into a Notes document via ODBC or some other method?

I’m looking to retrieve customer account information from MYOB and display it in a customer document in Notes. I know MYOB has an ODBC driver available but can this be used to set-up a data connection in a Notes database?

2

Subject: Connection to MYOB

Jason,

If MYOB has an ODBC driver, then I imagine that means it can accept requests in SQL language, and therefore Notes to MYOB should work just like any other Notes to ODBC connection.

We use Lotus Connectors LotusScript Extensions (LC LSX) to access data from external MS SQL Servers via ODBC. It works great.

Ken

3

Subject: RE: Connection to MYOB

…actually just some more details incase anyone can supply me with a some more information, I’m having trouble wading through the LDD for the specific info I need.

  • We are running Notes/Domino 6.0.2CF1 on RedHat Linux.

  • The accountants are using MYOB Premier, the MYOB database sits on a shared network drive on another RH Linux server.

  • I want to be able to pull fields from the MYOB database into a Notes form.

Is this possible? I have a feeling that having everything sitting on Linux servers throws a spanner in the works?

4

Subject: RE: Connection to MYOB

Jason,The spanner is not the fact that your servers arew on Linux, but rather taht anyone who needs to get data from MYOB will need to have an ODBC connection defined.

There are ways around that as well, but if you want to go to that trouble, you will find the data source of MYOB a bit limiting anyway.

I have done this in the past, but my experience is that the effort is not worth it.

Regards

Rolf Pfotenhauer

5

Subject: RE: Connection to MYOB

Rolf,

Thanks for the input.

I’m not quite sure how this is all supposed to work but this is what I have in my head:

  • we have 2 RH Linux servers, (Server1)is the network file server with Samba for windows networking. (Server2) is our Notes/Domino server.

  • All network client PC’s are Win2000Pro

  • the MYOB data file sits on Server1 and the client PC’s have MYOB Premier installed and access the single MYOB data file via a common shared network drive.

  • For Notes to access the MYOB data I must set-up an MYOB DSN on Server2 which points to the data file on Server1?

  • MYOB has a ODBC driver available but its not free and as far as I can tell it only works for Windows? (I could be wrong here?)

So my problem appears to be that there is no MYOB ODBC driver for Linux? What I have found is something called “Easysoft ODBC-ODBC Bridge” (www.easysoft.com) which apparently allows ODBC applications on one machine to access ODBC data sources on another machine.

But still with this I would need to set-up a DSN on a windows machine for the MYOB data file on Server1 and then use ODBC Bridge to allow that DSN to be used by the Server2 - it sounds like a very long way around to get there!? But I could be missing something (I hope!)

6

Subject: RE: Connection to MYOB

Thanks Ken,

I’ve never used Notes to connect to an ODBC database or connected to an MYOB database via ODBC before so was hoping for some handy hints info from someone who had done it before.

I’m looking into LC LSX now.