Important Nexla Help Center Update:
Nexla's Zendesk Help Center pages are being deprecated and will soon no longer be available.
Nexla Documentation is now the home for Nexla's User Guides, with improved formatting and categories that are easier to navigate, providing a better overall user experience.
Please update any bookmarks to the new Nexla Documentation site (docs.nexla.com/user-guides).
_______________________________________________
This article provides information about sending data from any data source to a NetSuite Analytics Warehouse (NSAW) database destination with Nexla.
Contents:
1. Begin Sending a Nexset to NSAW
2. Select the NSAW Database Destination
2.1 Send Data to an Existing Table
2.2 Create and Send Data to a New Table
3. Select Update and Tracking Options
4. Map the Nexset Attributes to Table Columns
5. Complete and Activate the Data Flow
1. Begin Sending a Nexset to NSAW
- Click the icon on the Nexset to be sent to the NSAW database destination. This will open the Send Nexset to Destination screen.
- Select from the destinations list, and click in the top right corner of the screen.
- Select the appropriate credential, and click 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
- Find the NSAW database table to which Nexla should send the data. Expand databases and tables as necessary by clicking the icon next to each.
- Select the table to which the data should be sent by hovering over it and clicking the button that appears to the right.
The button should now display , and the path of the selected location will be shown at the top of the list.
- Click in the top right corner of the screen.
- Proceed to Section 3.
2.2 Create and Send Data to a New Table
- Find the NSAW database in which a new table should be created, and expand the database by clicking the icon next to it.
- Click below the database in which a new table should be created.
- Click in the top right corner of the screen.
- Enter a name for the new table in the Table Name field.
- Proceed to Section 3.
3. Select Update and Tracking Options
- Select whether the records contained in the Nexset should be inserted or upserted into the database using the Update Mode pulldown menu.
- 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 .
- 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 , and enter the desired tracker name in the text field that appears below.
4. Map the Nexset Attributes to Table Columns
- 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.
- Optional: To create a new column in the selected NSAW table, click at the bottom of the table formatting list, enter a column name under the Column heading, and proceed to the subsequent steps.
- Optional: To delete a column, hover over the row containing that column, and click the icon that appears to the right.
- Use the pulldown menus under the Linked Draft Attribute header to map Nexset record attributes to columns in the NSAW database table.
- 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.
- 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.
5. Complete and Activate the Data Flow
- Once all of the above steps have been completed, click in the top right corner of the screen.
- The confirmation screen indicates that the selected or created NSAW database table has been successfully created as a data destination.
- Optional: To edit the name of the newly created destination in this screen, click on it, and enter the desired text.
- Optional: To enter a description of the newly created destination, click on , and enter the desired text.
-
- To activate the flow of data into the NSAW database destination now, click .
- To activate the flow of data into the NSAW database destination later, click in the top right corner of the screen.
- When the flow is ready to be activated, find the flow in the My Data Flows screen, and click on the destination.
- Click on the menu that appears to activate the flow of data to the NSAW database destination.
- When the flow is ready to be activated, find the flow in the My Data Flows screen, and click on the destination.
- To activate the flow of data into the NSAW database destination now, click .
Comments
0 comments
Please sign in to leave a comment.