Since writing the NetSuite Delivers on ODBC article back three years ago in 2009, NetSuite has delivered an easier to use driver for connecting up the their platform with third party reporting tools.  That’s good news for the average business user who is working to minimize IT help promised by being on the platform.

One key element we are working on is connecting to multiple NetSuite accounts at the same time.  This is usually a rare requirement because generally you are using NetSuite with one account at a time for your business data.  But NetSuite Systems Integrators, like my firm, Prolecto Resources, hold support accounts to many NetSuite clients at the same time.  When we  support our clients on ODBC matters, we need to be able to connect to their instance without issue.

We are currently working on a solution to this challenge.  The basic approach NetSuite prescribes is to fully qualify the table (view, really) as follows [account role].[table object].  Seems easy enough but we keep getting results back from the very first account that had ODBC active for our login.   It looks as though there is no answer in the private usergroup.  I am confident we will work through it and we will update this post once ready.

Update 5/9/2012

After working with NetSuite Support  and providing them WebEx screenshots and sample software, (MS Access with VB Code) it looks like there is no way to do this.  I basically demonstrated that the system remembers the first account that has ODBC enabled and your email address associated with it.  Their suggestion is to use separate email addresses and roles for each account.  That was not what I wanted to hear but I am not surprised.

Upon deeper reflection, given the typical use case, this workaround will probably be effective for most users.

If  you are interested in the visual basic code we used to connect up with ODBC to NetSuite, let me know.

Marty Zigman

Holding all three official certifications, Marty is regarded as the top NetSuite expert and leads a team of senior professionals at Prolecto Resources, Inc. He is a former Deloitte & Touche CPA and has held CTO roles. For over 30 years, Marty has produced leadership in ERP, CRM and eCommerce business systems. Contact Marty to set up a conversation.

More Posts - Website - Twitter - Facebook - LinkedIn - YouTube