How do I retrieve external data via Statistica Query?

Statistica Query is used to easily access data from a wide variety of databases (including many large system databases such as Oracle, Sybase, etc.) using OLE DB conventions. The steps necessary to retrieve external data via Statistica Query are outlined below:

  • Select Create Query from the Data - Get External Data menu (or from the File - Get External Data menu) to display the Database Connection dialog box, which is used to select a predefined database connection (the provider, data source location, and advanced settings of the server or directory on which the data resides).

Note that if you have not already created the database connection, you can do so by clicking the New button in the Database Connection dialog box. The Data Link Properties dialog box will then be displayed, which will guide you through a step-by-step wizard to create a database connection. For specific documentation when you are using the Data Link Properties dialog box, press F1 on your keyboard to display the Microsoft Data Link Help®. See How do I set up a database connection using the OLE DB provider for ODBC? for further details.

  • After you select a database connection and click the OK button on the Database Connection dialog box, you now have access to Statistica Query in which you can specify the desired tables, fields, joins, criteria, etc. (via the Table, Join, and Criteria menus) to be included in the query.

See Example - Querying a database using ODBC and Example - Querying a database using ODE DB for step-by-step examples.

Note: Connecting to external databases for streaming. The Get External Data option executes a user-defined query and copies the resulting data 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 database connector 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 connections 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. See also Streaming Database Connector Technology for additional details.