Can Statistica access data from mainframe databases?
Use Statistica Query to easily access data from a wide variety of databases (including many large system databases such as Oracle, Sybase) using OLE DB (Object Linking and Embedding Database) conventions. OLE DB is a database architecture that provides universal data integration over an enterprise network, from mainframe to desktop, regardless of the data type. OLE DB is a more generalized and more efficient strategy for data access than ODBC because it allows access to more types of data and is based on the Component Object Model (COM).
Statistica Query supports multiple database tables; 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 by a simple graphical interface and intuitive menu options and dialogs. Hence 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. Hence, you can maintain connections to multiple external databases simultaneously.