DB view creation on outsystems SQL database
Question

We have a requirement to create a view on production outsystems DB server this view will be accessible from a external system.

Before proceed, please help us understanding below

Is it recommended to create view on outsystems database ?
If Yes, will there be any impact on view during platform upgrade or any other operation?

Hi Ajay,

I think the recommended way would be to develop with available OutSystems tools, such as exposing a REST API for the external system. Is this not possible in your case?

Do you have direct access to your OutSystems DB? It might give a hard time in the future to maintain an SQL View (or anything that is not directly accessible via OutSystems really), especially if the platform is on cloud.

Hi Ajay Ghosh,
My name is Cristian, And I am helping in the forum with the intention of becoming an MVP, your like helps me a lot and even better if I manage to solve your issue.

Not recommended to expose a database, the server should expose the data through services.


Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.