Create a Centric Analytics Warehouse Connection from MineMarket

This activity describes how to create a Centric Analytics Warehouse connection from within MineMarket using a report connection.

A Centric Analytics Warehouse connection for MineMarket integration is required before you can create an analytics connection and map analysis objects. If an Analytics Warehouse connection has already been created in the Centric application, this activity is not required.

Security Note: You need the Allow Report Connection maintenance security right in the Reporting user group security rights group for this activity.

Activity Steps

  1. Select the Reporting panel in the Solution Explorer.
  2. Expand the Connections node.
  3. Right-click the Connections node and select New » Report Connection from the menu.

    The Report Connection screen displays the new connection.

  4. Update the Name of the report connection if required.
  5. Update the following fields as required.
    • Connection Type—Select SQLServerNative.
    • Data Source—The name of the SQL Server to which to connect.
    • Timeout—Length of time, in seconds, that a select statement is given to execute. Default: 300.
    • Initial Catalog
  6. Uncheck Use Integrated Security.
  7. Enter the User ID and Password.
  8. Click Test Connection.

    A message box displays the test result.

  9. If the connection is not successful, determine the correct settings or contact your network administrator or Datamine representative.
  10. If the connection is successful, click OK.
  11. Click Save.