Setting Up the Data Transfer

To start transferring data to the Analytics Warehouse, you need to go to the data transfer setup page and select the functional areas to include. Your NetSuite data is grouped into predefined functional areas. To learn about the record types and fields available in the NetSuite2.com data source, see Record Types and Fields.

For more information about the functional areas, see Supported Functional Areas.

To set up the data transfer:

  1. Go to Setup > Integration > Configuration.

    Note:

    The configuration page might take some time to load. If you get an error message, ensure the NetSuite Data Warehouse integration record is enabled. For more information, see Enabling NetSuite Analytics Warehouse.

  2. Click NSAW Data Transfer Setup to go to the data transfer setup page.

  3. In the Initial Extract Date field, select the date from when you want your data transferred.

  4. In the Subsidiary field, select the subsidiary for which you want to transfer the data.

  5. Select the functional areas to include in the transfer.

Data from the selected functional areas is refreshed automatically every 24 hours. The Last Transfer column shows the date and time of the first automatic data transfer, or the last manual data transfer. You can see the time remaining before the next automatic data transfer above the functional area list.

The first data transfer may take some time. The subsequent data transfers happen incrementally every day.

You don't have to wait until the scheduled data transfer. If you want the latest data, click Transfer Data in the Transfer Data column to manually start a transfer for a specific functional area. You can see the last transfer date for each functional area in the Status column.

Viewing the Data Transfer Audit Log

You can use the NetSuite Analytics Warehouse Customization History page as a data transfer audit log to check and track all the data transfer operations and their statuses. It shows the operation name, status, and a time stamp for when each operation occurred.

Note:

You must be assigned the NSAW Administrator role to view the Data Transfer Audit Log page.

To view the data transfer audit log:

  1. Go to Setup > Integration > Configuration.

    Note:

    The configuration page might take some time to load. If you get an error message, ensure the NetSuite Data Warehouse integration record is enabled. For more information, see Enabling NetSuite Analytics Warehouse.

  2. Click NSAW Data Transfer Setup to go to the data transfer setup page.

  3. Click the Request History button.

Related Topics

General Notices