Define Custom Database Connections

Now that the connection is set up and communicating with the Smart Integration Connector Gateway, the final step is to set up the location of the remote data source in OneStream. To continue adding the Custom Database Connection, you must assign a user to the ManageSystemConfiguration role.

  1. Go to System > Administration > System Configuration.

  2. Select Application Server Configuration > Database Server Connections.

  3. Select Create Item to create a new Custom database server connection.

    NOTE: If the only fields displayed are Name and External Database properties, verify that the current user is assigned to the ManageSystemConfiguration role.

  4. Enter the Name of the Database Server Connection.

  5. For Database Provider Type, select Gateway.

  6. The Gateway Name drop-down menu will be populated with a list of configured gateways. Select the Gateway.

  7. After the Gateway is selected, the Data Source Name drop-down menu populates with a list of the Local Gateway Server Database Connections.

  8. Select a Database Connection from the drop-down menu.

    NOTE: If the remote data source is not displayed or the Gateway is offline, you can select Custom to allow the data source to be manually specified. It is advised to wait up to five minutes for the Gateway to populate first.

  9. Click Save to complete the configuration.

  10. Verify the custom database connection is under Custom.