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
   • Generic JDBC
   • 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.

   If you select the Optional Properties tab, and define a property that already exists, the Add button is disabled. That is, Sybase Unwired WorkSpace prevents the MBO developer from defining the same property multiple times.

• 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.