The Aii (Active Integration Interface) Designer is a set of integrated components consisting of source and destination templates, mapping definitions, business rules, and a Transformation Engine that will guide you through the process of creating, integrating, modifying and testing interfaces between applications. Using the Aii Designer’s graphical user interface, a user or system administrator creates aiis (maps) that describe the source and destination data formats, as well as the means with which the data will be manipulated through the transformation process. The map building and definition capabilities in the Aii Designer provide the rules and methods to define data transformation relationships between source and destination templates, and apply business rules, data filtering conditions, complex equations, and formulas with an easy-to-use point and click interface.
Since the Aii Designer is compatible with many different file formats, Applications Communication Handlers (AppComms) are available to simplify and expedite interface development and execution processes. AppComms are used by templates to “communicate” with the applications or databases that are being integrated. Enterprise Enabler’s AppComms understand the details of various data file formats and application interfacing requirements, as well as communications specific to the application
An Aii (Active Integration Interface) Definition in Enterprise Enabler, is an object that allows users to map data sources to destinations. Using the Active Integration Interface (Aii) Designer, a user can create rules and methods to control data transformation between source and destination templates. Mapping source data to destination data is achieved by simple drag-and-drop actions. This allows disparate types of data (i.e. relational data, plain text, etc.) to be used together as a single “data source” for processing. In addition to data mapping, the Aii Designer provides a simple interface to create any combination of logical conditions and formulas.
Example on how to create an Aii Definition, mapping an SQL source to a Delimited Text Destination.
This section will cover how to create an Aii definition using an SQL Server Source Template and mapping it to a Delimited Text Destination Template.
a) Go to the File menu –> New –> Aii
A blank Aii interface will open. Expand the tree category where your sources and destinations are. In this example, our sources and destinations are under the Northwind tree to the left of your screen as you can see in the screenshot below.
b) Click on your destination template on the left, drag it over and drop it into the Destination Templates area. In this example, our Destination Template is named dstEmployeesCSV.
Note that the “Mappings” area in the Aii Designer will be populated with the blocks and columns contained in the Destination Template, this comes in handy next, when we connect our source(s) to that destination.
c) Click on your source template on the left, drag it over and drop it into the Source Templates area. In this example, our Source Template is named srcEmployeesSQL.
d) Click on a block from your source template, drag it and drop it onto the first block in the Mappings area, and confirm the message asking if you want to intelligently derive relations by doing a click on Yes. Note that this block will become the driving block. In this example, our source block is named Employees, and so is our destination block. Your source and destination blocks do not necessarily need to have the same name.
e) Inside the Mappings area click on Aii. Next, under the properties to the right side of the screen do the following:
- Set the CategoryName to: NORTHWIND. (You can also choose a category or your own or create a new one)
- Set the Name to: aiiEmployeesSQLtoCSV. (you can also choose your own name)
f) On the File menu click on Save.
g) Click on the Preview Data button at the top toolbar to run a preview of your mapped data.