# 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

© Copyright 2015-2019 Micro Focus or one of its affiliates | Send documentation feedback Close Send documentation feedback To open the configured email client on this computer, open an email window. Otherwise, copy the information below to a mail client, and then send this email to swpdl.idoldocsfeedback@microfocus.com. We appreciate your feedback! Product: Topic Title: Help Topic: Feedback:

_FT_HTML5_bannerTitle.htm