Database Connections: Create a Database Connection

Select New adjacent to Connection: when defining/editing a Data Configuration to display these options.

Name

Enter or modify the name you would like to assign to this Database Connection.

This will be the name displayed to users of the Statistica Enterprise Manager when they create Data Configurations based on this Database Connection.

Note: Statistica identifies Database Connections with a unique internal identification number so the Name of the Database Connection is a descriptive label that can be changed at any time as the need arises.

Connection String

Enter or modify the database connection here.

Edit

Click this button to edit the existing connection string.

Open UDL

Click this button to open a UDL file containing connection information.

Test Connection

Click this button test the connection to the selected database.

It is good practice to the test the connection while still in this dialog to confirm that your connection configurations were entered correctly and connectivity to the target system is available.

Options:

The options in this group box contain advanced settings specific to a database connection and will be applied by default to all OLE DB queries created in any Data Configurations that uses this Database Connection. The default for each option is set based on the respective provided for the current Database Connection.

Statistica Enterprise Data Configurations that use this Database Connection will inherit these settings. Here, and in Statistica Query, these settings can be changed and will be retained when the Database Connection or query is saved. Settings in a Statistica Enterprise Data Configuration affect all queries created in any Data Configuration that uses the respective connection.

The set of Quote options determines whether references to database objects in the SQL statements generated are enclosed in quotation marks. For most database drivers, the default option is applicable. For certain drivers, placing Catalog, Schema, Table, and Column names in quotation marks causes an SQL error.

Quote Catalog

This option determines whether references to database Catalog names in the SQL statements generated are enclosed in quotation marks. 

For most database drivers, the default option is applicable.

Quote Schema

This option determines whether references to database Schema names in the SQL statements generated are enclosed in quotation marks. 

For most database drivers, the default option is applicable.

Quote Table

This option determines whether references to database Table names in the SQL statements generated are enclosed in quotation marks. 

For most database drivers, the default option is applicable.

Quote Column

This option determines whether references to database Column names in the SQL statements generated are enclosed in quotation marks. 

For most database drivers, the default option is applicable.

Force retrieving rowset information

This option determines whether information about the column types is requested by the OLE DB query.

For some database formats, this information is automatically returned by the query, and placing an explicit request in the query causes a substantial increase in its time to execute.