Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only

  • 1.  Connecting to Microsoft SQL server

    Posted 04/27/20 10:30 AM
    Hello everybody, 
    I have an issue creating a new Data Source using Microsoft SQL Server. I have found some tutorials that tell to copy JDBC to certain Cognos folder. I am only using the Cognos Analytics in browser though. 
    The server itself is on my own machine and I am not sure I am using the right JDBC URL.

    Is anybody able to help me with my issue?

    Thank you very much!


    ------------------------------
    Matěj Bischof
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Connecting to Microsoft SQL server

    Posted 04/28/20 03:19 AM
    Hi, try to use Microsoft SQL Server (ODBC). also please save on (C:\Program Files\ibm\cognos\analytics\drivers) the sqljdbc42.jar file. Then fill in the JDBC as shown bellow. 



    ------------------------------
    Stoyka Bojkova
    ------------------------------



  • 3.  RE: Connecting to Microsoft SQL server

    Posted 01/10/24 08:35 AM

    Hi,
    How can i conect with if i dont have software cognos?

    I use in google chrome.



    ------------------------------
    Andrei Andrade
    ------------------------------

    Original Message


  • 4.  RE: Connecting to Microsoft SQL server

    Posted 01/10/24 08:35 AM

    Hi,

    How can i conect in cognos 12 in google chrome?

    Can you help me?



    ------------------------------
    Andrei Andrade
    ------------------------------

    Original Message


  • 5.  RE: Connecting to Microsoft SQL server

    Posted 01/10/24 09:01 AM

    Hi Andrei,

    if you have the appropriate rights in Cognos, you have to go to "Manage" in the hamburger menu:

    Then hit "Data server connections":

    A new UI will open where you can add net data servers. Choose the MS SQL connection type, hit "Next" and enter all connection details for your server.



    ------------------------------
    Robert Dostal
    Team Leader BI
    GEMÜ
    Ingelfingen
    ------------------------------

    Original Message


  • 6.  RE: Connecting to Microsoft SQL server

    Posted 04/29/20 08:57 AM
    Hi Matěj

    Did you copy the JDBC file into the /drivers folder and restart the Cognos service? You should get that file from the DBA if possible, they should know which one you require.

    If you did the steps above, what is the issue you are encountering?

    ------------------------------
    TREVOR COMEAU
    ------------------------------