Teradata Developer Tools for Visual Studio 15.11

Tools
Tools covers the tools and utilities you use to work with Teradata and its supporting ecosystem. You'll find information on everything from the Teradata Eclipse plug-in to load/extract tools.
Teradata Employee

Teradata Developer Tools for Visual Studio 15.11

We are pleased to announce general availability of the Teradata Developer Tools for Visual Studio 15.11.

This product may be integrated with Visual Studio 2010, 2012, 2013 or 2015 and can be downloaded from the following locations:

    English version

    Japanese version

Alternatively, you can use the Extensions and Updates item on the Tools menu in Visual Studio to download it directly from within Visual Studio.

If you are not familiar with this tool you may wish to read the following articles first:

New Teradata Developer Tools for Visual Studio

Teradata Developer Tools for Visual Studio 15.01

Teradata Developer Tools for Visual Studio 15.10

Overview

The main feature of this release of the Teradata Developer Tools for Visual Studio is the addition of a New Table Designer.

The New Table Designer

A New Table designer is opened using the Add New Table command on the context menu of either a Database node or a Tables Collection node of the Teradata Explorer. This designer window contains 3 sections as shown below:

  • The Columns Grid allows you to enter the base information for each column, and to create constraints based on the selected columns.
  • The Constraint Tree allows you to see the constraints that you have defined, add security constraints, or normalize a derived period.
  • The SQL Text window displays the DDL that has been generated from your input.

As with the Query/Result panes of the Query Editor you may switch the positions of the SQL Text and Designer areas, or Maximize either of these.

The Table, Columns, and Constraints can be further defined using the Properties window.

The following screen shot shows some of the properties of the Table itself:

When the designer is first displayed the Properties window will display the table properties and focus will be on the Table Name property.

To display the properties of a column click on the row in the Columns Grid that defines that column.

To display the properties of a constraint click on the node within the Constraint Tree that displays that constraint.

To re-display the properties of the table itself click on the column headers or white space area of the Columns Grid, or within the white space area of the Constraint Tree.

The available properties will vary depending on the Teradata Database release that you are connected to, and on the property values you have previously set. For example, if you set the Temporary property for the table then the Is Queue, Block Compression and Journaling properties will not be available.

Most constraints are added by selecting the Column rows that define the constraint and then using the context menus:

  • Add Primary Key
  • Add Unique Constraint
  • Add Check Constraint
  • Add Foreign Key
  • Add Index
  • Add Derived Period
  • Normalize Column

After completing your definition, you can create the table using the standard Execute command, or you can script it to a Teradata Query editor, or file, using one of the Script commands.

If the table is successfully created it will automatically be added to the Tables node of that database in the Teradata Explorer.

The Teradata Explorer

A new Add Database command has been added to the context menu for Data Source nodes. This command will only be displayed when you are connected to the data source. Clicking this command will display a dialog that allows you to enter the name of an existing database that you wish to add to the tree. This allows you to add a User while using the option to load only databases, or to add a newly created Database without refreshing the entire data source.

Fixes and minor enhancements to the previous release

  • Added support for Visual Studio 2015
  • F2 can now be used as a shortcut for the Rename command.
  • Removed the limitation that only allowed a single Create Trigger statement as the last statement in a Query.
  • Display the context menu at the selected node in the Teradata Explorer when it is requested through the keyboard.
  • Corrected the content of the intellisense list that is displayed after Create, Drop, Show.
  • Avoid an unusable Connection dialog when you try to connect to a Data Source that no longer exists.

Conclusion

This tool will allow you to develop the SQL required for your applications without leaving the Visual Studio environment. However it should be noted that the tool is not a replacement for SQL Assistant or Teradata Studio. These other tools still have more/different functionality than the Teradata Developer Tools.

5 REPLIES
Teradata Employee

Re: Teradata Developer Tools for Visual Studio 15.11

Hi,

Can I integrate it with the free Visual Studio 2015 Community Edition https://www.visualstudio.com/products/visual-studio-community-vs ?

Thanks,

Joseph

Teradata Employee

Re: Teradata Developer Tools for Visual Studio 15.11

Hi,

Although this is not part of the main topic, may I ask if we allowed to install Visual Studio Express and/or Visual Studio Community Editions in our Teradata laptop?

Regards,

Joseph

Teradata Employee

Re: Teradata Developer Tools for Visual Studio 15.11

I have not tested the tools with the community edition but I did allow it in the installation control file so you should at least be able to install it.

I think CE contains the full application, but without the compilers and extra tools, so I think it should work.

I don't know Teradata's policy on that but since it does not require purchase of a license I don't see why they would object.

N/A

Re: Teradata Developer Tools for Visual Studio 15.11

Hi Mike,

I'm really excited to use these tools. I've downloaded them and installed them, but every time I try to launch the Teradata Explorer window after connecting, it crashes VS. Any ideas on what might be happening?

Here are my VS settings:

Microsoft Visual Studio 2013 Shell (Integrated)

Version 12.0.21005.1 REL

Microsoft .NET Framework

Version 4.5.51209

Installed Version: IDE Standard

.NET Data Provider for Teradata   14.11.0.1

Teradata Integration Package for Visual Studio Supporting Data Connections in Server Explorer

Application Insights Tools for Visual Studio Package   1.0

Application Insights Tools for Visual Studio

ASP.NET and Web Tools   12.4.51016.0

Microsoft Web Developer Tools contains the following components:

Support for creating and opening ASP.NET web projects

Browser Link: A communication channel between Visual Studio and browsers

Editor extensions for HTML, CSS, and JavaScript

Page Inspector: Inspection tool for ASP.NET web projects

Scaffolding: A framework for building and running code generators

Server Explorer extensions for Microsoft Azure Websites

Web publishing: Extensions for publishing ASP.NET web projects to hosting providers, on-premises servers, or Microsoft Azure

NuGet Package Manager   2.8.50926.663

NuGet Package Manager in Visual Studio. For more information about NuGet, visit http://docs.nuget.org/.

Oracle Developer Tools for Visual Studio   12.1.0.2.0

Oracle Developer Tools for Visual Studio Copyright (c) 2005, 2014

SQL Server Analysis Services   

Microsoft SQL Server Analysis Services Designer 

Version 12.0.2000.8

SQL Server Data Tools   12.0.50730.0

Microsoft SQL Server Data Tools

SQL Server Integration Services   

Microsoft SQL Server Integration Services Designer

Version 12.0.2430.0

SQL Server Reporting Services   

Microsoft SQL Server Reporting Services Designers 

Version 12.0.2430.0

Teradata Query Tool   1.0

Compose SQL queries for the Teradata Database and execute those queries using the .NET Data Provider for Teradata

Workflow Manager Tools 1.0   1.0

This package contains the necessary Visual Studio integration components for Workflow Manager.

Thanks,

Darren
Teradata Employee

Re: Teradata Developer Tools for Visual Studio 15.11

I have never used either of the 'shell' components - I only use the full product - so I may be wrong here.

My understanding is that the integrated shell runtime allows use of extensions in the 'isolated' shell. (The download site says that 'isolated' is required for use of the 'integrated' runtime)

The only version of the isolated shell I can find is 2010 (Version 10).

You say you are using version 12 (VS2013) of the integrated shell but no mention of the isolated shell so maybe I don't understand what is required. (and there doesn't seem to be a version 12 of isolated.)

I have only tested the extension with VS2010, VS2012, VS2013 and VS2015. (Professional and Enterprise versions)

However everything I have read says it will also work with the [free] VS2015 community edition.

Having said all that, your issue may be the version of .Net Data Provider for Teradata that you have installed. You say 14.11.0.1 but this product requires 15.11. (unless that was a typo in your comment)

The vsix package includes version 15.11 of the provider but if you installed version 14.11 with its VS Integration feature that might have caused things to get confused.