Nitro Table Designer

To allow users to easily extend the Nitro data model to accommodate custom reporting tables, a new table designer is available to create or update tables in the Nitro reporting layer (DDS schema) for all Nitro connectors. Users can also refresh custom tables on an ad hoc or scheduled basis.

Users can create a view or a table. Views update automatically when the source data is updated in Nitro, but tables do not. Views support simple SQL logic.

Useful Scenarios:

  • Users who want to quickly expand a data model in Nitro
  • Nitro users who want to easily upload specialty data from a vendor not included in Nitro’s data model
  • Explorer users who want to persist a query as a standard table in Nitro

Adding a Custom Table

To add a custom reporting table to an existing schema:

  1. Log into the NAC.

  2. Select Inbound from the Connectors side menu.

  3. Select the inbound connector you want to edit.

  4. Select the DDS schema in the Connector Schemas section.

  5. Select New Table.

  6. Enter the new table required details.

  7. Add the SQL query in the SQL Editor containing the logic to populate the table.

  8. Select the Create as View toggle to create a view instead of a table. This step is optional.

    Views cannot be built on temporary tables since temporary tables are not persisted in Nitro.

  9. Select Validate.

  10. Select or edit the following attributes from the Fields tab. This step is optional:

    • Active check box
    • Required check box
    • Description
  11. Select Save.
  12. Run or schedule a job with the updated connector as needed.

Updating a Custom Table

To update an existing custom reporting table:

  1. Log into the NAC.

  2. Select Inbound from the Connectors side menu.

  3. Select the inbound connector you want to edit.

  4. Select the DDS schema in the Connector Schemas section.

  5. Select the table you want to update.

  6. Select Edit.

  7. Update the SQL query in the SQL Editor or the editable attribute fields.

  8. Select Validate to regenerate the metadata. Nitro drops and re-adds the table containing the new parameters.

  9. Select Save.

  10. Run or schedule a job with the updated connector as needed.

To ad hoc refresh the data in a custom reporting table:

  1. Log into the NAC.

  2. Select History from the Jobs side menu.

  3. Select Run Job.

  4. Select the connector and job you want to refresh.

  5. Select the table to refresh.

  6. Select Execute.

Deleting a Custom Table

To remove a custom reporting table:

  1. Log into the NAC.
  2. Select Connectors > Inbound from the side menu.
  3. Select the appropriate inbound connector.
  4. Select the DDS schema in the Connector Schemas section.
  5. Select the table to be deleted from the schema (must have an __c extension). The Table Details page opens.
  6. Select the Delete button.
  7. Select Yes to confirm deletion.