Blog

What's happening? What's new? What can I do? Find answers to these questions in the blog.

Archive Results

Blog

Administration: How to setup a Generic OpenID Namespace against Auth0 with Cognos Analytics 11

The purpose of this blog is to extend the capabilities of the number of supported OpenID Connect Providers with Cognos Analytics to now include the Generic OpenID Identity Provider. This allows the ability to “customize” the configuration based on the Identity Provider of choice not listed. Here we have a real lab example of configuring a Generic OpenID against Auth0: Environment: Windows 2016 Single Installation Cognos Analytics 11.0.11+ Identity Provider: Auth0 Section 1: Steps to creating and configuring an Auth0 application: 1. Create an Auth0 Application by clicking on “CREATE APPLICATION” button 2. Give the application a name e.g. IBMSUPPORT in this case 3. Click on the “Settings” where the ClientID, Client Secret are shown: 4. Scroll down to “Allowed Callback URLs” and add the Cognos Analytics URL 5. Click Save 6. Access the https://manage.auth0.com/#/tenant 7. Set the “Default Directory” to “Username-Password-Authentication” and click “Save” Section 2: Collect all the information required and create a Generic Namespace The following information is required: ClientID Client Secret Redirect URL 8. Download the Issuer Certificate by accessing http://auth0.com   9. Save and transfer over to the Cognos Analytics <install>/bin64 directory 10. Import the certificate using the following command line: <install>\bin>ThirdPartyCertificateTool.bat -i -T -r <certificate> -p NoPassWordSet 11. Launch Cognos Configuration and create a new Generic Namespace:     12. Update only the following details Customize from default values and the following are only required in this case: Discovery Endpoint URL Scope for Authorized Endpoints (default is openid): openid profile email name given_name family_name offline_access Password Grant – Strategy: UserInfo endpoint Username: nickname NB: The settings required for a Generic Template may vary depending on the IdP (Id Provider) and the supported Grant Types and Claims. Also ensuring all URI’s are SSL enabled i.e. switch from http to httpS including the redirect url. 13. Test the Connection   When the “Testing ‘IBMSUPPORT’ namespace” is successful then the imported certificate is trusted. However, the userID/password to test the connection may fail with Status 403 error. To resolve this, disable the “OIDC Conformant” setting as follows: 14. Application - <Application> - Advanced Settings – Oath and Disable the “OIDC Conformant”   15. From that same page select “Grant Types” and unselect “Client Credentials” and select “Passwords” 16. Now, test the connection again and it should succeed 17. Save and start the CA Service 18. Select the Generic Namespace which redirects to the Auth0 Log-In Page:   19. Log in using your email address and then it will redirect back to CA and login seamlessly:   Optional: Check the Namespace is active (IBMSUPPORT) from Manage – Administration - Security Additional Information Create Additional Users: From the Dashboard Select “Users” and then “CREATE USER” button Populate the Email, Password and Repeat Password fields. References: Auth0 Documentation Cognos Analytics OpenID Connect authentication providers Other OpenID Blogs Administration: How to setup #Cognos Analytics OpenID Authentication Proxy federating with Active Directory and LDAP over AD Administration : How to setup ADFS OIDC with #Cognos Analytics Release R9+ Administration: How to setup and authenticate via OIDC OKTA integration with AD on-premise and Cognos Analytics 11 R9+ Administration – How to Setup OpenID Connect using OKTA Identity Provider with #Cognos Analytics Release 8+  

Blog

How to connect #Cognos Analytics to DashDB on IBM Cloud

The purpose of this blog is to demonstrate the capabilities of connecting an on premise instance of  Cognos Analytics to  a cloud-based database service instance hosted on IBM Cloud. This is a great environment for testing purposes and provides insight into Cognos Analytics full capabilities against IBM DB2 Warehouse on Cloud for Analytics. The following are the actual steps taken to get this working using your free IBM Cloud account. To setup a free account go to https://console.eu-gb.bluemix.net and sign up. Environment: Cognos Analytics Server 11 Video: Steps: Create a Test DashDB instance: Create a IBM Cloud account and log in, then select "Services" and click on "Db2 Warehouse". 2. Then give the Service a unique name and click on the "Create" button. 3. Once the service has been created the following page will be displayed: Create the credentials: 4. Next, click the service that has been created and  click on “Service credentials” then “New credential”. 5. Next, give the credential label a name and click “Add”. 6. This will generate a json document with all the connection and signon details. You can see entries for an SSL connection string  "ssljdbcurl" and a non SSL connection string  "jdbcurl" as well as Port and password information. Download and Install the JDBC driver: 7. The next stage is to download/install the drivers. From the console click on “Manage” and then click on “Open”. 8. Click on the “Download” section and download the drivers based on the OS platform. 9. In this case, since CA 11  is on Windows 2016, download the “Driver Package for Windows 64-bit” and install on the CA 11 Server. The next section is specific to setting up the CA 11  Datasource Connection to IBM DB2 Warehouse on Cloud From the Driver Package installation locate the JDBC Driver (<installation>\IBM DATA SERVER DRIVER\java\db2jdbc4.jar) Copy this over to the CA 11 R6 /drivers directory (<installation>\ibm\cognos\analytics\drivers) Restart the Cognos Analytics service. Creating the Dynamic Datasource using the JDBC Driver Information In Cognos Analytics: 10. Login to Cognos Analytics and select “Manage” – “Administration Console” – “Configuration” – “Datasources”. 11. Create a new JDBC Type Datasource Connection. 12. With regards to the signon, use the credentials as generated in the JSON document above. 13. Test the connection, then go to the properties of the datasource and enable the “Allow web-based modeling” option so it’s visible in CA11. 14. You can now create a new Framework Manager Model, import the datasource and the table(s) and publish a package.   Please visit the IBM Cognos Analytics channel on YouTube.  

Blog

Video: How to import the samples deployment (11.0.6+)

This video will show you how to find and import the Base sample content (e.g. reports, dashboards, stories, data) from a deployment file. Instructions for installing the Extended samples and restoring the sample Great Outdoors database are available here. Related posts: IBM Knowledge Center: Four categories of Cognos samples Library of How-To Videos for IBM Cognos Analytics Samples Landing Page How to import the samples deployment (11.0.4 - 11.0.5) Please visit our IBM Business Analytics Support channel on YouTube.

Blog

Video: How to add a new data server connection (11.0.6+)

Welcome to our video on how to add a new data server connection in IBM Cognos Analytics 11.0.6+. A data server connection specifies the parameters that are needed to connect to the database that the connection represents. In this demo, we will show you how to create a new Microsoft SQL Server data server connection. The same general procedure applies to all of the other types of data server connections as well. Related posts: IBM Knowledge Center: Four categories of Cognos samples Library of How-To Videos for IBM Cognos Analytics Samples Landing Page Please visit our IBM Cognos Analytics channel on YouTube.

Blog

Video: How to import the samples deployment (11.0.4 - 11.0.5)

This video will show you how to import sample data, reports, and dashboards from a deployment file. Related posts: IBM Knowledge Center: Four categories of Cognos samples Library of How-To Videos for IBM Cognos Analytics Samples Landing Page How to import the samples deployment (11.0.6+) Please visit our IBM Business Analytics Support channel on YouTube.

Blog

Video: How to add a data server to connect to a Microsoft SQL Server database in #Cognos #Analytics

This video will show you how to add a data server to connect to a Microsoft SQL Server database. You can download the associated step-by-step instructions here in PDF format. Please visit our IBM Cognos Analytics channel on YouTube.

Blog

Video: How to add a data server to connect to an Oracle database in #Cognos #Analytics

This video will show you how to add a data server to connect to an Oracle database. You can download the associated step-by-step instructions here in PDF format. Please visit our IBM Cognos Analytics channel on YouTube.

Blog

Video: How to add a data server to connect to an IBM DB2 database in #Cognos #Analytics

This video will show you how to add a data server to connect to an IBM DB2 database. You can download the associated step-by-step instructions here in PDF format. Please visit our IBM Cognos Analytics channel on YouTube.