Connecting to the database

Create a connection between the IBM® App Connect Enterprise Toolkit and the CLIENTS database.

Before you begin

In the scenario, user ID db2admin is used. Ask your database administrator for the user ID and password, and use these values for the userID and password variables. The user must have suitable permissions to read and create a stored procedure in the relevant database schema.

About this task

Connect information is stored in a database definition (.dbm) file.

Procedure

  1. Open the IBM App Connect Enterprise Toolkit and click the Data Source Explorer view.
  2. Right-click CLIENTS, and then select Connect.
    If the CLIENTS database is not listed, proceed as follows:
    1. Right-click Database Connections, and then click New.
    2. Set the database manager to DB2 for Linux, UNIX, and Windows.
    3. Set the Database to CLIENTS.
  3. To set up the connection to the database, complete the following fields:
    • Type db2admin as the User name.
    • Type the user password in Password.
    • Select Save password.
  4. Click Test Connection.
  5. If the connection succeeded, click Finish.

Results

You are now connected to the CLIENTS database. Expand the CLIENTS database to view the schemas. Expand the ADDRESSBOOK schema, and then Stored Procedures. You should see a stored procedure that is named EMPLOYEEDETAILS.

What to do next

Follow the steps in Creating a data development project.

Tip: Database definition files are not automatically updated. If you modify your database, you must re-create the database definition file that describes the connection to the database.