External data source

  • 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.

1C:Enterprise 8 - External data source

The tables of external data source can be described manually using the wizard .

1C:Enterprise 8 - External data source

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.

1C:Enterprise 8 - External data 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 .

1C:Enterprise 8 - External data source

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.

1C:Enterprise 8 - External data source

The data of these tables can be addressed by the query language.

1C:Enterprise 8 - External data source

These tables can be used in the reports on the data composition system.

1C:Enterprise 8 - External data source

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 .

Leave a Reply

Your email address will not be published.

 

1C:Enterprise Developer's Community