Contents

Previous

Next

OMSQL-> introduction sqlconnect sqlexec sqlfetch sqlcolnames sqlnumrows sqltables sqldisconnect

introduction

Index-> contents reference index search

Introduction
Introduction
The Data Access Toolbox enables you to use O-Matrix to retrieve, analyze, and visualize data stored in databases and ODBC data sources. From within O-Matrix you can use SQL (Structured Query Language) to obtain data from local or network data sources.



• Interfaces with ODBC compliant data sources such as Microsoft Access, Oracle Microsoft SQL Server, and MySQL
• Executes SQL queries directly from within O-Matrix
• Provides an easy-to-use set of data access functions to simplify the process of data retrieval
• Enables you to retrieve and combine results from multiple data sources
• Provides efficient data retrieval for both local and network based data sources



Using the Data Access Toolbox with O-Matrix enables the technical analysis of SQL based data, and simplifies the development of sophisticated Business Intelligence, (BI) applications.

System Requirements
The Data Access Toolbox requires O-Matrix version 5.5 or greater and is available for all Windows operating systems supported by O-Matrix. The Data Access Toolbox is compatible with ODBC data sources and requires that the ODBC driver for your data source be installed.

The examples in this documentation use the Microsoft Access database and sample data formated for that system. The examples, however, may be modified to work with other ODBC sources.