Creating a connection

You must establish a connection to the Integration database before you can import dimension and cube data.

  1. Start Designer.
  2. Expand System.
  3. Select Connections.
  4. Click New in the right pane.
  5. Specify a name for the connection. For example, depm_integration.
  6. Click the Wizard button.
  7. Click the Connection tab and select the server computer for the Integration database.
  8. Specify the connection information to the SQL Server and select the Allow saving password check box.
  9. Select the database on the server where the data integration for the Base Data Store scripts and tables reside.
  10. Test the connection.
  11. Exit Designer.