Hi,

I am new to outsystems. I am trying to create database connection to my local sql server database.

My local sql db is configured for windows authentication.

How can we create DB connection in Outsystems environment

Hi Raj,

Welcome to OutSystems! With "local" you mean "on my development computer"? The OutSystems software runs on a server, either in the cloud or on-premise. If you want to connect to a database running on your pc, that server must be able to access it. Note this might create a security problem.

Also, in what way do you want to connect to it? There are tables in the database you want to access? In that case, you'll also need to expose those via Integration Studio.

Hi Raj,

I think you can't access data base which has been configured in your local windows machine. 

Since when you open your personal environment it connects to your cloud environment. The outsystems service studio working in your windows machine it doesn't mean it is connected to your local windows machine.

If you want  connect to data base which external to your OS cloud application. Please look into below link it may helps you.

https://success.outsystems.com/Documentation/10/Extensibility_and_Integration/Integrate_with_an_External_Database


Thanks 

Ramakrushna Rao Seera

I am also facing same issue. I have 10+ years of experience in Dotnet. This means I can't practice outsystem if i don't have any Database on cloud. Don't you think this is pretty unfair. A developer is trying to get familiar with outsystem and he can't simply use his localhost sql server database.

According to the replies I found that even for learning purpose I need to spend money on purchasing database on cloud.... I that can it's better to leave it and I am pretty ok with Visual studio and will spend my valuable time in learning new releases on Visual studio

Hello Kamalpreet, welcome to the OutSystems forum.

When you created your account in OutSystems, you enabled the possibility to have a Personal Environment (without any cost). Just login in outsystems.com and ask for your personal environment.


You also wants to check here: https://medium.com/@marcoarede/start-outsystems-in-5-steps-9b8c5d1e589a

You will get your personal environment with its own database to start learning to use OutSystems (I recommend the Web Path here).

You may want to take a look in the OutSystems overview, also.

Happy coding!