Skip to main content
Installation Progress
  1. Create the source connections
  2. Create the destination connection
  3. Upload the project into Acumatica
  4. Import the extractions
  5. Schedule the extractions
  6. Set up the data source in SEI
  7. Import the template
  8. Buld and load the OLAP cubes

Destination Connection

You must create a destination connection to specify where DataSync will store all extracted Acumatica 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 2 – data warehouse and 3 – consolidated, select SQL Server or Oracle based on your SEI data warehouse platform.
    • For scenario 4 – 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 4 – cloud, use the credentials provided to you.
  6. Click Save.


Next: Upload the Project into Acumatica →