# Database Settings

The Database Settings allow administrators to adjust how Exago interfaces with databases. Additional type-specific settings allow you to specify which driver to utilize when connecting to each data source.

The following Database Settings are available:

### Database Timeout

Maximum number of seconds for a single query to run.

> NOTE. This setting will also control the maximum number of seconds that a Web Service Api method can run. If set to ‘0’ the Web Service time out will be ‘infinite’.

### Database Row Limit

Maximum number of rows returned on an execution. This only applies to Tables, Views and Functions. Set to ‘0’ to return all rows.

### Row Limit Step Size

(v2017.2+) Maximum number of rows returned on a query. Set to ‘0’ to return all rows. Set to > 0 to enable Incremental Loading for Advanced Reports and ExpressViews. The value determines how many rows are returned for each user-initiated data query.

### Disable Non-Joined Data Objects

If True users are not able to add Data Objects to a report that does not have a join path with at least one other Data Object on the report. Set to False to disable this behavior.

### Enable Special Cartesian Processing

If True any one-to-many Joins will cause special processing to avoid data repeating on the report. Set to False to disable this behavior.

### Aggregate and Group in Database

(v2016.3+) If True, aggregate and grouping calculations will be done in the database when possible. This will provide a performance boost for reports with group sections.

> IMPORTANT. Before enabling this, you MUST ensure that all One-To-Many Joins in your environment are correctly identified and set as One-To-Many in the Join options menu. If these joins are not properly identified, reports which utilize them will return incorrect aggregate data! See Database Aggregation for more information.

# Type-Specific Database Settings

Each Type of Data Sources has the following settings available.

### Data Provider

The name that can be used programmatically to refer to the data provider. This matches the InvariantName found as a property of DbProviderFactories in the machine.config file. See this link for more information.

### Table Schema Properties

Specifies how to retrieve the schema of tables.

### View Schema Properties

Specifies how to retrieve the schema of views.

### Function Schema Properties

Specifies how to retrieve the schema of Functions.

### Procedure Schema Properties

Specifies how to retrieve the schema of Procedures.

> NOTE. For any of the Schema Property settings you can dynamically refer to properties from the Data Source’s connection string by surrounding the property name in @ symbols. Ex. "@database@" will be replaces with the database name from the connection string of the Data Source being queried.