Search found 3045 matches

by vmcburney
Sun Sep 21, 2014 5:14 pm
Forum: General
Topic: IBM InfoSphere Information Server 11.3 Licence
Replies: 4
Views: 4758

All you need is a server license for Information Governance Catalog - this is sold as a Processor Value Unit entitlement - you buy a certain number of PVUs to license processor cores on an IGC server. You only license decisions are: 1) How much processing power do you need and what type of processor...
by vmcburney
Wed Sep 17, 2014 6:27 pm
Forum: General
Topic: Upgrade from 8.1 to 9.1
Replies: 10
Views: 6352

You have the opportunity to upgrade to 11.3 instead of 9.1.2. IIS 11.3 is currently only supported on a DB2 repository but I would expect the Oracle and SQL Server versions to be available within a couple weeks. The effort to go to 9.1.2 or 11.3 is about the same - version 11.3 has a faster installe...
by vmcburney
Wed Sep 17, 2014 6:14 pm
Forum:
Topic: Business Glossary - Users and Groups
Replies: 5
Views: 4059

These are the Business Glossary roles: - Administrator (can do anything). - Steward: can access Development Glossary and create or modify terms. - Reviewer: can access Development Glossary and review drafts. - Approver: can access Development Glossary and approve drafts. - Publisher: can access Deve...
by vmcburney
Tue Sep 16, 2014 10:20 pm
Forum: General
Topic: Using REST based webservices on DataStage 9.1
Replies: 2
Views: 3193

You might be better off in DataStage 11.3 where the XML stage has a GetDocument step that connects via HTTP to a web service to retrieve data. It was added to make it easier to access data via REST/HTTP such as cloud data or Sharepoint data.
by vmcburney
Wed Sep 03, 2014 7:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Information Server 11.3 and Unidata
Replies: 7
Views: 8525

There has been a significant license change that may interest you. DataStage WorkGroup Edition version 8.x and 9.x comes only with DataStage Enterprise Edition and no Server Edition. However DataStage WorkGroup Edition 11.3 comes with DataStage Server Edition. If you want to start using both Server ...
by vmcburney
Wed Sep 03, 2014 7:29 pm
Forum:
Topic: Importing excel in Business Glossary
Replies: 6
Views: 4727

What BI tool are you using? If you have Cognos, SSRS, Business Objects or OBIEE you are better off importing the metadata directly from the BI tool via one of the metadata bridges in the Metadata Asset Manager. This will ensure you get all the BI metadata via the Common Warehouse Model format and it...
by vmcburney
Sun Jul 27, 2014 5:58 pm
Forum: General
Topic: Named License for DS/QS Designer
Replies: 4
Views: 2478

Usually the chargeback on Designer client licenses is trivial - and that the larger cost of DataStage is the engine and the jobs running on it. Version 8.7 and 9.1.2 introduced the idea of the Operations Console and processing queues where you could start to track DataStage engine utilisation in a s...
by vmcburney
Tue Apr 08, 2014 12:17 am
Forum: General
Topic: What are the recommendations for upgrading v8.5 to v9.1?
Replies: 11
Views: 4966

I would jump straight to 9.1.2 with fix packs and skip 8.7. You can do a co-exist upgrade where 8.5 and 9.1 run on the same servers for a period of time so you can regression test the results. Strength here is that you have time to test and your production server does not have a long outage. Drawbac...
by vmcburney
Wed Apr 02, 2014 6:44 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Data Profiling in Aster database
Replies: 1
Views: 3805

I think you would need to download the Aster ODBC drivers and install them on your DataStage server. The drivers are on the Teradata website. You would then connect to Aster via the ODBC Connector. In DataStage 9.1 you could also use the JDBC drivers - though I'm not sure if Information Analyzer 9.1...
by vmcburney
Sun Mar 16, 2014 6:38 pm
Forum: General
Topic: Anyone tried installing DataStage onto Amazon Oracle RDS?
Replies: 2
Views: 2436

Anyone tried installing DataStage onto Amazon Oracle RDS?

Was wondering if you could install Information Server 9.1 onto Amazon AWS and use an Amazon RDS Oracle instance as the XMETA repository? Amazon RDS has an Oracle instance which doesn't require an Oracle DB license - Amazon takes care of that - but I don't know if the DBA or system restrictions will ...
by vmcburney
Sun Mar 16, 2014 6:33 pm
Forum: General
Topic: DataStage and Minecraft (just for fun...)
Replies: 6
Views: 2539

That is very nice, and detailed! I think it needs a few traps to be even more like DataStage.

How much did you have to bribe your son to pretend to be interested in DataStage?
by vmcburney
Sun Mar 02, 2014 6:02 pm
Forum: General
Topic: Sequence job vs unix script to run DataStage jobs
Replies: 6
Views: 11017

When it comes to straight forward scheduling - where your load is a sequence of jobs with clear dependencies - I think you can get away with either. When you add in some complex paths Sequence jobs can become easier or at least more intuitive. When several jobs need to finish before the next job sta...
by vmcburney
Sun Feb 09, 2014 6:51 pm
Forum:
Topic: Update CustomAttributes to NULL via XML in Business Glossary
Replies: 6
Views: 6977

WesL wrote:Vmcburney, I ending up having the best success with a modified version of your suggestion.
Does that mean I won? Woo hoo! Gold Medal!

Thanks for the comprehensive response, it's always great to hear back on what works and it will help other forum members.
by vmcburney
Wed Jan 29, 2014 6:31 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: How to use IA function: Count(field)
Replies: 4
Views: 5997

Call me crazy but wont the count of CUST_SCORE always be 1? Information Analyzer runs a rule that evaluates the data one row at a time. You need to rethink what you want this rule to do. If you are looking for a thresh hold of records where CUST_SCORE = 9999 then you set the rule to be CUST_SCORE = ...
by vmcburney
Wed Jan 29, 2014 6:26 pm
Forum:
Topic: Update CustomAttributes to NULL via XML in Business Glossary
Replies: 6
Views: 6977

So clearly you cannot load a blank or null into an Enumerated custom attribute and it's probably working the way it is supposed to. I can think of a few ways around this: - Split your content into two Glossary XML files, one with the terms that need custom attribute values and one that doesn't. If y...