English

How To: Add XY data from an RDBMS table as points to a view

Summary

You can create a point event theme from XY data stored in an RDBMS table. This example examines how to accomplish this with Oracle data.

Procedure

  1. Create a Data Source Name (DSN) for the Oracle database.
    A. Click Start > Settings > Control Panel.
    B. Double-click the ODBC32 Administrator icon.
    C. Select the User DSN tab, then click the Add button.
    D. Select the Oracle ODBC Driver and click the Finish button.
    E. Type in a name for the DSN in the Data Source Name field, for example 'Addresses'.
    F. Enter the Service Name.
    G. Click OK.
    H. Click OK to close the ODBC Administrator dialog box.
  2. Add the Oracle table to ArcView.
    A. Start ArcView.
    B. Select SQL Connect from the Project menu.
    C. Select the Data Source Name (DSN) from the Connections scrolling list.
    Note:
    You may need to restart ArcView before new DSNs appear in this SQL Connect dialog box.

    D. Click Connect. Type in User Name and Password if necessary.
    E. Double-click the table in the Tables list.
    F. Double-click the desired columns From the Columns list.
    G. Enter a name for the new ArcView table in the Output table field.
    H. Click Query.
  3. Create an event theme from the newly added table.
    A. Open a view.
    B. Select Add Event Theme from the View menu.
    C. Specify a table, an X field, and a Y field.
    D. Click OK.