Chapter 12 Working with Web Services

Reverse engineering Web services using an ODBC data source

Steps To reverse engineer Web services (into an existing PDM) using an ODBC data source:

  1. In the menu bar, select Database→Reverse Engineer Database.

    The Database Reverse Engineering dialog box appears.
  2. In the Selection page, select the Using an ODBC data source radio button.


    Note   ODBC data source
    An ODBC data source (previously used) might be predefined, or you can type the name of an existing ODBC data source. In both cases, when you click OK, a database connection dialog box appears, if you need to specify additional connection parameters. Click Connect and the ODBC Reverse Engineering dialog box appears. (Go to step 8)

  3. Click the Connect to an ODBC Data Source tool to display the Connect to an ODBC Data Source dialog box.
  4. Click the Machine data source radio button and select a data source from the dropdown listbox.

    or

    Click the File data source radio button, then the Select a File DSN tool to select a .DSN file from an appropriate directory.
  5. Type a user ID and a password.
  6. Click Connect.

    The selected ODBC data source appears in the Database Reverse Engineering dialog box.
  7. <optional> Check the Reverse using administrator's permissions check box, if you want to select tables reserved to the database administrator.
  8. Click OK.

    The ODBC Reverse Engineering dialog box appears with the user objects. Only tables and triggers are selected by default.
  9. Click the Table tab and select the tables you want to reverse engineer with the Web services.


    In the lower part of the dialog box, select or clear option check boxes specific to tables.
  10. Click the Web Service tab and select the Web services you want to reverse engineer.
  11. Click OK.

    A message in the Output window indicates that the database has been fully reverse engineered and the Merge Models window appears.


    The reverse engineered tables and Web services appear checked in the tree view of the existing PDM (right panel).

    For more information on comparing and merging two models, see chapter Comparing and Merging Models in the General Features Guide .
  12. Click OK.

    The reverse engineered tables and Web services appear in the existing PDM.

 

Copyright (C) 2005. Sybase Inc. All rights reserved.