Connecting to databases using the Data perspective

The Data perspective is available as part of the Message Brokers Toolkit for WebSphere Studio. For more information about the Message Brokers Toolkit for WebSphere Studio, see Client environment and Different versions of the Message Brokers Toolkit.

To create a new connection to an existing database using the Data perspective:

  1. Open the Data perspective by clicking Window > Open Perspective > Data. When the perspective opens you see the DB Servers view.
  2. Right-click the DB Servers view and click New Connection. The New Database Connection wizard opens.
  3. Depending on the database vendor type to which you are connecting, you might need to provide details of the connection, such as the name of the JDBC connection, name of the database, database user ID and password, database vendor type, host name, port number, name of the JDBC driver, JDBC driver class, class location, and the URL to the connection. See the WebSphere Studio Application Developer infocenter for more information about the settings required for each vendor type.
  4. Create filters by clicking on the Filters button.

    It is recommended that you create your own JDBC connection filters to exclude one or more tables from relational view. This decreases load time, which can be considerable for connections to a remote server.

    By default, the Exclude system schemas check box is ticked, excluding the system schemas that come with the database. However, if you are connecting to either a SQL Server or a Sybase database, you must clear the Exclude system schemas check box.

    When you have created the connection, you cannot change these filters.

  5. Click Finish. The database metadata is collected and used to create a transient model. This model can be viewed in the DB Servers view.

You can use this method of creating a new database connection when importing database schema files into a message flow. See Adding a database mapping input or Adding a database mapping output for more information.

Related tasks
Accessing databases from message flows
Configuring access to databases
Creating the databases
Adding a database mapping input
Adding a database mapping output
Related reference
Supported databases
User database connections