Creating a Database Connection Profile

A connection profile contains the connection property information needed to connect to a database server in your enterprise.

1. In the Enterprise Explorer, right-click Database Connections and select New.
2. On the Wizard Selection page, select an option from this list and click Next:
   • DB2 for Linux, UNIX, and Windows
   • DB2 for i5/OS
   • DB2 for z/OS
   • Oracle
   • SQL Server
   • Sybase ASA
   • Sybase ASE
3. Follow the instructions on the wizard pages to create the selected database connection profile.

   Before creating connection profiles for SQL Server, DB2, and Oracle databases, you must install the appropriate drivers and JAR files.

• Configuring Your Environment to Use a JDBC Driver
  Download the appropriate JDBC driver and configure your environment to connect to Oracle, DB2, and Microsoft SQL Server 2005 and 2008 databases.
• Creating a DB2 Connection Profile
  A connection profile contains the connection property information needed to connect to a DB2 database in your enterprise.
• Creating an Oracle Connection Profile
  A connection profile contains the connection property information needed to connect to a Oracle database in your enterprise.