Hi,
I'm new to outSystems. I want to do hands-on on connecting an external database. I tried using local database but seems it is not a possibility. Is their a way I can create a SQL Server like standalone database in outsystems, don't want to go thru Azure/AWS, and then connect it as an external database into my project?
Also, how does OutSystems will connect to my on-premise database? DO I need to do any special settings/installation? Also, cannot import my existing database to OutSystems because company prefers to keep the database on-premise.
thanks,
Shreyash
Shreyash Maheshwari wrote:
You will need the database connection properties, and it has to be visible to OS environment.
After that you have to do some steps so you can use the tables in the module.
See this step by step guide : https://success.outsystems.com/Documentation/11/Extensibility_and_Integration/Integrate_with_an_External_Database
Hi Shreyash,
Welcome to OutSystems!
One question. Are you using your personal environment for this? If so, I suggest you read through this post to get answer about connecting to a local database.
For an On-Premises installation of the OutSystems platform, you are required to have separate Database server to which you connect your application server(s). Check out this setup guide for On-Premises infrastructures.
And last, you also have an option to integrate with an External Database with OutSystems. Here’s detailed article on how to set this up. And here’s a demo on how to integrate with a SQL Server Database.
Hope this information helps!
Regards,
Nordin
Just a quick note.
You mentioned that you want to keep the DB on-premises so I assume your OutSystems is in the cloud. Pedro says that "database must be visible". Please don't read it has "database has to be public". For security purposes, a VPN should be set between the OS cloud and your infrastructure.
Here's another link: Set Up a VPN to your OutSystems Cloud. There is even a topic in troubleshooting for databases.
Nuno Reis wrote:
If I have to use my local machine (localhost) database, then is their a way to use it?
I see only two options:
Thanks!
Is their a minified version I can deploy (on-premises installation) on my personal machine or some kind of local connector which I can use to connect to my local sql server instance which will facilitate the limited but same type of functionality as service center?
Not currently. There used to be Community Edition that you could install anywhere, but it was replaced by the Personal Enterprise that is less limited but exclusively online.