Hi! I want to connect my app to a SQL database (in the end I want to use the SQL database to create a Power BI dashboard). So I don't want to import data from the SQL database into Outsystems, I just want to go the other way. Is this possible? If so, can I use a local SQL database?
Hi,
You can expose each entity as a Rest API, or SOAP Service, however, you'd have 2 copies of each table.
https://success.outsystems.com/documentation/11/extensibility_and_integration/integrate_with_an_external_database/integrate_with_an_external_database_using_integration_studio/
This tells you how to connect with external databases and what databases are allowed
Hello @edTheEngineer ,
thank you for your reply, I was able to connect to a SQL server in the cloud.
However, I am still not sure if it is possible to connect to a local server. I tried to connect but when I enter the information of my local server and click on "Test connection" Outsystems does nothing, I don't even get an error message. Do you have any idea why is that?
HiNever tried it, but from what I've read, appears difficult. I couldn't see it listed. The forum below implies you can but there are security implicationshttps://www.outsystems.com/forums/discussion/80163/connect-with-sql-server/
Hello,
thanks again for your answer. I didn't find this post - I think I'll just give up with the local connection for now. Anyway, I'm glad I was able to connect in the cloud.