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.
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.
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. |