The ODBC Connector for Optymyse 5.1.x allows you to connect any data source with an ODBC driver to an Optymyse 5.1.x installation (Cloud or On Premise).
For example, you may have data in any one of the following:
SQL Server, Oracle or MySQL database
MS Excel spreadsheet
The ODBC connector allows you to specify an ODBC connection using either a defined DSN, or by specifying the full connection details in the configuration. You may also specify the query to execute on that ODBC connection - this will usually be a SELECT query of some kind; the actual content and format of the query will be dependent on the data source.
To use the ODBC connector for multiple sources you need a feed license per query.
Please download our full PDF below for more information