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 SEI
6. Import the template
7. Build and load the OLAP cubes

Destination Connection

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

Create a destination connection

1. Next to Destination Connections, click New.
2. Choose the connection type.
   
   • For scenario 1 – data warehouse, select SQL Server or Oracle, depending on where the SEI data warehouse is hosted.
     
   • For scenario 3 – cloud, select SQL Azure.
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.
   
   • For scenario 3 – cloud, use the credentials provided to you.
6. Click Save.

Scenario 1: Data Warehouse & Scenario 3: Cloud – Next: Import the Synchronization Extraction →

Scenario 2: Consolidated – Next: Import the Consolidation Extraction →