Setting connection limits for data source definitions

You can control the number of simultaneous active connections to a data source by setting a connection limit. This helps manage resource usage and prevents overloading the data source.

How Connection Limits Work

When you configure a maximum number of active connections for a data source definition, the following features are enabled:

  • Connection Tracking: The system tracks all active connections to the data source in real-time.
  • Limit Enforcement: When a user attempts to connect to the data source, the system checks if the limit has been reached.
  • Automatic Refresh: The system periodically refreshes limit information to ensure consistency.

Prerequisite

Set up connection limits

To configure a connection limit for a data source definition:

  1. Go to Data > Connectivity from the main menu.
  2. Select the data source definition you want to configure.
  3. In the properties panel, set the following attributes:
    • Enable Include limit of active connections.
    • Set the maximum number of allowed simultaneous connections by entering a value for the Limit of active connections attribute.
  4. Set the data source definition state to Active.
  5. Save your changes.

Connection limits only apply when the following conditions are met:

  • The maximum active connections value is specified.
  • The data source definition state is Active.

If the limit is reached, you will see the following error:

You have exceeded the number of active connections that the Platform Administrator has set. Ask your Platform Administrator for details and try again later.

You need to wait for other connections to complete or contact the Platform Administrator to increase the limit.

Disabling Connection Limits

To disable connection limits for a data source definition:

  1. Got to the data source definition settings.
  2. Choose one of the following options:
    1. Remove the value from the Maximum Active Connections field.
    2. Set the data source definition state to Inactive.
  3. Save your changes.

When the connection limits are disabled, you can create unlimited concurrent connections to the data source. This is subject to any limitations set up from the data source.

Best practices

For platform administrators:

  • Set limits based on data source capacity and expected usage.
  • Monitor usage and adjust limits as needed.
  • Document limits for your users.

For Users:

  • Retry after a short wait if you hit the limit.
  • Close connections promptly when finished.
  • Avoid leaving queries idle.

Learn more