Connecting to a Database Using a JDBC Driver

Use the appropriate JDBC driver to create a connection profile to an Oracle, DB2 or SQL Server database.

1. To create a connection profile to the server, right-click Databases in Enterprise Explorer and select New.
2. Select Generic JDBC Connection and click Next.
3. Enter the connection name and click Next.
4. Click the ellipsis (...) and expand the driver type you are creating, for example, Oracle.
5. (Oracle) If you selected Oracle, click Add and select Oracle Thin Driver.
6. Click Edit.
7. Configure the driver and click OK.
8. Enter the URL, user name, and password and click Finish.
   Note: An Oracle, SQL Server, or DB2 database that is connected with a JDBC driver currently has the following limits in its functionality:
   

   • Dragging and dropping a table onto the mobile application diagram results in the warning: This operation may not generate valid attributes or executable operations for non-Sybase databases. Do you want to continue?
   • Clicking the Validate Syntax button in the data source wizard results in an error and the SQL statement does not validate.
   • Auto-generated SQL is wrongly prefixed with a database name, which must manually be removed for the database qualification to make the SQL work.