All Forums Viewpoint
gryback 271 posts Joined 12/08
14 Dec 2009
What Teradata products would you like to see in Viewpoint?

We have begun discussions on the next candidate products for transition to Teradata Viewpoint. As you may already know, complete feature equivalence of Teradata Manager and Teradata Dynamic Workload Manager (TDWM) in Viewpoint will be realized in 1H2010. The next product plans are shaping up to be Teradata Administrator and Teradata Workload Analyzer (TWA).

Interested in your thoughts. Let us know.

Random_Thought 87 posts Joined 06/09
07 Jan 2010

Is viewpoint the right vehicle going forward? I personally am not too thrilled with it. However I am only a user of it, I am not given permission to tinker with the configuration.

The issues I find are that the interface is not intuitive, it uses a thid party database not Teradata, so the information is not readily accessible for analysis outside the tool. Thus I have to still query the TD base tables PDCR etc to get the information I need.

I see other DBAs and they still don't use it, their first port of call are the old tools rather than Viewpoint.

I would not stop development on the Traditional tools, viewpoint need time to develop and evolve alongside the existing toolset

random

gryback 271 posts Joined 12/08
07 Jan 2010

I appreciate your feedback but I'm a bit surprised as this is not in line with the majority of customer feedback I receive on Viewpoint. The majority of feedback is very positive on it being a very intuitive, highly configurable, easy to use solution. Try the on-line help, it is very detailed and should guide you through any areas in question.

The choice of the data collection database really has nothing to do with accessibility. There are libraries within the PDK that provide access to all the data if necessary.

If you like, please contact me directly as I'd like to understand the rationale of still using the older tools. Again, this is not in line with the general consensus that state "we use Viewpoint for whatever we can and only use the prior tools where we have to".

Also we truly believe Viewpoint is absolutely the right vehicle for all this and we are moving forward on this belief very aggressively. There will be overlaps in releases where Viewpoint and the older tools will both work to allow for transition. However the older products will be discontinued as it doesn't make good business sense to invest in two solutions providing the same functionality. For example, Teradata Manager and TDWM 13.0 versions are the last releases of those products.

I would like to understand through this forum discussion, what information do you need when you mention having to query TD base tables and PDCR? Maybe this can drive valuable additions to Viewpoint. Let me know and again thanks for the feedback.

gryback 271 posts Joined 12/08
12 Jan 2010

A bit surprised at the lack of response here.

So we are going to focus on Teradata Workload Analyzer to complete our TASM products transition and then initiate work on portlets for Teradata Adminstrator and improved Performance Management. The Teradata Administrator portlets should be complementary to our Agile Analytics offering. Still open to feedback if you want to contribute.

Pat GoHabsGo 6 posts Joined 01/10
12 Jan 2010

My client is asking if Viewpoint is available on 2580 appliance? If not can a 5600 viewpoint server also cover a 2580 appliance?

gryback 271 posts Joined 12/08
12 Jan 2010

Teradata Viewpoint can manage a Teradata system running on the 2580 appliance. For this, Viewpoint could be installed in the 2580 or 5600 rack as long as there is room. Note that all systems need to be properly licensed.

Random_Thought 87 posts Joined 06/09
13 Jan 2010

gryback,

Don't mean to be critical or cause offence. In our fairly recent implementation, we had several DBAs onsite, a significant number of Teradata consultants / impelmentation guys on site, and viewpoint implemented. When I noticed issues with the system, via viewpoint, and approached any of the above guys with those issues they did not use viewpoint to investigate, they went straight to the old tools.

Obviously being a new Teradata shop we have had some training, but the Teradata people leading the course did not know much about viewpoint. I think the concensus was that because it needed extra hardware to run, they did not have that. The older tools were always available.

I need to use Analytics tools to extract data directly from PDRC, and resusage tables to graph and trend the usage of the system. I need to be able to drill down and report on performance and then transfer those graphs with data to Office applications etc.

Perhaps we just need to see other viewpoint implementations.

Perhaps other posters here can help persuade me?

random

gryback 271 posts Joined 12/08
13 Jan 2010

No offense taken. As you mention, there is a learning curve to any new tools especially one replacing a mainstay tool like Teradata Manager. What I have seen is that customers transition to Viewpoint where both tools are utilized over time.

So everyone understands, the PDCR is actually a Teradata Professional Services offer, not an R&D standard offering. So if someone is wondering why they don't have it, this is the reason. We have had in depth discussions with PS on the PDCR offering and when I mention "Performance Management" as a next candidate item, that is directly related to a portion of what PDCR provides today. As you probably already know, PDCR has lots of reports and creates their own data tables so it is not a trivial exercise to integrate that.

Again I appreciate the feedback and am open to an offline discussion in improving Viewpoint at your site if you so choose. And I too would like to see other postings on Viewpoint. Maybe this even warrants a new thread that has a more descriptive subject line.

MikeDempsey 94 posts Joined 10/06
27 Jan 2010

If you are wanting to access the database used to store Viewpoint data there are many query tools (including SQL Assistant) that can be used to do that. While SQL Assistant 12 was never tested against a PostgreSQL database, version 13 was, and it includes the required language file and SQL example files used by the Query Builder.

gryback 271 posts Joined 12/08
28 Jan 2010

We actually prefer access to the Viewpoint DCS through the PDK libraries versus direct SQL access.

aengusrooney 2 posts Joined 04/10
10 Apr 2010

Hi Gary,

When you say "We have had in depth discussions with PS on the PDCR offering and when I mention "Performance Management" as a next candidate item, that is directly related to a portion of what PDCR provides today" - does this mean PDCR or aspects of PDCR will be available in Viewpoint, and if so, what can we expect, and when?

aengusrooney 2 posts Joined 04/10
10 Apr 2010

(Happy to be pointed forward to any existing articles on the developments)

AbeK 24 posts Joined 08/09
14 Apr 2010

Currently there is a limitation within Teradata Manager when we put a user in the exception list and this list is 'Global' and any/all alert for this exception list is ignored.
Would ViewPoint solve this issue by being more granular on the exception list ?

gryback 271 posts Joined 12/08
14 Apr 2010

PDCR type reporting is certainly a candidate for future Viewpoint releases. However as there are dozens of reports, don't expect a complete replacement anytime soon. What we are considering is implementing some of the most commonly used reports. There are two aspects to this implementation, first the report itself and secondly the data collection. So in short, we continue discussions and planning but I'm not ready to declare any content expectations or time frames. It is just too early to do that currently.

gryback 271 posts Joined 12/08
14 Apr 2010

Regarding the limitation within Teradata Manager, can you provide more detail here? What exception list? Are you talking about TASM exceptions and resulting alerts? Sorry need more context for an appropriate response.

hd185015 8 posts Joined 10/09
19 Jun 2010

The current viewpoint release doesn't have a usage and current user logon report, is there a plan for those kind of informaiton to be available.

gryback 271 posts Joined 12/08
25 Jun 2010

Yes, that is on the roadmap but no clear delivery date currently.

mbarrow 1 post Joined 09/10
14 Sep 2010

Are there any plans to include the scheduling aspects of Teradata Manager into Viewpoint? I was under the impression that 13.03 would provide a complete functionality replacement for TMGR, but cannot see any way to schedule a processes (for example PDCR scripts that are generally implemented to run from TMGR).

gryback 271 posts Joined 12/08
15 Sep 2010

Teradata Viewpoint 13.03 is the feature equivalence release for Teradata Manager but there are documented exceptions. One of which is we made a business decision not to migrate the Teradata Manager Schedulers as any modern OS already offers scheduling capabilities (cron, at, etc). This was documented in the Viewpoint 13.03 release article at the bottom under the Teradata Manager considerations section.

http://developer.teradata.com/viewpoint/articles/teradata-viewpoint-13-03-released

Specific to PDCR, Professional Services approved this business decision have have a plan to transition PDCR scheduled tasks to OS based scheduling. Please contact your PDCR PS representative on that specific case.

anils345 2 posts Joined 09/12
21 Sep 2012

Hi Gary Ryback,
I want to know about DBQL and PDCR? Can you Plz explain DBQL and PDCR with examples?
 
Thanks&Regards,
Anil kumar

gryback 271 posts Joined 12/08
21 Sep 2012

DBQL is the Database Query Log, essentially the Teradata Database activity logging that provides detailed logging for system activity.
PDCR is a performance and capacity reporting offering from Teradata Professional Services. This offering creates summary tables of DBQL that then allow custom performance and capacity planning reports to be generated. 
 

geethareddy 37 posts Joined 10/11
03 Jun 2014

Gary,

I was wondering which version of VP can support the complete set of features of Workload Analyzer. Can you please confirm.

Thanks,
Geeta

gryback 271 posts Joined 12/08
04 Jun 2014

Just for everyone's information, Teradata Workload Analyzer (TWA) provides the ability to organize, sort, and analyze DBQL data to assist in creating Workload Definitions (WDs) in Teradata workload management strategies. To Geeta's question specifically, we considered TWA creation in a Viewpoint portlet but because of the nature of DBQL analysis, we decided it was better to position in a fat client type solution. So for now, TWA remains a Windows based install client product. We do have a roadmap consideration for migrating this into Teradata Studio at some point in the future. 

geethareddy 37 posts Joined 10/11
05 Jun 2014

Good to know this. Thank You Gary.

 

Thanks,
Geeta

piyush.lohana 4 posts Joined 09/14
16 Mar 2015

Hi,
Do we have any PDCR portlets in TD 15 viewpoint? I would appreciate if you can provide me the path to its documentaion as well.
Thanks,
Piyush

Piyush

gryback 271 posts Joined 12/08
22 Mar 2015

You need to contact your PS representative for the PDCR portlets as those are part of the PS PDCR offering.

gryback 271 posts Joined 12/08
26 Mar 2015

Some level of PDCR type reporting is coming with Viewpoint 15.10 and the new Query Log and Application Queries portlets. These portlets do reporting out of PDCR and DBQL tables. Stay tuned, you will be hearing more about Viewpoint 15.10 in April.

teradatauser2 236 posts Joined 04/12
29 Mar 2015

Hi,

Can we have a portal in VP to do the L1 activities like - password reset/unlock, getting locking information for an ID, getting user information(from dbc.users), granting roles , roles analysis etc. Currently, we have to login to administrator tool/write your own queries in sql assist or we have our own unix scripts for these activities. Currently, few installations have some kind of inhouse tool developed in any UI languages to accomplish this. 

If we have such options, we might not need to login to admin for such basic activities and viewpoint will be one stop shop.

Please let me know if this doesn't make any sense at all :)

--Samir 

gryback 271 posts Joined 12/08
08 Apr 2015

We position Viewpoint as a monitoring solution and as a portal based solution allowing broad access, thus the self-service type portlets. Administrative aspects are positioned more around our Teradata Studio product offering. 

teradatauser2 236 posts Joined 04/12
11 Apr 2015

Hi Gary,
Do you mean that these admin aspects covered as  part of the TD studio and cab have customizations? Also, i have read that you can create your own portlet in viewpoint, so what is that option for ?
Is Td studio a separate paid product or can we download it from TAYS and use it if we already have TD 14 ?
Thanks !
Samir

You must sign in to leave a comment.