Create Information Access Layer Objects

Obsolete picture, otherwise ok!

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

Links

• Setup Information Access Layer
• Administrate Information Access Layer

Contents

• The IAL Object Developer Tool
• How to create an IAL Object

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 FNDDEM, for the Foundation1 Demo 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.
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.
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.