Rally Software

Expand all | Collapse all

Unable to connect to CA Agile Central from Excel

  • 1.  Unable to connect to CA Agile Central from Excel

     
    Posted 04-05-2017 08:29 AM

    I have installed agile central plugin to import and export data from excel

    After providing CA Agile central details and Unable to connect to CA Agile Central from Excel

    Refer below attachment

     



  • 2.  Re: Unable to connect to CA Agile Central from Excel

    Posted 04-05-2017 11:17 AM

    Hi Ahmed;

     

    Unless you intentionally obfuscated the username in your screenshot it doesn't look like you're entering a complete Agile Central username. Your username would generally be your account email address and I don't see an email domain specified in the username field. You might want to confirm that you're entering the username and password in the exact format in which you enter them in Agile Central.

     

    Also, if you normally use SSO and you're not a whitelisted exception user then you need to use SSO in the Excel Add-In as well. Instructions on that are at CA Agile Central Add-in for Excel Installation & User Guide | CA Agile Central Help . Hope that helps.

     

    -Eric Nash



  • 3.  Re: Unable to connect to CA Agile Central from Excel

     
    Posted 04-06-2017 02:55 AM

    Hi Eric,

     

    I provided user name as ahmmo05@ca.com, provided the password but still facing same issue.

     

    Regards

    Irfan



  • 4.  Re: Unable to connect to CA Agile Central from Excel

    Posted 04-06-2017 03:05 AM

    Mohammed,

     

    The CA Agile Central Subscription uses SSO for Authentication.  You will need to select the Single Sign-On (SSO) option to connect and use an updated URL as described in the document Eric linked.  I'll open a case for you and we'll send the specific URL for CA.

     

    Michael



  • 5.  Re: Unable to connect to CA Agile Central from Excel

     
    Posted 04-06-2017 04:50 AM

    Hi Michael,

     

    I am able to connect Rally from excel using the following URL:

    https://sso.rallydev.com/sp/startSSO.ping?PartnerIdpId=samlgwsm.ca.com&TargetResource=https://rally1.rallydev.com/slm/j_sso_security_check?noRedirect=true

     

    Thanks for the help.

    Regards

    Irfan



  • 6.  Re: Unable to connect to CA Agile Central from Excel

    Posted 04-10-2019 03:27 PM

    Hi Eric, 

    I am trying to connect excel it mentions sso handshake sucessfull , relaystate was not set.



  • 7.  Re: Unable to connect to CA Agile Central from Excel

    Posted 04-10-2019 03:58 PM

    Hi Afroze,

     

    You will need to change the URL to be:

     

    - Your subscription's SSO url , concatenated with this:

    &TargetResource=https://rally1.rallydev.com/slm/j_sso_security_check?noRedirect=true

     

    So, for example if your subscription's SSO url is: "https://myssourl.com" then your URL for that text box should be: https://myssourl.com&TargetResource=https://rally1.rallydev.com/slm/j_sso_security_check?noRedirect=true

     

    I prefer not to write your actual subscription's SSO URL here cause it's a public page and visible to everyone in this community. You can contact your sub-admins to find it, or otherwise open up a support case with us and we'll provide it to you.

     

    Thanks,

    Sagi