Introduction to the Adapter Server

1. Rob Mace June, 2008 Introduction to the Adapter Server

2. S - 1 Objectives • Introduction to iWay • Understand iWay components (Adapters, iWay Client, and Network Services) • Discuss server deployment scenarios • iWay Adapter Server Internals • Learn about administration of the iWay Server

3. S - 2 What is iWay?

4. S - 3 iWay Components iWay Server Front-end Applications Data Sources iWay Client iWay Adapters

5. S - 4 iWay Adapters Perform data retrieval and allows the iWay server to access and process information stored in any format. iWay Server Front-end Applications Data Sources iWay Adapters

6. S - 5 iWay Adapters (continued)

7. S - 6 iWay Client Extends the reach of an existing software application without having to custom build an interface. iWay Server Front-end Applications Data Sources iWay Client

8. S - 7 iWay Network Services inbound outbound iWay Server Front-end Applications Data Sources iWay Client iWay Listeners iWay Adapters TCP/IP TCP/IP

9. S - 8 iWay Network Services (continued) A variety of environments can be integrated using iWay.

10. S - 9 iWay Server Implementations • WebFOCUS • Data Migrator • Full Function Server

11. S - 10 WebFOCUS Information Builders’ Business Intelligence product suite. Can be configured in various ways depending on application requirements but must include two essential components: • WebFOCUS Client • WebFOCUS Reporting Server

12. S - 11 WebFOCUS Client • Runs as part of your Web and/or application server and connects WebFOCUS to the Web. • Receives and processes browser requests by passing them to the WebFOCUS Reporting Server. • Includes an iWay Client component for communicating with the WebFOCUS Reporting Server.

13. S - 12 WebFOCUS Reporting Server • Is a specific configuration of an iWay Server. • Resides on the machine(s) that can access your data. • Provides data access, numeric analysis, and report generation functionality.

14. S - 13 WebFOCUS Configurations Standalone Configuration:

15. S - 14 WebFOCUS Configurations (continued) DistributedConfiguration:

16. S - 15 WebFOCUS Configurations (continued) Multiple Data Source Configuration #1:

17. S - 16 WebFOCUS Configurations (continued) Multiple Data Source Configuration #2:

18. 1 - 17 Data Migrator Suite of software components that automates the process of building and maintaining a data warehouse or data mart. Components required for a Data Migrator implementation: • Data Migrator Client • Data Migrator Server

19. S - 18 Data Migrator Client • Also called the Data Migrator Data Management Console (DMC). • Provides a graphical user interface to design, test, and run data and process flows. • Utilizes iWay client software.

20. S - 19 Data Migrator Server • Another specific configuration of an iWay Server. • Provides the central point of processing for data sorting, transformations, e-mail notification, scheduling, and security rules. • Utilizes iWay data adapters for extracting and loading the data.

21. S - 20 Data Migrator Configuration

22. S - 21 Full Function Server A configuration of the iWay server that is used to allow other applications to talk to back-end data sources.

23. S - 22 iWay Server Internals Listeners – Receive communications from client tools and applications Workspace Manager - Manages client connections and data access Adapters – Enable the iWay Server to access corporate data sources Special Services – Internal processes that perform specific tasks

24. S Connection Session Agent - 23 iWay Terminology Service

25. S - 24 iWay Server Communication

26. S - 25 iWay Server Listeners Listeners

27. S - 26 Workspace Manager Responsible for management and processing of client requests. Workspace Manager

28. S - 27 Workspace Manager Configuration Two major areas of configuration in the Workspace Manager are: General Server Configuration Settings iWay Services

29. S - 28 iWay Server Profiles Used by iWay server to customize the server environment for different users and/or applications. • Can be applied on a global, service, group, or user level basis. • Used for application set up commands such as environmental settings, search path, and DBMS connection information. • Run upon each connection to the iWay server. • Settings established by profiles are in effect for the duration of the established connection. • The server processes all profiles found in the search order. If it finds duplicate settings or commands, the last setting or command processed will be active for the connection.

30. S - 29 iWay Server Profiles (continued)

31. S - 30 Common Uses - iWay Server Profiles Global • Set default adapter connections • Establish global variables to be used by client applications • Set environmental variables Service • Establish test environments for verifying new or updated code • Establish application-specific environments for protecting application components (metadata and procedures) Group/User • Establish data connections for specific users to access sensitive data • Change default application search path • Override default settings established in global or group profiles

32. S - 31 iWay Server Administration

33. S - 32 iWay Server Administrative Tasks • Configuring data adapters • Configuring a remote iWay server • Managing application folders and files • Creating and managing metadata • Editing and managing procedures • Running and monitoring the iWay Server • Troubleshooting the iWay Server • Scalability controls such as clustering and dynamic load balancing

34. S - 33 Review • Introduction to iWay • Understand iWay components (Adapters, iWay Client, and Network Services) • Discuss server deployment scenarios • iWay Adapter Server Internals • Learn about administration of the iWay Server