Skip to Content
author's profile photo Former Member
Former Member

How to connect SAP BusinessObjects cloud to SQL databases

Hi there

Has anyone ever connected SAP BusinessObjects cloud to SQL databases, if so please can you post a step by step screenshots to what needs to be done/configured, as I have tried by following the SAP BusinessObjects cloud help guide, however the help guide is not useful with regards to this issue.

Any suggestions?

*NB please note I have already configured my C4A_AGENT on SAP BusinessObjects Cloud to acquire data from SAP universe and this works, however I would like it to connect to SQL databases

See error returned on screenshot attached.

1.JPG (52.5 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Jul 13, 2016 at 03:26 PM

    Hi Peter,

    Your agent should be correctly installed as you can connect to universes.

    You need to complete the following steps indicated in the guide to connect to SQL databases:

    SAP BusinessObjects Cloud Help

    1. Download and install JDBC drivers

    2. Create the .properties file to specify the path for the drivers

    3. Restart the agent with the java option

    -DSAP_CLOUD_AGENT_PROPERTIES_PATH

    Regards,
    Julian

    Add a comment
    10|10000 characters needed characters exceeded

    • Hello John,

      I got another update from my resources and found that this issue is also fixed in version 1.0.58, which is coming out soon, where you'll not need JCO driver to be installed for MS SQL.

      So, if you'd like you can wait till new version is released or for now, just bypass the error by installing JCO drive.

      Thanks

      Raman

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.