In order to use the Oracle Extension, you must first create an alias in the Borland Database Engine (BDE) for your source
data store to communicate with the Oracle client installed on your machine. A BDE alias is not required for your target data
store.
Note:
- For your source Oracle data store specified for either the Distributed Loader or Distributed Exporter, you must create a
BDE alias. We recommend that the associated BDE alias match the Oracle TNS service name specified in your
tnsnames.ora file.
- For your target Oracle data store specified in the Distributed Exporter, make sure that the target name is the Oracle TNS
service name specified in your
tnsnames.ora file located on the machine where you intend to mask/subset data.
- If you are using Data Express on Windows Vista and User Access Control is enabled, you must run the BDE Administrator utility
as
Administrator.
To create an Oracle alias:
- Open BDE Administrator (from the
Control Panel). Click the
Configuration tab, and then select
ORACLE from the
Native Drivers list as shown in
Figure A-1:
- In the
Definition of ORACLE pane, click in the second column for
DLL32 to display a list of DLLs. Select
SQLORA8.DLL, and click
Object >
Apply as shown in
Figure A-2:
- 3. In the
Definition of ORACLE pane, click in the second column for
VENDOR INIT, and enter
OCI.DLL as the Vendor DLL file name.
- 4. In the
Drivers and System pane, click the
Databases tab.
- 5. Create a new Oracle database alias (right-click, select
New, select the Database Driver Name
ORACLE, and then
OK) and rename the alias as appropriate.
- 6. In the
Definition of
AliasName
pane, click in the second column for
SERVER NAME, and enter your Oracle TNS.