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

Teradata® SQL Assistant for Windows User Guide

Product
Teradata SQL Assistant
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2020-01-03
dita:mapPath
gfk1537201040714.ditamap
dita:ditavalPath
ft:empty
Use the Connection Information dialog to create, edit, and delete data sources for .NET for Oracle. The dialog is also used to connect to existing Oracle .NET data sources.
  1. Open Teradata SQL Assistant.
  2. Select Oracle.NET from the provider list.


  3. Click .
  4. Use the Connection Information dialog to select a .NET data source.
    • Create a new data source by entering the name and 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.
    Field Description
    Basic tab
    Data Source Name Enter the name of the data source or use the drop-down menu to select 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.