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.

Links

Contents

The IAL Object Developer Tool

Ial-files can be created manually, but it is recommended to generate the first file using the form IAL Object Developer. This will help with the syntactic disposition of the file, which will aid in the development.

 

 

The IAL Object Developer

The left side includes some hints about things to remember when developing.

How to create an IAL Object

  1. Open the IAL Object Developer window in Configuration/Information Access Layer folder.
  2. Give the 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
  3. Write down the component for documentation purposes, for example FNDBAS, for the Foundation1 Base component.
  4. Check Live 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".
  5. Write or insert a valid select statement. 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.
  6. Enter a valid where clause. 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.
  7. Save and/or deploy the file into the database and begin testing.

Note! "Sql Query Tool" is very useful for writing initial select statements and for testing deployed IAL-Objects.