Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Connecting to Teradata Database With LDAP Using Oracle SQL Developer

DZone's Guide to

Connecting to Teradata Database With LDAP Using Oracle SQL Developer

With Oracle SQL Developer, it's possible to connect to many databases with JDBC driver. Learn how to connect to a Teradata database configured with LDAP Authentication.

· Database Zone
Free Resource

Traditional relational databases weren’t designed for today’s customers. Learn about the world’s first NoSQL Engagement Database purpose-built for the new era of customer experience.

In this article, I will describe how to connect to the Teradata database via LDAP. We will do this with Oracle SQL Developer.

With Oracle SQL Developer, it is possible to connect to many databases with JDBC driver, not just an Oracle database. Some of these are DB2, Teradata, Access, MSSQL, and MySQL. In this article, I will describe how to connect to a Teradata database configured with LDAP Authentication.

I want to connect to Teradata database version 15. The version of Oracle SQL Developer is 4.1.5.

First, I need a Teradata JDBC driver to connect to Teradata from Oracle SQL Developer. You can download this driver by following the link.

After downloading the ZIP/TAR file containing the driver, we need to extract it to the appropriate location on our computer. Then, we need to show the files tdgssconfig.jar and terajdbc4.jar, which will come out of this file in Oracle SQL Developer.

We extract the files from Oracle SQL Developer by clicking on the Add Entry button in the window accessed by following the corresponding path (Tools > Preferences > Database > Third-Party JDBC Drivers). Then click the OK button to close the screen.

jar_ext

Now that we have the relevant drivers displayed, let's open the new connection setup screen through Oracle SQL Developer.

teradata

When we open the connection screen, we see that the Teradata connection tab comes right next to the Oracle option — proof that your JAR files are correctly defined. Now, we have the last step we need to make to connect. In the last step, we will add the LOGMECH parameter to our connection to determine how to provide our connection via LDAP. Since we do not have this option on the connection screen by default, we will click the Add button to add this parameter, and when we press the OK button after selecting LOGMECH parameter in the popup window, we will see that this parameter is added as a selection button on the connection setup screen. Then, we will select LDAP with this selection button and we will complete the process.

teradatacon teradatacon2

Now we can connect to the Teradata database using our LDAP information and database connection string.


Learn how the world’s first NoSQL Engagement Database delivers unparalleled performance at any scale for customer experience innovation that never ends.

Topics:
oracle ,teradata ,database ,tutorial ,sql ,ldap

Opinions expressed by DZone contributors are their own.

THE DZONE NEWSLETTER

Dev Resources & Solutions Straight to Your Inbox

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.

X

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}