You can use iWay Explorer to connect to relational databases, such as Oracle or Informix and to non-relational databases, such as an IMS database. The majority of the interactive information that is generated for the RDBMS adapter, such as, targets, statements, and web services are stored in the iBSP repository.
When connected to non-relational databases, the adapter uses an iWay server component which enables you to take advantage of all the integration capabilities offered by iWay Software for mainframe database access. For example, when using the iWay server component, you gain relational database access to non-relational data. Stored procedures for non-relational databases can be created and stored using the server component.
The following highlights the tasks you will perform to generate request and response document schemas and a business service, and provides references to the related procedures found in this chapter.
You can open a new or existing connection to a relational or non-relational database management system, as described in Creating and Managing a Connection.
After you connect to a system, you can expand the iWay Adapters node to view the list of adapters installed on your system. After you finish using a connection, you can close it. If you will not need the connection in the future, you can delete it.
Note: When you close iWay Explorer, it automatically closes all open connections.
The schemas define request and response documents for your SQL statements and stored procedures, as described in Creating an SQL Statement and Generating Schemas.
You can use the schemas when you create request documents and when you develop logic to process responses.
You create documents for each operation against each table and for each stored procedure. You can use a third-party XML tool to generate a request document from the XML schema.
You also may want to examine the metadata describing your SQL statements and procedures, as described in Viewing Metadata. For information about request and response document formats, see Request and Response Documents.
iWay Software |