We are finally upgrading from DataStage 7.5 to 8 (V8.5), and I'm exploring the Metadata Workbench stuff. And I'm wondering how I can use it to access metadata from Cognos 8.
I spent some time learning MetaStage several years ago, but we decided not to progress with it, and my knowledge has departed me.
Now that I've started looking at Metadata Workbench, I feel quite lost. The tutorial discusses importing sample files via a command line, and doesn't discuss how to do this any other way (assuming it's possible to do it another way).
I fully concede that some training would be in order, but I would have thought that importing some Cognos metadata would have been simple enough to do without training.
Can anyone give me some pointers on how to import Cognos metadata?
This topic has been locked.
4 replies Latest Post - 2011-10-05T12:34:29Z by SystemAdmin
Pinned topic Metadata Workbench question from a total ignoramus.....
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2011-10-05T12:34:29Z at 2011-10-05T12:34:29Z by SystemAdmin
MarcHaber 060001Y53G11 PostsACCEPTED ANSWER
Re: Metadata Workbench question from a total ignoramus.....2011-05-25T09:40:14Z in response to mgibsonThere are several engineering guides available for loading metadata into the IBM InfoSphere Information Server - including Cognos Reports and Database Systems using the Import Export Manager utility. The Workbench can then display and report on such information, including Data Lienage Analysis.
Please contact me at email@example.com.
Re: Metadata Workbench question from a total ignoramus.....2011-05-26T01:35:44Z in response to MarcHaberHi Marc,
Thanks for the info. After I installed the client I saw an icon for 'IBM Import Export Manager', but I thought that was a DataStage Import / Export utility, not a Metadata Import / Export tool.
So I decided to change the name of the desktop icon to 'IBM Metadata Import Export Manager'.
I can now see the Cognos brokers.
As it happens, I'm now getting a Memory error, but i've got our local support guys looking into it.
NONE : JVMDUMP006I Processing dump event "systhrow", detail "java/lang/OutOfMemoryError" - please wait. NONE : JVMDUMP032I JVM requested Snap dump using 'C:\IBM\InformationServer\Clients\MetaBrokersAndBridges\Bridges\bin\Snap.20110525.214344.5360.0001.trc' in response to an event NONE : JVMDUMP010I Snap dump written to C:\IBM\InformationServer\Clients\MetaBrokersAndBridges\Bridges\bin\Snap.20110525.214344.5360.0001.trc NONE : JVMDUMP032I JVM requested Heap dump using 'C:\IBM\InformationServer\Clients\MetaBrokersAndBridges\Bridges\bin\heapdump.20110525.214344.5360.0002.phd' in response to an event NONE : JVMDUMP010I Heap dump written to C:\IBM\InformationServer\Clients\MetaBrokersAndBridges\Bridges\bin\heapdump.20110525.214344.5360.0002.phd NONE : JVMDUMP032I JVM requested Java dump using 'C:\IBM\InformationServer\Clients\MetaBrokersAndBridges\Bridges\bin\javacore.20110525.214344.5360.0003.txt' in response to an event NONE : JVMDUMP010I Java dump written to C:\IBM\InformationServer\Clients\MetaBrokersAndBridges\Bridges\bin\javacore.20110525.214344.5360.0003.txt NONE : JVMDUMP013I Processed dump event "systhrow", detail "java/lang/OutOfMemoryError". FATAL MBCM_F0029 : java.lang.OutOfMemoryError FATAL 4 : [JBDG_F0006] The import bridge failed ERROR MIMB_E0062 : The tool failed with error code ERROR_EXPORT
Thanks for your help.
SystemAdmin 110000D4XK510 Posts