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.