Data - Get External Data - Create Query

Ribbon bar. Select the Data tab. In the Manage group, click External Data and from the menu, select Create Query...Or, select the File tab. In the left pane, click External Data and in the right pane under Query, click Create...

Classic menus. From the Data - Get External Data submenu (or the File - Get External Data submenu), select Create Query...

...to open Statistica Query and display the Database Connection dialog box. Once you have chosen or defined a database connection, you can use Statistica Query to write your query.

For details on defining a database connection, see the FAQ: Working with Statistica Query.

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 will be 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:

Ribbon bar. Select the File tab. In the left pane, click New. In the right pane under the Classic New Document Dialog heading, click New Document. In the Create New Document dialog box...

Classic menus. Select New from the File menu; 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 will not first copy and store all data returned by the query on your local computer and then begin the analyses, but rather, the computer will process the database in place, only fetching the information from the database when it is needed for computations. Hence, streaming 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.