Cognos Data Manager SQL Node

Cognos Data Manager SQL Node

Cognos Data Manager SQL Node is only available in Cognos Data Manager Job Stream. It is used to execute database query inside a Job Stream.

Follow below steps to add a SQL node inside a Job Stream.

  • Right Click on Job Stream in which you want to add SQL node and click on Insert Node and select SQL Node.
  • Provide appropriate Business name and Description in General tab.
  • Click on SQL tab, first select database from Database drop down (if no connection is available click on New button to create a new database connection. For more details how to create a connection refer this link.) and add following SQL Query "SELECT 'Hello World !!!';". Click on SQL Helper. In SQL Helper windows select play icon to execute your SQL Query. If your query executed successfully click on OK to close SQL Helper.
  • Select Predecessors tab. Select the node which is going to execute before this SQL node.
  • Click on Successor tab and check the check box which is going to execute after this SQL node. If the SQL Node is last to execute do not check anything.
  • Click on OK to save the changes. 

In above example we created a SQL node which is used to execute SELECT 'Hello Wolrd !!!' command in a SQL server Database.

Still facing any issue feel free to post a comment.

Leave A Comment

Please login to post your valuable comments.

Join the newsletter

Get the latest vLemonn news first