Initializing help system before first use

Supported Data Sources

Models can initialize the input data entities from any supported source, with the some caveats.
  • The default security restrictions for xprmsrv are pre-configured to allow Xpress Insight to connect to external databases but not to external files.
  • Xpress Insight allows trusted file locations to be whitelisted as accessible from the executing Mosel model. The whitelists for read, read-write and execute permissions can be edited in the execution worker configuration file (c:\xpressmp\bin\xprmsrv.cfg by default). The worker must be restarted for changes to take effect.
  • xprmsrv is started as a service so it may not be able to use the mmodbc.excel driver to access Microsoft Excel as a data source due to an issue with certain versions of Microsoft® Windows® (Vista, 7, 2008, 8 and 2012). The recommended solution is to use the new mmsheet.xslx driver.
  • Some ODBC drivers do not behave correctly with relative paths and so attempts to access model resource files that are locally referenced may fail. In this case, the workdir parameter can be used to get the absolute path to the current working directory. For example: 
    SQLconnect('DRIVER=Microsoft Excel Driver (*.xls);dbq=' + getparam("workdir")+"\\"+ExcelFile)
Parent Topic Supported Mosel Features, Types and Data Sources

© 2001-2019 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.