Database Connections: New Database Connection

  1. Right-click the Database Connections node in the tree view.
  2. Select one of these: 
  • New Database Connection to display the Data Link Properties options
  • New Database Connection from DataLink File to display  the Select Data Link File options, respectively.

After entering the appropriate database connection information, the New Database Connection options will be displayed in the properties page.

Name

Enter or modify the name you want 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. If a user has read-only access, this information will not be displayed.

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 to test the connection to the selected database. It is good practice to 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 use this Database Connection.

The default for each option is set based on the respective connection 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 a 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.

Access Permissions

Click this button to display the Access Permissions options in the properties page.