Cognos Analytics with Watson

How to setup Cloud Object Storage and Amazon S3 Buckets with CA 11.1.5

By ANTONIO MARZIANO posted Wed December 25, 2019 05:34 PM

  
With the release of Cognos Analytics 11.1.5 comes with a new feature that provides the Save to Cloud capability for saving report outputs to both IBM Cloud Object Storage and Amazon S3 Buckets.  The purpose of this article is to provide a "step-by-step" guide to setting up a Cloud Connection to both IBM Cloud Object Storage as well as Amazon S3.

Lab Environment:

Windows 2016
AWS Subscription
IBM Cloud Lite Subscription
CA 11.1.5

IBM Cloud Object Storage

1. Firstly, log into IBM Cloud and create a new “Resource”

2019-12-25_21-01-49.png

2. Click on “Storage” and then click on “Object Storage tile

2019-12-25_21-03-39.png
3. Click on the “Lite” plan and then scroll down and provide a Service Name e.g. “Cloud Object Store-CA” and the click “Create”

2019-12-25_21-05-38.png

4. Click on Service credentials

2019-12-25_21-07-12.png
5. Click on “New credential”

2019-12-25_21-08-38.png

6. Give the credential a name and click “Add”

2019-12-25_21-10-00.png

7. Expand the “View Credential” to see the information in json format

2019-12-25_21-11-38.png
8. Create a bucket

2019-12-25_21-12-32.png

2019-12-25_21-13-47.png

9. Now, in order to create a Cloud Objectstore Connection, you need the following:

2019-12-25_21-15-09.png
10. Log into CA and go to Manage – Storage

2019-12-25_21-17-39.png

2019-12-25_21-18-36.png
11. Click on “Create connection”

2019-12-25_21-20-04.png12. The ‘Access key ID’ is the ‘apikey’ value and the ‘Secret access key’ is the ‘resource_instance id’ value

2019-12-25_21-21-32.png

2019-12-25_21-22-33.png

13. Click “Create and continue”

2019-12-25_21-23-59.png
14. Test the connection and click “Finish”

2019-12-25_21-25-32.png
Setup the Delivery Output to Save to Cloud


2019-12-25_21-27-10.png

15. Trusted Credentials will be generated so click on "Renew"

2019-12-25_21-33-03.png

Once Schedule is completed the report outputs are visible

2019-12-25_21-34-09.png

Amazon S3 Buckets


Steps are as follows:

1. Log into the Amazon Management Console using the root user account
2. From Services/Resources select IAM
3. Create a new user

2019-12-25_21-40-02.png

4. Create a new Group to add the user to it

2019-12-25_21-42-25.png
5. Select the AmazonS3FullAccess Policy

2019-12-25_21-43-52.png

6. Complete and select "Create User"

2019-12-25_21-46-14.png

7. Grab the Access Key ID and Secret access key ID which will be used to create the Cloud Storage Connection in CA by downloading the csv file or from the information displayed.

2019-12-25_21-48-27.png

8. Create an S3 Bucket by selecting Resources / Storage / S3

2019-12-25_21-51-35.png
2019-12-25_21-52-46.png
2019-12-25_21-53-54.png
2019-12-25_21-54-51.png

4. Log into CA and Create a Cloud Object Storage Connection, select  Type "Amazon" and use the access ID keys from point 7 above to populate the connection information and then test the connection.

2019-12-25_21-56-47.png
2019-12-25_21-59-09.png


5. Set the Delivery Output for a report to "Save to Cloud"

2019-12-25_22-04-31.png
6. Once completed, check the S3 bucket for the saved outputs

2019-12-25_22-06-34.png

MINIO Object Storage Server

Minio is a very popular open-source object storage server which is compatible with Amazon S3 which can be hosted on a server rather than cloud. This is popular for those that want more control over the storage and also would not require any payment based subscription. Its seen like a "local" storage file system for saving report outputs in a similar way with storing on cloud.

The steps to set this up is as follows:

1. Download Minio from here : https://github.com/minio/minio
2. Extract the package and launch from its current working directory:

chmod +x minio
./minio server /data

3. The following information will be displayed:

2019-12-27_15-01-26.png

4. Launch the home page using http://x.x.x.x:9000
5. Grab the Access Key/Secret from the output above 'AccessKey' and 'SecretKey'

2019-12-27_15-12-37.png

6. This is the home page:

2020-02-05_11-05-06.png

7. Create a storage bucket by clicking on the red circle on the bottom right and then select create bucket e.g. cabucket:

2019-12-27_15-17-33.png

8. Enable Read/Write access to the bucket by clicking on the properties (3 vertical dots):

2019-12-27_15-24-46.png
Select "Edit policy"

2019-12-27_15-25-20.png
Select "Read and Write" and click on "Add"

2019-12-27_15-26-36.png

2019-12-27_15-27-46.png
2019-12-27_15-23-57.png

8. Now, log into CA and create a new Cloud Storage Connection (see steps above from S3/IBM Cloud Object Storage) by selecting "Other":

Details required are:
Access Keys
Server Endpoint (found in screen output from step 3 above)

2020-02-12_12-56-32.png
9. Click "Create and continue" and then follow the same steps as above to configure the task properties to save the report to the storage connection above.
On completion, check the storage page below and you will see the report output(s).

2020-02-12_13-03-17.png

This is a good option is you want to leverage the new feature but store the report outputs on a storage server rather than on a cloud storage.


Additional Information:

Release 11.1.5:
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ca_new.doc/c_ca_nf_11_1_5_container.html

Cognos Analytics Community Blog:
https://community.ibm.com/community/user/businessanalytics/communities/community-home/recent-community-blogs?communitykey=6b10df83-0b3c-4f92-8b1f-1fd80d0e7e58&tab=recentcommunityblogsdashboard


Amazon AWS:
https://aws.amazon.com/

IBM Cloud:
https://cloud.ibm.com

Minio ObjectStorage
https://github.com/minio/minio
#LearnCognosAnalytics
#home
#cloudstorage
#administration
1 comment
69 views

Permalink

Comments

Tue December 31, 2019 08:08 AM

Very Nice Information, I would like to read more blogs here. Please provide more cool stuff. Holi Wishes 2020Happy Holi Wishes 2020