Qlik Community

Technology Partners Ecosystem Documents

Documents & videos related to the Qlik Technology Partners Ecosystem

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS

NetSuite Partnership - Data access and connector options

cancel
Showing results for 
Search instead for 
Did you mean: 
MarcusAdams
Employee
Employee

NetSuite Partnership - Data access and connector options

Introduction

NetSuite (now part of Oracle) is the world's largest Cloud ERP software provider. Its integrated cloud business software suite includes business accounting, ERP, CRM and eCommerce software for the SMB market. 

Data Connectivity options

There are several options for Qlik to work on NetSuite. These are your options (basic to most comprehensive in order)...

Option 1 - Direct Connectivity

There are no show-stoppers in connecting Qlik directly to NetSuite however, NetSuite does not provide metadata and does not publish any material that documents the entity relationship in its data structures. Therefore, while you can easily connect to NetSuite via traditional connectivity methods, the data is essentially a black box.

You can leverage ODBC/JDBC via SuiteAnalytics Connect (NetSuite charges a small fee for the driver), REST API, SOAP API or SuiteScript.

Option 2 - 3rd Party Connectors (Informatica)

As mentioned, there are 3rd party connectors in the market that do offer some level of visibility and map out about 10-20% of the primary keys in NetSuite data. Qlik has tested and successfully built sample Qlik visualisations using Informatica's NetSuite Connector with the Informatica Cloud. This option is best for those customers who may already be Informatica customers.

Option 3 - SuiteSolutions: QVX File Generation

NetSuite, with support and technical validation by Qlik, has developed and released an add-on bundle to their platform called QVX File Generation. This new SuiteSolution provides users with the ability to export the results of a Saved Search directly into a QVX-formatted file – a proprietary Qlik file format that is optimized for use with both QlikView and Qlik Sense. The feature can be provisioned to a customer’s NetSuite environment in minutes for a 1-time cost of $700 USD.  Users now have a quick and easy way to leverage the full analytical and associative experience of Qlik against their NetSuite data.

Option 4 - Tactical Connect for Qlik®

Qlik has partnered with NetSuite Implementation Partner, Tactical Cloud LLC, to validate and co-market Tactical Connect for Qlik® - a connector for Qlik on NetSuite that has been certified by NetSuite as a SuiteApp and is now posted on suiteapp.com! Tactical Connect for Qlik® can also be provisioned to a customer’s NetSuite environment in minutes and offers the following benefits:

  • Business users can easily access and sync all NetSuite data (via a single or multiple Saved Searches) into Qlik through a live, REST API-based connection.
  • Business users can join as many NetSuite tables/objects with each other and 3rd party data sources in one Qlik app.
  • Publish/embed Qlik visualizations back inside NetSuite portlets with full associative experience.
  • Price: $5K per year subscription.

Tags (3)
Labels (1)
Comments
adamau
Contributor
Contributor

In Option 1 you said, there is an option to connect to NetSuite via Rest API.
Can you provide more details?
I was trying, however Qlik still doesn't support OAuth 2.0 which is required to connect to NetSuite Rest Web Services.

Can you provide some alternatives how to connect Qlik Business SaaS with NetSuite?

tayshaprovost
Contributor II
Contributor II

Hi Markus!
Thanks a lot for your article, it's very informative.
The only point I want to add is about an alternative 3rd party connector - Skyvia. I found it more convenient and cheaper. Skyvia allows you to connect Qlik Sense to NetSuite through a DB or a cloud DWH: https://skyvia.com/data-integration/analyze-netsuite-with-qliksense

0 Likes
eric_cabeza
Partner - Contributor
Partner - Contributor

Hi @MarcusAdams 

From which versions of QlikView and Qlik Sense do those options works?

 

Thanks!

0 Likes
Version history
Last update:
‎2019-03-05 10:42 AM
Updated by: