Skip to main content
Installation Progress
  1. Set up the data and API access
  2. Create the source connection
  3. Create the destination connection
  4. Import the extractions
  5. Schedule the extractions
  6. Set up the data source in Nectari
  7. Import the template

Set Up Data and API Access

To ensure Nectari can securely extract the necessary data from Sage 300 People, you must first configure API access and import the required queries.

This setup enables communication between your reporting environment and Sage 300 People and allows you to automate and customize data integration for analytics.

Obtain the API key​

  1. Open the official Sage 300 People API Documentation.
  2. Follow the instructions to generate your Sage 300 People API key.
  3. Save the API key securely—you need it to configure the data source.

Set up Generic GET API queries​

To enable data integration, import the provided Generic GET API queries into Sage 300 People.

  1. Log in to Sage 300 People.
  2. Go to Utilities, then API, then Generic GET API.
  3. Download and unzip Sage300People_Queries.zip.
  4. Open one of the .txt files and copy its entire contents.
  5. In Sage 300 People, create a new Generic GET API query.
  6. Paste the file contents into the Query field.
  7. In the Code field, enter the file name without the .txt extension.
  8. Save the query.
  9. Repeat steps 4–8 for each remaining .txt file in the ZIP.


Next: Create the Source Connection →