Teradata database

This message was edited 1 time. Last update was at 2007-10-05 14:50:20

Is it possible to connect to a teradata database using power architect?

This message was edited 1 time. Last update was at 2007-10-05 16:11:53

Hi tsnider,

I moved this posting to the Power*Architect forum, as it is a much more appropriate place for it.

Yes, you should be able to connect to a Teradata database by adding a Teradata connection type using our JDBC Driver settings editor.

Here's a step-by-step description:
1. Select 'User Preferences...' in the File Menu. A User Preferences window should pop up

2. Click on the 'JDBC Driver' tab. Then in in the lower left corner of the window, click on the '+' button

3. This should have created a new database type with blank fields. Fill out the fields as necessary
- Name: Call it whatever you'd like, ex. Teradata
- Driver Class: the full class name of the driver. Should be com.ncr.teradata.TeraDriver
- The Connection String Template should be something like:

- Options Editor Preview / Sample Options: You can leave these alone for now

4. Now click the 'Add JAR' button and find your JDBC driver JAR file
I've attached a screenshot of what this should look like in the end.

5. Click 'OK'. Now you've set up your Teradata DB type. You can then set up your database connection as usual. (via 'Add Source Connection')

Note that in the latest code, there is a bug that causes the name of the latest Database type that was added to the list to appear squished or not at all. We hope to fix this, but your database type should still be created.

Hope this helps! Let me know if you run into any problems.

I know this post is very old but I am a brand new user of Power Architect and am trying to use it to connect to Teradata. I set up the Teradata connection type but I quickly got lost when I tried to create a database connection. I'm wondering whether I actually need to the Gateway Server Name and Port - when we set up ODBC data sources, we usually only specific a TDP name, which, I believe, should get plugged into the DBServerName.

Any hints on how this might work?