Defining a .NET Data Provider for Oracle Data Source - SQL Assistant

Teradata SQL Assistant for Microsoft Windows User Guide

Product
SQL Assistant
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2430
lifecycle
previous
Product Category
Teradata Tools and Utilities

Defining a .NET Data Provider for Oracle Data Source

Use the Connection Information dialog box to create, edit, and delete data sources for .NET for Oracle. The dialog box is also used to connect to existing Oracle .NET data sources.

To define an Oracle .NET data source

1 Open Teradata SQL Assistant.

2 Select Oracle.NET from the provider drop down list next to the Connect tool button.

3 Click the Connect icon or select Tools > Connect.

4 Use the Connection Information dialog box to choose a .NET data source.

  • Create a new data source by entering the name, server, and other applicable information.
  • Delete an existing data source by clicking Delete.
  • Use this dialog box to modify existing sources.
  • 5 Use the Advanced tab to make additional changes to a data source. The figure below shows the .NET dialog box. Table 4 describes the options in the .NET dialog box.

     

    Table 4: Description of the Oracle.NET Connection Dialog Box 

    Dialog Box Item

    Description

    Basic tab

    Data Source Name

    Enter the name of the data source or use the drop down menu to choose an existing name.

    Server

    Enter the name of the data source or the IP address.

    Use Integrated Security

    Use your Windows credentials for this connection.

    User Name

    Enter the appropriate user name information.

    Password

    Enter the appropriate password information.

    Advanced tab

    Proxy User

    Enter the Proxy user to connect through.

    Proxy Password

    Enter the password for the Proxy user.

    Connection Timeout

    Enter a time limit in seconds for SQL Assistant to establish a connection to an available system before timing out. The default setting is 20 seconds.

    Show Color Bar

    Select this box to display a narrow bar of color across the top of any Query window that is connected to this data source.

    Use the Color selection control, to the right, to select a color.

    This same color is used to underline the Data Source name in the Database Explorer Tree when you are connected to this data source.