Cognos - Connections

Cognos – Connections

You’ll be able to report interactive consumer stories in Cognos Studio on the highest of varied knowledge sources by creating relational and OLAP connections in internet administration interface that are later used for knowledge modeling in Framework Supervisor generally known as packages. All of the stories and dashboards which are created in Cognos Studio they’re revealed to Cognos Connection and portal for distribution. The report studio can be utilized to run the advanced report and to view the Enterprise Intelligence info or this will also be accessed from completely different portals the place they’re revealed.

Cognos Connections are used to entry stories, queries, evaluation, and packages. They will also be used to create report shortcuts, URLs and pages and to arrange entries they usually will also be custom-made for different use.

Connections

Connecting Totally different Knowledge Sources

A knowledge supply defines the bodily connection to a database and completely different connection parameters like connection outing, location of database, and so forth. A knowledge supply connection accommodates credential and signal on info. You’ll be able to create a brand new database connection or can even edit an current knowledge supply connection.

You may also mix a number of knowledge supply connections and create packages and revealed them utilizing Framework supervisor.

Dynamic Question Mode

The dynamic question mode is used to supply communication to knowledge supply utilizing XMLA/Java connections. To connect with the Relation database, you should use type4 JDBC connection which converts JDBC calls into vendor particular format. It offers improved efficiency over sort 2 drivers as a result of there isn’t any have to convert calls to ODBC or database API. Dynamic question mode in Cognos connection can assist the next forms of Relational databases −

  • Microsoft SQL Server
  • Oracle
  • IBM DB2
  • Teradata
  • Netezza

To assist OLAP knowledge sources, Java/XMLA connectivity offers optimized and enhanced MDX for various OLAP variations and know-how. The Dynamic question mode in Cognos can be utilized with the next OLAP knowledge sources −

  • SAP Enterprise Data Warehouse (SAP BW)
  • Oracle Essbase
  • Microsoft Evaluation Providers
  • IBM Cognos TM1
  • IBM Cognos Actual-time Monitoring

DB2 Knowledge Sources

The DB2 connection sort are used to hook up with DB2 Home windows, Unix and Linux, Db2 zOS, and so forth.

The frequent connection parameters utilized in DB2 knowledge supply consists of −

  • Database Title
  • Timeouts
  • Signon
  • DB2 join string
  • Collation Sequence

Making a Knowledge Supply Connection in IBM Cognos

To create fashions in IBM Cognos Framework Supervisor, there’s a have to create a knowledge supply connection. When defining the info supply connection, you might want to enter the connection parameters – location of database, timeout interval, Signal-on, and so forth.

In IBM Cognos Connection → click on on the Launch IBM Cognos Administration

IBM Cognos Administration

Within the Configuration tab, click on Knowledge Supply Connections. On this window, navigate to the New Knowledge Supply button.

Configuration

 

Data Source Connections

Enter the distinctive connection identify and outline.

New Data Source

You’ll be able to add an outline associated to the info supply to uniquely determine the connection and click on the following button.

New Data Source Wizard

Choose the kind of connection from the drop down listing and click on on the following button as proven within the following screenshot.

Type of Connection

Within the subsequent display that seems, enter the connection particulars as proven within the following screenshot.

Connection Details

You need to use the Check connection to check the connectivity to the info supply utilizing connection parameters that you’ve got outlined. Click on on the end button as soon as executed.

Knowledge Supply Safety Setup

Knowledge Supply Safety may be outlined utilizing IBM Cognos authentication. As per the info supply, several types of authentication may be configured within the Cognos connection −

No Authentication − This permits login to the info supply with out utilizing any sign-on credentials. This sort of connection doesn’t present knowledge supply safety in connection.

IBM Cognos Software program Service Credential − In the sort of a sign-on, you log in to the info supply utilizing a logon specified for the IBM Cognos Service and the consumer doesn’t require a separate database sign-on. In a dwell atmosphere, it’s advisable to make use of particular person database signal on.

Exterior Title Area − It requires the identical BI logon credentials which are used to authenticate the exterior authentication namespace. The consumer should be logged into the identify house earlier than logging in to the info supply and it ought to be lively.

Signons

All the info sources additionally assist knowledge supply sign-on outlined for everybody within the group or for particular person customers, group or roles. If the info supply requires a knowledge supply sign-on, however you do not have the entry to a sign-on for this knowledge supply, you’ll be prompted to go online every time you entry the info supply.

IBM Cognos additionally helps safety at dice stage. In case you are utilizing cubes, safety could also be set on the dice stage. For Microsoft Evaluation Service, safety is outlined on the dice stage roles.