Skip to main content

Send Data to NetSuite Analytics Warehouse

This article provides information about sending data from any data source to a NetSuite Analytics Warehouse (NSAW) database destination with Nexla.

1. Begin Sending a Nexset to NSAW​

  1. Click the Send.png icon on the Nexset to be sent to the NSAW database destination. This will open the Send Nexset to Destination screen.

      Send_Nexset.png

  2. Select Oracle_Autonomous.png from the destinations list, and click Next.png in the top right corner of the screen.

  3. Select the appropriate credential, and click Next.png in the top right corner of the screen.

    To learn how to enter a new Oracle Autonomous credential for use with NSAW, see Section 2 in the Help Center article Connect to NetSuite Analytics Warehouse.

2. Select the NSAW Database Destination​

With Nexla, data contained in Nexsets can be sent to an existing table in an NSAW database, or users can create and send the data to a new table in an NSAW database. To learn how to send data to an existing table, see Section 2.1. To learn how to create and send data to a new table, see Section 2.2.

2.1 Send Data to an Existing Table​

  1. Find the NSAW database table to which Nexla should send the data. Expand databases and tables as necessary by clicking the Expand.png icon next to each.

  2. Select the table to which the data should be sent by hovering over it and clicking the Select.png button that appears to the right.

    The button should now display Selected.png, and the path of the selected location will be shown at the top of the list.

      Selected_Location.png

  3. Click Next.png in the top right corner of the screen.

  4. Proceed to Section 3.

2.2 Create and Send Data to a New Table​

  1. Find the NSAW database in which a new table should be created, and expand the database by clicking the Expand.png icon next to it.

  2. Click Create_New_Table.png below the database in which a new table should be created.

      New_Table_Location.png

  3. Click Next.png in the top right corner of the screen.

  4. Enter a name for the new table in the Table Name field.

      Table_Name.png

  5. Proceed to Section 3.

3. Select Update and Tracking Options​

  1. Select whether the records contained in the Nexset should be inserted or upserted into the database using the Update Mode pulldown menu.

      Update_Mode.png

  2. Optional: When upsert mode is selected, by default, Nexla is configured to allow table columns to be updated with Nexset records containing null values. To omit null record values from the upsert and allow records to be partially upserted, uncheck the box next to Allow_Updates_with_Nulls.png.

      Allow_Partial_Upsert.png

  3. Optional: To enter a name for the tracker that will be used to trace the lineage of the Nexset in Nexla, check the box next to Set_Tracker_Name.png, and enter the desired tracker name in the text field that appears below.

      Tracker_Name.png

4. Map the Nexset Attributes to Table Columns​

  1. Under the Column heading, when the Nexset will be sent to an existing NSAW table, Nexla will supply a column name from the selected table for each attribute contained in the Nexset. When a new NSAW table will be created, column names corresponding to the Nexset attribute names will be supplied. These names can also be edited by clicking on a Column field and entering the desired text.

      Edit_Column_Name.png

  2. Optional: To create a new column in the selected NSAW table, click Create_New_Column.png at the bottom of the table formatting list, enter a column name under the Column heading, and proceed to the subsequent steps.

      New_Column.png

  3. Optional: To delete a column, hover over the row containing that column, and click the Delete_Column_Icon.png icon that appears to the right.

      Delete_Column.png

  4. Use the pulldown menus under the Linked Draft Attribute header to map Nexset record attributes to columns in the NSAW database table.

      Linked_Draft_Attribute.png

  5. Select the data type for each attribute using the pulldown menus under the Type header.

    For flows in which the data will be sent to an existing table, Nexla will provide a data type selection for each attribute. Users can choose to continue with these selections or specify different data types.

      Data_Type.png

  6. For upsert-type data flows, select a primary key by checking the box under Primary in the row that contains the primary key attribute.

    For insert-type data flows, skip this step.

      Primary_Key.png

5. Complete and Activate the Data Flow​

  1. Once all of the above steps have been completed, click Save.png in the top right corner of the screen.

  2. The confirmation screen indicates that the selected or created NSAW database table has been successfully created as a data destination.

      Confirmation.png

  3. Optional: To edit the name of the newly created destination in this screen, click on it, and enter the desired text.

      Edit_Destination_Name.png

  4. Optional: To enter a description of the newly created destination, click on Description__Data_Source_.png, and enter the desired text.

      Edit_Description.png

    • To activate the flow of data into the NSAW database destination now, click Activate_Flow.png.

    • To activate the flow of data into the NSAW database destination later, click Done__Data_Destination_Screen_.png in the top right corner of the screen.

      1. When the flow is ready to be activated, find the flow in the Integrate screen, and click Edit.png on the destination.

          Data_Flow.png

      2. Click Activate.png on the menu that appears to activate the flow of data to the NSAW database destination.

          Activate_Destination.png