- Microsoft Analysis Services;
- Oracle Essbase;
- IBM InfoSphere Warehouse.
When operating with other DBMSs , some constructions ofquery language cannot work as they are limited by the capabilities of the used ODBC driver .
The external data source consists of a set of tables.
The tables of external data source can be described manually using the wizard .
Using the connection string, the wizard may connect to the external database and give a list of tables available for adding to the external source.
Each table, in fact, is an independent configuration object . It contains a set of fields, it is possible to specify for it the forms, to create the commands and to set the templates .
The tables of external sources are used in the configuration as well as the tables of any other configuration objects .
For example, the platform automatically generates for them the forms or the developer can create the form by himself.
The data of these tables can be addressed by the query language.
These tables can be used in the reports on the data composition system.
Also, the items of these tables can be referenced to like to any other data of objective type. For example, like to the items of catalogs or the documents .