If you are unable to create a new account, please email support@bspsoftware.com

 

Connect to Datamanager from Command Prompt

Started by rakesh.java, 13 Aug 2014 06:05:56 AM

Previous topic - Next topic

rakesh.java

Hi,

I'm new to Cognos DataManager, Can you guide how to connect Datamanager from command prompt to run the commands which are available in Datamanager User guide.

Regards,
Rakesh.M

Gary

Easiest way to do so is :

1. Right Click on any of the build in DM catalog.
2. Click on Execute and "Execute" window will open.
3. Copy the content in command line. This mainly for the DOS execution

For Linux/Unix executions the parameter values can be modified accordingly. But the syntax remains the same.

Gary
Gary

:)*Throw Parties Not Grenades*:)

rakesh.java

Thanks for your support. And i'm trying to run the commands provided in DataManager user guide like catexp,catimp and so on..but i'm unable to run the commands from command prompt,Can you please guide me on that.

Regards,
Rakesh.M

Gary

For catalog import use catrestore command as below:

catrestore "<database type>" user/pwd@<SID> <direcory of the catalog>/<catalog name>

Gary
Gary

:)*Throw Parties Not Grenades*:)

MFGF

Quote from: rakesh.java on 13 Aug 2014 07:55:25 AM
Thanks for your support. And i'm trying to run the commands provided in DataManager user guide like catexp,catimp and so on..but i'm unable to run the commands from command prompt,Can you please guide me on that.

Regards,
Rakesh.M

You might also need to specify the path of the executable if it's not already in your path environment?

eg C:\"Program Files"\IBM\cognos\c10_64\bin64\catexp <your arguments go here>

Or alternatively navigate to the bin64 folder first.

Cheers!

MF.
Meep!

rakesh.java

Hi,

I tried with the command as it is which is under command line option,im getting error like rundsjob.exe is not a valid win32 application.


Regards,
Rakesh

MFGF

Quote from: rakesh.java on 14 Aug 2014 07:16:40 AM
Hi,

I tried with the command as it is which is under command line option,im getting error like rundsjob.exe is not a valid win32 application.


Regards,
Rakesh

What version of Windows are you running? Is it 32 bit or 64 bit?

What version of Data Manager have you installed? Is it 32 bit or 64 bit?

MF.
Meep!

rakesh.java

Hi,

can you guide me how to create the package which contains main jobstream and corresponding child job streams and child fact builds using catexp command from command prompt.

I need similar functionality creating the package from Datamanager UI.Here if i select one jobstream automatically it is selecting corresponding childs.

Note: I created a package which contains one jobstream using catexp command which is working fine.



Regards,
Rakesh.

MFGF

Quote from: rakesh.java on 20 Aug 2014 10:05:35 AM
Hi,

can you guide me how to create the package which contains main jobstream and corresponding child job streams and child fact builds using catexp command from command prompt.

I need similar functionality creating the package from Datamanager UI.Here if i select one jobstream automatically it is selecting corresponding childs.

Note: I created a package which contains one jobstream using catexp command which is working fine.



Regards,
Rakesh.

Hi,

When you export packages from the Data Manager Designer, all the dependencies are calculated for you, and everything you need to support the object you are exporting is included automatically. When using the command line, it is an entirely manual process. Sadly, you need to figure out what builds, connections, collections etc are included, and export these using CATEXP. There is no easy answer - you just need to be very diligent and thorough, or else you end up missing a vital component.

Is there a reason you are not using the Data Manager Designer to do this?

Cheers!

MF.
Meep!

Gary

I agree with the reply from MF.

In order to deliver an individual component like in case of DataStage jobs, its not easier task in Data Manager rather more confusing and error prone. That in case od Dimension build to deliver using CATEXP command can be a nightmare for a beginner.

In case the Windows export is not feasible in the project, i would suggest to restore the whole ETL catalog in case of any release. That the most easiest stuff. Its better to keep the latest code  in the controlled env and then import the package manually via windows env and then deliver the whole ETL catalog using catexp command in prod env.

Gary
Gary

:)*Throw Parties Not Grenades*:)

rakesh.java

Hi,

"c:\cognos\bin\catexp.exe"  "ODBC" "userId/UUID@dsn" "JobStream.pkg" J "JobStream"
This command is working fine,here i'm exporting only one jobstream.But i need to export either multiple jobstreams or combination of jobstream and factbuild from command prompt at a time using catexp command.Can you please suggest is there any way to do like this.

Note:Aim is to export whatever changes made to catalog only those things i need to export and deploy from command prompt at a time.


Regards,
Rakesh

MFGF

Quote from: rakesh.java on 22 Aug 2014 08:46:14 AM
Hi,

"c:\cognos\bin\catexp.exe"  "ODBC" "userId/UUID@dsn" "JobStream.pkg" J "JobStream"
This command is working fine,here i'm exporting only one jobstream.But i need to export either multiple jobstreams or combination of jobstream and factbuild from command prompt at a time using catexp command.Can you please suggest is there any way to do like this.

Note:Aim is to export whatever changes made to catalog only those things i need to export and deploy from command prompt at a time.


Regards,
Rakesh

Hi,

As I mentioned before, you need to figure out manually what dependencies exist for objects you export using CATEXP. If a jobstream contains multiple builds, you will need separate exports for each build into separate definition files - a file with more than one fact build or dimension build in it will not work when you come to import using CATIMP. If you have multiple jobstreams to export, you could either use a separate definition file for each, or you could use the -a switch to append to an existing definition file.

Cheers!

MF.
Meep!

rakesh.java

Hi,

Can you guide me how can i customize the cognos login page which is existing.

Regards,
Rakesh.M

MFGF

Quote from: rakesh.java on 25 Aug 2014 05:46:32 AM
Hi,

Can you guide me how can i customize the cognos login page which is existing.

Regards,
Rakesh.M

What does this have to do with Data Manager?

MF.


Sent from my iPad using Tapatalk HD
Meep!

rakesh.java

This is another requirement i got related to cognos connection.Existing logon page contains Namespace,userid,password but i want to add one link when we entered wrong credentials to logon page.

Regards,
Rakesh

MFGF

Quote from: rakesh.java on 25 Aug 2014 09:53:55 AM
This is another requirement i got related to cognos connection.Existing logon page contains Namespace,userid,password but i want to add one link when we entered wrong credentials to logon page.

Regards,
Rakesh

So it's a Cognos Connection question? Why have you tagged it onto the end of a thread covering a different topic in the Data Manager section? Start a new thread in the Cognos Connection section.

MF.
Meep!

rakesh.java

Hi,

I implemented custom java name space and is working fine. But I have a query is that as if I click on  Test (Cognosconfiguration->Security->Authentication->customnamespace->Test) of cognos configuration, what is happening backend I need to know hence I can add custom functionality. Can any one please guide.

Regards,
Rakesh

MFGF

Quote from: rakesh.java on 16 Dec 2016 04:48:02 AM
Hi,

I implemented custom java name space and is working fine. But I have a query is that as if I click on  Test (Cognosconfiguration->Security->Authentication->customnamespace->Test) of cognos configuration, what is happening backend I need to know hence I can add custom functionality. Can any one please guide.

Regards,
Rakesh

Hi,

What relation does this question have to Data Manager? Is there a reason you have tagged it onto the end of a two year old post in the Data Manager section of the forum?

MF.
Meep!