Password: Set this to the password of the Teradata user.User: Set this to the username of a Teradata user.To connect to Teradata, provide authentication information and specify the database server name. On the next page of the wizard, click the driver properties tab.Įnter values for authentication credentials and other properties required to connect to Teradata.In the Create new connection wizard that results, select the driver.In the Databases menu, click New Connection.Add jdbc:teradata: in the URL Template field.įollow the steps below to add credentials and other required connection properties.This will automatically fill the Class Name field at the top of the form. Click the Find Class button and select the TeradataDriver class from the results.In the create new driver dialog that appears, select the file, located in the lib subfolder of the installation directory.In the Driver Name box, enter a user-friendly name for the driver.Click New to open the Create New Driver form. Open the DBeaver application and, in the Databases menu, select the Driver Manager option.This article shows how to connect to Teradata data with wizards in DBeaver and browse data in the DBeaver GUI.Ĭreate a JDBC Data Source for Teradata Dataįollow the steps below to load the driver JAR in DBeaver. In the following blog posts, we will tell you about other useful DBeaver features.The CData JDBC Driver for Teradata implements JDBC standards that enable third-party tools to interoperate, from wizards in IDEs to business intelligence tools. We hope this tutorial was helpful for you. Also if the password for the SSH tunnel changes, you will need to simply edit your network profile once, without editing each connection individually. This saves you from having to manually enter all the settings when connecting to each database. You will see that the settings in both tabs are filled in automatically. Go to Database -> New Database connection, open the SSH tab, and use the drop-down lists to choose your network profile. Let’s create a new connection using a predefined profile. ![]() You can create a new profile or delete an existing one at any time by clicking on the corresponding button. If you need to connect to a database with different credentials, you can create two different network profiles for this. Click the Apply button to save the specified settings. Set automatic proxy configuration and SOCKS Host, User name, Port and Password. To do that open the Proxy tab and select the Use Proxy checkbox. If you are using a proxy to connect to your databases, you can configure settings for it in your network profile. Click the Apply button to save the specified settings.įor more information about the SSH configuration сlick on the link in the bottom right of the window. To cancel changes, click Restore Changes. By selecting the checkbox Save password, you will avoid having to enter it each time when creating a connection.Ĭlick on Test tunnel configuration to check that everything is working correctly. If you need to set the Jump server settings or advanced settings, you can do so in the same window. Choose one of the authentication methods, set the password, or upload the key file from your computer. Now you can set the Host, Port, and User name. To configure the SSH preferences, select Use SSH tunnel. ![]() Set a profile name and then click OK, or press Enter. Next, click on the Create Profile button. Find the item Profile and click on the pencil button.Ī window with network profile settings will open. Right-click on the database, choose Edit connection and go to the SSH or Proxy tab.In the window that opens, go to DBeaver Settings -> Network profiles. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |