Toad allows you to create a full-featured, native Teradata connection. This type of connection provides complete Query Builder, Query Editor, and Database Explorer functionality.
Notes:
To install the Teradata data provider
Download and install the Teradata .NET Data Provider from the Teradata Web site. Use the version supported by your database version.
To create a Teradata connection
Enter the connection information in the Create New Connection dialog. Review the following for additional information:
Login | |
Server name |
Enter the name of the server hosting the database to which you want to connect. |
Use Single Sign On |
Select if the user is using a single sign-on authentication system. |
Password |
Enter the password to use when connecting. Tip: After connecting, you can set a master password to further secure your connection in Tools | Options| Environment | Security. |
Session mode |
Displays the session mode, which is always Teradata in a Toad Teradata connection. |
Default database |
(Optional) Enter a default Teradata database for the connection. |
Category |
(Optional) Select an existing category or create a new one. |
Advanced |
|
Mechanism |
(Optional) Select an authentication mechanism from the list. |
Parameter |
(Optional) Enter the parameters required by the selected authentication mechanism. See your system administrator for these values. |
Account string |
(Optional) Enter a new account string. |
Character set |
Select a character set. Note: When querying or viewing data in a column defined with GRAPHIC or CHARACTER SET GRAPHIC data type, you must specify a Character set of UTF-16 for the session. |
Use data encryption |
Select if using data encryption. |
Response buffer size |
Specify a Response Buffer Size (in bytes). This allows you to govern the number of rows returned in a single response. To increase the number of rows per response, increase the response buffer size. This strategy might help to improve performance with larger data sets. The default value in Toad is set to the maximum, 1040000 bytes. |
Click Connect to connect immediately while saving the connection information. Optionally, click Save to save the connection without connecting.
Tip: Connections are stored in the connections.xml file and can be found by clicking the Application Data Directory link in Help | About.
To install a Teradata ODBC driver
Download and install a Teradata ODBC driver from the Teradata Web site. For a list of supported Teradata ODBC drivers, please see the Release Notes for your version of Toad Data Studio.
Notes:
© ALL RIGHTS RESERVED. Feedback 利用規約 プライバシー Cookie Preference Center