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

[Jacques-Antoine]

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

[Former Member]

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

[Former Member]

Hi Jacques,

Yes as Will said, I don't think this feature what you have highlighted is not having anything to do with.

You will be having the REST API's which you have to consume in SDK to read the data from the given SQL table.

Regards

Hanu K

[Jacques-Antoine]

Thank you for your answers!

at Will Godsall and Hanumath K

     I might not understand very well what you mean by REST API as I am not an expert of SQL servers.

The REST APIs are out of the box with any SQL server database?

Or do we need the Integration services to be installed?

I am missing something here that would allow me to understand the end to end process.

To come back on the functionality in the SDK to connect to a SQL server.

     I understand this is a standard Visual Studio feature, however I would like to leverage it in order to query the SQL server directly from the SAP cloud App Studio, and if possible, use the SQL results in my ABSL code.

Not sure it is possible though.

Thank you very much for your help!

Best regards.

Jacques-Antoine Ollier

[Former Member]

Hi Jacques,

Yes SQL data base has to be enabled to provide the REST API's with method GET to read the details from the DB and the read response has to be parsed for accessing the required field details and those details have to be written back to BO using ABSL.

Hope this clarifies

Regards

Hanu K

[Former Member]

Hi Jacques,

There is an official plugin provided by MySQL however its only meant for testing purposes

http://labs.mysql.com/ and select MySQL HTTP Server (make sure you check the versions).

Or you could use an open source variants such as

https://github.com/alixaxel/ArrestDB

GitHub - mevdschee/php-crud-api: Single file PHP script that adds a REST API to a SQL database

If you do use any of these make sure they are secure!

Kind Regards,

Will