User`s guide

2 Getting Started with Database Toolbox
2-46
on a machine. Any data sources a user defines under User DSN are seen only by that
specific user. Conversely, a System DSN is not specific to the user on a machine. Any
data sources a user defines under System DSN on a machine can be seen by any user
who logs into that machine. Your ability to set up a User DSN or System DSN might
depend on the database and ODBC driver you are using. For details, contact your
database administrator or your database ODBC driver documentation.
3
A list of installed ODBC drivers appears in the Create New Data Source dialog box.
Select the ODBC driver Oracle in OraClient11g_home1. Your ODBC driver
might have a different name. Click Finish.
4
In the Oracle ODBC Driver Configuration dialog box, enter an appropriate name for
your data source in the Data Source Name field. You use this name to establish
a connection to your database. Here, enter ORA as the data source name. Enter a
description for this data source, such as Oracle database, in the Description
field. Enter your database name in the TNS Service Name field.
5
To establish the data source without Windows authentication, enter your user name
in the User ID field. Or, to establish the data source with Windows authentication,
leave this field blank. Leave Application, Oracle, Workarounds, and SQLServer
Migration tabs with default settings.