Method:API Q&A

Re: Programmatic SQL access

Jason_L — Tue, 26 Jun 2012 21:19:01 GMT

Hi Dave,

I think I can see a way forward from here. Thanks a lot.

Jason

Re: Programmatic SQL access

Method_David — Tue, 26 Jun 2012 20:45:48 GMT

Hi Jason L,

We do not grant programmatic SQL access. That would be a severe security policy violation (among other issues....).

The synchronization between your method account and quickbooks is handled via the method synchronization engine. (You can read up on that in the documentation at http://www.methodintegration.com/self-service-documentation.aspx).

MethodAPI is a webservice (located at https://www.methodintegration.com/MethodAPI/Service.asmx), which you can use to manipulate data in your method account programmatically. The synchronization engine will handle moving the data you manipulate via the API between your method account and quickbooks.

Java can invoke and use webservices as needed. I suggest you google something like "java to call a microsoft webservice.", for examples of how to do that.

Dave

Re: Programmatic SQL access

Anonymous — Tue, 26 Jun 2012 20:05:15 GMT

Jason_L:
Can you give me ideas on how I can do that?

I'm going to move this thread to the API forum and I can say I don't think what you're trying to do is possible ouside the Method API. From my knowledge there is no direct access to our database without going through the API.

Programmatic SQL access

Jason_L — Tue, 26 Jun 2012 19:54:53 GMT

As part of our business plan, we are devloping a java applet that will be run atuomatically and needs to write to our SQL database directly, without human interaction. Therefore, we need to be able to connect with the database directly. We're using Java and the JDBC standards. I've found the correct MS SQL driver for the database, but I'd like to know how I can directly access and write to SQL without going through the UI or the MethodAPI, since that is written for MicroSoft languages. I'm really trying to avoid using a Java/Quickbooks bridge, and just write directly to SQL. Can you give me ideas on how I can do that? I will need some things that can't be posted in the forum (our specific database url, what I can use for username and password, etc.). However, if you want or can give me some general answers here, that would be great.

Jason