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
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.
- Open the IAL Object Developer window in Configuration/Information Access Layer
folder.
- 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
- Write down the component for documentation purposes, for example FNDBAS,
for the Foundation1 Base component.
- 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".
- 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.
- 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.
- 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.