Connecting to a Teradata database

• Share
  • Share via Facebook
  • Share via Twitter
  • Share via Linkedin

Use the following procedure to connect to your Teradata database.

1. Click the New icon in the Project panel at the top left corner of the window.

   

2. Select Teradata in the Platform drop-down list at the top of the dialog box.

   

3. Select the Standard option in the Mode drop-down list if you would like to connect to the Teradata database in the standard mode.

   

   • Specify the Server name in the appropriate field. You can enter it manually or select it from the drop-down list (if it has been already used).
   • You may opt for Standard Server Authentication or use the LDAP Authentication in the Authentication field.

     

   • Provide the rest of connection information to the Teradata database: Server Port and Username. You can manually enter these values manually or select them from the drop-down lists.
   • Enter the Password to complete the information about Teradata database connection.
   • Press the Test button to verify that you can successfully connect to your Teradata database.
4. Select the ConnectionString option in the Mode drop-down list if you would like to connect to the Teradata database using the connection string.

   

   • Enter the Connection string manually or select it from the drop-down list (if it has been already used).

   • Find the connection string template below. Use it as an example to create a connection string that allows to connect to your Teradata database:

     Data Source=teradata_server;Port Number=1025;User Id=teradata_user;Password=pass;Response Buffer Size=200000;Session Character Set=UTF16;Connection Timeout=300
     

   • Press the Test button to verify that you can successfully connect to your Teradata database.

Didn’t find the answer?

You can report problems, ask questions or share ideas for improvements on our email [email protected].