Hi Hachemi
Is you SQL Server DB on prem? If so, you will probably need to set up a Secure Gateway, to be able to connect Cognos Cloud to SQL on prem.
Go to Manage > Secure Gateways. But first read this to check how to do that:
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ag_manage.doc/c_ca_manage_secure_gateway_installing.htmlOnce you have a secure gateway connection to the SQL Server, you can go to Manage > Data Server Connection and add a SQL connection. Here is an example connection string that we have setup: jdbc:sqlserver://HELLO-PC:1433;Database=NPC2;
Hope that helps
------------------------------
Heather Staniland
------------------------------
Original Message:
Sent: Fri March 26, 2021 02:58 PM
From: HACHEMI HAMED
Subject: Cognos on cloud
Thank you very much for the answers, I also wante to know why I was unable to connect to a sql server database? Thank you
Original Message:
Sent: 3/26/2021 1:31:00 PM
From: Heather Staniland
Subject: RE: Cognos on cloud
Hi
With the Standard license, you can create Dashboards which include all sorts of visualisations, connect to many data sources, upload flat files, create data models.
Quite a bit. What do you need to be able to do?
------------------------------
Heather Staniland
Original Message:
Sent: Fri March 26, 2021 12:29 PM
From: HACHEMI HAMED
Subject: Cognos on cloud
Hi, Thank you for your reply, this is what I bought: IBM Cognos Analytics on Cloud Standard Authorized User per Month.
I can't do nothing with this,
I played 17,80 € for nothing,
Original Message:
Sent: 3/26/2021 2:47:00 AM
From: Peter D'Haeyer
Subject: RE: Cognos on cloud
Hi,
I assume you are talking about Cognos on Demand? In this case, it depends on the license subscription you have choosen ( which you can change at all time). Only premium covers the reporting feature. in all cases you will not have the legacy "administration console" the admin options are limited to what is available under "manage" ( note that this is a SaaS service and IBM take care of most admin tasks)
hope this clarifies
Peter
------------------------------
Peter D'Haeyer
Original Message:
Sent: Thu March 25, 2021 05:01 PM
From: HACHEMI HAMED
Subject: Cognos on cloud
I purchased Cognos on cloud a week ago, but I have a problem with the Cognos login interface, I cannot find the new "Report" feature, nor the "administration consol" in "manage". i wrote an IBM but it didn't fix the problem. someone a slvp solution? thank you
#CognosAnalyticswithWatson