Create a Data Augmentation Scripts Application

Create a Data Augmentation Scripts (DAS) application to use your custom logic to bring data from the source to your application data files.

  1. Sign in to your service.
  2. In Oracle NetSuite Analytics Warehouse, Console, click Data Configuration under Application Administration.
  3. On the Data Configuration page, under Configurations, click Custom Data Configurations.
  4. On the Custom Data Configurations page, click Create, and then select DA Scripts.
  5. In the Data Augmentation Scripts (DAS) dialog, enter an ID in Application ID, name in Application Name, and then click Create.
  6. On the DA Scripts page, in the left menu, click Source.
  7. Under Source, select main.hrf, and in the editor, enter the logic to bring data.
    In the following example, you create a data augmentation script for CUST_D using the sample Data Augmentation Scripts source files.

    Description of dasrg-dascripts-editor.png follows
    Description of the illustration dasrg-dascripts-editor.png

    To build your dataset, you can reference data from your sources into the data warehouse using the IMPORT command.
  8. Right-click the Source folder, select New and then select the type of file you want to create.
  9. Click Save and Exit.
  10. Click Build and then select Build project.
    The project compiles and validates your syntax and to ensure that the source metadata are mapped properly.

    Description of dasrg-dascripts-build.png follows
    Description of the illustration dasrg-dascripts-build.png

  11. Click the Actions icon next to the DAS Scripts application you created, and then click Publish.
    This initiates the deployment and execution of Extract, Process, and Load phases into the data warehouse.