Skip to main content
Installation Progress
  1. Create the source connections
  2. Create the destination connection
  3. Import the extractions
  4. Schedule the extractions
  5. Set up the data sources in Nectari
  6. Import the template
  7. Build and load the OLAP cubes

Import Template

Importing the Sage 100 NA template provides your Nectari environment with a complete set of standard reports, dashboards, and views. Before you begin, make sure you have your ERP database name, schema, and Nectari custom schema ready.

Download the template ZIP file that matches your Nectari version (TPL_20XX.0.X.XXX_Sage100NA.zip). You can get the latest template from ShareFile.

important

Web browsers have updated their policy regarding cookies. To embed Nectari in your ERP website or enable Single Sign-On (SSO), apply the required cookie management changes on your web server.
For details, refer to Cookie Management.

Import the template​

Run the template process​

  1. If not already open, in the navigation panel, select the gear icon to open Administration.
  2. Expand Templates and select Import Template.
  3. Click Select files or drag the ZIP file into the window.
    You can find the template ZIP file here:
    Packages\Templates\Templates - Official\20XX Release X\Sage 100NA\WebServer
  4. In the Data Sources Mapping window, match each Received Data Sources Description with the corresponding Current Data Sources Description you previously set up.
  5. Ensure that only the desired data sources from the template are selected under Received Data Sources Description.
  6. In Current Data Sources Description, click Bind a Data Source and select your existing data source from the dropdown list.
  7. Click Next.
  8. On the Data Models screen, review the list that compares the template content with your environment.
    On first-time imports, the first columns will show None and Never installed, and the Add box will be checked by default for all rows.
  9. Uncheck the Add box for any objects you do not want to import. You can also choose Update or Skip as needed.
  10. Click Next to continue. The import may take several minutes depending on the number of objects.
  11. Select the environment(s) where the scripts should be executed. Each environment will appear as a column in the table.
  12. Enter the required parameter values for each column such as schema names.
  13. Click Next.
  14. When the import is complete, review the execution report:
    • The first section corresponds to the ERP data source.
    • The second corresponds to the Cube data source.
    • Click the checkmark icon in each row to view script details.
  15. If all scripts succeed, close the window.
    • If any script fails, click the error icon to open the report. You can copy, debug, and rerun the failed script.
    • Users proficient in SQL can debug directly in the Report Preview window using the Try to rerun button.

Update a template​

Updating the template is only required if you encounter issues with Nectari data models or custom objects, or need to update template content. Software upgrades do not update the template automatically.

  1. After mapping data sources, select the checkboxes for the objects to upgrade you want to update, then click Next.
    • By default, nothing in the Update column is selected.
    • If a new data model or view is included, the Add option will be preselected.
    • Select Skip to ignore or Update to overwrite existing objects. Updating will overwrite customizations.
  2. Select the environment where the scripts will run and click Next.
  3. Complete the parameters and click Next.
  4. In the execution report, click the error icon for any failed scripts to view and debug them.
  5. Copy and rerun the script as needed, or debug directly in the Report Preview window using Try to return.


Next: Build and Load OLAP cubes →