Creating a data connection to the Staging database

Working with relational modeling requires data sources, from which you load data into the Staging or Integration databases. We recommend that you always configure a connection to the Staging database. You can also add connections to other relational data sources.

To create a data connection to Staging:

  1. Select Dashboards > Applications Administration > Data connections..
  2. Select the application to which to add the connection.
  3. Click Add and select Relational Providers.
  4. On the General tab, specify a name for the connection.
    We recommend that you specify Staging as both the name and the unique name.
  5. On the Connection tab, select Use built-in staging database.
  6. Test the connection and click Save.