# ConnectionString

The connection string to use to connect to a SQL database that you want Coordinator to use to store Controller information.

If you set UseODBCDatabase to `True` in the `[StatsCollector]` section, Coordinator also reads statistics from this database. In this case, you must configure your Controller components to populate the database with statistics.

The database must already exist in the SQL backend, but Coordinator creates any required tables after it connects.

TIP: You can encrypt the value of this parameter by using the autpassword command line tool. For more information about how to use this tool, refer to the IDOL Server Administration Guide.

Alias: | `SQLConnectionString` If you set both `SQLConnectionString` and `ConnectionString`, `SQLConnectionString` takes precedence.
Type: | String
Default: | None
Required: | No
Configuration Section: | Server
Example: | `ConnectionString=Driver=PostgreSQL ANSI(x64); Server=sql-host.mycompany.com; Port=5432; Database=coordinatordb; Uid=postgres;password=password;`
See Also: | UseODBCDatabase

_FT_HTML5_bannerTitle.htm