Connecting to databases using the Data perspective
To create a new connection to an existing
database using the Data perspective:
Open the Data perspective by clicking Window > Open Perspective > Data.
Right-click the Database Explorer and
click New Connection. The New Database
Connection wizard opens.
Follow the instructions in the wizard to provide connection details
and create filters.
You can 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. You
cannot change these filters after you have created the connection.
Click Finish. The wizard
creates the database connection and a dialog box appears,
asking if you want to copy the database metadata to a project folder.
To associate the new connection with a message
flow project, click Yes and click Browse to
navigate to the appropriate message flow project.