Importing an Oracle Database Table
By importing Oracle tables, users can access and manipulate Oracle data with all of the data that CONNX can access through a single driver. Some of the possible implementations for this functionality include data migration, ad hoc reporting, data warehousing, application development, and Y2K-compliance modification and confirmation.
Additional core features of Oracle access through CONNX include invocation of stored procedures, support for SQL passthrough, and Rdb list cursor support, which allows storage of up to 2 gigabytes of data in a single field.
Oracle requires specific logon information during the initial import procedures to further ensure access security. The Import CDD dialog box has a separate tab in which to specify server name, user name, and password, as required.
1. Click the Import button in the CONNX Data Dictionary Manager window.
2. Select Oracle database from the Import Type list box.
3. Type the SQLNet database name in the Enter the SQLNet connect name text box.
Select the Include System Tables check box if you want to import system table definitions into the CDD.
Select the Get Statistics check box if you want to identify the table sizes.
4. Type a user name, and password under Logon Information.
a. UserName - OpenVMS user name used to log in to the account where the database resides.
b. Password - OpenVMS password used to log in to the account where the database resides.
5. Click the OK button.
The CONNX Import Table Selection dialog box appears with a list of available table names.
6. Click the Add or Add All button to move the tables to the Select Tables for Import pane.
7. Click the OK button to import the selected tables into CONNX.
The Oracle database tables are added to the list of accessible objects in the CONNX Data Dictionary Manager window.