User guide

Data Integration with Sybase Avaki Studio 31
The exercise
• HIREDATE: The date the employee was hired
• SAL: The employee’s salary
• COMM: The employee’s commission rate
The database connectors
The required information resides in two databases. The following database connectors
are needed:
• dept_db
Connects to the department database, which has a table, EMP, with these columns:
DEPTNO, DNAME, LOC
• emp_db
Connects to the employee database, which has a table, DEPT, with these columns:
EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO
The emp_db connector has been configured by the database administrator; we’ll con-
figure dept_db.
Tasks in this tutorial: the to-do list
To set up the HR data service, we must complete the tasks listed here. The tutorial
takes about an hour to complete.
1. Configure the dept_db database connector.
2. Configure two database operations—one to extract data from each database.
3. Create a new view model.
4. Within the view model, set up two input sources—one for each of the database opera-
tions in task 2.
5. Create a view model parameter to accept the name of an employee and map the input
source parameter to the new view model parameter.
6. Use a Join operator to combine the two input result sets.
7. Use a Projection operator to combine the EMPNO, ENAME, and JOB columns into a
single NameNumberJob column.
8. Test the view model.
9. Deploy the view model as a data service in the Avaki data grid.