Does Statistica support ODBC?
Yes, using Statistica Query, an external data querying facility available from the Data - Get External Data menu and the File - Get External Data menu.
The Statistica Query interface includes options to combine fields from multiple tables and provides flexible access to a wide variety of database management files, including the major enterprise database formats such as Microsoft SQL Servers and Oracle.
Specific records (rows of tables) can be selected by entering SQL statements. Statistica Query automatically builds the SQL statement for you as you select the components of the query using a simple graphical interface and intuitive menu options and dialogs.
An extensive knowledge of SQL is not necessary in order for you to create advanced and powerful queries of data in a quick and straightforward manner. Multiple queries based on one or many different databases can also be created to return data to an individual spreadsheet. Therefore, you can maintain connections to multiple external databases simultaneously.