- Open Teradata SQL Assistant.
Select Oracle.NET from the provider list.
- Click .
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.
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.
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.