Skip to Content

How-to connect to a SQL server from SAP Cloud App Studio?

Dear SCN community,

I am working on a project where I need to extract data from many SQL servers and integrate them into Cloud for Customer.

I want to make the solution as easy as possible.

In this goal, I found the option in the SAP Cloud App Studio to connect to a server or a database (cf screenshot).

However, I am trying every settings possible but none are making the connection works. I alwasy get an error that the instance cannot be retrieved, even if I am working directly with the database's IP.

To be noticed, I have no MDF file, I just want to connect directly to the remote SQL server from the SAP Cloud App Studio.

This might be possible as I found another option when you right click on the Database symbol in the Server Explorer window. However, this option is greyed out (cf screenshot).

Connecting directly to the SQL server from the SDK have many advantages as I could consume the objects from my query results and not bother with the exchange of files or dumping files on the webDAV.

If somebody already did connect a SQL server to the SDK, any hint on this would be greatly appreciated.

Thank you very much for your attention.

Best regards.

Jacques-Antoine Ollier

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Mar 30, 2016 at 08:17 AM

    Hi,

    I might be wrong but I believe the feature you are using is a standard Visual Studio feature and has nothing to do with the SDK.

    There are plugins/addons for MySQL which would allow you to access it using a REST API. There might be a few security issues if you fail to set it up correctly however.

    Kind Regards,

    Will

    Add comment
    10|10000 characters needed characters exceeded