Hi,
I want to connect the AWS RDS (Sql Server) with the Outsystems. What are the Step wise Process?
What are the prerequisite in AWS side and steps from AWS side?
Thanks.
Hi Rohan,
The next document would be a starting point:
https://success.outsystems.com/Documentation/11/Extensibility_and_Integration/Integrate_with_an_External_Database
There is also an instruction video:
https://www.outsystems.com/learn/lesson/1847/demo-integrating-with-external-databases/
Regards,
Daniel
Daniël Kuhlmann wrote:
Hi Daniel,
I got that it can be possible by service Center configuring external Database. But my concern is that what would be the value for "Server" input in this case?
Thanks.....
Rohan Hanumante wrote:
HI,
I am also facing the same problem. I created RDS and create the instance of SQL Server, mention the server name in "outsystems" but it is not connected.
Please give me the solution if you get it.
Read the amazon documenation:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ConnectToMicrosoftSQLServerInstance.html
On the connectivity/security tab is the enpoint (server) and port.
I am having the same issue.
AWS documentation is pretty clear and I have used it to attach other tools to my AWS RDS-SQL Server.
The issue seems to be that AWS shares an Endpoint and a Port, and of course their is a database name.
I entered the Endpoint into the "Server" field and the database into the database field and it won't attach. It just spins.
Is the Server truly exactly the Endpoint? Or the Endpoint plus the port? If so, is there a format to follow for the port?
Thanks for any assistance.
Thanks
Hi Rohan Hanumante,
Here is the step-by-step checklist to connect AWS RDS to OutSystems:
AWS Side Prerequisites:
Publicly Accessible: Go to RDS > Connectivity & security. Ensure 'Publicly accessible' is set to Yes.
Security Group (Firewall): Click on the VPC Security Group. Add an Inbound Rule for MSSQL (Port 1433) allowing the IP of your OutSystems environment (or 0.0.0.0/0 for testing).
Create User Database: AWS RDS SQL Server only has system databases (master, model...) by default. You must connect via a client tool (like SSMS) first and run CREATE DATABASE YourDBName;.
OutSystems Side:
Server/Host: Use the AWS Endpoint (e.g., mydb.xxx.rds.amazonaws.com).
Database Name: Enter YourDBName (created in step 3), do not use the RDS Instance ID.
User/Password: Use the credentials created during RDS setup.
Regards