1. Analytical Application Infrastructure User Guide
  2. Object Administration
  3. Translation Tools
  4. Config Schema Download

Config Schema Download

Configuration schema refers to the database schema that is referred by all information domains to access data related to Metadata, System Configuration, Administration Security, and so on. Configuration schema stores the user security information and metadata used within the applications which are deployed on OFSAA Infrastructure.

The Config Schema Download window facilitates you download data from configuration schema tables along with the option to filter data during download, in Microsoft Excel 2003/2007 format. The Config Schema Download window has restricted access and you should have Config Excel Advanced user role mapped to your user group to download configuration schema data.

To download Config Schema Data:

  1. Select the table from the drop-down list. The list consists of those database objects (tables) which are mapped to Configuration Schema based on a specific configuration.
  2. Select the Format to download from the drop-down list. You can either select Microsoft Excel 2003 or 2007.
  3. (Optional) If you want to download only the required data instead of complete table data, specify a filter condition in Filter(where clause) field. For example, if you want to download Group Code details from the table “cssms_group_mast”, you can specify the filter condition as: elect * from cssms_group_mast where v_group_code in ('AUTH')
  4. Select Download. The File download dialog box is displayed providing you with options to Open or Save a copy of the file in selected excel format.