NetSuite SQL Query Tool

This article is relevant if you are seeking to write SQL queries against the NetSuite database.

Background

With the advent of the long-awaited and much welcomed, NetSuite SuiteQL (SQL) query language, we can finally write queries in the NetSuite Platform that are actionable.

For SuiteScript developers, the ability to call the N/query SuiteScript 2.x library is an exciting capacity.  For administrators with SQL skills, we finally can feel at home making queries in the database.

Introducing Prolecto SuiteQL Query Tool

Working with NetSuite software libraries, you have no easy-to-use interface to craft your SQL commands. Thus, Boban D., Senior Technical Analyst, developed a utility that allows you to craft and execute NetSuite SQL commands to see your results.  Note, we must be in gratitude to Tim Dietrich who inspired Boban to produce our version of the tool.

Boban D. continues to enhance the stand-alone tool as we are using it to help drive a new version of our Content Renderer Engine (article coming soon) designed to extend the reach and output of data in the platform.  Note, the Content Renderer Engine is a way to build and consume a NetSuite data universe.

Currently, the SQL tool supports these capacities:

  1. Top Queries: NetSuite does not support native Top queries yet in the language. But through a nested SQL syntax, our tool produces the same impact.
  2. Run Paged: take your queries and run them in a paged manner. As of this writing, some queries must run paged to perform correctly.
  3. Pivot Feature: we created a way to take the data and pivot it (future article on this) from the tool. Nice!
  4. Save Queries: a mechanism is offered to save and recall your queries.
  5. Load Workbooks: load your previously saved SuiteAnalytics Workbooks.
  6. CSV Download: save your data in CSV format.
  7. JSON Format: get your data in JSON format.

Click the related image to see an early version of the tool.

NetSuite Data Inquiry for Administrators and Developers

The tool allows administrators to craft queries that can be very handy to answers questions that can otherwise be slow to craft via Saved Search.  Are you like me and you tire of the work it takes to exercise the saved search field dropdown selector?

For SuiteScript developers, you can craft your queries, or take apart and discover the SQL behind SuiteAnalytics Workbooks and Datasets.  This capacity can help you learn NetSuite’s proprietary “BuiltIn” function syntax and sharpen your SQL skills.

Get the Prolecto SuiteQL Query Tool

Like all the algorithms and software patterns we create in our firm, the Prolecto SuiteQL Query Tool is available to our clients without a license charge. We simply need to ensure we have the right care relationship in place to ensure our clients succeed in their NetSuite-related endeavors.

If you found this article meaningful, feel free to sign up for notifications to new articles as I post them. If you would like to expand your capacity to work with the NetSuite platform, and you assess the SuiteQL Query Tool will help, make a request and let’s have a conversation.

Be Sociable, Share!

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

| Category: Infrastructure, NetSuite, Reporting, Technical | 2 Comments

2 thoughts on “NetSuite SQL Query Tool

  1. Jason S says:

    One thing that SS can do is be consumed by SuiteLets & Workflows. Can queries written here be consumed in that way? Thank you for your great work.

    –sjo

  2. Marty Zigman says:

    Hello Jason,

    Yes, you can write SQL queries and your SS2.0 scripts can utilize them. Workflows can get access to them via Workflow Action scripts.

    Marty

Leave a Reply

Your email address will not be published. Required fields are marked *