Skip to content

Create Information Access Layer Objects

Setting up IAL objects is done as part of an implementation project for a customer. Read more about the IAL concept.

IAL Objects page

IAL files can be created manually, but it is recommended to generate the files using the IAL Objectspage.

IAL Page

The IAL Objectspage

This page lists all the available IAL objects in the environment.

How to create an IAL Object

  1. Navigate to IAL Objects page in IFS Aurena Client
  2. Click on the Create New/ Load Existing button.
    Create New
  3. Select Create New option in the assistant and click next
  4. In the next step provide the IAL object a name. Max 26 characters, underscores accepted but not spaces. This name is the base for all database objects that are generated for this IAL object. The name should be in plural, i.e. CUSTOMERS
  5. Select the component, this is mainly for documentation purposes, for example FNDBAS, for the Foundation1 Base component.
  6. Check Create IAL for Live Data Only if you want the IAL object to be created without any table and index. This will prevent the Scheduling option from being enabled and all data will accessed online.
  7. Write or insert a valid select statement in the Select Statement text area. This will represent the Transfer Part of the IAL-Object which describes what data will be included. Full SQL syntax is supported and column aliases used with preference. The 'WHERE clause' to filter out data should also be included with the select statement in this section. This is described in more detail below.
  8. Enter a valid where clause in Where Clause field. This will be applied to the end user view if the IAL is schedule as full or partial replication. Include all the columns that are used in the where clause in the select statement. Note that this section should not be used to add where clauses to filter out data. That should be added along with the select statement above. You should add the row base security where clause in this section. This will make sure that the correct data is shown to the user according to the security privileges.
  9. Click Next. It will automatically download the IAL file in to local Downloads folder.
  10. Click Next to deploy the IAL in to database.

How to load an existing IAL Object

  1. Navigate to IAL Objects page in IFS Aurena Client.
  2. Click on the Create New/ Load Existing button.
  3. Select Load From File option in the Choose Option step in the assistant and click Next
    Load From File
  4. In the next step select the IAL file by using Browse IAL File... button and click Next
  5. Select the component, this is mainly for documentation purposes, for example FNDBAS, for the Foundation1 Base component.
  6. It will load the IAL definition in to relavent fields in the assistant. Make the changes to the IAL definition if you need any. (Refer the above section for more details)
  7. Click Next. It will automatically download the IAL file in to local Downloads folder.
  8. Click Next to deploy the IAL in to database.