Database Connection

Select Create Query from the Data - Get External Data menu to display the Database Connection dialog box. It is also displayed when you select New from the File menu when you are using Statistica Query.

Use these options to specify a database connection.

OK. Click this button after a database connection has been selected in the Connections field. After you click the OK button, Statistica Query will be accessible with the specified database displayed in the Tree pane.

Cancel. Click this button to close the Database Connection dialog box. Statistica Query will now be accessible; however, there will be no database displayed in the Tree pane.

Connections. All of your predefined database connections are listed in the Connections field. Select the desired database connection based on OLE DB or ODBC provider. If the database connection is not available in this field, create it by clicking the New button or open an existing configuration file by clicking the Browse button. When the database connection has been selected, click the OK button.

New OLE DB. Click this button to display the Data Link Properties dialog box, which is the first of a step-by-step wizard to create a database connection. For specific documentation when you are using the Data Link Properties dialog box, press the F1 key on your keyboard to open the Microsoft Data Link Help®.

New ADO.NET. Click this button to display the Choose Data Source dialog box, which is the first of a step-by-step wizard to create a database connection based on default ADO.NET providers distributed with standard .NET installation; these include Access, ODBC, SQL server, and Oracle.

New 3rd ADO.NET. Click this button to display the Add an ADO.NET Database Connection dialog box, which is the first of a step-by-step wizard to create a database connection based on third party .NET providers that are available on your system. These may be installed with specific client installation packages that your DBMS vendor may have provided.

Edit. Click this button to display the Edit Database Connection dialog box, which is used to edit the currently selected database connection.

Delete. Click this button to delete the currently selected database connection. When you click the Delete button, a Statistica Query dialog box is displayed prompting you to verify that you actually want to delete the selected item. Click Yes if you want to continue. Click No if you want to exit the dialog box without deleting the selected database connection.

Browse. Click this button to display the Select Data Link File dialog box. Use these options to locate and open a previously saved configuration file (such as a data link .udl file) that contains information about the database connection parameters.

NOTE: Connecting to your local computer. In other words, all data retrieved by the query is copied into a Statistica data file, and stored locally. Alternatively, you can connect to external databases and retrieve particular sets of data via query without the need to create a local copy of the data. Specifically, in the Create New Document dialog box, select the Streaming DB Connector tab to create a connection to a database that will look to Statistica as if it were a regular data file.  In other words, when you use the streaming options, the program does not first copy and store all data returned by the query on your local computer and then begin the analyses, but rather, the computer processes the database in place, only fetching the information from the database when it is needed for computations. Hence, streaming database connectors are particularly useful and efficient when processing extremely large data sets (retrieved by a query from an external database), and they are commonly used in Data Mining applications. Note that streaming connectors are currently only supported by OLD DB database connections, not ADO.NET connections.

See also Streaming Database Connector Technology for additional details.