Data source access from Mosel models
Access to data files with formats other than the initializations text file format can be achieved with the help of modules or packages that define additional functions specific to a format or data source type. Alternatively, other formats can be used directly in the initializations block, and hence minimizing the changes required in a model to switch between different data formats.
The drivers odbc, excel and diskdata described in this section are used in the initializations block of the Mosel language to provide access to new data file formats and data sources. Some of the drivers described in Section Exchange of information with embedded models (e.g. raw and mem) also provide such a functionality. However, they are only of use in models embedded into an application and run through the Mosel libraries, not in stand-alone Mosel models as is the case with the odbc, excel and diskdata drivers.
For a more in depth discussion of the database and spreadsheet drivers and examples of their use, the reader is referred to the Xpress whitepaper Using ODBC and other database interfaces with Mosel. Besides the ODBC and spreadsheet access functionality described in the following sections, this whitepaper also explains how to use the direct Oracle interface defined by the module mmoci (including the I/O driver mmoci.oci that behaves similar to mmodbc.odbc and SQL statements corresponding to the functionality described in Section Alternative implementation using SQL statements) in the place of an ODBC connection.
© 2001-2020 Fair Isaac Corporation. All rights reserved. This documentation is the property of Fair Isaac Corporation (“FICO”). Receipt or possession of this documentation does not convey rights to disclose, reproduce, make derivative works, use, or allow others to use it except solely for internal evaluation purposes to determine whether to purchase a license to the software described in this documentation, or as otherwise set forth in a written software license agreement between you and FICO (or a FICO affiliate). Use of this documentation and the software described in it must conform strictly to the foregoing permitted uses, and no other use is permitted.