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 extraction
  5. Schedule the extraction
  6. Set up the data source in Nectari
  7. Import the template

Destination Connection

You must create a destination connection to specify where DataSync will store all extracted Sage 300 People data. This connection points to your data warehouse—a central database where the template will load and organize data received from your source connection.

Create a destination connection​

  1. Next to Destination Connections, click New.
  2. Choose the connection type. Select SQL Server or Oracle, depending on where the Nectari data warehouse is hosted.
  3. In the Connection Properties panel, enter Data Warehouse as the Description.
  4. Enter the Server and Database names.
  5. Enter the Username and Password.
  6. Click Save.


Next: Import the Synchronization Extraction →