Creating a connection

You must establish a connection to the Integration database before you can import dimension and cube data. The connection appears when launching the import process.

  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. Select Microsoft OLE DB Provider for SQL Server on the Provider tab.
  8. Click the Connection tab and select the server computer for the Integration database.
  9. Specify the connection information to the SQL Server and select the Allow saving password check box.
  10. Select the database on the server where the table-based integration scripts and tables reside.
  11. Click Test Connection.
  12. Click OK.
  13. Click Test.
  14. Click OK.
    The new connection appears in the list on the left pane.
  15. Exit Designer.