Oracle NetSuite

37.1 Introduction

Oracle NetSuite is the world’s leading provider of cloud-based business management software. Oracle NetSuite helps companies manage core business processes with a single, fully integrated system covering ERP/financials, CRM, ecommerce, inventory and more.

Oracle Data Integrator (ODI) seamlessly integrates with Oracle NetSuite. Oracle Data Integrator features are designed to work best with Oracle NetSuite, including reverse-engineering and mappings.

37.1.1 Concepts

The Oracle NetSuite technology concepts map the Oracle Data Integrator concepts as follows: An Oracle NetSuite Instance corresponds to a data server in Oracle Data Integrator. Within this instance, a schema maps to an Oracle Data Integrator physical schema.

37.1.2 Knowledge Modules

Oracle Data Integrator provides the Knowledge Modules (KM) listed in the following table for handling Oracle NetSuite data. It is also possible to use the generic SQL KMs with Oracle NetSuite. See Generic SQL for more information.

Table 37-1 Oracle NetSuite Knowledge Modules

Knowledge Module	Description
LKM NetSuite to Oracle	Loads data from Oracle NetSuite to an Oracle staging area.
RKM Oracle NetSuite	Reverse-engineers tables, views, columns, saved searches and creates data models to use as sources in Oracle Data Integrator mappings.

37.2 Installation and Configuration

Make sure you have read the information in this section before you start working with the Oracle NetSuite technology:

37.2.1 System Requirements and Certifications

Before performing any installation, you should read the system requirements and certification documentation to ensure that your environment meets the minimum installation requirements for the products you are installing.

The list of supported platforms and versions is available on Oracle Technical Network (OTN):

http://www.oracle.com/technetwork/middleware/data-integrator/documentation/index.html

37.2.2 Technology Specific Requirements

There are no technology-specific requirements for using Oracle NetSuite in Oracle Data Integrator.

37.2.3 Connectivity Requirements

This section lists the requirements for connecting to the Oracle NetSuite database.

Oracle Data Integrator uses the Oracle NetSuite JDBC Driver to connect to the Oracle NetSuite database.

Installing Oracle NetSuite JDBC driver

To install the Oracle NetSuite JDBC driver, perform the following steps:

Download the JDBC driver installer from NetSuite and install it.
Copy the NQjc.jar file into the userlib directory. For more information on adding third-party libraries to ODI studio, refer Adding Libraries to ODI studio section of Installing and Configuring Oracle Data Integrator.

Gathering parameters from NetSuite Webpage

In order to define the JDBC connection, you need to retrieve certain parameters from Netsuite. The information required to populate the NetSuite JDBC connection string is available on the NetSuite webpage - Home/Dashboard/Set Up SuiteAnalytics Connect. On this page, you can view the following information for the user that you logged in with:

Service Host
Service Port
Service Datasource
Account ID
Role ID

37.3 Setting up the Topology

Setting up the topology consists of:

37.3.1 Creating an Oracle NetSuite Data Server

Create a data server for the Oracle NetSuite technology using the standard procedure, as described in Creating a Data Server of Administering Oracle Data Integrator. This section details only the fields required or specific for defining an Oracle NetSuite data server:

In the Definition tab, enter the following fields:
1. Name : Name of the data server that will appear in Oracle Data Integrator.
2. User: User name for connecting to the data server.
3. Password: Password for connecting to the data server.
4. Account ID: Account ID for connecting to the data server.
5. Role ID: Role ID for connecting to the data server.
For Saved Search access, Application ID and Version are also required. The steps for generating the application ID and finding the release version are explained below:

Generating the NetSuite Application ID

To generate a NetSuite Application ID for ODI, perform the following steps:
1. Log in to NetSuite as an administrator.
2. Navigate to Setup > Integration > Manage Integrations. Select New.
3. Fill in a name and ensure that Token-based authentication and user credentials are checked. Uncheck any other selections if not needed. After saving the configuration, the Application ID will be displayed on the Integrations panel.
Finding Your NetSuite Release Version

To find the version of NetSuite that your company uses, perform the following steps:
1. Log in to NetSuite.
2. On the Home page, scroll down to the bottom of the page.
3. Find the NetSuite version number in the page footer. The version number appears as follows: NetSuite (Edition: United States) Release 2020.1 Copyright © NetSuite Inc. 1999-2020. So the version would be 2020_1.
In the JDBC tab, enter the following values:
1. JDBC Driver: com.netsuite.jdbc.openaccess.OpenAccessDriver
2. JDBC URL: NetSuite {Server Host}:{Server Port};ServerDataSource={Server Data Source};
The mandatory URL parameters are listed below:
- Server Host: The TCP/IP address of the SuiteAnalytics Connect server, specified as a host name.
- Server Port: The TCP/IP port on which the SuiteAnalytics Connect server is listening. Valid parameter value is 1708.
- Server Data Source: The name of the SuiteAnalytics Connect server data source to be used for the connection. Valid parameter values include NetSuite.com and NetSuite2.com.
Click Test Connection, to test the established connection.

37.3.2 Creating an Oracle NetSuite Physical Schema

Create a physical schema for the Oracle NetSuite data server using the standard procedure, as described in Creating a Physical Schema in Administering Oracle Data Integrator.

Create a logical schema for this physical schema using the standard procedure, as described in Creating a Logical Schema in Administering Oracle Data Integrator, and associate it in a given context.

37.4 Creating and Reverse-Engineering an Oracle NetSuite Model

This section contains the following topics:

37.4.1 Creating an Oracle NetSuite Model

Create an Oracle NetSuite model using the standard procedure, as described in Creating a Model of Developing Integration Projects with Oracle Data Integrator.

37.4.2 Reverse-engineer an Oracle NetSuite Model

Oracle NetSuite supports only Customized reverse-engineering - which uses a RKM to retrieve the metadata.

To perform a Customized reverse-engineering on an Oracle NetSuite model, use the usual procedure, as described in Reverse-engineering a Model of Developing Integration Projects with Oracle Data Integrator.

Oracle Data Integrator provides the 'RKM Oracle NetSuite' knowledge module for reverse-engineering purposes. If you want to reverse engineer only the tables, you need to select 'Tables' in the 'Types' section. If you want to reverse engineer a Saved Search, you need to select 'Saved Search' and then the 'Type' of the saved search must be selected.

37.5 Designing a Mapping

You can use Oracle NetSuite as a source of a mapping. The KM choice for a mapping determines the abilities and performance of this mapping.

If only JDBC sources are used (that is, no saved searches), you can use the generic JDBC KMs. However, if any of the sources is a saved search, you need to use the 'LKM NetSuite to Oracle' knowledge module.