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.

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

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 Validate.

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

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

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.